Item-by-item detail of your posted purchase bills, showing both the price on the bill and the true landed cost once the extra charges on that bill are spread across its lines.
When to use it
When you want to know what an item really cost you, not only what the supplier billed, with freight, duty and other charges included. Also as the month's purchase detail for costing and review.
Before you start
- Purchase Invoices must be entered and posted. Drafts do not appear.
- Any extra charges must be recorded on the bill itself for the landed figures to be right.
- You need report access for Procurement.
Where to find it
ERP > Procurement > Purchase Invoice.
Filters
| Filter (on screen) | What it does |
|---|---|
| From Date | Start of the period this report covers. |
| To Date | End of the period this report covers. |
Reading the report
- Every row is one item line, not one bill. A bill with five items is five rows sharing a date and a document reference.
- Amount is the line as billed: quantity multiplied by rate, before any extra charges.
- Effective Amount is that line value plus the line's share of the extra charges on the same bill (freight, duty, loading and the like). This is the landed cost, and it is the figure to use when you are deciding what an item costs you. Effective Rate is that same landed amount divided by the quantity.
- Commission Amount is the difference between the two: the extra charge loaded on to that line. It is zero when the bill carried no extra charges.
- Amount and Commission Amount are totalled at the foot. Adding the two together gives you the landed total for the period. Quantity is not totalled, because the lines are measured in different units.
- Only posted purchases appear. A bill entered but not yet posted is invisible here, so this report will not match a list of everything typed in this month.
- Purchase returns are not netted off. To see goods sent back, run the Purchase Return report.
Tips and common mistakes
- If Effective Amount equals Amount on every row, no extra charges were recorded on those bills. The landed cost then has nothing extra in it, which may or may not be right.
- A missing bill is almost always an unposted one. Check its status before assuming a date problem.