Discussion Forums

There are orders that contain non-stock items that get fulfilled right away before syncing to Acumatica the Shopify connector. These orders get the status of filtered. We would like to sync them to Acumatica using import scenario or API.Is there a way to import archived orders or modify Shopify orders to archive after 7 days? How do we prevent this from happening?

Is there a way to print a check for a customer refund that is not tied to the credit memo process?  The GITHUB package is not an option.

For example: A pay-in-advance Medical deduction of $150 was deducted from the employee paycheck for the upcoming month of coverage. The employee quit or was terminated.  We need to refund the $150 on the next/final paycheck. What is the best approach to accomplish this refund? 

I’m trying to do an import that will support updating existing records and creating new onesNew records only is pretty straight forward using the Auto Number KeyWe want to use Auto Numbering because we do not want to make the Serial Number the primary key because there are other factors down the road where the same Serial Number could be used multiple times across multiple customers/vendors, etc.  We are only importing records with a unique serial number right now.  But they will need to be updated.I’ve done some searching which seems to be involved with the concept of simulating the UI where you would use the Lookup Selector for the Reference Number and try to find a record with a matching Serial Number but I can’t get the right syntax down specifically for the Field Service Equipment FS205000The example from the training references a “CurrentCustomer” in the Source Field Value in the first line.That seems be an internal reference and I can’t quite figure out how to translate this exa

We have had this issue with 23R1 and it is still happening now that we have upgraded to 24R2. We have some products where we introduce new versions of them with new SKUs while keeping the product name the same.To do this, we have to delete the old product from BigC before we are able to sync the new product since BigC does not allow multiple products to have the same name.When we do this, we sometime run into an issue where if we include the deleted product as a related item on that new product, then it causes a syncing error that is unrecoverable. Essentially, Acumatica just keeps trying to sync the product, gets the same error from BigCommerce API that the product doesn’t exist, and keeps trying to sync without updating anything or giving an error message to the user.Has anyone else run into this issue?

Good day Is there a way to add a condition to a style in the Sales Order screen or a similar screen where the Sales Order gets highlighted if there is not enough stock available ship completely.  

Hello!I”m having issues implementing relations to support my results in a GI.I can list out all my sales orders, which type of order they are, warehouses and customers list no problem. However, once i implement an “address” feature, it breaks my GI and duplicates everything. I’ve read and reread the join type explanations and it seems that i want an “inner” join type. But i’m thinking i may not still understand this. anyone have an idea on how i can stop these duplications? 

How do you have a distribution addition and not include DRP in it? I find it curious that if this is such a need functionality, why is it not core to the product? Thoughts?

I have a report where I am trying to use the [PageOf] formula, but it only shows “1 of 1” on every page.From searching the forums, I’ve found the following:[PageOf] must be in the pageFooterSection Page footer ProcessOrder must be set to Always Textbox containing [PageOf] must have ProcessOrder set to WhilePrintAll of these criteria are met with my report, but I am still getting “1 of 1” for every page.

How do you set up Direct Deposit to receive payments from customers?

I am trying to create production orders from a sales order, but I keep getting this message:   Thank you

 I want to extend a new customers from business account, but while i try to extend there is error like this and also I can’t add a the new customer or account class. Can anyone help try to solve this?I really appreciate, thank you

Dear Supporters, I don't know why my set up approval have problem the user approval can't approval on the bill. Please kindly advise and Thanks in advance for support.  

Added this formula in the generic inquiry This error appears when trying to view generic inquiry. not sure what does this error means

Relatively new to Acumatica--we would like to make a change to the Profit and Loss financial statement to sort by Account Class then by Account Number.  Can this be changed and if so, what is the procedure to do so.  Thank you in advance.

Hello Community,I need advice regarding a customization we applied on the InventoryItem DAC. Initially, we had a custom field UsrUnitCost defined as [PXDBString], so in the database it was nvarchar. Later, I changed it to [PXDBDecimal] and republished. This altered the DB column to decimal. Recently, I changed it back to [PXDBString] because I wanted to show values like 20.33 BOX. Now in production, I’m seeing errors such as:The entry form (ID: IN202500, title: Stock Items) cannot be automated. An error occurred during processing of the field Unit Cost: Specified cast is not valid. How can I unpublish only one customization to check whether the error goes away or not? This works fine in sandbox but in production this issue occurs 2 days after publish. I have atttached the package. Thanks

Is there a user group conference for the Southern Region of the USA coming up in the next few months?We have a couple of users that are wanting to attend a conference.

Hello, We are running Acumatica 2025 and Shopify Advanced with the  standard Acumatica<>Shopify connector and are experiencing a lot of issues. We have two(2) retail stores, one e-commerce site and an industrial sales division. Our ERP is Acumatica and our online store and POS run on Shopify.We have been unable to get real-time sync of orders. Everything goes through a schedule - orders, item availability, payments, etc. When we do flash sales/promos, we oversell product. We have been unable to to implement BOPIS. The Shopify statuses (Ready for Pick Up and Marked as Picked Up) is not transferred to Acumatica. We have automatizations that close the orders in Shopify automatically. For POS orders, we are ONLY able to do exchanges or returns for original form of payment. Gift Cards or product exchanges are not updated because of a order does not allow modification errors. If a customer buys in store A but returns or exchanges products in Store B, this second transaction is posted t

 I have a screen in Classic UI. there is a Parameters grid in the lower. After adding data to the Parameters grid, it reflected in the Formula Editor when click on Equation field and inside the Fields node. This works correctly in Classic UI likeso, to achieve this, written code in the ASPX.CS file to retrieve parameters inside the Fields node-------------------------------aspx-----------------<pxa:PXFormulaCombo ID="edChildField" runat="server" DataField="Equation" EditButton="True"  FieldsAutoRefresh="True" FieldsRootAutoRefresh="true"   LastNodeName="Fields"   PanelAutoRefresh="True" IsInternalVisible="false"  IsExternalVisible="false"   OnRootFieldsNeeded="edOns_RootFieldsNeeded" CommitChanges="true"/>   -------------aspx.cs:- ------------------------------protected void edOns_RootFieldsNeeded(object sender, PXCallBackEventArgs e) {      EWQCVariableMaint graph = this.ds.DataGraph as EWQCVariableMaint;        if (graph != null) {          String[] parameters = graph.GetAllPar

We went from 2023R2 to 2025R1 (25.101.0153).  I had a request to check a report parameter, but I am getting ‘Authentication Failed.  The user with the given login and password was not found in the system.’ when I attempt to open Report Designer.Upgraded Report Designer with the 2025R1 Acumatica Tools. Verified my user(s) have Report Designer Role My Site URL didn’t change. The user name and password did not change and work in Acumatica. I switched my URL to my local sandbox with the same results.Any guidance?

I would like my generic inquiry to include a variance column for our labor hours. The problem I am running into is that the inquiry doesn’t return a negative number when the “To Date” amount is less than the “Est Labor Hrs”. (Ex. 673.05-1,358.00 should return -684.95 so we can see the difference)This is the current formula I am using for the +/- hours column: =IIf([PMBudget.Type]='E' AND [PMAccountGroup.GroupCD]='LABOR', [PMBudget.ActualQty]-[PMBudget.Qty], 0) I am also using these formulas to get my estimated and to date labor hours.Estimated Labor Hrs: =IIf([PMBudget.Type] = 'E' AND [PMAccountGroup.GroupCD] = 'LABOR', [PMBudget.Qty], 0)To Date Labor Hours: =IIf([PMBudget.Type] = 'E' AND [PMAccountGroup.GroupCD] = 'LABOR', [PMBudget.ActualQty], 0) I know the within the projects the balances tab shows a variance amount, has anyone figured out how to replicate this in their own generic inquiry?

For a webhook that has been registered with an endpoint in Acumatica (24R1), how does a non-developer discover the interface for documentation/testing purposes outside of requesting it from the developer or having access to the underlying class in the VS project? The customization project only has the DLL in it, and there is no option on the screen to view the interface definition or to generate a swagger file.  Thanks.Added:  Additionally, is there a way for a developer to read/consume the webhook endpoint in order to generate a stub for the interface? 

We are looking at the use of Ai to extract data from our production orders and put out in a BI tool the work that each work centre is working on, the current amount of hours done, and whether they are on target or not.Has anyone done this yet? and if so, what tools were found to be the best for doing it?

Has anyone leverage an ISV to assist with customer billbacks short payments for promotions, rebates or etc?  

On some of the service contracts the Default cost Code field was left empty.  This is preventing our Service dept from Processing the service contracts and move them to the expired status. I what I thought was a simple import scenario to update the blank ones to add the default cost code to those missing.  I keep getting the error message of “The System failed to commit the ServiceContractRecords Row when running an import scenario” I tried unchecking the commit box as another post suggested but I am still getting the same error message.