SageForum for UK versions of Sage 50- Help and support.

Hi,

I use Sage Line 50 v. 13.02.30.0144

We use the standard Product analysis, Product Movement in/out report which shows product movement for any given day. We use this as an initial picking list for orders going out that day, which works very well and saves a lot of time compared with going through individual sales orders, picking each order individually.

BUT we get a lot of additional orders each day after the report has been printed - is there a report, or can I customise the current one, which will allow me to print the same report but only for certain invoices, not for all invoices on a particular day? EG if I could get it to do the report for invoices greater than a given number that would be perfect.

I have looked in report designer at editing the existing report to do this, but haven't used report designer before and am struggling.

Any tips gratefully received!
Thanks.

When an invoice is updated, the Invoice Number is used as the Reference for the stock transaction so it should be possible to add a new Criteria to the report to allow for the selection of a range of invoice numbers.

You'd need to edit the report and, in the Report Designer, go to Data -> Criteria. Add a new criteria from the STOCK_TRAN table using the REFERENCE_NUMERIC field. Save as a new report which will appear in the My Product Reports section.

When you run the report, you'll now be able to select a range of invoice numbers to run the report for.

I've tried this in v2011 and it works there.

John

There is anotherway

You could use the same report but before you run it use a search to filter your view to invoices where the invoice number is greater than xxxxx