Australia - National - AX

  • 1.  Costprice fluctuations

    Posted 16 days ago
    Hi,
    we're currently running AX2012 R3CU10 with weighted average turned on.
    We've seen some big quantities coming through and therefore these fluctuations stands out.
    I'm a little at a loss where these originates from and would like to see if someone in here have an idea?

    CostPrice1

    First transaction after inventory closure the cost price for the sales order picked up a cost price different from the closing cost price.

    How does that make sense?


    CostPrice2

    After I did inventory closure last month end it calculated a proper cost price.

    We had a couple of purchase order received which calculated ok.

    We then did a Quarantine transaction where we use the scanner and moved the item from it's location into damaged/blocking location.

    I'm not sure what happened there but it seems that it grabbed a cost price out of the blue $126.60.

    When they do these transaction on the scanner, they don't enter any cost price, do you know where AX calculates the cost price from?

    And once calculated it seems to keep that cost price on future sales orders as well, as you can see below, how can that be?



    Once month end runs this will rectify but in the mean time the system reports margins all wrong. Which is a huge issue.
    thanks
    Soren

    ------------------------------
    Soren Normann Rasmussen
    SSS Australia
    Murarrie
    ------------------------------


If you've found this thread useful, dive deeper into User Group community content by role