Sage 50 UKI Ideas Portal

Import Purchase Invoices Error Control Account Issue

When importing PI purchase invoice transaction types for 1000s of lines of data when setting up sage 50 mid way through financial year, and error message appears "Nominal A/C Ref: Bank or Control account nominal code not permitted".

Solutions 1 that is not acceptable - on website and help desk is "change nominal code". That is not a solution, invoices or there values need to be posted to purchase ledger account for accounting purposes/creditor reconciliation.

Solution 2 that is not acceptable - manually key in journal (i have 20,000 lines, not reasonable solution)

Solution 3 that does not work - change control account nominal to a non control account post journal and then change back- system does not allow change of purchase ledger control account.


Solution required: We need a upload template that hits the purchase ledger supplier account, the purchase ledger control account, the purchase vat control account and the standard P&L or expense nominal account.

Alternative solution is to use error nominal code 9998 for the purchase and vat amounts. Then journal values to the creditor & vat control accounts by month (as need accounts by month) if the control accounts accept journal transaction type.



  • Guest
  • Feb 8 2024