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)

Rob Cushen
Rob Cushen
@robcushen
Forum Home   |   Recent Posts
Eminent Member
Follow
Profile Activity
Topics: 10 / Replies: 14
AllTopicsReplies
Reply
RE: Adding Contact and Address info to AP Bills and Adjustments GI

Thanks so much for the help Megan!! I believe I am working with an older version of Acumatica. It did appear that I had to add the "bAccountId" in...

5 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Topic
Adding Contact and Address info to AP Bills and Adjustments GI
5 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Replies: 3
Views: 1577
Reply
RE: Concat function - how to add an apostrophe to a string?

Hi Wyatt.ERP, In most engagements, I have full SQL server access & functionality. In that environment almost anything is possible! I ended up...

5 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Concat function - how to add an apostrophe to a string?

Using Acumatica 2018 R2 with customizations. Maybe that has something to do with it. Thanks again.

5 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Concat function - how to add an apostrophe to a string?

Hi wyatt-erp, Thanks for responding. That is one of the first things I tried, but I got a different result when I View the Inquiry. I get ''Hi a...

5 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Topic
Concat function - how to add an apostrophe to a string?
5 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Replies: 7
Views: 6279
Topic
Convert String to Date?
5 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Replies: 3
Views: 3213
Reply
RE: Perform Left Join on an aggregate?

@timrodman Thanks for the response Tim, and thank you again for hosting this site. My hope is that Acumatica Corporate is contacting you for feedback ...

6 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Perform Left Join on an aggregate?

Thanks for all the responses... Royce, yep having SQL access is the bomb... Ellie, allowing a GI to be used as a source could work if it becomes a re...

6 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Perform Left Join on an aggregate?

Thanks for responding... Yes, I may end up testing that option. There are some calculated values on the report that I do not want to be affected b...

6 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Topic
Perform Left Join on an aggregate?
6 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Replies: 9
Views: 2499
Topic
AR Tran - Tie totals to Standard Report?
6 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Replies: 1
Views: 1456
Reply
RE: Conversion failed when converting the varchar value 'ONLINE DISCOUNT' to data type int

@royce-lithgo Thanks for the clarification Royce.

6 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Conversion failed when converting the varchar value 'ONLINE DISCOUNT' to data type int

@brandon Thanks for the response Brandon... I employed this method -> "The first would be to add the InventoryItem table to your GI and then join ...

6 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Topic
Conversion failed when converting the varchar value 'ONLINE DISCOUNT' to data type int
6 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Replies: 5
Views: 4795
Topic
Values rendered change based on usage of formula when multiplied by 1
6 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Replies: 2
Views: 1334
Reply
RE: Entity Relationship Diagram?

Another thing that would be very helpful would be for the a row count to be returned when Viewing the results of an Inquiry (instead of having to Expo...

6 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Entity Relationship Diagram?

Yes I have done a bit of that as well. Thanks Shawn

6 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Topic
Entity Relationship Diagram?
6 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Replies: 5
Views: 3728
Reply
RE: Creating separate versions of a GI

Thanks for the advice Shawn!

6 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Link Invoice to Ship To State

Thanks Ryan, I linked the ARTran to SOOrderShipment (OrderNbr, OrderType, and ShipmentNumber), then linked SOOrderShipment to SOShipmentAddress (Ship...

6 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Creating separate versions of a GI

Thank you both for the responses. I do not want to start making changes to the live GI's. I'd rather work with a "copy". Don't want to break so...

6 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Topic
Link Invoice to Ship To State
6 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Replies: 6
Views: 2611
Topic
Creating separate versions of a GI
6 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Replies: 6
Views: 2172

Online Members

  • Tim Rodman Julian Schrenzel
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.