generator-variable

{saveValidation}
if (documentAction=='A'){
var s=lookupTable('CAN_AUTO_APPROVE_BY_DATE','SALES_ORDER_REPORT2.RECORDID',_lookup('query.PARENT_RECORDID'));
var s2=lookupTable('MAX_COST','BOM_LIST.RECORDID',RECORDID); 
var s3=_lookup('query.SOI_PO_COST')*1;
/*alert(' s2'+s2+' s3: '+s3); */
if (s==0 | s3>s2){alert(' Remark : This BOM Need Special Approve');}
}
{/saveValidation}


Standard
standard Template





sql Variable

where=where (status:`A`   or status:`D`   or status:`C`  or status:`S` or status:`R` or status:`P`) and PO_DDATE<:ADDDATE(curdate(), INTERVAL '+7+' DAY)


countChecked i.e. count the checked. and save to the countEhecked Variable

countChecked[0]
{countChecked}0{/countChecked}


USER
var notSameUser=(USER!=lookupTable('PAYEE_INPUT_USERNAME','VENDOR.RECORDID',RECORDID));Checked[0]

COMPANY_NAME
_refreshv2('SALES_HEADER.PAYMENT_METHOD_REMARK','Please send a crossed cheque made payable to “'+COMPANY_NAME+'”.' );


DISK_DOC_STATUS

endofload=if(DISK_DOC_STATUS!:'D'){document.getElementById('SALES_ORDER_INV_DESC_gridButton1').style.display : 'none';}



thisRowNo

a

this.id

 {refresh}DOCUMENT=($.trim(_lookup('this.id'))+'-'+$.trim(_lookup('PURCHASE_HEADER.VERSION'))).replace('-0',''); if (DOCUMENT==''){$("#printCaption0").css("disabled", "disabled" );}{/refresh}