Macola table that has the product category's Sales GL code with description and cost of good

[ssan]

Hi,
Macola version progression 7.7.600.
I'm looking for the table, that has the
Sales GL code and Cost of goods for
The product category of items.
Will appreciate if anybody ca let me which table will have this.
Thanks.

 

[dgillz]

oeprdact_sql

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[dgillz]

Actually that table doe not hold the descriptions. To get the product category description, link to the imcatfil_sql on prod_cat. To get the GL account description link to syactfil_sql on mn_no, sb_no, dp_no and either the Sales or COGS group of 3 similar fields (depending on which description you want).

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html