Skip to Main Content
Sage 200 UKI Ideas Portal
Status Idea Accepted - Gauging Support
Created by Rustum Khedkar
Created on Mar 13, 2017

Additional Control Ledger Nominal Accounts for Sales/Purchase Ledger.

Addition to default Debtor / Creditor control Nominal Account, some customers have asked to allow them to assign a separate NL Control Account at Supplier / Customer account level. By default Customer/Purchase Account will have default debtor/creditor Nominal Codes assigned. But if customer choose to create a separate NL code based on Trade Type with Sup/Cust then they want this flexibility to assign a separate NL code to customer / sup account level as NL control account.

  • Marek Tonderys
    Reply
    |
    Jan 25, 2024

    With the additional Nominal accounts for the sales/purchase ledger, you could also create dedicate nominal control account per currency and when you do a foreign exchange revaluation at the end of the month, you know the which ledger account have been impact by this. Current the single nominal ledger has tens of thousands of transactions is a single month and splitting it would make it easy. Right now I am spending to much time data dumping and reconciling multiple ledger reports to balance back the nominal account to the TB closing balances.

  • Geoff Turner
    Reply
    |
    Jan 24, 2024

    True, the CC/Dept will also be used for the VAT control accounts. That may actually be useful to enable reporting on VAT by trade type. If not, the VAT transactions table (SYSTaxTran) does not have the CC/Dept

  • Admin
    Jo Kirkup
    Reply
    |
    Jan 24, 2024

    Making the above change noted by Geoff would impact other accounts not just the debtor and creditors control.

  • Geoff Turner
    Reply
    |
    Jan 24, 2024

    If the "Trade Types" in the suggestion can be set as cost centres, then this can already be done using the "Split postings between cost centres..." option in system settings, and setting "Use Specified" to No for the control accounts in NL Default Accounts.

    See https://desktophelp.sage.co.uk/sage200/professional/Content/NL/MaintainDefaultNominalAccounts.htm

2 MERGED

Can the Purchase ledger and all related functions of the purchase ledger be duplicated and renamed, also linking to it's own control account i.e. LA = Leasing agreements

Merged
We have numerous leasing agreements across all department, cost centres and managing these agreement via an external software. As we need to report leasing cost separately in the P&L, if each lease agreement was captured as it own account ledg...
Marek Tonderys almost 1 year ago in Purchase Ledger (Suppliers) 2 Idea Accepted - Gauging Support
1 MERGED

Sage 200 - Ability to run 2 Sales Ledger

Merged
Client would like to be able to run 2 separate Sales Ledgers in Sage. The ability to split the Sales Ledger for different divisions/branches not just department split - actually run 2 different Sales Ledgers with different control accounts etc
Guest over 1 year ago in Aged Debtors 0 Idea Accepted - Gauging Support