Accounting › Product Costing
Material Ledger
What an item ACTUALLY cost in a period, once every purchase price difference and production variance is rolled back in. The only honest answer to "what did the goods we sold in March cost us".
Where to find it
- Module: Accounting
- Group: Planning & Control
- Section: Product Costing
- Screen: Material Ledger
Address in the console: /accounting/material-ledger
Read-only list · 13 columns
This list is read-only: its records are written by the work that produces them. A correction, where one is possible at all, is made where the record was created.
What the list shows
These are the columns of the list, in the order they are drawn. Any of them can be sorted on, filtered on, hidden, or exported.
| Column | Kind | Field name |
|---|---|---|
| Period | Code | period_code |
| Item | Code | item_no |
| Name | Text | item_name |
| Warehouse | Code | warehouse_code |
| Opening qty | Number | opening_quantity |
| Closing qty | Number | closing_quantity |
| Standard | Amount | standard_price |
| Actual | Amount | periodic_unit_price |
| Difference % | Number | actual_vs_standard_pct |
| Difference | Amount | total_difference |
| To cost of sales | Amount | consumed_difference |
| To stock | Amount | stock_difference |
| Status | Status | status |
The rules that apply here
Everything on this screen obeys the platform rules rather than rules of its own. The ones worth knowing before you use it:
- Narrowing a list — search, conditions, sort, totals, export and saved views.
- What may be changed — the five grounds a record may not be edited on.
- Companies and business units — what the switcher above this list is doing to it.