These are not all the reports available but the most commonly asked about

This lists all invoices and cash sales, value, vat value and how paid, it also includes cash deposits on Sales Orders.  This report should be used for the cash reconciliation and the reconciliation of credit cards to the PDQ end of day print.

• Reference Number – This is the invoice number

• Account – This is the sales ledger account code the invoice was raised to 

• Type – If it was an invoice or credit note

• Date – Date of when the invoice has been raised

• Total Value – Total of the invoice/Credit Note

• Sett. Disc. – This will show the settlement discount if the customer has this set on their account 

• Cash Receipts – This is when you mark the invoice/credit note as paid/refunded by cash

• Credit Card – This is when the invoice/credit note has been paid/refunded by credit card

• VAT Value – This is the VAT amount applied to the invoice/credit note

Analyses all today’s items issued by dept. e.g. Counter, Workshop/Bodyshop and by retail, trade, internal & warranty but only by product group and shows retail, discount, nett cost and margin

• Group – Produce Group

• Retail – Retail Price

• Discount – Discount Value

• Nett – Nett Value

• Cost – Cost Price

• Margin – Margin Value (cost price - retail price)

• %age – Margin Percentage (margin value ÷ by Nett x 100)

During the month end processing the system writes a stock movement history file (sales, receipts and adjustments) for the month. This can be printed during the following month at any time up to the following month end processing. Includes part number, description, type, date, group, ref, Job No, Quantity, cost and sales value.

• Part Number – Part number which has been issued

• Description – Description of the part number

• Type – How it was issued i.e. Receipt, Issue etc

• Date – Date of issue

• Group – Product Group Number

• Ref No – Invoice/Credit note, Supplier Reference, user input reference 

• Job No – Job number part was issued to 

• Quantity – Number of parts issued for that part number

• Cost Value – Cost price of the part

• Sales Value – What the part was sold for

Asks for a selection by start/end code, product group, totals or all items, controlled (Y/N) and full list or totals and then prints out;

Includes product Group, Part no, Description, Quantity on hand and then average/latest costs and Retail values 

The Average cost value at the bottom of the report is what is used to compare to the nominal.

There are a number of options within this report

• You can select to print by ‘Part Number’ or ‘Bin Number’ order

• You can enter a Start and End code and Product Group or enter through the fields for all

• You can enter ‘Last Receipt Date’ as a Less Than or Greater Than or leave as N/A

• If you tick Print Product Groups this will be displayed on the report

• You can Evaluate Negative Stock i.e. Qty’s showing as a minus

• You can Include Zero Stock i.e. Qty showing as 0

• If you have Decontrolled items then if this is tick you can include them in the report

• You can do a Full List which will include all the part numbers OR a Totals Only which will only give you the Totals