Product analysis in/out reports - by invoice number range?

[rebeccaruth]

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.

[leyburnsolutions]

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

[brucedenney]

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