Table: I/R Details Master (1,2) Composite

Field:{Inv Status}

The results show me that we have receipts with Invoice statuses of 0, 1, 2, and 3.

Can anyone tell me what 0, 1, 2 and 3 represent? I thought there would only be 2 statuses, delivery note or invoice.

I am trying to create a Gridview that shows only the outstanding receipts. Same as the one in POA called, "Outstanding Receipt Invoice List", but if I can get those results in Gridview, I can export them to excel.

So, to get only the outstanding receipts, which {Inv Status} do I use? 0, 1, 2 or 3 ?? Or is their another method to show only the outstanding receipts in Gridview?

Hi Susan,

Here are the status values and their text equivalents:


Does that help?

Hi Susan,

A status of 1 means that the receipt was posted as an invoice, not a delivery note.
A status of 3 means that the receipt was posted as a delivery note and later on the delivery note was invoiced.
The rest should be self-explanatory.

The upcoming upgrade release for Purchase Orders will have appropriate fields support the Translate feature, and {Inv Status} is one of them.

So then the only ones that are outstanding receipts are {Inv Status} = 2?

The result I'm getting is that I found out that we have a number of outstanding receipts at zero dollars that did not show up on the "Outstanding Receipt Invoice List" in POA. So, I went in and posted these to clear them up.

I also found some receipts listed here that are not actually outstanding. When I look at the Receipts in POA it says, all lines says that the invoice status is "inv". However, they have not moved to history and they keep showing up on the Gridview report. I tried reposting them again but it won't correct the problem.

For example this receipt is appearing on the Gridview report with invoice status 2:

RC 00002634 reports qty of 144 @ 39.74 = 5,722.56 is still outstanding. However, I've posted it multiple times now and shows that the invoice status is "inv". So, why won't this move to history and how to I get it off my gridview report?

Will the new POA fix this? I've run integrity checks in POA and DataCare and they are not finding or correcting the problem.

Can anyone help or advise?

Hi Susan,

In order for a PO/Receipt/Invoice to be moved to history, all details and Vendor totals must have a status of Invoice (1) or Post Full (3) or Adjustment (4). This includes all POs and Receipts and Invoices that may have been combined together. Look at the Data Flow tab for this receipt to see other related documents. Can you put the Invoice Status field on this grid for easier checking?

If any receipt details have a status of Delivery Note (2), then that would prevent the move to archive. The receipt and at least one item would have to be edited, and an invoice/adjustment posted.
If any invoice details have a status of Delivery Note (2), then the data is corrupted (because invoices cannot be edited). In this case, you might have to get your Adagio consultant to edit the underlying data with GridView RW.

You might want to look at the misc charges on receipt 2602, and the first 4 details on invoice 3379, and the totals for all related receipts and that invoice (nudge nudge, wink wink).

I've always known that you guys were gifted with special abilities, but this takes it to a whole new level. :-)

So, I posted the misc charges on receipt 2602 so it now shows all lines as invoice status "inv".

When I view invoice 3379, I see that the first 4 details show as invoice status "del" instead of "inv" but I still don't know how to fix that? I can't edit the invoice and every related receipt now shows all lines as invoice status "inv". Can you give me another clue? :-P The bottom 4 lines show as invoice status "inv" from RC2635, but RC2635 doesn't even show up in the Data Flow. On my gridview report RC2634 and RC2635 both show as invoice status "2", even though RC2635 is in history already. Does this mean my data is corrupt or is there a way for me to fix it?

Hi Susan,

Invoices would have to be edited using an outside tool such as GridView Read/Write - you are correct that these cannot be edited directly within Purchase Orders. It makes sense that invoice details should not have a status of 2-Delivery Note, so I would assume that the data is not correct (corrupt?).

No special abilities - just happened to have an old copy of data from a tech support issue that still had these docs. By the way, I tried editing all the documents as above, and Archiving still hasn't moved these to History. Must be some other document that still needs correcting (2635?). There are a bunch of older documents that have similar scenarios, such as receipts where just the shipping charge have a 2-Delivery Note status but all items are invoiced.

Older versions of PO may not have dealt with item backorder qtys correctly if a partially received PO was completed, which is why items on completed POs may still appear on outstanding item reports. These have been fixed in the upcoming upgrade.

There's nothing I can do with RC2635 because it's already in history, unless I restore it, which I'm not sure what that does and so I didn't try it. So, seems I have a bunch of these that won't move to history, no matter what I do. I have tried everything. So are you saying that when I open my data in the new program, I'll have the ability to clean them up?