Reports and Generic Inquires

Hello Community,I have been trying to create a report where I would like to display the below highlighted fields in my report:  And have the following relations established: How can i put up the condition to only display the type=Subcontract and the description from the Subcontracts screen?Thanks in advance.

Hello team,I have added one UDF field in the projects form, but its values isn’t getting displayed in the report:  I also tried using the INNER JOIN between PMProject.AttributeAuthorize & AuthRepres.BAccountID; PMProject.AttributeAuthorize & AuthRepres.AcctName but it displays the same result as above.

I am trying to filter the results of a report based on the below filters However, it is calculated field in the table as shown below:  I am using the same formula on the filters tab like below:    However, on the report - it does not list the items that are aged between 45 and 90 days ONLY. Can you please advise what I am missing here? thank you@lauraj46, @Robert Sternberg - any ideas? thank you!

We have a report that has text box with nothing but information on where to call, or order items online. The text box reads: Questions? Call 123-456-7890 | (yes that is a pipe symbol included) Order Online at www.company.com. For some reason it is throwing an error. I have tried using single and double quotes in various places but still no joy. 

Having a issue joining FSARTRAN in a GI with ARInvoice and ARTran - does not show as related table and can not add manually.  Yes - Field Service is enabledWhat am I doing wrong?  

Hi, I tried to modify our Check Report to show more line under remittance. But it stop at row 12. Try to add more variable but do not know what I missed because it still does not work.Can someone help me with it ?Thanks  

I am trying to write a GI that shows when there is time activities that are not included in a Time card that is released.If a timecard is corrected, I need to eliminate the old card.There appears to be nothing on the header EPTimeCard that can help me to do this.The old timecard has a TimecardType or Normal and no reference.The New timecard has a TimecardType of Correction and a reference to the old time cardA non-corrected type card is the same as the old one.I tried to create a join using TypecardType to elimate refs where it is “Correction” but I get an error message Error: The virtual field TimecardType cannot be used in a condition expression.Is my only method to look at the PMTimeActivity field IsCorrected and then just create a grouping?

what installation missing this package, but other package is working.this package have only screens is show it. other left menu not displayed

Dear Acumatica Community, I was wondering if anyone knows how to force the system to print the additional remittance every time a check is being printed?The best I could do was set the line per stub in the payment method screen to one which will trigger the additional remittance when there are 2 lines or more in my check stub. However, I would like the additional remittance to print even if there is only 1 line in my check stub:Is this possible or is there any code changes I will need to do? Thank you, Choenho

Hello!I am new to the KPI dashboards and I am hoping to utilize the dashboards that are provided by Acumatica to its full potential. Can someone please explain the capabilities of the dashboards in relationship to KPIs? As well as the best way that I can implement this in my company. For background information, I work for a medical reseller company that services the Los Angeles, Orange, Riverside, and San Bernardino counties in California. We mainly service nursing home facilities and have contracts with VA hospitals around the area. Any insight and tips on how to utilize the dashboards are most appreciated. Thank you!

One of our clients noticed that our GI-backed functionality (retrieving PMProject.Description) was always returning the values for English, whereas they also had a French localization set up.They would have preferred to see the results in French. Is there a way to retrieve localized values through the OData interface of a GI, or is it something that is not supported at all? 

I am trying to use the following statement of a Data Field in the Results of a GI.=iif([PrevPDO.EffectiveDate] >= '2023/06/24',[EmployeePDOHours.PDOHours]-[PrevPDO.HoursUsed],[EmployeePDOHours.PDOHours]-SUM(Iif([PMTask.TaskCD] = '10',[PMTimeActivity.TimeSpent]/60,0.00)) + [EmployeePDOHours.HoursUsed] )When I run the GI it errors out with a GROUP BY clause error.However, when I take out the SUM(Iif([PMTask.TaskCD] = '10',[PMTimeActivity.TimeSpent]/60,0.00)), I can run the GI without an error, but it does not calculate what I want as I need to include the SUM of the time activity based on that Task ID.    I can put that SUM(Iif([PMTask.TaskCD] = '10',[PMTimeActivity.TimeSpent]/60,0.00)) into another GI Results row and it returns the correct value, so it IS a correct forumla.  It simply does not want to work inside of that other IIF statement.  Is there something I can do to make this work?(If there is even a way to create a GI variable with that SUM value and then referenced in the II

When a shipment is confirmed, the shipment confirmation report no longer shows all of the backordered items.  How can I make this report show all backordered items from the parent sales order, regardless of whether the shipments are confirmed or not?I thought I could achieve this result with the filters on the backorder sub-report but damned if I can work it out. 

Is there a way to create a filter on GI to show the last seven days, last month, and to forecast next month? I know there is the @month and the @today parameter but couldn’t find a way to add days to it. I tried @today-7 and it does not filter the last seven days. 

Hi, Trying to build out a GI and needing some help on an IF statement. Here’s the scenario. If Qty in APTran more than 0 (red check), it will return data Inventory acc ID (yellow checks) else will return AP Acc ID (Blue Check). So, here is my formula:Receipt Account=IIf( [APTran.Qty]>0,[InventoryItem.InvtAcctID], [APTran.AccountID]) and  when applied it on Receipt Account field, it revert to “something else” value which shown above did not return as well as they taken individually. Need your advice on this problem.Thank you in advance.

On the Shipment screen, not all Sales Order lines will be marked as having a ship quantity.In effect, their shipment qty for the line = 0.How can I display those unshipped lines (ship qty = 0) on the subsequent AR Invoice form?

Hello - within the projects module I have 68 different tasks.  I want to clean this up a bit.Is there  a way to change the Task ID / Description?  Everytime I try it defaults to a new task. If / When I change the Task ID - does Acumatica retroactively update my projects?Eric

Hello, Currently attempting to create an aging GI by Salesperson, summarized by customer. Ran into issues with the group by trying to do this from a generic inquiry so I created a view\DAC to hold my data. This all works good, but the next thing I need to be able to do is update either customer notes or sales order notes for this customer. This is possible until I add my custom view that as the aging columns. Once that is added, it shows the notebook like its populated, but clicking on that comes up with a blank note and doesn’t save when entering text. Highlighted is the custom DAC:Results Grid:Columns showing notes, but when clicked it comes up with a blank note:Attached the SQL view as well. Any ideas or is using the custom view\DAC a lost cause?  

Hello Team,I want to print Orders section in Shipment Form, how can I do that? Thank you

After upgradation when we open “Goods in transit” report it is working fine in Sandbox after saving as server for live instance it is not working properly.1.  When we run this report in Sandbox Sandbox 23R1When we run same report in live   In Live InstanceWhen try to save it as server still not working  

I would like to create a Generic Inquiry that list Service Orders - not completed up to a specific time <= 7days, <=30 but >7days;  <=60days but > 30 days; <=90days but > 60days ..... and  can be filtered by supervisor. Would eventually like to turn into a dashboard.

Hi friends, I would like to create a parameter as a selection list.For example, if I have a list of customer Classes A, B, C and would like to generate a report for customer classes A and C.Thank you for your support.

Hello. I’m learning Acumatica, specifically Reporting now. As an exercise, I want to insert an image (PNG file) into a report Picture Box. There two Picture Box properties, Data Value and Data Source, for which I need more information. So, I am searching for documentation or help. Can someone point me there?Much thanks. Tom Morris

Team, I made this report worked up to show 1 branch (client has around 150 branches or more), and shows one account, but I need to show account by branch example 10100 by each branch it exist, I also modify a Trial Balance Detail by Branch, but i could not make the report to group by Account, as it would also group by subaccount (removed all subaccount grouppings and nothing), I dont know if somebody can help has worked something like this or can direct me on what I am doing wrong. Attached is the Report.

Hi, the petty cash voucher report can be printed after the user releases a payment. I want to print this report before releasing the cash transaction, but the report won't fetch the data unless we release the transaction.is there a way to configure this from the workflow?Thank you.