Purchase Orders Overwriting?

(1) Share

Report

Posted on by Greg Kujawa

618

Originally when we launched with our BC 365 SaaS production company I ported in a batch of purchase headers and lines through a configuration package. Now it seems that when staff are creating new purchase orders, the document numbers are falling back to the existing Purchase Order Nos. that already exist. So apparently the old orders are being overwritten.

Below is a screen shot of how we have the No. Series defined for Purchase Orders. I had to check the Manual Nos. option to allow us to define the Purchase Order Nos. when importing in the initial batch. But I'd assume that the Default Nos. option being enabled would automatically increment the numbering of new documents. I must say I did not see what the Last No. Used value was after the initial import.

Is this behavior normal? I haven't tested over in our sandbox environments, but I'd assume that using a configuration package to import in our purchase headers and lines would automatically increment after completed, so the Last No. Used field value would be higher.

All responses (4)

Answers (1)

Greg Kujawa 618 on at

Like (0)

Report

Purchase Orders Overwriting?

Thanks for the replies! I will keep in mind that importing in new records via the configuration packages won't update the Last No. Used values. So I'll need to manually reset that once the import has completed. The imported records were fine and we were receiving against those purchase orders okay. I just think it's odd that if a user is creating a new purchase order in the web UI and an already-used Purchase Order No. is pulled in that no error is thrown. But I'll file this one away for future reference!
Suggested answer

Jun Wang 7,443 Super User 2024 Season 2 on at

Like (0)

Report

Purchase Orders Overwriting?

did you find out why they are recreating the orders if already been imported? Maybe those imported orders have trouble to be processes due to certain reasons.

I'll recommend to review those orders and find a strategy to fix besides the numbering thing.

Jun Wang
Verified answer

Valentin Castravet 24,785 Super User 2024 Season 2 on at

Like (1)

Report

Purchase Orders Overwriting?

This is normal behavior. If you manually create purchase orders using a configuration package the system doesn't make the connection to update the number series for you.

In the number series page you have to update the Last No. Used field. In your screenshot the last number used for purchase orders is PO100051, so the system will use this numbers to create the next purchase order as PO100052 and so on. You have to update this field now, and any time in the future you create records using configuration packages.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/
Greg Kujawa 618 on at

Like (0)

Report

Purchase Orders Overwriting?

For a tangible example, below is a screen shot of the current Purchase Order No. PO100033. Created on 5/6/2024. Along with a Posted Purchase Invoice that was posted back on 3/31/2024, pulled from this same purchase order. Totally different vendor and purchase lines compared to the purchase order that's sitting there now in May.

Purchase Orders Overwriting?

Helpful resources

News and Announcements

Quick Links

December Spotlight Star - Muhammad Affan

Top 10 leaders for November!

Community AMA December 12th

Leaderboard

Featured topics

Product updates

Purchase Orders Overwriting?

Helpful resources

News and Announcements

Quick Links

December Spotlight Star - Muhammad Affan

Top 10 leaders for November!

Community AMA December 12th

Subscribe to

Leaderboard

Featured topics

Product updates