To reconcile inventory and capacity ledger entries with the general ledger, the related value entries are posted to different accounts in the general ledger. From the Inventory Ledger The below table shows the relationship between different types of inventory value entries and the accounts and balancing accounts in the general ledger.
Tag Archives: Ledger
Customer/Vendor ledger entry wrong Amount, Remaining Amount in NAV 2015
It has been noted as a bug in NAV 2015 where Customer/Vendor Ledger Amount, Amount(LCY), Remaining Amount and Remaining Amount(LCY) flowfields are calculated wrongly. This case only if there is adjustments posted for foreign currencies.
How to Mark General Ledger Accounts for Reconciliation
Have ever look for a option in Microsoft Dynamics NAV to reconcile the cash accounts or any other liquid accounts before posting the transaction to the ledgers?
If you have, then you need to activate the Reconciliation Functionality in the Chart of Accounts. Reconciliation option in the General Ledger Account allows you to see the current balance, and the balance that will be after porting the transaction.
Assembly Order Posting to General Ledger
I have previously described how production orders are posting into the general ledger which I have received a lot of positive feedback on. This time I will described how assembly orders are posting into the general ledger in Microsoft Dynamics NAV (which is a lot simpler).
Inventory to GL Reconcile SQL Report
Here is the sql report for Inventory to GL Reconcile Report. For Large customers the report probably is running out of memory or taking too long to run.
The Inventory to General Ledger Reconciliation Report in Microsoft Dynamics NAV
The Inventory to G/L reconciliation effort in some com[current-page:url:absolute]panies can be challenging. The Inventory to G/L Reconciliation Report in Dynamics NAV makes the effort quite easy (or should I say a lot less difficult).
Activate Item Tracking for Items with Ledger Entries
A common request is to activate item tracking (lot numbers and/or serials numbers) for items that already have transactions (item ledger entries). In Microsoft Dynamics NAV you can’t really do this without going ‘behind the scenes’ and tweaking the data.