Is the following doable? is there a flaw in my plan? Is there a simpler way?
We're 405 CD on V5R1

My boss wants a new cost set copied from standard, except actual cost used on certain combination of item classes of raw materials (this is to be the basis of standard cost for next fiscal year) ... after I do this, he will have a few of the results adjusted slightly before we switch to this for next year standard costs.

My tentative approach plan:
* create logical file join-CJ1
** CMF cost master, only cost set-1 actual, joined to IIM item master, only items of those raw classes that he wants to have actual used in the new cost set
* create logical file join-CJ2
** CMF only cost set-2 standard with IIM all other items (than those in join CJ1)
* in theory all items should be in join CJ1 or CJ2 except any that lack standard or actual cost
** before starting, I could identify any such null situations via no-match vs. active records, then zero such items for safety
* create cost set 13 of CMF to start off devoid of records
* create temporary work copy of CMF as CMF13W identical physical file structure, to start off devoid of any records
* copy file CMF all physical records of join -CJ2 to the temporary file copy CMF13W
* copy file CMF all physical records of jokn-CJ1 to be appended to CMF13W
* use SQL/400 or other tool to replace contents of cost set in CMF13W with value 13
* copy all records of CMF13W appended to CMF
* do a cost rollup of new cost set 13
-
Al Mac ... who has not done this kind of manipulation in a while



As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.