Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

What causes records to be written to SEE30303 but no corresponding records to be written to GL20000?

(0) ShareShare
ReportReport
Posted on by 75,730

Why would a record be written to the SEE30303 table but no corresponding records are created in GL20000?

*This post is locked for comments

  • Verified answer
    kdd281 Profile Picture
    kdd281 465 on at
    RE: What causes records to be written to SEE30303 but no corresponding records to be written to 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.

    https://pastebin.com/9c8qqQuG

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: What causes records to be written to SEE30303 but no corresponding records to be written to GL20000?

    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.

  • Verified answer
    kdd281 Profile Picture
    kdd281 465 on at
    RE: What causes records to be written to SEE30303 but no corresponding records to be written to GL20000?

    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

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.

Helpful resources

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans