Solved

Acumatica is using mysql or sql how to identify in c# code. Or In Acumatica how to get the provider name in C# code to identify the SQL or MySql.

Hi, I have a requirement to see the tax amount for each invoice line. In the invoices and memos form, under the details tab, there is a column for Tax Amount. It does not show any values while the taxes are applicable for the line. My tax calculation rule is exclusive line level.  Does anyone have any idea? Best Regards,Dulanjana

We have a user that has a new last name (recently married). These changes have all been updated in AD. Now in Acumatica, the ‘Last Name’ field is incorrect. In one site I was able to delete the user, then add from AD, and set up the user roles again. This fixed the last name issue.However, in another site, the user is tied to records in the system, so they can not be deleted. How do I update the last name in this case? Thanks

After upgrade to Acumatica 2023R2 filters on forms and GI stopped working for some users. It looks like computer related problem because when admin login to user’s account, all filters work.But some users under admin role experience the same problem. It’s the same for custom and original form/GI.Here is an example 

Hello! Is there a way I can find out who created a user’s profile/account?

Hello all,I have a doubt as to why for some of the scenarios the Modified fields column under the Audit History report is blank as highlighted in the below screenshot. In what scnearios & why are these rows blank?Thanks in advance

I originally posted this issue on Financials but looks like it is more of a technical or development issues as I usually get quick replies on Financials and have been a couple days with a few views and no replies yet. Original post:  Issue: On sales orders, while adding a new line item. New users get a search result while typing the Inventory ID. We don't want it to show a search result, if a search is needed the users can use the search icon on the Inventory field. We want to block search result for displaying while they type in the Inventory ID.  Note: Existing users have this correct. When existing users type in the Inventory ID. No search results are not displayed. Existing users can then use the search Icon if they wish to look up for an Inventory ID. See images for details Existing users entering Inventory ID: Correct display. No search results displayed while typing the inventory ID.   New users entering Inventory ID:Need to fix this for new users so that a search result is not

Hi,I recently make a change in AP preference by select “Require Single Project per Document’. Before the change, I can make payment on multiple invoices across different projects from the same vendor. After the change, it seems like I can only pay invoices of same project each time but can’t select to pay invoices across several projects. Could I ask if that is correct? Thank you.Raymond

I have tried creating a Dashboard widget for Quarterly Revenue without any success. Does anyone have one already built?

Hello Everyone,We recently upgraded to 23 R2, and one of our custom screens is encountering the following issue. Has anyone seen and resolved this issue before? If so, could you please help us with the solution?  

My GI is showing some Credits as negative numbers, but a lot more numbers are not negative, showing as positive. I have included the coding to account for negative numbers but it appears to not be consistent across the inquiry.

Looking to add to the Details column an Attribute that is assigned to the PO Line Inventory ID.  I have a Attribute created for Inventory ID called Revision.  I am trying to get this available to the PO Order Line.  I don’t want a new Custom Filed, because I want to pull in the value of the Attribute at the Inventory ID level. 

Hi,I’m new to Acumatica and I was wondering how I can import line items from an excel file into “Cash Purchases” in Payables, please? Thank you!

Hello,I want to set up a fixed price for a customer so that the price is unchanged according to quantity.In fact, the customer's exact requirement is that, depending on the quantity band, the price is either a fixed price or per unit:- Band 1: <600 ==> fixed price- Band 2: from 601 to 4000 ==> quantity rate- Band 3: over 400 ==> quantitative rateWith the sales price screen, you can manage quantity-based prices for bands 2 and 3 by defining the price per unit, but how can you manage band 1 so that the price is always the same regardless of the quantity entered on the order line?How can we manage this type of case with Flex, please?Thank you in advance

I have a client who pointed out to me that on their customer portal Closed Cases are not displaying the “Last Activity Date” on the “Closed Cases” (SP204010).Is this a known bug with 22.126 version that is fixed in new versions?  Or is this some kind of configuration that is missing?  The screenshot below is of my local test installation of Acumatica with SweetLife and does the exact same behavior that the clients site portal is doing. 

Hi, I am able to successfully create a Sales Order and all of the customer data, line item data etc. is correct except for RequestedOn date. It seems to be auto-assigning to the day before delivery based on the delivery Route assigned to the customer. Even if I put the RequestedOn date weeks in the future, it still assigns to the day before the next delivery route is scheduled. This is what my JSON Request Body looks like:  { "OrderNbr": { "value": "<NEW>" }, "OrderType": { "value": "SO" }, "CustomerID": { "value": "XXXXX" }, "note": "", "CustomerOrder": { "value": "XXXXXX" }, "Details": [ { "InventoryID": { "value": "XXXX" }, "OrderQty": { "value": 1 } }, { "InventoryID": { "value": "XXXX" }, "OrderQty": { "value": 1 } }, { "InventoryID": { "value": "XXXXX" }, "OrderQty": { "

Hi, I have created a new business event in the system, which is set to trigger when the PO receipt line date matches today's date. The event is correctly triggering based on this condition, but it is returning the following error:Index was out of range. Must be non-negative and less than the size of the collection.Parameter name: indexCould someone please help me with this?  I’ve attached business event for your reference. 

I have a generic inquiry that I am using in a dashboard data table widget. The GI in question has an email address in the result grid and I would like to turn the email address string into a mailto link so that when someone click on the email address on the dashboard it will automatically open the email client with the address already to the TO field. Is there a way to embedd html code into a GI to accomplish that? Any help on this would be greatly appreciated.

I need to change a segment ID for my project tasks segemented key from alphanumeric to numeric but there is a task that has already been used in a posted transaction that is preventing the change. What are my options? CS Error: Edit Mask cannot be changed. There are Project Task identifier TINGÉNIERIE       to which the new edit mask cannot be applied

Hi,Does anyone know if there is the possibility to count the # of lines in this screen in the lower toolbar like on GI’s? We are on 22R2 but upgrading to 24R1 shortly.  

I would like to have a generic enquiry that lists out any AP invoices that are still open and have multiple payments applied.  Can someone advise how to get started.  I don’t know which tables I would need and how to join them.ThanksHere is an example of the data I am looking for: 

Good day everyone, Need some help or suggestions. We are on 2024R1 and the BOM ID Number is limited to 15 characters. THe Item inventroy ID came go up to 30 characters. We typiclly use the top level inventory id number to be the same as the BOM. Unfortuntily, we are running into problems.  We have over 60,000 BOM now and we growing. I am hoping for a suggestion before we start looking for an outside solution . Thank you Kim 

Would it be possible to create a project numbering sequence that included a character based on the project type?

Hello everyone, I am attempting to pull the unit cost for Sales Quotes from InventoryItemCurySettings to automate our gross profit calculations.Has anyone had any luck doing so? Thanks,Aleks