3,484
Hi:
We have created a Configuration Package for tables 38 and 39. It works for importing data already containing a Purchase Order number.
But, we want the ability to import this data to create new Purchase Order numbers.
So, we have tested leaving that field blank in the Excel source files for both tables.
Obviously, this doesn't work.
Can Configuration Packages be used to create new transaction numbers like this?
Thanks!
John
Hi, when using Configuration Package to import data, you must have a primary key. If the value of the primary key already exists, the record will be modified. If the value of the primary key does not exist, new data will be inserted.
So, I don't think this can be done with Configuration Package.
But it is possible if customized.
Below is an example of importing Sales Order. I think it can be slightly modified to automatically get the value from No. Series. I hope it can give you some hints.
Hope this helps.
Thanks.
ZHU
If it is a regular import you are doing you should look at using a xml port instead of the config. packages.
So may disagree with me, but i think they work best for one time imports.
Good suggestion you got from Steve there.
Because you are importing both head and lines they need to be assigned a number before you can do the import.
Because the purchase header no. is a part of the primary key on the lines.
John,
I am not a programmer, but have an idea... why not include the PO Number in the Import that is a specific PO Number Series. Then whomever is responsible for this just adds the next Number range to the Import file before importing.
Just a thought.
Thanks,
Steve
#1
André Arnaud de Cal...
293,278
Super User 2025 Season 1
#2
Martin Dráb
231,983
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
