Small and medium business | Business Central, N...

Using a Configuration Package to Create a New PO Number

(1) Share

Report

Posted on by john.ellis

3,510

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

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Ollie 10 on at

Like (0)

Report

hi John,

did you manage to come up with a solution for this as i am looking to do the same and getting the same issues?

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (0)

Report

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.

https://yzhums.com/4223/

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No