Reports and Generic Inquires

I have a custom field on a shipment report that I would like to read horizontal not vertical. Has anyone done this before?Value 1 Value2 Value 3 Value 4…notValue 1Value 2Value 3Value 4

Hey all,I’m working on the Invoice report and want to integrate the ARTran.NoteText. I’m not sure how to join it in the schema to get it working. I’ve tried a few random solutions but it always prints blank. ARTran is already joined and other items from ARTran print fine- but ARTran.NoteText doesn’t.

Hi all, I’ve got this line which mostly works: =IIf( InStr( [AMProdStep.Descr], 'MESH' )<0, IIf( InStr( [AMProdStep.Descr], 'ADHESIVE' )<0, True, False ), False) We don’t want anything with ‘ADHESIVE’ in the product description to print and it works fine. But now we have one adhesive type we do want to print, let’s say ‘BLUE ADHESIVE’… how do I restrict all adhesives from printing but allow BLUE ADHESIVE to make it through the expression?

I have been following the exported file name thread.  Our client is wanting to change the exported file name on several reports.  I have been looking for a resource to give me some direction.  On the PO I tried doing  =Format( 'PurchaseOrder {0} {1}',[@OrderType],[POOrder.OrderNbr],[Vendor.AcctCD])And it would not give me the vendorid in the file name.  Are there directions or examples that I might follow?

Does anyone know of a way to combine all the detail values for a grouping in a single field on an export scenario or generic inquiry?For a shipment export, the 3rd party software requires a single line for each shipment, with details about each individual package sent in the column & row, but separated by a ‘|’ character.  So, if the shipment included 3 boxes, our “Shipping Weight” column might show “5.0|2.5|10.0” to export each value.   

Has anyone built a GI to show a list of stock items that are back ordered?Allocation Type - SO Back OrderedInventory Allocation Details - Screen ID IN402000 is a start. But it’s filtered by item.What we would like is to show all items, qty, and SO reference number that are current Allocation Type - SO Back Ordered.

In Sales Profitability, there are logical parameters ‘Released transactions’ and ‘Completed Transactions’. What’s the difference? I tried multiple checking by dates. The same. Can someone pls explain? Thank you!

All, I have a report where we are reporting on a four year range. So something like this: Date A from: → Date A to:Date B from: → Date B to:Date C from: → Date C to:Date D from: → Date D to: I need to have the 3 previous years/parameters setup like “@Today-1Y” “@Today-2Y” etc.In Report Designer, I’m unsure how to modify the expression to display the previous 3 years in the dropdown menus. Here are the screenshots from Build Schema:  

what is the reason why Audit History is missing? even though in access rights by user set to view only and also Access Rights by role set to view only, thank you hopefully some people can reply to this . 

I am attempting to add InventoryItem attribute(s) to SOLineThe report I am editing is SO641010.rpx I have added the table InventoryItem with the following join:SOLine - Left - InventoryItemSOLine.InventoryID - Equal - InventoryItem.InventoryIDI think this is correct, but have not been able to test it yet. I would like to add the attribute to SOLine, but do not understand the syntax.=IIf([SOLine.InventoryID]<>Null, Format( '{0}: {1}', [SOLine.InventoryID],[SOLine.TranDesc]),[SOLine.TranDesc]) How can I properly add attribute(s) with a line break {br} to this syntax?I found the attribute ID after adding the table and making the relations [InventoryItem.BRAND_Attributes], but not sure how to correctly add it to: =IIf([SOLine.InventoryID]<>Null, Format( '{0}: {1}', [SOLine.InventoryID],[SOLine.TranDesc]),[SOLine.TranDesc]) Thank you for your help

Hi All, I am having an Issue where I want to have a more detailed Inquiry that is still referencing back to a normal Transaction such as a Sales Order or Shipment. I basically started out and created copies of the Sales Order and other Inquiries, made my changes for Fields and Conditions and exposed it to the Mobile App.Now, I run into the Issue that it is barely showing a very limited Result Screen rather than the Sales Order, the Shipment or others.Please see below for Screenshots.The issue is that major functionality such as editing or taking actions on the Transaction is missing.Does anybody have an idea on how to fix this? Any Settings I am forgetting on the Inquiry Creation itself?Inquiry “Result”Native Sales Order Inquiry “Result” 

In Generic Inquiries, we can use Aggregate Functions & Grouping to sum values based on similar key fields, which is a great feature to present summarised data.Is there a similar way to aggregate rows with the source schema tables in Report Designer? It appears that ‘groups’ in Report Designer refers to grouping sections, and does not appear to perform any aggregation.

I am trying to calculate the number of work days (Mon - Fri) between 2 dates in order to work average daily sales etc. I came up with this and it seems to work but feels clunky. =(DateDiff('d', [PeriodStart], [Now])) + 1 - DateDiff('w', DateAdd([PeriodStart], 'd' , 0 -(DayOfWeek([PeriodStart]) -1)) , DateAdd([Now], 'd', 2 - DayOfWeek( [PeriodStart]) )) * 2 - Switch((DateDiff('d', [PeriodStart], [Now]) + 1) % 7 > 0 And DayOfWeek([PeriodStart]) = 1, 1,(DateDiff('d', [PeriodStart], [Now]) + 1) % 7 + DayOfWeek( [PeriodStart]) = 8, 1,(DateDiff('d', [PeriodStart], [Now]) + 1) % 7 + DayOfWeek( [PeriodStart]) > 8, 2,True, 0) Appreciate if someone has something more concise. thx

Hi, we are testing to upgrade to 2022 R2 and if there is =NULL in the GI parameter, it is giving an error. But in our 2021 R1, this works. In the example below, I have the =NULL in the branch so it shows all results (not auto fill branch) then be able select what Branch we would like. This is in 2021 R1In 2022R2, I get the error below. If I remove the =NULL completed, it auto fills in with a branch. Does anyone know how to fix this so the parameter starts out blank, then we can select which we want? 

Is there a way to find out the quantity reserved?  For example, if Sales orders are not completed yet then is there a quick way for Inventory staff to identify the quantity being reserved for any particular items?  Or the same thing applies to stock transfer from the main warehouse to the retail stores; How do we find out the quantity in transit.?  Thanks...

Working on creating a shipment cut GI, and I would like to know how I would add a condition that only shows me lines that SOShipline.Orderqty does not equal the SOshipline.Shippedqty.  In other words I don’t want to see if an order was shipped complete only the ones where the ship qty does not equal order qty. Thanks

Hi everyone,As everyone knows, we have an excellent process on Acumatica regarding EFT in Canada, where we can send notices to the vendors about their payments. So far, for me is excellent, but I would like to insert one step more if possible.I want to see if all the emails are correct; due to this, I would like to know if someone knows if exist a report in this process where we can see all the emails about the batch that will be proceeded and be sent to the vendor.This way I'll be sure that everything is ok.If I can help you with anything else, please count on me.Have a great week guys!! Emir Nelson Calaidoemir.calaido@caronbusiness.com

I want to modify the Project Balance report screenId PM621000. How can I find the report that i need to change There is no inspect element option available for the screen.

I created a generic inquiry to show all credit notes as per serialized sequence.On viewing the Inquiry I noticed 9 of them are missing, maybe they were deleted, this may cause problems in auditing.Kindly assist on how I can retrieve them. Urgently need you help.All responses will be appreciated.

Hi,Has anyone been able to add a parameter for “Paid with” to the expense claim details report? Thank you,KT 

Hi!I am trying to add the Vendor Class ID as a parameter on the AP Register Report - AP621500, the Vendor Table is not on the report.  I am not sure what relationships I need to create when I add the vendor table.  Any help would be appreciated. Thanks,Coleen

Hello,I have modified an AR report to give details on ar discounts.  One of the parameters is the discount code.  It works, but I want the user to be able to select the discount code rather than type it in.The little magnifying glass doesn’t appear next to the box where you enter the value.When I add this into the View Name, the parameter disappears when I run the report.ARDiscount is not used on the report, but I thought I could use it to select the code the user wants. 

Hello,I have a generic inquiry of SO Shipment Lines and I’ve added a condition that limits the Inventory Ids to only those that start with “GENPSY”.I’ve also added a parameter for the Inventory Id to allow users to select a specific item.My issue is that I would like for the lookup for the parameter to also only show items that start with “GENPSY”, so that users don’t have to look through the entire stock item list.Is it possible to filter a parameter? This is my parameter: These are my conditions:  On the results screen, I would like for the parameter lookup to only show items that start with “GENPSY”: 

On certain items we ship out and include on a Pick List, our teams will modify the description on the Shipments screen.We want this modified description to appear on the Pick List. I am bringing in the SOShipLine.TranDesc but it still shows the InventoryItem.Descr instead? In example below, we have modified the description on the Shipment screen (image A). We then Print Pick List, however the description shown remains the original description associated with the inventory item (image B) - not the description per inventory item on the Shipment. I have modified the Pick List in Report Designer so it displays SOShipLine.TranDesc (image C) - but it still doesn’t show the correct description. Image A  Image B Image ​​​​​C 

Has anyone come up with a good way to report on “time logged in” for a user.I think it’s a challenge with a web application like Acumatica because you aren’t really “connected”. As far as I know, Acumatica just knows the last time that you interacted with the system.There is a “timeout” feature so Acumatica must somehow maintain the last time that you interacted with the system so it can require you to login if your last interaction was too long ago according to the timeout setting in the web.config file.But I want to report on “minutes logged in” for each user.It would be cool if Acumatica tracked when it “logs you out” according to a period of inactivity, but I don’t think that’s how it works. I think it only works according to the “timeout” feature described above.Looking at the data in the Access History (SM201045) screen, I was initially thinking to count minutes between an Operation of Login and Logout, but it appears that Acumatica only records a Logout Operation if you specific