I would like to run something by you- least to say I am not sure about anything re the coa. The situtation is:
When our sage was set up back in 2003 by the Accountant the default nominal codes of sage were not used. It appears they have made up most if not all of their own. Since 2003 there have been a few upgrades to sage- of which we are using sageL50 2010 (I think its v11 or 12).
The firm have now switched over to a new programme for purchase ordering and sales ordering, that will automatically be put over to sage. (have been told the programme was modelled on sage)
The problem is: Our Sage uses Sales NC as 0650 and Purchase NC as 0730. Basically all other NC are used up to 1399 , then vat liability comes in at 2202 and for some bizarre reason we have the nc77(something) as variable exchange rate- we do not do any foreign transactions.
The new sales order/purchase order system uses the sage default nominal codes i.e. 4000 sales and 5000 purchase. They are formated as number fields and cannot be altered to start with a 0 (zero).
I have been reading the sage v12 book which states you can add (edit) nc in a particular field (i,e sales type 1/type2 etc) as long as they are within the range. It also states it is preferential to keep to standard set of 4 numbers throughout.
By adding a nominal code to the sales would mean starting with a 1 (not a zero). 1650 would this work
Help ! I am open to suggestions as this is causing me several concerns regarding P&L TB etc - No only that all the customer accounts are set to 0650 sales - and does this interfere with any vat accounting (we are towards the end of a vat quarter.
Am I being paranoid?
Thanks
-- Edited by twiglet on Friday 22nd of February 2013 07:39:38 PM
There will be some mapping involved but I would have thought you could speak to the providers of the purchase and sales ordering system to amend their software to map the correct codes?
__________________
Phil Hendy, The Accountancy Mentor
Are you thinking of setting up your own practice or have you set up and need some help?
If so a mentor may be the way forward - feel free to get in touch and see how I can assist you.
I have already spoken to them. I can go in and amend their nominal code, but as stated the format is a number and cannot start with a zero. I can enter our nominal code as 0650 but it only imputs 650. They have said they cannot change it and that they have had no other clients where this is a problem. I need to speak to my boss and let him deal with this.
Obviously, the only people that can see and change their software is them, because only they have access to their source code - but where they've said they "cannot" change it, I think they mean they "do not want to" change it, because there should be absolutely no "cannot" about it, unless their software is really, really badly written and their programmers are... a bit rubbish.
I do wonder what the thinking was behind setting Sage's nominal codes up the way they have been - but the real point is that Sage is versatile enough that the codes can be set up like that, and it will happily cope with it provided all the related configuration (eg the COA) is set appropriately, so any software designed to work with Sage should be equally versatile about its nominal coding.
__________________
Vince M Hudd - Soft Rock Software
(I only came here looking for fellow apiarists...)
I've spoken to my boss who assures me today that he has it all sorted out- keeping my fingers crossed.
And yes I agree with you, as the programe is a 'Data Base' on set up they 'set' the fields as a 'type' ( text, date,number etc) there should be somewhere to re-format the fields, either by them or the end user, but I'm only a pleb where computers are concerned.
Sorry, I didn't answer the other question: odd nominal codes in the first place. I presume the previous purchase order/sales order software used the codes of 0650 and 0730 and our Sage was adapted to suit them.
