Identify Infinite Recursion in Product Structure

From KeystoneIntranet
Revision as of 12:58, 14 July 2023 by WikiAdmin (talk | contribs) (1 revision imported)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Product Cost Rollup will report an infinite recursion error when a compenent code is the same as an assembly code.

Identify:

select * from artprstr
where assy_product_code=comp_product_code

Aggressive fix:

DELETE from artprstr
where assy_product_code=comp_product_code