We do this it’s a huge pain in the butt. It will required a set of pre and post directives, data directives for new releases/lines added to accept the rule.
The data directive needs to capture adding of new release records and defaulting the firm value depending on the order held value at that point in time.
The pre directive needs to capture the change of the order held checkbox and forward to a post directive
The post directive needs to load the actual OrderRel table either directly or using BOs in custom ABL (chefs choice) and update the records then retrieve the saved records into the temp tables to avoid “Row modified by another user†errors after the change.
Very difficult to explain all the steps in an email but this is the highlevel
Joshua Giese
CIO
Direct: 920.593.8299
IT Dept: 920.437.6400 Ext. 337
Site ID: 27450-E905702A-SQL64
Wisconsin Converting, Inc.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, August 27, 2015 10:04 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Order Hold and Unfirmed Releases
Good day,
We are on 10.0.700.4 and I am struggling to find a way to automate a process we are spending we too much time doing manually right now. We will put orders on User Hold for any number of reasons for any length of time. I do not want our nightly MRP run to recognize, thus, create jobs for lines or releases of orders on hold (OrderHed.OrderHeld = true). I can't seem to get a BPM right that would essentially say if OrderHed.OrderHeld = true, then OrderRel.FirmRelease = false for all releases on a Sales Order. Something that would do the opposite (Hold change to false, Firm Release = true) is also desired.
Has anybody done this or be able to provide assistance on how to make this happen? Your help is greatly appreciated.
Thanks,
Matt