AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • 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)

MichaelHansen
MichaelHansen
@michaelhansen
Forum Home   |   Recent Posts
Estimable Member
Follow
Profile Activity
Topics: 26 / Replies: 123
AllTopicsReplies
Reply
RE: Manage / Reduce Database Size

It's been a moment. Any news on a clean way to kill off emails, files, and audit history? Below is my space usage sorted by table size. Any guidance f...

7 months ago
Forum
Everything Else
Reply
RE: Date of the last physical inventory count

Bind InventoryItem to INPIDetail by InventoryID Bind INPIDetail to INPIHeader by PIID and Site ID (You might not need Site ID) The rows will now h...

2 years ago
Forum
Everything Else
Topic
Mass Update PO Dates
4 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Replies: 1
Views: 1367
Reply
RE: Create shipment for sales order in import scenario

I can import shipments, but how do I access the date field to set the date on the shipment? My system always pulls TODAY for the date and these are sl...

4 years ago
Forum
Everything Else
Reply
RE: Adding Line Breaks

That's ingenious, in fact I won't even need a special character, I can just replace the first word with itself and a line break or do a targeted inser...

4 years ago
Forum
Everything Else
Reply
RE: Shipping attention field override not reflecting on invoice form.

@richard Fair enough my friend, it's almost like our employers want it now or something right? I find it hard to troubleshoot sometimes because of the...

4 years ago
Forum
Acumatica Report Designer
Reply
RE: Can a customer Cross Reference for a parent account feed automatically to child accounts?

I thought this was the default behavior to be honest. Does your customer selector only show the child accounts? If so, you need to create a master cus...

4 years ago
Forum
Everything Else
Reply
RE: Shipping attention field override not reflecting on invoice form.

@richard Absolutely. The Schema Builder is where you should start. Your code is referencing ShippingContact, which is shown as an alias in the schem...

4 years ago
Forum
Acumatica Report Designer
Topic
Compressing Images
5 years ago
Forum
Everything Else
Replies: 1
Views: 872
Reply
RE: Contact Location

I just found out that in my case, they dropped that field entirely and renamed it. No real reason to do so, other than breaking users' reports. I'm no...

5 years ago
Forum
Everything Else
Reply
RE: What is your role at your company?

My title is Analyst, but I'm the system administrator for all IT related adventures. Form an accounting angle, Acumatica is hit and miss. Applying d...

5 years ago
Forum
Accounting in Acumatica
Topic
Contact Location
5 years ago
Forum
Everything Else
Replies: 5
Views: 998
Reply
RE: Adding Line Breaks

Unfortunately, that didn't work out. The company name just has a {br} tag in the name now 😀 FYI: i am in the Companies screen trying to alter our c...

5 years ago
Forum
Everything Else
Reply
RE: Searchable Selector Fields

Nope, but this interests me as well. We use alternative ID's a lot and this would be handy in my sandbox.

5 years ago
Forum
Everything Else
Topic
Adding Line Breaks
5 years ago
Forum
Everything Else
Replies: 4
Views: 3175
Reply
RE: Enable Tools -> Audit History

That is 100% true. I could not find a setting like "delete, revoke, etc", but I instead was forced to use the entire user role itself. I was hoping to...

5 years ago
Forum
Everything Else
Reply
RE: Enable Tools -> Audit History

nvm I found what I was missing. There's a specific role for this and I just overlooked it altogether by jumping right into access rights.

5 years ago
Forum
Everything Else
Topic
Enable Tools -> Audit History
5 years ago
Forum
Everything Else
Replies: 3
Views: 2410
Reply
RE: Excel Export Issues

Sorry, it's the only field in the report header, it's just text. The contents are: "Available to Purchase 4RNPORT/DIRECT. Units are in EACHES", just t...

5 years ago
Forum
Acumatica Report Designer
Topic
Excel Export Issues
5 years ago
Forum
Acumatica Report Designer
Replies: 3
Views: 1970
Reply
RE: Passing Variables from Sub Report not resetting value when no Value in subreport

The Master report has both Subs set to FALSE for visible. That should be set to TRUE, although you do have it visible for Excel, so it'd show if you e...

5 years ago
Forum
Acumatica Report Designer
Reply
RE: Hidden rows still appear

Well I found my error. When you try to hide a group, ensure you also hide the footer of that group. I only placed my visibility expression in the head...

5 years ago
Forum
Acumatica Report Designer
Topic
Hidden rows still appear
5 years ago
Forum
Acumatica Report Designer
Replies: 2
Views: 2336
Reply
RE: Add additional Summary to Sales Report Summary

@gustavo-carrasquillo I would highly advise you to name your groups, it'll make life easier down the road. the name "group2" is harder to analyze than...

5 years ago
Forum
Acumatica Report Designer
Reply
RE: Date Math Issues

If the $Week12 date was December 20th, I'd like $Month3 to be December 31st. If $Week12 was December 31st, I'd like $Month3 to be January 31st. I'm tr...

6 years ago
Forum
Acumatica Report Designer
Topic
Date Math Issues
6 years ago
Forum
Acumatica Report Designer
Replies: 3
Views: 2152
Reply
RE: Adjust Excel Layout

Good to see you're still as helpful as ever @royce-lithgo! That surely does the trick. Straightening out the cells is rough, but infinitely easier tha...

6 years ago
Forum
Acumatica Report Designer
Topic
Adjust Excel Layout
6 years ago
Forum
Acumatica Report Designer
Replies: 3
Views: 3140
Reply
RE: Reports Button Security

@royce-lithgo That is the behavior I am seeing as I have that example running in my system. If two roles are EXPLICITLY defined, the highest appears t...

6 years ago
Forum
Everything Else
Reply
RE: Reports Button Security

I 100% agree and it appears the "most restrictive vs least" isn't applied consistently. For example, my account has almost every single role on it and...

6 years ago
Forum
Everything Else
Reply
RE: Reports Button Security

Well, according to my VARs, inheritance get's overridden by explicit denials, which caused our issue. The users had two roles, the first granted permi...

6 years ago
Forum
Everything Else
Topic
Reports Button Security
6 years ago
Forum
Everything Else
Replies: 6
Views: 2009
Topic
Export Sub-Report values to Excel
6 years ago
Forum
Acumatica Report Designer
Replies: 1
Views: 1810
Reply
RE: Reset Group on a Sub-Report

I was hoping to have the sub-report send a variable, then get re-ran and send over the variable again. However, I just restructured my report/groups a...

6 years ago
Forum
Acumatica Report Designer
Topic
Reset Group on a Sub-Report
6 years ago
Forum
Acumatica Report Designer
Replies: 5
Views: 4168
Reply
RE: Import Scenario for Kit Assembly including Allocations for multiple Stock Components

That sucks, my data dump is blind to the components. I tested it though and it totally works! I'll just make a GI to dump my components and merge them...

6 years ago
Forum
Everything Else
Reply
RE: Import Scenario for Kit Assembly including Allocations for multiple Stock Components

These are new assemblies that do not exist. I am not updating an existing record. The moment I put the inventory ID in my header, I get component line...

6 years ago
Forum
Everything Else
Reply
RE: Import Scenario for Kit Assembly including Allocations for multiple Stock Components

I just tried adding the "From Loc" to line 1, 3, 5, 7, & 9. Same error as before.

6 years ago
Forum
Everything Else
Reply
RE: Import Scenario for Kit Assembly including Allocations for multiple Stock Components

No, our component lines are generated from a kit spec and fill in automatically. I merely need to set the location on the lines so the assembly knows ...

6 years ago
Forum
Everything Else
Reply
RE: Import Scenario for Kit Assembly including Allocations for multiple Stock Components

I've ran this manually a number of times, it's how I build all my IS's. This works perfectly fine in my system (manually). I'm not sure what is amiss ...

6 years ago
Forum
Everything Else
Reply
RE: Import Scenario for Kit Assembly including Allocations for multiple Stock Components

Did you ever get this working @royce-lithgo? I'm hitting a similar wall trying to set the location on my components and my error says "Save Button Dis...

6 years ago
Forum
Everything Else
Reply
RE: Results Grid - Schema Field

I assume Mycustomer is a customer ID in your system correct? For example I have customer ID: ALB-TOLLES and the description is Albertson's Tolleson. S...

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Results Grid - Schema Field

You don't need single quotes around your CustomerID. I'm really not sure why, but I hit that wall before when trying to set it in the conditions tab. ...

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Modern UI

Solution: My users had bookmarked their URLs. Unfortunately the URL for our ERP had changed and it no longer has .aspx in the string. If your users ke...

7 years ago
Forum
Everything Else
Reply
RE: Product sale rate via GI

Ok, I opened the inquiry and here's what I would do: For the count of SOLines, the .99999 is a rounding error. Add Ceiling to round up. This assumes y...

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Product sale rate via GI

I think the issue lies in your joins. You'll get an ItemID times the # of SOLines with the item, which is what you want. BUT you've then added a dupli...

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Modern UI

@royce-lithgo We have two, but no one works in my test environment except my VARs and myself. I can't figure out why it keeps swapping back. Maybe I n...

7 years ago
Forum
Everything Else
Topic
Modern UI
7 years ago
Forum
Everything Else
Replies: 17
Views: 7693
Reply
RE: Add Alternate ID to Invoice - help with Join

For your first question: ARTRan Left (you could use inner) SOShipLine SOShipmentNbr Equal ShipmentNbr (Now we're looking at the right shipment)SOShip...

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

It looks like it might be any "shared" selector. I get the same behavior applying the filter in Stock Items and then looking into Non-Stock Items when...

7 years ago
Forum
Everything Else
Page 1 / 3 Next

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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