Menu Option 1.4.10

[MPHANSON]

Hello,

I was wondering if someone could help me out with a table name in menu option 1.4.10 Item-Site Cost Inquiry since we didn't purchase the QAD source code. I am looking for the table name of the cost set information being displayed on this screen after hitting f1 with your site/item information. The fields being used for the material, labor, burden, etc. would also be helpful.

Thanks,

Matt

 

[W.Wulmsen]

Hello Matt

First your question:
The cost information is stored in 2 tables:
- Cost detail - spt_det
- Cost summarised - sct_det

Second your program remark:
For each MFG/Pro installation you must have the Query and Report programs.
They are stored in the base directory of MFG/Pro in the src directory.
In case you have a UNIX ( or variant ) go to the Progress Editor via Main menu and try to open a file.
Then enter src/ppptiq03.p <enter>

In subprogram pppptiq3a.p is logic build for the cost inquiry!


Good Luck

William W

 

[MPHANSON]

Wow, thanks.

No one in our company had any idea you could view the src code of QAD's code. It was always encrypted when we tried to view it through unix.

This will be a big help in the future - thanks again.

Matt

 

[yls999]

Matt,

The below code maybe be helpful for you.
You can modify the sct_sim with your corp. using.

------------------------------------------------
for each sct_det where sct_sim ="standard" :
display sct_part sct_cst_tot sct_mtl_tl + sct_mtl_ll sct_lbr_tl + sct_lbr_ll sct_bdn_tl + sct_bdn_ll sct_ovh_tl + sct_ovh_ll sct_sub_tl + sct_sub_ll with width 132.

------------------------------------------------

Wow, thanks.

No one in our company had any idea you could view the src code of QAD's code. It was always encrypted when we tried to view it through unix.

This will be a big help in the future - thanks again.

Matt