Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Inventory Accounts setup
Microsoft Dynamics GP (Archived)

Inventory Accounts setup

(0) ShareShare
ReportReport
Posted on by babubaskaran@outloo...

Hello There,  

some of the P&L and Liability accounts in error has been assigned to some of the inventory item class accounts. I couldn't find which class so that I can correct.  Basically when I run HITB it has all inventory accounts as well as some other non inventory account, so I assume some of the Inventory item accounts has been assigned with wrong GL(P&L and Liability account).  Does anyone one know how to find a particular account assigned to which item class.  Any suggestion will be helpful for me.

thanks,

Babu

*This post is locked for comments

  • Albert Quezada Profile Picture
    Albert Quezada 95 on at
    RE: Inventory Accounts setup

    Kind of similar situation here, I'm trying mapping inventory GL's accounts to items in multiple locations across GP how can I do that? Is the site (ex. 1410-00-21-000) (21 **being the site) in the GL account driving how the GL accounts are hit in GP?

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Inventory Accounts setup

    If you simply follow the instructions provided above, you should be on the safe side.

  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... on at
    RE: Inventory Accounts setup

    Hi Mahmoud,

    I am sorry still I haven't identified this problem since the data is big.  But when we run the HITB to overall total of that is almost agreeing to the GL balances.  I need to find a way of query to investigate this further.  I will let you know soon, let me know if you have any recommendations.

    thanks,

    babu

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Inventory Accounts setup

    Dear Mr. Babu

    Any update on this case ?

    Please provide us with your feedback for further assistance

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Inventory Accounts setup

    Hi babu,

    I often see the 'damaged'  account mapped to an expense account. As this is a status rather than an income or loss, it really shouldn't be mapped directly to P&L for purposes of the HITB reset.

    Also, perhaps already mentioned, don't forget to check your company posting account setup - an account may be defaulting from there.

    Kind regards,

    Leslie

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Inventory Accounts setup

    Assuming the ultimate goal is to get all of your items assigned with the correct GL accounts, I would make sure all items are assigned to an item class and that the GL accounts assigned to those item classes are correct. If you then want to roll down these GL accounts to all items follow these steps:

    1) Pull up an item class that is assigned to items and make note of the GL accounts

    2) On the item class change the GL accounts to something other that what it currently is

    3) Click Save and click Yes to roll down changes.

    4) Pull that same item class back up and change the GL accounts to the correct GL accounts

    5) Click Save and click Yes to roll down changes.

    The roll down will only change those accounts with different values so you need to change them to something else first and then back again.

    If the future you may want to create a Business Alert to send you an email when an item is setup with a GL account that varies from its assinged GL accounts in it class.

  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... on at
    RE: Inventory Accounts setup

    Hi Mahmoud, on the first query itemnumber, item description & item class i have got 24437 records and most of them has class and on the 2nd query i have got 54 records item inventory accounts different to class inventory account.  what will I do now.

    thanks,

    babu

  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... on at
    RE: Inventory Accounts setup

    Dear Mahmoud & Richard,

    Thanks for your kind reply.  Sorry for not communicating properly I dont have any accounts of balance sheet but posting type as P&L or vice versa.  My account of balance sheet inventory account as correct posting type as balance sheet.  My problem is some of my P&L account which posting type also P&L (no problem with account) but these accounts appearing on my HITB and I have check more than 6K inventory items to find which one has wrong accounts.  I will run the above query and come back with my findings.

    thanks,

    babu

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Inventory Accounts setup

    Note: This will also return items that are not assigned to any class as the value of Class_InventoryAccount will be null. Is the goal only to find the differences between items and their classes or ulimately to find transactions where there is a difference? If it is to find transactions, which transactions?

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Inventory Accounts setup

    Thanks Mr. Richard. Following to your suggestion, I provide the script below to match the inventory account of items versus their classes. it will retrieves only the dis-matched items.


    SELECT  A.ITEMNMBR,
            A.ITMCLSCD,
            A.IVIVINDX AS Item_InventoryAccount,
            B.IVIVINDX AS Class_InventoryAccount
    FROM IV00101 AS A
    LEFT OUTER JOIN  IV40400 AS B
    ON A.ITMCLSCD = B.ITMCLSCD
    WHERE ISNULL(A.IVIVINDX,0) <> ISNULL(B.IVIVINDX,0)

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans