web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archive) / Production Order formu...
Microsoft Dynamics AX (Archive)
Suggested answer

Production Order formula line "quantity cannot be reduced" -> cannot move from started to reported as finished

(0) ShareShare
ReportReport
Posted on by Brad Ellington

We have a production order with multiple formula lines that all show the following error when trying to consume on a pick list:

Quantity "XX.XX" cannot be updated with inventory reference Prod. picking list journal because inventory transactions with status On order, Reserved ordered, Reserved physical or Picked are insufficient.

If I open the Formula lines and go to Inventory->Pick, there are no lines in the "Issue status" (therefore nothing to add to pick).  If I look at the Item/Batch ID combination in On-hand or Inventory Transactions, I see an "On Order" line for this production order.  In the Inventory Transactions screen I see an "Inventory Reference" of prod. picking list journal with LOT-11082700.  Then in the Inventory section, the LOT ID is LOT-11082699.

I believe part of the is issue is someone created a pick list and added lines to the formula.  Then they deleted the pick list and now these records are "orphaned".  

The order itself is in Started status and we have reported some product as finished.  We need to get the status to Ended and consume the material on the Formula Lines. 

How can I get the material consumed?  (let me know any additional info that might be helpful)

Thanks!

Categories:
Manufacturing
  • Mannem Raju Profile Picture
    Mannem Raju 33 on at
    Production Order formula line "quantity cannot be reduced" -> cannot move from started to reported as finished
    Hi, have you found the solution even I am facing same error while posting picking list journal, please suggest how you resolve this issue?
     
    Thanks,
    Mannem Raju
  • Brad Ellington Profile Picture
    Brad Ellington on at
    RE: Production Order formula line "quantity cannot be reduced" -> cannot move from started to reported as finished

    Hi  Ludwig, 

    Yes, in this warehouse there is Qty 384 in Physical Inventory, 384 Available Physical, 47.25 in On Order.  There should be sufficient quantity of this item in this warehouse.  There are a couple of other items referenced on this production order and they have similar quantities available and on order.

    Ludwig Reinhard 

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Production Order formula line "quantity cannot be reduced" -> cannot move from started to reported as finished

    Hello Brad,

    If you open / inquire into your on-hand quantities of the items needed for the production, do you see that there is sufficient quantity available? On order won't be sufficient for that. Probably there is some quantity available on other warehouses/sites?!

    Best regards,

    Ludwig

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Blog subscriptions now enabled!

Follow your favorite blogs

TechTalk: How Dataverse and Microsoft Fabric powers ...

Explore the latest advancements in data export and integration within ...

more Community News

Leaderboard > 🔒Ι Microsoft Dynamics AX (Archived)

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans