Solved

Create Critical Materials Inquiry to show all the work order materials

  • 18 August 2022
  • 9 replies
  • 348 views
J
Rank
Userlevel 2
Badge

Hi, 

Have anyone done similar inquiry to view all the critical materials for all the production orders? Would be great if able to share the GI with me, or assist me in creating the GI. Thanks!

icon

Best answer by dgodsill97 17 November 2022, 18:16

View original

9 replies

A
Rank
Userlevel 4
Badge +1

Hi. We’ve done a GI which shows us both components and sub-assemblies which are negative available without the PO and RO respectively. It gives purchasing and production a way to prioritize orders and see critical materials across all orders. See snip of GI below.

GI showing amount available without PO

 

In general the GI takes the quantity available (which in our setup includes amounts ordered on either a PO or RO) and backs out the open orders. Those which are negative without the PO or RO quantities would be “critical materials” as we don’t have enough in house for the demand.

If this is what you are looking for please let me know and I can share the GI.

J
Rank
Userlevel 2
Badge

hi @alicezyks51 , yes this is very helpful. Please share the GI with me. thanks a lot!

A
Rank
Userlevel 4
Badge +1

Attached is the GI - please let me know if you have trouble uploading from the file. Thanks!

1 Attachment
Chris Hackett
Rank
Userlevel 7
Badge

Hi @alicezyks51 - did you find a solution for this one? 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*.
D
Rank
Userlevel 5
Badge +2

There does not appear to be anything in the XML other than the header.

<?xml version="1.0" encoding="UTF-8"?><Error><Code>MissingKey</Code><Message>Missing Key-Pair-Id query parameter or cookie value</Message></Error>

D
Rank
Userlevel 5
Badge +2

Found the issue and successfully downloaded and uploaded it.

D
Rank
Userlevel 5
Badge +2

Nice Job.  Just a few comments.

  1. It excludes QtyProductionSupplyPrepared and QtyPOPrepared
  2. It only includes demand for QtySOBooked and does not consider any other demands such as transfer demand or production order demand.
A
Rank
Userlevel 4
Badge +1

Thanks!

  1. Yes, for our purposes the RO and PO prepared quantities are excluded, however it is easy enough to add them to the respective formulas in the inquiry.
  2. In our case, the quantity available from INSiteStatus, based on our Availability Calculation Rules setup, includes all demand so those demands are included. You may be seeing different results depending how your availability is being calculated.
D
Rank
Userlevel 5
Badge +2

Thanks. I don’t use the Qty Available because it’s not used by MRP

Reply


Terms & ConditionsCookie settings
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