Skip to Content
avatar image
Former Member

Selected Wrong Inventory Account in JV while posting GRPO


Please see the following Attachment.

The JV of the following GRPO, hit Negative Inventory Adjustment Acct instead of Inventory Account.

Please explain why it is happening ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Jan 06, 2017 at 05:39 AM


    Check the following thread:

    In case of Quantity going negative, the document books the value in the Negative Inventory Adjustment Account.



    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 06, 2017 at 09:16 AM

    Hi Narendra ,

    This is happened only when your item is not available or zero quantity in stock then only this Raw Material Variance account comes in effect.


    Add comment
    10|10000 characters needed characters exceeded

  • Jan 06, 2017 at 12:04 PM

    Dear Narendra,

    You can verify as per below...!!

    This account is used only if:

    • Inventory quantity is negative when the inventory posting takes place
    • The document price is different from the moving average or the FIFO price.

    In these cases the moving average or FIFO prices are held static, and the differences between these prices and inventory values resulting from the addition of new documents, are posted to this account.


    This account is not relevant for the standard price valuation method.


    From an accounting perspective, we do not recommend using negative inventory. However, to use negative inventory, deselect the Block Negative Inventory field in  Administration  System Initialization  Document Settings  General  tab.

    Best Regards,

    Harshit Rakholiya

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 10, 2017 at 06:49 AM

    Dear All

    1) I have already set the Block Negative Inventory setting. and also the document was GRPO, so no possibility of the -ve quantity.

    2) The Base document purchase order and GRPO had same price, quantity, only Exchange rate are different (66.6645 in Purchase Order, 68.5185 in GRPO.) and Valuation method for that item is Standard. so i think there is no issue of price difference.

    3) Also i found that the G/L account 1030202-9501-95 - RAW MATERIAL INVENTORY IMPORT was selected in both GRPO and base document Purchase order while adding is same. but why Variance Account RAW MATERIAL VARIANCE IMPORT (FCR - STR) is selected in the JV.





    The setting of Block Negative inventory is already selected. and also document is GRPO, so no question of -ve inventory.

    In the GRPO, also the selected G/L account is Raw Material account, but the whole amount has posted against Raw Material Variance Account while posting the JV. and latter there was not any changes in that document .

    There was not any changes related to price in base document and GRPO (only USD conversion rate is changed from rs 66.6645 to rs 68.5185

    so i didn't think that there is issue of price difference.

    i think any other reason for this ?

    Add comment
    10|10000 characters needed characters exceeded