Sales order Backorder problem

twdavis · 2007-02-13

We are running SQL2005, Nav4.0 SP3 executables, and Nav4.0 database.

We are periodically experiencing a problem with backorders not being reflected correctly on the refreshed SO after posting a partial shipment\invoice. It does not happen all the time, it is not confined to one customer.

For example
SO has 2 items, A has a qty of 5, B has a qty of 2. we invoice and ship, 2 of A and 2 of B. History files show correctly, shipments of 2 and 2 and Invoices of 2 and 2.

However, the refreshed SO shows incorrectly
for A: "qty to ship" 0, (should be 3)
"qty shipped" 5, (should be 2)
"Qty to invoice" 3,
"qty invoiced" 2

for B: "qty to ship" 0,
"qty shipped" 2,
"Qty to invoice" 0,
"qty invoiced" 2

Is there a known issue with the posting of backorders? Has anyone experienced this problem? How do I resolve?
I looked for any customizations that might explain the occurrence, but there are none that impact the "Qty. to Ship" and "Quantity Shipped" field values.
Thanks for your help.
t

Alex_Chow · 2007-02-14

No, there's no issues with the out of the box back order/partial shipping in Navision.

Couple of things to consider:
1. Does this happen every time?
2. Did the user accidentally posted the back order?
3. Did you NSC did some development along this area?

kriki · 2007-02-14

[Topic moved from Navision Attain forum to Navision forum]

Mbad · 2007-02-14

Sure sounds like someone messed around with your CU80 or your sales line table.
Should be pretty easy to test if you are a code nerd, since you can recreate the error.

Alex_Chow · 2007-02-14

If you still have the stand alone CRONUS demo database, you can try the same scenario there.

muksha · 2007-02-15

There is no such issue observed in Navision. This is a mistake of user nothing else.

Sales order Backorder problem

Comments

Categories