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: Setting up User Security

That might have worked.... had i not already configured it by hand! But anyway, it wasn't a complete waste of time as I did find a few small inconsist...

7 years ago
Forum
Everything Else
Reply
RE: Modern UI

I suppose Modern UI doesn't support a Dashboard as a home page and so they default to classic. I am just glad to have found a solution to the issue th...

7 years ago
Forum
Everything Else
Reply
RE: Delete using Export scenario when 'Action: Delete' is not available

Wow this is great news. I don't remember seeing <Line Number> = -2 to delete a row documented anywhere.

7 years ago
Forum
Everything Else
Reply
RE: Modern UI

Actually you have to assign the Home Page on the User record, and save it. Then the Use Classic UI by default gets ticked. Then you can remove the Hom...

7 years ago
Forum
Everything Else
Reply
RE: Generic Inquiry - Sorting if files are attached

If you're looking to join to PX.SM.UploadFileWithIDSelector, I think you should be using FileID and not NoteID. NoteID should be for attaching Notes t...

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Understanding The Calculation Behind a Field

Search for "source" and it should match Source Code. On Find in Files tab, search for NetSalesAmount - first match is the DAC, expand the #region NetS...

7 years ago
Forum
Everything Else
Reply
RE: Publish to Multiple Companies

In the end i didn't bother doing it. The only customisation that wasn't in the new Tenant were 2 site map entries which I added manually. Database Cha...

7 years ago
Forum
Everything Else
Reply
RE: Understanding The Calculation Behind a Field

[PXDBCalced(typeof(Mult<Switch<Case<Where<ARTran.drCr, Equal<DrCr.debit>>, Minus<decimal1>>, decimal1>, Sub<Sub<...

7 years ago
Forum
Everything Else
Reply
RE: PO Receipt - Last Vendor Price

You need to check AP Preferences for when Last Price is updated. Price and Cost are very different things. 🙂

7 years ago
Forum
Everything Else
Topic
Notes on Import Scenarios should be separate from Data Provider
7 years ago
Forum
Everything Else
Replies: 0
Views: 2016
Reply
RE: Modern UI

Hey Tim, didn't you see this from my post above? You can get classic UI back for new Tenants by assigning a user Home Page and then removing it. As so...

7 years ago
Forum
Everything Else
Reply
RE: Setting up User Security

Manual copying by hand. Dual monitors comparing source to target Tenant. Using Access Rights by Role report as a guide of the nodes to check and then ...

7 years ago
Forum
Everything Else
Reply
RE: Setting a Field to Empty or Null

Couldn't you add a Terms column to your data provider and assign that value in the Import Scenario and if that value is blank, it would be assigned nu...

7 years ago
Forum
Everything Else
Reply
RE: Filters on AP Bills And Adjustments and Cheques And Payments are shared.... but why???

I got the same response from our MYOB partner. I can't see the logic in Acumatica's stance on this. They are different tables with different numbering...

7 years ago
Forum
Everything Else
Topic
Publish to Multiple Companies
7 years ago
Forum
Everything Else
Replies: 11
Views: 8692
Reply
RE: Modern UI

And on the Modern UI Topic, I found that for new Tenants, modern UI is defaulted on and can only be switched off by Partners (we're on MYOB Advanced)....

7 years ago
Forum
Everything Else
Reply
RE: Modern UI

Bookmarks should be base domain only. You shouldn't need anything after acumatica.com.

7 years ago
Forum
Everything Else
Reply
RE: Delete using Export scenario when 'Action: Delete' is not available

I wonder whether Delete action is directly tied to Access Rights on the object? So if a user gets Edit or Insert access, Delete action is disabled. If...

7 years ago
Forum
Everything Else
Reply
RE: Setting up User Security

Ellie, the Copy Role button prompts for a new role name. It cannot be used to copy roles between Tenants. There is also no Clipboard copy button on th...

7 years ago
Forum
Everything Else
Reply
RE: Delete using Export scenario when 'Action: Delete' is not available

You're right. It doesn't allow you to call delete actions. Now I see the problem 🙂 How about publishing a DB script to delete the data via SQL? Of co...

7 years ago
Forum
Everything Else
Reply
RE: Delete using Export scenario when 'Action: Delete' is not available

If i had this problem, I would start with working out how to create an import scenario that could update those rows that you want to delete. This is c...

7 years ago
Forum
Everything Else
Reply
RE: Setting up User Security

So in the end I did set up role based security but the roles were limited to specific areas of the system. I then granted each user one or more roles ...

7 years ago
Forum
Everything Else
Reply
RE: Modern UI

I don't like the Modern UI at all. It takes a lot longer to navigate than it did with Classic. I can get around the system much faster with the Classi...

7 years ago
Forum
Everything Else
Reply
RE: Import Scenario to add allocations to a Purchase Receipt

The error means the item is Lot/Serial tracked "When Received" and you need to provide a Lot/Serial number for the PO Receipt Line. This can be done d...

7 years ago
Forum
Everything Else
Reply
RE: Modern UI

Well it's a user preference setting and it's per Tenant (Company), so if you have multiple Tenants, they would need to make the setting change in each...

7 years ago
Forum
Everything Else
Reply
RE: Filters on AP Bills And Adjustments and Cheques And Payments are shared.... but why???

Actually stock items and non-stock items makes perfect sense as they have common numbering sequences. Bills and adjustments, Chequers and payments do ...

7 years ago
Forum
Everything Else
Reply
RE: Generic Inquiry - Use subqueries for a field

No, GIs cannot do SQL subqueries. There are many things they can't do. For example, grouping on expressions, filtering on aggregated data. I really ho...

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Filters on AP Bills And Adjustments and Cheques And Payments are shared.... but why???

Thank you so much Tim for this!! I hit a brick wall trying to get our MYOB Advanced Partner that this was definitely not a feature. Lets hope Acumatic...

7 years ago
Forum
Everything Else
Reply
RE: Filters on AP Bills And Adjustments and Cheques And Payments are shared.... but why???

Hi Tim, Filter on the Reference Nbr, as in your second screenshot.

7 years ago
Forum
Everything Else
Reply
RE: Appearance of Notes and Attachment action icons in query results

Your query works for me too. But I have other queries that use INRegister and don't show the notes or attachment columns. I think I know why, when yo...

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Formulas on Generic Inquiry

Mandy, What exactly appears to be the issue? On the results tab, add a new row, select an appropriate Object, use the formula editor on the Data Field...

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Group by Location Description

Try joining INLocation and then grouping on Descr.

7 years ago
Forum
Acumatica Report Designer
Reply
RE: Discounts - Generic Inquiry

Try using Left instead of Inner - then review the results and where there are nulls instead of values (and you expect a value), look at the join to se...

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: New Sales Quotes Screen in Acumatica 2018 R2

Tim, you can view the License access via Configuration -> User Security -> Access Rights by License Type. In our system only "Full User" and "Sa...

7 years ago
Forum
Everything Else
Topic
Filters on AP Bills And Adjustments and Cheques And Payments are shared.... but why???
7 years ago
Forum
Everything Else
Replies: 21
Views: 11686
Reply
RE: Appearance of Notes and Attachment action icons in query results

My query is based off INRegister and it is the first table in the results grid but notes are not showing for it. Issues, Receipts etc. are all saved i...

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Budget Import Scenario

If you can do it manually but the Import Scenario cannot do it that means something is wrong with your Import Scenario or the order of processing in y...

8 years ago
Forum
Everything Else
Reply
RE: Budget Import Scenario

Without knowing anything about importing budgets, the best way to debug an Import Scenario that's failing is to replicate what the scenario would do m...

8 years ago
Forum
Everything Else
Topic
Appearance of Notes and Attachment action icons in query results
8 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Replies: 10
Views: 5582
Reply
RE: PO Approval - notifying users on Approved or Rejected

Notifications are flawed - they will get triggered multiple times (if no Fields parameters are specified). So for example, if your criteria is "Approv...

8 years ago
Forum
Everything Else
Reply
RE: Date Condition

Simple - import restrictions on import scenarios don't support formulas. That's why there's no formula editor on any of the fields. You could try @Tod...

8 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: What did I break?

I would try the usual system stuff, starting with sfc /scannow (from admin command prompt) - if you don't have admin rights, then get your IT people i...

8 years ago
Forum
Acumatica Report Designer
Reply
RE: What did I break?

Works fine for me: Could be a font issue specific to your PC. Perhaps a font that ReportDesigner needs is missing and it is resorting to what it thin...

8 years ago
Forum
Acumatica Report Designer
Reply
RE: Giving access to Vendors without financial information

Really weird. This is not the first time i've found things on pages which can't be restricted via Security.

8 years ago
Forum
Everything Else
Topic
Multistage sequential approval maps with Customer criteria on the first stage
8 years ago
Forum
Everything Else
Replies: 1
Views: 1745
Topic
Calculating monthly average Quantity for an inventory item
8 years ago
Forum
Everything Else
Replies: 1
Views: 2798
Topic
Giving access to Vendors without financial information
8 years ago
Forum
Everything Else
Replies: 2
Views: 1888
Reply
RE: schema diagram

If you didn't have access to the database what would you do?

8 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Default View settings for all users

This looks promising - I can see the feature in our 2018.1 upgrade sandbox. But since it has the ability to override the default for all users, is it ...

8 years ago
Forum
Everything Else
Reply
RE: Formula for GI caption

+1 from me. I remember wanting to do that in the past and was kinda surprised that Captions were static text only.

8 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Page 10 / 12 Prev Next

Online Members

  • Brent Brashars
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.