Discussion Forums

When raising a change request, My CR is picking the costs correctly from the supplier price worksheet. However when a change request is converted to the Change order, for the items which are  already a part of the Cost budget tab reflect correct costs/Unit rate on the Change orders.For the item which are missing and are newly added from the Change request to change order, are added to the cost budget tab but with a zero costs. I have done some reading here based on the below and it shows it will select an avg cost for this. Currently as it stands it seems for project based inventory enable/disable setting the avg cost doesn't exists as project based inventory is the only way our client deals. The issue with this when they are marked from Purchase order from Cost budget tab lot of the items are zero costs. This is causing a lot of issues. Is there any way or a workaround where the costs doesn't need to be put manually on cost budget and are reflected from the change requests to change o

Hi there,I am currently trying to resolve a API call to enter a activity on a customer. I have tried referring a few articles online. One of them was as below.https://www.postman.com/flight-geoscientist-57391170/celigo-pakcage/request/wgijcfd/create-an-activity-that-is-linked-to-a-customerMy postman call is as below:https://{URL}/entity/Default/24.200.001/Activity/{    "Summary": {"value": "Automated Test 2"},    "Type": {"value": "N"},    "RelatedEntityNoteID": {"value": "a474872e-1378-f011-ac49-0a202afc9b19"},    "RelatedEntityType": {"value": "PX.Objects.AR.Customer"},    "ActivityDetails":{"value": "Automated Test 2"},    "RefNoteID":{"value": "CUST000001, BA Industries"}}My error is: 406 not acceptable. My I please get some tips in this regards.

HI there all,We use project tasks for our design team to log into - giving us time activities in the Billable time field - however, we dont bill out their labour - but we would like to capture in a GI or on our dashboard, how each project task is tracking by employee.Anyone done this already?Cheers

I’m trying to create a GI that brings in the Labor, Material, Move, ect. Transactions into line with their respective Production Orders. However, When I link AMMTRan to the sheet, it results in a cross join for every entry. All of the Material transactions are repeated under material, material under labor, ect. I can’t figure out what’s causing this bad join? Any idea where this issue may be originating?

Can someone know how to update acumatica order's delivery status, timestamp, signature image (URL or attachment) and optional delivery notes/photos using restapi?Thanks in Advance 

Does anyone know how we prevent the Company Entity from syncing in our Shopify B2B Connector?For some orders, we need Companies to exist in Shopify because Tax Exemption and Pricing Catalogs are assigned at the Company level in Shopify. But we don’t want Companies to sync in the connector.I have it turned off. But the Order sync is failing because the Company entity is inactive. If I activate the Company I’m getting a “CountryID cannot be empty” address error on the Company Entity — which doesn’t make much sense because the Company Location in Shopify has a complete address. Really confused on how to be successful here. It seems like Acumatica rolled out the Company entity without equipping customers or VARs on how to strategize for success. Thanks for any help. 

Hello community,I’m working on enhancing our use of Rough Cut Planning in Acumatica Manufacturing and wanted to share my setup, the process I’m following, and a key question about how scheduling handles material availability.🔧 Setup We are using Rough Cut Planning to schedule and manage production orders. Items in our BOM are flagged with Check Material Availability. Components can be a mix of: Purchased materials (with confirmed promise dates on POs). Manufactured materials (supplied from other production orders). ▶ Process From Rough Cut Planning, we run the Schedule action on a group of production orders. The system assigns start and finish dates based on constraint dates, resource availability, and current setup. For items with Check Material Availability, I expect scheduling to respect: Promise dates from purchase orders for purchased components. Finish dates of sub-production orders for manufactured components. ❓ My QuestionWhen the product is set up to

We are up to date and using 2025 R1. We were told originally that Multi Clock would be coming to the mobile workspace in 2025 R1. Is there a way to get Mobile workspace to have Multi Clock or is this not functioning yet?

I am processing a Capable to Promise order and it is creating a unique production order for each line item on the sales order. Is there a way to get the system to create one production order for the entire sales order? 

I’m trying to add a field to the ARTran DAC that isn’t stored in the database, and instead calculates a value based on another field in the ARTran DAC.  I’ve found lots of examples online, but they all reference returning True or False, and I think they also are leaving stuff out.  Google AI and ChatGPT are leaving stuff out too, probably because they’re only as smart as their source.What I want to do is add a “Transaction Multiplier” field like what exists in various OE and IN DACs--a value of 1 means that the transaction has a positive effect (like an invoice) and a value of -1 has a negative effect (a credit memo).  In human readable terms, I think my tasks are:Add a non database field to the DAC Add code to tell the system that if ARTran.Trantype = “CRM”, return -1.  Otherwise return 1.  Ideally I’d do this as a Switch in case I have other Trantypes that I need to account for.Focusing on what I know, I added the field to the DAC (using the Data Access section in the customization)

We are setting up our locations in Acumatica, and are using the Avalara address validation tool. When we set up a location, the address and LocationID is the same as we are using in Avalara, yet the “Validated” button within Acumatica is framed in red and unable to be chosen. Has anyone experienced this? If so, and if you know how to repair, I would be grateful.  

I’ve got a Dashboard which contains the result of Generic Inquiries filtered by Customer, but I want to be able to select the customer by searching by postcode. So I need the Address.PostalCode column to be available on the Customer Selector that is displayed on my dashboard form.My Customer Parameter is defined from Customer.AcctCD. I’ve tried defining a CacheExtension with a (non-persisted) custom field, but that wasn’t recognised. And I can’t work out what Graph is being used by the Dashboard. Was going to post this as a question, but can answer it myself as I’ve found a solution:Create a database table with a column of the desired data type (AcctCD nvarchar(30)) Create a DAC for that table (it’s a real table, so decorate with PXCacheName) Define the selector on the AcctCD field Amend the Dashboard parameter to use that table/field as the Schema Object / Field.(This also works for Generic Inquiries, the table needs to be included as a Data Source but doesn’t need a join. The paramet

I have created a Sales Order and linked all the items in the Sales Order to Create a Purchase Order.Now I have modified the Sales order to add in an additional line. I cannot seem to link it to the existing Purchase Order. Mark for PO is ticked on the SO line. If I use Create Purchase Order it will create an entirely new Purchase Order If I go to the existing Purchase Order, the line type will change to Goods for Inventory instead of Goods for SO which enables me to link back from PO to SO.How do you link the items from the SO to an existing PO? Surely this is a common issue. 

The title of this topic should be Printing an invoice on the Mobile App is not doing anything.I wish I could change the title!When I try to print an invoice on the Mobile App, nothing happens.I read this previous topic and I think I am doing everything correctly.I added AR301000 Invoices and Memos to the Mobile App.I updated AR301000 to expose the printInvoice command on the mobile appupdate screen AR301000 {  update container "InvoiceSummary"  {    add recordAction "PrintInvoice" {          redirect = True    }  }}This is the command from WSDLI exposed the action to the mobile app in the project editor.In the Mobile App, the Print option appears in the ellipse menu.When I select Print, no report is shown.  Nothing seems to happen.I verified that the invoice I am working with is available to be printed as I can print it from the UI.Does it look like I’ve missed something? 

How do we send an automated email to a workgroup? We want to notfy the workgroup members via email whenever a Task is created and assigned to the workgroup. 

Is Acumatica planning to upgrade the Report Designer? I am not a professional, but sometimes the report designer feels worse than Excel, which has more features.In one window, it shows that the expressions you created are valid, but in another window, it shows an error.When you preview, it shows "XML not well-formed," but if you save it to the server and run it from the system, there are no issues.There is no option to preview based on a reference document. It shows some documents randomly, which does not help to find the changes/results. To check, the only option is to save back to the server and test.The formatting features are very limited. Viewing in grid format is possible, but there is no option to zoom in or out.These are just a couple of issues from many.Acumatica overall has many options and features. However, to be honest, when doing quality testing, there are many options whose workflows and explanations are not clear. Even when we try to research it, it is hard to get clear

hello all,Can anyone guide me on how can I make the header level description field on AP301000 screen to remain as editable for all the statuses? Thanks.

SummaryWe recently updated to 2023 R2.After the update I am getting an access rights error whenever I attempt to use the Customers table/object in a Generic Inquiry.I have admin access rights and there was no issue before the update. DetailsThe exact text of the error is: 'This field will not be displayed for the current user because the user has insufficient access rights or the required feature is disabled'   If I do use the fields they will end up blank when I view the GI. This warning does show up in GIs that were made before the update, but the data is not missing when viewing those GIs.​Self-Service ResourcesKnown Issues - Cannot find related issue Knowledgebase - Cannot find any related entries/articles Release Notes - Don't see anything related Forums - The following is the only similar issue that I can find and it does not have a solution: https://community.acumatica.com/reports-and-generic-inquires-115/backorder-inquiry-in-2023r2-20699  Troubleshooting Access Rights by Roles

 we just upgraded to 24R1 and we are seeing an issue with push notifications as shown on the system queue monitor page“The queue cannot be processed. Check the access rights to the queue and restart dispatcher.”here is a screenshot: https://capture.dropbox.com/Fsyi91vzrIxyLt8Zany idea where we set the access rights for this or how to resolve this issue? 

I have attempted several times to follow this article, but I find it very difficult, and I always get hung up and end up ditching it. Has anyone successfully done this that would be willing to provide some helpful tips, and/or allow me to pay for samples?

Hi allWe have a staff member heading off on ML in October.  We will be receiving her Centrelink payments and then forwarding on to her.Is there a guide for Acumatica to set up all the required accounts etc.ThanksE 

I need to invoice from a project in EUR and have the project revenue and cost budget in USD. I set the billing currency in the summary tab to EUR. When I run billing, it correctly invoices in EUR. However, my invoice also shows the total revised amount column in USD. I do not want this b/c it makes it look like I’m only invoicing for less than 100%.  I cannot use foreign currency in the revenue budget, so how do I get this to show the total revised amount in EUR? I’m assuming this is a report designer fix, but thought I would ask before going that route. 

Hi - My name is Jean McClelland and I’ve been implementing Acumatica for 10 years - after a long career with other ERPs (JDE, PeopleSoft, Epicor, Yardi). Acumatica is definitely my favorite! The VAR I work with, Clients First Business Solutions, serves Manufacturing, MRO, Construction, Distribution, etc. We recently finished a small customization to track tariffs and their effects cleverly called Tariff Tracker. We are all about helping our clients keep up with the times and have the data they need to make effective and wise business decisions.On a personal level, I enjoy watching funny movies, walking/hiking, and being in the mountains. There aren’t many mountains in Texas so I drive up to New Mexico and Colorado fairly often! Road trip! I love the ease and convenience of road trips.

What Sales reporting tool integrates with Acumatica? We are unable to extract effective Sales data for our owner. We need a robust tool to capture the following and more: Sales By: Customer, Customer and $$$, Customer and Product, ytd, ytd vs. last year ptdProduct - units sold, $$$ sold, ytd, ytd vs. last year ptdThank you. 

I am creating a copy of a Contact record in a processing screen.  I instantiate a ContactMaint graph to do this.After I create the graph             var contactGraph = PXGraph.CreateInstance<ContactMaint>(); contactGraph.Contact.Current = new Contact(); Set the values in the fields. For example, contactGraph.Contact.Current.BAccountID = bAccountTo.BAccountID; If I put in an email address that is already in a contact for the respective BAccountID and contactGraph.Actions.PressSave();, an error with this value "At least one duplicate has been found. Do you want to save the record?";If the email address in my new contact is not already in the DB for the current BAccountID, it saves just fine.  But if it is a duplicate (which I want to be able to do), there is an exception thrown that would ordinarily be easy to say yes to if you were doing this in the UI.However, since this graph is created in the Processing screen, I cannot programmatically say “yes” to create a duplicate.  Once th