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é 2 years ago
3 Posts
3 Users
1 Reactions
1,381 Views
RSS
sarah.bond
Posts: 2
 sarah.bond
Topic starter
August 31, 2023 1:55 pm
(@sarah-bond)
Active Member
Joined: 5 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
Tami
Posts: 36
 Tami
April 16, 2024 9:58 am
(@tlynn)
Trusted Member
Joined: 6 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: 17
 Dominic Boullé
May 6, 2024 7:11 pm
(@dboulle)
Eminent Member
Joined: 2 years 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,527 Topics
  • 10.9 K Posts
  • 18 Online
  • 2,411 Members
Our newest member: thollings
Latest Post: Invoice subreport for line-level tax breakdown not tieing to taxes subtotal
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.

‹›×

    ‹›×