You can apply a freight cost to an EDI invoice and then distribute the cost across its received items. Cost distribution can be by weight or item cost. This feature is already available for manual receiving.
How it works
To apply a freight cost, after an EDI invoice is processed, in the Inventory module, click EDI, and then click Reporting.
In the EDI Reporting window, invoices that are eligible for a freight cost have a red X icon in the Freight column. Highlight an invoice with a red X and click Apply Freight.
In the EDI Freight Cost window, select the freight cost distribution method:
- If you select Item Cost, the cost will be distributed in proportion to each item’s individual cost.
Example: If the shipment contains two items that cost $10 and $20 respectively. the $10 item will receive 1/3 of the freight cost and the $20 item will receive 2/3 of the freight cost.
- If you select Weight, the cost will be applied in proportion to the weight of each item.
Example: If the shipment contains two items that are 10 and 20 pounds respectively, the 10 pound item will receive 1/3 of the freight cost and the 20 pound item will receive 2/3 of the freight cost.
If you select Weight and not all items have a specified weight, a message will appear. In the example EDI Freight Cost window below, the message tells you that 6 of the 89 invoice items do not have a defined weight, and therefore will not receive a freight cost.
After you choose a distribution method, enter the Freight Cost and click OK or press F8 to complete the process. An informational message window will appear when the freight cost is applied.
Click OK to close the message window. Then, in the EDI Reporting window, you will notice that the red X icon for the EDI invoice you processed has become a green check mark.
Tip It’s a best practice to apply freight cost soon after the EDI invoice is processed and before received items are sold.
If you have questions or suggestions about this information, contact firstname.lastname@example.org.