By using this website, you agree to our Terms of Use (click here)
Looks like the separate standalone installer for Report Designer is planned to be reintroduced in Acumatica 2019 R2:
Here are details on how to do User Security with a Customization Project:
You can definitely do formulas. If you could mockup a simplified version of what you're trying to do in Excel, with Excel formulas that accomplish wha...
I haven't done it, but I would probably start with a Generic Inquiry just because Report Designer is a lot more time-consuming to work with. You could...
Not sure if this helps, but I put together this report a few years ago. The first one is the report, but you need the 2nd and 3rd reports since they a...
I agree with Shawn, to do all this in Acumatica, you'll need a SQL View. Or, as Royce pointed out, you could use Power BI. You could even just do it i...
The Valuation Method field on the GENERAL SETTINGS tab of the Stock Items (IN202500) screen has to be set to Average: Then the Average Cost field o...
So a Shipment, for example, will create the Inventory Issue document in a Balanced status and it won't get Released automatically? And the Automatical...
Glad you figured it out Taylan. And thanks for reporting back with your solution.
Personally, I'm not too concerned with Pre Release here because it looks to me like it functions like a macro and just copies data into the graphical ...
I use the Android Mobile app, but I don't use it a ton. What do you mean by locking up? Does it freeze? Does it crash? Does it spin infinitely?
I'm still not sure why it's needed other than recalculating Qty. Available when you change the settings in Availability Calculation Rules (IN201500) s...
I think you can add them manually to the GL Account Access (GL104000) screen. Trying this for Group Type A since Group Type A Inverse, B, and B Invers...
I think you have to build this into the Company Tree (EP204061) screen. Can you create a separate top-level folder for the Expense Approver tree?
Hey Matt, What about something like this on the Generic Inquiry (SM208000) screen?
What about using OneDrive or Dropbox so you can get a regular HTTP path? Or do something like this:
Very cool Bobby. Thanks for sharing the code that you used!
Thank you for sharing your solution Armando. It's people like you who have caused me to learn a lot from this forum too.
Wow, this is AWESOME! Thank you so much for sharing this.
I have noticed the same thing as you pointed out. "Explicit" access trumps "Inherited" access. Otherwise, higher level access wins. It's especially an...
I forgot about this approach that I tried a while back. It might help you:
Very cool. You are the Attribute master Harsha! I remember that Sales Order screen you showed me back at Acumatica Summit 2016 in Orlando. I doubt the...
The ORDERS tab of the Opportunities (CR304000) screen makes it seem that there can be multiple Sales Orders for an Opportunity so I don't think it can...
Hey Shawn, Big congrats on being appointed to ITA President (click for news)! I'm not sure why the + and x icons are there. The Default Salesperson fi...
That's a bummer 🙁
Note that Velixo Reports and Solver BI360 provide more advanced budgeting capabilities if you find that Acumatica is too limited.
Hi Joseph, Can you attach the exported Generic Inquiry XML file? Or at least some screenshots of it?
Interesting, I hadn't thought about Kit impact on Replenishment before. Glad you pointed that out!
I haven't been able to get it to work in the Mobile app. I don't think it's there yet.
Thanks for sharing Carl
Thanks Carl. I haven't done much with the module yet myself, but I'll try to think of something to contribute too.
And you want the PDF to print when say a certain report is printed? Or maybe all PDFs to print for all the Items listed on a report?
Very cool that you were able to get it working Brandon.
What about setting the Report Parameter defaults in the Report Designer report definition itself?
That's interesting. Pretty much every Lookup that I've seen has a filter icon where you can set filters, including default filters. But the Inventory ...
I'd love to see a screenshot of the out-of-balance journal entry. I've never seen one in Acumatica before. I agree, this is a critical error.
I can't remember what version this was introduced in, but this ACTIONS -> Change to Test Tenant option should allow you to turn what is now called ...
That's a good way of putting it 🙂
Are you applying your filter to the INLocationStatus.SiteID field?
Which Invoice form are you looking at? Each Invoice has one Invoice Date so do you mean that you are printing a batch of Invoices and want them sorted...
The Data -> Sorting field on the Report Properties only sorts the Detail Section which is empty for this report unfortunately. Pretty much everythi...
Do you have anything setup in the Company Tree (EP204061) screen? That screen should restrict who an Employee can see.
