This modification extends the existing PO Transactions screen and allows to user to distribute a total landed cost amount across all line items in a transaction. The landed cost amount applied to each line item is weighted against the cost of the item versus the combined line item cost.
To use the modification a new Landed Cost item must be created for each location you will receive goods at. The Landed Cost ID should exactly match the Location ID as setup in inventory as this will be used to locate the appropriate Landed Cost item per transaction.
Each new Landed Cost item must have a single detail record attached to it. The detail record must have a cost type of Fixed Amount. An amount is required but is irrelevant as it will be overwritten during distribution, so a value such as 0.01 will suffice. Description, Level, and GL Expense Account can be setup as required.
Once setup is complete the process of using the modification is simple. Once a PO Transaction has been created and the line items are entered switch to the Totals tab on the header control. Enter the Total Landed Cost amount and then press the Distribute button. Each line item will have its Landed Cost details created and populated with the Landed Cost item setup for the transaction location. The amount for each Landed Cost detail will be set to the weighted portion of the Total Landed Cost.
The applied Landed Cost can be viewed by clicking on the toggle arrow on the right-hand side of the line item summary, or by pressing CTRL + SHIFT + T, and clicking on the Landed Cost tab.
Note: If there is any remainder during distribution, such as from rounding errors, versus the expected Total Landed Cost the difference will automatically be applied in full to the last line item on the transaction.
The standard PO Order report has been modified to include the applied Landed Cost amount, as well as a Landed Cost grand total in the report footer.