Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Item Journal - Financi...
Microsoft Dynamics NAV (Archived)

Item Journal - Financial Journal

(0) ShareShare
ReportReport
Posted on by Ahmad_Safadi 373

When posting an item journal, the GL journal is basically relate to the inventory account and the inventory Adjmt Account. The inventory Adjmt

account is configured on the General Posting setup.

The item journal is used for several purposes in the company, in each case the inventory adjmt account should be changed, is there any easier way to change it according to the "Reason Code" for instance. Because it is not applicable to keep on changing the setup every time the user want to change the inventory adjmt account

7242.111.png

6683.22.png

Thanks in Advance,

*This post is locked for comments

  • Christos Christou Profile Picture
    Christos Christou 511 on at
    RE: Item Journal - Financial Journal

    Hi, I think @Robertas Rackauskas described the solution to this very nicely

  • Suggested answer
    RobertasR Profile Picture
    RobertasR 5,002 on at
    RE: Item Journal - Financial Journal

    I would create 3 more Gen Prod. Posting Groups (or use the existing ones if it doesn't affect any other part of your process), and each one would point to the different Adjustment GL Account - DAMAGE - points to Inventory Damage GL, HOSP - Hospitality expense GL, and ST-COUNT - Stock Count Expense GL.

    On the Item Journal, for each line select the relevant Gen. Prod. Posting Group (instead of or together with the Reason Code), and system will post the adjustment into the related GL.

    Robertas

  • Ahmad_Safadi Profile Picture
    Ahmad_Safadi 373 on at
    RE: Item Journal - Financial Journal

    Let me explain to you my case, and let me know how it can be achieve ...

    I have several cases for which the inventory adjustment account differs as follows:

    1- Damage (inventory adjustment account should be - Expenses/ inventory damages)

    2- Hospitality (inventory adjustment account should be - hospitality expenses)

    3- Stock count variances (inventory adjustment account should be - stock count expense)

    Thanks in Advance,

  • Suggested answer
    RobertasR Profile Picture
    RobertasR 5,002 on at
    RE: Item Journal - Financial Journal

    Hi,

    you can't automatically relate that to 'Reason Code' without additional development, however you can open the field 'Gen. Prod. Posting Group' on the Item Journal, and change its value on the line. System will pick up the related Inventory Adjustment Account.

    Robertas

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,407 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans