Prev
Next
Forums Lawson S3 Supply Chain

New ship-to location pricing

Sort:
You are not authorized to post a reply.
Author
Messages
awalters
New Member
Posts: 3
New Member
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
    Veteran Member
    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
      Kat V
      Veteran Member
      Posts: 1020
      Veteran Member
      8/1/2013 1:48 PM
        We do the same - IT paint on Last Issued Cost
        brupp
        Veteran Member
        Posts: 165
        Veteran Member
        8/2/2013 7:15 PM
          I must be missing something - Why not use IC28?
          JonA
          Veteran Member
          Posts: 1162
          Veteran Member
          8/6/2013 3:25 PM
            Alex wants to load the cost to item locations that have no previous activity, no receipts.
            Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
            You are not authorized to post a reply.