Freight Bill linked to voucher for load is being transferred to Accounts Payable module.
Consider load:
Shipments on Load - Weight Distribution
Shipment |
Origin |
Destination |
Weight (LB) |
---|---|---|---|
AAA |
Chicago, IL |
Denver, CO |
5,000 |
BBB |
Chicago, IL |
Las Vegas, NV |
10,000 |
CCC |
Chicago, IL |
Los Angeles, CA |
25,000 |
Assuming Load Pro-Ration Strategy is Weight, the load level charges for load would be distributed to the shipments as follows:
Shipments on Load - Percentage of Load Weight
Shipment |
Weight (LB) – Shipment |
Weight (LB) – Load |
Percentage of Total Weight |
---|---|---|---|
AAA |
5,000 |
40,000 |
12.50 |
BBB |
10,000 |
40,000 |
25.00 |
CCC |
25,000 |
40,000 |
62.50 |
Total |
40,000 |
|
100.00 |
The G/L Transactions generated when the voucher for this load is transferred to A/P would be:
G/L Transactions - A/P Load with Pro-ration
G/L Classification |
G/L Account Type |
Charge ID |
Destination |
Debit Amount |
Credit Amount |
---|---|---|---|---|---|
A/P Expense – Revenue Shipment |
Expense |
MILE |
Denver |
200.00 |
|
A/P Control - Revenue Shipment |
Liability |
MILE |
Denver |
|
200.00 |
A/P Expense – Revenue Shipment |
Expense |
MILE |
Las Vegas |
400.00 |
|
A/P Control - Revenue Shipment |
Liability |
MILE |
Las Vegas |
|
400.00 |
A/P Expense – Revenue Shipment |
Expense |
MILE |
Los Angeles |
1000.00 |
|
A/P Control - Revenue Shipment |
Liability |
MILE |
Los Angeles |
|
1000.00 |
A/P Expense – Revenue Shipment |
Expense |
FUEL |
Denver |
20.00 |
|
A/P Control - Revenue Shipment |
Liability |
FUEL |
Denver |
|
20.00 |
A/P Expense – Revenue Shipment |
Expense |
FUEL |
Las Vegas |
40.00 |
|
A/P Control - Revenue Shipment |
Liability |
FUEL |
Las Vegas |
|
40.00 |
A/P Expense – Revenue Shipment |
Expense |
FUEL |
Los Angeles |
100.00 |
|
A/P Control - Revenue Shipment |
Liability |
FUEL |
Los Angeles |
|
100.00 |
Note: A separate debit and credit will be generated for each combination of shipment and charge code. Given that characteristics of the origin and destination shipping locations for each shipment are considered when creating G/L Transactions, the G/L Accounts numbers assigned to each charge could be different.