Reports and Generic Inquires

All, I have a pretty rudimentary GI. I need to filter values with a check box. So I created a parameter and then a condition. Essentially, if the check box is checked I need this to be true:[SOLine.ReasonCode]<>'PENDING'If the SOLine.ReasonCode = ‘PENDING’, then do not display those pending orders in the results.This is what I have. When I click the No Pending check box, all records disappear. I’m not sure where to include the [SOLine.ReasonCode]<>'PENDING' 

How is Device Hub supposed to work?  I’m very confused with the community posts and help files.Scenario:I have a custom form.  I have set the form to print to my device hub printer in user profile.  When I run the report to preview and then click Print, should the form automatically print to the device hub printer?  

Trying to make a GI that has a Condition to only show results is a specific Warehouse Item detail exists, and if that Warehouse Item detail has the Override Replenishment check box checked.  This is what I have currently:But my results do not filter out just the check boxed items.  And I triggering the validation of a check box incorrectly?

Hi,Does anyone know how to resolve this error? I am unable to access report IN615000 Inventory Balance Report.Thanks for any help.  

Hello all, I’m fairly new to Acumatica, and wanted to know how all of you have installed databases, i.e. Microsfot SQL Server or MySQL.  The Aumatica instance is in the cloud but the database would be on prem.  I supposed there could be a way to move it.  My goal is to write SQL to query the database using DAC’s, but visualizing those DAC’s in the database so that I can see the schema.Does anyone have a set of instructions?  Protocols needed, etc? Thanks!

I’m attempting to create a Generic Inquiry based on the INLotSerialStatus DAC.However, it only shows me some of the records that are present in the database.If I use the DAC schema browser and look at the DAC source data, I see about 2,100 fewer records than what are in the database table. I’ve compared a number of db records and have been unable to find a commonality between records that don’t show in the DAC.Is this a bug, or is there logic that filters INLotSerialStatus records and is intended to hide them from the DAC based on certain criteria?As far as I can tell, all the records that don’t show in the DAC, are records that have production orders that haven't been completed yet. However, there are plenty of records for items that are in various stages of production, that do show in the DAC.

Is there a way to “filter” out alphanumeric characters from an INT field? Somehow, our Parent.BAccountID field has aat least four customer numbers, such as AAMISC, C000001, INTMISC, and KCTEST which, when I do a GI linking Parent accounts with Child accounts it continually throws an error message:I’ve tried filtering out the “bad” customer numbers in various ways without any success. For example and I am only using two of the four for now:Any help, if it is possible, would be appreciated. I suspect that these were imported into the system because I didn’t think it was possible to do this as a manual entry.

A client, in Canada, needs to have some TaxIds grouped together on the printed AR InvoiceI created a subreport to do the calculations & return the calculated total. This is what the calculation is: =$GST + IIF ( [ARTaxTran.TaxID]='FREIGHT13' OR [ARTaxTran.TaxID]='FREIGHT15' OR [ARTaxTran.TaxID]= 'FREIGHT5' OR [ARTaxTran.TaxID]='GST' OR [ARTaxTran.TaxID]='GSTNOPST' OR [ARTaxTran.TaxID]='HST13' OR [ARTaxTran.TaxID]='HST15', [ARTaxTran.TaxAmt] , 0)This works perfectly for Invoices. When a Credit Memo is printed the result returns zero. I set the subreport up in the site map & ran it & the totals appeared as expected. I have no idea why the Credit Memo is not returning the results. Any assistance would be great!The 2 reports are attached.  

Scenario:  I am working on a Invoice Report, and need to make some changes to how the report calculates discounts.  While in report designer, when I click on Preview, the verison of the report is one that doesn’t reflect what I am trying to work on.  Meaning the Invoice in quesiton does not have any discounts to update, so I cannot see if my changes are working as expected.  I have just been saving to the server, and checking there.  But is there a way to tell Report Designer what data I want it to pull?

I want to populate  [AMBatch.BatNbr] as the report parameter. I have added the parameter in the schema but nothing is showing up on the report screen. Report Designer Setup for the ParameterThis is how I see this empty selector.  Report screenAny leads will appriciated.Thanks​​​​​​​

I’m not really sure of how this is going to play out, but I am trying to generate a Generic Inquiry invoice whereby the parent is the bill_to_name with the child customer no and ship_to_name associated with the child account. At one point I did manage to get both but in most case, the child account was duplicated multiple times including the invoice number and total sales. I did try it by using one instance of customer as a parent, and a right join on another instance of customer as a child, and it worked until I startted putting the bill_to_city, bill_to_state and the child ship_to_city, ship_to_state. It really got convoluted. If anyone has anything that they’ve done in the past along these lines, please share. I’ve tried using some of the Out-of-the-box GI’s and modify them but so far no joy.

 In the report designer, I need to print a Quote Order report including SOLine InventoryIDs and other details, along with Sales Order Estimate Tab’s InventoryIDs and other details, including taxType. How can I do this? When I try to print the SOLine InventoryIDs, duplicates occur.

Hi Everyone,Good Morning,I have added a multiple filters in Report Designer. But, all are working fine expect Location lookup data not populated. Here is my setup… So please help me out, How to fix this? Thanks,Nageswararao A.

We would like to add a row style to a Generic Inquiry where if the SOOrder.OrderDate within 3 days of shipping AND SOShipment.ShipDate <= 3 days from the SOOrderDate show the row as ‘green40’ else show as ‘red40’. Unfortunately using Is Between can’t be used for the row style.

Building a GI that will display Inventory items along with the data from the InUnit table (conversions).Ex. My GI keeps giving me duplicate records such as below:I’m not sure where the conversion factor of 1 is coming from in this case. Here are the joins: 

I am using SWITCH in a Generic Inquiry but the column comes up without any values. My formula is as follows: =SWITCH(([SOInvoice.DocType] = 'Credit Memo'), 'C',([SOInvoice.DocType] = 'Invoice'), 'O')So what I am attempting to do is if the DocType = ‘Credit Memo’, change the field to a ‘C’ and if it is an ‘Invoice’ change to an ‘O’.

Hi, is there a way to restrict certain users to only print approved PO only? Thanks in advance. 

When add function in data field and view inquiry. after export to excel but in excel i cannot sum column value 

Is it possible to stop selection of all incl. serialized items with 0 balance on the SVO/Appt.. Or highlight that entry in red when someone picks that item on the Service Order or Appointment?

I have a report that I created a couple months ago that I need to make some changes to. When I click on Edit Report, I get the normal Report Designer pop-up to login. However, as soon as I login I get the error message that the report does not exist. The report runs, so I know it’s there. I just can’t figure out why I’m not able to open it in Report Designer. I haven’t had any issues with opening other reports, so it’s something with this one specifically. Has anyone else run into this or have any suggestions? Thanks! 

Any suggstions ?

We have a production ticket report for production of canned beverages.There are 50+ product specifications. These are 1 page documents/images. Is there a good way to display a specific product spec that is pulled from the inventory ID stock item description and matched with the 1 page image?The only way I can think to do this is have 50+ sections with visibleExpr that would each display the image only if the statement below was true:=iif([InventoryItem.ItemClassID_description] = 'BERRY LEMONADE', 'TRUE', This would require a lot of work to set up and maintain 50+ image files.If these product specs were to change every month or so, what would be the best way to update or set up these reports? Would a database setup allow for the image files to change without having to change anything in the report? 

Hi All,I want to add & show the content of Shipment Notes on Generic Inquiry.As I know from version 2021 R1 (we use 2022 R2) we can choose which notes can be attached to GI by Attach Notes toAfter viewing GI, I don't see it appear and even though the content of notes can be seen on screen also.Do you have any idea? 

I am developing a custom report, and it needs to set the ARPayment , RefNbr as a parameter. I set the parameter in both ways in the report designer as follows,but it doesn't show the reference number in the frontend, Does anyone have an idea how to get the ARPayment reference number as a report parameter?