Receiver ID Always showing same thing

Good morning all:

When our receiving department here receives items on a purchase order, or someone goes to Purchase Receipt Entry screen, when they print the actual receiver, the "Receiver ID" always shows "PR-0058469", no matter who the receiver is / was.

I checked the fields in Gupta, and it shows the field as "RECEIVER_ID". If I change that option to "RECEIVER_ID_BC", then that line is completely empty.

What I can't figure out, is where to set up Receiver ID's within Visual. This system was set up by our old parent company years ago, and those support folks are no longer available. I have been able to figure most stuff out on these reports, but this one just has me baffled.

We have 5 people in our receiving department, and what they are requesting is the actual Visual Username of the person who received it be placed in that spot, or some sort of name identification instead of that same number.

Can anyone offer suggestions on what I am overlooking?

Thank you!

Find more posts tagged with

VISUAL - Enterprise General Discussions

Comments

judy

Our receivers each have a unique ID. I setup the Auto Numbering within the Purchase Receipt Entry. You could also use a User Defined Field for a person's name and add it to the entry screen and onto the report.

unknown

Thank you for the reply. Is that done within Employee Maintenance?

judy

The auto numbering and user defined are setup within the purchase receipt entry screen. You will find them both under the Edit. You can also add a column for the user defined to the browse screen so you can see it and sort by it.

unknown

HI,

The receiver ID in the data base is actually the unique identifier for the receiver document. To get the Visual User ID and/or name on your report will require you to add an extended query to your report. For some reason the receiver USER_ID field has not been made available in the receiver report.

The extended query you would need would read something like this:

SELECT RECEIVER.USER_ID

FROM RECEIVER

WHERE RECEIVER.RECEIVER_ID = :RECEIVER_ID

If you want the User Name you will have to do a join to the Employee Table (Make sure USER ID is updated in the Employee table)

That query would be…

SELECT RECEIVER.USER_ID, EMPLOYEE.LAST_NAME, EMPLOYEE.FIRST_NAME

FROM RECEIVER LEFT OUTER JOIN

EMPLOYEE ON RECEIVER.USER_ID = EMPLOYEE.USER_ID

WHERE RECEIVER.RECEIVER_ID = :RECEIVER_ID

NOTE… I’ve made the assumption that your report does not currently have an extended query defined.

Do a search in the knowledge base for “Extended query” I believe there are one or two KB that will walk you through the process.

Regards,

Copyright © 2025 Infor. All rights reserved.