Reports, GIs, Dashboards, Pivots
Recently active
Hi all,I am struggling with a report filter, when I attempt the below filter I am only receiving about 20 results and the GI has 370. Any suggestions? Thank you,Kage
@Irina or someone, I am looking for advise/KB articles or anything else that can help me determine why a report is running so slow. I know it could be the joins, subreports etc but I am hoping for someone to point out the typical culprits.My report takes about a minute + to run, has two subreports and only a few tables that are joined as recommended. Any assistance would be greatly appreciated.
Hello all,I am attempting to add a salesmen parameter to my AR Aging report so I can run that report as it is relevant to each salesman. I have attempted to add a parameter, however it still returns all invoices, and not just the invoices based on the salesmen entered into the parameter. Here is how it is currently set up -As stated, the report returns all invoices regardless on the salesperson ID entered into the parameter. Thanks all!
Hi, In the Result Grid Tab, when i add a column and I set it to the attribute, it show the Attribute description by default. How to show the Attibute Value ID instead of the Description?I already tried a lot of workaround like Attibute.Value without any succes.I don’t want to use “schema field” because i will need to put this in formula .My starting point is from the Non stock list PX.Objects.IN.InventoryItemThanks
New InvoiceI created above Commercial Invoice report by using the ar641000.rpx.Below screenshot shows the relevant parameter and filters used for this invoice report.Used Parameters Used FiltersBut when passing the reference number as the report parameters to generate this Commercial Invoice Reports, the Balanced status type Invoice reference numbers not show in the “Select-reference number” list. Please check the below screenshots.Sales order Invoices ListStatus type Balanced Ref Numbers Not FoundBut I want to display all the reference numbers in the Sales Order Invoices in the section of report parameters “SELECT-Reference Number” . So please give me some guidance to overcome this issue. Thank you.
Hello,I have this long error message upon accessing server in report designer (opening from folder is okay, but opening from server or saving to server gets an error).Does anybody know how to resolve this? I cannot use Report Designer for sometime now. Please help.Thank you in advance! See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box.************** Exception Text **************System.Xml.XmlException: Root element is missing. at System.Xml.XmlTextReaderImpl.Throw(Exception e) 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.ControlHelper.GetDataFromConfigFile(String filename, List`1 logins, List`1 urls) at PX.Reports.Design.ControlHelper.ReadConnectionHistoryFro
Hopefully a simple question and answer. When we click the magnifying glass in the Item field of the Sales Profitability Analysis Detailed Generic Inquiry it only displays Nonstock items. If we enter an Inventory ID (Sku) directly into the Item field it show “No results found If we leave the Item field (TAB, Mouse into another field, press <Enter>) the actual item shows in the item field and the GI displays the analysis for that itemIf we click on the magnifying glass in the Item field it only show our NONSTOCK items.If we enter a finish goods Inventory ID in the the Search box the results are Nothing has been found for “<Inventory ID>’ I have looked through the GI and don’t see any place where the Inventory ID is limited to NONSTOCK items. Has anyone else run into this or know how to correct it?Thank you!
I have a GI that has several calculated fields. I need to take the qty on hand from one Warehouse and add it to the qty on hand form another to show total qty on hand.I tried grouping by inventory ID however this causes issues in my calculated fields.Example Error: “Column 'INSiteStatus.QtySOBackOrdered' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.”
I have a GI that uses the Soline table. There are a couple of custom fields basically some boolean values I would like to update. Is there an easy way to add them to the mass update list?
I am looking at the Issues GI I would like for the Returns to show negatives. Would someone be able to give me directions on how to make this work. I am trying to balance our inventory daily and really do not want to have to export it daily and change the numbers to negatives. This is the balancing that we are doing each day to balance. BEGINNING INVENTORY, BAL SHEET, April 30 PLUS: RECEIPTS PLUS/MINUS: ADJUSTMENTS PLUS/MINUS: ISSUES LESS: COGS NET INVENTORY INVENTORY BALANCE SHEET, May 31
Hello,I have an integration with a 3rd party EDI provider into Acumatica.I need the ability to compare the incoming EDI (derived from non-standard Acumatica tables) total amount of the EDI sales order with the Acumatica sales order total amount. Example:EDI sales order total = $50 (data stored in custom tables)Acumatica Sales Order total = $51Print this record on my new custom report because the sales order TOTALS don’t match. Discounts are involved which are causing the discrepancies I need to report. I have written a report that accurately reports the Sales Order number and the total from the EDI tables.I intend to use this as a subreport.The total is in a group footing as it sums up the individual lines of the order.This part works. I can write a main report that will accurately calculate the total of the actual Acumatica sales order.However, this too will have the order total in a footer as a subtotal. (main report) So I have a subtotal on a group in a subreport that I want to com
We enter Quote Lines the move them to a different Sort Order. We desire to print our Quotes in Line Sort Order, not Line Order. When reviewing Line sort options in ScreenId=SO641010 I noticed only Line Number Ascending or Descending, not Line Sort Order. Is there a way to Print a Quote to be the same as the Entry screen appears after changing the Line Sort ?
I’m stumped...can anyone tell me why all my checkboxes are grayed out on my GI? I’ve got Admin permissions on the GI and can make changes to everything except the checkboxes.
