Hi Andrew,

Thanks for using Community Hub.

Can I just confirm what it is that you are trying to do ?

Regards,
Stuart
Sage UKI

Hi Stuart,

I would like to be able to amend the Product Item Code without it creating two entries, i.e. original and amended Item Code, in the reports.

E.G. if I have an Item Code that was originally entered as say Product1 and it should have been entered as Product12 and a number of transactions have been processed with the Item Code as Product1 before noticing.

Last time I checked if you amended the Product Item Code to Product12 and run a Sales Revenue Product & Services Report after the amendment. you would have an entry of the sales for Product1 and the Sales for Product 12. The report uses the Product Item Code to group the report.

As the products now have a Unique ID, for import / export, is this /Can this being used in the reports for grouping, with the product item code also displayed? 

Regards

Andrew

Hi Andrew,

Thanks for using Community Hub.

Thank you for coming back to me with your response.

I have been looking into your query and testing it in my own test data and found that if you have a product set as Product 1  and there has been some transactions made using that product and realise it should be under a different Item code and then update it then proceed to do transactions under that new item code it will combine the 2 together, I checked also on the report you are running and it does combine them.

If you are looking to export details and update for example, I would make sure that the Item code you are going to use match's what is in Sage for that product so it does collaborate in Sage Accounting.

I would also take a look at our Knowledgebase article called "Import, export and update products and services" I have attached the link below
https://gb-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=222001000100914&utm_source=findbytagv2

Check out the Before you begin section and update existing products and service records

If this helps, please click Verify Answer.

Regards,
Stuart
Sage UKI

Hi Stuart,

Thank you for your reply. I will run a test and report back.

Hi Stuart,

Thank you very much. I have run a test and can confirm that we can now amend the Product Item Code with no issue when running the Sales Revenue Product & Services Report.

This will be a great help in tidying up our Product Item Codes.

Regards

Andrew

Hi Andrew,

I am happy to have helped, if you have any further questions please continue to place your questions on our Community hub or take a look at out Knowledgebase articles for the product, I have attached a link below.
https://my.sage.co.uk/public/help.aspx#/customer/support/accounting-select-region

Regards,

Stuart