OELINAUD_SQL promise date

[fredwhitridge]

I am trying to add the ORIGINAL promise date to a cyrstal backlog report, ie, what was the promise date when the order was first entered? (We move the promise date out if production hits a snag). But promise date seems to hold a number of different dates. It looks like an array but I don't seem to be able to parse it as an array.

any ideas on how to read the last OELINAUD_SQL.promise_dt?

Thanks

 

[abaldwin]

Progression MS-SQL backend.

Promise date will be in the format of 20030627 (YYYYMMDD)


I would suggest using the aud_dt field (date of the audit) and grab the min of this field for the order number in the current record as a filter to grab the promise_dt.



Andy Baldwin

"Testing is the most overlooked programming language on the books!"

Ask a great question, get a great answer. Ask a vague question, get a vague answer.
Find out how to get great answers FAQ219-2884.

 

[maccrystal]

The aud_action code for the original line insert will be an "A" This should represent the original Promise date when the order line is entered. This assumes the user assigned the correct date on inital entry. If not you would need the minimum Promise value from either the "A" or "C".

http://www.appstratinc.com