Prev
Next
Forums Enterprise Resource Planning & Manufacturing Lawson S3 Procurement

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
6/22/2017 8: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
    Veteran Member
    Posts: 1020
    Veteran Member
    7/14/2017 8: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

      Diana
      Posts: 3
      8/8/2018 12:24 PM
        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
        8/8/2018 8:41 PM
          Mine worked as is. Have you tried adding the usual suspects like PO Release? Have you populated the HK166?
          Diana
          Posts: 3
          9/27/2018 1:23 PM
            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.