Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Restriction on dimension in item reclassification journal

Posted on by 421

I have created locations as a dimension.

I want to issue item through item reclassification journal.(negative adjustment).

On hand inventory available but there is no inventory available in location(dimension). How can system restrict to issue the inventory in such case.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,339 Super User 2024 Season 2 on at
    RE: Restriction on dimension in item reclassification journal

    Hi, I agree with Nitin, in this case you need to do some customization, otherwise it is only human control.

    Because there is no quantity in Dimension, I am not sure what is the purpose of adding Location to Dimension. You need to calculate it in Item Ledger Entries based on the value of Dimension (Location) and Item No. every time.

    Hope this helps.

    Thanks.

    ZHU

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Restriction on dimension in item reclassification journal

    Your inventory is not being recorded on a dimension level only on a item no. and Location number if you chose to use locations in you setup. The dimensions are there for financial reporting purpose and not for keeping physical inventory.

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,091 Super User 2024 Season 1 on at
    RE: Restriction on dimension in item reclassification journal

    In that case you need to write your custom logic.

  • RE: Restriction on dimension in item reclassification journal

    I need for dimension wise.

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,091 Super User 2024 Season 1 on at
    RE: Restriction on dimension in item reclassification journal

    You can make TRUE this into Inventory setup page, to prevent negative inventory, but it will not work dimension wise.

    pastedimage1678790160353v1.png

  • RE: Restriction on dimension in item reclassification journal

    Dimension already mandatory.

    But how can we prevent negative inventory in dimension.

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,091 Super User 2024 Season 1 on at
    RE: Restriction on dimension in item reclassification journal

    Hi,

    You can go to the Item card > Dimension and on Dimension page, you can choose that particular location as code mandatory option. See if it helps you.

    pastedimage1678789438816v1.png

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans