Report: Tolerance Report

 7 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
LouP
Basic Member Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
Posts: 7
Basic Member
What alternative would I have since we do not want to setup a "Tolerance" account....
Ruma Malhotra
Veteran Member Send Private Message
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 Send Private Message
Posts: 7
Basic Member
I am not exactly sure I understand what you are asking..thankyou
Ruma Malhotra
Veteran Member Send Private Message
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 .