Hi, I am in the process of upgrading from release 2.50 to 3.70 for a client. I have completed the upgrade process, and am now testing all the customisations that have been made. I am aware that the 2.50 Item Ledger Entry table (32) has been altered in 3.70, and also that some of the fields have been moved to the new Value Entry table (5802). Does anyone know if there is a document anywhere that describes how the fields have been mapped (it looks as though some have the same content, but have been renamed) - and which have been deleted. The problem I have is that a customised report uses the Unit Amount field in the 2.50 Item Ledger Entry table - but this no longer exists in 3.70, and doesn’t appear to exist on the new Value Entry table either. I have checked the Upgrade Toolkit manual, and searched the forum, and looked on the PartnerSource site - but can find nothing. Thanks, V
That’s a big problem!!!You are right!!! Only manually do upgrade and show logic.That’s it!!!
quote:
Originally posted by Veronica Smith
Hi, I am in the process of upgrading from release 2.50 to 3.70 for a client. I have completed the upgrade process, and am now testing all the customisations that have been made. I am aware that the 2.50 Item Ledger Entry table (32) has been altered in 3.70, and also that some of the fields have been moved to the new Value Entry table (5802). Does anyone know if there is a document anywhere that describes how the fields have been mapped (it looks as though some have the same content, but have been renamed) - and which have been deleted. The problem I have is that a customised report uses the Unit Amount field in the 2.50 Item Ledger Entry table - but this no longer exists in 3.70, and doesn’t appear to exist on the new Value Entry table either. I have checked the Upgrade Toolkit manual, and searched the forum, and looked on the PartnerSource site - but can find nothing. Thanks, V
In general, most reports that has been built for the customer on table 32 needs to be rebuilt/changed so they look at the value entries instead since it’s there You have the amounts nowadays
Hi Veronica, I agree with Lars. You need to modify/rewrite the custom reports to look for Value Entry not the Item Ledger Entry table for amount etc. Also if you check the Item table, All the Qty flowfields (i.e. Sales (Qty.)) are calculated from the Item Ledger Entry, but the Amount flowfields (i.e. Sales (LCY)) are based on the value entry table. Naveen Jain
Thanks for your replies people… indeed I have had to re-write the reports as you have suggested. The customer is now in the process of User Acceptance testing the upgrade - so far all looks good. Regards, Veronica