Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2022 Release Wave 2Check out the latest updates and new features of Dynamics 365 released from October 2022 through March 2023
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
We use the Orders module to create our Purchase Orders for Vendors. We have done so for a year with no problems with the module. We just received an error today (System Message 15481 & then System Message 15481) where it states that the quantity on the PO is greater than the quantity remaining on the blanket PO for this item. We have never used Blanket POs & have no need to use blanket POs. So when I go into the PO system to create a PO, it will only let me create a PO with no quantities or Unit Costs- HELP!?!
-Stacy Leslie, Accounting Supervisor
Looks like you may have a blank PURORDDET record.
This issue occurs if one of the following conditions is true: • In Purchase Orders (04.250.00) the Quantity entered is more than the Quantity remaining on the Blanket Order. • A record exists in the PURORDDET table with a blank value in the PONbr field. RESOLUTION
Note If you receive System Message 15481 or 15482 in Purchase Orders (04.250.00), and the PO Type is Blanket Order, it may be a valid message. Either message may occur if the Quantity or Extended Cost entered on the Purchase Order is more than the Quantity or Extended Cost remaining on the Blanket Order.
If you receive System Message 15481 or 15482 and the Purchase Order PO Type is not Blanket Order, a record in the PURORDDET table may exist with a blank value in the PONbr field. To resolve this issue, use Query Analyzer to delete the incorrect record in the PURORDDET table.
Note Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs.
1. In Query Analyzer, access the appropriate Application database and run the following statement to identify PURORDDET records with a blank PONbr value:
SELECT * from PURORDDET where PONbr = '' (where '' = 2 single quotes)
2. If records are returned, run the following statement to delete the incorrect PURORDDET records:
DELETE from PURORDDET where PONbr = '' (where '' = 2 single quotes)
This article was TechKnowledge Document ID: 129352
-Stacy R. Leslie
Great news! Thanks for the feedback.
You may run the PO Integrity Check
Check Purchase Orders
Verify Table Relationships
Delete Orphaned Records
The reason for the error is that there is an Orphaned Record(s)
Thank you very much this is a wonderful fix that got me out of rough morning! Thank you for taking the time to share you Knowledge with us!
~ Leif Hanson
Business Applications communities