Back ordered QTY showing as Negative

(0) Share

Report

Posted on by Community Member

Does anyone know how we can fix negative backorder quantities in GP? I want to discontinue a non-used site and I have removed the item/site assignment for all items in that site, except for the item below because it has an item quantity for Back Ordered (-1). There are a few other items in existing/still in use sites that also have negative Back Ordered quantities so I really need a solution for how to find these.

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

MattPaulen 6,912 on at

Like (3)

Report

Have you tried reconciling yet? I would try reconciling Sales documents first (Sales >> Utilities >> Reconcile - Remove Sales Documents). Choose the Reconcile Sales Documents Option. Then you could also try running the Inventory Reconcile against the one particular item.

If it's been awhile since you've run any reconcile, it may be best to run a backup of your company database first to make sure nothing major happens.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks, we will be running Year-End Reconcile shortly, hopefully this will fix the problem and if so I will update accordingly.

On a separate but similar note, we have items that are listed as Back Ordered, but they are not present in our Back Ordered sales batches. We have a smartlist that shows the total amounts of each item back ordered, but we do not have a way to track down each individual B/O without going through hundreds of sales orders. Is there a way that B/O's can be displayed either through a report or smartlist that shows the order # for each item so we can delete or void the outdated BO's?

Thanks in advance.

Was this reply helpful? Yes No
Verified answer

L Vail 65,271 on at

Like (1)

Report

Hi,

The reconcile utility may correct the erroneous backorders as well. To match the BO with an order (if one exists), use your Sales Line Items smartlist and filter by the item number and quantity BO'd.

Kind regards,

Leslie

Was this reply helpful? Yes No