negative qty on order

I was a few $ short of a minimum order on a PO. The supplier added 1 more case pack of an item to meet the minimum. When I received against my PO, I received 18, and the order qty was 12. Now when I run and qty reports, it shows -6 on order for this item. When I look at the item itself, it shows 0 on order. I manually reduced the on hand quantities to test if it would be added to a PO based on re-order quantities. That worked fine. How do I get rid of the -6 on order in my reports?

Thanks in advance,

MP

Reply to
Mary-Pat
Loading thread data ...

Not sure what reports you're seeing this on, were they customized to include the Qty on Order, or am I just not seeing that field? In any case, if you go to File/Configuration, Options, Purchase Order Options and select the option "Allow edit of closed purchase orders", then open the PO for edit and change the Qty Ordered to the Qty you received, the negative number should go away. Strange that when you receive less than you ordered RMS detects it and asks you if you want to change to the lower amount, but it doesn't catch an over shipment...

Reply to
Glenn Adams [MVP - Retail Mgmt]

That worked Glenn, Thank-you.

The report I was referring to was the summary sales report from the MS web site. It lists each item only once with totals sales - looks much like the detailed sales report without the repitition and transaction detail.

Mary-Pat

"Glenn Adams [MVP - Retail Mgmt]" wrote:

Reply to
Mary-Pat

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.