Skip to main content

Reports and Generic Inquires

Reports, GIs, Dashboards, Pivots

  • 2,323 Topics
  • 9,272 Replies
2323 Topics
A
Jr Varsity II
aidenwills15Jr Varsity II
asked in Reports and Generic Inquires
Report Writer Formatting not working with equations

Hello all, Whenever I use an equation (apologies if wrong terminology) in report writer, the formatting field doesn’t seem to affect the actual result. In this case, it will always return 4 decimal points when I try to format it to return 2. Take note of ‘Payment Applied’ - you can see it returns 4 decimal points Whenever I use an equation (for example, the above), it ignores the formatting I have tried =###,###.00 , =###,###.## , =######.## , =######.00 , all with and without the quotations as seen above. Any insight into this would be great!

1202
A
Jr Varsity II
L
Freshman II
LungileNjakazi37Freshman II
asked in Reports and Generic Inquires
Report Designer: Show unit cost by period in separate columns

Hi Everyone. Once again I need your assistance. I need to show the unit cost by year on the report designer. Each year needs to be on a seperate column and all the unit costs for that particuar period need to show. The structure would be similar to the screenshot attached. Is this possible. So the report will need to adjust based on the number of periods. The max periods should be around 3 to 5. So each column would be a specific period and the data in each column the unit cost of the inventory item. What I need assitsance with is showing the periods input in the parameters as columns.

951
Laura02
Captain II
M
Freshman I
mcateFreshman I
asked in Reports and Generic Inquires
Reports on Country of Origin of Parts used in Production Orders

Is there a report I could run to discover what countries the materials consumed in a production order came from?

351
dcomerford
Captain I
H
Freshman I
helpdesk37Freshman I
asked in Reports and Generic Inquires
Report designer

Hi I need to design a QT from scratch, it’s suppose to take the format provided below in an excel sheet. Which tools in report designer should I deploy to achieve this and more specifically draw the tables? Regards

1301
Laura02
Captain II
A
Freshman II
ArleneFreshman II
asked in Reports and Generic Inquires
How to add Ship To Address State On a Sales Order by Customer Report

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

1042
A
Freshman II
M
Semi-Pro I
malinthawarnakulasooriya08Semi-Pro I
asked in Reports and Generic Inquires
How do we separate data into variables that come in a single data field?

Sub report​​​​ Used filters in the sub report Above 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 view Below image shows the DAC related to this. DAC I 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?

804
M
Semi-Pro I
P
Semi-Pro II
podonnell11Semi-Pro II
asked in Reports and Generic Inquires
Report Designer Mailing Settings Embed Image Formula Editor

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?

3811
P
Acumatica Employee
L
Freshman I
lwiemann17Freshman I
asked in Reports and Generic Inquires
GI used for Actual Revenue vs Budget by Qtr

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

1544
L
Freshman I
J
jericenero37
asked in Reports and Generic Inquires
Multiple columns in Report Designer

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 barcodes This 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.

2581
meganfriesen37
Captain II
P
Freshman I
prabhu83Freshman I
asked in Reports and Generic Inquires
How to check Tabular Report Columns statical split to page by page print

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

551
meganfriesen37
Captain II
P
Varsity I
psoni1585Varsity I
asked in Reports and Generic Inquires
How to add supplier bank account no in same format based on the supplier master--> Payment instruction

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.

1866
Chris Hackett
Community Manager
kdavis45
Semi-Pro I
kdavis45Semi-Pro I
asked in Reports and Generic Inquires
Visible Expression works for field, but not section

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?

1884
Chris Hackett
Community Manager
adamclarke
Freshman II
adamclarkeFreshman II
asked in Reports and Generic Inquires
ARDunningLetter.Deadline Field on Stock Dunning Letter Form AR661000?

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?

403
Chris Hackett
Community Manager
J
Varsity III
jwarrenVarsity III
asked in Reports and Generic Inquires
Calculating on GI for Sales Orders

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,000 Item 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?

663
aborisova37
Semi-Pro I
param2022
Jr Varsity II
param2022Jr Varsity II
asked in Reports and Generic Inquires
Combine report for multiple sales order

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

1222
miguel80
Semi-Pro II
T
Pro I
TharidhiPPro I
asked in Reports and Generic Inquires
Show Attached Notes in Line Level Records in Generic Inquiry

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.

4574
Chris Hackett
Community Manager
S
Jr Varsity III
srengdahlJr Varsity III
asked in Reports and Generic Inquires
How do I change the column header date format?

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!

1322
S
Jr Varsity III
A
Jr Varsity II
AidenMissionJr Varsity II
asked in Reports and Generic Inquires
Record not showing despite being found

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.

922
A
Jr Varsity II
R
Varsity III
rodrigocid34Varsity III
posted in Reports and Generic Inquires
Optional table relations for getting attributes values from items

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! :)

2062
Chris Hackett
Community Manager
H
Jr Varsity III
hgilbertJr Varsity III
asked in Reports and Generic Inquires
Removing Time Stamp from @WeekEnd Date in Reports

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

2202
H
Jr Varsity III
L
Jr Varsity II
lightmanJr Varsity II
asked in Reports and Generic Inquires
Export to PDF not working properly

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 PDF This 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 settings Could someone please help on how to solve this issue?

3084
L
Jr Varsity II
O
Jr Varsity III
oshadarodrigo64Jr Varsity III
asked in Reports and Generic Inquires
get some bank details to acumatica report

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.

820
O
Jr Varsity III
D
Jr Varsity II
dgrossJr Varsity II
asked in Reports and Generic Inquires
Report- adding a link to an image or making an image linkable

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.

2252
D
Jr Varsity II
S
Freshman II
swartzfegerFreshman II
asked in Reports and Generic Inquires
Need help formatting VisibleExpr for Report Designer

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"

1716
S
Freshman II
R
Varsity I
rmillerKimballVarsity I
asked in Reports and Generic Inquires
Business Event not triggering after activating Real-Time Order Sync

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

710
R
Varsity I

Go to

Discussion Forums
Financials
Distribution
Manufacturing
Construction
CRM
Field Service
Retail
Payroll
Professional Services
Low Code | No Code Customizations or Integrations
Develop Customizations
Develop Integrations with Web Services | APIs
Other Developer Topics
ISV Solutions
Configuration and Installation
Reports and Generic Inquires
Import and Export Scenarios
System Health and Performance
Community site discussions
Community Introductions
Everything Else
Technology Partners and Customers
News & Announcements
Product Downloads
Partner Forums and News

Tags

Most helpful members this week

Badge winners

  • Easy talker
    lorneweinsteinhas earned the badge Easy talker
  • Easy talker
    bodiechas earned the badge Easy talker
  • Import and Export Scenario expert
    Samvel Petrosovhas earned the badge Import and Export Scenario expert
  • Reports and Generic Inquires expert
    jhouserhas earned the badge Reports and Generic Inquires expert
  • Acumatica expert
    jhouserhas earned the badge Acumatica expert
Show all badges
Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved