Discussion Forums

On the self service portal, when you open the Catalogue, you can select a Category which populates from the Item Sales Categories screen on the main site.We don’t want to display ALL categories.  I added a custom field to the screen to indicate that we want to show the selected category on the portal. I think I found where the Categories selector is populated on the SSP.public class PXSelectCategoriesTree : PXSelectBase<INCategory>{ public PXSelectCategoriesTree(PXGraph graph) { this.View = CreateView(graph, new PXSelectDelegate<int?>(categories)); } public PXSelectCategoriesTree(PXGraph graph, Delegate handler) { this.View = CreateView(graph, handler); } private PXView CreateView(PXGraph graph, Delegate handler) { return new PXView(graph, false, new Select<INCategory, Where<INCategory.parentID, Equal<Argument<int?>>>, OrderBy<Asc<INCategory.sortOrder>>>(), handler); } internal IEn

It's great that we have such a vibrant Acumatica community to get quick answers to questions and gain product knowledge! We have very active members jumping in to help others out all the time. The goal of the community is to respond to every member’s question so that no one goes away "empty handed".Connect, Learn, Share  Mark De Castro - Acumatica Community Featured Member for June 2026Meet Mark De Castro our Acumatica Community Featured Member for June 2026. It’s great to have you as part of the Acumatica Community ​@MarkD! Acumatica Community Webinar - Is your Acumatica system running harder than you realize? - June 18, 2026Acumatica 2026 R1 introduces a powerful new Resource Monitoring dashboard that gives administrators and partners real-time visibility into how their system is actually consuming CPU, SQL, and memory — mapped directly to the screens and actions driving that load.Join us for a live walkthrough where we'll show you how to use the new monitoring tools to spot performa

Is there a configuration or setting to force users to do a recount on the mobile device if they enter a value other than what is on-hand?Example steps:On hand inventory = 7 ea User enters 6 ea for the location Mobile device prompts that this value is incorrect and needs to be recounted After the second entry the user may continue with the count

According to this article, /entity is the way to get a site’s build number from the API. When will this also include the patch segment (e.g. 26.100.0175.2)?

When we go to sales orders or shipments and try to search for a customer, if we type their email in to search, that doesn’t work. We sell a lot online, and many times a customer will email us and ask for order updates or some other info. A lot of times they will not put their name in, so we only have the email to work with.   Or, they will put their name in, but the order is under their company name.  These fields do not come up when trying to search, so many times the results are empty if we type in the email or name in the search. So is there any way to search like this?  Even better, if there was some sort of a “Customer Center” where we could go to that customer, and see every single activity that customer has with us. Sales orders, shipments, invoices, current balance, etc.   We came from Quickbooks Desktop and they had a customer center which showed all of this, but I am not able to find a place that tracks everything like this.  An example of this would be if a customer calls an

The International Accounting Standards Board has issues IFRS 18 - the new standard on presentation and disclosure in financial statements with a focus on Profit and Loss. One area addressed by this standard is foreign currency. “IFRS 18 requires foreign exchange differences to be classified in the same category as the income and expenses from the items that resulted in the foreign exchange differences, unless doing so would involve undue cost or effort.”In Acumatica, Revaluation Gains and Losses are set up for each currency. Since the Revaluation process Creates a CM batch in the General Ledger an accountant can manually adjust the batch to allocate foreign currency gains and losses to the related income and expense accounts.  Does anyone have suggestions for a more sophisticated approach to this?

We want to email a report using the Email Template and Automation Schedule but we receive the error “A field with the name FSAppointment.UsrPartsReviewed cannot be found”.  The report runs fine from the screen and I’ve built a GI that uses the custom field as a filter and it also works as it should.   We received these trouble shooting steps from Acumatica Support:1. The updated report version containing the refreshed FSAppointment.UsrFinishedDate field is assigned as the active/default version.2. The report attached to the email template is pointing to the correct report ID/version.3. The customization package that adds FSAppointment.UsrFinishedDate is published in the tenant where the automation schedule is running.4. The automation schedule is running under a user that has access to the customization field/report.We verified all these as well as clearing the cache and restarting the instance but the issue still persists.  Just wondering if anyone else has had this issue and have bee

We are trying to develop a more systematic physical inventory process and are looking for advice on best practices within Acumatica.We are currently using Acumatica 2025 R2 (Classic UI).Our challenge is that we do not want to lock the entire warehouse when performing a physical inventory. Ideally, we would like to count only specific Inventory IDs or locations at a time.I realize that Physical Inventory Types can be filtered by location, and the Prepare Physical Count process allows us to further filter by locations and inventory items when generating a count. However, with approximately 1,300 active Inventory IDs and 1,500 warehouse locations, it still feels like a very manual process to decide what should be counted and when.From what I have seen so far, setting up and managing Physical Inventories appears to be heavily manual. Am I missing something, or does Acumatica really lack the ability to generate and manage cycle counts in a more systematic way?This has led me to investigate

Up until recently our company has solely used production orders for our manufacturing process. We have found that we can use the Kit Assembly process and still have the lot tracking capabilities that we desire. The one thing that we loose out of the box is the ability to track labor associated with the kit assembly and have that labor cost be allocated to the item being created. Has anyone come up with a process for this? 

Hi, Does anyone know how we can grant this blue “x” velixo customization on all GI’s to other users outside of system admin? We’ve searched everywhere on Access Rights.  Our product management team needs it and their role has access to the entire Velixo segment, but this button doesn’t appear on any GI’s. 

Hey there! Since “IsDefault” is non-existant in the POVendorInventory DAC how else can I bring in the default vendor for a specific inventory item?

We have developed a very powerful Approval Workflow that works on over 20 of Acumatica’s most used screens. Unlike other Approvals Workflows in the market that mostly manage AP Invoices, this workflow basically works on any screen that has Approval Map in Acumatica.Some of the benefits of this advance workflow are:The workflow allows to define multiple Approval Classes and Approval Routes.The workflow allows to Approve, Reject, Route, Skip and Complete any given document based on the permissions. Users who are part of the Approval Admin Role, can override the step.Approval chain can be set up at master record levels in combination with the Acumatica’s built in functionalities and used in transactional approval. For example if you are a construction company, you can setup your approvers on the projects and then use them for example in AP bills or subcontracts.,.. we support up to 10 level of Approvals at master record levels but can be increased if needed.All actions are permission base

Hello all,I want to know if tyats a possibility to create inter-unit production processes have 2 sites in Acumatica? Can anyone guide me thru this.Thanks

Hey, team - I am attempting to automate an email when an AP Batch is released to only those vendors associated with payments in that specific batch.  However, what I’ve built is resulting in an email to many vendors that are not associated with payments in that batch. I've reviewed the following video in preparation for this. https://www.youtube.com/watch?v=JEwTAB47opg The Business Event triggers and sends an email when it's expected.  However, the issue is in the sending of unnecessary emails to vendors who aren't included in the released batch.  My guess is there is an issue with the GI. GI and BE attached

Hi everyone,I am working on an Import Scenario and wanted to confirm if this is possible using standard Import Scenario functionality.Goal:I have a Generic Inquiry that returns one row per completed Sales Order. The GI calculates a handling fee amount based on 25% of the freight amount.Example GI result:Order Nbr. Freight Amount Handling Fee 25% SH12345678 17.41 4.35 I would like to use this single GI row to create one GL Journal Transaction with two detail lines:Account Debit Credit 1111- Shipping Revenue 4.35 0.00 Handling Fee Revenue GL 0.00 4.35 Question:Is there a way in an Import Scenario to take one source row from a GI/Data Provider and insert two detail lines into the Journal Transactions screen?In other words:1 GI source row → 1 GL batch with 2 transaction detail linesI tried mapping two Transaction Details lines in the same Import Scenario, but I am running into issues saving the scenario / processing the mapping.I am trying to avoid creating a custo

Has anyone created an import scenario that creates a journal entry and adds it to an existing recurring schedule.  Customer has approx 200+ journal entries that need to be imported and added to various schedules. Appreciate any assistance!Thanks.

I am getting the following error in report designer. An error occurred while executing the Substring(Identifier(ARTran.TranDesc), Const(0), BinaryOp - (InStr(Identifier(ARTran.TranDesc), Const(|)), Const(1))) function. Length cannot be less than zero.Below is the formula. It works in a GI, but not here.=iif(InStr([ARTran.TranDesc],'|')<0,[ARTran.TranDesc],Substring([ARTran.TranDesc], 0, InStr([ARTran.TranDesc], '|') - 1)) I am trying to print all characters to the left of “|”, but this fails when there is no “|” in the string.  

We are aware that currently there is an issue adding images to posts. Support has been notified and we are awaiting resolution. No ETA at this time. This post will be updated when there is more information.

Hi,I created one Processing screen with List of Vendors..After Processed selected records(3), All records(10) got vanished from the screen.If I refresh the grid/screen, then unprocessed records(7) are showing in the screen.How can I get unprocessed records automatically  without refresh after processing??Thanks.

Early this year, we added the Expense Management Module.  We have not been able to go live due to multiple usability issues - we have not been able to begin testing and mapping due to the fact that the Plaid/MX feeds for our credit card accounts do not bring over account owner information. That information is essential for a corporate card account with 20-30+ users. It is also essential for the functionality of pro-actively prompting employees to enter receipts for charges and matching those charges to the correct receipts. We need employees to proactively to see what charges are remaining to submit receipts on vs a manual receipt upload where after a month at reconciliation, accounting realizes they are missing multiple receipts and cannot complete the statement reconciliation.Is anyone using any third party/Acumatica friendly expense management apps that connect directly to Acumatica existing projects & GL Accounts as well as the ability easy approval mapping? If so, can you plea

Hello experts, i have created access right by role for sales user and have restricted user to create shipment but when i am creating sales order create shipment button gets enables and allow to create shipment. please check the screen shot for access right by role and please let me know what am i missing. 

Hi everyone,Our team is ramping up on the new Acumatica UI and we're gathering training material to get everyone up to speed. We've already found the T290 course, which has been helpful.We're now looking for additional sources to round out our learning — anything that covers the new UI in depth. A few things we'd love pointers to:DevCon / Acumatica Summit sessions or recordings on the new UI Blog posts or article series YouTube channels or playlists Any other official or community-made content you'd recommendPlease let me know if you have something!

Hi, we have a set up of promotions by item class but need setup mixed promotions. Eg. Item Price Class 1 QPD 120ML (24) has 24 products in it. There is a promotion that is Buy 4 get 1 FREE (the products can be any of the 24 in the item price class). Currently Acumatica will only apply the discount if the customer buys Qty 4 of the one item – not mixed.Any thoughts on setting up mixed promotions?

Hi, Is there a configuration that allows revenue to be recognized as sales income at the time of shipment confirmation? Thanks,

Hello, I am trying to customize the screen SP401000 which only appears in the modern portal. I created a typescript and html extension for that screen, and published via the project editor in the main instance. Once I go into the portal of that main instance, those fields don’t show up. Is there a different process for adding custom fields to the portal? When I did ctr+alt in that screen, the view uses the same CRCase database which those custom fields are located in.