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: 2955
AllTopicsReplies
Reply
RE: Summit 2024

@alyness I wish. Acumatica doesn't like putting me in front of audiences anymore. I tend to be too honest ๐Ÿ˜€ I might get to sing my Acumatica Song du...

2 years ago
Forum
Everything Else
Reply
RE: Summit 2024

Yep, I'll be there. I just added a Poll to the top of this page with a few voting option ๐Ÿ˜€

2 years ago
Forum
Everything Else
Reply
RE: Idea -Translation Dictionaries - Improve Functionality in Exporting Data For Translation in the following ways

On #4, in the short term you could probably expose the data using a SQL View.

2 years ago
Forum
Everything Else
Reply
RE: Adding Calculated Columns โ€“ Example #1 Multipart identifier could not be bound

Hmmm, could it be that JAMIS Prime doesn't have that field? That's a pretty standard field though so I'd be surprised if it doesn't have it.

2 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Sandbox

Great question. The license can only be put in one Instance at a time. If your Sandbox is running as a unlicensed Test Instance of Acumatica, th...

2 years ago
Forum
AugSQL
Reply
RE: Project Invoices - Paid-to-Date

Checkout this post:

2 years ago
Forum
Everything Else
Reply
RE: Managing the Scope of Evaluation for Prepare Replenishment, Screen ID : IN508000

@jmck Just sent you the info by email.

2 years ago
Forum
Everything Else
Reply
RE: Managing the Scope of Evaluation for Prepare Replenishment, Screen ID : IN508000

Would you be up for coming on my Acumatica Podcast to talk through this and share more details?

2 years ago
Forum
Everything Else
Reply
RE: Woocommerce integration to Advanced

@ken-akltggmail-com You mean MyOB Advanced in Australia right?

2 years ago
Forum
Everything Else
Reply
RE: Generic Inquiry to Show Where GI's are Used in Dashboards

Great formula @cwomack ! Also note that Acumatica 2023 R2 has a new WIDGETS tab on the Dashboards (SM208600) screen which is kind of the opposite of...

2 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Woocommerce integration to Advanced

@garenmardirossian posted about a WooCommerce integration here:

2 years ago
Forum
Everything Else
Reply
RE: Idea to Vote on -File Maintenance SYNCHRONIZATION tab - Here's the existing idea expanded - Please vote for this idea.

I'd be very interested to see a OneDrive integration.

2 years ago
Forum
Everything Else
Reply
RE: How to move a company to a new tenant

You can move one Tenant over the top of another Tenant, but I don't know of a way to move a Company or Branch into another Tenant.

2 years ago
Forum
Everything Else
Topic
LEFT JOIN vs. INNER JOIN
2 years ago
Forum
AugSQL
Replies: 0
Views: 380
Topic
Joining Tables Together
2 years ago
Forum
AugSQL
Replies: 0
Views: 356
Topic
Your first SELECT statement and always using CompanyID
2 years ago
Forum
AugSQL
Replies: 0
Views: 464
Reply
RE: Welcome and Introductions

@pwills Excel is a great logical foundation. Now you just need to map that knowledge into Generic Inquiries and Report Designer.

2 years ago
Forum
Everything Else
Reply
RE: Welcome and Introductions

@bill-rosado Thanks for joining and thanks for being a sponsor!

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

@pwills Welcome! Checkout my GI Course (click here) if you're struggling with Generic Inquiries.

2 years ago
Forum
Accounting in Acumatica
Reply
RE: What is your role at your company?

@rybanez I'm curious about your setup. How many entities are there? Did you use separate Companies? Or did you go with separate Branches?

2 years ago
Forum
Accounting in Acumatica
Reply
RE: Printing the Username on a Report

@teckla-kapuenene You can join over to the Users table to get this info.

2 years ago
Forum
Acumatica Analytical Report Manager (Financial Report Writer)
Reply
RE: Report Designer Customer Location Parameter

You might want to try the technique that's used on the Sales Order (SO641010) report. It's not using the fields that you want, but you can see the tec...

2 years ago
Forum
Acumatica Report Designer
Reply
RE: New UI in Acumatica 2023 R1 (23.100.0138)

@infosourcing Good question. I'm not sure yet.

2 years ago
Forum
Everything Else
Reply
RE: Import scenario processed via Business failing initially.

So it fails every time, but can be competed manually every time on the Business Event History screen? That seems like it might be a buggy thing with...

2 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Acumatica And Tableau

@joni-girardi might want to chime in on this

2 years ago
Forum
Everything Else
Reply
RE: Import Scenario for Customer Activity (from Ring Central)

Just curious, did you look at Lightspeed Voice (click here)? They take care of the Acumatica integration for you. I believe it even can push the recor...

2 years ago
Forum
Everything Else
Reply
RE: Totals in RD

It seems like maybe you're suppressing the Orders rather than excluding them with Conditions in the report schema. If that's the case, you can still e...

2 years ago
Forum
Acumatica Report Designer
Reply
RE: Print Report without showing Report Viewer

It looks like they added the ability to do this without code in Acumatica 2023 R2. You would add an Automation Schedule on the Print Production Orders...

2 years ago
Forum
Acumatica Report Designer
Reply
RE: Current Survey functionality in Acumatica?

Are you talking about this survey solution that was built during COVID? The GitHub page looks like it was updated last year:

2 years ago
Forum
Everything Else
Reply
RE: task reminders on mobile app

You could create a Business Event with a Mobile SMS Notification subscriber to trigger a mobile app notification.

2 years ago
Forum
Everything Else
Reply
RE: Adding Project Contacts to Report

Try this: As you can see, these top two records... Appear on the CONTACTS tab of the Projects (PM301000) screen:

2 years ago
Forum
Acumatica Report Designer
Reply
RE: Auto Incrementing Number Based on Grouping

I think you'd need to do a SQL View for this. Here's an example:

2 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Good training or videos on how to use MRP in Acumatica

@shennelly knows MRP well

2 years ago
Forum
Everything Else
Reply
RE: Pick List report suddenly not splitting on Shipment

I would compare the .rpx files using something called WinMerge which will highlight the differences between two text files. That might help you spot t...

2 years ago
Forum
Acumatica Report Designer
Reply
RE: Date of the last physical inventory count

@jeffrey-patch You could create a SQL View to expose it. I've done that before for hidden fields (or hidden tables) and it works great.

2 years ago
Forum
Everything Else
Reply
RE: Creating new task from GI

@sam-stoltzfus Ryan used a Customization Project to create a new screen in Acumatica, but he didn't do anything too crazy. He copied and pasted the so...

2 years ago
Forum
Everything Else
Reply
RE: Default Vendor for an Item

@kyle-wright You can get the Preferred Vendor for the Item in the InventoryItemCurySettings.PreferredVendorID field. This is how you join from Inven...

2 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Formula for GI caption

@rpiester You'd have to use Report Designer to generate a dynamic label.

2 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Manage / Reduce Database Size

@jwaldron Since you have Acumatica reading the emails from that email address, it has to store them somewhere. You could probably do a database script...

2 years ago
Forum
Everything Else
Reply
RE: Show week in year for a date

This isn't what you want, but you could do the following if you wanted the Week Ending date (not Week Number) for each Sales Order. You would ne...

2 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Sorting on pivot table

Since Pivot Tables group by each field, it has to apply the sorting one group at a time. In your case, it's first sorting on Vendor, then on Vendor Na...

2 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Adding an empty editable cell to a generic inquiry?

@alec-axelblom I'm not sure what version of Acumatica Visma.net runs on, but User-Defined Fields were introduced in Acumatica 2018 R2. You can acces...

2 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Barcode not showing up on shipment confirmation document when it is sent to mail via automatic notifications (SM205040)

@alec-axelblom Hmmm, not sure why it works, but at least it works. I'm glad that you figured it out!

2 years ago
Forum
Everything Else
Topic
Version 1.1.0
2 years ago
Forum
AugSQL
Replies: 0
Views: 339
Topic
User-Defined Execution Timeout Setting
2 years ago
Forum
AugSQL
Replies: 0
Views: 305
Reply
RE: Using "End Period" is not working

As long as there is data in the period, it will print, unless you use the Visible Formula line in the Column Set to suppress it. You could try somet...

2 years ago
Forum
Acumatica Analytical Report Manager (Financial Report Writer)
Reply
RE: Cannot email notifications when business event triggers

@paul-rapnikas Nice! Thanks for circling back on this.

2 years ago
Forum
Everything Else
Reply
RE: Adding a freight tracking number to a shipment

@ntrauscht You can use FOREACH in the HTML of the Notification to get it to loop through the tracking numbers. Here's an example:

2 years ago
Forum
Everything Else
Reply
RE: Allowing Underscores in the Inventory ID Field

@missionaiden Doesn't look to me like Ship Via Codes are available in the Segmented Keys (CS202000) screen unfortunately. Maybe you could put your c...

2 years ago
Forum
Everything Else
Reply
RE: Purchase Order - Quantity must be greater than 0

@vhaase Did you end up doing a customization?

2 years ago
Forum
Everything Else
Page 3 / 64 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.