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)

Jeffrey Patch
Jeffrey Patch
@jeffrey-patch
Forum Home   |   Recent Posts
Trusted Member
Follow
Profile Activity
Topics: 6 / Replies: 32
AllTopicsReplies
Reply
RE: Business Events type "Trigger by Record change" failure to launch

Well here we are 2025 and at least in 2024 R1 release, not much has changed. Business Events still perplex me. I have written probably well over 100...

10 months ago
Forum
Everything Else
Reply
RE: Import scenario to renumber chart of accounts

For those who do not want to use the Description, you can use the AccountID (internal number, not the AccoundCD).

1 year ago
Forum
Everything Else
Reply
RE: Delete or mark complete tasks in bulk

Tried using an import scenario to Delete Tasks. So far no luck. I have done similar for Emails. But cannot do same for Tasks. Tim's recommendatio...

3 years ago
Forum
Everything Else
Reply
RE: Date of the last physical inventory count

In reviewing the DAC Schema Browser, I found the file (LastPICountDate), but it is flagged as hidden. Pity.

3 years ago
Forum
Everything Else
Reply
RE: Static notes for customer transferring to sales order

Hi Travis An alternative to the above is to use Pop Up Notes and Business Events. Neither of these approaches require programming. We have co...

3 years ago
Forum
Acumatica Dashboards
Reply
RE: How to print from a generic inquiry

This is a good question. Suggest you log an enhancement request. My expectation which is fulfilled in other ERP systems is that printing the results...

3 years ago
Forum
Everything Else
Reply
RE: Accounting Journals that show specific debits/credits

Hello TravisAs Patrick mentioned, you can easily create a solution in the form of a Generic Inquiry or dashboard that satisfies the user requirement. ...

3 years ago
Forum
Accounting in Acumatica
Reply
RE: Recover Deleted Stock Items?

normally the approach you took works. Although I did need to add at least a description to the item.

3 years ago
Forum
Everything Else
Reply
RE: Vote on an Idea - disable the export to excel functionality for user role

You can already do this, but only at the screen level not at the overall role. So good idea.

3 years ago
Forum
Everything Else
Reply
RE: Restrict purchases to Default Vendor

Your assessment is correct. This is an useful feature that applies to Purchasing and Sales. Suggest you post an idea or vote for existing idea on th...

3 years ago
Forum
Accounting in Acumatica
Reply
RE: Back order - automation

@kuhnami You and Tim are correct. The Replan Backorders works as stated, but as Tim mentioned there are gaps in the functionality. I worked around t...

3 years ago
Forum
Everything Else
Reply
RE: Help with grouping in a report

Hi Laura Try putting the Page Break on the Group Footer Section1 - see screenshot

3 years ago
Forum
Acumatica Report Designer
Reply
RE: “Poor man’s” project / cost accounting

Hello GregUse a subaccount segment for pseudo projects. This provides for: Validation - you validate the segment from predefined list Easy data ...

3 years ago
Forum
Accounting in Acumatica
Reply
RE: Employee Setup

Hello EdAll sorts of benefits: Approval and Assignment maps use Employees Tasks, Activities, Events use Employees. I typically setup an corres...

3 years ago
Forum
Everything Else
Reply
RE: Generic Inquiry to Export Scenario

Hello Tim Did you consider changing the "Maximum File Upload Size in KB" in the File Upload Preferences?

3 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Topic
How to automatically add file attachments to an outgoing email
3 years ago
Forum
Everything Else
Replies: 1
Views: 1553
Reply
RE: Custom Account Statement - Issues Maintaining Text Position

If the "perforation" is moving, normally I would look to the reason. The information below must be variable in height. So look at "fixing" the heigh...

3 years ago
Forum
Acumatica Report Designer
Reply
RE: How to display an image in a side panel

Hi Tim Great minds think alike. After I posted, I thought of the same. I have a subreport that I can tweak a little that will do just that.

4 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Topic
How to display an image in a side panel
4 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Replies: 2
Views: 1916
Reply
RE: Designing Graphic Dashboards?

Hi Natalie Alternatively, you can just load an image and define the areas that are clickable and the associated actions. There is a Technical Tuesd...

4 years ago
Forum
Acumatica Dashboards
Topic
How to make use of the Subcontract Source for "Drop Ship" in Advanced Manufacturing
4 years ago
Forum
Everything Else
Replies: 0
Views: 755
Reply
RE: Including file attachments when printing an invoice

@abrunner Whatdo you mean by "dynamic rather than static"?

4 years ago
Forum
Everything Else
Reply
RE: Inventory Quantity Transfers from Item A to Item B

Yes - use a Kit Assembly. B is the finished item and A is the component. Setup Steps Flag B as a Kit Setup Kit Specification for B. Either a...

4 years ago
Forum
Everything Else
Reply
RE: Can't Open Sales Order Form

There may have been a schema change in relation to that field where it used to use Salutation and now uses Attention

5 years ago
Forum
Acumatica Report Designer
Reply
RE: 6. Business Events – Creating a Task Automatically (Summit 2019 Session Examples

Does anyone know the "secret sauce" in relation to Email Activities? I have tried Email$RefNoteView, EmailActivity$RefNoteView, CurrentMessage$RefNo...

5 years ago
Forum
Everything Else
Reply
RE: Is it possible to select Actual and Budget Ledger at run time?

Hello John Interesting dilemma. Must have been some important reasons to have separate ledgers. Not much you can do about the Actual ledgers post ...

5 years ago
Forum
Acumatica Analytical Report Manager (Financial Report Writer)
Reply
RE: Default Sorting on Aggregate Results

Good one Tim

5 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Tricky filter and/or formula

See the attached xml built using 20.115.0039. Simply grouping the sales orders by customers and aggragting the OrderDate using the Max (OrderDate) an...

5 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Tasks & Quotes

Hello Chris Depending on the browser you can click and drag the email to the quote/task. Prerequisites: Acumatica - .msg has to be defined in ...

5 years ago
Forum
Everything Else
Reply
RE: Approval for Discounts / Price Changes

Yes - because Discount Amounts & Percentages are available when creating the approval, you should be OK - see screenshot

5 years ago
Forum
Everything Else
Topic
Support for OData and Apple version of MIcrosoft Excel - Looks like its coming
5 years ago
Forum
Acumatica OData with Microsoft Excel and Power BI
Replies: 1
Views: 1446
Reply
RE: Import Activities for a customer

Hello John Looks like you are nearly there. I have tested the following Import Scenario successfully: Please note that I have hard coded th...

5 years ago
Forum
Everything Else
Reply
RE: Business Events type "Trigger by Record change" failure to launch

@timrodman Unfortunately here in Australia, there is a lag between Acumatica releases and local deployment. The distributor in Australia is rollin...

6 years ago
Forum
Everything Else
Topic
Support for custom fonts
6 years ago
Forum
Acumatica Report Designer
Replies: 4
Views: 2852
Topic
Business Events type "Trigger by Record change" failure to launch
6 years ago
Forum
Everything Else
Replies: 6
Views: 2084
Reply
RE: Import Scenario - AP check with Applications

Thanks Kurt I was wasting my time until I saw your pointers.

6 years ago
Forum
Everything Else
Reply
RE: % of Sales Annual Total

Hello all Another approach is instead of using a Calc Type column is to use a GL Type column where the DataSource is across the 12 months required.

8 years ago
Forum
Acumatica Analytical Report Manager (Financial Report Writer)
Reply
RE: % of Sales Annual Total

Hi all I had nine such ratios in a report. As you could imagine the formulas in Tim's excellent approach would have gotten very long. I was not sure...

8 years ago
Forum
Acumatica Analytical Report Manager (Financial Report Writer)

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.