Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
User Experience
Lawson Add-Ins for Microsoft Office
PO25.6 Line cost changes with add-ins
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Jessica
Past 24 Hours:
2
Prev. 24 Hours:
0
Overall:
5164
People Online:
Visitors:
213
Members:
0
Total:
213
Online Now:
New Topics
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1348
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Lawson Add-Ins for Microsoft Office
PO25.6 Line cost changes with add-ins
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
Dave Humphrey
Basic Member
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
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
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
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
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
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
Posts: 1162
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.
You are not authorized to post a reply.