How Do I ... Generate a report showing what stock items have been sold?
How do I generate a report showing what stock items have been sold?
I want to keep an audit trail of goods in/out on a monthly basis.
Normally you would use the History option but in some cases you just want a note of the numbers rather than the full details.
Use either:
- Stock Control -> Reports -> Monthly Figures to get a breakdown
over the year by month of either Sales or Purchases. You
can use the Flags to limit just to products relating to
milk/meat producing animals.
- Set up a report in the Report Generator:
Stock Control -> Reports -> Report Generator
- Pick Create New Report
- 1st Box relates to what details you want printed out e.g. Number, Description, March Sales, March Purchases (assuming you want the report for the month of march) {navigate via arrow keys and <spacebar> to select}
- Return through all the Printout Format options
- Sort Fields - Select Yes
- Pick 'Description' so the report comes out sorted into alphabetical order.
- Search Criteria Box
You will want to limit the report so only items that have been sold or purchased in March are listed. I know this next line is very cryptic but it does work - trust me I'm a programmer :-)
Select: Special 1 and when asked for the details enter:
&3s@>0,%&3p@>0 - Press RETURN through the Misc settings
- Give the report a name e.g. Usage for March
Press return when asked for filename.
- Now whenever you need to run the report select 'Run a Report'
Press return to get a list of the reports and pick 'Usage for March'
You can fine tune the report as required.