Deleting line from Order

[LukaszBloch]

I had an order in SBO. It was synchronized do NP. Then i made an shipment for just 3 lines (5 lines in order). i deleted one line from order (this line was not on the delivery document, it will not be delivered).

In next synchronization i have conflict:

<b>

DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_ShipmentDetail_OrderDetail'. The conflict occurred in database 'np', table 'ShipmentDetail', column 'OrderDetailID'.

The statement has been terminated.</b>

Is there possibility to synchronize order with deleted line (after shipment)

[Former Member · Accepted solution]

Hi Lukasz,

This is a known bug.

During synchronization, all line items are deleted and readded if the order is updated. If there is a delivery document already in place prior to the update, the delete of the line items will cause this error.

This is fixed in 2007 sp0 p3.

There is currently no fix for 5.9.

At the moment, the only way around this is to delete the shipment and shipment detail for this order in NetPoint.

You can then edit the delivery document in B1 to get the shipment to synch back to NetPoint.

[LukaszBloch · Accepted solution]

Is there any solution to automatically delete this kind of order's from transaction_queue

[Former Member · Accepted solution]

You could resolve it with a synch plugin or a DTS job.

Unless you are seeing this error frequently, it may be easier to just manually delete them, though. This should be a pretty rare occurance.