Why would a record be written to the SEE30303 table but no corresponding records are created in GL20000?
*This post is locked for comments
I just went through this yesterday for 2 missing Inventory transactions that were in IV but not SEE. In my situation the transaction was 0 dollars so there was no record on the GL side since it was 0 dollars, but I used below to search.
select * from iv30300 where itemnmbr like 'XXXX' order by docdate to locate the TRXSORCE
TRXSORCE = ORGNTSRC
select * from gl10000/gl20000/gl30000 where ORGNTSRC = XXXXX
GL10000 – Transaction Work/Unposted (header)
GL20000 – Open Year Posted TransactionsGL30000 – Historical Year Transactions
I have 30 such transactions that exist based on this query.
SELECT * FROM SEE30303 WHERE JRNENTRY NOT IN (SELECT JRNENTRY FROM GL30000) AND DOCDATE <= '20190430' AND UNITCOST<>0 ORDER BY DOCDATE
Using your query some of the records that are missing have a blank value for TRXSORCE. Others do not.
This all came about because of $6.60.
If I run the IVHITB it comes up with a number that is $6.60 less than
SELECT SUM(EXTDCOST) FROM SEE30303 for the same dates which also $6.60 less that the purchase receipts report.
I believe I have tracked it down to one record in the SEE30303 table.
The TRXQTY is 18, the unit cost is $6.60 but the EXTDCOST is $112.20 when it should $118.80.
If I manually update the EXTDCOST the cost is still wrong on the report.
I found some older troubleshooting scripts that might help, it must be getting them from the GL side. I used pastebin since its too large.
https://pastebin.com/9c8qqQuG
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Community Member 4
Victoria Yudin 1
