SageForum for UK versions of Sage 50- Help and support.

I've got a list of customers' sales invoices that are to be mapped to Other Debtors 1102, instead of Debtors Control Account 1100 (which is the nominal code where all Sales module is mapped); Should I use an import Audit Template to upload these as I cannot go through Sales invoice module? If I use Sales orders, still I 've got no control in mapping to 1102, as usually does not allow me to change the control account; by default is mapped to 1100!
Your help is much appreciated!

You can not have anything in the sales ledger that is not in 1100 automatically.

The reason is that the balance of 1100 is supposed to match the ledger balance.

What you can do it do it n the ledger then journal to 1102, and then as invoices are paid journal it back.

The alternative is to journal the entries and not have them in the sales ledger.

Thanks, Bruce:) I would trial the journal alternative option but when I used the journal template Audit Trail Template, uploaded as SI, then I found duplicates posted to 1100; I think I should not use the SI as Type, but nominal transaction types JC or JD?

If i trial the other traditional Sales ledger, the effect would be for SI e.g £120
credit amt to 4005, 100
credit Sales vat Output 2200 with VAT 20

dr 1100 120
then at what stage i need to re-post the amt sitting in DR for 1100 to 11002 as other debtors as my DoF wants to see these Sales on 1102? at the time of settlement or immediately after stage 1?
Cheers
AJ

If you enter them as invoices they will go to 1100 so you need to journal from 1100 to 1102.

You do not need to worry about VAT element.

When you pay the invoice you reverse the journal.

The balance of 1100 plus 1102 should reconcile to the Ledger instead of just 1100 matching, this will create a warning, but you know what it is and why so it is not an issue..