Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals

Sales invoices mapped to 1102, instead of 1100

Sage 50 general help forum - Free help and support for all general issues
Post Reply
JonesA18
User
User
Posts: 6
Joined: 29 Jun 2016, 14:45
Sage Version: v2015 21 UK/Europe/Africa

Sales invoices mapped to 1102, instead of 1100

Post by JonesA18 » 31 Jan 2019, 01:25

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!

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4619
Joined: 28 Feb 2006, 09:56
Sage Version: v28 UK/Europe/Africa

Re: Sales invoices mapped to 1102, instead of 1100

Post by brucedenney » 31 Jan 2019, 08:26

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.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

JonesA18
User
User
Posts: 6
Joined: 29 Jun 2016, 14:45
Sage Version: v2015 21 UK/Europe/Africa

Re: Sales invoices mapped to 1102, instead of 1100

Post by JonesA18 » 31 Jan 2019, 10:01

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

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4619
Joined: 28 Feb 2006, 09:56
Sage Version: v28 UK/Europe/Africa

Re: Sales invoices mapped to 1102, instead of 1100

Post by brucedenney » 01 Feb 2019, 12:33

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..
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

Post Reply

Who is online

Users browsing this forum: Ahrefs [Bot], Google [Bot] and 22 guests