Skip to main content
Microsoft Dynamics GP forum
Answered

How to resolve difference between IV10200 and SEE30303?

editSubscribe (0) ShareShare
ReportReport
Posted on by 75,730

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?

Categories:
  • Verified answer
    kdd281 Profile Picture
    kdd281 465 on at
    RE: How to resolve difference between IV10200 and SEE30303?

    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

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: How to resolve difference between IV10200 and SEE30303?

    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?

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,030 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,562 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans