Reports and Generic Inquires

I have created a customized PO report and when I try to open the respective report in the Report Designer I come across this error, please let me know how to solve this issue. 

Hi Guys, I am trying to create a report for the inventory items through a catalog:I have gotten to a point where the layout is correct but I can’t seem to get the list correct in the sense that it is duplicating each item as above. The design:The relations:Filters:Does anyone have an idea of what the problem could be?

I have set the formula to count the margin, I’m not sure is the formula correct?=([Products.CuryUnitPrice]-[Products.curyUnitCost])/[Products.CuryUnitPrice]does someone know how to solve this problem?After I set the formula, it come out the error. “Divide by Zero error encountered”.  

I have a client that uses Subitems and I have modified some reports to show the sub item along with the inventory ID but they need the segment value description to print instead of the segment value. In this setup, there are 5 subitem segment IDs, e.g. W-AE-FRS-PA -1/10 where W = Wild, AE = UAE, FRS = Frescomar, PA = Panulirus argus and 1/10 = 1/10 lb. Is there a way to link by the subitem back to the individual segments and pull the description for any or all of the subitem segments that make up the subitem so instead of printing the subitem as W-AE-FRS-PA it would print as Wild-UAE-Frescomar-Panulirus Argus-1/10lb.

I would like to create a GI showing all the AP Invoices and AR Invoices for a custom table having a field called Housebill. I can get it to work showing only AP invoices or only AR invoices, but not both at the same time. I attached screenshots of the existing GI. Any help would be appreciated.

I have created a custom report that captures some calculations in 3 variables, in the footer area the totals should be calculated according to the second segment of the item class, how can I approach this development?Report OutlookSample Data 

Hello,       I’ve met an issue in 2020R2 as below: I created a Variable named FN to control the sub report visibility.If $FN=0, would display sub report “FNNOW”,if $FN>0, would display sub report  “FN”, As math tells, the two conditions above can not be both true at the same time It is working as expected when showing on screen or export to PDFBut when exporting to Excel， both sub report are displayed at same time. I don’t understand, is it a platform glitch?

I have an “On Hold” AP Bills Generic inquiry to present same in a dashboard.  I tried to use the two example expressions in the Style column of a Generic Inquiry for APInvoice.Due.Date to shade invoice due dates pink (bad) when an AP Bill is past due.  However, what I’m getting is pink (bad) only when the DocDate and DueDate are equal dates or when the DueDate is blank (example: for a Debit Adj).   Here are the two Style IIf statements that I tried. =IIf([APInvoice.DueDate]>Today(),'good','bad')=IIf({APInvoice.DueDate]>@Today,’good’,’bad’) Looking for the correct Style expression to shade the APInvoice.DueDate pink (bad) when an AP Bill is past its due date.  Thank you.

This is a copy of my question posted in Everything Else, which I realise should have been posted here.We are attempting to retrieve a report using the SOAP Screen API, but the report we are getting back is blank.  The version of Acumatica we have is Build 20.112.0035.I have the following code:public void PrintReceipt(params PurchaseReceipt[] receipts){ client.Logout(); var screen = new Screen(); try { screen.CookieContainer = new System.Net.CookieContainer(); screen.Url = Properties.Settings.Default.AcumaticaERP_PrintReceipt_Screen; screen.Timeout = 10000000; var lResult = screen.Login(LoginDetails.name, LoginDetails.password); var schema = PX.Soap.Helper.GetSchema<Content>(screen); foreach (var r in receipts) { var ReceiptNo = r.ReceiptNbr.Value; Command[] commands = new Command[] { new Value { Value = "Receipt", LinkedCommand = schema.Parameters.Type }, ne

I have created a report where it is based on the Sales Order Screen, requirement is to print each line detail on separate pages, but in my case the first page only prints when I preview the report but when I export to PDF all the pages show up, when there is more than 1 record. I have attached the report for clarity. 

Oh developer titans of myth and legend, I beg of you… PLEASE find the cause of random primary lists (GI’s) magically disappearing as the result of an upgrade.  This has been going on for several major versions… I think 2021R1 marks the 3rd major release to pain me so with this problem.There seems to be no rhyme or reason that I can find.  When we perform an upgrade on any of or production, testing, or development instances, we never know what GI is going to be missing.  This time, a fresh instance of 2021R1 with nothing but Sales Demo and a very small customization for a blog post lost the Purchase Orders primary list with the upgrade to 21.104.0018.  The workaround is the same every time.  Go to another tenant of the instance or to another instance and export the GI to import where it is missing.  I know there has been discussion on this in the developer community.  Since I cannot reproduce it at will, there is nothing I know to report in opening a case.  When our sysadmin did some re

Report Designer: Parameter Display search does not work properly.I have 3 parameters, but one of them is not fully working.Build of parameters:Display CorrectSearch with the Char “P”. Shows Nothing.Search with the second digit of the actual TaskID. Display Correct.Obviously, I shouldn't have to search with the Task ID but with the Task CD. Please help, any suggestion will be appreciated.Thanks!

Hello.  We are trying to create a dashboard widget from our AR Overdue categories.  We created a Pivot table widget which summarizes the outstanding AR balances by current, 1-30, 31-60, 61-90, and over 90.  How do I turn the sum of these categories into a dashboard widget ?  Thanks,Gwen

 Hi,I have updated the check (AP641000) to include the signature on Checks from Cash Account. Relationship: -Picture box property set: -  However, when I print the check from process screen (AP505000) with multiple checks and combinations of Quick Checks and Checks, it does not print signature on all checks.Not sure if that is the bug or if I am missing anything.Please suggest. 

Hello AllI am sorry for this question but I am new with Report Designer so I do not have much experience.I was trying to create Generic Inquiry for production data and financial data which are no related (cost amount from account that is not related to Production itself). There could be applied Doc Issue data as the key but I do not think it is rationale and reliable key.Therefore I was thinking of making 2 separate tables in Report Designer - 1 with production data and 1 with financial data for same specific period. And then I would like to have 3rd table where I could make some simple mathematical calculation taking data from both 2 first table.Is it at all possible in Report Designer?I would be grateful for any support. Thank you in advance.Malgorzata

When I try to do AR Print Statement I got error message Error: The report does not contain parameters: StatementMessage.Please advise on how to solve this issue. Thanks,Idrus

Hi, We have a field that allows for multiple codes to be selected. These codes are attached to descriptions in a table. There can be up to 20 codes in the field and the codes have differing lengths.The field ends up looking like COC; DC & CT; First Article Samples My task is to have the descriptions associated with each segment print on the PO form. I am unsure of how to process the field to get the descriptions. or how to do the join to the table that has the description. Any assistance will be appreciated!

Hello--Does anyone know where or how to edit the column names on a Data Table widget?Right now it derives them automatically from the results of the GI.  Thank you!!!! 

Hi, I am trying to convert a pre-existing report to a generic inquiry. Most of the hurdles I have managed to figure out, however I have gotten stuck at the formula for a balance.The formula is as follows:I would like to know why I can’t find [ARRegister.SignBalance] in the generic inquiry. Thanks.

Hi Acumatica community!I have a column chart in a dashboard that shows sales by month for individual customers. The column chart only displays months with sales data, which is a problem as many of our customers order every second month or quarterly. See example below.If there are no sales in a given month, I’d prefer that the chart showed zero (a blank space) for that month. This would make it much easier to see the relationship between sales and time.Is that possible in Acumatica? 

HI, I created a copy of the PO Form, P0641000 as PS641000. I made a change to the new form to print the discount percent rather than the discount amount at the line level.  This form has been added to the site map and works. When I try to add the new report as the default Purchase Order on a vendor, mailing settings tab, I am getting a message that the Report cannot be found in the system.I think I am missing a step somewhere to allow forms that begin with PS to be used. I have done this with other Acumatcia site, but have changed the name to begin with PO & not PS. Is there a way to allow a form beginning with PS to be used??Thank you 

I am customizing the Sales Order Report in Acumatica (so641010.rpx) and there is a requirement to convert [SOLine.CuryUnitPrice] to USD given that the unit price is not already in USD, and also currency rate type should be MONTH rate (rate type ID in currency rate types form) and currency effective date in the same month and year range of the Sales Order Date [SOOrder.OrderDate]. I created the joins and values to be picked as follows,SOOrder Left CurrencyRate2 → =Month(OrderDate) Equal Month(CuryEffDate)                                                      Year(OrderDate) Equal Year(CuryEffDate)=IIf(([SOOrder.CuryID]<>'USD' And [CurrencyRate2.CuryRateType]='MONTH' And [CurrencyRate2.FromCuryID]=[SOOrder.CuryID]),+IIf([CurrencyRate2.CuryMultDiv]<>'Multiply',[SOLine.CuryUnitPrice]/[CurrencyRate2.CuryRate],[SOLine.CuryUnitPrice]*[CurrencyRate2.CuryRate]), '-' )At the moment the column always displays ‘-’, so I need verification if this is the right method to carry out conversi

Is there a way to not allow 0 (zero) Qty in the Sales Order screen? 

I want to generate a generic inquiry that will list stock items and then all of the sub items for that stock item. is there an easy way to accomplish this? 

Is there a place I can override the background color applied to an active Pivot filter.  Acumatica default seem to be applying something derived from the primary color override for the active Company or Branch.  In our case it makes the active filter indistinguishable from the non-active filter, causing much confusion with our users.  I don’t need to match the theme, just need to know filter is active.Any alternative (i.e. changing color of text and/or funnel icon) would be acceptable also.