Everything Else

Hi, I have a one dashboard in Acumatica 2024 R1 and need to display the value of a calculated Gross Profit field as a percentage. Currently, the calculated field shows as sum of Gross Profit % column in the widget. For example, in my Generic Inquiry I created a calculated Gross Profit % field using a formula like: =(IIf(Sum([ARTran.CuryExtPrice]) = 0, 0, (Sum([ARTran.CuryExtPrice])-([AMProdTotal.ActualLabor]+[AMProdTotal.ActualMaterial]+[AMProdTotal.WIPAdjustment])) / Sum([ARTran.CuryExtPrice])))*100 This displays correctly as a number in GI, but when I add it to the dashboard (KPI or Chart widget), it doesn’t show as a percentage. Can you please advise the best way to calculated Gross Profit % field so that it displays as a percentage based on formula on the dashboard?  

I wish there was a way to view API requests or logs from the UI…  The platform is so robust when it comes to API’s and the only thing we can see is from events to the database. This would help a lot when it comes to troubleshooting and implementation!

Does anyone know where this perm lies? I need to activate it so a user can edit a customer contact. I have searched in Sales Order, Receivables and Hidden but have yet to find the correct perm.

When raising a change request, My CR is picking the costs correctly from the supplier price worksheet. However when a change request is converted to the Change order, for the items which are  already a part of the Cost budget tab reflect correct costs/Unit rate on the Change orders.For the item which are missing and are newly added from the Change request to change order, are added to the cost budget tab but with a zero costs. I have done some reading here based on the below and it shows it will select an avg cost for this. Currently as it stands it seems for project based inventory enable/disable setting the avg cost doesn't exists as project based inventory is the only way our client deals. The issue with this when they are marked from Purchase order from Cost budget tab lot of the items are zero costs. This is causing a lot of issues. Is there any way or a workaround where the costs doesn't need to be put manually on cost budget and are reflected from the change requests to change o

Anyone who encounters the same issue? I have tried resetting the cache and restarting the application through Apply Updates page but still the issue occurs. I have also tried restarting the whole server but still the issue occurs. I encounter this one when I attempted to publish the updated customization. I tried to publish my customization package to another instance and server it push through. 

I encourage my team to add a product idea whenever we find something that could be improved in Acumatica.It would be useful  to see what my Ideas team have raised and to see the progress.ThanksJames 

Dear Team,I noticed that in Acumatica 23R1, I could create inventory transfers with a quantity of 0, but in 25R1, the system shows an error and prevents this. Is there any release note or setting I might have missed causing this change?23R1:25R1: I would appreciate your guidance on resolving this.

We are looking for a way to track how many phone calls our customer service team receives each day. We aren’t necessarily always looking to track the details of the phone call or who the phone call came from, but just how many phone calls received during the day.Right now our company is using a google sheet and phone operators are keeping track via sticky notes on their desk.

Hi all, we are interested in creating a data provider that would point to an Azure SQL database living in Microsoft Fabric. The challenge here is that Fabric supports Entra ID users, service principals, and groups only. SQL or Windows authentication aren’t supported.It doesn't appear that the built in SQL data provider driver, as of 25R1, supports Entra ID authentication.  We've come up with a couple of ideas but would be very interested to hear if anyone has been able to establish this kind of integration successfully.Our thoughts:Find a middleware driver that would support Entra ID authentication through Acumatica.  Potentially CDATA? Access fabric data through a linked server query to a SQL Managed Instance in Azure Replicate the fabric data to a regular Azure SQL DatabaseThoughts welcome.  Thank you!

Can someone tell me how Acumatica is calculating the Qty on Demand and Qty on Supply within the Prepare Replenishment screen?  For some of my products, I can easily see that the Qty on Supply is pulling open Purchase Orders and Kit Assemblies but there seems to be something else pulling in that I’m missing.  I cannot figure out at all what the Qty on Demand is pulling in.

Hi all, Does anyone know if there’s a way to pick Sales Order lines without having to create a shipment first?Right now, the only way we can pick is once a shipment’s been created, and we run everything through our WMS. The standard pick/pack/ship process doesn’t really suit our setup, and I’m wondering if there’s a better way to pre-pick stock into a designated area ahead of time?We’ve thought about just transferring the available stock into that area manually, then once the shipment’s created, reviewing the lines and updating them to the right location — but honestly, I’m hoping there’s a smoother, more efficient (ideally system-driven) method out there.Anyone come across a workaround or setup for this?

Good day, we updated our item weights from pounds to KG and volume to CBM,  Currently our open PO count about 800.  I would like to a suggestion on how we can update all of them at once without have to open each one, recalculate and then close.  Anyone ideas.  Right the PO if not recalculated after open has the weight and volume from when it was created.   Thank you.Evan

Hello,Hoping this is an easy one, I am trying to set/change the “From” to something other than Default on templates.  When I hit the magnifying glass, the only option is Default.  Is there something I need to change to allow the selection of another email account?  I have created email accounts for all users as well and still only get Default as an option.  

HiIs there a way to change the login page of an Acumatica system please? I did navigate to Customization Project , created a project and then went to Customization Project Editor and selected Files, however I do not have the option to upload my own image onto the system and I think it is because the system isn't locally stored on my machine. How do I go about this?

Just upgraded to 24r2.  We are on prem. And have 11 tenants.Looking at switching our payment processor to Acumatica Payments and would love feedback from others currently using it as far as pros and cons.Have some questions regarding Acumatica Payments features. Can a customer set up a credit card for Auto Pay on the customer portal? Do new credit card set up or changes made to existing credit cards by the customer on the customer portal get imported back into Acumatica on the customer screen? Can we brand the payment and customer portal screens with company logos? Can we customize the customer portal to include new columns populated from Acumatica tables like the invoice or customer tables?  Are there features not available while we are on 24r2 that will be available once we upgrade to 25r1 or 25r2?Thanks for the help!Mike Jacob 

Hi Community,In the Tenant’s screen, there is a button to “Change to Test Tenant”. Is there a way to undo this as now both tenants say the status a Test Tenant, and I need to make one of them a Production tenant. Thanks

When installing my demo instance, redirecting to the website didn’t show the default password already set-up. No I am not sure how to log in. Help with this please.

For the past few months my company has been working on trying to implement the Acumatica Customer Portal to allow our customers to view and pay their statements and Invoices. From what I have seen though, there are a couple of issues. I figured I would share them here to see if anybody has experienced these issues and if they have found solutions. Reloading reports results in errors: This is the biggest issue I have run into. When a customer views their statement or Invoice, if the URL is reloaded in any way, they will be brought to an error screen stating that they do not have the rights to view that screen.  Even if I set them as an administrator they will get this error.  I fear this can come off as extremely unprofessional to our customers. Has anybody else experienced this and/or come up with a solution? (See the image below for the error I am confronted with) Inability to pay Overdue Charges or Apply Credit Memos:  It looks like customers who have Overdue Charges to pay aren’t ab

There is no option to login via SSO for Outlook plugin. It just have an option to enter local credentials. While searching online, this issue was almost from beginning. Is Acumatica not looking to improve this feature from several years? Why ? Also, Looks like, It doesn’t support new Outlook mode (Currently, Microsoft has replaced legacy Outlook) as the login window gets disappeared after entering credentials. Has anyone faced such issue? 

 My reason for asking is we have different size attributes depending on size run. For example SIZESSXL is for Small through X-Large, SIZESS2XL has Small through 2X-Large and so on. If I want to add 2X-Large to a shirt with SIZESSXL, we would change it to SIZESS2XL and create the extra matrix item. This leaves the existing items pointing to the previous size attribute which causes problems all over the place.Is there is a way to point it to the new size attribute?

I’ve been trying to set up some custom wikis for my team, however, once I leave the wiki and return, or anyone else tries to open the page, the custom wiki doesn’t load and says “Not Found.” I’m the administrator, so I should have access to this, but even I can’t get into it anymore. Any idea of how to fix this? Here’s the wiki details: 

I have a snapshot that I am trying to delete. The Processing popup has been up for over an hour…..How long should this process take?

We’re in the process of setting up our Fixed Assets in Acumatica. When we dispose of an asset, Acumatica posts a debit to our depreciation expense equal to all of the depreciation posted in the current fiscal year and calculates the gain as Proceeds less NBV at the start of the Fiscal year. We’ve set our depreciation method to New Zealand Diminishing Value Evenly by Periods. I wasn’t able to find anything in the literature for that method that would indicate a full reversal of current year depreciation on disposal.I’ve also tested the following scenarios without any change in results:  Page Field Value Scenario 1 FA Preferences Depreciate in Disposal Period FALSE   Dispose Assets Before Disposal Depreciate Scenario 2 FA Preferences Depreciate in Disposal Period FALSE   Dispose Assets Before Disposal Suspend Scenario 3 FA Preferences Depreciate in Disposal Period TRUE   Dispose Assets Before Disposal Depreciate Scenario 4 FA Preferences

We need your input on this matter. The company has started using the Intercompany process, which is functioning well. However, we are encountering an issue when the sales order is generated from the other company. Here's a sample scenario:Create a Sales Order in ‘Company A’ for ‘Customer X’  - In this scenario Items are not available to ‘Company A’ so a PO will be created to order the items to Company BCreate the Purchase Order from the Sales Order in Company A. In the Vendor select Company B. Purchase Order was generated from Company A to purchase the item to Company B. From here It’s still looks fine.Then next step is to generate the Sales Order to Company B from Company A. (PO Screen > … > Intercompany > Generate Sales Order ). Sales Order is generated then switch companies to Company B.Here is the issue: instead of defaulting to Warehouse 20 for Company B, the sales order is still defaulting to Warehouse 30 for Company A.I've already checked the community, and it was menti

We are currently implementing an integration between ServiceTitan and our ERP system, Acumatica, and would like to streamline our Accounts Payable and job‑costing processes entirely within Acumatica.ServiceTitan recommends processing bills in their system first and exporting them to the ERP. However, our goal is to maintain all AP workflow—including bill entry and cost coding—directly in Acumatica, then sync to ServiceTitan for project tracking.Has anyone successfully implemented ServiceTitan → Acumatica integration, while routing AP entries exclusively through Acumatica?