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.