Need to know the table name

J

jchellap

Member
Hi All,

I am using MFG/PRO version eb2. In a trying to find whether the GL calender period is open for "IC" and "SO" transaction for a particular date.

Unfortunately, I do not have the standard QAD programs. May I know in which table / usrw_wkfl the values are storing. It seems they are not available in glcd_det.

Thanks in advance !
 
Hi jchellap

You can find these values in table qad_wkfl using this key:
qad_key1 = "GLCD_DET"
qad_key2 = string(glcd_year,"9999") + string(glcd_per, "999") + glcd_entity

Values are in decimal fields where 1 is Yes.
ap_closed = (qad_decfld[1] = 1)
ar_closed = (qad_decfld[2] = 1)
fa_closed = (qad_decfld[3] = 1)
ic_closed = (qad_decfld[4] = 1)
so_closed = (qad_decfld[6] = 1)

Regards, Rene
 
I assume you don't need to know the table. I suggest you use the standard QAD Include to determine if GL Period is open for a particular module.
Below is the include file and the syntax.

{gpglef.i ""AP"" entity effdate}

Entity = Entity Code
effdate = Transaction effective date
 
You must log in or register to reply here.
Back
Top