Report: Tolerance Report

 7 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
LouP
Basic Member
Posts: 7
Basic Member
    Greetings,
    We are on 8.0.3 and was wondering if there are any reports out there that can track invoices that are paid with tolerance and invoices not paid because of tolerance.
    Thank you
    mark.cook
    Veteran Member
    Posts: 444
    Veteran Member
      I can't remember versions of when reports were added but matched with tolerance you might get what you need from the Match Analysis report (AP251) and invoices not paid because of tolerance should show in your message queue so you could look at the Invoice Message report (MA264) using the filter for PO Cost Message option.

      Otherwise I would try to write something using the MAINVDTL table to pull the data.
      LouP
      Basic Member
      Posts: 7
      Basic Member
        What I am looking to find is all invoices that were paid when a tolerance value was used...
        Ruma Malhotra
        Veteran Member
        Posts: 412
        Veteran Member
          on Ma01 you set up a tolerance account and this account is used whenever you match invoices out of tolerance etc. You can then use GL95 for a range of accounting units or all accounting units and this account to get a list of transactions posted to this account. If you do a csv export of the gl97 list which will be saved according to the directory specified and ftp this file over you get a list of all transactions to the other alternative is to run a GL290 report for the list of invoices that hit the tolerance account which will need to be defined on GL50.

          hth.
          LouP
          Basic Member
          Posts: 7
          Basic Member
            What alternative would I have since we do not want to setup a "Tolerance" account....
            Ruma Malhotra
            Veteran Member
            Posts: 412
            Veteran Member
              Which account is the tolerance going to according to your ma01 if the tolerance account is not setup ?
              LouP
              Basic Member
              Posts: 7
              Basic Member
                I am not exactly sure I understand what you are asking..thankyou
                Ruma Malhotra
                Veteran Member
                Posts: 412
                Veteran Member
                  what I am saying is if an invoice is matched out of tolerance the difference in the invoice amount and purchase amount gets posted to the tolerance account. Which account according to your system has been setup for this posting?

                  You would have to run a report against the same account to show all transactions that are posted to that account .