Can anyone help me? A few days ago I activated the backflow of materials, we work with different warehouses and each warehouse has locations, therefore, each location manages inventories.
I release production orders for specific locations of the same warehouse, my logic would be that when materials are consumed, they would be from the location where the work is being done, but when I check the materials that were consumed, I see that they are consumed from different locations.
Is there a way to force it to only take components from a single location?
For example, this order should be working on the location 46-99-1-A-1
What version are you using? I recreated this scenario in Build 23.212.0024 by creating a new Finished Good and Raw Material. Adjusted in a quantity of 1, two separate times into different locations. This creates a FIFO lot and allowed me to put the second lot into the Production Order location.
If I clear the Location from the Production Order Details then it goes back to using the FIFO lot
You said you turned on Backflushing but your screenshot shows that Backflushing is turned off. Either way, I turned Backflushing on and set the Location to “BACKFLUSH” (non FIFO lot) and you can see here it pulls from that Location through Backflushing
The only other variable I did not test that I can think of is if you are lot tracking or using another Issue Method besides FIFO.
What does your BOM look like for that product? Within the Materials section of the BOM there are two fields that might help you here:
Warehouse
The warehouse from which the material is issued. If this box is empty, the system uses the warehouse specified in the Warehouse box of a production order on the Production Order Maintenance (AM201500) form.
Location
The warehouse location from which the material is issued. If the column is empty, the system selects a warehouse location, as described in Production Processing: Selection of Warehouse Locations. If the Backflush Materials check box is selected and the warehouse location is specified, the material is issued only from this location as follows:
If the Allow Negative Quantity check box is selected for the item class assigned to the material, the system issues the material from this location regardless of the required quantity.
If the Allow Negative Quantity check box is cleared, the system issues only the material quantity that is available in this location.
If the Allow Negative Quantity check box is cleared and the available material quantity in the location is zero, the system does not issue the material and returns an error message on the form from which the material issue has been requested.
@JavierGtz Did you define the location in the materials tab of the production order details (AM209000) form?
I did a test adding the location to see if that works, I also moved the inventory of 1 component from the location I'm working at but the system deducted the material from the location even though the component's inventory was 0, I don't know how it could do it but it happened.
What does your BOM look like for that product? Within the Materials section of the BOM there are two fields that might help you here:
Warehouse
The warehouse from which the material is issued. If this box is empty, the system uses the warehouse specified in the Warehouse box of a production order on the Production Order Maintenance (AM201500) form.
Location
The warehouse location from which the material is issued. If the column is empty, the system selects a warehouse location, as described in Production Processing: Selection of Warehouse Locations. If the Backflush Materials check box is selected and the warehouse location is specified, the material is issued only from this location as follows:
If the Allow Negative Quantity check box is selected for the item class assigned to the material, the system issues the material from this location regardless of the required quantity.
If the Allow Negative Quantity check box is cleared, the system issues only the material quantity that is available in this location.
If the Allow Negative Quantity check box is cleared and the available material quantity in the location is zero, the system does not issue the material and returns an error message on the form from which the material issue has been requested.
What version are you using? I recreated this scenario in Build 23.212.0024 by creating a new Finished Good and Raw Material. Adjusted in a quantity of 1, two separate times into different locations. This creates a FIFO lot and allowed me to put the second lot into the Production Order location.
If I clear the Location from the Production Order Details then it goes back to using the FIFO lot
You said you turned on Backflushing but your screenshot shows that Backflushing is turned off. Either way, I turned Backflushing on and set the Location to “BACKFLUSH” (non FIFO lot) and you can see here it pulls from that Location through Backflushing
The only other variable I did not test that I can think of is if you are lot tracking or using another Issue Method besides FIFO.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
