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

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) / Document type 8 in IV3...
Microsoft Dynamics GP (Archived)

Document type 8 in IV30300

(0) ShareShare
ReportReport
Posted on by Imad Kassoumah 3,235

What is the document type 8 in IV30300 with Trx source starts with GLTRX, HSTMODUL =IV,

TRXQTY = 0, UNITCOST = 0 and EXTDCOST=some value?

This is coming after a receipt and before a transfer.

Both the receipt and the transfer are entered in the correct date sequence.

Thanks. 

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    Hello Imad

    This is a Cost Adjustment record.

    I have already started recently to provide in-depth details as related to the cost adjustment in the inventory module in Dynamics GP.

    There series has not been completed yet, still you can check both of the below related article:

    Cost Adjustment (1 out of 4) Override Documents

    Cost Adjustment (2 out of 4) Shipment and Enter Match Invoice

    Your feedback is highly appreciated,

  • Thomas Newcomb Profile Picture
    Thomas Newcomb 1,810 on at

    Hi Imad!

    As Mahmoud mentioned Doc Type 8 is cost adjustments.

    Hope this helps!

    ~Thomas Newcomb

    ------------------------------------------

    Microsoft Dynamics GP Support

    ------------------------------------------

    This posting is provided "AS IS" with no warranties, and confers no rights

  • Imad Kassoumah Profile Picture
    Imad Kassoumah 3,235 on at

    Hi,

    The receipt and the transfer have been entered in the correct date sequence.

    So, why there is document type 8.

    GP was set up to not accept below the available quantity.

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    Imad

    Apparently, the original receipt type is "Shipment", which resulted with a journal entry of (Inventory and Accrued Purchases). As for the transfer, it has withdrawn quantity from this specific cost layer (the receipt), with the the original unit cost.

    Once the receipt has been matched (an enter/match document was recorded on the POP level), with a different unit cost than the original unit cost, a cost adjustment record resulted on the inventory module level to correct both; the original receipt and the associated transfer.

    The date sequence of both the receipt and the transfer doesn't matter, having the same document date will never prevent cost adjustment. They are prevented in one case only, when the item is not setup to "revalue cost".

    All these details are illustrated on the second blog post that I mentioned earlier in my post (Cost Adjustment 2 out of 4 : Shipment and Enter Match).

    The second article related to the "override" is not related to this specific issue, it was just mentioned in case you wanted to know further details about the cost adjustment behavior.

    Let us know if you need any further assistance,

  • Imad Kassoumah Profile Picture
    Imad Kassoumah 3,235 on at

    Hi Mahmoud,

    I have already checked the invoice. It has the same item cost and the same exchange rate.

    The strange thing is that a GL entry has been in IV30300 and a journal entry has been created with a date (I think the user date when he entered the transfer and not the transfer date).

    The exchange rate is completely different when the transfer has been issued from the one when the receipt has been issued.

    Could this cause the cost adjustment? But why?!!!!

    As I mentioned before that both transactions have been entered in the correct sequence.

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    Imad

    Would you please run the below queries and provide me with the results to get things explained

    -- Retrieve POP Receipt and Invoice
SELECT  POPIVCNO ,
        POPRCTNM ,
        QTYINVCD ,
        ORUNTCST ,
        RCPTCOST ,
        PPVTotal
FROM    POP10600
WHERE   POPRCTNM = 'ReceiptNo#'

-- Retrieve HITB details
SELECT  ITEMNMBR ,
        DOCDATE ,
        DOCTYPE ,
        TRXQTYInBase ,
        VARIANCEQTY ,
        UNITCOST ,
        JRNENTRY
FROM    dbo.SEE30303
WHERE   DOCNUMBR IN ( SELECT DISTINCT
                                RCTInvoice
                      FROM      ( SELECT    POPIVCNO AS RCTInvoice
                                  FROM      dbo.POP10600
                                  WHERE     POPRCTNM = 'ReceiptNo#'
                                  UNION ALL
                                  SELECT    POPRCTNM AS Receipt
                                  FROM      dbo.POP10600
                                  WHERE     POPRCTNM = 'ReceiptNo#'
                                ) AS A ) 


-- Retrieve Purchase Receipt Cost Layers
SELECT  ITEMNMBR ,
        TRXLOCTN ,
        DATERECD ,
        QTYRECVD ,
        QTYSOLD ,
        UNITCOST ,
        ADJUNITCOST
FROM    dbo.IV10200
WHERE   ITEMNMBR = 'ItemNumber#'
        AND RCPTNMBR = 'ReceiptNo#'

-- Retrieve Purchase Receipt Cost Layers Details
SELECT  ITEMNMBR ,
        TRXLOCTN ,
        ORIGINDOCID ,
        QTYSOLD ,
        UNITCOST
FROM    dbo.IV10201
WHERE   ITEMNMBR = 'ItemNumber#'
        AND SRCRCTSEQNM IN ( SELECT  DISTINCT
                                    RCTSEQNM
                             FROM   dbo.IV10200
                             WHERE  ITEMNMBR = 'ItemNumber#'
                                    AND RCPTNMBR = 'ReceiptNo#' )


    Your feedback is highly appreciated,

  • Imad Kassoumah Profile Picture
    Imad Kassoumah 3,235 on at

    Hi Mahmoud,

    I ran the script but there was no output.

    Thanks.

  • Imad Kassoumah Profile Picture
    Imad Kassoumah 3,235 on at

    Hi Mahmoud,

    I'm sorry for previous reply.

    The result is:-

    POPIVCNO POPRCTNM QTYINVCD ORUNTCST RCPTCOST PPVTotal
    RCT0000008        RCT0000007        2 1100 96690 0
    ITEMNMBR DOCDATE DOCTYPE TRXQTYInBase VARIANCEQTY UNITCOST JRNENTRY
    31200010 09/10/2012 4 1 0 97799.25 821
    31200010 09/10/2012 4 1 0 97799.25 821
    31200010 09/10/2012 8 0 1 27660 984
    31200010 09/10/2012 8 0 1 27660 984
    ITEMNMBR TRXLOCTN DATERECD QTYRECVD QTYSOLD UNITCOST ADJUNITCOST
    31200010 SP-MISC-WH 09/10/2012 1 1 125459.25 125459.25
    31200010 SP-MISC-WH 09/10/2012 1 1 125459.25 125459.25
    ITEMNMBR TRXLOCTN ORIGINDOCID QTYSOLD UNITCOST
    31200010 SP-MISC-WH TRF0000008                      1 125459.25
    31200010 SP-MISC-WH TRF0000008                      1 125459.25
  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    Okay Imad

    Here is my findings:

    1. The original receipt cost created inventory cost layers, with the original cost
    2. The transfer pulled the quantities of the original receipt with the original cost
    3. The invoice is posted toward the original shipment with the Actual unit cost.
    4. Cost Adjustment Journal was created to adjust The unit cost of the related cost layers Original Receipt and Transfer document ( Document Type is 8 )

    Cost Adjustment is calculated as follows :

    • Original Unit Cost as retrieved from the shipment (97799.25)
    • Actual Unit Cost  as retrieved from the enter match invoice (125459.25)
    • Cost Adjustment variance = 125459.25 - 97799.25 = 27660 per unit

    Please let me know if you have any further concerns,

  • Imad Kassoumah Profile Picture
    Imad Kassoumah 3,235 on at

    Hi Mahmoud,

    I mentioned that the match invoice unit cost (96,690.00) is the same as the receipt unit cost before the landed cost and the same exchange rate.

    This is why I could not understand the cost adjustment (27,660.00) is created.

    Best regards.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans