Discussion Forums

How can customer payments be set off against another customer account in Acumatica when there is no established parent-child relationship between the customers, and without creating debit or credit notes?Looking for recommended approaches or best practices.

We have a very large product count (400k+ SKUs) and are looking to launch our Shopify store on Shopify Plus very soon. Shopify has given us increased API capacity for 30 days, but now I'm getting the following error when trying to sync:Adding the specified count to the semaphore would cause it to exceed its maximum count.Has anyone run into this? Any guidance appreciated.  

I’m running into a strange issue where I have a customization project targeting PO screens with multiple purposes - some validations to prevent certain combinations of projects and subaccounts, and another to unlock certain fields like descriptions and such while the po is in pending approval status. When I publish this project on my local dev environment, all works great (no other customization projects installed). When I publish this exact same project on a client’s cloud environment, the validations work but the field unlocking under pending approval status does not. Both environment have exactly the same version and patch deployed (2026R1 Patch1). I’ve unpublished all other customizations and only published this project in both environments, and the same happens. In the dev environment, everything works as expected in both classic UI and modern UI. In the cloud environment it does not work in either. This customization used to work in 2025R1 on the cloud environment, but stopped wo

Running Build 26.100.0175 The instructions have the following block:*Activity log*<foreach view="Activities">- Activity Type:((Activities.Type))- Activity Date:((Activities.StartDate))- Activity Summary:((Activities.Summary))- Activity Details:((Activities.Body))- Activity Incoming: ((Activities.Incoming))</br></foreach>Formulate the response in English. Use the activity details from the past 30 days, to provide the case full view. The response should include the below points only:The prompt shows the following without showing any of the activities that are on the case :*Activity log*Formulate the response in English. Use the activity details from the past 30 days, to provide the case full view. The response should include the below points only: Compare to the CLOSURE-NOTES prompt which has similar instruction block and does show activities.*Activity log*<foreach view="Activities">- Activity type: ((Activities.ClassInfo))- Activity date: ((Activities.StartDate))

Hi, I need to set up a fuel levy (fuel surcharge) per carton amount ($0.20) to auto apply on purchase orders to a specific supplier and then $0.30 to auto apply to customers when ordering products from this same supplier? How do I do this?

Has anyone found a method to auto release reversing journal entries? They get created on Hold and we are finding that users are making changes to them prior to release. We need to prevent that.

I have created a Bill using PUT /Bill REST API endpoint and it created below data, the process also includes releasing the bill but I am encountering a “The document is out of balance” error. It seems the bill header total figures were not calculated correctly. For this bill, I created its own PO and PO Receipt with vendor’s Allow AP Bill Before Receipt unticked (3way match)On second screenshot, I checked the PO Receipt linked to the Bill and based on the Billing tab, it shows Billed Amount as 550 which is correct and matched with the Bill line’s Amount. I am not sure what needs to be added on the payload when calling /Bill API endpoint but when I used UI to create Bill from PO receipt, I don’t encounter the “The document is out of balance” error.Thanks! 

In assignment and approval screen of Requests cannot find field status but on screen ui I can see the status field.  

We have Cost projection in which the UOM is empty but we need to bulk update to ‘EA’. I first tried to update by editing the GI and adding the filed to Mass Update tab but it was not possible. I am now trying to use Import by scenario to update the filed but getting errors such as View Document or Add button lines disabled. Before I keep investigating is it even possible to bulk update using either way

We are currently on 2025R1 and noticed this week that we are unable to add a new record from the Subcontracts primary list. When it was reported by a user, I checked user rights and this individual has full access to that screen.  I as an admin also am no longer able to see the ‘+’ sign to add a new record form the SC3010PL screen.   As a workaround we are able to add a new record by opening an existing record and clicking the ‘+’ from there, or from the Commitments screen of a project. Our production instance is: Build 25.101.0153.9 + Our Sandbox, which is build Build 25.101.0153.2 +, has the ‘+’ on the pl list.  I even made a copy of the Subcontracts PL in our Sandbox, exported it and imported to our Live instance, and the ‘+” is no longer visible.  Wondering if anyone out in the community has seen this behaviour and/or what else I should do to troubleshoot it?   There was a patch applied to our Prod instance last week so am wondering if this might have anything to do with that. 

Hi Team,I am working on an custom report based on PMTimeActivity and needed to add a Manager filter using EPCompanyTreeMaster and EPCompanyTreeMember so managers can view only their employees.I added joins similar to:BAccount.DefContactID = EPCompanyTreeMember.ContactIDEPCompanyTreeMember.WorkGroupID = EPCompanyTree.WorkGroupIDand filtered using:EPCompanyTreeMaster.Description Like @ManagerOR@Manager IsNullThe filter works correctly, but after adding the EPCompanyTreeMaster and EPCompanyTreeMember joins, the report values are getting duplicated.Kindly assist if you have added similar filtering using EPCompanyTreeMaster and EPCompanyTreeMember in reports.Please find the screenshots of my joinings and filterings    

In Acumatica 24R1 through 25R2, I have experienced an issue of the Shipstation “Age” being off by up to 23hrs. This seems to be the “expected” behavior according to Shipstation. Has anyone else experienced this issue? If so, any work arounds? 

We confirmed ShipEngine is successfully returning valid UPS and FedEx rates outside of Acumatica using direct API testing.The ShipEngine /v1/rates response completes successfully with no errors and includes valid service codes such as: fedex_ground fedex_priority_overnight ups_ground ups_next_day_air However, Acumatica 2025 R1 still fails during Get Rates with:"The given key was not present in the dictionary"Stack trace:PX.ExternalCarriersHelper.SOShipmentEntryExtCarriersPXExt.ReplacePackagesWithActualPackagesAll returned ShipEngine rates contain:"package_type": nullPlease confirm whether there is a known 2025 R1 ShipEngine connector defect or hotfix related to package mapping/rate parsing within CarrierRatesExtension. Any assistance is greatly appreciated. 

In the classic dashboards, when you click on a KPI widget it takes you to that GI with all your filters accurately displayed so you can see quickly what info makes up that KPI. In the Modern dashboard, it does not carry any of your parameters from the dashboard over to the GI. You would have to refilter from there. This seems like a regression in Dashboards. It was much easier to view what the KPI was made of before switching over. Has anyone else experienced this? Is there a solution in the works to use the behavior of the classic dashboards since that was easier to navigate and get information fast?

Once cross-sell suggestions have been generated and then approved on the Manage Cross-Sell Suggestion form, is there a way to un-approve this suggestion.  The related item can be deleted from the Stock Items Related Items tab, but would be helpful if there was a way to do this on a process screen instead of individually.

Any other Amazon sellers still experiencing this? Seems to be no solution from Acumatica in sight 

We are an Independent Special District of the State of Florida (Fire Department). We are members of the Florida Retirement System, which is a 401(a). We need to code the deduction for this retirement plan correctly. There is no option for a 401(a) in Acumatica currently. How do we add it? This is affecting an over 50 employee with his catchup contributions. Any help would be greatly appreciated. Sincerely,Denise McCaughanA 401(a) is a retirement savings plan that an employer sponsors, and that allows for contributions from both the employer and the employee: Availability: Some public sector employers offer 401(a) plans. Contributions: 401(a) plans typically have employer contributions that are non-elective, meaning they are made regardless of whether the employee contributes. However, contributions can also be elective, or "match" contributions, where the employee must contribute first to receive the employer's contribution.  Taxation: Earnings in a 401(a) plan are tax-deferred, meanin

Can anyone confirm whether this has been taken care of it 2026 R1?

Recently updated to 2025R2 and using Modern UI, the column configuration is not saving, even when changed on the column configuration button (now gear) and saving it.  Any ideas on how to make the new configuration stick?  

After upgrading to 2025R2, clicking Export>PDF from the check printing window no longer protects the MICR line. Previously, all characters were being replaced by “•••••••••••••••••••” but it now shows the MICR font. Is there a way to turn this feature back on?

Has anyone out there attempted to allow users to view 3D CAD Files (.step) attached to a BOM or Production Order from within their browser?  I assume we would have to use a cloud based file management system that integrates with Acumatica.Only other option I see for Acumatica-initiated viewing is to download the files to the local machine, then use a free 3D CAD viewer software, like eDrawings (Solidworks).Obviously we can use a server directory, but the user would need to search the directory for the part number based on the Inventory ID from the Production Order.

We are raising invoices from projects module or from AR module and want to be able to make the customer order field mandatory.In payables there is a data entry setting to require a supplier reference but doesn’t seem to be any equivalent for a customer reference (PO number).It would also be great if we could also amend the customer reference number for corrections after the invoice has been released without having to reverse and re-raise.Sorry rookie question!

Good da CommunityI am battling with a report I have been working on for ages. It was originally written by someone else but has never wired correctly. I have at last managed to get the columns to have the correct data, but some of the totals are duplicating, i.e. Aquisition Cost, Closing Cost & Depreciation.I suspect that the joins between tabes are the problem. I would appreciate it if one of you experts would check these joins and advise.These are the formulae that are incorrect:Acquisition Cost - by Class - =$BeginningAmount; Total Report - =$TotalBeginningAmountClosing Cost - by Class - =$ClosingCost; Total Report - =$TotalClosingCostDepreciation for the Period detail - =Sum(iif([FAHistoryByPeriod.FinPeriodID] = [FAHistoryByPeriod.LastActivityPeriod], [HistoryLast.PtdDepreciated], 0)) - this formula worked in a previous version before FABookBalance table was added.Any advise you could give regardug the table jjoins would be greatly appreciated.RegardsBarbara  

How can I change the status of a sales order to complete when it shows Shipping? 

Is there any risks or negative impacts on subledger/GL or other accounts if a Retainage Bill that is still on Hold is deleted? We have over 20 that have been released by accident and would like to delete rather than create any reverse entries