Manufacturing

Hi All,I am currently working on an Inventory Report and need to access the underlying Data for Inventory Allocation Details.I am 95% there by using INSiteStatus and INItemPlan Tables. But I am missing a crucial piece and that is the Reference Nbr: Anybody have an idea on where this is stored/how I can access this?The Document Type/Allocation Type, Allocation Date etc are all stored in INItemPlan but I cannot seem to find the actual Source Document or the reference number related to it. This would be crucial for this Report.

Hello,I’m trying to create a dashboard widget that shows end inventory balance by period as a line graph.  The Account by Period inquiry has the information I need when I filter to our inventory account, but when I try to add this inquiry to a widget it returns ‘No Data’.  Is there a way to easily copy this report into my own GI?  

Is there a way to create a navigation link on a GI to the “Create Labor Transaction” action?I currently have the navigation link to go to the “Labor” transaction screen, but the user has to add the labor transaction details.I want the Order Type, Production Order Number, Operation ID, Employee ID (based on user logged in), and Shift to auto-populate using the values from the GI so the user only has to enter the labor time and quantity if any.

We want to be able to track common inventory items that maybe used at multiple work stations in our assembly department.  Some of our production uses common BOMs because the same option is shared a crossed different units that are built on different assembly lines.  An example is the same meter package is used on Unit X and Unit Y.  But is consumed on Line 1 station 2, and Line 3 station 2 respectively.  How can we track inventory at each different station without the need for separate BOMs?  Is there a way to set stocking quantities by location & part?

when selecting employee employee rate is not comming on labor rateset the employee rate in labor rate screen.what am i missing out .

Hi All,I am going to try and keep it simpleOn a BOM there exist an item 0001 Nuts with a qty of 10, but then later on that same item’s qty needs to be changed to 12. So instead of the user searching if that item already exists on the BOM they just add another line with qty 2.When you go look at the where used inquiry it only shows the qty 10 off and not the qty 2 off.Can someone please explain why this happens.Thank youDries

The MRP procedures state that the "Calculate Replenishment Parameters" function in the inventory module can be used to review the following items:Safety Stock/Reorder Point Lot SizesHowever, there is a note in the "Creation of a Replenishment Class" section specifying:"If you want to configure automatic calculation of replenishment parameters, you must use only replenishment classes with the Purchase or Transfer replenishment source. For details, see Configuration of Replenishment: Replenishment Methods and Configuration of Replenishment: Demand Forecast Model."We are deploying the usage of MRP and want to have suggested safety stocks or reorder points under different service levels as part of our internal ABC Inventory Management Strategy. However, when calculating the replenishment parameters, only parameters associated with demand are shown (as we get the demand with the top accessible assembly). No information is shown for lead time.The item is manufactured and has an associated BO

Where are these accounts set up for stock items?  When the item class is selected on the General tab it auto populates these GL accounts and I need to revise some of them.  

I am trying to add a customization but the plus button is grayed out.  I have the Administrator role and access rights to this screen show Administrator has Delete rights, which I believe is the highest level of rights.  Does anybody know why this is grayed out? 

Looking to understand how the release of materials on a production order relates with the production ticket. We are looking to use the production ticket as a picklist in our manufacturing facility, but the production ticket is driven from the Production Detail. The Production Detail only shows locations for items ordered through Critical Materials or items that have been manually allocated in Production Detail. We can have up to 60 line items on a Production Detail so manually allocating each item is not an efficient use of time. Additionally, most of our items are purchased through MRP, not Critical Materials. Is there anyway to automate inventory allocations to a production order? When releasing materials for a production order, the system will select a location by default but you can manually change the locations prior to release. In my mind, it makes sense to have a printable version of the material release which can then be provided to the warehouse staff for picking purposes (sin

We are ready to do an overhaul of stock ID #s in our system.  We have tested the “change ID” function in Acumatica and from what we can tell it does a very good job.  Seems to override any and all instances of the previous id number with the new number.  However we want to have a record of what the previous number was, in case of records created outside of Acumatica printed copies, numbers in hard copy files, etc.  I have been unable to locate any location where we can find the history of what old numbers were/are.  Does anyone know if this exists and how it can be accessed?

Hello all, Currently, sales orders for on hold/credit hold customers can not be entered. Is there way we can push orders through for customers with on hold status.Often times we would still like to send these orders through to production, as their hold status can usually be resolved by the end of the month. As it stands now, we’re often scrambling at the end of the month to get these orders produced and out the door in the remaining days to hit our end of month numbers.We will still have a hold on these orders and they would not ship until the hold is lifted; but if we could get them into production, the orders could ship as soon as the customer’s hold status was removed.I’m sure I can (not easily) develop a customization to handle this, but was wondering if there’s an easier way of accomplishing this. Thanks!

We have backflush on some material in the prod detail, but when we do the Move transaction on that operation, a material transaction does not get created - and the material does not get issued. Anyone have this issue?

I was giving a demo of manufacturing for a potential customer and they asked a great question.Their business is growing plants to sell and they use manufacturing orders to track the plant from germination, through it’s growing stages.The first work center would be “Germination” and it doesn’t matter how many seeds they plant, the germination rate is 3 days for a particular seed.How would that be represented on the BOM under the Run Units and Run Time, if quantity isn’t a factor?Thanks!

Our business creates seed mixes via the manufacturing process.The ingredients for the mixes have base units of “EA” or “each” because we purchase and sell the bags by the bag (not by weight). Each ingredient comes in bags that weigh 50 pounds.I have the following BoM to create 1# of the seeds mix:Ingredient 1 - 0.4# (0.008 of a 50 pound bag)Ingredient 2 - 0.4# (0.008 of a 50 pound bag)Ingredient 3 - 0.2# (0.004 of a 50 pound bag)Inventory wise this math works perfectly and I’m able to do a production order flawlessly in the system.BUTOn the production order ticket it displays/tells workers to use 0.008 of a 50# bag and ideally I would want it to tell the worker how many POUNDS to use. I can’t change UoMs of the ingredient stock items.Originally I was going to create a second stock item for each ingredient and call them “Ingredient # BULK” with UoMs as pounds and create BoMs to convert 50# bags (EACH) into Bulk pounds and THEN create a BoM for the mix using the BULK stock items... but t

Hello, Date range runs out to 8-2-24.In the production order pane, I can scroll to the right, but no all the way to 8-2-24. 

Hi All,I am new to manufacturing. What is the process of disassembling of a closed production order with serialized items? thxDries

Trying to build a GI or maybe a report, that can quickly show me items and when they were produced.  Is there a table somewhere that captures when a order changes status?  I’d like to see the date that certain Work Orders were completed.

Hello Experts, how to resolve this error. 

I am testing automatic forecast generation for a client that has been live for a year. I am testing in 2022 R1.We previously uploaded manual forecasts since the client did not have any actual sales data to generate forecasts automatically. The forecast calculation is simple...10% growth per month. I am able to calculate the forecast however when I process the data, the forecast listing shows the items with an interval of One Time and they appear to be in addition to the old forecasts. The previous forecasts were entered with the interval Monthly. My questions are as follows:Is it possible to process the generated forecast with the interval of monthly and automatically update previously entered forecasts?What is the implication of one time vs monthly?There does not seem to be a way to easily mass delete old forecasts. I have thousands of lines as there are different forecasts by item by month and deleting one by one is not realistic.

In inventory planning display, we can only select multiple items for purchase if they are for the same vendor.  We would like to select all lines, click “PURCHASE”, and have multiple POs created.  1 for each primary vendor with the relevant items on the PO lines.It is too cumbersome to select items for one vendor, hit purchase, then repeat for each vendor in the list.Is there anything that helps with this process or is this an enhancement request?

I am wondering if there is any way to do a BOM cost roll using Average Cost. For example, we need to be able to provide pricing to customers before we publish the new pricing but need a way to find out the new BOM cost with a pending price. Since we have not purchased anything at the “new/pending” cost, it is difficult for us to accurately provide new pricing for finished goods from a BOM.Is there any way that we can do this in Acumatica?Thanks

Client is creating the production order the day before the actual production run estimating how many cases will be produced so they can print off the FG bar codes. They are also setting up the release of materials so the raw pallets and caps can be scanned in real time. The issue is that they cannot change the number of cases produced after the release of materials is made (without deleting the release of materials, which defeats the purpose of scanning real time) they wont know the exact number of cases produced until after the shift is done producing. Any thoughts on how to change the production work order flow that allows one order per shift and the modification of the produced qty in that work order before completing production order in system.

We run 23R2, Build 23.209.0023. When attempting to use the Finish action via the ConfigurationEntry endpoint, the Supplemental Item does not appear on the Sales Order. This is not the same behavior we see when manually creating an SO, where after closing a Finished Configuration, the SO is updated to include the Supplemental Item.Has anyone else had success with the Finish action that’s part of the ConfigurationEntry endpoint? It is properly updating the Configured Item’s Line Description.

I have an odd question. We have part ABC123. This part is sometimes manufactured and has a BOM; sometimes, we purchase it from an outside vendor. Our engineering team wants to be able to use the same part number but two BOMs. I question if this is a good idea. Others might have similar scenarios and would love feedback on how they deal with them. The gist is we save money but have an extended lead time on the purchased item so in some cases, we end up making the item.