By using this website, you agree to our Terms of Use (click here)
I have a colleague who got this same error message, but I wasn't able to reproduce it in my environment. The solution for her had something to do with...
I have a colleague who got this same error message, but I wasn't able to reproduce it in my environment. The solution for her had something to do with...
I like the new little frown face in Acumatica 2019 R1 that you get when you type something into a Lookup (Magnifying Glass) field and no results are r...
Good point Shawn. That would eliminate all three of the "Cs"
It used to be that you could only run companies within the same Acumatica tenant if you had the 3 C's: 1. Chart of Accounts 2. Fiscal Calendar 3. Base...
I really like these two new screens that were introduced in Acumatica 2019 R1. These will make it a lot easier for Accountants to reconcile Accounts P...
There is now a predefined list of Currencies in Acumatica 2019 R1. In Acumatica 2018 R2, if you went to the Currencies (CM2020PL) screen, you had to...
Multiple AR Invoice documents now track the Ship To address. Prior to this, the AR Invoice documents did not track the Ship To address. This wasn't a ...
Attached are the final release notes for the official release of Acumatica 2019 R1. AcumaticaERP2019R1ReleaseNotes.pdf
I just noticed this on GitHub which might be pretty useful for printing multiple product labels:
Hi Siva, Unfortunately I think your only option at the moment is to add your vote to this idea:
I've wondered the same thing, but haven't done it myself yet. You might want to try StackOverflow for this:
Ah, two different parameters: Generic Inquiry parameters (which you're talking about) and Dashboard parameters (which I'm talking about). I'm not awar...
You could use a Parameter instead of the View Fields, but you'd still have the problem of it displaying multiple Alternate IDs.
I think you'll need to use Parameters with defaults values and Filters for this. Take a look at the Sales Order Summary (SO610500) report for a good e...
I also like the idea of Power BI for this. The only thing I can think of within Acumatica would be to use the DateInfo table, specifically the DateInf...
I put together the attached Report Designer report showing a grouping with CInt in the formula. I had to filter out Postal Codes with characters in th...
Hey Matt, Great to meet you at the recent Summit. Not sure on this one myself, but you might want to try posting API questions like this on StackOverf...
Ah, so it seems like we're talking about User Defined Fields (Attributes) and not Custom Fields here. Doesn't surprise me that Generic Inquiry Mass Up...
Dato, Is this related to this Discussion Topic or did you mean to create a new one?
Nice move. I like that feature a lot, just wish that you could also navigate to any URL, not just screens in Acumatica.
Ah, that makes sense, but I never thought about that scenario. Thanks for posting back with your solution.
Have you tried using an Acumatica Pivot Table for the totals?
Me neither. Seems like a bug that needs to get reported to Acumatica.
Was the Grouping the problem? For totals, you can finally add totals in 2019 R1 which is good. That way you could display both the details and the tot...
Thanks so much for sharing this Mark. This is awesome!
Zebra BI is the best solution that I know of, backed by the IBCS methodolody:
I just checked my own 2019 R1 environment. Looks pretty easy to use. Just use the Total Aggregate Function field on the RESULTS GRID tab of the Generi...
Ah, I see. Nice technique. I didn't realize that there was already a table that only has two entries in it. That's perfect. Thanks for sharing!
Nice! I just added my vote.
If the parameters are displaying correctly in the report, then it seems like you set them correctly. This smells like a buggy thing to me. You might w...
I noticed it during the Summit too. Looks like it's now a feature in Acumatica 2019 R1. Here is a screenshot picture that I took during the keynote at...
There isn't a statement concept in Accounts Payable that I'm aware of, but have you compared the AP Aged Past Due and AP Aged Outstanding reports?
I wish the format was always /odata/companyname regardless of whether you have one Tenant or multiple Tenants. It would make this a lot simpler.
I like Excel for this scenario. What you are missing in a Generic Inquiry is the UNION concept from SQL where you can have two completely separate que...
Thanks for sharing this info Royce
So you can update the custom field through the screen, but not through the Mass Update feature on the Generic Inquiry? I haven't used Mass Update much...
Sorry for late reply. Are they using the Projects module? Account Group sounds like a Projects module error to me, but that's usually on the Account, ...
This should be doable. The conversions are stored in the INUnit table so you'd just need to join from InventoryItem over to INUnit to get the conversi...
Wouldn't the custom field have to be a Lookup field like Inventory ID, Vendor ID, etc. for that to work? If you just defined it as a string, what list...
Are you looking for a way to have an audit trail every time the budget changes?
Thanks for posting the solution Royce, even though it was disappointing.
How come you can't just use the browser print collate option? Also, what's the APAROrd technique? Sounds interesting.
I've done something like this before using Microsoft Flow because I couldn't figure out how to feed a folder of files to an Import Scenario. It was fo...
I don't. Any reason why you wouldn't use Analytical Report Manager for this?
Holy cow, thanks for putting this together Daniel. It would also be nice if we could just specify the hex color code like #ec1c1c, but I don't think i...
