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:
Chris Radcliffe
Past 24 Hours:
1
Prev. 24 Hours:
0
Overall:
5187
People Online:
Visitors:
230
Members:
0
Total:
230
Online Now:
New Topics
Lawson Landmark
LPL INSTR Functions
4/5/2024 8:32 PM
I'm writing a simple report using the Create R
Infor SCM
Translating 856 to get the ~ REF^CN^ field
4/3/2024 8:24 PM
We are trying to get the tracking number which is
IPA/ProcessFlow
Sample XML file create Flow
4/3/2024 3:43 PM
Hello everyone, I am new to creating XML files
Lawson S3 HR/Payroll/Benefits
bn105 error message
3/26/2024 6:40 PM
I need to change some of the set ups in our Life I
IPA/ProcessFlow
IPA executing Job
3/13/2024 7:08 PM
New to the IPA world and was wondering, can an IPA
Lawson S3 HR/Payroll/Benefits
Life Age Reduction on benefits plans
3/12/2024 7:15 PM
For our optional life we have an age based coverag
Lawson S3 HR/Payroll/Benefits
BN53.1 Add-In
3/7/2024 3:31 PM
We are migrating to Solstice. They require a
Lawson Business Intelligence/Reporting/Crystal
Domain Name Change
3/5/2024 7:45 PM
Our domain name needs to change and was hoping I c
S3 Customization/Development
Cobol calling Shell Script
2/29/2024 1:27 PM
Has anyone created or modified a Lawson Cobol prog
Infor ION
ION vs IPA
2/29/2024 1:24 AM
We had a person new to Lawson and Infor go to Info
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 S3 Procurement
PO30 addins upload
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
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
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
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
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: 1162
9/26/2013 11:53 AM
You cannot do the release action with addins.
Leslie
Veteran Member
Posts: 45
9/27/2013 2:51 PM
Thanks, Jon - That's what I thought, but there's always hope, right?
JonA
Veteran Member
Posts: 1162
9/27/2013 4:48 PM
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
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
Hi Leslie! Could you provide more detail about your solution? Thanks!
Kat V
Veteran Member
Posts: 1020
10/9/2014 8:01 PM
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.
You are not authorized to post a reply.