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

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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