Reports and Generic Inquires

I have a rather simple GI that uses PMProject and PMTran to break down Labor spending, per month, on each project. Then tools me what 4% of that labor cost would be. The problem I’m having is that it’ll say pages 1 of 14. Then when I click onto page 2, that will change to page 2 of 26. The data then becomes invalid after switching pages. Has anyone seen this before? Attached is the GI. Seems something weird with the conditions but not sure why. We are on Build 22.212.0046   

Hello,I am using the following function to combine the account # with the location ID, but somehow the function is creating a space on some of the records, why?This is the formula I am using, which is working for most of the records, however there are some that contain a space in between. =Concat([BAccount.AcctCD],[Location.LocationCD]) Please see attached screenshot.   Space between these records 

Hi All, We currently have issues adding the Bubble Nbr. from the Bill of Material screen to the Production Ticket. Not quite sure why it wouldn’t be showing in Production Order Details but that is a different story.It is basically blank, so I recreated a Generic Inquiry that mirrors the Subreport and played around with it.It does not seem to like the Link between AMProdMatl and AMBomMatl when it is an Inner Join. (Yet, it has to be an Inner Join to show the Bubble Nbr.) The inquiry is attached.Any ideas on how to link the two together that the Subreport and the production Ticket is displaying this correctly?My simple Test Inquiry is attached.

Has anyone successfully recreated the Inventory Transaction by Account as a GI? We want to get a Generic Inquiry where the Inventory Balance of the Balance sheet equals to the Inquiry Balance. The main issue in here is that we wanted to depict the transactions in the Generic Inquiry and at last, the balance should be equal to the inventory balance of the Balance sheet.  I’ve been trying to recreate Inventory Transaction by Account as a GI, but so far have remained unsuccessful.

Hi,Our company has several pivot tables we Export to Excel and then print out for record and approval. Is there any way of adding the company’s logo to the Excel Export for ISO compliance purposes? Alternatively, if there is any way of fitting a pivot table to a Report which we can add the logo through Report Designer, that would be great as well.

I am trying to do the following calculationQty on Hand / SoldLast30 Qty on Hand / Sold365AvgOn the screenshots below for 1. it should have Cover Qty LM = 1.363 and Cover Qty LY = 2.664 for the top line result. I cant seem to get it to work. What am I missing?ResultsGI  

Hi community,I am trying to solve the problem as below. Appreciate any comments and help would be really awesome.I am trying to print the barcode Code 128 for the following with application identifiers. My barcode still is not scannable for some reason. I have tried multiple things which doesn't seem its liking it.I am using a symbal scanner which accepts the below input but is not scannable for my vendors'400'+[SOOrder.CustomerOrderNbr]+'90'+[SOShipment.ShipmentNbr]I am using the following settings for my barcodes:According to GS1 (400) is customer PO number (90) is shipment number'(400)'+[SOOrder.CustomerOrderNbr]+'(90)'+[SOShipment.ShipmentNbr] Can I get some help on this one please?  

Hi, I am customizing the standard PO report to reflect information shown on the Approvals tab in the Purchase Order form, the approvals are shown in the footer of the report, therefore I use a sub report to display the approval information. At the moment, values are not displayed in the footer even though Approvals are listed. Please let me know how I can fix this issue.Thank you.

Strange issue with Business Event not firing if the underlying GI has a conditional on it.  Worked through all the troubleshooting guides I could find, and still stumped. I have a Generic Inquiry which is a simple join of the AMMTran table and the AMProdItem table:The relations are simple, just joining the shared keys of OrderType and prodOrdID:  And my conditions are straightforward, looking for Materials documents that linked to Closed production orders: And my business event is set to “Trigger by Record Change” with Raise Event set to “For Each Record”:This does not fire.  If I change my conditions on the GI to remove the status=Completed, it works fine (though it fires immediately upon issue of the materials, which is NOT what I need, as I need to do something with the Material once the Production order completes). I have tried it with “from schema” for the condition instead of the =’M’, so it’s not anything that simple. I’ve tried changing the Trigger conditions to be Record Inser

Hi, I need to do some enhance in ARM report, previously we use the switch function to insert each value manually to display the branch name + Tax registration ID, is there any other ways we can auto retrieve the data from the fields?  

Hi Everyone. I have a user defined field in a GI that pulls the employee ID. I want to get the employee name and email address in my GI. How do I go about doing this?

We’re looking for a way to send customers an open order status report - We think that some simple modifications to SO611000 would work great, however I can’t figure out a way to automate sending this report (filtered by customer) to the customers with their open sales orders If we save a template on the report, is there a way to utilize the automation templates and available filters to refine this to one email, sent to each customer on the report - filtered by only their open orders?  

Hi Team, We have a requirement where we have to print one report in 2 different sizes. Basically we are looking for a way where we can set the report labels dynamically with one size as 1''x1'' and other size is 1.5''x3'' inches. We are working with version 2023 R1 (build 23.105).Can you please suggest the best possible way to achieve it. Thank you in advance!

Hello, I am having issues with a data table coming through on a dashboard, I currently have parameters set up on the GI and have it pulling in the dashboard parameters as well. Any idea why it's not populating any data?Widget Properties:  Inquiry Parameters: Thank you,KT

Is there a way to see history of journal transactions against an invoice?Currently, if I have to create a journal for any reason, I put a note on the invoice to flag to myself that there is a journal transaction related to it. It would be great to be able to go into an invoice and see journal transactions directly related to it.

Hello,I am running into an issue where there is nothing displaying on the inventory transaction history inquiry for a specific item. This is not true as there is currently a closed receipt, bill, shipment, and invoice for this particular item. What could cause this?Thanks!

We do not have any facility in Acumatica Reports to convert Amount In words for Trillions.Eg : 5235460235892.85Amount In words : five trillion two hundred thirty-five billion four hundred sixty million two hundred thirty-five thousand eight hundred ninety-two and eighty-five hundredths. Do we have any solution for this In acumatica ?  

I have an amount in my report which is calculated by using a variable. I need to display this amount with the currency symbol next to it ($140.00). If I use ‘=[Currency.CurySymbol] +$InvcAmt’,in the ‘value’ of the text box, I am unbale to format the ‘amount’.The only way I am able to format the amount is to create a second text box in front of the amount for the currency symbol. The issue here is that there is now a space between the currency symbol and the amount ($     140.00).Is there a way to join the two where there is no space between the two, bearing in mind the number of characters in the amount can vary? 

As shown in the above screenshot, I want to modify the Invoice Status parameter so as to select multiple options at once, like Open and Closed status at once. So can I know if this is a possible feature in the report designer and if it is possible how to modify this parameter so as to accept multiple selections?

how is the best way to handle this situation?  right now we are going in and changing the ship to address with each shipment.  but if we ever have to go back to print a previous shipment we have lost the address that it was shipped to, which loses the traceability.  there has to be an easier way.1 sales order, with multiple ship to locations. - each line to different locations. thanks!

Good day,i need to make a slight adjustment to Acumatica AR Aging Report.  When I try to login from the server, I can get the below message.  User Name, login and password are all correct.  I try to load reports list too and received the same error.  I have admin rights.  I don’t have problems report designer when there is a report version available and able to save to the server.  Is there something different when you try to update an ACM OOB report?Any assistance would be greatly appreciated.Evan 

We have a GI that pulls all our stock items that were/ on a sales order along with their dimensions like Length, Width, depth using attributes.  We are using an attribute that has a prefix of ‘ID :’followed by the length dimensions. We would like the GI to only display the numbers and not ‘ID :’ We used substring function to only display the numbers. Substring function Since we are using an attribute in the substring function, we get the below error: ErrorIs it possible to split/ display only certain characters from an attribute?

i am trying to modify a report I want to add another layer of grouping for subtotals.  I want to add Group3.  I can modify group 1 and group 2 but cant figure out how to add a Group 3.  fairly new to Report designer 

I have our logo on the AR Invoice and it looks like it’s as far left that I can get it in Report Designer (aligned with the Bill To text below) but when I print it has space (not aligned with company and Bill To info just below it).What am I doing wrong?  

I'm trying to print in a thermal mini printer, and the rpx is fine while the report has only one page. The report heigth it is configured like a Letter size. But when the report has 2 pages, repeats the header and footer.I would like to configure this report like a continuos paper roll, is there a way to do this?