Reports and Generic Inquires

How can I add the ship to State to the Sales Order by Customer Report - or any sales order report? Thanks

Sub report​​​​Used filters in the sub reportAbove sub report was created to get the bank name, bank code and branch code. All the different data come under a one data field as below. Please check the below images.Sub report viewBelow image shows the DAC related to this.DACI want to assign the Account Value column data corresponding to the 4545,4546,4547,4548 and 4549 ID shown in the above image to separate variables, in order to send them to the main report. If is it possible, can I know how to accomplish my task?

Hello Everyone, I am trying to create a email template to be used when sending out an email from a payables report. I wanted to embed both the vendor’s name and a logo of our company on the report. The problem is that I cannot do both on either the notification templates screen or the report designer mail settings body section. If I use notification templates, the vendor account name does not show up as the screen I am using does not appear in the screen selection. Does anyone know if it is possible to embed an image in the formula editor?   

The Controller DB, has a widget that uses a GI for Actual Revenue vs Budget by Qtr.   It is not correct…Any Suggestions?

Our client wants to have a report that can be split into two columns in one paper page where each column has different details from different barcodesThis is from Production Order Details screen and when there is two lines that is checked for print barcode, the report must show 2 columns with different details from it.Example:Question:Is it possible to achieve this one? If yes, how?I am very new to Acumatica so it will be kind of you to answer my newbie question :)Note: Every column has different barcode so it has different details too.

Vendor 1 and Vendor 2 need to show page 1, then vendor 3 and 4 need to show page 2.but other details show same format

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