Manufacturing

I have a GI that shows the Qty On Hand for each item by Warehouse. I want to get the total quantity on open Production orders at that warehouse for that item.  What tables/DACs do I need to join to my GI to pull in those numbers? 

Hello experts, I was looking to create a Generic Inquiry for Aging category of production order , I found this Generic inquiry for reference can anyone suggest me is it fine for the reference but still i am confused is it possible can we  show the aging category in this GI Report ? 

Looking for some clarification & guidance. We are testing the Inventory Planning in Acumatica and one of the things I have noticed is the Min Order Qty on the Inventory Planning Tab of a Stock Item does not seem to utilized during the Planning Regeneration.In the example below, Stock Item 68000 has Safety Stock = 5, Min Order Qty = 10. I currently have Qty On Hand = 0.I would think that when Regeneration occurs, it would look at demand (currently 0), then check Safety Stock, determine in this case we need to place an order to fulfill the safety stock demand, and then use Min Order Qty if value exists. However, it doesn’t seem to use it at all. Only workaround I have found, is to set Min Order Qty on the Vendor Tab for the default Vendor and that does seem to work. If it is intended to be Vendor Dependent, then it seems odd this setting is there.Reading the Form Reference, I can see it get’s populated from the Item Class, but still not sure why the Inventory Planning doesn’t use it.

Hi Everyone, I’d like to pass a list of values instead of calling out the items 1 by 1. There are many options in the conditions drop down. But the documentation does not specify how they should be used, or provide limitations.  

In Acumatica Manufacturing, is it possible to configure variable overhead GL postings to use the same WIP subaccount as the related Production Order, instead of the subaccount defined on the Overhead Code?

We are working through some orphaned data in our system from our conversion. This data is all from 2022. I hoped there was a way to use buckets or something else to exclude this data from everything else ( or ignore it altogether). This is throwing our MRP numbers off and reconciling these orders is happening, but is time consuming, 

Hello Manufacturing and Distribution Experts,I am currently working with a customer who is transitioning from SAP to Acumatica. We've encountered a significant difference in how the two systems handle MRP planning suggestions when the required action date (start date) is in the past due to lead times. In SAP's MRP logic, the system typically performs automatic "forward scheduling" when a backward-scheduled start date falls in the past. It automatically moves the suggested order date to the earliest possible current date and issues an exception message. Acumatica, as we understand it, requires a more manual process using exceptions and date updates.I am thinking about  proposing the following workflow to our client, and I'd like the team's validation:Our Proposed Workflow for Past-Due Demands:MRP runs and generates planned order suggestions with dates in the past. The planner uses the Inventory Planning Display screen (AM402000) or Exceptions screen (AM403000) to identify these items. T

I created a Bill of Material with operation IDs 10, 15, 20, and 30. When I create a production order using this Bill of Material, the operation IDs in the production order appear as 10, 20, 30, 40, and 50.The custom columns maintained in operation ID 15 of the Bill of Material are shown under operation ID 20 in the production order. Additionally, an extra operation ID 50 is created in the production order, even though it does not exist in the Bill of Material, and operation ID 15 is missing from the production order.Similarly, the custom columns maintained in operation ID 30 of the Bill of Material are shown under operation ID 40 in the production order. 

We manufacture items using a Lot/Serial Class configured as follows:We want the system to auto-generate serial numbers by default when these items are finished in a Production Order. However, we want to manually override the auto-generated serial number occasionally, as when we are making R&D items.My Question: If I keep “Auto-Generate Next Number” enabled to handle the majority of our volume, does the system prevent manual editing of the serial number field during the Production receipt/move process? I am looking for a workflow that defaults to the auto-generated sequence but still allows a user to manually override the serial number on specific units before the transaction is released.

I’m trying to use a third-party service (Skyvia) to sync records from Acumatica to our local SQL server.  When I pull data from the Manufacturing endpoint, it cannot do incremental updates because the data does not have either a 'CreatedDateTime' or 'LastModifiedDateTime' column.  Is there a way that I can get this information in the endpoint?

We have a stock item that is primarily manufactured, but can also be purchased / outsourced when required.Since the Item Master allows only one Replenishment Source, we would like to understand how MRP handles order quantities: If MRP generates a Manufacturing Order, does it use the Inventory Planning tab (min / lot size)? If the same item is planned as a Purchase Order, does it use the Vendor tab minimum order quantity? As per my understanding, MRP behavior is driven by the Replenishment Source, and standard MRP does not support planning the same item as both Make and Buy automatically with different order quantities.Please let me know if this understanding is correct or if there is a supported approach.

We are experiencing a workflow issue related to Production Orders in Acumatica Manufacturing and would like clarification on expected system behavior.In our case: A Production Order was marked as Completed After completion, the system still allowed posting additional transactions, including Move transactions However, when attempting to Close the Production Order, we receive the following error: “Select a production order for which transactions are allowed according to the workflow.”We understand that Acumatica may allow late Labor or Material adjustments after an order is marked Completed, but we have not seen clear documentation confirming whether Move transactions are expected or supported after Completed status.Questions: Is it expected behavior that Acumatica allows Move transactions after a Production Order is marked Completed? If allowed, should this prevent the Production Order from being Closed later due to workflow validation? Is this considered a workflow limitation,

Hello all,We are documenting our business processes (in Visio swimlane flowcharts) prior to implementing Acumatica modules. The manufacturing module looks like it will work well as is. As a time saver: does anyone have flowcharts already developed that document manufacturing workflow (with standard Acumatica configuration)?Thank you in advance,Gerry

I work in a manufacturing environment that requires production work orders to be split for validations, new tooling runs, qualifications that were not originally planned for.  The problem is that I don’t see the functionality that allows me to split a production order.  The worst part is that we have to link our SO’s to the production orders when created for lot tracing. Every time I get a request for splitting, in order to keep the linking correct, I have to go all the way back to the original Sales Order and make changes, and so on... Reduce the original sales order lineCreate new lines for the split qty’sMark those new lines for productionGenerate new production ordersPrint new production ticketsReduce the production order and print a new ticketWhen shipping, this then creates additional work as now they have several lines instead of 1 line int he sales order.  I was wondering if I missed this functionality or maybe someone has a similar problem and came up with a less time-consumin

Our company utilizes our Quality Assurance team for Supplier Management. Does Acumatica have any Supplier Management functionality with regards to monitoring specific stock items that are on back order with vendors? Also, is there a way to restrict items to only being purchased from specific vendors, or vice versa (vendors can only sell a specific category(ies) of items)?

Hello Experts, i was looking to create a GI to show material planned cost and actuaL cost for production order, i was in doubt that the data which i am looking because values may be calculated value, it may not be stored value. can anyone suggest me your opinion for this.

Some context - We are a high volume production transaction location and we scrap/reject off work orders to either scrap or rework locations. We quarantine scrap to be able to rework it if necessary. At end of month we purge our scrap locations (issue out of system) to record the expense on our P&L. However we seem to have ran into an issue since we went live in 2022 when we do a negative move that is scrap (we call these negative scrap transactions). We do this to try and reverse the move transaction when there is an error/mistake when it was created/posted. Acumatica doesn’t seem to like this very much as it doesn’t correctly reverse the posted transactions, reverse the inventory, or update the Work Order Totals. Every time this happens (a lot) we have manually reverse the inventory back into WIP, post an opposite transaction WIP adjustment to correct Work Order Totals, check to see if the Applied Overheard reversed correctly (Cost transaction), and finally many any Adjusting Jour

Hello, I generated a Purchase Order for a Production Order from the Critical Materials screen. I can clearly see the demand with the Production Order # listed on the Purchase Order. I wanted to know if there was a way to receive the Purchase Order and directly issue it to the Production order from the receipt screen. In our legacy ERP, we were able to buy directly to Production Order without having to receive it into inventory and then do a material transaction like in Acumatica. I’m looking for some way to lower the amount of steps that it takes to purchase and issue out items to a production order for our team. If you need more context let me know. 

We are in the middle of implementation and I am writing a workflow for issuing Purchase Orders to Outside Process vendors for metal finishing (Ie: Powdercoating, Plating, etc),  however I am not certain that I am totally clear on the correct process. We have setup non-stock items to represent the outside processes.  These have been defined as a service, They have vendor(s) associated with them on the vendors tab and the default price as been set to $1.00.   On the manufactured (stock) item I have defined a BOM and on the operation step for the outside service I have added the Non-Stock item (Powdercoat) to the BOM as a material.  The qty required has been set to the per-piece cost that I was quoted,  the Unit cost remains at $1.00, The material type has been set to “Sub Contract” and the Subcontract Source has been set to “Purchase”.  On the Outside processes tab I have also checked the “Outside Process” box and have selected the preferred vendor for this operation.  I have then opened

Hello Experts, I am getting stuck in one of the issue how to show all the warehouse qty  for an item in inventory planning display when MRP is run, is there any setup missing i have enabled inventory planning check box for the warehouse location which are there in item, but then after iam unable to get the all warehouse location qty when mrp is run.

Hi Community,Many of our manufacturing clients are ETO shops who are incorporating Project Accounting (or Professional Services) with Manufacturing.  Do to the nature of the ETO manufacturing, the client is often required to recognize revenue using the Percentage of Completion method, per their CPAs.We love that manufacturing and (formally) project accounting are integrated, but from an accounting perspective it feels as though cost accounting for manufacturing and project accounting couldn’t be further apart, and I’m struggling as to the best way to leverage the best of each feature set to achieve the client’s accounting goals.  To illustrate, in manufacturing (and in a full-absorbtion cost accounting paradigm) the costs of each production order are capitalized to WIP Inventory on the balance sheet until the production order is complete.  Upon completion the accumulated manufacturing costs are placed in FG Inventory until the goods are “sold” and “shipped” to the customer.  Therefore

 We have a project with multiple tasks from initiation to signoff. For this project, we’re creating Production Orders for multiple Finished Goods. Labor Transactions: When labor transactions are created for a production order, they generate a GL transaction that posts to the WIP (Work-in-Progress) account. Upon closing the production, the labor costs move to the Finished Goods (FG) inventory. Shipping/Issuing Finished Goods: When the finished goods are shipped or issued, the costs move to COGS (Cost of Goods Sold) and update the Material account group in the project. Is this flow and my understanding correct? The main challenge I’m facing is tracking the production labor costs that have been reported back to the project, particularly when there is a budget allocated for labor costs. Labor Budgeting: How can I ensure that the actual production labor costs are properly tracked against the budget that was allocated for labor within the project? Linking Labor to the Project: How do I m

We have a problem in configuring work center. A work center is configured with ‘basis of capacity’ set to crew size, and three shifts are added, each with a different calendar. The calendars are configured with 8 working hours in a day, but the timings are different. When the MRP runs, the action date calculates based on the crew size and calendar in the first row of shifts but we thought it would consider all the shifts. If all the shifts are considered, the action lead time should be reduced to one-third, as the total working hours of the work center are 24 hours.We are not sure why Acumatica considers only the shift details in the first row

When updating the Safety Stock and other settings on the INVENTORY PLANNING tab of a stock item, the new value carries over to all existing item warehouse details records for the item. Shouldn’t it only carry over to whatever the default warehouse is? It seems undesirable for it to update all warehouse detail records because each warehouse could have its own safety stock. This is on 25R1 25.101.0153.5. I understand that when multiple warehouses are available that the planning settings should be updated on the individual item warehouse details records. However, it becomes confusing for users when there may only be 2 warehouses (one ‘Main’ and a secondary back up warehouse). It’s easier to simply update the safety stock on the stock item and have that setting carry over to the warehouse detail record for the default warehouse, rather than also updating the secondary warehouse. Is this expected behavior?

I need to advise the sales team regarding the availability of materials in the multilevel BOMs (Capable to Promise (CTP) multi-level BoM), which may include both Manufacturing and purchasing items at various levels. Any ideas on how to create a GI or even generate a report showing the INSiteStatus.QtyAvail using AMMultiLevelBomData?