Discussion Forums

Hello Linkies,I have created a new PO report - PC PO (PC651000) in the system that I would like to add in place of the Print Purchase Order report as highlighted below.But I am unable to add the newly created report by modifying the Mailing & Printing tab in the Vendors (AP303000) form & Purchase Orders Preferences (PO101000) form.  Kindly let me know how can I achieve it. I am not looking to modify the already existing report.

I would like to be able to change values in one column at runtime. Is it possible to do that with a prompt or maybe in the Import by Scenario screen to change all the values in one column in the grid?AI suggested that this can be done by: Defining a Parameter on the Import Scenario Referencing that parameter in the Mapping (e.g., using a prompt variable) Having Acumatica prompt the user at runtime and inject that value into the mapped column for all rows It may be hallucinating since I wasn’t able to find any info on that.

We are on 25R2 modern UI and using the New Release Process for Manufacturing.  I have seen two glitches so far, and wondered if anyone else has seen these in their instance:A Move that completes an operation no longer records Actual Start Date and Actual End Date in the AMProdOper (Production Details, routing section) table.  We have critical reports that rely on these dates, and they are broken right now due to this issue. The final Move (production receipt) for a linked Production Order to SO Line no longer allocates the inventory to the SO Line.  You have to delete the SO Line and re-add it to invoice the sales order.  The issue this creates for us is that the production order loses the link to the Sales Order, also breaking critical reports that help us report on stock product versus build-to-order product.I don’t see a way to undo the New Release Process, but I would like to.

I am creating a GI where I want to show GL account wise period wise and branch wise ending balance and turnover amount .Column A     |  Column B  | Column C |   Column D           | Column FGL Account  |  Period       | Branch      | Ending Balance    | Turnover amount   In the above GI (also attached the XML file ) , the ending balance and turnover amount for each GL account is not showing the correct data when compared with the Account Details screen.  

I need to add new field “Line” into Generic Inquiry to display line numbers as 1,2,3,4… Is there anyone who did this kind of customization before?

Hello,I have a couple of questions regarding Purchase Order approvals in Acumatica.1. Approval by amount using Workgroups instead of specific usersFor Purchase Orders approval based on amount, I have configured an Approval Map with conditions.However, instead of assigning a specific user as an approver, I need to assign a workgroup that can approve these documents under the defined conditions.The goal is to avoid constant changes in approval settings and to ensure that if one person is absent, another member of the workgroup can approve the document. Is it possible to configure Purchase Order approvals using workgroups instead of individual users? If yes, what is the correct way to set this up? If not, what alternative configuration options are recommended to achieve this behavior? 2. Approval ba

Hi,i am just wondering how can i set properly the workflow for approving credit memos, so that Sales Manager will always be the first to confirm new credit memo. Right now our AR map for credit notes is the Sales manager on the top and then the local controller, but in reality is other way around. The first the crontorller is getting the memos and then sales manager. Do you know maybe what is causing this flow?Thank you,Andreja Špindler

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. 

Hello, group,Long time listener, first time caller… We’re just getting started using the Rough Cut Planning and Production Schedule Board Modules and we’re wondering if there is a way to easily export the Production Schedule Boards. It’s old-school, but while we’re learning the tool, I would like each plant to print the Production Schedule Boards out for their Production Teams to review until we are fully comfortable with the tool and can display on a large monitor. We’re on release 2025 R1.  Thanks...

Hello,I am working on a customization in Acumatica 2025 R2 and trying to display a Google Map side-by-side with a PXGrid in a custom screen.Scenario-Custom screen: JobMaintTab: "Regions"Left side: PXGrid (JobRegion)Right side: Map (should show selected region address)Goal: When selecting a row in the grid, the map should update and display the address.What I Have Done-Created an unbound DAC field MapHtml in JobRegion.In RowSelected<JobRegion> event, I generate an iframe:protected virtual void _(Events.RowSelected<JobRegion> e){    if (e.Row == null)        return;    string address =        $"{e.Row.AddressLine1}, {e.Row.City}, {e.Row.PostalCode}, {e.Row.CountryID}";    if (string.IsNullOrWhiteSpace(address))        return;    string encoded = Uri.EscapeDataString(address);    string map =        $"<iframe src='https://maps.googl

How can I customize the system to not allow a user to change the Branch if certain conditions are met?

Hi, I saw a post regarding this:But the resolution is not feasible to us. Is there any other way to restrict users to a specific vendor class? Purpose of this is we would like only one user to view an create transactions for a specific vendor class. This user shouldn’t also view, enter or edit bills for any other supplier class.

Hi,We are looking to integrate Acumatica with Monday.com to pull over some key data from a few places. Projects and DB Tasks. We would like to pull data such as:-From ProjectsProject ID Project Description  Cost and Revenue Tasks Hours budgets from each Labor cost task Actuals Completion %-From DB Tasks      -Assignee(s) Has anyone done something similar? How is it working and or what are you using to generate a resource plan for projects and staff? Thanks!   

Hi! The goal of the generic inquiry is to be able to display a list of customers based on the percentage set in the parameter. Right now the generic inquiry is grouped by customer and displays all customers with their Net Sales and last order date. There are two parameters, one is last order date, where it displays a list of customers with last order date less than or equal to what is specified. And the other will be percent. Where users should be able to enter a value as percent, and the GI should display only a list of customers based on that percentage.For example, if there are 100 customers with last order date on or before today, and 25 is specified in the percent parameter. Then the GI should only display 25 percent of the 100 customer records.Is it possible to achieve this with Generic Inquiry? I’m not able to create a parameter where users can enter values that is not tied to a scheme field. I can’t enter a formula in the parameter or advanced filter eit

Hi all!I’m trying to create a report for my company that will show inventory unit sales by INVENTORYID.So far, every combination I’ve tried is “tripling” the units sold in the final query.I have the below Joins:ARTran Full → InventoryItemARTran Left → ARInvoiceInventoryItem Left → POVendorInventoryInventoryItem Left→ InItemCostGrouped by: ARTran.InventoryID.Results Grid:VendorID VendorInventoryID InventoryCD InventoryItem.Descr (Calculated Field) → =sum(iif([ARTran.TranType] = ‘CRM’, -1 * [ARTran.Qty], [ARTran.Qty])All fields are showing correct except for the unit sales which seem to be tripled in quantity. Hoping someone can point out where this may be coming from :) Thank you!

We have a custom UDF called UsrOrderSource that helps us track various origin sources for our orders. Using the Shopify integration, it would be ideal to map a parameterized value (eg Connector name - Store name, or in this case, ‘Shopify-Store443Austin’ ) to that UDF.On the Shopify Import Mapping screen, I can select various order header level fields; but I cannot select my custom UDF. Why is this, since the UDF is part of the SOOrder DAC?Ideally, map to a SOOrder UDFThis is one of those things where I am hoping I just haven’t gotten the mapping right- it seems to me like it would be SUCH a useful way to allow the low-code/no-code style to apply here.I do see elsewhere that a

Hello,I’m looking to link SOLine Files to the AMProdItem files via import scenario through the add link action or ideally directly through the file maintenance screen.Has anybody successfully done this? I’m not sure this is possible because the add link button opens up a new window to the search in files screen and the file maintenance screen apparently does not currently allow you do add an entity.  

Has anyone successfully implemented an email notification when a Sales Quote (Order Type = QT) is fully approved? We’ve been trying for ~4 months and it never fires.GoalSend an email to the appropriate recipient as soon as a Quote becomes Approved.EnvironmentModule: Sales Orders Document: Sales Quote (SOOrder, Order Type = QT) Workflow: Using Approval Maps; quotes do get approved in the UI.What we built1) Business EventType: Trigger by Record Change, For Each Record Screen Name / GI: Sales Quote Approved - BE (GI21001) Trigger Conditions (current): Record Inserted (screenshot attached) 2) Email TemplateScreen: Linked to GI21001 – Sales Q

Is there a way to get the Acumatica credit terms to the Shopify locations? This seems to be missing from the entities screen. It looks like there is a substitution list slot for Credit Terms, but that seems to be specific for import.

Hey Community,  Does anyone have a generic inquiry that is triggered off of import errors? Looking for a GI to display the import scenario that has the error and a translation of the error message.  I have something like this below but struggling to get the actual error message and the import scenario on the GI.   

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.

Has anybody come up with an elegant solution for this? Client wants to add inventory items to service orders to communicate to the warehouse that it needs to be shipped from the warehouse to client site (drop-ship to client)  Client is currently shipping parts from the warehouse via sales orders in a normal distribution workflow for sales activity But what about service orders?  The client wants inventory to be decreased when the parts are shipped from the warehouse  There is no way to track parts that are shipped from the warehouse natively like with sales orders  Inventory items will not be decreased until the service order is billed I’ve seen and experimented with a few solutions: Use Workflow Stages or UDFs and monitor inventory shipping statuses via dashboard widgets  Additionally, transfer inventory from MAIN warehouse to “service” warehouse  Effectively decreasing on

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 are currently doing stocktakes in this system for the first time.  We have had a couple of counts error in the Physical Inventory Review screen when trying to Complete PI.  The error we get is ‘Updating Item ##Inventory ID## in warehouse ##warehouse## quantity available will go negative.’ As an example the book quantity is 3 and we are trying to post a physical quantity of 0.  We don’t allow items to go into negative however that is across the whole system.  This has happened on about four of five items out of thousands.  Any ideas on why?  We have checked Inventory summary/allocations etc and nothing has been allocated. It is a rarely used part and has had the initial adjustment in, then a transfer that is pretty much it.

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.