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)

Charles Craig
Charles Craig
@charles-craig
Forum Home   |   Recent Posts
Eminent Member
Follow
Profile Activity
Topics: 0 / Replies: 21
AllTopicsReplies
Reply
RE: ARInvoice and PMRevenueTotal Needed on Same GI

@mnecaise you can trip zipping the xml up first to see if that lets you attach it.

2 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Embedding a web page into an Acumatica screen (not dashboard)

@kyle-wright I did find out a little bit more but put my Acumatica studying on hold for a bit. I will get back at it though, as my long term goal is t...

2 years ago
Forum
Everything Else
Reply
RE: Do you currently use a VOIP Provider at your current company?

I don't see an integration option for Acumatica, but we use BroadVoice.

2 years ago
Forum
Poll Questions
Reply
RE: Embedding a web page into an Acumatica screen (not dashboard)

@kyle-wright injecting custom html/js has been on my list of things to figure out. This has encouraged me to get back into looking into.

2 years ago
Forum
Everything Else
Reply
RE: Exploring the limitations of Lo-Code/No-Code Customisation Project Editor ...

Awesome! Looking forward to your guide!

2 years ago
Forum
Everything Else
Reply
RE: Exploring the limitations of Lo-Code/No-Code Customisation Project Editor ...

Good for you for not punishing yourself with Microsoft's Java, uh, I mean C# ๐Ÿ˜‰ Hopefully there's a better way, but since I'm still learning I'll ju...

2 years ago
Forum
Everything Else
Reply
RE: What SQL table store Audit History information for Acumatica?

One of these? AUAuditField looked promising.

2 years ago
Forum
Everything Else
Reply
RE: Odata / PowerBI Error

I was able to choose a specific OData exposed GI using these instructions

2 years ago
Forum
Acumatica OData with Microsoft Excel and Power BI
Reply
RE: Keyboard Shortcuts: Ctrl-Esc for SELECT and Ctrl-Insert for EXEC

@timrodman Just checked and it is still Ctrl+Ins on the mac, but that's only because I have an external keyboard that has Windows keys on it. Without ...

2 years ago
Forum
AugSQL
Reply
RE: Keyboard Shortcuts: Ctrl-Esc for SELECT and Ctrl-Insert for EXEC

@timrodman use Ctrl all you want, us Mac users will be fine ๐Ÿ˜‰ Would having ctrl-v auto execute be an option one could toggle between? I don't alway...

2 years ago
Forum
AugSQL
Reply
RE: Create a Generic Inquiry to Show only Orders with Specific Inventory Items

@richard-heap This gives me motivation to build some better tools for it ๐Ÿ™‚

2 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Create a Generic Inquiry to Show only Orders with Specific Inventory Items

@richard-heap I was trying to see if I could avoid filters, but this gets the job done. I wonder about how it scales for larger datasets since this wi...

2 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Create a Generic Inquiry to Show only Orders with Specific Inventory Items

@anne-r-trockman unfortunately, that still puts us back in the same spot where it returns orders that contain both. My example only has the Acumatic...

2 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Create a Generic Inquiry to Show only Orders with Specific Inventory Items

@alconroy The tricky part is that he does not want any orders that also contain line items that don't start with 6. A condition of starting with 6 r...

2 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Create a Generic Inquiry to Show only Orders with Specific Inventory Items

This is not what you asked for specifically, but in SQL you could do this: SELECT * FROM SOOrder o LEFT JOIN SOLine l ON (o.id = l.OrderNbr) WHER...

2 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Is it possible to add a page break to note text?

@mnecaise this probably won't make a difference, but could you try it with double quotes around the parameters? =Replace([PMQuote.NoteText],"II","{b...

2 years ago
Forum
Acumatica Report Designer
Reply
RE: Is it possible to add a page break to note text?

I've never used the Report Designer, but does it allow you to use periods as separators instead of commas for function arguments? If not, then I'd say...

2 years ago
Forum
Acumatica Report Designer
Reply
RE: Retrieving large datasets with AugSQL

@timrodman Ok now that makes a lot of sense that it's IIS! When I hop in to SQL Server Studio and run queries they run at full speed so I just figured...

2 years ago
Forum
AugSQL
Reply
RE: Retrieving large datasets with AugSQL

Interesting that it took minutes, was there a lot of joins or non-indexed where clauses? Granted, I find Acumatica the slowest platform I've ever used...

2 years ago
Forum
AugSQL
Reply
RE: adding SO to account details screen

You can add that field by adding a LEFT JOIN on the Batch table's BatchNbr column to INRegister BatchNbr column. Add the INRegister to the Tab...

2 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Question on REST API for Stock Item

Are you using the $expand parameter?

2 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables

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.