web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / How to resolve differe...
Microsoft Dynamics GP (Archived)

How to resolve difference between IV10200 and SEE30303?

(0) ShareShare
ReportReport
Posted on by Richard Wheeler 75,848 Moderator

What is the difference between these two fields?

SEE30303.QTYTRX

SEE30303.QTYTRXInBase

I am trying to resolve a difference between the purchase receipts report and the IV Historical Trial Balance report. Out of millions of dollars we are off by $6.60

Is there any way to reconcile the IV10200 to the SEE30303? Can you tell me the sp's used behind these two reports?

*This post is locked for comments

I have the same question (0)
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at

    These two queries return the same total for the amount of inventory in stock. However when I run the IV HITB report it is too low by $6.60. What would I need to add to the query for SEE30303 to get it to agree with the report?

      SELECT  SUM(EXTDCOST) AS EXTDCOST

      FROM SEE30303

      HAVING SUM(EXTDCOST)>0

      SELECT  SUM((QTYRECVD-QTYSOLD)*UNITCOST) AS EXTDCOST

      FROM IV10200

      HAVING SUM((QTYRECVD-QTYSOLD)*UNITCOST)>0

    The query for IV10200 agrees with the purchase receipts report so which report is correct. The IV HITB which is $6.60 lower or the purchase receipts report that agrees with these two queries?

  • Verified answer
    kdd281 Profile Picture
    kdd281 469 on at

    We use this find the missing transactions in SEE :

    Compare

    select * from IV10201 where docdate  > '2019-XX-XX 00:00:00.00'

    select * from see30303 where docdate  > '2019-XX-XX 00:00:00.00'

    select * from iv30300 where itemnmbr like 'XXXXXX' order by docdate to locate the TRXSORCE ; TRXSORCE = ORGNTSRC

    select * from gl10000/gl20000/gl30000 where ORGNTSRC = XXXXXX

    I just added the missing record or there is script you can find, search DECLARE SEE30303_INSERT CURSOR FOR

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans