I've founded some nominal codes on the wrong range (ie Agent Fees is 1003) so I'm not able to create reports as P&L, Balance sheet etc. because this problem affects the COA.
The COA is still [PARTIAL] and it MUSTN'T be like this.
I'd like to ask what should I do to fix this terrible situation and also, I have all data inside of Sage so I'm not able to delete and start all of this again.
This isn't a show stopper. You can just create an entry to hold 1003 in the P&L COA definitions. Obviously, you then need to exclude it from the current COA category (Current Assets) and sub-category (Stock) which will probably be defined as covering range 1000 to 1099.
You'll need to use the COA checking facility to make sure the [PARTIAL] suffix is removed after you're done.
We have a surprising number of clients asking about our COA re-mapping capabilities (for example, where they have a non-contiguous range of codes that they want to report as a single sub-category). You are not alone with awkward COA issues in Sage.
Another solution would be to create new codes in a more logical range and journal from 1003 to the new code. However, I think you're ruling this out as an option in your post.
I've tried yesterday to solve these problems but my COA is still [Partial]. I decided to put nominal codes under the right category fo the P&L so, as an example, my agent fees nomial code (1002) went under the Direct Expenses but when I did a check I saw lots of errors on report as "one of the following ranges is enclosed within the other range: Overheads, Salaries and Dividend,1000/ Current Assets 1000-1999"
I think it is telling you that some of your ranges are included twice. For example if you have one line in the P&L under direct expenses that is defined as from 1002 to 1002 and another line in the Balance Sheet definitions under current assets that is defined as 1000 to 1009 then 1002 is in both ranges and Sage will complain. The secret is to investigate the error/warning messages that Sage gives until they all go away. There may be more than one problem. From the error you have shown it looks like you have a P&L item called Salaries and Dividend defined under Overheads that contains code 1000 and your Balance Sheet Current Assets also cover 1000 to 1999 - so 1000 is covered twice.
Hi Boris
As Ian rightly says it looks like you may have some duplications. The 1000 - 1099 range is set by default in sage as Stock in the Balance sheet so if you need to strip part of it out now for the P&L you need to add the code to the P&L, then adjust the Stock lines in the Bal Sheet to show anything on either side that is to remain in the balance sheet.
Did you choose your nominal code for agents fees from your nominal list? As 1002 is normally for WIP. The nominal list page may confuse a little with some of its titles - generally down to about 4000 its all the Balance sheet codes, followed by P&L. The easist wasy to check where they sit and will report is by checking via the COA button. I would suggest if you need any other codes that you try to keep to the P&L and Balance sheet ranges as set up in sage, as there is plenty of flexibility within these number ranges to create new nominal accounts. Eg your Direct expenses codes should be retained within the 6000 - 6999 range. This is listed on the COA page as P&L---> Direct Expenses - then shows the high and low numbers by default.
As always - back up sage before you start, have a play with it, do your 'check' option and ensure it is right before inputting anything else, so that you can restore if you go wrong. You can still do this now as you try to sort matters.
HTH
__________________
Joanne
Winner of Bookkeeper of the Year 2015, 2016 & 2017
Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.
You should check out answers with reference to the legal position
