Reports and Generic Inquires

Hi, I’ve added supplier bank details in the supplier master GI, but bank account number is not displaying in the same format as per the supplier master payment instruction. so how we can solve this.I would really appreciate, if someone can help me on this.         

I’m trying to build two ‘alternate’ sections:Limited space that only shows “Continued” (if the details extend beyond one page) Visible expr: =([PageIndex]<[PageCount]-1) Larger space that shows the full subtotals (intentionally the second-to-last page for terms & conditions at the end) =([PageIndex]=[PageCount]-1) If I apply the visible expressions to the group, it does not appear on any page.If I apply the visible expressions to the individual fields, it appears as-anticipated (though this defeats the purpose). Additional information:The ProcessOrder is Always in both scenarios The PageIndex and PageCount are definitely calculating in both scenarios Both are GroupFooters that are setup to PrintOnEveryPage (with the above exceptions, if I can get them to work)Any ideas? Suggestions?

Doing some editing work on stock Dunning Letter Form, but can’t seem to figure out how to manipulate the ARDunningLetter.Deadline field that is showing up on my Dunning Letter. Looks like it is adding 3 Days to ARDunningLetter.DunningLetterDate, but not sure where that additional 3 day setting would be coming from? 

Trying to modify the Sales Order GI so it calculates partial price (ignoring or subtracting one of the line items on the Sales Orders). Is this possible? Example:SO100038 - Total Order Price of $10,000Item A $2000 Item B $5000 Item C $3000 In my GI, I want to display an adjusted price column that is calculated by taking total Order Price - Item C Price resulting in an adjusted price of $7,000 per this example. I can perform joins to bring in the SOLine detail but not sure how I would be able to subtract the correct line item?  Any thoughts?  

How can we combine all the sales order report (so641010) within a specific date range. I want to merge so641010 report based on a date range on order date. If five order are placed on a particular date I want all 5 report for individual sales order (so641010) to be combined in a single one. Any ideas how it can be achieved ?Thanks

Hi, is it possible to show attached line level record notes and files in the generic inquiry? We have a custom form with a simple form to record data. Even though a note is already attached it’s not shown in the generic inquiry end. Please let me know how I can show the attached note in the generic inquiry as well. 

I am trying to create a comparative balance sheet report and the columns currently have the year (2023, 2022) for the headers.  The report is ran as of 5/31/23 so I would like the column headers to be 5/31/23 and 5/31/22.  How do I change the column set format so the date pulls as of the last day of the period?  Thank you!   

Hello,I have made a new generic inquiry to help with warehouse staff, the last screen they wanted was to show shipments that have been sitting for more than 24 hours. Easy enough since I added a a calculated column to see how long a shipment has been waiting. See image bellow.I then made a new filter and added the new condition: However the result I get is this: And there is 1 shipment that is over 24 hours old, and in the bottom left hand corner we can see that Acumatica is finding it, just not showing it.What is also weird is that if I change the filter query to “Less than” 24 hours, it does show every shipment that is less than 24 hours old! So I dont know why “Greater than” and “Greater than or equal to” is broken. Any advice would be greatly appreciated,Thank you. 

Hi,If someone is having trouble using the attributes values in the inventoryitem table (inventoryitem.AttributeCreated), you could use the CSanswers and CSattibutes tables to get them. Greetings! :)

Hello all,I am working on a report in which I want to display receivables based on the week ending + one week.I am using this formula for the column heading=Concat( 'Week Ending ', DateAdd( [@WeekEnd], 'w', 1 ) )It does exactly what I need, however it displays the time stamp at the end of the date and I would like to remove this. What is the best way to do this? I tried using Left String to cut off after the date, but depending on whether the day and month have one digit or two this would be either 8, 9, or 10 total characters so it’s not a viable solution.=Concat( 'Week Ending ', Left( DateAdd( [@WeekEnd], 'w', 1 ) ,8)) How can I format the date to only include dd/mm/yyyy format without the time stamp?Thanks in advance,Helen

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