AUGForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • Consulting
  • Login
  • 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: GI is combining results of two relations

GI with 2 or more different values • Acumatica Generic Inquiries & Pivot Tables • Acumatica User Group Forums (augforums.com) Try this technique...

6 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Structure of SOInvoice versus ARInvoice and ARpayment versus ARadjust2

SOInvoices are from Distribution and once released end up as a corresponding ARInvoice. ARInvoices are for invoices that don't generate in Distribut...

7 months ago
Forum
Everything Else
Reply
RE: Refreshing Odata GI TAbles in Excel not showing newly created GIs with Expose via OData selected

Did you confirm the security on the GIs - the OData user needs access to the queries.

7 months ago
Forum
Acumatica OData with Microsoft Excel and Power BI
Reply
RE: How to print from a generic inquiry

If you want formatted output you need to use Report Designer, not GI.

8 months ago
Forum
Everything Else
Reply
RE: which Generic Inquiry is it connect to?

Well all i can think of is using the Access History page. Set Operation to Access Screen and Screen ID starts with GI. That will give you the histor...

8 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Creating pop-up warnings

We do this with Dashboard widgets following this methodology:/p>

9 months ago
Forum
Everything Else
Reply
RE: Prevent Acumatica New User Email

Any MYOB Advanced users reading this note that MYOB have removed the New User Welcome Email Template from the Email Preferences page. MYOB believe tha...

9 months ago
Forum
Everything Else
Reply
RE: Attaching Notes in a Generic Inquiry

You can add the note text as a result column on your GI and display it on the Data Table widget.

10 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Dashboard Parameters Aren't Filtering Data from Underlying GI

Did you map the dashboard parameters to the GI via the widget?

10 months ago
Forum
Acumatica Dashboards
Reply
RE: Date Difference in year and month

Looks correct to me.

10 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: formula for negative amounts in GI (Adding Calculated Columns – Example #2)

@timrodman Yes you need an IIf, but it's a very simple one.

10 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: formula for negative amounts in GI (Adding Calculated Columns – Example #2)

You can use the [APInvoice.DrCr] field to make the sign flip formula trivial.

10 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: formula for negative amounts in GI (Adding Calculated Columns – Example #2)

Perhaps an example might make your issue apparent.

10 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Unit conversion is missing error in AP Bill processing

Did you check the Trace output under Tools menu?

11 months ago
Forum
Accounting in Acumatica
Reply
RE: Generic Inquiry to Export Scenario

XML doesn't need line breaks to be valid. Can you share the original XML if not confidential?

12 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Generic Inquiry to Export Scenario

Have you tried an XML validator yet?

12 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Generic Inquiry to Export Scenario

I was just thinking of whatever XML validator google search found. eg. But what about the log file mentioned in your 2nd screenshot? That might...

12 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Generic Inquiry to Export Scenario

Click on the link in the error message that opens the log file. You need to work out what is wrong with the data in the excel xml file. There should b...

12 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Generic Inquiry to Export Scenario

Could you please screenshot the errors rather than attach the doc?

12 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Getting a SUM from Quantity on Report

I think you can just multiply the amount by the field InvtMult to get the correct sign. You should be doing a SUM of the formula that does the multi...

12 months ago
Forum
Acumatica Dashboards
Reply
RE: Adding multiple receipts to a bill error

It's not an issue from the application - the error message isn't in the source. Googling I found this:/p> It looks like an issue with your webserv...

1 year ago
Forum
Accounting in Acumatica
Reply
RE: Adding multiple receipts to a bill error

Try adding one by one and saving after each. Has your system been customised? I've never seen that error before.

1 year ago
Forum
Accounting in Acumatica
Reply
RE: Creating Import Scenario For Case History

You can't do anything in an Import Scenario that you cant do interactively in the page. So you need to find out how to do it interactively before atte...

1 year ago
Forum
Everything Else
Reply
RE: Formula comparing last created with ship date wont work

Try this:

1 year ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Formula comparing last created with ship date wont work

Try: =CDate([SOShipment.LastModifiedDateTime]) - CDate([SOShipment.ShipDate])

1 year ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Dashboard widget filter date range from single date parameter

I added the period start and end dates to the query result and then used a filter on those columns: This is actually better as it limits the resul...

1 year ago
Forum
Acumatica Dashboards
Topic
Dashboard widget filter date range from single date parameter
1 year ago
Forum
Acumatica Dashboards
Replies: 1
Views: 330
Reply
RE: Parameters in Scorecard KPI widget

Yep just had this issue today. So frustrating.

1 year ago
Forum
Acumatica Dashboards
Reply
RE: Appearance of Notes and Attachment action icons in query results

@ddunn I finally got around to testing this and unfortunately still no notes when Grouping is enabled. I even tried including the relevant NoteID in t...

1 year ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Join table with filter on a constant (Generic Inquiries)

You need to prefix the string with an equals so it's treated as a formula. ie. ='StatusB'

1 year ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Import Scenario for importing Cash Accounts including payment settings, remittance detail and entry types

@anita-munnich what was the error?

1 year ago
Forum
Everything Else
Reply
RE: Import scenario - delete stock item conversion with IIF statement

Only way i can think of is 2 import scenarios, one for those with conversions and one for this without. Or depending on how many items need the conv...

1 year ago
Forum
Everything Else
Reply
RE: Import Scenario for importing Cash Accounts including payment settings, remittance detail and entry types

Here's an excerpt from a Suppliers import that i did which assigned remittance account details. Hopefully it might be similar for what you are doing. ...

1 year ago
Forum
Everything Else
Reply
RE: Import Scenario for importing Cash Accounts including payment settings, remittance detail and entry types

Do you have a lot of cash accounts to import? This was one table that I've always configured manually as it didn't take long to do and building a GI w...

1 year ago
Forum
Everything Else
Reply
RE: Fixed Assets Question

Did you try the help? General: Depreciation Tab: So the one on the General tab is the default for the Class. On Depreciation it's the actu...

1 year ago
Forum
Everything Else
Reply
RE: Creating a report to automatically send for prior day and month

No, not possible. Put a checkbox parameter in the report which you tick in the schedule template. Then in the report criteria, where you apply the...

1 year ago
Forum
Acumatica Report Designer
Reply
RE: Linking Purchase Receipts with Closed Bills

You can't link Purchase Receipts to closed bills, so you'd need to reverse them if you desperately needed to do so. Purchase Orders can be closed a...

1 year ago
Forum
Accounting in Acumatica
Reply
RE: Help with grouping in a report

How about moving groupHeaderSection2, detailSection1 & groupFooterSection1 (which needs to be changed to footer of groupHeaderSection2) to a subre...

1 year ago
Forum
Acumatica Report Designer
Reply
RE: Is there a way to rearrange Header Sections?

No problem. Glad to hear that it worked for you!

1 year ago
Forum
Acumatica Report Designer
Reply
RE: Is there a way to rearrange Header Sections?

I don't think there is. You could try (carefully) modifying the child elements of <Sections> in the report .RPX file.

1 year ago
Forum
Acumatica Report Designer
Reply
RE: Activities (emails, messages etc.)

Try left join (POOrder to CRActivity) with this: POOrder.NoteID = CRActivity.RefNoteID

1 year ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Creating formula for GI

Try this: =IIf([IspkpCompanyOperatorLicense.EndDate] < DateAdd(Today(),'y',2), 'Expired more than 2 Years', IIf([IspkpCompanyOperatorLicense.EndD...

1 year ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: How to calculate weeks of supply

I doubt you can do it in GI as it requires calculations to be applied to aggregates and GI isn't good for that. You might need to migrate the GI to...

1 year ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: How to see who clicked "Approved for Payment" on an AP Bill?

There's a tab on Bills and Adjustments page named "Approval Details" - did you look there?

1 year ago
Forum
Everything Else
Reply
RE: Trying to subtract credit (amount) from sales dollars in a GI based on the ARTran table

How about this: =IIf([ARTran.DrCr] = 'D', -1, 1) * [ARTran.Amount]) This handles all tran types without having to specify them in the formula.

1 year ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Updating configuration option labels with import scenario

Not quite clear on what you're trying to accomplish but are you able to do the same update yourself interactively? Whenever I'm stuck with an IS I alw...

1 year ago
Forum
Everything Else
Reply
RE: Want to create a Generic Inquiry to manage files that are attached to sales orders

Unfortunately looks like the only way to join is via text in the UploadFile.Name field. Returns 1 row per attachment per sales order with atta...

1 year ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Sales Order Allocations disappear when a Shipment is confirmed - Bug or designed behavior?

Just recently noticed this as well but thought it was due to a recent change. Based on the age of this post it looks like it's always been that way.

1 year ago
Forum
Everything Else
Reply
RE: Want to create a Generic Inquiry to manage files that are attached to sales orders

Try joining SOOrder.NoteID to UploadFile.NoteID. UploadFileInfo has the filesize and datetime.

1 year ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: GI Last Execution Time/Date

Pretty sure it's not recorded. I am in the same situation with the custom GIs built at our site. Would also love to know who it was last run by.

1 year ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Page 1 / 12 Next

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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