Prev
Next
Forums Lawson S3 Financials

AP270 need a little more information

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