Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Enterprise Resource Planning & Manufacturing
Lawson S3 Procurement
PO30 addins upload
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
HireIQ
Past 24 Hours:
0
Prev. 24 Hours:
0
Overall:
5264
People Online:
Visitors:
97
Members:
0
Total:
97
Online Now:
New Topics
Lawson S3 Procurement
Tolerance Settings
3/31/2025 2:01 PM
I've been trying to set a tolerance for some t
Dealing with Lawson / Infor
Printing Solutions other than MHC
3/27/2025 1:00 PM
What are others using for printing solutions besid
Lawson S3 Procurement
Green check marks in Lawson 9.0.1
3/20/2025 4:55 PM
Hi, How to remove green check mark on items when o
Lawson S3 HR/Payroll/Benefits
Pay Rate History to Show All Positions
2/26/2025 3:34 PM
Does anyone know how to modify payratehistory.htm
Infor CloudSuite
How to build a Pre-Prod tenant
2/7/2025 1:28 AM
After we finished our implementation and ended our
Lawson S3 Procurement
Browser issue with RQC Shopping
1/28/2025 5:49 PM
Since the recent Chrome/Edge updates, our RQC shop
Lawson S3 Procurement
S3-Procurement New Company
1/22/2025 10:38 PM
My Accounting Department has created a new Company
S3 Customization/Development
JUSTIFIED RIGHT
1/15/2025 7:41 PM
Is there a way in Lawson COBOL to make a character
S3 Systems Administration
ADFS certificate - new cert
12/3/2024 9:38 PM
The certificates on the windows boxes expired and
Lawson S3 HR/Payroll/Benefits
Post Tax Benefit Plan Table
11/14/2024 9:16 PM
Hi, totally new to Laswon. I have a repor
Top Forum Posters
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
Forums
Filtered Topics
Unanswered
Unresolved
Announcements
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Enterprise Resource Planning & Manufacturing
Lawson S3 Procurement
PO30 addins upload
Please
login
to post a reply.
9 Replies
0
Subscribed to this topic
1 Subscribed to this forum
Sort:
Oldest First
Most Recent First
Author
Messages
Sue Shirley
New Member
Posts: 1
10/19/2010 4:44 PM
Has any one used Addins to upload new receipts to PO30.1.
I am finding I need to run it twice. Once to add the receiver then again to add the lines to the receiver.
Any insights would be helpful,
Thanks
Sue
Red
Veteran Member
Posts: 87
10/19/2010 8:40 PM
Split
Sue,
That is pretty much going to be your only option. This applies to all similar screens that have mutiple detail lines underneath header information (basically, any screen that you need to hit the [Page Down] key to see the next set of lines).
The Exception - Small Documents
If you are creating a receiver that has five or fewer lines, you can create a file that explicitly details each of the fields. In essence, your spreadsheet becomes horizontal rather than vertical. As an example, rather than just pointing to field 41, to enter the function code and then going to the next line of your spreadsheet; you would have a column that relates to field 41 and a field that relates to field 127 (the second function code field). Now multiply that out by each data element necessary to create a valid receipt line.
Caveat 1 - The spreadsheet can be extremely tedious to build, especially when you are trying to line up with existing information (as you are in your receiver). This process is much easier when the file is fully creating the information (as you might be in creating a requisition or purchase order). Incidentally, it was in the creation of reqs and POs for system/load testing that I have used process--so it can work.
Caveat 2 - It is important to fill all of your "blank" cells with "spaces". This true for values that are truly null and for fields where you expect a value to be system-populated. The space clears out anything left in the cell from the previous record. Personally, I use a combination of hyphens and spaces. The hypen, in MS Excel, forces the cell format to text and is ignored in Add-Ins--it is simply a flag to show that I have a space in that cell. It looks like (' ) (without the parentheses).
Basically, you are doing what you want in the most efficient way I can think of. The time and energy needed to create a single-sweep-file would almost certainly outweigh any benefits.
Good luck,
Red
Nick
Veteran Member
Posts: 50
10/27/2010 9:59 PM
Split
On most forms with multiple detail lines like PO30, you can use the Position To field to upload to rows after the first five. Did you try mapping in PT-PRL-PO-LINE-NBR? I haven't tried it on PO30, but it works on other similar screens.
Leslie
Veteran Member
Posts: 45
9/24/2013 8:50 PM
Split
Is there any way to get the PO30 to release with the upload? I have a map that will work for everything but releasing.
JonA
Veteran Member
Posts: 1163
9/26/2013 11:53 AM
Split
You cannot do the release action with addins.
Leslie
Veteran Member
Posts: 45
9/27/2013 2:51 PM
Split
Thanks, Jon - That's what I thought, but there's always hope, right?
JonA
Veteran Member
Posts: 1163
9/27/2013 4:48 PM
Split
I do hope someday they modify Addins to do special actions like release. They have an Add then Change function, why not a Change then Release?
Leslie
Veteran Member
Posts: 45
10/11/2013 3:36 PM
Split
OK, we figured out a way with 2 uploads - one to add the receiver and lines in PO30 and then another one to upload the release file to PO35. It's working great!
Scott H.
Posts: 3
10/9/2014 12:58 PM
Split
Hi Leslie! Could you provide more detail about your solution? Thanks!
Kat V
Veteran Member
Posts: 1020
10/9/2014 8:01 PM
Split
PO35 is a release screen like PO22 releases POs. You upload to the position to fields and then put the FC on r0 and change.
Please
login
to post a reply.