Share
ReportIs there any report or filter that can be run to recommend production orders in process with time and\or material issued that no longer have demands.
*This post is locked for comments
You’re offline. This is a read only version of the page.
Is there any report or filter that can be run to recommend production orders in process with time and\or material issued that no longer have demands.
*This post is locked for comments
Find any order in process that the demand is no longer there. Hoping to scrap item or items before to much labor is invested.
You could do this with a T-SQL query/custom report. To give you an idea, a Production Order In Process could be determined like this:
All responses (
Answers (
SELECT CASE WHEN ([POL].[Finished Quantity] / [POL].[Quantity]) < 1 AND [POL].[Status] <> 4 THEN 'In Process' END AS [Situation]
FROM XXXXXX.dbo.[XXXXXX$Production Order] [PO]
LEFT JOIN XXXXXX.[XXXXXX$Prod_ Order Line] [POL]
ON [POL].[Prod_ Order No_] = [PO].[No_]
WHERE ...
Depending on what you mean by demands, determining which orders already have Material Issued would require usage of the [Prod_ Order Component].[Remaining Quantity] table.field in conjunction with other logic.
*Contact your Partner/Reseller for a solution to this. They will need to gather your requirements to develop a proper solution for you.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156