Replies posted by TimRodman
Thanks for the ping @kbeatty21. I forgot to include screenshots on that post that you linked to so I just updated it with screenshots:https://www.augforums.com/forums/everything-else/field-level-security-user-defined-fields-udf-vs-attributes
@darylbowman Ah, interesting, I didn’t realize that. Maybe then it’s only an issue when restoring a backup to another Acumatica Instance.It’s good to know though that you’ve been using it for years without any major issues. Would you mind sharing the size of your Amazon S3 Bucket?Click the Metrics button on the top to see the size of the bucket:
@darylbowman I think that one of the reasons why they might have disabled it by default in SaaS environments was because of Test environments. When you copy a Production Tenant to a Test Tenant, the Amazon S3 links remain the same. So, if you delete a document in a Test environment, it would get deleted in Production as well. How do you handle this scenario?
Hey @hsarjapur,I haven’t used this with a Production environment of Acumatica yet, but I’ve been using Amazon S3 for my AUGForums.com website for years and it works great.You can’t beat the price. It partially depends on how much bandwidth you utilize, but, as far as total file storage goes, I'm using about 145GB of space and my bill last month was only about $3.00.I don't remember picking a “type” of S3 storage, but, as far as I know, I’m simply using S3 Standard as listed on the top of the screenshot below.I think the main reason to look at the other options would be for things like database backups or other infrequently accessed files.For file attachments in Acumatica, I would think that S3 Standard would be the best option because of the “frequently accessed” nature of file attachments.
@vpanchenko I don’t have access to the Ideas area anymore so I can’t check it, but, while you’re implementing OData 4 for Generic Inquiries, if you have the opportunity to slip in an enhancement, I have one that I’ve encountered several times and I was just talking with @awilcheck about it today.The idea is to be able to set values for Generic Inquiry Parameters in the $filter part of an OData URL. Regular field names are referenced normally (eg. RefNbr), but maybe Parameter names could be referenced as something like #MyParameter in the OData URL after $filter, just like filtering on regular fields.The reason for this is that it’s cumbersome to create complex filtering logic in OData filters. It’s a lot simpler to add complex filtering logic to the CONDITIONS tab of a Generic Inquiry and use Parameters on the CONDITIONS tab as a way to interact with the filter logic which could be as simple as a drop-down with a few options that turns logic on/off. We just don’t have a way to set Para
@peterj23 Ya, I'm not sure if you'd see the problem in both the GI and the OData feed. That's why I was wondering what it looks like in the browser. It might give you a clue to know if it's breaking between the GI and the OData feed or between the OData feed and Excel.
@peterj23 Interesting. The reason I asked is that ARSalesPrice.InventoryID has to do a query to get the Inventory ID that you see in the user interface and I was wondering if maybe the problem was with the query. But if it just started working, that’s strange.Another thing to check, if it happens again, is accessing the OData feed in your web browser since that’s closer to the “raw” OData to see if the data is messed up there or only when it arrives in Excel. I think we’d also need to see your Excel file to know if there is any Power Query data transformation or Pivot Tables in place that could be manipulating the data.
@abrunner78 It would be nice to have a DISTINCTCOUNT option available instead of just COUNT. This is an example of why I tend to go with Power BI when I’m getting into an analytical situation since you don’t run into these kinds of limitations in Power BI. But, then you’re using an outside tool which has downsides.
Because of these differences between HTML and PDF (and there are a lot of them), as a general rule, whenever a report is going to get printed, I like defaulting that report to PDF.In my experience, PDF is more reliable and more consistent between computers.
Login to the community
Social LoginLogin with your Acumatica account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.