Skip to main content
Solved

Item quantity exceeds the preassigned item quantity

So, we have Clock Entries against Production Orders, but to approve the Clock Entries, I’m getting the following error:

The transaction cannot be created for Production Order RO (Order number) because the item quantity exceeds the preassigned item quantity for the 000010DATEIN240410 lot or serial number.

However, that’s not the only issue. I had to CHANGE the Lot number to 000010DATEIN240410 (it was assigning the ‘lot’ day) and giving me this error:

The transaction cannot be created for Production Order RO (Order Number) because the 000000DATEIN240410 lot or serial number has not been preassigned.
 
Why is Clock Entry Approval trying to assign lot numbers? Why isn’t it just using the lot numbers that were generated on the Production Order?

8 replies

angierowley75
Rank
Userlevel 7
Badge +3

If the worker reported quantity on their labor transaction - that would fire the business logic to check for lot/serial assignment of the production item being moved or received into inventory.

What “Require Parent Lot/Serial” setting are you using - never, on issue, on complete?

 

If I have helped you, please ~ *Like* my post. If I have provided an answer to your question, please mark it as *Best Answer* . Thank you!
M
Rank

Hi Angie- We currently have the Require Parent Lot/Serial set to “Never” on the RO order type. I can double-check, but I assume a quantity is being recorded on the labor transaction because the Quantity column has a value on the Approve Clock Entries (AM516000) form. Is this assumption incorrect?

 

angierowley75
Rank
Userlevel 7
Badge +3

Yes the quantity column having a value on the labor transaction means quantity was reported complete for that operation.

If I have helped you, please ~ *Like* my post. If I have provided an answer to your question, please mark it as *Best Answer* . Thank you!
M
Rank

Okay, thank you for confirming! On one of the entries, I was able to follow these steps to get the clock approval processed:

  • Open the Production Order
  • Copy the Lot/Serial Number from the Line Details tab in the Production Order
  • Select the clock entry in the Approve Clock Entries (AM516000) form
  • Click on Line Details
  • Paste the Lot/Serial Number to the grid
  • Save the Approve Clock Entries screen
  • Refresh the screen, and click Process

Is there a better way to be doing this? The process is lengthy, but I have not come across a better way to get these clock entry approvals processed. Thank you for your responses!

Chris Hackett
Rank
Userlevel 7
Badge

Hi @mattjesse68 were you able to find a solution? Thank you!

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
M
Rank

Hi @Chris Hackett - We are continuing to use the steps I outlined above (pretty manual process), but it’s working for the time-being. I’m not really sure why the Lot/Serial from the Production Order is not being used as the default. Hopefully I’m not missing a setting/preference. Thanks for the response!

M
Rank

Just coming back to this, we resolved the issue. I noticed there are a few other posts on this topic, and it looks like there is already a Community Idea for it (CLICK HERE to upvote it - Around automatically populating preassigned Lot/Serial Nbr). However, to resolve this specific issue, I recorded a demonstration of the fix HERE (~20 minutes). Thanks for the responses!

Chris Hackett
Rank
Userlevel 7
Badge

Thank you for sharing your solution with the community @mattjesse68!

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.

Reply


Terms & ConditionsCookie settings