Recently active topics

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

So, I just build this GI. I want to show year to date for this year and last year.The formula for this year is working. The formula I have for this year is not working. Can I please get help if anyone has done this.This is my result now. 

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? 

Environment - Acumatica version: Acumatica 2025 R2,Build 25.200.0248- SQL Server: Microsoft SQL Server 2022 Express  - Module: Automation Schedules / Scheduling Error messageCannot insert the value NULL into column 'IsRelative', table 'DatabaseName.dbo.AUScheduleFill'; column does not allow nulls. INSERT fails. When it occursOccurs when saving or running an automation schedule that includes entries in the Filter Values tab after recent changes (upgrade, customization deployment, or schema update). The error appears at the moment the system attempts to insert rows into ‘AUScheduleFill’. --- Steps to reproduce1. Log in to Acumatica and open Automation Schedules.  2. Create or open a schedule that has a populated Filter Values tab (one or more filter rows).  3. Save the schedule or trigger the schedule run.  4. Observe the SQL/Acumatica error about `IsRelative` being NULL and the INSERT failing. --- What I have checked and tried- Confirmed the exact error text in the Acumatica trace and S

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 use the Shopify Connector for Acumatica and have run into a workflow question:If an item has already been synced with Shopify and we later decide to de-list it from Shopify (but keep it active in Acumatica), the usual step is to uncheck the "Export to external system" box.However, when we do this, the item in Shopify remains Active and continues to appear in the online sales channel. The only effect seems to be that no further changes are synced after that point—it does not change the Shopify product status (Active → Draft) or remove it from the online store.At the moment, it seems the only options are: Change the Acumatica item status to Inactive, or Manually change the item’s Ecommerce Visibility in Acumatica. Question:Is there a way to configure the Acumatica → Shopify integration so that when the "Export to external system" box is unchecked, Acumatica automatically sets the item to Draft or removes it from all sales channels in Shopify?Any insights, workarounds, or best practi

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

I was wondering if anyone has a work around for reconciling Balance Sheet accounts?  Our accountant likes us to reconcile all of our Balance Sheet accounts.  When we were using QuickBooks, this wasn’t an issue.  However, using Acumatica, this doesn’t seem possible.  Any suggestions? 

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?

Good Day how can one get the current detailed TB report to display budget columns next to each TB line? 

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 

Hi, I’m trying to consolidate group of companies for financial reporting. I’m using ARM reports to consolidate different companies and there are minority adjustments to be made to remove the non-controlling interest of few companies. Is there any way that can be configured in Acumatica?Thank you,Dulanjana

We are trying to clean up old vendors from our list vendor but do not have a way to identify the VENDOR status without having to drill down and open each one which is rather inefficient and not as useful as “VENDOR” status.  This may be to do a user before my time messing with the generic inquiry schema or is that how everyone’s vendor report appears. We do have MASS EDIT option SELECTED and can INACITIVE the VENDOR(s) accounts all at the same time once we have the VENDOR STATUS column available in the GENERIC INQUIRY.Does anyone know our VENDOR GENERIC INQUIRY would have a column for CUSTOMER STATUS rather than VENDOR STATUS?  The Vendor status also does not appear in the list of fields that can be selected to be visible in the report edit options.  . 

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.)

I have only project ID and TaskCD. How to import task by TaskCD?