Call Us: 1 502 223 1136 - email info@customwareinc.com
Modifications and Add-Ons

Traverse Mods Online

Traverse Accounting Software Modifications, Add-Ons and Enhancements

PO Distribute Landed Cost

$800.00

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.

Description

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.

Setup

Landed 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.

po-landed-cost1

Process

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.

po-landed-cost2

 

Report

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.

po-landed-cost3

 

Reviews

There are no reviews yet.

Be the first to review “PO Distribute Landed Cost”

Your email address will not be published. Required fields are marked *

Back to Top
Traverses Accounting Software Modifications