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.
- 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.