Forums
Lawson Business Intelligence/Reporting/Crystal
MA236 Criteria
Author
Messages
Kidd Kasper
Basic Member
Posts: 13
1/27/2016 3:08 PM
Hello all,
I have resources that would like to have a Crystal Report in LBI that essentially duplicates MA236. I've tried to pick through the logic of the program to pull all the criteria that it's using. Although I know programming logic in general, I've never learned Cobalt. What I have thus far is:
apinvoice.rec_status in (0,1)
apinvoice.match_status in (0,1)
apinvoice.invoice_type not in ('C', 'D', 'R')
apinvoice.mtch_proc_type in ('R', 'A')
mainvdtl.r_status = 0
mainvdtl.matched_qty < 1
poline.item_type <> 'S'
poline.cost_option <> 2
purchorder.closed_fl <> 'Y'
purchorder.dropship_fl <> 'Y'
Any suggestions or insights into the MA236 would be greatly appreciated. Thanks!