MA236 Criteria

 0 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Kidd Kasper
Basic Member Send Private Message
Posts: 13
Basic Member
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!