I was attempting to enter a new product on Sage. In the Product Record Wizard, as you type in the name of a new product the Wizard has a "Code" box that automatically fills up with the full name of the product as you type. If you don't want that you are meant to overtype it with the code number.
I pressed "Save" too soon and forgot to overtype it with the code number.
Now I can't seem to change the product record - if I try to edit the product code, it creates a second, new record with the correct code but leaves the old record (with its opening balance of stock recorded on it) in place. If I try to delete the entire product, the system sends a message saying, "Not all the records selected could be deleted".
How can I blast this stupid product record into oblivion?
hi, sorry but hope i have understood the query. If you mean the incorrect wording please go to Company / nominal ledger. Highlight the code and double click to open up record (or press record) Here you can amend the wording. If you have created an incorrect code - as long as you have not entered on the code you can highlight and delete record.
__________________
Donna Curling - Complete Book-Keeping Ltd (CBKLtd) - 07939 101900
I don't think that editing the nominal codes will help, because my problem is specifically with the Products module. (Although I seem to remember being told on my Sage course that a similar problem can arise with Customer codes and Supplier codes.) The problem is that I can edit pretty much anything on the record EXCEPT the product code, i.e. I can edit the cost or the sale price by calling up the record and altering it, but when I try to edit this code it won't accept the alteration.
That's what I did, Semsley and it solved the problem. But I wasn't half frustrated with Sage - all that typing in wasted just because I got one little code wrong.
What makes it worse is that the system automatically assumes that the code you will use is just the full name of the product in capitals. Surely that can't be common?
What happened to me is that I originally deleted the automatically generated "full name" code and overtyped the right code. Then, unfortunately, I decided to slightly change the full name of the product to make it more obvious to other users. And that caused Sage to wipe out my product code and revert to just having the full name in capitals as the code! Fat lot of use that would have been to anyone searching!
Thanks to all who replied, as ever, for spending a little of your precious time on someone else's problem.
Tom, in principle it seems it should be possible. When I googled versions of "can't delete" "Sage Line 50" and "product code" I got answers saying to do something on those lines.
I also got evidence that I am not the first person to have this problem !
However when I tried to set the amount in stock to zero and delete the record, I kept getting a message saying:
The selected record could not be deleted.
POSSIBLE REASONS:
1. Items still in stock
2. Stock code(s) still have Transactions.
3. Stock code(s) are possible sub-component(s).
To clear stock transactions run Clear Stock option in Period End.
I don't understand why I kept getting this message, as I had set items in stock to zero, and there had never been any transactions and there had never been any question of the products being sub-components of anything. After backing up I did run the Clear Stock option, but got the same message.
Although I have solved the immediate problem by restoring an earlier version of the program, I would still like to know what I am doing wrong for the future. It is very irritating that it seems so difficult to delete a product, or to change the product code. Any advice welcome!
-- Edited by chatcat on Tuesday 8th of November 2011 09:36:29 AM
I know this thread is a few days old now, but I thought I would add an update for the benefit of anyone searching for a similar query.
Although I had managed to solve my major problem, at odd moments I repeatedly tried deleting a little-used record in order to find out what was going wrong. I altered the stock balance to zero and run stock clearance at period end as suggested by Tom McClelland above, but no luck at first. I tried doing the same things in several different orders and kept getting that stupid message.
Eventually though, I hit on the right combination and suddenly - silently - the record was gone. I had got so used to that annoying "beep" and the Message Of Evil that it took me by surprise. Unfortunately I had got so frustrated when trying out my various combinations of strategies that I failed to follow my usual procedure of writing down exactly the variables with which I was trying it this time. So I don't know quite what I did.
I think what made it work this time was that I had set the date of the stock-take to the day I had created the record and the date of the Clear Stock option as today's date. This suggests that somehow, probably by a keying error, I had set a transaction as having occurred between those two dates. No transaction on this product had in fact ever occurred, which is why in previous attempts I had set the Clear Stock day as either the day I created the record or (following one of my better hunches but I didn't go far enough forward) the day after.
Anyone who comes across this post, i think i solved it. I was getting the same errors as above, ie:
The selected record could not be deleted.
POSSIBLE REASONS:
1. Items still in stock
2. Stock code(s) still have Transactions.
3. Stock code(s) are possible sub-component(s).
To clear stock transactions run Clear Stock option in Period End.
You have to go into each product that you cant delete, click on the BOM tab and delete any lines that are in there by pressing F8 on each line. Save. Now you should be able to delete it. This worked for me but i cant say for definite that it will work for everyone.
!
