About
The Purchase Cost Movement report displays figures and graphs that outline
the change in purchase cost of inventory items for the period under review.
This report compares actual information with expected costs generated
from the stock received information. It will list each invoice entered
for each product during the reporting period.
Getting the Report
The Purchase Cost Movement report can be found in two ways:
- Sysnet Toolbar
>Reports Menu > Stock > Stock> Financial Checks > Purchase
Cost Movement
- Sysnet Toolbar
>Stock Menu > Reports> Stock> Financial Checks > Purchase
Cost Movement
Filtering the Report
The report can be printed by Date Range or Period and filtering options
include Location, Stock Item, Stock Group, Supplier and Manufacturer.
Advanced filtering allows graphical display, 3 additional group
options to alter how the report appears, and several variance filters
to allow for defined searching.
Hints on Reading the Report
- DATE OF INVOICE
= the date entered as "date of invoice" when received into
Sysnet
- SUPPLIER CODE
= the supplier code from the Sysnet Supplier Menu
- REFERENCE INVOICE
# = the reference number entered when received into Sysnet
- SUPPLIER PRODUCT
CODE = the supplier's product code
- INNERS RECEIVED
= the total quantity of inners (stocktake unit) entered for the invoice
- PREVIOUS COST
= historical listing of "Last Cost" at the time each invoice
was entered
- PURCHASED COST
= the new purchase cost amount at the time the invoice was entered
- VARIANCE $
= Previous Cost - Purchase Cost
- VARIANCE %
= Variance $ /Previous Cost * 100
- EXPECTED COST
= the expected cost set by the venue
- VARIANCE $
= Expected Cost $ - Purchase Cost $
- VARIANCE %
= Variance $ / Expected Cost *100
- HISTORICAL AVERAGE
= calculates the historical average figure using stock in location
history
|
The Historical Average can only be calculated if
"Stock in Location" values exist for the product.
This will depend on the
"Days to Keep" setting, standard
storage is 31 days. Please refer to your local H&L Representative
for more information. |
What is the Purchase Cost Movement Report Useful For?
- Ideal for venues who are using food costing and
recipes to track the history on purchases as food costs can fluctuate
more often
- Problems with invoices entered incorrectly can
be quickly highlighted
- This is also a handy tool when purchasing the same
product from multiple suppliers as it shows the difference and trends
in costs on each invoice for the period under review
- Provides the ability to cross check any discrepancies
where an agreed cost has been set for a particular code and a variance
is showing
