Thanks for the responses, Tim and James! Tim, to response to your comments: 1. Seed does have a shelf life, because as we store seed germination rates...

Well, I kept digging on this problem on my own and was able to figure it out. First of all, I stupidly had forgotten that my report read orderdate fro...

Yeah. Unfortunately you can't use a calculated field. You'd have to create a SQL View as a published customization. I posted this on the Acumatica for...

Combing through the help docs, just saw this: "Through OData, you can view the list of fields in exposed inquiries. The field names in the list are...

Hey Tim, Have you ever used this with Power BI? I followed the instructions here to setup the incremental refreshes here: However, when I had it setup...

In case anyone else runs across this issue, I did find another solution to my troubles here. I'm not experienced enough to be able to build my own vie...

@myrcenary - This would give me the data from inventory summary report (summary report pulls from INSitestatus). But the idea would be to build a GI t...

Nice one! Thanks for posting that. At this point, probably not worth going that deep, but if we do continue to have problems, I'm definitely going to ...

Does anyone know if the fields from the Inventory Allocation Details Screen is available in the database to pull into a GI?I'm finding a lot of these ...

Hey Michael, Could you do something like this to give you the start of month 3? Dateadd(today(),'d',84 - (Dayofweek(Dateadd(today(),'d',84))+1)) Or a...

I've got 25 columns, so nothing insane. Some of them do have formulas, but nothing intense. I think overall I have 4 columns that have formulas, most ...

So yes, Tim, that does fix the issue of the refresh. Limited it to 1000 lines, and works like a charm. Definitely a size issue. And Royce, I'm afraid ...

@royce-lithgo - it's pretty static at this point. It is line level data from orders. I could do an export and create a static table. Ideally I get aro...

You could create a "Week Start Date" column using: = DateAdd( [SOLine.OrderDate], 'd',1-IIf( DayOfWeek( [SOLine.OrderDate]) = 1 , 7, DayOfWeek( [SOLin...

After trying 3-4 times, deleting off the sitemap and reentering I had given up. I went back to the Generic Inquiry this morning and voila - the screen...

Wow. Okay, so back to the original issue on this thread, the screenID changing to zeroes. I had this happen to another GI. This one, luckily is not co...

Yep! And we did have two companies. Our partner had to do an update to one of our instances and ran into an issue with it, so made a call to change to...

Turns out it was just timing with the URL change on this last error. I tried changing my URL to /odata/ instead of "/odata/companyname" and the feeds ...

Hey Shawn! I did that and I realized that yes, I can't pull any data from my normal OData URL. But I realize now that it is an internal issue due to a...

Hmm. To add clarification here, as well, it looks like all of my odata feeds in PowerBI and in Excel no longer load, and they all give me this error. ...

Argh. I went into refresh my OData source now in excel and it is giving me a not found error. I don't know how to go and try to modify the source in t...

@Royce - I can tell you have done this before 🙂 Worked perfectly. Thank you so much! Just saved me a bunch of time. And I'm sure I'll see this again...

Hey Tim! I would love to learn about this topic, but the link you posted above is no longer active or it says I don't have credentials to view it. We'...