Discussion Forums

We are considering changing from Shopify POS to Clover.Is anyone using Clover for POS, and if so is there a preference for which 3rd party connector is used?Thank you

I’m trying to condition a GI to only show shipments that were confirmed yesterday.Originally I was using ShipDate and was able to achieve this by using the following formula:SOShipment.ShipDate Equals =DateAdd(Today(), 'd', -1)But using the SOShipment.ConfirmedDateTime does not give me the same results (it actually gives me no results). 

Good day, I have Generic Inquiry that pulls data from Customer and Activities including email subject.  I have ten different Branches for the time being.  I am going to have more than 100 as some point.  I don’t want to create a different GI and then set them to the individual branch security roles.  The customer are set to Restrict Visibility for the customer account.  We don’t the Branch manager to see the other branch activities.  Any ideas?Thank you.Evam  

We are having an issue attempting to partially ship an SO line linked to a partially completed production order.  Work order/SO quantity is 100, we have 50 complete.  Selecting the SO line shows 50 on hand/ available / available for shipping, but none allocated.  Line details shows the below, which looks strange from what I recall in the past.  This hasn’t been an issue in the past but we recently upgraded to 25.201.0213.2 and this isn’t something we do often so wondering if it is a bug or some obscure setting that now needs to be changed.  Any guidance would be appreciated.  Thanks,Dan

I have the following issue with Modern UI:In one package I create a column.In another package I add a field / logic that depends on that column.Everything works fine when I develop Modern UI in Visual Studio — after build, all changes are visible on the screen and work correctly.But when I add Modern UI files into packages and publish them in another instance of Acumatica ERP, I get errors (field/column not found).I understand that this approach is not recommended, but I still need to make it work.Is there any way to handle this scenario? [2026-03-26 14:54:27.199] npm run build failed with output:> screen@0.1.0 build> cross-env node --max_old_space_size=6144 --optimize_for_size --stack_size=6144 --trace-warnings ./node_modules/webpack/bin/webpack -- --env production --env tenant=Company screenIds=AR301000,AR303000,BZ101001,BZ101007,BZ201520,BZ401005,BZ401022,BZ501011,BZ501012,BZ501013,BZ501014,BZ501015,BZ501017,BZ501041,

I’m hoping someone can help us with a workflow hang-up we’ve run into several times. We are a contractor supply store and often place custom orders for customers or drop ship and/or ship material from our location to a jobsite.When we custom order products, we pass the our vendor’s shipping cost along to the customer unless we can add it to one of our normal stocking orders.When we drop ship, we add the shipping expense to the Sales Order.When we ship from here, whether it’s using the UPS integration within Acumatica or LTL freight, we add that expense to the Sales Order. What is the recommended workflow from Acumatica or something that works for YOUR company for charging customers before the exact shipping amount is known? I see a “create pre-payment” button next to the “create payment” button, and when we create payments there are options for “authorize” and “capture.” My understanding of these 4 is as follows - “create pr

Hi All, Need help currently we are transitioning to the new 2025 R2 of Acumatica, by this I am trying to switch the Classic UI to the Modern UI, but the problem is when I am switching the UI to Modern UI all the customizations are not reflected to the modern UI, especially we have a customized button in Details tab of Opportunity, because we linked the Estimates on the Opportunities that whenever there is a created Estimated with the same inventory id on the details tab, after clicking the calculate price, the system will automatically calculate the price based on the margin code we specified.  Thank you

I am creating a purchase order approval workflow for a client. They previously used Purchase Requests with an approval workflow and are wanting to replace this with Purchase Order approvals.Their Request Approval Workflow conditions are based off Department and $ amount.  Currently it is not possible to setup Purchase Order workflows in the same way, as the Department Entity is not available.Can we add the department field to the Purchase Order header and add the department entity to the Purchase Order workflow?Additionally we would probably get the Purchase Order department field to default to the PO Owner (employee’s) department but they could select any department, as it

Good day,I wrote the attached WO Import Scenario.  It is said it processed without issue.  However, it not producing the write off document from the scenario.  I think it has to do with the selection/process action not working.Any assistance would be greatly appreciated.Thank you.Evan

There are a built in plug ins for both EasyPost and Ship EngineDoes Acumatica recommend one vs the other ?At one point I thought EasyPost was the go to integration that Acuamtica was developing but I do not see EasyPost set up as part of the Sale Demo...Suggestions?  Only looking at one of these two since the integration is “built in”   

We are adding drawing files for requested customizations to our open Opportunity File.  Once we have the drawing on file, we reach out to the customer for their approval, using create email selecting email template, from the Opportunity file.Is there an easy way to get the file document on the opportunity to be included on the Email being created from the same document, without having to download the file and then import it directly to the email?Surely having to download in order to then turn around and upload to an activity on the same document is not the intending process flow, correct?

I am currently working on printing the Purchase Order in line sequence based on Sort Order instead of Line Number.I attempted to use POLine.SortOrder with ascending sorting in the report; however, the sorting does not appear to be working as expected.Could you please advise if there are any additional configurations required or if there are any limitations with using SortOrder for this purpose?Thank you in advance for your guidance. 

Hello,Curious if other folks are noticing the same issues with Acumatica Updates and Upgrades overwriting customized reports?  Historically, we haven’t had issues with this, but it appears in the newer updates and released that stock forms that have been previously tweaked/changed (i.e. the check form) are not printing correctly after updates?Thanks,Megan

I got a couple issues with the Shopify Connector, specifically the customer location sync.At random it will create more than one location for the customer in Acumatica.  It will activate one and deactivate the other.  Since upgrading to 2025R2 we have every day one or two orders where it will fail to import due to "property set method not found". What we found is that it means that the location is not active. When you go to it in Acumatica, you cannot activate it either. You need to create an additional location, make that the default, then you can go back to the other location and activate it.  In addition I found today that when I look at audit history for any customer, it will show me a bunch of location changes for different customers, different random locations. I don't know what these mean and why they're showing up on another customer that's not even connected to our Shopify store.  

We have a situation where a B2B shopify order gets sync’ed into Acumatica from Shopify.  The order is on terms (IE - Net 30) so no payment records comes with the shopify record.   Shopify order is fulfilled inside Acumatica and Invoice is generated for sales order.  Some time later, customer pays the invoice and invoice is closed in Acumatica but the original order in shopify remains open instead of closed.   Is there a way to close that B2B (Terms) order in shopify when payment is completed in Acumatica?

Hello! The below code is running great in 25R1. It tells the system to look at the UsrQUOTECOST field on SOLine when create a PO through Create Purchase Order. If UsrQUOTECOST is empty, then system should behave the same, if user inputs value in UsrQUOTECOST, then when PO is created, the unit cost field should pull from this udf.The issue I am running into is that when I try to publish this code in a 25R2 tenant, I get the following error: The PX.Objects.PO.POLine FindOrCreatePOLine(PX.Objects.PO.POOrderEntry, PX.Objects.CS.DocumentList`1[PX.Objects.PO.POLine], System.String, PX.Objects.PO.POFixedDemand, SOLineSplit3, FindOrCreatePOLineDelegate) method in the PX.Objects.PO.POCreate_Extension graph extension is marked as [PXOverride], but no original method with this name has been found in PXGraph.And per the 25R2 developer release notes, looks like the FindOrCreatePOLine method was removed. Any ideas around what the alternative method would be

Hi All,Has anyone successfully used an Import Scenario to automatically convert purchases to Fixed Assets in Acumatica?I have been testing the Convert Purchases to Assets screen with a Business Event + Import Scenario approach. The scenario runs successfully without errors, but no Fixed Asset is created in the end.My understanding is that this screen relies on UI behavior:select the transaction in the top grid the detail line appears in the bottom grid fill in Asset Class and Department mark Create Asset then click ProcessThe reason I am trying to automate this is because I want the FA number to be available immediately when the stock is issued/shipped out. My warehouse team needs to attach the FA code to the item at the time of issue, so I need the purchase-to-FA conversion to happen automatical

Hello, I created this year over year variance report for qty sold of a stock item. As you will see in the screen shot below, the calculations in the QTY % VAR column are correct. However, the manager would like to see it as follows: Row 1 (for the 021 stock item) the % VAR shows -62.86 (round to 63). He would like to see it as 37% instead of -63%. Is there any way to accomplish this? Here is the formula used for the % VAR column: =IIf(     Sum(IIf(Year([ARTran.TranDate]) = Year(Today()) - 1, [ARTran.Qty], 0)) = 0,      0,      (Sum(IIf(Year([ARTran.TranDate]) = Year(Today()), [ARTran.Qty], 0)) - Sum(IIf(Year([ARTran.TranDate]) = Year(Today()) - 1, [ARTran.Qty], 0)))      /      Sum(IIf(Year([ARTran.TranDate]) = Year(Today()) - 1, [ARTran.Qty], 0)) )*100  

Hello Acumatica comunity,i have many customers. i have a question if somehow i need to increase customer number more than (10digit) 1000000000 + 1. how we can modify or the customerid field to accept more than 10.Currently acumatica with default settings accpets only 10 Digit CustomerID 

Hello Everyone!I’m Deena Howard, a controller for a set of retail stores in Florida and Georgia. I have been using Acumatica for about 4 years now and lean something new all the time. While I may only have a few answers, I have tons of questions. Usually related to Finance, Generic Inquiries, Report Designer, and Development.I hope to be useful!Deena  

We are using the Shopify Connector, and have the Shopify Warehouses mapped to Acumatica Warehouses. Whether I select a Location for the mapping or leave it blank, it seems to ignore anything <UNASSIGNED> regardless of Allocated or not. This is not ideal because it reports a higher inventory number than is actually available to be sold, resulting in over-selling, upset customers, etc.  Am I missing something?

Hi all, I am looking for a way to merge all the attachments for the transactions (for e.g., and AP Bill) showing up on AP Edit Detailed report into a PDF and link it on the same report against respective transactions. Please let me know if you have any suggestions/ alternatives for this. Appreciate your time!

Has anyone successfully configured a ShipStation connection with 25R2?  I imported the customization package, entered the configuration in Acumatica, then created a store in ShipStation. I received the message that the connection was successful, but no shipments are imported even for a manual refresh.  In fact, I don’t even see login activity in the request profiler.  The account information and credentials are correct, and I can hit the web service endpoint from Postman to receive shipment details for the date range.  I am working with ShipStation Support, but response time is slow with little helpful information provided.  I’m aware of the currency rate issue that can break the connection attempt from ShipStation if not configured, so that’s not the issue.  I don’t know if it’s a design flaw or a bug, but if you attempt to edit the connection details after setting up a successful connection, the screen is blank.  I’ve repopulated it many times and each time it comes back blank.

We’re using Pacejet with pack and ship in Acumatica. I’m wondering if anyone is having speed issues like I’m having. It takes about 45 seconds to confirm an order.

Hi,I have an SO Order Type that is Invoice and there is the Mark for PO box, but it is greyed out. I have created a new item with no items in stock and made the replenishment warehouse the same as on the order. There is also a default vendor for that item. Does anyone have a workaround or thoughts?