Go to previous topic
Go to next topic
Last Post 01/31/2020 2:16 PM by  Erik G.
Changing to 2 decimal pricing
 9 Replies
Author Messages
Bev Edwards
Lawson Consultant
Hilsmier Consulting, LLC
Veteran Member
(711 points)
Veteran Member
Posts:357


Send Message:

--
01/24/2016 3:38 PM

    We are moving from a 4 decimal pricing format to a 2 decimal format for all of our LUM pricing with Owens & Minor.

    I have changed all the pricing using the file they sent me, however, I noticed that the price is correct now, but still showing 4 decimals.

    Is that something hard coded in PO25.6?

     

    Bev

    David Williams
    Private
    Private
    Veteran Member
    (3256 points)
    Veteran Member
    Posts:1096


    Send Message:

    --
    01/24/2016 4:38 PM
    You have to update IC11 for each item.
    David Williams
    Bev Edwards
    Lawson Consultant
    Hilsmier Consulting, LLC
    Veteran Member
    (711 points)
    Veteran Member
    Posts:357


    Send Message:

    --
    01/24/2016 5:06 PM
    What would I need to update in IC11? I just wanted to update the pricing we already had in PO25.6. These are established LUM items but had a 4 decimal price. I wanted to change to a 2 decimal price. The price did change but the 4 decimal place holder remained.
    David Williams
    Private
    Private
    Veteran Member
    (3256 points)
    Veteran Member
    Posts:1096


    Send Message:

    --
    01/24/2016 6:12 PM
    4 decimals will display regardless of the cost (with the item on IC11 set to 4 decimals). The last 2 decimals should be 00.
    David Williams
    David Williams
    Private
    Private
    Veteran Member
    (3256 points)
    Veteran Member
    Posts:1096


    Send Message:

    --
    01/24/2016 6:13 PM
    If an item changed to $1.25 it will display as 1.2500
    David Williams
    Bev Edwards
    Lawson Consultant
    Hilsmier Consulting, LLC
    Veteran Member
    (711 points)
    Veteran Member
    Posts:357


    Send Message:

    --
    01/25/2016 8:43 AM
    Thanks David!
    AndreaS4
    Senior Supply Chain Analyst
    Private
    Basic Member
    (12 points)
    Basic Member
    Posts:6


    Send Message:

    --
    08/31/2016 2:16 PM
    Bev, did you have any issues when you went from 4 to 2 decimal places? We want to go from 3 to 2 decimal places, but I want to make sure it will not cause an issue elsewhere.
    Stacey
    EDI Analyst
    Private
    New Member
    (3 points)
    New Member
    Posts:1


    Send Message:

    --
    01/31/2020 1:55 PM
    Hi Bev,
    I have the same question, we are currently looking to standardization going from 4 decimal to 2. Did it have any impact to Accounts Payable?
    LauraPat
    Sr. Application Engineer
    Private
    Advanced Member
    (82 points)
    Advanced Member
    Posts:40


    Send Message:

    --
    01/31/2020 2:05 PM
    I would be curious as well. Our Materials Management group is going to be using a new tool which will require everything to be 2 decimals from the PO through to the invoice. We have invoice files that come in from both GHX and another outside vendor. I believe we will need to have them change the format of the file once the MM users go in and change the # of decimals in IC11. We were going to just do some testing to see what happens (in our test system) because I couldn't get a real straight answer from the vendor that is requiring this change or from Lawson.
    Erik G.
    System Analyst I
    Private
    Basic Member
    (32 points)
    Basic Member
    Posts:14


    Send Message:

    --
    01/31/2020 2:16 PM
    Stacey,

    I could be wrong (AP is not my strong suit in Lawson) but if your accounting team uses match rule groups, you will probably need to look at the tolerances that are set up to make sure they don't go out to 4 decimals.


    ---