×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

PO Receipt -> Invoice -> PO Posting Journals

PO Receipt -> Invoice -> PO Posting Journals

PO Receipt -> Invoice -> PO Posting Journals

(OP)
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.

RE: PO Receipt -> Invoice -> PO Posting Journals

Can you reproduce this in sample company?

RE: PO Receipt -> Invoice -> PO Posting Journals

(OP)
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!

RE: PO Receipt -> Invoice -> PO Posting Journals

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.

RE: PO Receipt -> Invoice -> PO Posting Journals

(OP)
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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close