Reports and Generic Inquires

I’m having trouble exporting to PDF from acumatica. The main issue is, I’m using Khmer fonts, and the are not showing up on the exported PDF. Also, the table size gets mismatched. I have seen the threads that talk about Korean and Chinese fonts not working, and the official answer was to change the font to a microsoft supported font, I tried that. It did not work.This is the original report This is how it should export to PDFThis is how it’s coming out. Please note that the Khmer language fields are all blank. Also, the tables are not coming out right in the exported version and if you look at the logo, it’s all messed up. The entirety of the logo is a PNG file, but it’s getting butchered when exported.These are the PDF settingsCould someone please help on how to solve this issue? 

Hi, this is a report modification. I need to get below bank details of DetailValue column to my ARInvoice. These information are taken from CashaccountPaymentMethodDetail DAC.For a particular CashAccountID, Detail Value is changed based on DetailID from 4545 to 4549 as above.ex: if DetailID=4545, Bank Name      if DetailId=4546,  Account number….And also it depends on the PaymentMethodID as well. If I made an expression to retrieve DetailValue Based on DetailID,  It only retrieves the first value which is the Bank Name. I need to get the DetailValue per each DetailID from 4545 to 4549. Can someone help me with a solution to do this?Thank you. 

I need to make the APPLY NOW linkable in PDF.  I tried adding a text box with a url and placing it over the image as transparent but it doesn’t work.  If I drag the text box to an empty area it works fine.  Any solutions would be appreciated...thanks.  

Hi all,I need a visible expression that if an item is active (“AC”) then the font is normal (black), if it’s active with a pop up note print it blue, and if it’s inactive (<>”AC”) print it red. I’m messing up my expr somewhere: =[InventoryItem.ItemStatus] = "AC" and [InventoryItem.Note] is not null, "Blue", [InventoryItem.ItemStatus] <> "AC", "Red", "Black" 

I recently turned on Real-Time sync to Prepare & Process Sales Orders in Acumatica. I tested this in a sandbox environment and thought I caught everything, but I missed that it is not longer triggering the Business Event I set up to send customers Order Confirmations.We have 2 Reasons for enabling the Real-Time sync:Provide the customer with an email confirmation quicker than the scheduled automation task was providing (We send through Acumatica instead of BigCommerce to provide the customer with the Acumatica SO#) Orders with Multiple Shipments were only ever getting the first shipment synced back into Acumatica. I tested this in our sandbox and Real-Time sync was consistently syncing all shipments for every order.Is this a known bug, and would there be something in my business event I could update to send an order confirmation email out on a record creation, but make sure it doesn’t send multiples on any changes?*note: Sandbox was tested in 2022 R2(22.214.0019) as we will be upgr

There is a Sub report in my main report. When  I export the main report to Excel, the value from the sub report does not export. But sub report data also appear when the main report export as a PDF. So can I know how to overcome this and export the main report with sub report data to a excel? Thank you.

I created restriction groups based on item classes, and I see all prebuild reports follow the restriction rules and don’t show up the items for users outside the groups.However, I created some GI’s on the PO line table and SO line table and it does show up in these reports all items even outside of the users group.is there anything I'm doing wrong that the system doesn't follow the restrictions on my reports?

I am at my wits end and need another set of eyes.  I have a PO Receipt subreport that prints exactly as I need it, but when I add it to the main report the values are not printing.  I have tried every conceivable combination of PRINT=ALWAYS / WHEN READ and moved the subreport up and down sections  I know it is picking up the subreport because I am getting a textbox value.  I have changed the grouping and sections and am missing something so simple, I know, but I just can’t seem to find it.  Attached are the reports if anyone can help.  Thanks.    

Hi,How to call multiple value on Barcode? Currently, I have configured the report to print barcodes for each value. I have try using concat» CONCAT([ARInvoice.CustomerID],[ARInvoice.CustomerID_BAccountR_acctName]) and set variable to call multiple value however not successful.Is it possible to setup report designer to call multiple value on barcode? Thank you

The system names all the PDF’s ARInvoiceINV.pdf for the Invoice report AR641000. Has anybody tried to change this to include the invoice number in the report? Or does anybody know if this is possible. For example, can we change it to ARInvoice12345? Or something like that….

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.  

Hi Team,I am working with 2022 R1 (build 22.106.0015 ) and I have created a custom Action button on Sales Order screen and wanted to add this button to a GI Mass Action. Is it possible to add this button as GI Mass Action, if so can you please suggest the best possible way to do that. Please find below details for reference:Action Button: public PXAction<SOOrder> CreateKit;        [PXButton(CommitChanges = true), PXUIField(DisplayName = "Create Kit", MapEnableRights = PXCacheRights.Select)]        protected virtual IEnumerable createKit(PXAdapter adapter){return adapter.Get();} I want to add the above button on below GI Mass Actions: Thank you in advance!