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

Community site session details

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

G/L Entries behind Items Transfer orders

(0) ShareShare
ReportReport
Posted on by 281

Dears, I did not work much with Inventory and while learning it, I discover in Cronus the transfer order hits this G/L account (Income Statement Accounts)

I see financially it's just a transfer between two locations, which should hit only a Balance sheet account.

Normally, when we ship items we debit a Current asset account ( Contra account) and once it's received in the other location it will be cleared

pastedimage1666248892022v2.png

I feel something may be missing in another setup area.

Thanks for your help

I have the same question (0)
  • MZ-25061431-0 Profile Picture
    3 on at
    G/L Entries behind Items Transfer orders
    Dears, I have one question here !!
    For the transfer orders, if we have an in-transit location that has its inventory posting setup on a balance sheet GL account, why do the GL entries take the GL account from the general posting setup "Inventory adjustment account" ?
  • Suggested answer
    Dallefeld Profile Picture
    193 User Group Leader on at
    RE: G/L Entries behind Items Transfer orders

    Best practice says that only two columns in your General Posting Setup should be balance sheet accounts. These are COGS Interim and Inv Accrual Interim. Your Inventory Adjustment Account should not be balance sheet.

  • Hasith-Auwion Profile Picture
    20 on at
    RE: G/L Entries behind Items Transfer orders

    No. It will affect item journal and physical inventory journal postings. For example, if you post a negative adjustment in an item journal, entries are,

    DEBIT - Inventory adjustment account (mapped in general posting set up)

    CREDIT - Inventory account (mapped in inventory posting set up)

    In this entry, inventory adjustment account is picked based on gen. bus. group of item journal line and gen. pro. posting group of item. And usually when you post a negative adjustment, it should be debited to a P/L account as loss of inventory is an expense to company.

    Let's assume you map a balance sheet account as inventory adjustment account. If a user forget to update the gen. bus. posting group when posting an item journal, then system will debit the amount to the balance sheet account you mapped as adjustment account which is not correct.

    I hope you understand what I meant.

  • mahmoud_algindy Profile Picture
    281 on at
    RE: G/L Entries behind Items Transfer orders

    Thank you,

    I've seen that the system exactly created all entries you've mentioned.

    I noticed some words in this statement:

    Inventory adjustment account is mapped by empty General Business Posting Group (because in transfer order, there is no gen. bus. group field in header level) and items' gen. pro. posting group combinations in general posting set up.

    It means I can change it to another G/L accounts, let say a Balance Sheet Accounts, and it will work only for Transfers?

  • Suggested answer
    Hasith-Auwion Profile Picture
    20 on at
    RE: G/L Entries behind Items Transfer orders

    When you post a transfer order (Ship & Receive), 8 entries are posted in NAV/BC if it is an indirect transfer.

    1. When you ship

           Debit - Inventory adjustment account (mapped in general posting set up)

           Credit - Inventory account linked to 'from location' (mapped in inventory posting set up)

           Debit - Inventory account linked to in-transit location (mapped in inventory posting set up)

           Credit - Inventory adjustment account (mapped in general posting set up)

    2. When you receive

           Debit - Inventory account linked to 'to location' (mapped in inventory posting set up)

           Credit - Inventory adjustment account (mapped in general posting set up)

           Debit - Inventory adjustment account (mapped in general posting set up)

           Credit - Inventory account linked to 'in transit location' (mapped in inventory posting set up)

    Inventory adjustment account is mapped by empty General Business Posting Group (because in transfer order, there is no gen. bus. group field in header level) and items' gen. pro. posting group combinations in general posting set up.

    Inventory accounts are mapped by location code and items' inventory posting group combinations in inventory posting set up.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sumit Singh Profile Picture

Sumit Singh 3,165

#2
Sohail Ahmed Profile Picture

Sohail Ahmed 2,682 Super User 2025 Season 2

#3
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,299

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans