PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 07/14/2017 4:00 PM by  Kat V
PO Distribution Upload
 1 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Kat V
Sr Supply Chain System Analyst
South Broward Hospital District
Veteran Member
(1831 points)
Veteran Member
Posts:625


Send Message:

--
06/22/2017 4:41 PM

    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
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (1831 points)
    Veteran Member
    Posts:625


    Send Message:

    --
    07/14/2017 4:00 PM

    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

    You are not authorized to post a reply.