Changing Payment Terms via SAP API

[dgamilong]

Changing Payment Terms via SAP API

We are trying to update the Payment Terms on a Sales Order via SAP B1IF XML without having the Price List, Price Source and Price data on the line items automatically change.

No matter how we try to update a Sales Order it will always update the Price List to the one related with the new Payment Terms, Price Source will be set to Active Price List and then due to these changes the pricing data is pulled from the new Price List. If a Payment Terms change is specified then everything else supplied around price lists and pricing is ignored.

What we are after is the exact same functionality as when selecting 'No' for the question "Do you want to update the existing table rows with the new price list?" when applying new Payment Terms to a Sales Order via the SAP B1 Client. Is this possible?

If you choose No on the system message it will ignore the Price List link to the Payment Terms - Setup. If yes, it will use the Price list on the Payment Terms – Setup.

Attached some XML examples:

• before.xml - Initial document state where all items have their PriceSource set to dpsManual with custom pricing.
• update.xml - Contains the update applied (also tried with the action updateDocWithSubDeletion which has the same issue).
• after.xml - Documents state after update (changes to line item Price List / Price Source).

Also some UI examples:

• before.png - Initial document state showing the manual price source and pricing.
• after.png - Document state after update.

SAP B1 Version is: SAP Business One 10.0 (10.00.200) FP 2208 (64-bit)

[Johan_Hakkesteegt]

Hi Darryl,

Have you set this setting?

Regards,

Johan