Sage 100

We have a client that wants to change product lines for their inventory items. We realize that you can change the Product Line in Item Maintenance but I don't believe this will effect the detail lines for these items in AR Invoice History Detail. Can these values be changed with a VI script? I realize it will be a somewhat daunting task.

You should be able to export out the lines you want and import back in with the change. Just make sure you export Invoice, HeaderSeq, LineSeq - those are the key fields. Don't forget there are also sales order files with sales by cust by prod line - but maybe your client doesn't use that report. And open sales orders...can't remember if the prod line is stored in the lines or not, but probably so.

Why do you want to change them in invoice history detail? Reporting purposes?

I'm with Therese though. Why do you want them changed in history? If its for reporting, just link to the ci_item file and pull in the current product line.

We are trying to anticipate what would be involved and get an idea of cost vs. value in case the client wants to make the change. And yes, the only reason would be for comparative reporting purposes.

Things like exporting history, making changes and importing it back in have a risk of failure with a low chance of getting paid for all the work involved.

As @BrettLyder said above, there are easier ways to work around that if it is only for reporting. If you're not that familiar with Crystal, there are plenty of us in this group that are! Brett's idea is about as easy as it gets but send me a message if you want to discuss it further.

Agreed with Brett and Therese reporting would be so much easier and you could do it in excel also just use Vlook up to get the current prod line and pivot table for the repot. If there is a lot of history you might want to use Jeff's PTQ's with crystal... Many different options but bottom of list I think is VI importing....

Chuck, how many records are we talking about? In the end, what is simplest for the client and how much are they willing to spend? Changing the field is doable, just a royal PITA which as Myron points out, you may not recover your investment. But if the customer is a great customer which you want to help, by all means, grab a copy of their files and give it a shot. Don't forget to change the SO open order detail and possibly the SO history detail.

@ChuckPeddy - If for some reason the customer insists on changing the history files, point out that if left as they are they can report either way - by how it was at the time or how it is now.

@JeffSchwenk The AR_InvoiceHistoryDetail.M4T has a record count of 770,170. I don't think I'm even going to look at the other files right now. This looks like one of those options that we need to price ""too high"" or just not offer. Jerry and I will discuss it and make a final call. I want to thank everyone for the good discussion on this one.

Only 770,170????? If you do anything, make sure you use the MAS_Mirror PTQ or other similar solution.......... Your Crystal reports or Excel Pivot tables will be much more impressive.