Solved

Materials Screen - Limit inventory IDs to only materials on the production order

  • 27 February 2024
  • 7 replies
  • 45 views

Userlevel 6
Badge +5

When you create a new materials transaction within the Materials screen, you enter the production order and the operation.  When you get to the Inventory ID field, it allows you to select any inventory ID.  This is likely by design.  However, is there anyway to limit the Inventory ID selection to only materials already defined on the production order?

icon

Best answer by angierowley75 28 February 2024, 13:19

View original

7 replies

Userlevel 7
Badge +2

@ltussing03 How do you have this parameter set? 

 

Userlevel 6
Badge +5

Thanks Debbie!

I set it to “Not Allow” and tried again.  It still does not limit the selection list of inventory IDs.  It does stop you after you select and inventory ID not on the production order.

 

The difficulty is in the selection itself.  They have to copy and paste the inventory ID from the production order into the materials screen.

Userlevel 7
Badge +3

What is the business scenario / Use Case - could they scan from the Production Ticket?  Or use the Release Materials to call up the Materials Wizard which list the materials to be issued.

Userlevel 6
Badge +5

They backflush all labor and materials.

They do not print production tickets or scan anything.

After the production order is completed, they need to issue additional material if any of it was physically broken and they physically needed to grab more.

 

Userlevel 6
Badge +5

So if they need 5 of a material and one was broken.  They do the one and only needed move transaction (there is only 1 operation) and all materials are backflushed.  Then they do a materials transaction to issue the extra 1 piece that was physically used.

 

Userlevel 7
Badge +3

The Inventory ID selector does not filter by the Materials of the Production Operation chosen - this would be an enhancement request.

Do they really want to issue the broken material to the Production Order - seems to me they would want to perform and inventory issue w/ a scrap reason code to relieve inventory and track scrap.

Userlevel 6
Badge +5

Angie,

Thanks for the response.  Right now, I don’t believe this needs to be an enhancement request.  Thanks to you and Debbie for your suggestions!

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved