Unposted Inventory Transfers in the Historical Table

(0) Share

Report

Posted on by KarlPedersen

Hi everyone,

Looking for some help on some mysterious transactions showing up in the GP view "InventoryTransactions". We use this view in a SmartList for members of my Inventory team to track down issues. I've received questions about 10 Inventory Transfer Documents that show up as "Unposted" and do not have a batch anywhere. After some poking around I noted that not only were these all probably created by a Check Links back on 10/5, but they are all "Unposted" but in the History Tables???

They all appear to either be simple Inventory Transfers used to move stuff between In Service and On Hand, and everything looks good on the floor, so I'm looking for advice on how to clean these up. Assuming there is no way to "Post" from history, should I just update via SQL or delete from SQL?

Thanks,

Karl Pedersen

IT Director

Nye Lubricants, Inc.

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Richard Wheeler 75,850 Moderator on at

Like (0)

Report

In which tables do you see these transactions? IV10200, SEE30303 or other tables? You need to be careful what you remove because you do not want to mess up the IV reconcile routine.

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

It is quite possible that checklinks would create documents in certain cases, but it would not post them automatically, they will be saved in order for you to check their validity and post them accordingly.

Please let us know on whether you can check on which tables these transactions are; as Richard implies above, and share your resutls.

Your feedback is highly appreciated,

Was this reply helpful? Yes No
KarlPedersen on at

Like (0)

Report

In full disclosure, I am not very familiar with the proper tables to check. I am only looking at them because they are showing as Unposted in the "InventoryTransactions" GP SQL View.

If I open up the Inventory Transfer Inquiry to find them I can, but they don't show up in Entry, so I assumed they are historical.

They all have entries in IV10200 where the document number is under RCPTNMBR and the items and quantities match.

My SEE30303 table is empty. Anywhere else I should check?

Karl

Was this reply helpful? Yes No