MikeS
Member
Hello there - I am new to the forum and actually kind of new still to working in the JDE/Peoplesoft environment (started creating UBE's about three/four months ago).
We need to import a legacy system customer master into our existing XE customer master (F0101 / F03012 etc.). I have created a UBE to populate F0101Z2 and F03012Z1 and was succesful in creating the new customer records however there is one field that we also would like to import that I am stuck on.
It is a text comment field that we would like to insert into the ABGT media object text attachments for the respective customers. I did some searches and it looks that you can only do a "Get Text" on ABGT within a Batch Report but not an "insert/add text".
This is only needed for a one time import but if we can get it to work we could also use something similar when we import the Open A/R items from the same legacy system. They also have a lengthy comment field for each open A/R record with important comments that our customer finance department would like to see moved into the Media Object text attachments for the open items once we import those.
Any help with this would be greatly appreciated.
Thanks
Mike Schuetz
B7333 XE SP23_J1 AS400 V5R3
P.S.: Great forums here - I already found a fountain of useful information here over the past ten days after one of my co-workers pointed this site out to me.
We need to import a legacy system customer master into our existing XE customer master (F0101 / F03012 etc.). I have created a UBE to populate F0101Z2 and F03012Z1 and was succesful in creating the new customer records however there is one field that we also would like to import that I am stuck on.
It is a text comment field that we would like to insert into the ABGT media object text attachments for the respective customers. I did some searches and it looks that you can only do a "Get Text" on ABGT within a Batch Report but not an "insert/add text".
This is only needed for a one time import but if we can get it to work we could also use something similar when we import the Open A/R items from the same legacy system. They also have a lengthy comment field for each open A/R record with important comments that our customer finance department would like to see moved into the Media Object text attachments for the open items once we import those.
Any help with this would be greatly appreciated.
Thanks
Mike Schuetz
B7333 XE SP23_J1 AS400 V5R3
P.S.: Great forums here - I already found a fountain of useful information here over the past ten days after one of my co-workers pointed this site out to me.