By using this website, you agree to our Terms of Use (click here)

GI with 2 or more different values • Acumatica Generic Inquiries & Pivot Tables • Acumatica User Group Forums (augforums.com) Try this technique...
SOInvoices are from Distribution and once released end up as a corresponding ARInvoice. ARInvoices are for invoices that don't generate in Distribut...
Did you confirm the security on the GIs - the OData user needs access to the queries.
If you want formatted output you need to use Report Designer, not GI.
Well all i can think of is using the Access History page. Set Operation to Access Screen and Screen ID starts with GI. That will give you the histor...
We do this with Dashboard widgets following this methodology:/p>
Any MYOB Advanced users reading this note that MYOB have removed the New User Welcome Email Template from the Email Preferences page. MYOB believe tha...
You can add the note text as a result column on your GI and display it on the Data Table widget.
Did you map the dashboard parameters to the GI via the widget?
Looks correct to me.
@timrodman Yes you need an IIf, but it's a very simple one.
You can use the [APInvoice.DrCr] field to make the sign flip formula trivial.
Perhaps an example might make your issue apparent.
Did you check the Trace output under Tools menu?
XML doesn't need line breaks to be valid. Can you share the original XML if not confidential?
Have you tried an XML validator yet?
I was just thinking of whatever XML validator google search found. eg. But what about the log file mentioned in your 2nd screenshot? That might...
Click on the link in the error message that opens the log file. You need to work out what is wrong with the data in the excel xml file. There should b...
Could you please screenshot the errors rather than attach the doc?
I think you can just multiply the amount by the field InvtMult to get the correct sign. You should be doing a SUM of the formula that does the multi...
It's not an issue from the application - the error message isn't in the source. Googling I found this:/p> It looks like an issue with your webserv...
Try adding one by one and saving after each. Has your system been customised? I've never seen that error before.
You can't do anything in an Import Scenario that you cant do interactively in the page. So you need to find out how to do it interactively before atte...
Try: =CDate([SOShipment.LastModifiedDateTime]) - CDate([SOShipment.ShipDate])
I added the period start and end dates to the query result and then used a filter on those columns: This is actually better as it limits the resul...
Yep just had this issue today. So frustrating.
@ddunn I finally got around to testing this and unfortunately still no notes when Grouping is enabled. I even tried including the relevant NoteID in t...
You need to prefix the string with an equals so it's treated as a formula. ie. ='StatusB'
@anita-munnich what was the error?
Only way i can think of is 2 import scenarios, one for those with conversions and one for this without. Or depending on how many items need the conv...
Here's an excerpt from a Suppliers import that i did which assigned remittance account details. Hopefully it might be similar for what you are doing. ...
Do you have a lot of cash accounts to import? This was one table that I've always configured manually as it didn't take long to do and building a GI w...
Did you try the help? General: Depreciation Tab: So the one on the General tab is the default for the Class. On Depreciation it's the actu...
No, not possible. Put a checkbox parameter in the report which you tick in the schedule template. Then in the report criteria, where you apply the...
You can't link Purchase Receipts to closed bills, so you'd need to reverse them if you desperately needed to do so. Purchase Orders can be closed a...
How about moving groupHeaderSection2, detailSection1 & groupFooterSection1 (which needs to be changed to footer of groupHeaderSection2) to a subre...
No problem. Glad to hear that it worked for you!
I don't think there is. You could try (carefully) modifying the child elements of <Sections> in the report .RPX file.
Try left join (POOrder to CRActivity) with this: POOrder.NoteID = CRActivity.RefNoteID
Try this: =IIf([IspkpCompanyOperatorLicense.EndDate] < DateAdd(Today(),'y',2), 'Expired more than 2 Years', IIf([IspkpCompanyOperatorLicense.EndD...
I doubt you can do it in GI as it requires calculations to be applied to aggregates and GI isn't good for that. You might need to migrate the GI to...
There's a tab on Bills and Adjustments page named "Approval Details" - did you look there?
How about this: =IIf([ARTran.DrCr] = 'D', -1, 1) * [ARTran.Amount]) This handles all tran types without having to specify them in the formula.
Not quite clear on what you're trying to accomplish but are you able to do the same update yourself interactively? Whenever I'm stuck with an IS I alw...
Unfortunately looks like the only way to join is via text in the UploadFile.Name field. Returns 1 row per attachment per sales order with atta...
Just recently noticed this as well but thought it was due to a recent change. Based on the age of this post it looks like it's always been that way.
Try joining SOOrder.NoteID to UploadFile.NoteID. UploadFileInfo has the filesize and datetime.
Pretty sure it's not recorded. I am in the same situation with the custom GIs built at our site. Would also love to know who it was last run by.