Upgrade from XE to 9.1 - Table mapping - Deleted Columns - F4211. OMCU, SUB, OBJ, ANI, AID

SingSar

SingSar

Member
Upgrade from XE to 9.1 - Table mapping - Deleted Columns - F4211. OMCU, SUB, OBJ, ANI, AID

Hi,

We are upgrading from XE and 9.1.

We have customizations using fields F4211.OMCU,OBJ,SUB,SID,ANI which are now deleted in 9.1 as part of the net changes.

Since F4211 and 'F49211 - Sales order detail file - tag file' are having one to one relationship, we have decided to map to F49211 for these deleted fields.

Now the question is about the ledger.
Information in these fields were tracked through 'F42199-Sales ledger' before. Now we are thinking to make use of the file 'F49299 - S.O Detail Tag Ledger File' to track the information in the deteled columns.


Which one of the following would be better
1. customize the ledger writing BSFNs and call accordingly or
2. Write Table triggers (JDE triggers not database triggers) on F42199 and F49211

The requirement is to have a relation between F4211 <=> F49211 and F42199 <=> F49299 and maintain integrity.

I personally dont prefer JDE triggers as this has been discussed so many times in this forum. Still I would like to explore these 2 options (or more options)


XE <=> 9.1
F4211.OMCU <=> F49211.OMCU
F4211.SUB <=> F49211.SUB
F4211.OBJ <=> F49211.OBJ
F4211.AID <=> F49211.AID
F4211.ANI <=> F49211.ANI

And

F42199.OMCU <=> F49299.OMCU
F42199.SUB <=> F49299.SUB
F42199.OBJ <=> F49299.OBJ
F42199.AID <=> F49299.AID
F42199.ANI <=> F49299.ANI
 
Back
Top