Removed SOP's showing in Item Transactions

(0) Share

Report

Posted on by Community Member

Bringing up a live system for Jan 1 date we cleared all sales history, however item transactions still have SOP data posted against them. This appears to be affecting our beginning balances. How do we remove the SOP transactions from the Inventory transactions window?

*This post is locked for comments

All responses (2)

Answers (0)

Suggested answer

L Vail 65,271 on at

Like (0)

Report

Re: Removed SOP's showing in Item Transactions

Hi Donnette

What you are seeing lives in the item transaction history tables. If you want to remove it, you will have to purge those tables as well. Removing SOP data will not impact the item transaction tables.

Kind regards,

Leslie
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

Re: Removed SOP's showing in Item Transactions

I would download the GP SDK. YOu have cleared the sales tables but not the item transaction tables. You will need to clear the IV10200 table and possibly the SEE30303 table and other tables. The SDK will give you an idea of the transaction flow.