Reports and Generic Inquires

What data tables hold the items currently in totes? I’d like to list all the totes active in the system and then display their contents. I just can’t seem to find the data tables holding this information. Anyone know where to look? Thanks!

Greetings, it is possible for the variables of Alternate ID to be reflected as for example in excel, individual columns?  example: 

Hi,I’m trying to make some generic inquiries available for customer portal users. All indications from the help guide make it seem possible so I suspect that I’m missing something out.The GIs appear on the portal for our admin users but not customer (contacts linked to business accounts) users. The access levels to the GIs are the same. Is there anything I’m missing out? Any help would be greatly appreciated!

When a production order is created from an Estimate, is there any join/link between Production operation ID and estimate operation ID?

I have a generic Inquiry that I’m trying to filder the created date time column by date and time. Right now if I click on the column to filter it I only get filters that filter as if the value was plain text however I would like for it to recognize that its datetime and allow me to filter as such.I’ve attached an example of how I would like it to be to serve as reference.  

I’m thinking of developing some Report Designer content in my off time.There’s a lot of stuff on the internet already, so I actually cover ground people want to know about/could do with a refresh I have a few questions for the community if anyone feels like sharing:Existing content: What Videos/blogs/websites are your favorites for Report Designer tutorials? Existing content: Are there any tutorials you REALLY recommend as amazing?   New content: What do you struggle to find information on? New content: What information seems to be out of date? New content: is there anything you just want a great tutorial out there for? Sorry if this question gets asked a lot, I couldn’t see a recent post like this.

Hi Experts.I have created a new GI and copy paste the Payment and Application GI in new one. Then I have added it in API End point and populate the fields using Results but When I am trying to get the data based on filters it raising Attached error. I just removed note table from GI and other is same as payment and Applications GI. Any one please guide me about this error. When I tried PUT method. it says exceptionMessage": "More than one entity satisfies the condition.", URL http://localhost/entity/Payments/22.200.001/ACHTEST?$filter=DepositAfter ge datetimeoffset'2024-05-07' and DepositAfter le datetimeoffset'2024-06-06'and PaymentMethod eq 'ACH' and (Status eq 'Open' or Status eq 'Closed') and Type eq 'Payment' and Deposited eq false

I have a customer who prepares statements monthly and distributes via email and mail. They utilize a 3rd party printing service that requires all multi-page statements to be isolated from single page statements.Would love to filter by mutli page first and single page next or something along those lines. Is there a way to do this utilizing the =PageOf function, some kind of grouping, or something similar? 

Hello. I need a resulting statistic that shows me Inventory Turnover Ratio: (This measures how efficiently you sell through your inventory.)Has anybody done this yet on an acumatica dashboard, and if so, can you share the method here? Please and thank you

I am experiencing an issue with Report Designer. When I make changes in Report Designer, they appear in the preview tab but do not reflect in the URL.Please note that I have saved the changes to the server with a new version and activated the version in Acumatica. My user permissions allow access to Report Designer, yet the changes still do not appear. I specifically tried modifying the dunning letter printing format in Acumatica.

I have formula that can grab all the differences in expected vs real dates, but how do I tell my AVG() aggregate to ignore any zero values in the formula (i.e. the false branch of the statement below)? =AVG( iif(DateDiff('d',[POOrder.ExpectedDate],[POOrder.UsrOrigPromDate])>6 OR DateDiff('d',[POOrder.ExpectedDate],[POOrder.UsrOrigPromDate])<-6,DateDiff('d',[POOrder.ExpectedDate],[POOrder.UsrOrigPromDate]),0))I tried using the empty set instead of zero, but it gets angry about it not being a number. There has to be a way to just say “Skip this row” based on a condition. Can someone save me?

I was looking through other forum posts trying to find a solution to a long standing request regariding Inventory Valuation report where my supervisor would like to run it by date, he linked me to this post  which I have already gone through before but hit a dead end as they state you can use an If statement to allow the date range to be input but I cannot seem to properly format this nor wrap my head around how the parameter would correctly engage the data sets the way they have shown it built. any help with this would be greatly appreciated.

HiMy asset already fully depreciation with 100 salvage value. After that, i want to change the salvage value to 1. Is there any option to trigger depreciation for amount 99. Asset with fully depreciation status, we cannot trigger Calculate Depreciation process.  Thank you,Nas 

How can I retrieve the date when the status of a sales order changes from 'Open' to 'Completed' using a Generic Inquiry.

Hi! Is there a way to identify $ amount of what is shipped on a SO and the $ amount of what is not shipped on the SO and put them both in one GI? I am guessing you can’t do this but would like to be confirmed. Any ideas on if this is possible?Right now I have a GI where I’m using the formula qtyhardavil >= openqty to determine where an item on the SO is Shippable or not. Not what has shipped and not shipped from the SO.Thanks!

Hi, is there a way where I can show all stock items their QTY on hand, available, location, and lot/serial number all on 1 GI? similar to inventory summary screen (whether it has a lot/serial or not) but in GI form? It seems like they are two separate tables being I would like to show lot/serial number as well. any thoughts are appreciated.

Hi ,I have a requirement to create a generic inquiry to see the projects revised budget (Original + Change Orders) for a given date. It needs to be able to select the date as a parameter and system show the total revised budget for the parameter date. I tried creating a GI but it was not successful. Do you anyone know a table to fetch this data or way of creating a GI to get this results?Thank You,Dulanjana

Good day, we have a client that has suddenly received an error on one of their Generic Inquiries.On the Main GI there is an exclamation mark that states System was not able to get record count and there’s an exclamation mark in the top right corner indicating that the number of records is capped at 50,000On one of the exisitng filters it states: The exact number of records cannot be retrieved. During export to Excel top 1000 transaction records will be exported.See screenshot below.Version 2024R1 PCS on an Azure server  

We have a newly created report that we would like to add to certain customer’s Mailing and Printing setting. When we attempt to add the report it is not found under either Mailing ID or Report ID. What is the process for adding a new report to these setting. 

Hello! I received the following error when trying to open a GI that I have created. I’m assuming this has to do with customization projects? The system recently got upgraded to 2024 R1, and the customization projects are published. Any ideas on where to go for this? Thanks!! 

We have a custom GI which is showing this message in the status bar:Same query exists in two tenants but only one of them (the one with more data) shows the message.

We are designing a new form where by we need to have a FROM: and a TO: using the first of the current year and the last of current year for the period. We would like to use @YearStart, and @YearEnd but are not quite sure where and how to code it in the Report Designer, or if parameters need to be stated first in the Schema. Most, if not all, of our reports have a date already associated with the type of report needed, but in this case, none of that is present. The initial form will be a “blanket” form just to get started. My code in the groupHeaderSection1: I have one text box: [=’FROM:’ + [@DateFrom]], another text box: [=’TO:’ + [@DateTo]]. but these are not showing up on the report in preview at all. My Parameter Schema has DateFrom as Name, Data Type Date Time, Prompt: Start Date, Default Value @YearStart, Visible, Required, and the DateTo has its’ appropriate parameters set up also basically the same way.

Hello,I have a custom report to print a lable.  The physical label is being printed on a label printer.  The label is 4” wide by 6” tall.  I want to print the label landscape as the items on the label are wider than they are tall.I was hoping setting it to 4” wide and Landscape would accomplish this.  However, it does not. If I select portrait when printing, it prints the label information at the top of the label and does not turn the items 90 degrees to be properly aligned on the label.  Items are squished and use about half the physical label.If I select Landscape when printing, it does turn the items 90 degrees as desired, but does not expand out to use the entire label, it squishes it use about half of the physical label.  

I would like the value to display as a currency with 0 decimal places and comma separators.However, when I used a formula like CInt(x), it still showed 1,111.00, so I would like it displayed as 1,111. I also created a new field decimal type (19,0) and selected it in the schema field, it still showed the same like1,111.00. Is there any suggestion? Thanks!

How can i convert a report into GI. “Inventory Analysis”1. That Report Contains Subreport2. These Fields were displayed in the reportSubreport Contains parameter - InventoryItem.InventoryCD Please help, Thanks in Advance