How to write a job

static void feb22(Args _args)


InventSum inventSum;

InventTrans inventTrans;

ItemId itemId;

DatePhysical datePhysical;


select * from inventSum where inventSum.ItemId == InventTrans.ItemId;

info(strFmt("%1 %2",inventSum.ItemId, inventTrans.itemName()));

I am getting no value…when I print this on the screen. can anybody say? where I am doing mistake.

Thanks for your help.



I think that you don’t have a value in InventTrans.ItemId, the filter in the query is empty.