Skip to Content
0
Former Member
Feb 20, 2011 at 06:23 PM

Credits on Invoices

38 Views

I am trying to write a query that pulls all invoices and adjusts that total amounts whenever there are credits that are applied to a vendor. I know that all credits reside in table ORPC, this is the table that I'm currently using to calculate the numbers. Question: do credits get moved to another table once invoices are ran for payment just as the invoices do get moved to OPCH? I want to make sure that when run this query I don't pull out old credits.