PO25.6 Line cost changes with add-ins

 6 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
Dave Humphrey
Basic Member Send Private Message
Posts: 18
Basic Member
We have an existing PO25 vendor agreement with many lines on it and we want to change the cost of certain lines/items.  We are trying to use add-ins, but I just can not figure out the correct steps/fields to use to change only certain lines.  Does anyone have instructions?
Matt_B
Advanced Member Send Private Message
Posts: 22
Advanced Member
Dave,

I think what you're missing is the sort option (_f6) and you'll the have to have something like Line number. Here's my simple upload for No-cost items: (This is for Version 10+)

A - _f2 PVN-Procurement-group
B- _f8, PVN-Ven-Agrmt-Ref
C- _f6, Sort-Option
D- _f14, PT-PVN-ITEM
E- _f15, PT-PVN-LINE-NBR
F- _f24, 0:Line-FC1
G- _f27:0, PVN-Item1
H- _f28:0, PVN-BASE-COST1
I- _f32:0, PVN-COST-OPTION1 (this is the no-charge part)

Kat V
Veteran Member Send Private Message
Posts: 1020
Veteran Member
To just change the cost, we just map
_f2 PVN-Procurement-group
_f8, PVN-Ven-Agrmt-Ref
_f14, PT-PVN-ITEM OR _f15, PT-PVN-LINE-NBR --- you pick one or the other not both.
_f24, 0:Line-FC1 C for change
_f28:0, PVN-BASE-COST1

upload as change only.
Dave Humphrey
Basic Member Send Private Message
Posts: 18
Basic Member
Thanks, we will give it a try and see if we can figure it out.
Dave Humphrey
Basic Member Send Private Message
Posts: 18
Basic Member
Thanks, we will give it a try and see if we can figure it out.
Jeremy
Veteran Member Send Private Message
Posts: 129
Veteran Member
I'm trying to do something similar. I'm adding lines to my agreement. Then, when I try to use an add-ins upload and FC of "R" for Release Hold on the line, I get a Change Complete, but the line is still on hold.
Any ideas?
I have:
f2, PVN-Procurement-group
f8, PVN-Ven-Agrmt-Ref
f15, PT-PVN-LINE-NBR
f24:0, Line-FC1
JonA
Veteran Member Send Private Message
Posts: 1163
Veteran Member
That should work. All I can say is double check your field/column mapping and make sure the agreement is not on hold at the header level.
Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health