Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Answered

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

Posted on by 75,730

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

Categories:
  • 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

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,564 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,651 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans