Reports and Generic Inquires

In this report I have added the sub report and I want to add the page break after the details section after every subreport. It appears that it is fetching all the data correctly if I set the page break to none for the details section without any page break. If any page break is added it fetches only the first record. Can anyone help here to solve this thing.Thanks.

ARM report export to excel/pdf function not working for certain branches.  I am able to export to excel/pdf for some branches but not all.  I have already restarted application and that did not work. 

I would like to create my own generic inquiry that links the RelationGroup table to the Users table - I’m guessing that there is an intermediate table that I haven’t found yet.  The goal is to have a generic inquiry that gives me all the restriction groups that the users belong to.  If you have managed to do this, I would be grateful if you could share some insights!

Hi all,We have a CIA/Proforma customer and want to print an invoice with a specific sales order line. It’s a blanket order and would like to print one invoice for 50% up front, then the second line for the final half.Could I modify this screen to print a specific sales order line? 

I am trying to use business event to schedule delivery email. After following the process of creating a GI, adding the notification template, linking a business event, and scheduling the automation schedule, the emails are still not being sent out, and it’s not executing. Has anyone encountered this issue before or knows how to go about solving it?    

I am trying to run an Odata V4 query but have not been able to get it to workThis simple query works fine:"URL/odata/Tenant/IN-StockItem?$filter=substringof('TestItem', InventoryID) eq true" But when i add the v4 part, it does not yield any results."URL/odataV4/Tenant/IN-StockItem?$filter=substringof('TestItem', InventoryID) eq true"Is the above V4 syntax wrong?Is there something that needs to be enabled in order for Odata V4 to work?I ensured the user has the ODatav4 User ( Access to data exposed via OData v4) role assigned.  

Hello all,My GI for Purchase receipts is currently doubling the Qty and the Amount. I am unsure how to correct that issue. Attached is the GI in questions. Any feedback would be helpful. Thankyou

Does anyone know of a report that shows how much of something we have ordered over a large period of time? Looking to see what are most used material is and average cost we are spending on it. **Not sure if this makes a difference, but most of our orders are drop ships, so this wouldn’t be reflected through our inventory.  

I am trying to add the SOLine linked AMProdOrdID to SO641010. According to the DAC Schema Browser, this is within SOLine table. But, it’s not showing up in the available fields in report designer.Anyone have any ideas?

I have created a business event and it is working fine. Now I want to attach my custom report in the mail that is triggered by the business event. I added it as an attachment and provided the required parameters but it is not generating exact report. Some details are missing. If i generate the same report on the report screen it is working fine.  

I have attached a static form to our PO that will print with the PO on vendors that we purchase ingredients from. I created a page break on the group footer and the PO prints on the first page and the static form prints on the 2nd page but the page 1 of 1 footer in printing on the 2nd page but not the first page. And when I add multiple lines to the PO to push the PO to print on a second page Acumatioca renders 10 pages and my static form prints on several pages. I have attache images for review, and my Report Designer settings for the footers. My end goal is to print the PO first and the static form letter last, as well as adding multiple lines to push the PO to a 2nd page to only print a 2 page PO and the 3rd page is my static form. Please check out my report designer setting to see what I need to change to make this work. 

see this is my sample. total amount is 3,350,000.00. but visible expr condition row amount also add to subtotal.

Hello,I am adding a parameter to a working GI.I check the box “From Schema” on the parameter.There ARE records and values for this field and I show them on the output.If I set a default value on the parameter it works for the default.I simply cannot select a value for my parameter from the database which is the whole purpose of “From Schema”.Any thoughts? 

Does anyone have any ideas on how to add backordered items to an Invoice? These would be zero dollar lines for visibility purposes only.We have the Add Zero Lines for Items Not in Stock checkbox checked on the Sales Orders Preferences (SO101000) screen so we get the following behavior: 1. Create a Sales Order where the first 2 lines are available, but the 3rd line is not available: 2. Create a Shipment and all three lines are carried onto the Shipment, even though the 3rd line is not shipped: 3. Create an Invoice and only the first two lines are carried over. The 3rd line disappears since it didn’t ship:

Can I know if there is a way to print data in detail section inside a grid in a report like in the below image?Expecting grid format in the report detail section 

I’m attempting to add a new Vendor via the REST API. I receive the error:DiscTakenAcctID: 'Cash Discount Account' cannot be emptyThis is a required field located under the GL Accounts tab. However, the field does not appear when getting the list of Vendors via the REST API. How should the JSON be structured to include this field when adding a new Vendor via the REST API?

I have a generic inquiry that I am using an IIF statement in the Results Grid to add and populate a column in the GI results.. The statement is as follows:=IIf( [SOInvoice.DocDesc] = 'ROLLER', '050116', ' ' )What I am running into is there have been a few time where the SOInvoice.DocDesc containers more than just “ROLLER”, it might have ROLLER - xyz. When the GI is run this field is empty if the parameter of ‘ROLLER’ isn’t exact. Is there a wildcard available in Acumatica like the * in VB?Thank you!

I am going through the S130 Data Retrieval and Analysis, second lesson. We are going through setting up the Navigation Targets and Parameters. There are three Navigation Targets, AP303000 - Vendors,AR303000 - Customers, and CR303000 - Business Accounts. The Window Mode is Side Panel for all three. Selecting any of the Navigation Targets, such as the AP303000 - Vendors, Navigation Parameters is set for AcctCD, Parameter BAccount.AcctCD has been set, Icon is the directions car (all set up in accordance with the video). When I attempt to save my work, an error pops up stating:Error: ‘NavigationScreenLineNbr’ cannot be empty.

Hi all, trying to hunt down an issue.We have this value in our Inventory Item on our Order Verification Report:=IIf([SOLine.InventoryID]<>Null, Format( '{0}: {1}', [SOLine.InventoryID],[SOLine.TranDesc]),[SOLine.TranDesc])So far so good.I duplicated it a few times as we want the item to be formatted with a different color depending on conditions. If it’s an inactive item, format red. Normal item, black. If it has a popup note, format it blue.Items usually format as they should. But I’m having occasional issues where an item with no popup note is still formatting blue. Here are the visible expressions:=[InventoryItem.NotePopupText]='' and [InventoryItem.ItemStatus]=’AC’ and [InventoryItem.ItemType]='F'=[InventoryItem.NotePopupText]<>'' and [InventoryItem.ItemStatus]=’AC’ and [InventoryItem.ItemType]='F'=[InventoryItem.ItemStatus]<>’AC’

I made a daily "Automation Schedules" with "raise business event" type.Is it possible to execute it  only from Monday to Friday but not on Saturday and Sunday ?

In our production process, we have the following dates (simplified view):Production Start Date: Feb. 3 Build Date: Feb. 10 Production End Date: Feb.20 The build date is always 5 business days after production start date. I’m trying to build a GI that will list out these dates but I don’t seem able to create a formula that does AmProdItem.StartDate + 5 Working Days. I can do AmProdItem.StarDate + 5,but it will include weekends. Is there anyway to do this but exclude weekends? Or anyway to incorporate one of the work calendars into this calculation?

My whole entire file has been wiped from the server and I don’t know how to get back. I need my production ticket back.

Hello,This is just one item w/ multiple serial #s. What statement do I write in each column to not show if its for the same item? Specially the LineNbr. Thank you! 

Hi all How can I include both unit original cost of inventory and its unit landed cost on inventory valuation report.I tried to do it , original unit cost is being displayed but the original unit cost/adjustment is not being displayed. 

I have worked considerable time with the report designer. But this is the first time encountered this issue. I modified the AR631000 report by adding some new columns. It worked nicely in the preview. But when I'm trying to publish the report as a new version by “save report on saver” option, process is getting successful without any error. But the new version is not in the instance. Please check the below images.Saving report to saver New version not foundUser access also rechecked by me. It is also in fine status.