SO Allocation w/o CIM

[bob101]

I would like to update the sales order detail allocation quantity w/o using cim. I will only be updating allocation quatity and do not need any additional validation. What additional tables need to be updated? Data is coming from a 3rd party scheduling system and I'd like to avoid cim if possible.

eB2 sp5
Progress 9.1D

Thanks for your help.

 

[LuisGdelC]

I would understand if you do not want to cim into SO maintenance but have you considered doing CIM into sosoal.p (7.1.6)?

Allocations affect a lot of tables, among them ld_det, lad_det, mrp_det, sod_det, in_mstr. You can check what tables are being hit using your system cross reference 36.18.2. You will need to know the execution tree of programs that sosoal (or subprograms) may end-up calling.

Also, not only quantities are affected. An example would be the flag that tracks whether a given item/site combination has had changes that would require at least a selective MRP (in_mrp).

I assume you are not refering to the standard QAD CIM (e.g. 36.15 menu) and that you know how to redirect input for a program.

In my opinion a program that creates a CIM-IN file, wraps sosoal.p and redirects the input/output will be good and fast enough as to avoid trying direct updates.

My 2 cent.

 

[bob101]

Thanks...I hadn't thought of using 7.1.6. I've used the CIM method you refer to with backflushing. I still think it's such a hugh weakness of MFGpro to not have friendlier (non-proprietary) hooks into thier app.