Reports and Generic Inquires

Hi All,We recently proceeded with our 2022 R1 upgrade and some of the table connections seems to have changed. I have created a custom report that report defect. It now show duplicate lines in the detail section and I can not figure out what is causing the duplication.I have attached the report file for review. If anyone have an idea please let me know.Kind regards,Calvin 

Does anyone know why I can’t access the SystemEvent DAC in a Generic Inquiry? I can see SystemEvent in the DAC Browser:  But not in a Generic Inquiry: 

Hello,I am working on adding additional periods to the AP aging.  AP631000.rpxI can manually set the bucket within the report successfully.  However, I cannot add addtional buckets.Original pulls days from AP settings.= Payments.GetBucketNumberForAgedReport(    @AgeDate,    $DueDate,    0,    CInt([APSetup.PastDue00]),    CInt([APSetup.PastDue01]),    CInt([APSetup.PastDue02]),    False,    False) I manually set the days and this works as expected.= Payments.GetBucketNumberForAgedReport(    @AgeDate,    $DueDate,    0,    15,    30,    45,    False,    False) However, if I add another value, so I can have an additional bucket value, it fails with a trace error.= Payments.GetBucketNumberForAgedReport(    @AgeDate,    $DueDate,    0,    15,    30,    45,    60,    False,    False)It seems like “= Payments.GetBucketNumberForAgedReport” may be referencing a stored procedure or some other procedure outside of the report.Can anyone shed any light on this?Thanks for any insight!

I have a custom report with a subreport.Both the main report and the sub report have the same Style Template.The field in both reports use the same style name, size, and settings.In this case Courier New, 12px, Bold When the report prints the main report fields are in the expected font but the subreport fields do not print in that font.  Changing the values on the subreport have not affected what font appears or whether or not that font is bold. Is there are override somewhere that is forcing the subreport to print differently than designed?Does anyone have any suggestions on how to get the two reports to use the same font.Thank youDaniel FlacksApplications ServicesEvron Computer Systems Corp. 

Hello. I tried searching the forums but didn't see a specific answer to this question. So apologies in advance if this was answered already.Using 2020R2I would like to add to the Vendor Generic Inquiry, some GL account info.Ex. in the Vendor GI, I'd like to addAP Account AP Sub Expense Account Cash Discount Account (stuff from the GL Accounts tab in the Vendor Form)It appears that the tables I need to add do not populate in the "Add Related Table" in the Tables tab?Thank you in advance. 

How to print parameter start financial period in the ARM. for example when i run this report, report parameter financial period is 09-2023, then i want to print 09 as value in the column set. i’ve tried different formula, but it didn’t work. i’ve added ARM report xml file in attachment.  

I’m working on a report to calculate the physical inventory count accuracy. I’m able to calculate the total number of lines counted, and how many of those lines had variances, but I would like to display the accuracy as a % value. This requires me to do some calculations on a single line, and I can’t quite figure out how to achieve that. I have the following so far:The corresponding SQL for the required outcome is:SELECT `INPIDetail`.`PIID`, `INPIHeader`.`CountDate`, COUNT(*) AS `TotalLines`, SUM(CASE WHEN `INPIDetail`.`VarQty` = 0 THEN 0 ELSE 1 END) AS `Variances`, ROUND(((COUNT(*) - SUM(CASE WHEN `INPIDetail`.`VarQty` = 0 THEN 0 ELSE 1 END)) / COUNT(*)) * 100, 2) AS `Accuracy`FROM `INPIDetail` `INPIDetail`INNER JOIN `INPIHeader` `INPIHeader` ON `INPIHeader`.`PIID` = `INPIDetail`.`PIID` AND `INPIHeader`.`CompanyID` = `INPIDetail`.`CompanyID` WHERE `INPIDetail`.`CompanyID` = XGROUP BY `INPIDetail`.`CompanyID`, `INPIDetail`.`PIID`, `INPIHeader`.`CountDate`;As seen above, I have the SUM(

I created a GI with some advanced filters on top, however when I attach the GI as a side panel to another GI these advanced filters doesn't show up it just shows all items at once without these filters.is there anyway to have advance filters on side panels?

This is the error i get (see below)Everything was working fine yesterday and today it is saying it can’t connect. Anyone have an ideas? these excel odata pivto tables a critical to how we operate :/Any help is greatly appreciated! 

Is there any possibility of selecting or typing multiple values to the filter/picker?Requirement is to select mutiple values for the filter.  

I’m trying to set up an approval map for Sales Orders which does the following: If the Sales Order has item X on it, it requires approval from Finance.If the Sales Order does not have item X on it, it does not require approval from Finance. Seems simple enough but the issue I’m having is that when the Sales Order does not have item X on it, it gets automatically Approved which prevents you from editing it while it is in Open status. Is there a way to set this up so that I’m still able to edit while it is in Open status? Or simply not requiring approval in these cases, rather than auto approving.We have some business automation running that requires the Sales Order line level details to be editable in Open status so putting the SO back on Hold to edit further is not an option.  

I’m looking to add a parameter on my sales order GI to filter by statuses, but instead of having all the database values as an option to select from and be limited to select only one value at a time I would like to create my own values (example, Group A, Group B,) and add a condition if Group A is selected than show the orders within these statuses and vise versa, so I can quickly shift my filter between Group A and B and see the relative information.any solution how this can be accomplished?  

Hi All,I notice when I use the quick search and try to export an excel file, it only export from a certain fields while ignoring others. Example below:You can see I search for “FT” and items that contain FT in their product number or description would show.  However when I export to excel, only product number with “FT” is showing and it does not pull the item that have “FT” in description. What do I need to do in GI screen in order to enable the description field to be able to export to excel? Like what governs the field that will be export to excel?Kind regards,Calvin 

I am trying to create a generic inquiry that groups on a formula.  However I am getting the error in the following screenshot:The help file for the Generic Inquiry screen specifically states that I can add a formula so I am not sure what I am doing wrong.  Any ideas? On another note, if there is a table in Acumatica that breaks the subaccount into their segments I would much prefer to use that but I have been unable to find one.Appreciate any help that you can provide!

I set up a dashboard to view the total amount on invoices for last week. I used the @weekstart-1 and @weekend-1 for the filter. It worked fine, however I’m running into an issue on a week where the moth changes in middle of the week. i.e. March 1 was on a Wed. The filter will only include anything from March 1 till the end of the week.   

how can I match debit and Credit in APV thanks a lot.  

Hello,Can somebody pls help me w/ this,Above is my formula giving me the following results:[TranDesc] + Serial Nbr (if SerialNbr is not null) [SerialNbr] (if previous TranDesc is equals to TranDesc) [TranDesc] (if LineType is Non-Stock) However, I have a problem, the highlighted part still comes out tho item has no SerialNbr. I can’t see where I’m wrong or how to add that.Thank you in advance!

Good day, After pulling some of my hair last night, I am requesting for help to add up the End Balances of any Accounts that will show up on the query of the Report,   I have tried to add a new variable $TotalEndBalance and =$EndBalance + $EndBalance, but of course did not work, and I cant find the way to accumulate the balances of each total. Thank you in advance.

Hey all! I’m building a new version of the Batch Packing Slip report, and in order to make it do what I need, I need to add the SOOrder, SOLine and SOLineSplit tables. However- once I added them, it caused the report to loop line items thousands upon thousands of times.How do I fix this? I’ve attached the report.

I created a Row & Column Set for a custom report.  I need a % of Salaries & % of Revenue to show in each column.  Below is the result.  T&B % should calculate off Salaries & % of Revenue calculates from Total Payroll Expense.    

I need to access the highlighted grouped values in one of the report. But I am not able to find a way through that. Can anyone help me here regarding this ?  

Hi, we have customized the SO641010 (Sales Order) report. We are accessing attributes from the Stock Items Screen according to the inventory item in the sales order line. There is a new requirement, that if a Sales Order is in open or closed state then these Attribute Values can't change (should be the previously set value) if that particular Stock Item's attributes are changed to a new value. How can this requirement be satisfied?The join used is attached below.

When I tried to open IN61500 in the report designer I get the following error.  We are on 2022 R1.************** Exception Text **************System.InvalidOperationException: Data at the root level is invalid. Line 1, position 1. ---> System.Xml.XmlException: Data at the root level is invalid. Line 1, position 1.   at System.Xml.XmlTextReaderImpl.Throw(Exception e)   at System.Xml.XmlTextReaderImpl.Throw(String res, String arg)   at System.Xml.XmlTextReaderImpl.ParseRootLevelWhitespace()   at System.Xml.XmlTextReaderImpl.ParseDocumentContent()   at System.Xml.XmlTextReaderImpl.Read()   at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean preserveWhitespace)   at System.Xml.XmlDocument.Load(XmlReader reader)   at System.Xml.XmlDocument.Load(String filename)   at PX.Reports.Design.ReportDesignerLoader.ReadReport(IDesignerSerializationManager manager)   at PX.Reports.Design.ReportDesignerLoader.PerformLoad(IDesignerSerializationManager manager)   at System.Component

Hi all, I was just informed we still have allocated inventory from orders that were completed back in 2020. How do we ‘release’ this so we have correct inventory levels?Our inventory allocations jump from the end of 2020 to February 2023 so it looks like something happened 2 years ago that caused these allocations to become “stuck”? 

It’s helpful within a generic inquiry to be able to influence the navigation using the Navigation tab.Is there a way to similarly control the pivot table hyperlink navigation?Example:I have a derived field (OrderAndLine) used as the “Value” that we count in order to show the results in the pivot table.But there are some problems with the hyperlink that is auto-created by the pivot table. When we click on the number shown within the pivot table, a new tab called “DRILLDOWN” opens to display the drilled-down data. However, there are never any records in the DRILLDOWN tab.I can manipulate the filter within the DRILLDOWN tab and eventually show the required data, but I can’t expect an end user to do that.(I think the root cause is actually a data type issue unrelated to OrderAndLine; it appears to me to be a data type issue related to a Date vs DateTime field, but IMO not relevant for this question)It would be ideal if we could configure the navigation within the pivot table such that we c