Solved

The mobile App updated on May 14th. Ever since the update was pushed, we have been getting error uploading file. We have had the error in three different parts of the app: 1. capturing the appointment signature, 2: uploading appointment photos, 3: capturing expense receipts. We are using Samsung XCover Pro 7’s with latest Android version. Verizon is our cell carrier. Saw there was a similar bug 2 years ago after update. Any ideas how to fix this issue?

Hi All, I am struggling with an import for the configurator maintenance screen. The last topics were years ago and those xml files error when i try them.  Am I right in my understanding that you need to have an import per feature for the options. So for each feature and that features options you would need to have a separate import or is this possible on one import. Any help or examples would be appreciated

=IIf([Customer.AcctCD] = 'A123', 'John Smith', [ShippingContact.Salutation])All, we’ve had an issue bugging us for over a year. Long story short -- for customer ‘A123’, we have contact ‘Jane Doe’ appearing as the shipping contact on the invoices. Jane Doe left A123 years ago but still appears on the invoices. I’ve hunted her down in contacts, leads, business/customer accounts, shipping tabs etc and can not find a trace of her.So I’m trying to “hard code” our invoice -- if Customer = A123, then display value is John Smith (the correct contact); otherwise, just use the usual [ShippingContact.Salutation].This works for A123 invoices… John Smith now appears! Great!Now the issue is all non-A123 invoices leaves a <blank> Shipping Contact. :/Do I need to use a visible expression instead? 

Is there an existing report in Acumatica that calculates the Average Days to Pay for Customers?   Needing a report that shows the metrics of payments for our Net 30 accounts.    

Hi everyone,I'm currently working with Acumatica Cloud ERP 2024 R1 and using the REST API to manage file attachments on various documents (e.g., Sales Orders, Invoices, etc.).What I can already do:I’m successfully attaching files to entities using the files endpoint like this:PUT /entity/Default/24.200.001/files/PX.Objects.AR.CustomerMaint/BAccount/{entityID}/{filename}This works well — the file is successfully attached and visible under the Files tab on the customer screen.What I want to do next:I would like to add a comment to this file — just like you can do manually in the UI by entering a comment when attaching a file.My assumption so far:From what I understand, this may require two separate REST calls: PUT — attach the file (already working ✅) Some second request to update the file record and add a comment (❓) But I haven't found a working REST example for that.My Questions: Is it possible to attach a comment to a file via REST API in Acumatica 2024 R1? If yes — what is the r

trying to use a contact for invoices and a different contact for statements. I thought that using the mailing & printing feature within the customer profile would solve this. However, after updating and saving, it does not seem to work. I did generate the statement on demand to test out; not sure if this is the issue. It is the same screen ID of AR641500 that the generated statement is on. It still uses the account email in the general tab, however. That is the one I want for invoices only.   

Hey, Gang - recently noticed for a customer that when the invoice report AR641000 goes out for Credit and Debit Memos, the report doesn’t display any values.  It displays just fine when I attempt to print it from the Invoices and Memos screen.  Issue is at the email.  Not sure what’s going on here.  I’ve attached the report and Email Template.  Any thoughts would be greatly appreciated.  

We have built a dashboard whose data source is the InitemsalesHist table. It queries the sales data of the latest 24 periods and presents it with a line chart.I know we can manually adjust the start period every month. But is it possible to realize automatic monthly adjustment without any manual intervention? For instance, even half a year later, it can still show the data of the latest 24 periods at that time.

"In Acumatica 25R1 Generic Inquiry, what are the correct join fields between ARAdjust and ARPayment tables? Trying to link payments to invoices by project. AdjgRefNbr is not binding."

I am working on extending the Customer Location screen (AR.30.30.20) and need to add an Attributes tab similar to the one available on the Customers screen.Attributes derived from the customer class by customer. But value set in Customer Location screen

I have a custom field called UsrAlternateIDs which is added to the InventoryItem DAC. It is used as a separate way to search for IDs while using a selector on certain screens. This is how it is added to a screen as an example: This is done because I would like when the user types in in the selector it will also filter on this custom field. It’s already added to the selector grid and if you click on the selector’s magnifying glass it filters as I would like (this works both in the Classic and Modern UI): I would like to do the same filter without the user having to click on the magnifying glass to filter the item like it does on the Classic UI: In the Modern UI I can get the selector to work if you click on the magnifying glass: But it doesn’t if you just search without opening the selector’s grid: This is what I’ve tried to do which doesn’t seem to do much. Does anyone have any thoughts on how to best update this Classic UI functionality to Modern UI? Or should I do this a different wa

"In 25R1 how do I get Cash Received by Project in a GI? AR Payments have no Project ID field. Do I join through ARInvoice?"

Our customer has segmented subaccount numbers. They wish to do a search on the account details screen with a partial segment that will pull all subaccounts with that partial. Is it possible to use a lookup field for segmented numbers?  See screenshot below. 

Wonder if anyone has started looking into the new Materials Management feature in the Construction edition and if so, any thoughts/feedback on it?It looks like it shows promise but we aren’t going to be using this in a typical construction scenario since we are focused on Custom Engineering projects and simpler/smaller types of transactions where we aren’t using hundreds of materials. Thank you.NOTE for Acumatica, please add a Tag for “Material Management” for posts.

Is there a way to map a value to the Location Billing address in Shopify? I noticed Acumatica Locations don’t have billing info.Alternatively, if I use a Parent/Child customer model in Acumatica (instead of multiple locations) is it possible to map the child customer to a Location in Shopify? 

"In Acumatica 25R1 Generic Inquiry, where do I set SUM aggregate for dollar fields? My Grouping tab only shows Active and Data Field columns."

I have a customer that would like to automate the creation of service orders from orders with a ‘Quote’ behavior using a Business Event with an import.For example, the RJ type order below is set up with the ‘Quote’ behavior. We need to copy this quote to a SV type order with an import. The import scenario is shown below as well. The import runs, but the new service order is not created.What are we missing? Is this possible?  

We have an scenario, where a customer they want to consider Project related Stock on MRP demand planning.For example, consider an item with a demand of 100 units and an available stock of 50 units, but this stock is tied to a project layer. The customer expects that any stock on a project layer should be excluded from standard MRP calculations.Additionally, there is another project-specific demand of 70 units for the same item. Since there are already 50 units available on the project layer, the system should only suggest purchasing the remaining 20 units.We understand that this functionality is currently not supported, but is there any plan to incorporate such logic in a future release?

Hi  I am looking for a suggestion to include backorder items in the shipment confirmation report, Any suggestions?

I am currently working on an integration where I need to extract data from various tables in Acumatica. Right now, my process heavily relies on using OData via Generic Inquiries (GIs) or configuring Contract-Based REST API Endpoints.While this works, it is becoming very inconvenient and hard to maintain. Every time there is a new requirement to get data from a new table, I have to go back into Acumatica, create a new GI (or add the table to an existing one), expose it, and publish the project.I am looking for a much more dynamic approach.My ideal scenario is to have a single API setup where I can just pass the target Table Name (e.g., SOOrder or InventoryItem) and the Fields I want to retrieve as parameters in the request, and have Acumatica return the data. I want to build/configure it just once and use it universally for any table in the future.Has anyone encountered this requirement before? Is there any alternative approach, hidden feature, or a more dynamic solution to achieve this

Hi everyone!I’m trying to apply this patch 26.100.0175-2 but after begining the Starting UI compilation, this error comes up: [16:55:41 INF] Starting UI compilation[16:58:04 ERR] build failed with exit code 2 in C:\Program Files\Acumatica ERP\Demo26R1\FrontendSources\screen[16:58:04 ERR] build stderr:[webpack-cli] Failed to load 'C:\Program Files\Acumatica ERP\Demo26R1\FrontendSources\screen\webpack.config.ts' config[webpack-cli] webpack.config.ts(24,8): error TS2307: Cannot find module 'build-tools' or its corresponding type declarations.webpack.config.ts(28,8): error TS2307: Cannot find module 'build-tools/logger' or its corresponding type declarations.webpack.config.ts(31,8): error TS2307: Cannot find module 'transformers/logger' or its corresponding type declarations.webpack.config.ts(34,31): error TS2307: Cannot find module 'transformers/constants' or its corresponding type declarations.I ran the get npm run getmodules and it created the build-tools folder inside the FrontendSourc

Hi, please help me fix my import scenario in AR Import Invoice, I need it to work to be able to upload with multiple lines or inventory id.Here is my import scenarios XML.

I’m looking for cause or explanation on why DeviceHub would duplicated a print job The system is set to poll every 30 seconds and yet it finds the same document at 8:20:38 and 8:20:45 and processes both   

Which web service end point should I access in order to do a Move transaction?Move Entry seems to be incorrect? 

We recently purchased DRP (not MRP). We buy items in nested sets from our vendors. We need the individual items out of the nested set (disassembly), not the other way around. For example, if Item A is out of stock, we need to buy a nested set that contains Items A, B, and C. When we receive the nested set, we do a disassembly to break it into the individual items. We've already explored setting Source = Kit Assembly on the individual items, but that plans an assembly — consuming components to build the kit — which is the opposite of what we need. We need DRP to recognize that our individual items come FROM disassembling a purchased kit, not the other way around. Is there a way to handle this in DRP? How are others managing nested sets or bundled imports that get broken down for individual sale?