Hello All,
I was unapplying some customer entries and during that time I came accross the unapplied entries of customer being inserted into the gl entry table.Is that default in NAV ?
*This post is locked for comments
NAV will create G/L Entries when applying Customer/Vendor entries only in two cases:
1) If the entries beeing applied have different dimensions and/or
2) If applying generates realized currency gain/loss.
In any other scenario it will not create G/L entries as far as I know.
Sulav,
The application of customer/vendor ledger entries indeed generate G/L transactions. It can be matching of the prepayments accounts, calculation and posting of realized currency exchange gains/losses between the payment and the invoice, and others, depending on your localization.
Unapplication of transactions would generate same transactions, but reversed. You are not able to delete those transactions on a user level; it is not recommended to modify the transactions in GL ledger in order to huge risk of loosing data integrity.
I can understand that if you many times applied and unapplied some transactions, it would be resulted in garbage G/L transactions, but this is how the system works.
Having those transactions in place will show you the history of the postings.
Hi. Sulav
This is the Nav Standard way of How Apply & Unapply Transactions are handled don't look it from one angle Think about scenario where you have forex transaction and during the application entry system will calculate the Realized Exchange Gain & Loss Wich Need to posted to the G/L As well.
So Blocking these entries posting to the System means you are trying break Nav Behaviour and later on you will have a lot of problems. if you really need hid these entries the look for the System Created Tick with Sorce Code and try the best possible combination to filter on the view only rather than trying stop posting.
Thanks
Indika.
Actually,I want to hide all the applied and unapplied entries from the g/l entry table and also is there any way not to pass those entries in the g/l while either applying or unapplying entries for both customer and vendor
When you unapply an erroneous application, correcting entries that are identical to the original entry but with opposite sign in the amount field are created and posted for all entries, including all general ledger posting derived from the application, such as payment discount and currency gains/losses. The entries that were closed by the application are reopened.
It is normal behaviour of Navision functionality.
Hi Sulav
Not only UnApply Entry but also Apply Entry will Create entries on G/L Entry Table. What is your exact requirement, if you explain we can provide better answer.
thanks
Indika
So,Is there any way to hide those unapplied entries from general ledger entries page.
Hi,
Yes this is Standard in NAV.
You apply general ledger entries to justify ledger balances on asset and liability accounts. For example, you can apply transactions on the bill of exchange accounts to get a clear picture of which bills make up the balance of the account.
Applying Entry is a balancing Act in NAV...
---------------------
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Saurav.Dhyani 2 Super User 2025 Season 2
RK-25090803-0 1
