Report as finished error - quantity cannot be picked as 0 is available

Hi, I am running AX 2012 FP where my inventory model is FIFO with no negative inventory physical 

I receive the raw item in inventory warehouse location (10) and on-hand shows that it is sitting in the correct location 

that's the only part on a BoM, the production will place the finished good at location 30 

automatic BoM and route consumption When I post the picklist it is correctly showing the amount in WIP. 

after posting the pick-list, when I report as finished I am getting the following error. 

Have anyone come across this scenario (when I allow pick negative from Inv model it is working fine). 

The quantity cannot be reduced. The number of inventory transactions on order is too low because the quantity or part of it is referenced by an output order or a production order or is marked against other transactions.
  • In reply to Patrick Am:

    Brining in cost at zero will impact on average and when financially consumed it will consume it correctly at zero cost.

    If you do not control physical stock by location and allow negative stock this will happen and will cause you issues, the close procedure cannot match this cost until the inventory is zero and therefore skips it in teh calculation (I believe).

  • In reply to AdamRoue:

    Thanks Adam. How could we rectify this now? Why AX doesn't deduct the quantity from location A but instead deduct from Location B where is no quantity on-hand.  In the FIFO model, I didn't allow negative.  But then how AX is able to deduct from a location where there is no quantity is what baffles me?  In the production order, I can see that the locations for all BoM line (raw materials) are populated as Location B. 

    When I create a Production order - I set Site, WH and Location B.  Could that be the reason? 

  • In reply to Patrick Am:

    You are not physically tracking at location so it does not care as you told it not to. Will not check negative, but I believe the costing cares. To correct it move teh stock from A to B. You cannot as standard define the location on a BOM line, you must have modified this, it is only warehouse. If on the warehouse you define B this will "probably" backflush to B - try it without and see where it takes stock from - my guess would be the default location if you have set it up, but it will reserve as well but the issue will come back to you not physically tracking at location which is your main issue I believe.

  • In reply to AdamRoue:

    Hi Adam, so if I am not tracking the item at specific location, but tracking is set at Site and Warehouse level, it seems AX allow the negative quantity at location level. 

    I set the location for the production order to "B" and I see that by default all production bom components have this dimension. 

    What I notice is that, at the warehouse level, the total quantity is correct and also the financial amount - the way it would calculate the running average. 

    It also seems to be that I need to set up the warehouse item location for each item which i think will default on the production order. 

    When I manually change the dimension for the Raw matl,  i see that AX has consumed correctly from that location.  Does it mean, that we need to update the inventory location every time I run the production order? 

    many thanks  

  • In reply to Patrick Am:

    Patrick Am

    When I manually change the dimension for the Raw matl,  i see that AX has consumed correctly from that location.  Does it mean, that we need to update the inventory location every time I run the production order? 

    Essentially you have turned on location control but do not care about the physical stock in the location, which I feel is wrong. When using locations if you are producing into one location I would want the journal to consume from the correct mixed locations - reservation would do this if you controlled the location dimension, however if you are autoconsuming it takes the location on the production order (or I beleive the one on teh resource for operation stepped consumption) in these instances you have to ensure you plan the system to remove from one location (like production withdraw) that you always move stock into and control any negative elements. Ultimately it depends upon the process and what you are trying to achieve.

  • In reply to AdamRoue:

    Hi Adam, you are absolutely correct on this. I turned the location as one of the storage dimension but i didn't tick the physical and financial for that location. Since we are auto-consuming, it takes the location from the production order location.  

    1) So how could I control the location dimension going forward? 

    For now, I am going to manually change the consumption location for components (in the production order) so at least the consumption is taking place correctly, since we are auto-consuming it. 

    2) For the transaction already done, could we move the positive stock from Location A (where it should have consumed origionally) to the Location B (where the negative stock is)? 

    Thank you 

  • In reply to AdamRoue:

    AdamRoue
    If on the warehouse you define B this will "probably" backflush to B - try it without and see where it takes stock from - my guess would be the default location if you have set it up, but it will reserve as well but the issue will come back to you not physically tracking at location which is your main issue I believe.

    Hi adam, yes on the warehouse, I set the location "A" for the raw material, but i am auto-consuming so will it still back-flush this location, even though production is consuming from location B (because it is picking up from the production order location default). 

    otherwise, you as recommended, I need to control at the location level. Appreciate if you could advise how I can do that. 

  • In reply to Patrick Am:

    Actually, I noticed that when I set the warehouse item location at the component level, AX automatically default to that location in the production material consumption so I didn't have to manually change in the production bom everytime.  This would work for us and the material is taken from the correct location. 

  • In reply to Patrick Am:

    I would go for option 2. and I would ensure that in the future there is a process to move stock into the production area where it is being made (location) to ensure the stock is consumed from the correct location.

Related
Recommended