Wednesday, June 24, 2015

Actual Freight on Customer Invoice in SAP Business ByDesign

We’ve often come across the requirement to invoice customers for only the actual freight price or cost incurred related to the outbound delivery. In the example we explore here, the “Freight Price” is an extension field that has been added to the outbound delivery. The value in the field is actually being sent to SAP Business ByDesign from an external system, but this functionality could also work with a value entered manually on the outbound delivery itself.
Note that this customization was only built for a single-currency environment, but it would be very easy to adjust to a multicurrency environment by changing the “Freight Price” field to an “Amount”-type field instead of a “Text” type field. In this scenario, the external system did not send data in an “Amount” type structure.
The external system would send back the actual amount value to populate the “Freight Price” field once the outbound delivery had been processed.

Actual Freight on Customer Invoice in SAP Business ByDesign 1
Now, when it’s time to create the customer invoice, the “Freight Price” is populated on the customer invoice automatically.
Actual Freight on Customer Invoice in SAP Business ByDesign 2

To do this, a minor customization is required on the backend – there’s a certain amount of customer-specific logic employed in this case, but provided a value is found for freight price, it is created on the customer invoice.
Actual Freight on Customer Invoice in SAP Business ByDesign 3

Lastly, for situations in which a set freight amount is specified on the sales order, an extension field can be checked on the sales order that indicates that the freight on the customer invoice should not be overwritten with the actual freight price.
Actual Freight on Customer Invoice in SAP Business ByDesign 4
Please do not hesitate to reach out should you need additional information or assistance.
Written by:  Dan Edelman, Senior SAP Business ByDesign Consultant - FMT Consultants