Bill of Material. MRP, Production Management, Product Configuration
- 495 Topics
- 1,771 Replies
We utilize the product configurator capability and learned today that we have been creating production orders within a sales order with expired BOM’s. The Bom revision changed to Rev B and Rev A was set to On Hold and with an expired date. The customer service team entered the make to order sales order and created the production order within the sales order as normal. Production orders were created with the obsolete BOM revision. Obviously we need to update the configurator now to the current active rev. I’m surprised the configurator wouldn’t error out in creating production orders with expired and on hold BOM’s.
Scenario: A sales order is entered for qty 100 of a manufactured item. A production order is created for all 100 pieces to drive the material requirements.Only 5 pieces are going to be produced and shipped this week, but when the RELEASE MATERIALS action is selected, Acumatica always puts the total material for the whole production order (unless there are shortages) and the user has to adjust every single line so that material is only released to cover the 5 units being produced (there could be hundreds of line items): Is there a way to select the quantity to be produced off of the production order, and have Acumatica calculate the required component quantity automatically so that each line doesn’t have to be manually adjusted?The work around I have them using right now is to export this list from the Material Wizard to excel, use excel to calculate the required quantities for the partial production quantity and then upload the spreadsheet on the Materials screen as a new transaction.
We are preparing our system for go live and would like to upload some sales figures from this year into the Generate Forecasts form to predict next years (2024) demand. I have extracted the figures from our current system and am preparing an upload into the screen below. The upload will be a list of items c/w begin and end dates and quantities. My question is; do I enter the begin and end dates for each month as historical (e.g. between 01/05/23 & 31/05/23 we sold 35 of a particular item) or predicted (e.g. between 01/05/24 & 31/05/24 we think we are going to sell 35 of a particular item based on last years’ sales)?
Would anyone know if there is a posibility to update the start/end dates on an operation itself? i know you can update the actual work order but i would like to have seperate dates for each operation so each team have there own start date.Thanks!
We have a need to be able to put multiple replenishments on a single item within the same warehouse. Our case for it is that our inventory control teams need to be able to deliver an item to a production line (Warehouse) in different locations. We use a Warehouse in Acumatica for each production line. But we can’t apply a replenishment for that warehouse because we have a single item occur multiple times on that production line. So we have to use a 3rd party system to notify our inventory control team to deliver the items to the production line. We would love to be able to no longer use that system but rather utilize the replenishment through transfer feature in Acumatica. Any suggestions would be great!
Materials Consumption GI was working fine for us then all of a sudden the ‘Actual Consumed QTY’ field stopped working properly (calculations are off). If we pull up the Production Order GI the QTY for labels consumption is accurate on a specific order (2 and 544). Which should = 546 Actual Consumed QTY for labels. However on our Materials Consumption GI for that same production order, only the most recent 2 Actual Consumed QTY is displayed. The Materials Consumption GI is set up as AMProdMatl.QtyRemaining We also tested reversing the 544 qty, and the total adjust to -542. Our question is why isn’t the 544 being calculated properly in this GI?
Looking for fellow users of Manufacturing and Arena so we can leverage experiences and draw from one another’s growing pains and gains. Is anyone up for connecting to see where we may be able to leverage common work and shorten the curve as some say. Two asks: Any tips or tricks to get Vendor Details to successfully import to Acumatica. I am stuck with an error that is blocking progress. I’m currently waiting on a help ticket. Outside processes. In other manufacturing instances I have created a non-stock item and included it on the materials list for the outside process operation to facilitate the purchase order and billing of the outside process. Due to the limitation of not being able to add materials to BOMs in Acumatica, I am looking for a work around short of creating a non-stock item in Arena, adding it to required BOMs and then importing BOMs again? If the import is limited to BOMs with outside processes then this whole thing is easier to manage, as someone would have to ensure
I have a client that purchases used equipment for refurbishing. They do not always know if an item can be refurbished at the time of purchase. One of the operations in production is to assess the item. If an item cannot be refurbished for sale, it gets put back into inventory in a quarantine location using a negative material transaction. Eventually the item is parted out using a disassembly production order to get as much value out of the item and the parted items are used for future repairs and refurbishments. There is labor incurred in the disassembly process however we cannot get the cost of labor allocated to the parted-out items. Is it possible to capitalize labor as part of the disassemble transaction? I tried recording a labor transaction as both a positive and negative and, in both cases, it ends up in the WIP adjustment entry for the difference between the parted-out items and the cost of the item being disassembled.
Hi,Looking for input on how to correct a product configuration and resulting production order that is in progress or completed.Scenario: A production order is created and partially completed, when it is decided that there needs to be a small change to the configuration. We manufacture portable storage buildings (pineviewbuildings.com) and in our case, this might be something as simple as changing the paint color due to a customer request or inventory needs changing midstream. The more common scenario is that a production employee made a mistake in the construction and now the configuration needs to be corrected to match the physical unit. Currently, there is no option modify the product configuration in any way after the production order has been released. The closest we can come is creating a new production order that consumes the finished good from the first production order, create the correct configuration result and then manually modify the materials. This, as you can imagine is v
We have recently deployed Acumatica in a live environment, but have noticed some issues on the costing.It appears that if a Production Order Detail uses material with UOMs other than the base UOM, any negative move would lead to backflushing negative Material Issues of incorrect quantities and amount. To illustrate this, we tested two production orders - one with materials in the base UOM (KG), one in materials not using the base UOM (MTON). Both are using average valuation / no serial lot tracking, and have negative quantities enabled in Item Class. We released a move transaction with 100 qty, then perform a full reversal of the 100 qty by releasing negative move transactions with -1 qty, -50 qty, and -49 qty. We noticed that the initial incoming 100 qty is treated and converted correctly in both cases. Material in Base UOM Base UOM - Material Issues reversed accurately However, for non-base UOMs, the reversing Material Issue is incorrect and leaves behind a discrepancy in the WIP
Hi guys, I have been introducing the packing feature to our factory staff and training them up on this.I have been experiencing an issue where when the shipment is open, and a run of production is complete, the produced items OCCASIONALY do not allocate to the sales order and therefore cannot be added to the shipment. Has anyone else experienced this? Thanks all, Aleks
We are currently trying to change the scrap percentage of a component which exists in thousands of parts, and it looks like the Mass Change function in Bills Of Materials work space is limited to only replace one part for another. I was hoping there would be something that we could make a change to any field that exists in the BOM for a component and be able to reload to Acumatica.
Accidentally closed a production order before all material issues were done.We really need the lot/serial information of this material to be recorded on the production order.Since you can’t re-open a production order, how can these skipped issues be corrected?
Hi SirWe would like to know what mean of production variance.As we do a disassembly transaction and notice that system auto generate “ production variance” May i know what is this for? Please refer to the below.If based on below journal , does it mean the production variance 21.44 is reduce the inventory value as the double entry is credit account code14720 inventory.
I’m working with a customer who is setting up a fairly lengthy configurator for their industrial product. He discovered that if he missed an option for one of the features, and then adds it in under the Features form, that it will not pull this new option into the selection set within the maintenance for his configuration. He ends up having to delete the feature, and then add it back in and recreate all the rules associated with that feature. I did see that you can export options and rules, then import them again when you recreate which should help the situation.Has anyone else noticed this, and is there any other way to update the feature without having to remove it from the configuration. I tried using the refresh tool and that didn’t appear to pull in the new option. Thanks in advance for any assistance or suggestions.
We have a client using MRP forecasts in Build 23.104.0027. Demand Time Fence in MRP settings is set to 30 days. MRP Prefefences, Demand Time Fence set to 30 days. According to help, this is “The number of days within which the system excludes forecast records from demand data; the period starts from the day when MRP is performed. Forecasts are ignored by MRP if they have a start date specified on the Forecast (AM202000) form that is earlier than the MRP run date minus the number of days specified in this box.”MRP was regenerated today, Nov 16, 23. This is the forecast for one part, 14 per month. Since it is mid November, I would expect MRP to skip the Dec forcast demand since it is within 30 days. But, this is the MRP Detail Inquiry for this part. Anyone know how MRP is actually using that Demand Time Fence number, or how to get MRP to skip forecast demand within 30 days?
Is there a setting to allow using the same lot number for an item for multiple production orders? I have a client that tracks the lot number of the component. They usually create several orders to consume the component, but can’t use the same lot number across multiple production orders.
I have read a variety of the posts on here and don't think I saw a clear answer on forecast consumption logic….. I am currently testing to understand the consumption logic before we launch forecasting. I have created a weekly forecast of 6 pcs/wk for 6 months and then entered sales orders for 5 weeks that are both under and over that weekly qty. It seems like the logic is to ONLY consume forecast within that week and not backward or forward consume forecast - Is that correct? Is this a setting we can modify to set the # of weeks/days forward and backward to consume? Our customer orders are not as consistent as a weekly forecast would assume and this would cause us the need to constantly reforecast or clear individual weeks each week forecast wasn’t matched or potentially overplan our demand when forecasts are not met, which is why consumption logic is often an MRP setting.
Login to the community
Social LoginLogin with your Acumatica account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.