There is an entry for an item on the HITB report that I cannot explain, no site, no journal entry, no quantity, -3,337.95. variance qty = 1,155 and the source = "Cost Adj. - IVTransfer. "
I have searched iv30300 for the document number and item combination, and although I do have a transaction, it is clearly a transfer of 2500, unit cost = 13.24, extdcost = 33110.30
How can I find out where this entry originated from?
Thank You!!
*This post is locked for comments
I wrote a blog post on this topic, which includes a query, which compares the IV30300 and SEE30303. You could try this query, but you need to update the lines related to the date HITB initialization was run on your system:
and IVTH.DOCDATE > '9/10/2011' (or similar) in 8 locations. You need to change 9/10/2011 to the date HITB was installed and initialized in your environment. This query should isolate records, which don't match in these tables (the summary of records in these tables should match). Here is a link to my blog post:
redbeardblogging.blogspot.com/.../hitb-quanity-on-hand-vs-inventory.html
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
