Your code won't work.  Record a VBA macro that does what you want, then convert that to C#.

Hey Jay,

Is that specific to the fields I am trying to access?

I am able to create orders with lots of other information with no issues, customers and so forth. However I am running into this issue when it comes to two specific fields on the Order Header and Order Details.

Thank you very much for your reply!

Record a VBA macro that does what you want, then convert that to C#.

I use the COM api in C# but the .NET API works fine for me too.

c# code for setting sales order on hold.

Are you missing the OEORD1header.Insert line?

_oeHeaderView.RecordClear();
_oeHeaderView.RecordCreate(tagViewRecordCreateEnum.VIEW_RECORD_CREATE_NOINSERT);

// set the customer

_oeHeaderView.Fields.FieldByName["ONHOLD"].set_Value("1");
_oeHeaderView.Fields.FieldByName["HOLDREASON"].set_Value("waiting for approval");
_oeHeaderView.Insert();

Hey Jay!

I figure out what you meant with recording a sequence of steps and seeing which fields are for what.

I got the On Hold working. Sadly, the Inline Discount Amount is not working as intended. "INVDISC" is for the amount according to the recorder. However, when using this field and sending a decimal, passing in "5.50" I get an error along the lines of "It must be greater than zero but less than extended amount". So when I send through ".55" it puts 55% into the Discount Percent field. And NOT the Discount Amount field like how the dang Macro Recorder says it's doing it.

To note, "DISCPER" is the field to edit the Discount Percent field. Is this a Sage SDK flaw? Or am I missing some more magic here.

We had a contractor doing an API integration last year from Sage to Magento, and here's how I told them to do complex discounting

We can't use amounts.  What makes things work is setting the "DiscountPercentage", both at header and detail levels. So, if the raw data has a discount amount, then the equivalent percentage amount would need to be calculated and sent.

Order Discount Payload:

This is an $1,800 dollar order. 2 items @ $1000 = $2,000 - 10% = 1800.
{
"CustomerNumber": "CUST1",
"ShipToName": "Joe Customer",
"ShipToAddressLine1": "100 Main Street",
"ShipViaCode": "BEST",
"OrderDate": "2022-05-26T01:26:22.000Z",
"OrderDiscountPercentage": 10,
"OrderDetails": [
{
"LineType": "Item",
"Item": "A1-103/0",
"QuantityOrdered": 1,
"OrderUnitOfMeasure": "EA",
"PricingUnitPrice": 1000.00,
"DiscountPercent": 0.00
},
{
"LineType": "Item",
"Item": "A1-103/1",
"QuantityOrdered": 1,
"OrderUnitOfMeasure": "EA",
"PricingUnitPrice": 1000.00,
"DiscountPercent": 0.00
}
]
}

Item Discount Payload:

This is a $1900 dollar order. One item is full price, the other is discounted:

{
"CustomerNumber": "CUST1",
"ShipToName": "Joe Customer",
"ShipToAddressLine1": "100 Main Street",
"ShipViaCode": "BEST",
"OrderDate": "2022-05-26T01:26:22.000Z",
"OrderDiscountPercentage": 0,
"OrderDetails": [
{
"LineType": "Item",
"Item": "A1-103/0",
"QuantityOrdered": 1,
"OrderUnitOfMeasure": "EA",
"PricingUnitPrice": 1000.00,
"DiscountPercent": 10.00
}
{
"LineType": "Item",
"Item": "A1-103/1",
"QuantityOrdered": 1,
"OrderUnitOfMeasure": "EA",
"PricingUnitPrice": 1000.00,
"DiscountPercent": 0.00
}
]
}

Order + Item Discount Payload:

This is a $1,710 dollar order. One item is full price, the other is discounted, then 10% is taken off the top.

{
"CustomerNumber": "CUST1",
"ShipToName": "Joe Customer",
"ShipToAddressLine1": "100 Main Street",
"ShipViaCode": "BEST",
"OrderDate": "2022-05-26T01:26:22.000Z",
"OrderDiscountPercentage": 10,
"OrderDetails": [
{
"LineType": "Item",
"Item": "A1-103/0",
"QuantityOrdered": 1,
"OrderUnitOfMeasure": "EA",
"PricingUnitPrice": 1000.00,
"DiscountPercent": 10.00
}
{
"LineType": "Item",
"Item": "A1-103/1",
"QuantityOrdered": 1,
"OrderUnitOfMeasure": "EA",
"PricingUnitPrice": 1000.00,
"DiscountPercent": 0.00
}
]
}