How to include shipping prices in an order data set?

[Former Member]

Where can I find examples or descriptions about shipping handling in orders?

I use successful the DI Server AddObject method to create an order and at this time I used the DocumentsAdditionalExpenses rows to add shipping price to the order, but on this way I do not have any reference to any configured shipping method like the ShippingMethod and ShipDate property in the Document_Lines rows.

If there any property in the Documents rows to define a general shipping method of the whole order and force the expenses calculation based on the SAP B1 configuration in this company database?

And then additional the similar issue with any Payment expenses...

Thank's for help and any suggestions

Heiko

[Former Member · Accepted solution]

As you noted, each line in an order has fields for shipping method, etc. The logistics "tab" in the UI has some logic behind it that updates the row info regarding shipping method if you change it.

For instance, if a customer has their shipping method defined as UPS in the BP master data, the order lines will have that selected by default. This can be seen if you add the shipping type field to the row by using Tools/Forms Settings. Now you can see the ship method is per row. if you change a coupld of rows to different shipping types and then change the shipping type on the logistics "tab" you are asked if you want to update the rows. I don't believe this logic can occur through the DI unless you replicate it.

When you add an order through the DI, I believe the lines will get the default shipping method that is assigned to the customer on the BP master screen. You will need to check this. Otherwise, you will need to supply the shipping method yourself on a line by line basis. This can be done by obtaining the default shipping method from the BP object ShippingType property and then assigning that value to each line.

[former_member185703 · Accepted solution]

Hi Heiko,

I think Ty is absolutely right in his analysis and his advice.

I suppose what you are really missing is to have (additional) expenses automatically applied when a particular shipment type is used (like you have it in "real life"...).

As you can see when looking at the shipment type definitions in SAP Business One you will find that there is no option to do this. Basically you will have to provide the logic / the expenses through your code.

Just a remark:

In the application you could use a formatted search to update additional expenses according to the shipment type selected...

So basically, I think you should make sure that the correct shipment type is applied to the particular lines + maybe define shipment costs as Expenses in Document Settings...

Does this make sense to you?

Regards,

Frank