New ship-to location pricing - LawsonGuru.com

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

awalters

New Member

Posts: 3

7/31/2013 8:29 PM

Does anybody know a way to upload the cost in Lawson to a new ship-to location so it doesn't cause first-order errors? For instance: When a user orders an item in RQC, if there is an established cost history for that item for the location they're ordering from, it's no problem. But when we change the location, that cost history doesn't transfer over, and it causes an error for the user that says they need to enter a cost. Perhaps there's a paint screen or upload that we can use to copy over the history. Maybe not. I figure you all are the ones who would know! If my terminology needs clarification or more information is needed, I can try to make it more understandable.

Thanks!

- Alex

Michelle Wetzel

Veteran Member

Posts: 183

New Poster

7/31/2013 8:41 PM

Alex,

Originally, we were adjusting the product in to the new location and then adjusting them out again to "initiate" the cost. We came up with that idea because it was what we had to do in our previous system. However, we had some issues with the value of the item not always hitting the same GL account on the adjust in versus out. I can't remember which order you need to do them in, but if you reverse it - it goes to a different account than the adjustment account.

Our IT department created a page within Lawson for us that is coded to update the last received, last issued, standard and average costs for the item and location. It forces the override of those four at the database level which relieved the GL issues we were having.

Michelle