• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums User Experience Lawson Add-Ins for Microsoft Office

Where does the APVENBAL(MA95) table get its data?

 2 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
willz06jw
Basic Member Send Private Message
Posts: 24
Basic Member
1/27/2010 9:14 PM

Hi and thanks for your help,

I am trying to use the APINVOICE and APPAYMENT tables to calculate similar results as what shows up in the PURCH section of the  APVENBAL table (this is where MA95 is grabbed)...but they are always too high. 

Any ideas?

Thanks,

Will

Derek Czarny
Veteran Member Send Private Message
Posts: 63
Veteran Member
1/29/2010 5:08 PM
The balance in APVENBAL may only include matched totals? I am probably wrong, but it could be something like that.
willz06jw
Basic Member Send Private Message
Posts: 24
Basic Member
2/1/2010 6:41 PM

Thanks for the help,

When I only include the items with match_FL = Y then it brings my total down too low.

(Note: I am using the APPAYMENT.BASE_PMT_AMT as the field to sum up).

Hmm, any ideas why the matched amount would be lower than the data in MA95?

Thanks again,

Will