AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Acumatica Dashboard...
Production Orders w...
 
Notifications
Clear all

Questions Production Orders with all material on hand

 
Acumatica Dashboards
Last Post by Dominic Boullé 1 year ago
3 Posts
3 Users
1 Reactions
873 Views
RSS
sarah.bond
Posts: 2
 sarah.bond
Topic starter
August 31, 2023 2:55 pm
(@sarah-bond)
Active Member
Joined: 4 years ago

Looking for a way to highlight/show the Production Orders in the system where there is enough material on-hand/available to make the order.

Short of having to look at Critical Material for each Production Order, does anyone have any recommendations on a way to get this information? 

Tim Rodman reacted
Topic Tags
Production Orders Inventory Critical Materials
2 Replies
tlynn
Posts: 33
 tlynn
April 16, 2024 10:58 am
(@tlynn)
Trusted Member
Joined: 5 years ago

Hi Sarah,

 

I'm very interested in a solution to this as well.

Were you able to get any feedback/help?

I think this report is a great starting point. I'd like to see this report for all Production orders in the "Released" status. Currently, it only pulls for completed or in process because it's tied to a "MOVE" transaction:

image

 

Reply
Dominic Boullé
Posts: 16
 Dominic Boullé
May 6, 2024 8:11 pm
(@dboulle)
Eminent Member
Joined: 1 year ago

Hi Sarah, were you looking to get this visibility in a GI? If so, I was able to essentially get a yes or no result based on the following relation and formula...

I am using MYOB Advanced, so your tables may differ slightly.

If you specifically want highlighting, you can just use an IIF in the row style. In my GI, I have named the column "short", as in, the production order is short of materials.

GI ProdMatl2
GI ProdMatl
GI ProdMatl3
Reply
Forum Jump:
  Previous Topic
Next Topic  
Topic Tags:  Production Orders (2) , Inventory (15) , Critical Materials (1) ,
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,518 Topics
  • 10.9 K Posts
  • 18 Online
  • 2,309 Members
Our newest member: Jason Rhodes
Latest Post: Table linkage for adding a customer location note to the SO Shipment form
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2025 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×