“`html
When you set up inventory opening balances in Business Central, the item journal automatically posts amounts to your inventory G/L accounts. This creates entries you do not want when you are about to enter your G/L opening balance.
The solution is to post your inventory through the item journal first, write down the amounts Business Central posts to the chart of accounts, and then reverse those exact amounts using a general journal. This resets your G/L to zero while keeping your item ledger entries intact.
Do the inventory opening before the G/L opening balance. That way you can verify everything balances to zero before you enter your opening balances as the final step.
Watch out for item costing methods. Standard cost items lock the unit amount, while FIFO and LIFO items require you to enter the unit amount correctly. Lot-tracked items need item tracking information such as lot number and expiration date.
Why post inventory openings before the G/L balance
The recommended order is to create your inventory openings first, then your G/L opening balance. The reason is straightforward: once inventory is in place, you can check that everything nets to zero and open your balance cleanly.
Inventory openings use the item journal, while the G/L reset happens in the general journal. These are two separate steps, and understanding how they interact is what makes the process work without leaving stray postings behind.
Checking the starting point
Before you begin, confirm where you stand. In a fresh setup the items already exist in the system but inventory is zero on all of them. If you look into the chart of accounts and drill into the entries, there should be nothing there. You can filter on entries with a value different from zero to confirm no accounts hold any postings yet.
Posting inventory openings in the item journal
Open the item journal and use a positive adjustment to bring inventory in. Enter a document number such as “Open Inventory” so the opening is easy to recognise later. For each line, enter the item number, the location code, and the quantity you want to open.
If the same item exists across several locations, create one line per location code.
Handle costing methods correctly
The unit amount behaves differently depending on the item’s costing method.
- Standard cost items: You cannot change the unit amount. The system uses the standard cost and you get a validation result.
- FIFO and LIFO items: You can change the unit amount, and you need to enter it correctly because the cost flows with the inventory.
- Lot-tracked items: You must enter item tracking from the item tracking lines on the journal line. Set the lot number and, where relevant, the expiration date so everything posts correctly.
Getting these details right at the opening stage avoids costing problems down the line.
Posting the full inventory
Once your lines are ready with the correct quantities, locations, and tracking, post the journal. This places every item into inventory on the correct location with the correct lot numbers. At this point your inventory is in good shape.
The catch is in the chart of accounts. Posting the item journal creates a set of adjustments on the inventory accounts. Business Central populates all your inventory G/L accounts with these postings. Since you want to open those accounts with your opening balances as the very last step, you need to clear these automatic postings.
Resetting the G/L with a general journal
To reset the postings, write down all the amounts Business Central created on the inventory accounts. Note every figure across the different accounts. Then go into the general journal and create an opening journal for inventory that reverses those exact amounts.
If you are doing this in a live company, run it as a test first and write down the numbers before you commit. Pay attention to the sign on each amount so the reversal lands correctly.
When you post the general journal with these amounts, the chart of accounts goes back to zero. You now have a chart of accounts that is reset and ready for an opening balance, while your inventory is fully populated and your item ledger entries are correct with lot numbers and locations.
Q&A
Should I create inventory openings before or after the G/L opening balance in Business Central?
Create inventory openings first. Posting the inventory through the item journal lets you verify everything balances to zero, and then you enter the G/L opening balance as the final step.
Why does posting the item journal create entries in the chart of accounts?
A positive adjustment in the item journal posts cost amounts to your inventory G/L accounts automatically. These appear as adjustments on the inventory accounts, which you then reverse with a general journal so the G/L is clean before your opening balance.
How do I clear the inventory postings the item journal created?
Write down every amount posted to the inventory accounts, then create an opening journal in the general journal that reverses those exact amounts. After posting, the chart of accounts returns to zero while the item ledger entries remain intact.
Can I change the unit amount for any item when posting an opening?
No. Standard cost items lock the unit amount and give a validation result. FIFO and LIFO items let you change the unit amount, and you must enter it correctly so the cost flows properly.
What do I need to enter for lot-tracked items during inventory opening?
You must open the item tracking lines on the journal line and enter the lot number along with the expiration date where it applies, so the opening posts correctly.
“`