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: External Imagens Link

I have used PictureBoxes only with embedded images. I tried an external one and had the same issue as you. I suspect it could have something to do wit...

8 years ago
Forum
Acumatica Report Designer
Reply
RE: Formula for GI caption

Not possible - caption only supports static text. You could try suggesting it here:/p>

8 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Dashboard for monthly assets and liabilities

I just did something similar for inventory. It has a similar INItemSiteHistByPeriod table with a FinPeriodLastActive field. The data I want for the qu...

8 years ago
Forum
Acumatica Dashboards
Topic
Import Scenario to add allocations to a Purchase Receipt
8 years ago
Forum
Everything Else
Replies: 15
Views: 7869
Reply
RE: Automation Notifications - Custom URL or Dynamic URL

You need to modify the HTML for your url, ie: <a href="https://url.acumatica.com/?ScreenId=PO302000&amp;ReceiptType=RT&amp;ReceiptNbr=((Doc...

8 years ago
Forum
Everything Else
Topic
Default View settings for all users
8 years ago
Forum
Everything Else
Replies: 8
Views: 5399
Reply
RE: schema diagram

Added my vote to that idea. I've been doing this the hard way when building new GIs. I use existing reports and GIs to determine the relationships for...

8 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Import scenario to update Default Customer Payment Method

I think you need to use the @@ operator to select the Payment Method you want to set as default and then assign the IsDefault field.

8 years ago
Forum
Everything Else
Reply
RE: Automation Notifications - Custom URL or Dynamic URL

What Screen ID did you associate your Automation Notification with? Alternatively, click at the end of your template, add a blank line and then add th...

8 years ago
Forum
Everything Else
Reply
RE: Formula to print Month description

Ishan, It's working in our reports, the only difference is for our reports the -1 is a 1, so it list months from current on wards. Example: These wer...

8 years ago
Forum
Acumatica Analytical Report Manager (Financial Report Writer)
Reply
RE: Formula to print Month description

Try something like this: =Format( '{0: MMM yyyy}', DateAdd( Report.GetPeriodEndDate(@StartPeriod), 'm', -1))

8 years ago
Forum
Acumatica Analytical Report Manager (Financial Report Writer)
Reply
RE: Report Designer- Exporting to Excel

Someone else just asked these 2 questions yesterday and I responded here:

8 years ago
Forum
Everything Else
Reply
RE: Using an import scenario to change the item class on a stock item

You need to include the <Dialog Answer> prior to the step that triggers it. Here's an example for reversing a journal. This also triggers a conf...

8 years ago
Forum
Everything Else
Reply
RE: AP EFT Payment Notification

Sorry for the confusion. For some reason, the "Print / Email AP Remittance Advice form" is a custom form included with MYOB Advanced. I have no idea w...

8 years ago
Forum
Everything Else
Reply
RE: How do you bring over an image from report designer to excel when exporting? I set up an excel format in report designer but it does not bring over the image.

Image export to Excel is currently not possible. Vote for the Idea here:/p> Note sure what your issue with text wrapping is - i just ran a PO report, ...

8 years ago
Forum
Acumatica Report Designer
Reply
RE: Email Sending quirks

Actually it was something that could be set on AP Preferences and that flowed down to all Vendor Classes which then applied to all Vendors. So it was ...

8 years ago
Forum
Everything Else
Reply
RE: Enable Scrollbar on Data Table widget

Thanks Tim, that makes 2 votes! 🙂

8 years ago
Forum
Acumatica Dashboards
Reply
RE: Automation Notifications - Custom URL or Dynamic URL

Switch to HTML view and add something like this - obviously you need to update the domain: <a href="https://mycompany.com/?CompanyID=((GeneralInfo....

8 years ago
Forum
Everything Else
Reply
RE: Email Sending quirks

For anyone interested, the email account can be specified on the Vendor, Mailing Settings tab for the 'AP REMITTANCE ADVICE' Mailing ID. If this is do...

8 years ago
Forum
Everything Else
Reply
RE: URL to open "My Workgroup's Approvals" tab on Approvals Screen

I can answer this myself. You can modify the default property via System > Customisation > Manage > Filters

8 years ago
Forum
Everything Else
Topic
URL to open "My Workgroup's Approvals" tab on Approvals Screen
8 years ago
Forum
Everything Else
Replies: 2
Views: 2182
Reply
RE: Automation Notifications - Custom URL or Dynamic URL

You can't open PO Receipts with an Order Nbr. Order Nbr is part of a receipt line and a receipt could include multiple orders.

8 years ago
Forum
Everything Else
Reply
RE: Enable Scrollbar on Data Table widget

Done. Anyone else who thinks this is a good idea, please vote!

8 years ago
Forum
Acumatica Dashboards
Reply
RE: Collapsible sections for dynamic reports

Tim, that's awesome. I think that would solve the problem!

8 years ago
Forum
Acumatica Report Designer
Reply
RE: Email Sending quirks

Hi Tim, Notification Template email is for EFT remittance. Under AP Preferences > Mailing Settings, there is a notification template specified for ...

8 years ago
Forum
Everything Else
Reply
RE: AP EFT Payment Notification

Use the Print / Email AP Remittance Advice form to trigger sending of remittance advices. The Vendor will need an email address to be able to send the...

8 years ago
Forum
Everything Else
Reply
RE: Auto-Email Received PO's

You can try using <foreach>...</foreach>, but it didn't work so well for me with Automation Notifications. It does work however for Notifi...

8 years ago
Forum
Everything Else
Reply
RE: Collapsible sections for dynamic reports

No, I want different "Label: Value" to be displayed depending on the data. The issue I have is that when fields have been disabled via VisibleExpr, th...

8 years ago
Forum
Acumatica Report Designer
Reply
RE: AP EFT Payment Notification

I have no problem using the built-in EFT remittance advice and Notification Template. Don't know what SWK is.

8 years ago
Forum
Everything Else
Reply
RE: Auto-Email Received PO's

Go To System > Automation > Manage > Automation Notifications and add a new record. Screen ID should be Distribution > Purchase Orders >...

8 years ago
Forum
Everything Else
Topic
Enable Scrollbar on Data Table widget
8 years ago
Forum
Acumatica Dashboards
Replies: 6
Views: 5641
Topic
Email Sending quirks
8 years ago
Forum
Everything Else
Replies: 10
Views: 5770
Reply
RE: Trend weighted average price for purchases of specific item

Thanks Tim. The end user was happy to download the GI data to excel and do the average calc with a formula.

8 years ago
Forum
Acumatica Dashboards
Reply
RE: Collapsible sections for dynamic reports

Hi Tim, Not dynamic columns but rows. I had some limited success with using Panels. Basically I grouped related fields in Panels which were sized the ...

8 years ago
Forum
Acumatica Report Designer
Topic
Trend weighted average price for purchases of specific item
8 years ago
Forum
Acumatica Dashboards
Replies: 3
Views: 4850
Topic
Collapsible sections for dynamic reports
8 years ago
Forum
Acumatica Report Designer
Replies: 6
Views: 5392
Reply
RE: PO Approval - notifying users on Approved or Rejected

Yep, that is used to notify the Approvers that there is something for them to approve. What I was asking was, how to notify the document owners when t...

8 years ago
Forum
Everything Else
Topic
PO Approval - notifying users on Approved or Rejected
8 years ago
Forum
Everything Else
Replies: 9
Views: 7307
Reply
RE: Automating Generic Inquiry with Import Scenario

Unfortunately MYOB hasn't released that version yet to Australia so we don't have Business Events yet. But actually, there's still an element of user ...

8 years ago
Forum
Everything Else
Reply
RE: Compare 2 account balances and calculate difference

Both tables needed to join to Account because they look for different values AccountCD. I couldn't get it to work but i think i probably should have d...

8 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Topic
Automating Generic Inquiry with Import Scenario
8 years ago
Forum
Everything Else
Replies: 4
Views: 5173
Reply
RE: Compare 2 account balances and calculate difference

Posted by: Tim Rodman I think you want to move your last condition into the join itself so that if it fails it won't kill your whole dataset, only the...

8 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Compare 2 account balances and calculate difference

Posted by: Michael Hansen My Guess: When it returns NULL, it fails your conditions tab, so you don't get a row at all. Conditions don't accept NULL un...

8 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Topic
Compare 2 account balances and calculate difference
8 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Replies: 6
Views: 3142
Reply
RE: Delete Restriction Group

I found that Ideas topic today as well. Don't have much confidence that it's going to be progressed.

8 years ago
Forum
Everything Else
Topic
Delete Restriction Group
8 years ago
Forum
Everything Else
Replies: 3
Views: 4624
Topic
Setting up User Security
8 years ago
Forum
Everything Else
Replies: 18
Views: 7544
Topic
Lack of Approvals for AR Invoices
8 years ago
Forum
Everything Else
Replies: 2
Views: 3978
Reply
RE: Audits against Enable/Disable features

I configured the Audit by going to System -> Management -> Manage -> Audit and adding the Screen Name manually. Perhaps the fact that it's no...

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

Hi Tim, Thanks for your efforts. Although i am a little confused by your example because AFAIK, the Allocations popup is for lot/serial number allocat...

8 years ago
Forum
Everything Else
Page 11 / 12 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.