Skip to main content

Notifications

Announcements

No record found.

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

Transfer orders not reflecting value on BS

(1) ShareShare
ReportReport
Posted on by 5
Hello!
 
In Navision 2018, we have multiple locations for our field service engineers. When we transfer parts to their virtual warehouse in NAV, the transfer orders net to zero and remove the value from the asset inventory account. While the inventory valuation still reflects the value at these locations, a discrepancy has emerged between the inventory valuation and the asset inventory accounts because the transfer order has eliminated the value from the balance sheet. Where is the disconnect in the system? Any thoughts are welcomed!
 
Thank you in advance for your time.
  • JG-21012024-0 Profile Picture
    JG-21012024-0 5 on at
    Transfer orders not reflecting value on BS
    @Valentin Castravet  All of them are assigned the same inventory G/L account. When I drill down on the transactions that account for the $3.4M value reflected in the valuation but not on the balance sheet, they are all transfer receipts. At the time of transfer, there is a debit and a credit to the inventory account, but the value at these virtual warehouses isn't being reflected on the balance sheet. 
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 25,284 Super User 2024 Season 2 on at
    Transfer orders not reflecting value on BS
    Are your virtual warehouses in NAV linked to the same asset account in the balance sheet? Or are they linked to another G/L Account? Perhaps that's where the disconnect is. Your regular locations are linked to the asset account, but the virtual warehouses are linked to another G/L account.
     
     
     
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 76,009 Super User 2024 Season 2 on at
    Transfer orders not reflecting value on BS
    Hi, you can try Inventory - G/L Reconciliation, this allows you to see the differences, and drill down.
     
    PS:
    Why Your Inventory Valuation Does Not Match the Inventory Account on the General Ledger
     
    Hope this helps.
    Thanks.
    ZHU
  • JG-21012024-0 Profile Picture
    JG-21012024-0 5 on at
    Transfer orders not reflecting value on BS
    @Valentin Castravet This is the first step I took and it looks great. My issue is that when I generate my inventory valuation report, it shows a total of $12.8 million, which accurately reflects the inventory on hand. However, the asset accounts on my trial balance only show $9.4 million, with the difference of $3.4 million not being accounted for by transfers at specific locations.
     
    Let me know your thoughts.
     
    Thank you!
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 25,284 Super User 2024 Season 2 on at
    Transfer orders not reflecting value on BS

    Can you go to the Posted Transfer Receipt and Posted Transfer Shipment page? (If your posted transfers only create one document, go to the Posted Direct Transfer page instead.) From there, focus on one transfer order, and click on Find Entries and review the G/L Entries.

    When you transfer an item, the system posts the following entries to remove the item from one location:

    • Dr Inventory Adjustment (Income Statement)
    • Cr Inventory Account (Balance Sheet)

    When the item is moved to the other location, the system posts these entries:
    ​​​​​​​

    • Dr Inventory Account (Balance Sheet)
    • Cr Inventory Adjustment (Income Statement)

    Review the documents and these G/L entries that I mentioned, everything should line up correctly.

    If both locations use the same inventory account on the balance sheet, there won’t be any change in the balance sheet. The item value remains in the same account—you first remove it, then add it back.

    However, if the two locations use different inventory accounts on the balance sheet, the item value will move from the inventory account tied to the first location to the inventory account tied to the second location.

     

    Valentin Castravet
    Work: Zander ERP Services
    Blog: Dynamics 365 Business Central Insights
    LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,488 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans