Reset Sales line item quantities to zero each period.

(0) Share

Report

Posted on by Derek Stearns

130

We have a very manual process in GP 10 in which we use the recurring SOP screen to create invoices for each period. This is more of a monthly billing and what we would like is the ability to zero out all the quantities of each sales order line item in a batch since each month may require a new qty or may not be billed at all. Does anyone know a way to do this instead of having to cycle through each sales order and zero out the qty before doing our next periods billing?

Thanks!

*This post is locked for comments

All responses (5)

Answers (0)

Derek Stearns 130 on at

Like (0)

Report

Re: Reset Sales line item quantities to zero each period.

Thanks for your suggestions. We will give it a shot.
Tim Foster 8,515 on at

Like (0)

Report

Re: Reset Sales line item quantities to zero each period.

It sound like the list of documents and items are static. You could do it in a macro.

Tim
djstearns 90 on at

Like (0)

Report

Re: Reset Sales line item quantities to zero each period.

Yes we use recurring SOP documents to create the invoices. A SQL query would work, however, I am not certified and our manager disapproves of using SQL. Any other ideas?

Sorry for the late response.
L Vail 65,271 on at

Like (0)

Report

Re: Reset Sales line item quantities to zero each period.

Do you use a repeating SOP document?
Suggested answer

Frank Hamelly | MVP... 46,319 Super User 2025 Season 1 on at

Like (0)

Report

Re: Reset Sales line item quantities to zero each period.

You could run a SQL script to set QUANTITY to zero in SOP10200 where BACHNUMB = xxxxxx. BACHNUMB is found in SOP10100 so you'll have to do a join to select the correct records in SOP10200.

Hope this helps,