Community
Discussion Forums
Reports and Generic Inquires

Reports and Generic Inquires

Reports, GIs, Dashboards, Pivots

1,995 Topics
7,815 Replies

When you subscribe we will email you when there is a new topic in this category

1995 Topics

Recently active

Most replies Most views Newest first

vpanchenkoTeam Lead, Reporting&Core

posted in Reports and Generic Inquires

OData v3/v4 plans and migration — need your feedback

Dear partners and customers,Currently, we have two OData endpoints:~/odata, which is GI-based, uses the OData v3 protocol, and has been with us since the 5.1 release; it is widely adopted in various ISV solutions ~/odatav4, which is DAC-based, uses the OData v4 protocol, and was released in 2020R2.The OData v3 protocol slowly becomes obsolete in favor of OData v4. For example, some .NET client libraries stop supporting OData v3 at all, and .NET Core/.NET 5.0+ supports OData v3 only in the compatibility mode with some restrictions.Because of that, we’d like to collect feedback on the OData v3 endpoint usage (GI-based, located at ~/odata route) and ask some question on what protocol-related features you actually use. As you may know, the default payload format for OData v3 is Atom XML (Accept: application/atom+xml or $format=atom). OData v3 also supports JSON in two forms: a regular one (Accept: application/json or $format=json) and a verbose one (Accept: application/json;odata=verbose o

1 year ago

paula012Semi-Pro II

asked in Reports and Generic Inquires

Report List

Hi all,Anyone please, is it doable that these highlighted parts disappear. I want it to appear once and the next be blank for the other items when multiple items are under the same transaction. I appreciate any help. Thanks!

1 year ago

hthuy24Jr Varsity II

asked in Reports and Generic Inquires

How to show field Currency rate on report designer ?

Hi everyone,I want to show field currency rate in report designer but I dont know how to do that? If you have any idea, pls advice me.Thanks in advanced.

1 year ago

ray20Captain II

asked in Reports and Generic Inquires

Can we filter/Sorting GI lines by highlighted color

Hello， I wrote a GI for our company to hightlight the lines using the below formula： =IIF([ARTran.Qty]>[INSiteStatus.QtyOnHand],'orange40','default') It works OK. However, you see, we are having 36 pages,And if the management team would like to view the on hand qty below period usage qty lines,he have to click 35 times to view all pages.Is there a way to filter out the lines by the highlight colors? I am thinking out add a new column with value : [ARTran.Qty]-[INSiteStatus.QtyOnHand]However [ARTran.Qty] should by SUMwhile [INSiteStatus.QtyOnHand] is by AVGThis column won’t get the expected result.Any suggestions?

1 year ago

kirbygompf32Freshman II

asked in Reports and Generic Inquires

Sort Production Orders Report Problem

When printing multiple Production Orders (using Print Production Orders process), I want to be able to sort all the orders by the Workcenter in which they start. The reason is so production orders can be distributed to each work center without manually sorting. The default is to sort by Production Order ID. I am playing with the sort properties but not having much luck: I have tried to change the property from [AMProdItem.ProdOrdID] to AMProdOper.WcID:I’m not having any luck the sort order remains the same sorting by ProdOrderID. Any help is much appreciated. thank you

1 year ago

wfilipiak67Captain II

asked in Reports and Generic Inquires

One user cannot view an added field on a GI

Hi, To the Shipment PL, SO3020PL, I added the table SOOrderShipment, Joined from SOShipment via the Shipmemt.NoteID to the SOOrderShipment.ShipmentNoteIDI am trying to get the Sales Order Number. This is working great for all but 1 user. That user cannot see the column. The user can access Sales Orders & Shipments. They have the Administrator Role. I tried doing a reset to default Configuration I log in as that user & can customize the GI & can see the table/ join & field on the Results Grid. But when I view the GI , as them, the field does not display. It is also not listed in the Column Configurator.There are no errors in the trace. TIA, Bill

1 year ago

mike2665Jr Varsity III

asked in Reports and Generic Inquires

ERP Admin

How do I add a hyphen in Report Designer between 2 fields. Trying to end up with this; Address - Number. +IIf([ShippingAddress.AddressLine1]<>null,[ShippingAddress.AddressLine1]+ - +[POOrder.OrderNbr]+'{br}','')

1 year ago

RManathungage94Freshman I

asked in Reports and Generic Inquires

Line Detail Values are getting Duplicated in the report

Hi,I wanted to get sum of all values in CASplit.CuryAmt field to display the Total Amount.these are the two tables that I wanted to get the line detail values.CASplit CAAdjAnd this is the new join I put to get the line detail values. And this is the condition to get the Total Amount=Sum ( [CASplit.CuryTranAmt] ) But when I run the report, it duplicates all the value details in CASplit.CuryTranAmt field and added to the Total Amount.Does anyone know what causes this issue and how to fix it? Thank you.

1 year ago

hthuy24Jr Varsity II

asked in Reports and Generic Inquires

Why is the item order not printed in the order entered on the PO print screen (PO641000)?

Hi everyone,I have a question with Purchase Order that the order of the rows is reversed, I want the lines to be printed in the order they were entered. I use the print version of the system and have not edited anything.Pls advice me if you have any idea.Thanks in advanced.

1 year ago

Jov29Freshman II

asked in Reports and Generic Inquires

EPApprovals and EPEmployee Relationship

Is there a way for us to create a generic inquiry, for this two table. Currently my project on the company is to set an approval map on the Sales Quotes based on the total amounts, and when printing the quote, the Approver name and their E Signature will be shown on the report. I want to use the subreport to get the approver name on the main report on the sales quotes. But my problem is how can i get the E Signature to be shown on the report.

1 year ago

TechtehtechFreshman I

asked in Reports and Generic Inquires

Unapplying debit adjustments

A debit adjustment that was created from an invoice was applied to the wrong invoice, how can I unapply it or move it from one invoice to the correct one after it has been released?

1 year ago

paula012Semi-Pro II

asked in Reports and Generic Inquires

Unsure where to put what

Hi! I’m new to using Acumatica Report Designer and I still don’t get where I should put table headers for example. In this picture, the highlighted part is what I want to be my first set of columns (and I need three sets of columns). Then I encircled this columns’ respective contents. Where do I put them? I tried to put it in the detail section, then tried putting my next set of columns in another page header section and tried changing places too but I can’t get what I want. I want my first set of columns to list down all contents before showing me next page (2nd set of columns) then next page again (3rd set of columns). I don’t even know if I’m making sense to anyone right now. Thanks for your help!

1 year ago

bjeter94Freshman II

asked in Reports and Generic Inquires

Change the color background in report designer on the AR 641000 invoice/credit memo report, share the same text box

I have a client that needs the Credit memo background color to be the same as the AR invoice, blue not red on the 641000 reports. Please advise. I appreciate any assistance. Thank you,Barbie

1 year ago

PaulMainard55Varsity I

asked in Reports and Generic Inquires

Avalara Tax Details Table

I feel like I should know this but, does anyone know in which table the Avalara Taxes are stored? I know that the ARTaxTran does not actually store the taxes generated from Avalara, even though they appear in the Taxes Tab on the AR Invoice. Does anyone know where this data is stored in the DAC layer, if anywhere?

1 year ago

ALEXSLUSSER15Freshman II

asked in Reports and Generic Inquires

SOLine.NoteText not printing

Hey all,I’m working on the Production Ticket with Barcode report. I have added SOLine.NoteText but it is showing up empty despite the note on the line item having text in it. Any solutions?

1 year ago

cmorelandSemi-Pro II

asked in Reports and Generic Inquires

Combining QTY On Hand from multiple Warehouses

Is there a way to combine qty on hand from multiple warehouse’s to come up with a total qty available in a GI? We have a use case where we want to look at two warehouses as a whole. (I know I could create a location as well but that would require a lot of inventory shifting.)

1 year ago

danielleallisonFreshman I

asked in Reports and Generic Inquires

Access Rights for Email Notification

Hi there! We are trying to clean-up who has access rights on each screen based on their access role. We have a couple generic inquiries that are for email notifications and I’m curious what would be a good role for those notifications (without restricting access to the current email recipients). Additionally, if the access rights should be set to Not Set, Revoked, View Only, Edit, Insert or Delete. An example would be like the image below. ACU will send out an email notification if an expense claim has been rejected. Which access role and access right, would be appropriate to assign in this scenario?

1 year ago

ALEXSLUSSER15Freshman II

asked in Reports and Generic Inquires

Grouping line items

Hey all,I’ve been working on the production order performance report for about two weeks now and am nearing completion with it My current issue is that it is printing separate line items for each inventory ID within a work order, when I would rather it sum the line items into a general work order. How do I achieve this?Thank you!

1 year ago

ketillerJr Varsity III

asked in Reports and Generic Inquires

Vendor Table connection to Attributes

Hello,I am trying to create a report using the Vendor table, I was wondering why my attribute is not populating. I can locate the attribute name within the table and know information is populated, but when I select that data field, everything is showing up blank. Some screenshots below:1 - Screenshot of GI results grid2 - Screenshot of attribute profileThank you,KT

1 year ago

TharidhiPSemi-Pro I

asked in Reports and Generic Inquires

Add Line Details from Transaction Details Tab in Transactions Form to Standard Report

Hi, I am trying to customize the standard report CA Register Detailed (CA624500.rpx). I am trying to get the line details in Transaction Details tab of the Transactions form (CA304000) to the report. I have used the following join but it results in duplicates. Please let me know how I can avoid that.Thank you.

1 year ago

TharidhiPSemi-Pro I

asked in Reports and Generic Inquires

How to Show Information in Footer Based on Line Item Inventory Item's Attached Attribute

We have a custom report based on the Invoices form where data needs to be picked to the report footer to show a summary of the line items. The Inventory ID field has an Attribute called HSCODE in the Inventory Form (there are 4-5 fixed HSCODES)Based on this information if the line items of the invoices have the same HSCODE for different inventory items, we should cumulate their totals, but if the separate lines have different UOMs we should show that as well. What would be the best approach to achieve this result? The expected result would be something like this in the footer section.

1 year ago

patriciabatisti2Freshman I

asked in Reports and Generic Inquires

Unwanted page break ARM reports

Hi eveyone, I am getting some unwanted page breaks on my ARM reports and I have not set any page break. The page break is added when I print it as A4 - landscape or portrait formats. Any ideas on why this is happening? Thanks, Patricia

1 year ago

ALEXSLUSSER15Freshman II

asked in Reports and Generic Inquires

Line Items Looping in Report

Hey all,I’m working on modifying the Production Order Performance report. I had some issues with it repeating lines yesterday, but ended up fixing them. After making further changes (necessary ones) it has started looping again. I can’t repeat the same solution, as the solution would simultaneously undo the changes as they conflict. It has to do with the relationships of tables. A screenshot is included below. I need to have the AMProdEvnt and AMMTran tables involved. They are necessary for the changes I am making. I don’t know how to properly configure them as to not cause looping. Any help is greatly appreciated.

1 year ago

JaneHewFreshman I

asked in Reports and Generic Inquires

Generic Inquiry Screenid changes to ScreenId=00000000

Hi All, How to prevent the Generic Inquiry Screenid changes to ScreenId=00000000 ? How to remain the Screen ID then go to New Screen ID if perform the GI (Untick & Tick) at the option for below.Make Visible on the UIExpose Via OData

1 year ago

ketillerJr Varsity III

asked in Reports and Generic Inquires

Account Details - recreation GI (No account filter)

Hello, I am trying to export account details for the whole year 2022 by a specific branch for all accounts. on the Account details inquiry (GL404000) we have to include an account, so I was trying to recreate the screen as a GI where we do not have to include an account. I can get all the information in the GI besides the Beg. Balance and the End. Balance, any suggestions on how to get that information?Data class: GLTranRData field: SignBegBalance Screenshot of Account details screen:Thank you,KT

1 year ago

Page 59 / 80

Badge winners

nhatnghetinhhas earned the badge Low Code | No Code Customizations or Integrations
johnh3has earned the badge Easy talker
andriitkachenkohas earned the badge Configuration and installation expert
andriitkachenkohas earned the badge Integrations and Web Services | APIs expert
andriitkachenkohas earned the badge Reports and Generic Inquires expert