Does anyone know if it's possible to do an upload to change or add Account Distributions to a PO (PO21.3)? If this is possible, does anyone have an upload they are willing to share? Thanks so much for your help.
I have one from years ago - Infor Support tried several times to say it didn't and then gave me the fields anyway - let me look.
OK - from 2017- I don't know what version of 10 this was so you might need to adjust.
f3 - Company
f4 - MMD-SYSTEM-CD - column of "PO"
f5 - MMD-DOC-TYPE - column of "PT"
f6 - po#
f7 - po release
f8 - po code
f9 - po line number
f13 - MMD-LOCATION (the ship to from the line - I still don't know why it wanted this but it really does)
f36r0 - FC (A/C/D)
f37r0 - acct-unit
f38r0 - acct
f39r0 - sub acct
f42r0 - percent
f43r0 - amount
f44r0 - quantity
(for whatever reason - I ended up mapping percent, quantity and amount and just ignoring the ones I didn't want and leaving them with a blank column)
f166 - HK - which ended up being: inquire on the PO and hit the Multi - then use Ctrl+Alt+A to get to the xml and use the drop down on top to get to the transaction xml to find your value for that line. You should something that looks like: <_f166>0001POPT 24716460000000000 000001000 </_f166>. Put everything between <_f166></_f166> including spaces in your field.
Upload as Change Only.
