AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Tim Rodman
Tim Rodman
@timrodman
Forum Home   |   Recent Posts
Admin
Famed Member
Follow
Profile Activity
Topics: 244 / Replies: 2960
AllTopicsReplies
Reply
RE: "Server returned an error you have insufficient rights to access the object (FS642000)" - For an specific role not the administrator

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...

7 years ago
Forum
Everything Else
Reply
RE: Online Version working but getting error on Mobile Environment

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...

7 years ago
Forum
Everything Else
Reply
RE: Acumatica 2019 R1 New Features

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...

7 years ago
Forum
Everything Else
Reply
RE: Acumatica 2019 R1 New Features

Good point Shawn. That would eliminate all three of the "Cs"

7 years ago
Forum
Everything Else
Reply
RE: Acumatica 2019 R1 New Features

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...

7 years ago
Forum
Everything Else
Reply
RE: Acumatica 2019 R1 New Features

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...

7 years ago
Forum
Everything Else
Reply
RE: Acumatica 2019 R1 New Features

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...

7 years ago
Forum
Everything Else
Reply
RE: Acumatica 2019 R1 New Features

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 ...

7 years ago
Forum
Everything Else
Reply
RE: Acumatica 2019 R1 New Features

Attached are the final release notes for the official release of Acumatica 2019 R1. AcumaticaERP2019R1ReleaseNotes.pdf

7 years ago
Forum
Everything Else
Reply
RE: Printing Product Labels from Purchase Receipt

I just noticed this on GitHub which might be pretty useful for printing multiple product labels:

7 years ago
Forum
Acumatica Report Designer
Topic
Extend to Customer or Extend to Vendor
7 years ago
Forum
Everything Else
Replies: 3
Views: 4817
Reply
RE: IMAGE IS NOT APPEARING AFTER EXPORT TO EXCEL

Hi Siva, Unfortunately I think your only option at the moment is to add your vote to this idea:

7 years ago
Forum
Acumatica Report Designer
Reply
RE: Customisation for new Lookup field

I've wondered the same thing, but haven't done it myself yet. You might want to try StackOverflow for this:

7 years ago
Forum
Everything Else
Reply
RE: Parameters on Dashboards

Ah, two different parameters: Generic Inquiry parameters (which you're talking about) and Dashboard parameters (which I'm talking about). I'm not awar...

7 years ago
Forum
Acumatica Dashboards
Reply
RE: Alternate ID Issue

You could use a Parameter instead of the View Fields, but you'd still have the problem of it displaying multiple Alternate IDs.

7 years ago
Forum
Acumatica Report Designer
Reply
RE: How to schedule a report for last week or last month.

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...

7 years ago
Forum
Everything Else
Reply
RE: Using Weekly Instead of Daily, Monthly, or Yearly

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...

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Applying the Cint() function to a varchar in its grouping collection

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...

7 years ago
Forum
Acumatica Report Designer
Reply
RE: Deleting Details with Postman

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...

7 years ago
Forum
Everything Else
Reply
RE: Mass Update Sales Order Status

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...

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Easily Creating an Acumatica Generic Inquiry from an Acumatica Screen

Dato, Is this related to this Discussion Topic or did you mean to create a new one?

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Adding a Drill Down Function

Nice move. I like that feature a lot, just wish that you could also navigate to any URL, not just screens in Acumatica.

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Upgraded to R18.206, UI issues with Menu Items

Ah, that makes sense, but I never thought about that scenario. Thanks for posting back with your solution.

7 years ago
Forum
Everything Else
Reply
RE: GI to show percentage of Out Of Stock

Have you tried using an Acumatica Pivot Table for the totals?

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Generic Inquiry Screenid changes to ScreenId=00000000

Me neither. Seems like a bug that needs to get reported to Acumatica.

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Adding a Drill Down Function

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...

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Topic
Tips for working with OData in Acumatica
7 years ago
Forum
Acumatica OData with Microsoft Excel and Power BI
Replies: 0
Views: 2973
Reply
RE: Acumatica Processing Payments

Thanks so much for sharing this Mark. This is awesome!

7 years ago
Forum
Acumatica Report Designer
Reply
RE: Profit and Loss and/or Balance Sheet in Power BI

Zebra BI is the best solution that I know of, backed by the IBCS methodolody:

7 years ago
Forum
Everything Else
Reply
RE: Add total to a GI

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...

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: CHeck printing - 2 copies of every check

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!

7 years ago
Forum
Everything Else
Reply
RE: ARM Reports - Colors

Nice! I just added my vote.

7 years ago
Forum
Acumatica Analytical Report Manager (Financial Report Writer)
Reply
RE: Monthly Scheduled report

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...

7 years ago
Forum
Acumatica Report Designer
Reply
RE: Add total to a GI

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...

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: AP aging by document date [NOT due date]

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?

7 years ago
Forum
Everything Else
Reply
RE: Generic Inquiry Screenid changes to ScreenId=00000000

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.

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Generic Inquiry Projects and Sales Orders

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...

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Understanding Consolidations

Thanks for sharing this info Royce

7 years ago
Forum
Everything Else
Reply
RE: Mass Update Sales Order Status

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...

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Acumatica Subaccount Setting

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, ...

7 years ago
Forum
Everything Else
Reply
RE: Multiple unit of measure in Inventory Valuation Report

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...

7 years ago
Forum
Everything Else
Reply
RE: Get Field Schema for Custom Field in parameters

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...

7 years ago
Forum
Acumatica Report Designer
Topic
Easily Creating an Acumatica Generic Inquiry from an Acumatica Screen
7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Replies: 7
Views: 3989
Reply
RE: Projects Module

Are you looking for a way to have an audit trail every time the budget changes?

7 years ago
Forum
Everything Else
Reply
RE: Consolidation "Restriction on Financial Periods"

Thanks for posting the solution Royce, even though it was disappointing.

7 years ago
Forum
Everything Else
Reply
RE: CHeck printing - 2 copies of every check

How come you can't just use the browser print collate option? Also, what's the APAROrd technique? Sounds interesting.

7 years ago
Forum
Everything Else
Reply
RE: Import historical documents as attachments

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...

7 years ago
Forum
Everything Else
Reply
RE: Profit & Loss Statement

I don't. Any reason why you wouldn't use Analytical Report Manager for this?

7 years ago
Forum
Acumatica Report Designer
Topic
XML (Old) vs. MSDL (New)
7 years ago
Forum
Everything Else
Replies: 2
Views: 3169
Reply
RE: ARM Reports - Colors

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...

7 years ago
Forum
Acumatica Analytical Report Manager (Financial Report Writer)
Page 38 / 65 Prev Next

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2026 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.