Who's On?

	Membership:
	Latest: John Bonin
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5270

	People Online:
	Visitors: 106
	Members: 0
	Total: 106

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1375
Roger French	1315
mark.cook	1244

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

6/22/2017 3:41 PM

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

6/22/2017 5:18 PM

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

6/22/2017 8:44 PM

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

6/23/2017 12:55 PM

Thanks, we will give it a try and see if we can figure it out.

Dave Humphrey

Basic Member Send Private Message

Posts: 18

6/23/2017 12:55 PM

Thanks, we will give it a try and see if we can figure it out.

Jeremy

Veteran Member Send Private Message

Posts: 129

6/20/2018 1:57 PM

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

6/21/2018 7:20 PM

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.