Updating Pars in IC81.2 - Field Replenish from Location -

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

Saurabh

Veteran Member

Posts: 94

3/21/2011 8:02 PM

Hi all
Can anyone advise what the easiest way to update the Par replenish from location(IC81.2).
We have created a new location and need to update the IC81.2 records from old to new.
Have been trying to use the upload wizard but not been very sucessfull? I have previously added the record but have not been able to chnage it?
If anyone has a uwf query and they can shre it that would be great.

Also if we updated that via sql backend can anyone see it causing any issues?

Regards
Saurabh

JonA

Veteran Member

Posts: 1163

3/22/2011 11:23 AM

Here's my Addins update file and a couple screen shots of how I set it up.

Attachments

Saurabh

Veteran Member

Posts: 94

3/22/2011 12:57 PM

Hi Jon
Thanks for the files. I have tried to use them against my data but i get a message
"Change complete - Line(s) not changed"
I have attached my upload screenshot and source data.
Any ideas?
regards
Saurabh

Attachments

ic81_error.doc

Kevin

Basic Member

Posts: 9

3/22/2011 5:20 PM

Hi Sarah, I was looking at the attachments to see if I could add any suggestions. Are you using IC81.1 or IC81.2 to upload with?

JonA

Veteran Member

Posts: 1163

3/22/2011 5:48 PM

What version of Lawson Apps and MS-Addins are you using?

Leslie

Veteran Member

Posts: 45

3/22/2011 10:26 PM

I use a different map and .uwf file. Try this one. Format your Excel worksheet like the one attached. The last column is a hidden key; copy the formula and drag it down to the end of the file. If your product is coming from an inventory location, don't put anything in the "Vendor# or co#" field or the "Purchase From or Whse" field. The warehouse location should default in. If it doesn't, try loading your stock and nonstock items on separate worksheets.

Saurabh

Veteran Member

Posts: 94

3/23/2011 12:59 PM

@Kevin- I am using IC81.2

@Jon - We are on 8.10 MSP5,LSF9.0.0.4 - Addin version 9.0.3.1

@Leslie - Thanks for the files . I will try those and update post with findings

JonA

Veteran Member

Posts: 1163

3/23/2011 4:54 PM

I don't see any reason that my uwf file would not work for you. Un;ess there's a difference between the ITEMSRC tables for 8.1 and 9.0.

Deana_W

Basic Member

Posts: 7

2/8/2018 4:35 PM

Hi Leslie,

I came across your post in regards to IC81.2 changes but I do not see your attachment. I can't find any information on the hidden field in IC81.2 and would greatly appreciate any help.

Russ M

Advanced Member

Posts: 18

2/9/2018 8:14 PM

I am seeing a message 'Item detail entered, transmit to update' when updating items in the IC81.2 via add-ins. Is anyone else seeing this?

JonA

Veteran Member

Posts: 1163

2/9/2018 8:26 PM

I always update IC81.2 via IC81.1

Russ M

Advanced Member

Posts: 18

2/9/2018 8:48 PM

I'm attempting to update 'User Field 1' (f22) which is a shared value in th itemloc table with the IC12. Unfortunately I do not see the field identifier in the IC81 options.

Kat V

Veteran Member

Posts: 1020

2/9/2018 8:56 PM

When uploading to IC81.2, I have to upload to IC81.1 then scroll through to get to the IC81.2 fields. As a result, the field id numbers are off for the IC81.2. I'm on 10.07 apps and the user field is mapping as f55:0 and it's called user field 11, but it changes the IC82.1 UF1 when I try it.

Attachments

2-9-2018 4-53-15 PM.png

Russ M

Advanced Member

Posts: 18

2/9/2018 9:01 PM

I see that. Based on the new messages I am getting with the current upload, I'll have to play with it over the weekend. Will Let you know how it goes though. Thanks for the reply!

Russ M

Advanced Member

Posts: 18

2/12/2018 8:14 PM

Kat - If you are online I have a question. I'm using the location info (Company, location), Bin Sequence, preferred bin and item. With the Line-FC1 (f24) selected to change, I'm only getting one line changed in a list. My past experiences in the PO and AP worlds would allow me to use it for each line to be changed. With the IC81, it is only changing one line. I'm looking at changing thousands of lines. What am I missing please? FYI, the user field is changing for the single value that does change correctly. Thanks, Russ

Kat V

Veteran Member

Posts: 1020

2/12/2018 8:58 PM

You're missing the PT BDG Bin Seq - the position to bin sequence. It's not positioning to the correct line without it.

Russ M

Advanced Member

Posts: 18

2/12/2018 9:12 PM

So I am getting one item to upload successfully using the IC81 to update the IC81.2. Just trying to do to an add in User Field 1 using User Field 11. I'm using f24:0, LINE-FC1 with a value of 'C'. First line of the record changes correctly, all others come back with 'Bin Sequence already exist (_f25r0)'. Can someone please tell me what I'm missing here? Thanks

Attachments

IC81 upload.png

Russ M

Advanced Member

Posts: 18

2/12/2018 9:17 PM

Would that correlate to the beginning sequence number for each location?

Kat V

Veteran Member

Posts: 1020

2/12/2018 9:22 PM

Likely, yes. If you were to manually do this on IC81, it's how you get to the line. Either Bin Seq or Item (not both, we get errors). See my attached screenshot.

You want to go to either field and use ctrl+shift+o to get the field number. It's high enough on the list, it should match the upload drop down.

Attachments

2-12-2018 5-19-26 PM.png

Russ M

Advanced Member

Posts: 18

2/12/2018 9:33 PM

Nevermind...I figured it out myself. Sometimes I'm just silly. Thanks again for your help. Supported Mayo for 13 years in Supply Chain. If you ever have questions about EDI, let me know...Regards, Russs

klemmyjb

Basic Member

Posts: 14

9/13/2024 5:05 PM

HI Russ,
Can you please share how you update IC81/IC82 with me I am getting same Error here I am trying to update Manu Information.