PO Receipt -> Invoice -> PO Posting Journals

[kdien]

We have 2 PO Receipts, RCP1 and RCP2. One PO Invoice was done on both receipts (checked off Multiple Receipts) but:
- RCP1: invoiced exactly the same with the rcp
- RCP2: received 2 items @ $100, but invoiced 1 item @ $200, Fully Invoiced marked Yes

I queried from table POINVAH / POINVAL to get the DayEndSeq, which I used to run the Posting Journal for PO Invoice Entries, which only shows RCP1 with 0 quantity and blank DR & CR but no RCP2 at all?!?

We have a custom SSRS Report showing POs received not invoiced and RCP2 shows there even though it shouldn't.

So I figured there might be a connection there between the Posting Journal (RCP2 not showing) and our report (RCP2 showing), although I'm not quite sure which table(s) the Posting Journal or our report pulls data from.

That's all the info I have on this situation. Hoping someone could shed some light on it.

 

[DjangMan]

Can you reproduce this in sample company?

 

[kdien]

Yes I did multiple tests in our test database and anytime I invoice a receipt and change both the quantity and unit cost that results in the same extended amount (like RCP2), that line won't show up in the PO Invoice Posting Journal. Any other case (invoice same as receipt, change just quantity, or change both quantity and unit cost but still result in a different extended amount) the line will all show up in the posting journal.

Also, I got my hands on our custom SSRS report and it looks like the report queries POAAPC and POINVAL tables for this case. I just did a few more queries, and both receipts and the invoice are in the POAAPC table, but only RCP1 and the invoice are in the POINVAL table, which seems in line with the posting journal.

So anyhow, I'm baffled by this. Any help or explanation would be greatly appreciated!

 

[DjangMan]

That does sound like a bug. They are probably looking only for a change in the extended amount when deciding if they are going to send an additional line to the posting journals. Could the invoice posting journal only be a reflection of what has gone to the GL on that invoice that is different from what went on the receipt? Unless you have a third-party application involved it has likely worked this way for a while.

 

[kdien]

I checked the working ones and my test ones as well. They all show on the PO Invoice Posting Journal, either as the difference or just O if there's no difference. And there's no third-party application for this process. I figured this must be a bug since the only scenario where it doesn't show in the posting journal is when both the quantity and unit cost are adjusted but still result in the same extended amount as the receipt. So I guess we're stuck on this then.