Sage 100

Does it always happen to one of the orders when there are two orders for the same customer?  Is it the same inventory item on both orders?  If yes to either question, you could put test orders that get imported using the ROI API and the VI job(s) and then compare every field in the SO data entry tables.  If there are no differences or irregularities then try posting. 

Thanks @Doug Higgs.  We wrote a report to track when this happens.  And will be doing nightly "company copies" before they post the batch so we can try and step through what might be causing the order to write back into Sales Order Entry as a BO with nothing on BO.  Let's see how this week goes for troubleshooting the cause. 

Does it always happen to one of the orders when there are two orders for the same customer?  Is it the same inventory item on both orders?  If yes to either question, you could put test orders that get imported using the ROI API and the VI job(s) and then compare every field in the SO data entry tables.  If there are no differences or irregularities then try posting. 

I think I have figured it out.  Their VI Imports intentionally "skip" bringing in comments to the SO Invoice.  I'm thinking the orders they are shipping have a /C Comment in SO Entry that is not being populated into the Invoice through the VI Import.  The order does not think it is shipped complete so it writes back into SO the shipped line, because of this.  I've not proved this out but it is what I believe is causing the issue.  Thanks for your suggestions. 

@Madeline Stefanou did you ever get a definite answer on this?

I've seen this at a particular client over the years & they are asking again. This most recent incident was shipped via StarShip & writes back without any errors. Its 1 line with a Ordered & Shipped qty of 1, no B/O. No comment lines. but is still an "Active Order".  I can't pinpoint what causes this to happen.

I think I have figured it out.  Their VI Imports intentionally "skip" bringing in comments to the SO Invoice.  I'm thinking the orders they are shipping have a /C Comment in SO Entry that is not being populated into the Invoice through the VI Import.  The order does not think it is shipped complete so it writes back into SO the shipped line, because of this.  I've not proved this out but it is what I believe is causing the issue.  Thanks for your suggestions. 

I just checked with @Tina Leonard.  The Inventory Item was not set to "allow backorders". So we went through and defined "all items" to allow Backorder.  As I recall, the problem was resolved with that change. 

@Madeline Stefanou did you ever get a definite answer on this?

I've seen this at a particular client over the years & they are asking again. This most recent incident was shipped via StarShip & writes back without any errors. Its 1 line with a Ordered & Shipped qty of 1, no B/O. No comment lines. but is still an "Active Order".  I can't pinpoint what causes this to happen.

I think I have figured it out.  Their VI Imports intentionally "skip" bringing in comments to the SO Invoice.  I'm thinking the orders they are shipping have a /C Comment in SO Entry that is not being populated into the Invoice through the VI Import.  The order does not think it is shipped complete so it writes back into SO the shipped line, because of this.  I've not proved this out but it is what I believe is causing the issue.  Thanks for your suggestions.