Reports and Generic Inquires

I need to display the dollar amount of Debit Adjustment(s) applied to a payment on the Check Remittance.  How would I do that or is there an existing report that shows this information that can be sent to a vendor.  This data is needed to inform the vendor why the payment is less than the invoice.

The quick question: Is there a list of the Transaction Type 3-character codes for inventory transactions (INTranDetail DAC) or, more generally, a way to view a field’s value before it is translated to the display version? As part of a larger Generic Inquiry that brings together a variety of inventory-related statistics, I am attempting to create a ‘Most Recent X Date’ column for several of the different transaction types, such as Most Recent Receipt Date and Most Recent Transfer Date. However, I am unable to filter to the desired transaction type in a formula without knowing the codes. [INTransfer.TranType] = 'Transfer' Doesn’t work, as the DAC Schema shows that the field is only 3 characters, but gives no list of what those codes are. I had to do something similar with Cross Reference codes and thankfully another po

I am trying to add report to the Acumaca customer portal and having error as follows. Any help appreciated Server Error in '/AcumaticaERPPortal' Application.Error: You don't have enough rights on 'CR632072.rpx'.Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.Exception Details: PX.Data.PXException: Error: You don't have enough rights on 'CR632072.rpx'.Source Error:  Line 317: }Line 318:Line 319: var pars = PXReportRedirectParameters.UnwrapParameters(passed);Line 320: passed = PXReportRedirectParameters.UnwrapSet(passed);Line 321: Source File:

Would anyone know why a GI would not allow the ability to use a Sum function on a specific line for the Total Aggregate? Every other line has the ability to select a dropdown and choose a function - this is the only line which does not.   

We just started using the CRM functionality in Acumatica. We were previously on a much older, on premise CRM. I have a high level sales manager who wants a GI that would allow them to search both leads and contacts at the same time. I showed them the global search but they felt it returned too much data from all aspects of the system to be useful.What I would like is to create a GI that did a Union or something like it on the Contact and Lead tables that would allow a simple search by Display Name (Contact table) / Lead ID (Lead table). If anyone has any insight on how this might be accomplished or if there is some other approach that will allow for simultaneous searching of Leads and Contact I would greatly appreciate it.

I am trying to figure out why the ‘Outstanding balance’ line is printing rather than =$InvcAmt00 and =$Balance00. this has not been altered since we adopted ACU so I am unsure why it is behaving strangely with a specific check. does anyone have some information on what it is looking at for that visibility expression line in the title?

Hello,Long story short, I have certain items that have zero quantity, but are still showing a cost both on our inventory reports, and the GL.  This is from the Historical Inventory Valuation report - in aggregate, it balances to the GL.  There aren’t any other issues with Warehouse/Branch/etc - it all relates to the costs not clearing properly.Here we can see where it starts.  We receive 7 of this particular item for $85.11, but when it’s sold, it’s relieved from inventory for $81.81, leaving the $3.30 with 0 qty.The next month we can see that $3.30 carries through. Looking at the Inventory Transaction Details, the purchase in August matches the Inventory report, but i

Hi, All I am trying to trigger event that is to send email when ever udf is updated with new value. The UDF is in the Customer screen as shown below. I have already created a business event and email notifications and I tried adding UDF with API but still no emails. Is this generic Inquiry Relation issue or something else?   

Is there a way to use the shortened month name in a GI? I’ve tried using =MONTHNAME([ARInvoice.DocDate]) which gives me the full month name. I’ve tried using =MONTHNAME(‘mmm’,[ARInvoice.DocDate]) and that gives me an error stating invalid token at position 12 (or whatever the number is). 

Hi everyone,I’m hoping this is a relatively simple question. I’m working on a Project GI and trying to set a condition that only includes projects with a booked sales amount greater than $1,000. We store the booked sales amount in a User Defined Field.The issue is that this field is a Text field, which causes problems when applying conditions. I’ve created a calculated field in the Results Grid that converts the text to a decimal (DEC) format, and I use this field for calculations and filtering in reports and dashboards.What I’m looking for is a way to handle this conversion at the Conditions level, so I don’t have to apply filters manually to every report and dashboard going forward.Thanks,Chris Lower

Hello all,I am attempting to utilize the Assign function in Report Designer to sort a series of variables.The basic concept is:=iif($Thing1<$Thing2,Assign( '$temp', $Thing1 ),'')=iif($Thing1<$Thing2,Assign( '$Thing1', $Thing2 ),'')=IIf($Thing1=$Thing2, Assign( '$Thing2', $temp ),'') While this works if Thing 1 is indeed less than Thing 2, as soon as Thing 1 is greater than Thing 2 it fails.I have been trying to trace the problem, and it seems that the Assign function is being triggered even if the first part of this IF statement is false. It is populating the $temp variable with a new number, when it should just do nothing.=iif($Thing1<$Thing2,Assign( '$temp', $Thing1 ),'')I have each section of the If statements above in a new group header, because I cannot utilize an assigned variable within the same section.I have double checked the values after each step to pinpoint the

Hi, I have a customize report, in which I am using two parameters one is order type and second is order number. In the second parameter field we want to show only those order which are approved currently system is fetching all the orders. attached screenshot for reference.    

As an exercise to learn Report Designer more, im trying to make a simple report from scratch. I’ve done some googling and reading here, but can’t seem to find the answer.The report is a BackOrder report i want to send to certain customers using Business Events. I have the GI Made and is working great. My report is coming along, Im running into a snag where its not showing all line items for the “Order Nbr.” but Im unsure howto get it to display correctly. My assumption is its the way I’ve formatted the expression editor for this value? My next problem is i can’t quite get the lines to group together cleanly, there is always a gap. 

Hello,I need to find the total number of calls performed by person by week in GI. I have added the following fields in grouping. Is Count the right function to be using?  

I am setting up push notifications for our salespeople who want to get notified when they have a new lead that is assigned to them as the “owner” of the lead How do I go about making the push notification and genric inquiry?

Hi Team,We made some changes to the customized report. The report displays correctly when previewed in Acumatica (see Screenshot 1); however, when exported to PDF, the bold font does not appear as expected (see Screenshot 2). Despite setting the same font size for the fields such as 'Services,' 'Bill To,' and 'Bank Details,' there is a noticeable difference in appearance. Specifically, 'Services' appears darker, while 'Bill To' and 'Bank Details' appear slightly lighter in the downloaded PDF.Could you please review this and suggest a solutionThank youScreenshot1:  Screenshot2: Screenshot3:

We have a GI called AR-Daily Sales History. We would like to, by using an IIF in the following manner. =IIF(LEFT([ARInvoice.RefNbr],3) = 'INV', 'US', IIF(LEFT([ARInvoice.RefNbr],3) = 'INT', 'INT',IIF([ARInvoice.OrigDocAmt] < 0.00, 'CRM'))) If the RefNbr starts with an INV then its a US invoice, if INT then International. That part is covered. The issue starts when we get to the Credits. There are some credits that the RefNbr starts with an INV which makes it US but then the DocType is a Credit Memo but because of the INV it still comes across as US. Using the last line in its present form, I get an error message: “Index was outside the bounds of the array”. I’ve also attempted this coding: =IIF(LEFT([ARInvoice.RefNbr],3) = 'INV', 'US', IIF(LEFT([ARInvoice.RefNbr],3) = 'INT', 'INT',IIF(LEFT([ARInvoice.RefNbr],2) = 'CM', 'CRM',IIF(LEFT([ARInvoice.RefNbr],3) = 'INV' AND LEFT([ARInvoice.DocType],5) = 'Credit', 'CRM', 'CRM')))) which still co

This one is pretty open ended, so please feel free to share. No issue is too small.

We are trying to make a weekly report containing multiple unrelated data. Currently, we want to bring in cases as a subreport to a inventory report. Is this even possible? It seems like subreports need to connect via a related table. Is it possible to bring in a subreport completely unrelated to the main file?

I have been asked to produce a form that prints the total of a collection variable on page 1 of the form, page 1 of the form will print detail lines 1 - 10, then text boxes for collection variable total, form verbiage and signature boxes. Page 2, 3 … will print detail lines of the SOShipLine with the collection variable calculated with each line.  I thought this could be accomplished with the WhileRead on the collection variable and WhilePrint on the detail sections.   I have placed a visibility expression on the detail section to print the required text boxes at bottom of page one, but this section prints for every detail line.  It appears the visibility expression isn’t working.  I haven’t been successful finding online documentation that guides the usage of ProcessOrder WhilePrint for detail sections.   

We have two different GI’s, one called AR-OE Export which is legacy data from an old ERP, and the other one called Ar-Invoice History. Both of the GI’s have been set up the same way as far as naming the fields are concerned. What we would like to do is combine both GI’s to form one dataset and have parameters to choose year and month and turn the results into a pivot table. We’ve looked at the WYATT.ERP method and it doesn’t seem feasible in our case to pursue that line of thinking.

We want to list all customers with Mailing ID “STATEMENT” and associated report ID. However, the GI only shows about 35% of the customers.How can we ensure it includes ALL our customers with the “STATEMENT” mailing setting?Here is a screenshot of my current GI setup.Thanks for your help!

Scenario:I have created a report based on Backlog report - Named as Backlog report by subaccount.For one customer or subaccount data is not showing in the report.But it should show in the report because the report is capable to display the december record as well.For ex:- I have created a SO with commit date 31st december it is not showing the Backlog report by subaccount.But when i change the SO commit date as 30th december it is getting reflected but with other amount it should display proper data. Screenshots:When the Commit date change to 30th DecemberIt is showing some other data when select commit date as 30th December ins

Added Production Order Operation CD as a parameter/filter for AM625010 to print on necessary operation materials and barcodes. It works, but I am struggling to make the Operation CD a lookup so the user does not need to reference production details to find the right Operation CD. I have tried =Report.GetFieldSchema('AMProdOper.OperationCD,ProdOrdID') but that did not work. I’m not familiar with how the GetFieldSchema works, but I assumed it had to do with the parent table. Any help is appreciated rpx zip file attached.

Currently I’m facing issue in “Print Labels”. Please refer the image below:When I click on the “Print Label” button. It gives me a message “The operation has completed” ,but I can see this is getting printed. I mean not even in print jobs either. I think I’m missing something here.Can anyone help me here?Thank you.