Upon further investigation, it appears that there are hundreds of receipts on our system that are completely invoiced that have not changed from receipt status "2".

I have another example as recent as Sept 2, 2012 where this occurred. I know you don't have my recent data but as an example, RC7776 with a receipt date of Sept 4, 2012 pops up "Adjustments have been issued on this receipt" and "There are no unadjusted delivery notes on this receipt" and all the line items say Inv Status "Inv". On the Data Flow tab, I can see that there are 2 Invoices associated with this receipt. ADJ7772 was used to invoice Vendor 2 and ADJ7782 was used to invoice Vendor 1.

The problem seems to be when our staff are invoicing Vendor 2 while Vendor 1 has not yet been invoiced, they are not deleting the lines for Vendor 1. When they post, it pops up a message saying "Vendor 1 items have not changed, do you want to complete this invoice now?" and they click "no". Then they complete the posting for Vendor 2 by receiving an ADJ#. Later when they get an invoice for Vendor 1, the receipt still shows those lines as "del" so they post them and complete them.

The problem is that first invoice to Vendor 2 on ADJ7772 shows "del" on the items for Vendor 1. This is unchangable. So these Receipts will never change to inv status "2".

My first question is, should I ask our staff to delete the lines from Vendor 1 when they are posting invoices for Vendor 2 and vice versa, to prevent this problem from continuing?

Second questions is, I have hundreds of these receipts in our data that are permanently stuck at inv status "2" even though they are completely invoiced. What do I have to do to get my data fixed? Should I get this mess cleaned up before we move to the new POA or will the integrity check in the new POA resolve it for me?
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario