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)

Royce Lithgo
Royce Lithgo
@roycelithgo
Forum Home   |   Recent Posts
Honorable Member
Follow
Profile Activity
Topics: 47 / Replies: 510
AllTopicsReplies
Reply
RE: TimRodman.com is now AUGForums.com

And the site is Acumatica blue themed too now i see. Except the title bar.

7 years ago
Forum
Everything Else
Reply
RE: Altering a Column Calcuation Based on a Condition

=IIF((@RowCode>4000 AND @RowCode<4100) OR @RowCode=5100 OR (@RowCode>7000 AND @RowCode<7100) OR @RowCode=7410 OR @RowCode=7410 OR @RowCode...

7 years ago
Forum
Acumatica Analytical Report Manager (Financial Report Writer)
Reply
RE: Multiple Branches = IN Issue

The error message tells you the problem - you are trying to do inter-branch transactions where the feature is not enabled. You would likely need to ...

7 years ago
Forum
Everything Else
Reply
RE: Making AUG Better

Ctrl + F5 resolved the issue and I logged in via Google.

7 years ago
Forum
Everything Else
Reply
RE: Making AUG Better

No, I see this: Clicking the link redirects to a OneAll login page, which I logged in to. But still it didn't solve it. I am using the login page tha...

7 years ago
Forum
Everything Else
Reply
RE: Making AUG Better

Things are much worse now @tim-rodman After logging in I get taken to this page: And now i am seeing this annoying [OneAll] security messages at vari...

7 years ago
Forum
Everything Else
Reply
RE: Shortcut key to collapse (and expand) summary

I am fairly confident there is no shortcut for that. You can try suggesting it:

7 years ago
Forum
Everything Else
Reply
RE: Easy way to convert body of tasks to readable text for GI

Perhaps if you posted a sample to the text you are talking about.

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Making AUG Better

Nope, doesn't work. After login i get dumped back on the forum index page as always.

7 years ago
Forum
Everything Else
Reply
RE: Acumatica Snapshot Export Format

XML - it is human readable and can be compared to prior versions if needed. That being said, I haven't taken a snapshot in ages.

7 years ago
Forum
Everything Else
Reply
RE: How to shows sold QTY in the past half a year ?

So doesn't that suggest that your grouping conditions are wrong?

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: How to shows sold QTY in the past half a year ?

You cannot access InventoryTransHistEnq* tables in GI, they are application tables, not data tables. All I can say is that if you are getting duplicat...

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: How to shows sold QTY in the past half a year ?

Build your query table by table and check the results at each step. Don't group/aggregate anything until you get the correct data. I suspect you have ...

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Separate Companies

Any reason why you didn't set them up as different Tenants seeing as you want the data applicable to the current Tenant only?

7 years ago
Forum
Everything Else
Reply
RE: How to shows sold QTY in the past half a year ?

If you're looking for Inventory movements, try INSiteStatus.

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Change to year-end (change in control)

I agree with Tim. If i were faced with this, I would be doing a new Tenant and converting over existing data. Messing around with the calendars is jus...

7 years ago
Forum
Everything Else
Reply
RE: Make Sales Order Number field compulsory?

Sounds like you haven't implemented the system properly. It should default to <NEW> and when it gets saved, a new number is automatically alloca...

7 years ago
Forum
Everything Else
Reply
RE: Make Sales Order Number field compulsory?

Make it compulsory where? More details needed.

7 years ago
Forum
Everything Else
Reply
RE: Renaming Report Designer Version Descriptions

I've been doing this from day one, so it's been around for ages i would say 🙂

7 years ago
Forum
Acumatica Report Designer
Reply
RE: Renaming Report Designer Version Descriptions

Yes, this is very frustrating. I track my report versions in a separate document as the version descriptions on the Report Versions tab often get trun...

7 years ago
Forum
Acumatica Report Designer
Reply
RE: Procedure to change inventory valuation method from Standard Cost to Specific

Why not create new items and move the stock over?

7 years ago
Forum
Everything Else
Reply
RE: Nested Variables - Report Designer to GI

You cannot say with 100% certainty that all reports can be replicated as GI. The underlying query surely can, but reports have a presentation layer wi...

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Variables - Schema Builder

Save the report to a file and then open it with a text editor. It's an XML file. Just search for the variable you are looking for. Otherwise you have ...

7 years ago
Forum
Acumatica Report Designer
Reply
RE: Defaulting Report Parameter to Specific Date

That's a really great idea Tim. I will do something similar. I wanted to schedule the AR Aged Past Due report on a bi-weekly basis but the report has ...

7 years ago
Forum
Acumatica Report Designer
Reply
RE: Modifying the Customer Statement Report in Acumatica

Voted. You can also go to Customer Statement History, select an existing statement and chose Print Statement action. Of course it requires at least o...

7 years ago
Forum
Acumatica Report Designer
Reply
RE: ArM Company Parameter to display on Report Header

Sorry Ronita, I think your use case is different to ours. We are running single Company (Branch) per Tenant, so what i posted gives the current Tenant...

7 years ago
Forum
Acumatica Analytical Report Manager (Financial Report Writer)
Reply
RE: Welcome and Introductions

Nice to hear from a MYOB employee Carl. There are a few MYOB advanced customers on here, my company being one of them.

7 years ago
Forum
Everything Else
Reply
RE: Acumatica Import Scenario - Prepare Tax Report (TX501000) Screen

Run the imports record by record - Activate 1, Process, Activate 2, Process. The problem is though that Prepare and Release are linked - in the sense...

7 years ago
Forum
Everything Else
Reply
RE: [SOOrder.Status] = 'Open' always returns false

I had the same issue when i first started as you did Kimberly. That was how i luckily stumbled upon this little trick which I use a lot now.

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Convert Last Day of Month from a Financial Period

I find that really hard to believe. The period table needs to have period start and end dates. FinPeriod also has EndDateUI. That is a different field...

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Adding Running Total to Accrual Balance by Trans Date

It's not possible to do running totals in the current version of GI.

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: [SOOrder.Status] = 'Open' always returns false

Here's a little trick to finding the internal values for such fields from GI Conditions. Create a condition on the field you want, tick the From Schem...

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Convert Last Day of Month from a Financial Period

Of course - here's a simple query showing all periods where FinDate is greater than today's date (hard-coded): (partial results shown)

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: AR INVOICE LINE SORT ORDER

Seems a bit weird to sort based on sales orders line numbers in an AR invoice report, but if it's working for you then whatever.

7 years ago
Forum
Everything Else
Reply
RE: ArM Company Parameter to display on Report Header

=Report.GetDefUI('RowCompanyBAccount.AcctName') is what we use

7 years ago
Forum
Acumatica Analytical Report Manager (Financial Report Writer)
Reply
RE: Import Scenario: Fixed Asset

It looks like you are running a custom IS. With no prior knowledge of the IS, it's impossible to say. To debug an IS, you always need to replicate ma...

7 years ago
Forum
Everything Else
Reply
RE: AR INVOICE LINE SORT ORDER

Check whether someone has modified your report. We have the vanilla version of AR641000 and don't have that problem. The default grouping is: That be...

7 years ago
Forum
Everything Else
Reply
RE: AR INVOICE LINE SORT ORDER

When you do Edit Report, what is the name of the file that gets downloaded?

7 years ago
Forum
Everything Else
Reply
RE: AR INVOICE LINE SORT ORDER

I didn't add groupInvoice to the report - it was already there. In fact, I didn't add groupInvoiceLine either - i just changed the field that was ther...

7 years ago
Forum
Everything Else
Reply
RE: Convert Last Day of Month from a Financial Period

I'm confused. Isn't this what you want? FinDate from FinPeriod table is what you want. FinDate i am assuming means Finish Date as there is also a cor...

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Acumatica Report Designer Download

It actually seems strange to me that MYOB built this and Acumatica doesn't have it at all. I will gladly vote for the idea if you link it.

7 years ago
Forum
Acumatica Report Designer
Reply
RE: Vendor Database Management and Revamp (HELP)

You need to download your existing vendor data into a spreadsheet, cleanup the sheet as needed and then import the sheet as new Locations to existing ...

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Making AUG Better

When you go to Recent Posts, open a post and Reply only to discover that you need to Logon. Then you Logon and get dumped back in the AUG top level vi...

7 years ago
Forum
Everything Else
Reply
RE: Apply Updates - Minor Updates

Well here in Australia MYOB applies minor updates without giving us an option! We had one go through last night (18.108.0016.193), no issues at all. ...

7 years ago
Forum
Everything Else
Reply
RE: Applying Filters in OData

How can a date 'contain' a date? How is this any different from eq?

7 years ago
Forum
Acumatica OData with Microsoft Excel and Power BI
Reply
RE: Images and Text Boxes on them

The red X always display for overlapping items. You could try ensuring that the graphic is the lowest in the display order by right-clicking it and ch...

7 years ago
Forum
Acumatica Report Designer
Reply
RE: LEFT JOIN With Additional Filter Value

I'm assuming you tried "=200" for the Child Field?

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Acumatica Report Designer Download

MYOB Advanced users can download it from System -> Customisation -> Tools -> Download MYOB Advanced Tools We can also download the Device Hub...

7 years ago
Forum
Acumatica Report Designer
Reply
RE: Reports Button Security

So lets say on a page field I explicitly made it view only in 1 role and in another role the page inherited Delete access, then the view only access w...

7 years ago
Forum
Everything Else
Reply
RE: Month End Purchase Receipts/Inventory don't match GL

Check that all inventory documents were actually released. We've just recently started having an issue where released distribution documents (eg. Purc...

7 years ago
Forum
Everything Else
Page 6 / 12 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.