PO Distribution Upload

 4 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
Kat V
Veteran Member
Posts: 1020
Veteran Member
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!

Anyone have a PO21.3 upload map handy?  I'm having issues trying to figure out the HK.

 

MMD- Component Sequence and AOC Code are particularly head-scratchy to me.

Kat V
Veteran Member
Posts: 1020
Veteran Member
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!

Infor Development helped solve this issue - although they also think there is no way to position to.
To find the HK f166 - go to the PO, click Multi and then use Ctrl+Alt+A (about) to open the xml.
On the menu bar change view to Transaction XML - the field is at the bottom of the list.  If you are loading to multiple POs, you will need to figure out the sequence for the HK - It's 47 character concatenated of f3 - f11.

Not on there is PO Location which turned out to be my missing field.

So the mapping is:

_f3:MMD-COMPANY
_f4:MMD-SYSTEM-CD = PO
_f5:MMD-DOC-TYPE = PT
_f6:MMD-DOC-NUMBER = 14 CHARACTER PO NUMBER
f8 PO Code
_f9:MMD-LINE-NBR
_f13:MMD-LOCATION = 5 CHARACTERS FROM PO20 SHIP TO FIELD
_f36:LINE-FC
 f37:MMD-ACCT-UNIT
 f38:MMD-ACCOUNT
 f39:MMD-SUB-ACCT

YOU WOULD PICK ONE OF THE FOLLOWING AND LEAVE THE OTHER 2 BLANK
 f42:MMD-DIST-PERCENT
 f43:MMD-DIST-AMOUNT
 f44:MMD-DIST-QTY
f166: HK166

Diana
Posts: 3
I used the format above for my PO21.3 ADD-In. However, I received the following error message:

Must inquire before using this function code (_f0)

Have you experienced this error, if so, how did you get your upload to work?

Thanks,
Diana Theriot
Ochsner Health Systems
Kat V
Veteran Member
Posts: 1020
Veteran Member
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
Mine worked as is. Have you tried adding the usual suspects like PO Release? Have you populated the HK166?
Diana
Posts: 3
The purchase order is released. I found the HK code, by using Ctrl-Alt-A in PO21.3. It was 47-characters. I am still receiving the "Must Inquire First" error message. I feel like I am missing a simple fix.