[ASM-System-System Settings] allows you to set 'Split postings between cost centres for Balance Sheet accounts'
And then further controlled in [Nominal-Utilities-Ledger Setup-Default Nominal Accounts] for Creditors' and Debtors' Control Accounts.
I would like to extend the functionality to ALL Balance Sheet and Profit & Loss Default Accounts by adding the following control;
When any posting is made to a Default Nominal Account; If the nominal code + Cost Centre + Department combination does not exist (E.G. VAT Input 15100 SAL VAL) a new setting in 'Default Nominal Accounts' would determine where the transaction is posted.
'Post to Top Level Nominal Account' tick box per account. (this could replace 'Use Specified')
If ticked a transaction would be posted to top level Default Nominal Account (E.G. VAT Input 15100)
or
If unticked Post to Suspense Nominal.
EG
With System Settings for Split Bal Sheet Accts 'Ticked' and Defaults Use Specified set to 'Yes' for Creditors' & Debtors' Control. Below are the postings for a Purchase Invoice:
Code | Cost Centre | Department | Name | Date | Debit Value | Credit Value | Reference | Narrative | Transaction Analysis | URN | Source |
25100 | Creditors Control | 15/01/2019 | 0.00 | 1200.00 | Bal Test | PI / CHR001 | 27052 | Purchase Ledger | |||
15100 | SAL | VAL | Code does not exist | 15/01/2019 | 200.00 | 0.00 | Bal Test | PI / CHR001 | 27052 | Purchase Ledger | |
44100 | SAL | VAL | Materials - Purchases Resale V | 15/01/2019 | 1000.00 | 0.00 | Bal Test | PI / CHR001 | 27052 | Purchase Ledger |
So we are able to utilise the 'Use Specified' and force the Transaction to the 'Top Level Default Nominal' but the VAT Input is being posted to Suspense as the NL Code + CC + Dept combination does not exist.
In the requested functionality;
'Post to Top Level Nominal Account' for:
Creditors' Control = Ticked so regardless of Cost Centre and Department values will be posted to 25100
VAT Input = Ticked so the above entry 'Code does not Exist' would not be a factor and the entry posted to 15100
Code | Cost Centre | Department | Name | Date | Debit Value | Credit Value | Reference | Narrative | Transaction Analysis | URN | Source |
25100 | Creditors Control | 15/01/2019 | 0.00 | 1200.00 | Bal Test | PI / CHR001 | 27052 | Purchase Ledger | |||
15100 | VAT Input | 15/01/2019 | 200.00 | 0.00 | Bal Test | PI / CHR001 | 27052 | Purchase Ledger | |||
44100 | SAL | VAL | Materials - Purchases Resale V | 15/01/2019 | 1000.00 | 0.00 | Bal Test | PI / CHR001 | 27052 | Purchase Ledger |
Any thoughts?