Freight Cost Allocation – Tailored for Infor SyteLine AP Automation
Need to allocate freight costs across multiple GL accounts? In this Nimbello tutorial, we’ll walk you through automating freight distribution in Infor SyteLine AP:
🔹 Distributing freight costs proportionally based on invoice line totals
🔹 Assigning freight to built GLs or custom freight accounts
🔹 Handling tax-exempt raw material invoices with freight adjustments
🔹 Updating GL entries to reflect accurate costing Keep your SyteLine financials precise with automated GL allocation!
Transcript:
Speaker 1:
I think what you're talking about is an allocation type of GE coding. What we do—this happens during the export process—is look at the total freight amount and the total line items of the different GLs being billed.For example, if one GL represents 51% of the invoice total, then 51% of the freight is allocated to that GL, while the remaining 49% goes to the second GL.
We can allocate it either to the billed GL (the one on the purchase order) or apply other logic, such as replacing the account number with a freight account number. We can handle that as well.
Speaker 2:
Okay, thank you! That answers my question for that specific example.I have another example I wanted to bring up—I think you briefly answered this, but I just want to double-check.
For raw material invoices, we have a tax exemption. However, occasionally, we have freight or shipping charges associated with them. Would the system be able to adjust for that?
For instance, say we ordered 100 bags of sugar at $10 each, totaling $1,000, and the freight cost was $250. Would the system be able to add that $250 to the total raw material cost and then divide it, giving us a new unit price for either the purchase order or the GL entry?
Speaker 1:
The GL entry, yes. The purchase order itself wouldn’t be updated, but the GL costing for that item would reflect the freight cost.
Speaker 2:
Okay, got it. Those were my main questions for now. Thank you!
Related Articles:
How to manually "Y-Approve" misc. charges on a PO invoice