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



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



    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



      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