Prev
Next
Forums Lawson Add-Ins for Microsoft Office

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

Sort:
You are not authorized to post a reply.
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

        You are not authorized to post a reply.