Skip to Main Content
Sage 200 UKI Ideas Portal
Status Idea Accepted - Gauging Support
Created by Guest
Created on Jan 15, 2019

Default Nominal Accounts - Ignore Cost Centre and Departments

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

  • +1