Why would a record be written to the SEE30303 table but no corresponding records are created in GL20000?
Why would a record be written to the SEE30303 table but no corresponding records are created in GL20000?
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.
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 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 Transactions
GL30000 – Historical Year Transactions
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,564 Super User 2024 Season 2
Martin Dráb 228,651 Most Valuable Professional
nmaenpaa 101,148