How can I turn on File Attachments Drag and Drop functionality on custom Data Entry Documents(Header)?
Hello All,If I am not mistaken, Acumatica introduced “IsInSubselect” & “IsNotInSubselect” with FBQL which is the Equivalent of “IN” and “NOT IN” of SQL. When we use these two functions it is translated to SQL correctly but they have a deadly flaw. This flaw impacts the whole result and when you expect to have thousands of records you get NONE. Look at the two below SQL queries (just logic, do not think what a stupid query). Please note I can NOT use Join//#1SELECT * FROM Vendor WHERE BAccountID NOT IN (SELECT DefPOAddressID FROM BAccount WHERE DefPOAddressID IS NULL)//#2SELECT * FROM Vendor WHERE BAccountID NOT IN (SELECT ISNULL(DefPOAddressID, 0) FROM BAccount WHERE DefPOAddressID IS NULL) Both queries are instructing SQL to return all vendors which do not have DefPOAddressID but the first query returns none while the second one in my case over 2,000 and this is what I expect to get. The only difference is the ISNULL wrapping. Acumatica translates its queries to the first one so I
We are relatively new to Acumatica and we are looking for an easy way for our AR people to see what a customer owes in each of the aging buckets when they call to make a payment. Most of our customers have consolidated accounts - meaning one parent account with a number of children accounts rolling up to the parent. When a customer calls in to make a payment we are not able to easily see what they owe as a function of aging. All we get is a balance amount which includes everything including the invoices that will appear on next months statement. Ideally we would like to be able to go to the customers screen (AR303000) see what they owe in each of the aging buckets then click the Create Payment action which opens the AR302000 screen and have it show the aging amounts for the customer there as well. Right now we have to bounce around between various reports, write down the amount and then go to the payment screen and create the payment. Has anyone heard of or done anything with displayin
I need to create a link on each line item(Inventory Item on a sales order) of the graph on page PO505000 that will pop up a screen showing all of the vendors for that item and the cost from each vendor. Any ideas how to approach this?
I am trying to install a new instance on my local machine of 21R2 and when trying to access the instance immediately after install, I get an “An item with the same key has already been added.” error message.I’ve tried two separate builds (first and latest) and get the same. Some of our other team members are using 21R2, but they all updated from 21R1 to get there. I guess I can go that route if needed, but I would prefer to get a new instance of 21R2. The stack trace follows below. Any insight would be greatly appreciated.Stack Trace: [ArgumentException: An item with the same key has already been added.] System.ThrowHelper.ThrowArgumentException(ExceptionResource resource) +60 System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add) +14338200 System.Linq.Enumerable.ToDictionary(IEnumerable`1 source, Func`2 keySelector, Func`2 elementSelector, IEqualityComparer`1 comparer) +302 Microsoft.Extensions.DependencyInjection.AspNetCoreServiceCollecti
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.