Prev
Next
Forums Financial Management Lawson S3 Financials

AP270 need a little more information

 1 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
Wade-T
Veteran Member
Posts: 54
Veteran Member
12/11/2009 2:27 PM

    I am looking for the information on the AP270 and also if it was tagged with a  Reportable Income code.  Would Addins be the best route to take, and if so, which table should i pull from?

    Currently we are running the AP270 for the year and the AP245 then reviewing both to see what should have been reported, and what wasn't but should have been.

     

    Any help would be great.

    Michael Landis
    New Member
    Posts: 2
    New Member
    12/12/2009 7:00 PM
      You're looking for the INCOME-CODE as defined in the APINCCODE table (for list of valid codes). The INCOME-CODE is recorded in both the APINVOICE and APPAYMENT tables. You'll probably want to pull your info from APPAYMENT (probably by check-date range), as you want to report what you actually PAID to vendors, not what they ASKED you to pay (APP takes discounts, etc into consideration). The tricky part is determining what SHOULD have been flagged as reportable income. I've done this by reports/queries on AP G/L distribution for specific GL accounts (Rent, Legal, Lawn service) that we KNOW are reportable income stuff.