AUGForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Course
  • Consulting
  • Login
  • 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
Member
Follow
0 Followers / 0 Following
Profile Activity
Topics: 0 / Replies: 24
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...

2 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Topic
Adding Contact and Address info to AP Bills and Adjustments GI
2 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Replies: 4
Views: 440
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...

2 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.

2 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...

2 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Topic
Concat function - how to add an apostrophe to a string?
2 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Replies: 8
Views: 2446
Topic
Convert String to Date?
2 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Replies: 4
Views: 1126
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 ...

3 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...

3 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...

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

@royce-lithgo Thanks for the clarification Royce.

4 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 ...

4 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Topic
Conversion failed when converting the varchar value 'ONLINE DISCOUNT' to data type int
4 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Replies: 6
Views: 2604
Topic
Values rendered change based on usage of formula when multiplied by 1
4 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Replies: 3
Views: 779
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...

4 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

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

Thanks for the advice Shawn!

4 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...

4 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...

4 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Topic
Link Invoice to Ship To State
4 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Replies: 7
Views: 1480
Topic
Creating separate versions of a GI
4 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Replies: 7
Views: 1010

Online Members

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.