Unanswered questions

Hello,We are looking into using USPS First Class Large Envelopes “Flats” (not a flat rate shipping method, but literally a flat envelope) to ship a majority of our products. We sell small, thin envelopes of seeds. We will save about $100k a year in shipping costs by switching from Ground Advantage to USPS First Class Large Envelopes.Is anyone using this service method in Acumatica?I do not see this as an option when setting up a Ship Via. We have an integration with stamps.com and it does exist as a service method on our account:I wonder if we have to do something similar to when we set up Med/Large Flat Rate ship vias? We had to do some heavy lifting to get those working:First by creating new Carrier IDs for each of those:→ then putting those new Carrier IDs in the Ship Via as the “Carrier”→ Then adding specific BOX IDs to the packages tab of the Ship Via I wonder if we have to do the same for First Class Large Envelopes? The only wrinkle is that these are NOT flat rates. Depending on

I created a mass email and used the HTML and previewed the message. The email message display shows what I need. When I send the emails, the information is correct, but when I open the email, the embedded page does not show. What am I doing wrong? 

Good day. I’m having an issue with my subreport. When I use the reference number range (from and to), it only retrieves the first reference number, and all the results end up being the same.  and this is what i put on my SubReport  

We have a customization that displays a warning popup with Yes/No buttons when an item is added to a Sales Order with a unit price of 0 or 999.99.If the user selects Yes, they can proceed with the line item at 0 or 999.99 and save it. If the user selects No, the system cancels the added line.This functionality works correctly when users manually add or update items.However, when we copy and paste a Sales Order that includes items with a 0 or 999.99 unit price, the system displays a browser-level alert (with only an “OK” button) instead of the expected Yes/No confirmation popup.Could you please help us achieve the same Yes/No confirmation behavior when an order is copied or pasted?

Hi everyone.I need your help regarding the error I encountered when I try to open a record in Checks and Payments screen. Attached is the error message.I tried unpublishing all customizations then try to open the record but I still got the error.  Thanks in advance.

When change date on datetime picker in report back to 2025 but calendar still display in 2026. In Acumatica 2025R2

Hi,due to the changes in the US regarding duties (800$ de-minimis), we have to collect duties from our customers in Shopify. This works very well, but if i’m correct, there is no solution/field in Accumatica to collect duties in sales orders.So now i’m struggeling how to import those values which i do have in my sales order in shopify to my sales orders in accumatica. Does anybody else have the same issue and already a solution for it?

Hi Community, Is there a way to have an API Role for a designated API User that is basically an API Admin and not a UI Admin? -RJ

Hi Team,Using PXDatabase Select query, trying to fetch recordsList<Table> imgAllprocessed = PXDatabase.Select<Table>().RowCast<Table>().ToList();Could you please help to add Where condition to filter records 

Hello Has anyone seen this error? I added Mass Actions to a GI for Production Order Ticket, but when I try to mass edit them or even one, I get this error. I was looking to complete or cancel multiples at once.  

Customer have Company wise Financial Calendar . I am running my 12 months BS based on Master Calendar”  What variable I can use to display the Respective company wise Periods (Eg :11-2025 ,12-2025) .   

We’re experiencing some odd behavior with the main search field. No results are returned when using a combination of three or more numerals and “AS”.Specifically, we have a stock items called “MAS513” with different suffixes, like AO, A12, and AS. Using the search bar at the top gives results for searches of “MAS513”, “MAS513-AO”, and “MAS513-A12”, but not for “MAS513-AS”. “MAS AS” and “13-AS” give results and can find the item, but “513-AS” does not. It works without issue in grids’ quick search field. It seems like ‘as’ is a keyword but only in certain circumstances? Does anyone know why this would be happening?Thank you for any insight you can provide,

Hello! I am reviewing the Import Scenario “ACU Import AP Bills”. When we manually print a check in Acumatica, it automatically finds the next “payment ref.” # in the sequence for the cash account/payment type and adds that into the  Payment Ref. cell. I was wondering if (for our AP Bill Import Scenario), instead of manually inputting the “Payment Ref.”, is there a way to have Acumatica autogenerate it based on the existing sequence? 

Good afternoon,Is there a way to set up a line item (i.e. - our company catalog) to go in at $0 value and bypass CREDIT HOLD so it doesn't get tied up?We want it to count against inventory for the product, but just no monetary value.Thank you!

I’m seeing the error message: [2025-11-19 12:17:33.647] Cannot delete C:\[tenant]\App_Data\TSScreenInfo\Company folder, lock.json is present, pid=21156, ppid=17096 I presume this relates to a fatal build error in the previous publish attempt, which aborted with an HTML Merge error. It seems like the lock.json is not deleted when the publish exits abnormally.I have to manually delete that file before I can Publish.The issue might go away if the HTML Merge error gets fixed in a new version, but it strikes me that the Publish ought to remove the lock file.This is with 25.200.0248.

As shown in the screenshot below, we understand that when a Move transaction is performed, the system should create both: The Move Transaction, and The corresponding Cost Transaction. This is not the actual screenshot; it was taken from the local system. In our case, we can only see the yellow-highlighted Move transaction line. The Cost Transaction shown above does not appear in the Production Order. We have identified an issue where, after completing a Move transaction, the Cost Transaction is not being created for that specific Move.As a result, the system generates a WIP Adjustment Transaction when closing the Production Order instead.We reviewed two Production Orders for the same Item Code, and confirmed that both orders have the same Event History and appear to be configured identically.In one Production Order, the Move did generate a Cost Transaction, while in the other, it did not.There are also no Parent Production Orders associated with these cases, and the No project Associ

Hi all,Someone asked me an excellent question, and I’m asking here because it feels like something there probably is an existing tutorial for, but I'm failing to find it in my searches.Assuming a customer has Azure Entra ID configured for logins, and native users are all forbidden (So OData via basic Passwords isn’t available)Has anyone got complete instructions/a complete tutorial for configuring a PowerBI connection to Acumatica as a Connected Application (To retrieve data)?I’m slightly afraid I’m going to have to teach myself how to write a Power Query connector from scratchhttps://learn.microsoft.com/en-us/power-bi/connect-data/desktop-connector-extensibility#certified-connectors(I have looked into installing the Acumatica content pack for Power BI, but I’m under the impression that pack isn’t maintained fully, and I’m having problems installing it which I’ve reached out to Microsoft support to help me diagnose.)

In Acumatica, on screen AR302000, I have a Closed payment that I want to change to Voided Payment using the APIs. In the UI, the process is simple: we click VOID, then REMOVE HOLD, and the document becomes voided.The VOID button triggers the action /24.200.001/Payment/VoidCheck, and the REMOVE HOLD button triggers /24.200.001/Payment/ReleaseFromHold.I called these two APIs sequentially. The first one returned 204, but the second one failed because the payment is not placed on hold after running VoidCheck, meaning Acumatica does not allow ReleaseFromHold.Here is the payload I’m sending for the first API call:json{ "entity": { "ReferenceNbr": { "value": "000025" } }}And here is the payload I’m sending for the second API call:json{ "entity": { "id": "eed4ab6d-ccd5-f011-a83a-6045bd6d244f", "ReferenceNbr": { "value": "000025" }, "Hold": { "value": true // I also have tried false }, "Type": {

Hey folks - do we know if there is a way to create a mapping, without customization to default the Ship Via - or are we forever bound by the Shipping mapping on the Store Settings?i.e. when a new shipment method is created in shopify and we want to import an order the system errors out because the mapping to the ship via is not provided on the Store Settings. How can we default one ship via value?

I’m trying to create a report that produces a excel sheet with cell borders. However, I can’t figure out how to get the borders to display in Excel. Is there a way to format the excel cells in Report Designer?

Is it possible to download multiple selected files as a ZIP file?Able to download one file at a time, but I need to download multiple files together as a ZIP file 

Hi All,Is it possible to add a line number as a field item and use it to format the output of the GI? For e.g., I have a GI that lists 10 rows but I had like to use the line number to change the background color of each alternate row, which is not based on any conditiion. Since, the Row Number is available only for display, how to get a row number for any GI (not a report)?Manish

I have a sales order that i have processed through into shipping and invoiced. the shipping and invoiced status both show completed/closed  but going back to the sales order it shows as ‘Open’ and not ‘completed’. I have put the order on hold and clicked off the check box under the completed column and have also clicked on ‘complete order’ under processing and still will not change the status of the sales order to ‘complete’.How can this be resolved in order to show status ‘completed’. Please help. 

Hi gurus. How do I create an Import Scenario that changes the transaction dates of Open Move Transactions dated in the current month to update to the first day of next month?Users make the move transactions ahead of time and so when they go to close out EOM, they can’t because there are "open Move transactions". The import aims to just shift them to the first day of the next month e.g. 30/11/2025 > 1/12/2025. Data provider would be a GI of open move transactions.

Hello everybody,I have the following scenario:A set consists of two components: a certificate, a 20-item box, which can contain one or more lot/serial numbers. In the delivery note, the information should be displayed as follows: Line for the certificate Line for the item (20-item box) Below the item line, a list of all associated lot/serial numbers should appear – regardless of whether there is one or multiple lots. The lot/serial numbers come from the field:[SOShipLineSplit.LotSerialNbr]Problem:When I use a separate detail section for the lot/serial numbers in the report, Acumatica repeats the item line for each lot/serial number. This causes duplicate or multiple item lines, which is not desired.I need a way to display the item line only once and list all associated lot/serial numbers below it in a single consolidated view.Question:What is the recommended approach or report setting to display the item line only once and show a consolidated list of all lot/serial numbers from t