@ellie Yes i got it to work with this: Excel file has Receipt Nbr, Inventory ID, Lot/Serial Nbr, Qty

I don't think you can pass values back from a subreport. Can't you calculate the remaining balance in the main report without relying on the totals fr...

Captions are inconsistently defined, hence my previous comment.

You won't get very far trying to apply conditions to aggregates in GI and anyway, as you already know, there's no distinct option.

You use parameters to pass from main to sub. Refer Lesson 5 of S130 Open Uni training.

Error messages such as?

I wouldn't worry too much about how it defaults Captions. In most of my GIs, I manually assign all Captions and column widths to have a nicely formatt...

You got me there Dom, we don't use Audits. But are the Audits the only way you can get the desired reporting outcome? Or to put it another way, can yo...

As I am a consultant I can't give away IP of my client. I am however willing to answer questions and give direction. I was pretty new to Acumatica whe...

Yes you can generate multiple lines from one source - just add as many of these as you need: In our system I wrote a couple of GIs that look for cert...

So you only want rows where x/y < 100 or x/y > 300? Isn't that the same as x < 100 * y or x > 300 * y If so then that's 2 conditions, Data...

@ellie You'd have to look through the available Datafields and see whether that information can be pulled in to the template.

@ellie I can think of two solution to your issue. 1. Add the conditional data to the Invoice report via customisation. 2. Display it inline in the em...

You can do different templates depending on the Type of Invoice. You should definitely include Type in your criteria and limit it accordingly. You mig...

You mean hide it on the profile? Doesn't really add any value so yeah why not.

As we don't use our warehouse in the way you do i can't help you with a specific example. Did you have a GI that you already wrote that wasn't working...

@tami-lynn-hoyt the Automation Notification needs to be based off the page where the source event occurs. If you want something to happen off release ...

@tami-lynn-hoyt No worries and good luck with it. Let me know how you get on with the Notification Templates.

@tami-lynn-hoyt, this might get you started. I can only suggest setting something up in a test tenant and seeing how it works. It would help if you ...

When you say report, do you mean use an existing report or do you mean build something in GI or Report Designer? If the latter, do you have any experi...

If you mean different templates for the notifications, you can setup different notification templates and apply branch criteria on the Conditions tab.

I'm not aware of any table row count limit, might be a data size issue. Do you have a lot of columns in each row and perhaps any columns with a lot of...

What are you trying to accomplish and what isn't working?

Something like that but you need to find out the object names. To be honest, I can't remember how i worked out those names as they don't appear in th...

How awesome would it be if they added the max length to Inspect Element. I am dreaming of course.

You need to do something like this to list multiple records - object names will change depending on context. <foreach view="Transactions"> ((Tra...

If you look at the VisibleExpr for that groupFooter, you will see this: Now look at the Variables for groupHeaderSection3: So you should be able to ...

Yes dealt with it many times. You need to use GLHistoryByPeriod as your driving table. You will then need to join GLHistory twice. Give one of the joi...

Wow thanks so much for this. This would have been a disaster for our site today if I hadn't read this. Although i think the correct URL to go directly...

I voted!

GI is so limiting in Acumatica. Aggregates are performed at the end and nothing can be done with them. I really miss direct SQL queries.

Looks like a required field is missing. As always, do debug Import Scenario failures, you need to do manually what the IS is doing in the same order. ...

Sorry no resources that will make this process any easier. I built multiple Import Scenarios for all our data imports for our cut-over to Acumatica. Y...

You need to build an import scenario for Stock Items. First create a data provider and configure your import file format, then build the import scenar...

It could be a timing issue then if you have bigger tables that refresh fine. If you run the query directly in Acumatica and do a full download, does i...

Without Bitwise operators available in GI, it's just not possible. If you feel strongly about needing it, add an idea to the ideas portal. Frankly sp...

I would try shrinking the data set to determine whether size is the issue. Of this 100mb of data, is all of it changing, or is some of it historical?

@brandon There are several free courses available on Open Uni that might get you started. Check out the application development section at the bottom.

Only stock items have Inventory ID on AR Tran rows. To correctly filter non-stock lines from your results, you should be using condition: ARTran.Inve...

Does this help?

Acumatica does some behind the scenes magic to map CD text values to ID internal numeric values when you directly reference a field in GI, whether it ...

Please do it the proper way, as per Brandon's first option. Using internal Id fields in queries is just asking for trouble and not user friendly eithe...

It is not possible to inject HTML in to GI results. It can be done with reports, just look at some examples of ones that already do it. In GI you are ...

I just noticed a typo, it should be: =CInt(Substring([Data],0,4))

Indeed there is no default data provider type for fixed text. The only nasty way i can think of is use the CSV data provider type, import each record ...

The way we do it is enter a Transaction under Cash Management for bank fees and then those transactions as well as customer payments get reconciled in...

Tim all good now - it came up yesterday. Site looks great!

Sorry but i don't see how pasting JS code answers the original question. If they do have a keyboard shortcut then what is it?

You don't know how to enable the feature?