Posting Levels in Dynamics GP – A Review
There have been many questions from many customers on the various levels of postings to the General Ledger accounts that are available in Dynamics GP. This article explains the posting levels with its advantages and disadvantages.
The level of posting to the GL accounts is determined from couple of setups that work hand in hand in Dynamics GP. The initial setup is to define the level of postings for various accounts in the Account Maintenance window from Cards >> Financials >> Accounts as illustrated below.
We can specify the levels of posting from the various series into the General Ledger module. The various options available for posting levels are
- Detail
- Summary
Once this has been setup, we need to define the level of posting for various transactions in various modules in the Posting Setup window from Microsoft Dynamics GP >> Tools >> Setup >> Posting >> Posting as illustrated below.
So for the purpose of this case study, let us create a couple of receivable invoices with the distributions explained below and save them in a batch called RECVINV.
Invoice #1
| Invoice Number | Account Number | Type | Debit Amount | Credit Amount |
| INV0001 | 000-1200-00 | RECV | $500 | $0 |
| INV0001 | 000-4100-00 | SALES | $0 | $500 |
Invoice #2
| Invoice Number | Account Number | Type | Debit Amount | Credit Amount |
| INV0002 | 000-1200-00 | RECV | $700 | $0 |
| INV0002 | 000-4100-00 | SALES | $0 | $700 |
Now, in the Posting Setup window, if we select the option to create one journal entry per transaction, posting will always be done at a detailed level (irrespective of the setting specified in the Account Maintenance window) (i.e.) There will be a one-to-one match between the distribution lines in the journal entry and the distribution that we had noted in the transaction posted in the sub ledgers.
So when the above batch RECVINV is posted in the Receivables module, there will be 2 journal entries created with the distributions explained below.
Journal Entry #1
| Journal Entry No | Account Number | Debit Amount | Credit Amount |
| 12345 | 000-1200-00 | $500 | $0 |
| 12345 | 000-4100-00 | $0 | $500 |
Journal Entry #2
| Journal Entry No | Account Number | Debit Amount | Credit Amount |
| 12346 | 000-1200-00 | $700 | $0 |
| 12346 | 000-4100-00 | $0 | $700 |
However in the posting setup, if we specify the option to create a journal entry per batch, we have two levels of roll ups that are available when journal entries are created when the sub ledger transactions are posted.
If the “Use Account Settings” option is unchecked, then when a batch of transactions is posted from the sub ledger module, the system creates one journal entry for all transactions posted in the sub ledger batch and the amounts gets rolled up for all the GL accounts in the two invoices which are posted as illustrated below.
Journal Entry #1
| Journal Entry No | Account Number | Debit Amount | Credit Amount |
| 12345 | 000-1200-00 | $1200 | $0 |
| 12345 | 000-4100-00 | $0 | $1200 |
Now let us update the account 000-1200-00 to post at a Summary Level in the Sales Series in the Account Maintenance window. Let us also setup the account 000-4100-00 to post in detail in the Sales Series in the Account Maintenance window.
If the “Use Account Settings” option is checked, then a batch of transactions posted from the sub ledger module will create one journal entry for all transactions posted in the sub ledger batch and the distribution amounts are rolled based on the posting levels for the accounts that are defined in the Account Maintenance window.
So in the same case study example above, if the batch was posted in the Receivables module, there will be one journal entry created with the distributions illustrated below.
Journal Entry #1
| Journal Entry No | Account Number | Debit Amount | Credit Amount |
| 12345 | 000-1200-00 | $1200 | $0 |
| 12345 | 000-4100-00 | $0 | $500 |
| 12345 | 000-4100-00 | $0 | $700 |
Note: Keep in mind that the various levels of postings will also be in effect only when we perform a batch posting in the sub ledger. If the posting is done at a transaction level, the system will always post in detail to the General Ledger (irrespective if the settings in the Account Maintenance window and the Posting Setup window for the specific sub ledger transaction).