[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?