Discussion Forums

I'm looking for feedback on a file synchronization issue we're experiencing.ScenarioWe have an Import Scenario configured to pull a file from an SFTP location using the File Maintenance screen's Synchronization tab (Synchronization Type: SFTP). The provider overwrites the same file in place each time new data is available — the filename does not change, only the content and (presumably) the modified date on the SFTP server.IssueEven after the file is overwritten on SFTP with new/updated records, Acumatica continues to import the old data. QuestionsDoes Acumatica rely on the file's modified timestamp or other metadata to determine whether a synchronized file has changed? Has anyone successfully used a single fixed file name that is continuously overwritten?

We are using the native shopify connecter with bidirectional sync for sales orders - and i found that if i cancel orders is shopify, it cancels the order in acumatica properly.but if i cancel the order in Acumatica, the moves to “Cancelled” in shopify - but the payment does not get “Voided”, it just remains authorized and i have no way to manually cancel it in shopify. i reached out to shopify plus support and they said it needs to be done by the API.Anyone have any insight into this?  

We have a large field service division that runs daily break/fix service calls. Each technician has their own service van full of inventory that they use for these calls. In Acumatica we have created a separate warehouse per truck in order to track the inventory levels and perform daily replenishment. How can we set a default warehouse (truck) per employee so when they add inventory items to their FS appointments it comes off of their truck only? It needs to be automatic; we run hundreds of calls per week and cannot expect our technicians to add their warehouse and warehouse location each time they enter a part/item. (We are running 26R1 for reference)

Has anyone figured out how to restrict a column datasource for a specific segment of the subaccount?  We have a client with a 4 segment subaccount and they want to break out columns of the financial statement based on specific values of the 4th segment.  I have tried various different possible wildcard characters in the subaccount string for the first 3 segments but it keeps returning nothing when run like that.

Hi Acumatica Community, I am in a situation where in our production environment when a user upon Loading the Documents and just before clicking “Save” the system is working perfectly.The moment “Save” is clicked the system becomes unresponsive for all the other users who were trying to do anything. The “Save” action alone is taking almost minutes sometime even multiple minutes and no other user is able to do anything and the system just becomes unresponsive.I did check if it could be related to some customizations and even tried unpublishing the customization that touched this screen; the problem still exists.Steps that I have taken to find the root cause of this:Tried to do record a Profiler for this action from the moment this screen loads. Upon inspecting the profiler for multiple scenarios the thing that was consuming the most of time was an Update SQL specially an update query that was taking multiple seconds. the longest time consuming SQL update statementupon sorting on the long

I have a GI that compares settlement batches to AR payments and then puts those payments on bank accounts, but I’m finding that even though settlement batch processing center transaction numbers match AR payment external reference numbers it’s leaving certain information blank. I’m sure it’s something simple I’m missing!

I received a payment from a Vendor that is a refund for a previous invoice paid.  How do I process this transaction to show that this vendor paid me back?  The refund exceeds any of my invoices and all invoices have already been paid.  So there is no open invoice to apply a credit to.  Need some help.

We have a custom action that prints one label report per container when a user selects several containers at once (e.g., the "Print Container Labels" batch feature). To send all labels in a single request we build a PXReportRequiredException for the first container and chain the rest with AddSibling(...), then throw the exception.This works as expected in the Classic UI (all containers are rendered), but in the Modern UI only the first report is shown — the siblings added with AddSibling are ignored. It looks like AddSibling may be deprecated or handled differently by the Modern UI report viewer.Questions:Is AddSibling deprecated / unsupported in the Modern UI? What is the recommended way in the Modern UI to print multiple report instances (one per record) from a single action so that all of them are produced?Environment: Acumatica 2025 R2, Modern UI.Code we currently use:public void PrintContainerLabel(List<FRContainerHeader> containerList, bool isMassProcess = false){ int? c

Am I just too old fashioned, or does anyone else lock down the ability for end users to create Shared filters on GIs (and elsewhere in the system)?  It seems like every time I have a consultant working directly with an end user the question always comes back “Why can’t this person check the “Shared” checkbox?”  I have over 200 users on the system; if everyone had the ability to share their filters the list of filter tabs on most GIs would scroll off the side of the screen.We lock it down, so when we do have a user with a good filter to share, we (IT) wind up recreating it.  It’s not a horrible task, but now we’re starting to do more pivots and recreating those is painful.  

Hello, group,Long time listener, first time caller… We’re just getting started using the Rough Cut Planning and Production Schedule Board Modules and we’re wondering if there is a way to easily export the Production Schedule Boards. It’s old-school, but while we’re learning the tool, I would like each plant to print the Production Schedule Boards out for their Production Teams to review until we are fully comfortable with the tool and can display on a large monitor. We’re on release 2025 R1.  Thanks...

We would like to sync PDF files into Shopify and display them on the storefront. The files have been successfully synced, but the issue is that we cannot open the files in Shopify. Could you assist us in resolving this?Or any alternatives on how we can flow this into Shopify? 

Hi,I have a requirement to build a Generic Inquiry (GI) that compares Purchase Order values against budgeted amounts for each GL account.I attempted to use the tables below, but I’m not able to retrieve the correct figures or reconcile the data as expected.  

When Acumatica released changes in builds only, we would always get the release notes for each build. Is there somewhere I can look to see the release notes for the patches? We are on 25R2.

Checking feasible to print Appointment information from the Invoice screen when an invoice is printed or emailed. Is it possible to print or email appointment information invoice screen?

When I create an invoice from multiple departments in the Receivables Module.  I want (“Prefer”) that the GL Codes assigned to my Non-Stock Inventory item to take precedents and to populate the line item detail.  Instead it takes the Customer default setting instead.    Currently I only have one customer that will recognize the GL Codes from the Inventory Line.  I have already set AR Preferences to “IIIIIIII” to update the “masking rule”.  But most of my customers accounts do not recognize this.  Is there some hidden masking rule in the Customer Profile that refuses to recognize the GL Code for the billing item?   What am I missing here? 

Is there a way to change an item from stock to non stock?Thanks!

Hello, I created a custom label where an employee can put in the production ticket number and print a label. Upon testing, I realized that the information will not populate unless the WO is in a “Completed” status. I would like for this to populate in the “Released” status as well. Does anyone know how to achieve this? Released Status: Completed Status:  

Hello all,I have a scenario, where I would like to manufacture my FG either from Site A or Site B. So based on my Machine availability and MRP planning, I would like to have the option/suggestion from Acumatica as to from where shall I move to Produce my FG, whether it is from Site A or Site B.Is this possible in Acumatica? If so, how? Would be grateful for your guidances and inputs.

I would like to gather suggestions on how we cam handle intercompany transaction under a single Job in Acumatica? Also, looking to restrict the visibility of for instance, Company A data to not be visible under Company B and Vice Versa.What could be best practice?

Hi everyone,I'm currently working on an SPS Commerce integration project with Acumatica and was wondering if there is any public documentation that explains the overall integration process and setup.If anyone has implementation guides, knowledge base articles, training materials, or can point me to the appropriate documentation, I would greatly appreciate it.

If a Modern Customer Portal user (a contact of a company) is granted access to the portal, with the Customer Portal Contact Manager and Customer Portal Company Manager roles, within the portal they can view Company Profile and click Add New Contact, but after doing this, the new contact appears in the Contacts tab of the customer account in the main ERP instance, but within the portal, the user is unable to see any records listed in the Contacts section of the Company Profile:We would like to use this role to allow a nominated company contact to manage the portal users within their company, with the ability to add new contacts, revoke access to contacts who have left their organisation, change passwords etc.  The Customer Portal Contact Manager role looks like it could do this but doesn’t seem to work properly. Could this be an issue with the default access rights for the Portal Contact Manager role? 

Hi everyone,I am currently analyzing the database schema for the Manufacturing Edition, specifically looking at the Cost Roll process (AM508000).I noticed that the core table used during this process, AMBomCost, includes a UserID field as part of its structure.Could someone please clarify the exact architectural purpose of this field? Is it used strictly for session-based data isolation to prevent conflicts during concurrent cost rolls by multiple users, or does it serve another specific tracking/auditing purpose within the Manufacturing module?Any insights into how Acumatica handles data inside AMBomCost during the processing lifecycle would be greatly appreciated.

Every month our company sends out Customer Statements to show Invoice and Payment history for that month. We email some and print and mail some. We have been live with Acumatica for a year and every single month there is an issue with these statements. Whether it’s calculations are off, form not printing correctly, missing data, etc. we have shelled out considerable amounts of money to our partner to fix these issues just to fix a new issue the next month. Can anyone recommend either an expert Acumatica report designer or some solution that easily integrates with Acumatica that is more user friendly than report designer and we can create the forms ourselves? Anyone know anything about GoFormz? We have Velixo, can I use that? Any help suggestions are welcome!

Hi Team,I’m having a hard time with a refund to a customer.Back on Dec 29, 2025, a payment from customer XXXXX was deposited into our bank account (they’re on PAP)Payment XXX for $1594.05Part of the payment was for an item that was not yet in stock, and part was for an order that was invoiced and sent.The $1554.07 that was intended for an item that had not yet been invoiced was left as an open payment on their account.The customer later cancelled that order, and I refunded them.The initial payment (XXXX) and the refund (YYYY) both show as open in Acumatica. How do I connect these dots and close off the payment and the refund? The refund is appearing twice in the Payment Transaction section of the application history, and it is also reflected in the Refund Transaction section.Please advise connect these dots and close off the payment and the refund

Hi Team,  Bright Side's orders aren't automatically invoicing like they should. When I go to manually invoice them I get an error related to Pacejet. Can you help look into what is going on? Below are the two shipments currently needing to be invoiced.I tried to correct the shipment to see if I could send it back through but since it has been too long since confirmation it wouldn't let me. The problem is, even though it wouldn't pull it back from Pacejet into Acumatica, it still deleted the shipment from the Pacejet side. So now its busted even more.