Open Forum

Expand all | Collapse all

Curious how users have loaded open inventory balances from NAV2005 to Business Central

  • 1.  Curious how users have loaded open inventory balances from NAV2005 to Business Central

    Posted 26 days ago
    I am curious how other users have loaded the opening inventory subsidiary and general ledger inventory balances?   Our inventory is reconciled between the subsidiary and general ledger inventory accounts in NAV2005.   I know the Item Journal is used to load with a CREDIT to Inventory Adjustment account.

    Costing Method is FIFO on the Item Cards.

    What table in NAV2005 should I used to obtain the Unit Amount values to input to the Item Journal in Business Central?

    ------------------------------
    David Cameron
    Microsoft Financial Consultant
    Templer Group
    ANCASTER ON
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Curious how users have loaded open inventory balances from NAV2005 to Business Central

    GOLD CONTRIBUTOR
    Posted 25 days ago
    Edited by Jamie Constantine 25 days ago
    This is how i do it:
    record inventory value iwth the rest of the GL ledger entry opening balance load (balance sheet will balance and inventory value is exact).  When bringing in the inventory qty and cost, you make the bal account the exact same GL account setup for inventory on the posting group setup.  (unless they truly want to value as adjustments)

    to answer your question regarding where to get the actual qty and cost that will be loaded and posted to a inventory journal  : the qty remaining and cost resides on the Value Entry table.   Because they are using FIFO , if the cost is different for records where the qty does not equal zero, then each record needs to come forward.  For example: itemABC has roughly 10 records in the value entry table where the remaining qty is more then zero.   2 records are dated in 2017 with the same cost - you can probably sum these two records together.   in june of 2018 there is a record with qty remaining of 35 and a cost of $5 per.  In july there is a remaining qty of 78 with a cost of $6 per.   blah blah...
    The point is if you do not bring over every record with its proper date and cost, then the depletion of the inventory will not follow FIFO once they go-live.


    ------------------------------
    Jamie Constantine
    Senior Consultant

    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Curious how users have loaded open inventory balances from NAV2005 to Business Central

    Posted 25 days ago
    Thank you Jamie.  You confirmed my thoughts on the Item Value table!

    ------------------------------
    David Cameron
    Microsoft Financial Consultant
    Templer Group
    ANCASTER ON
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role