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 this:

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.

ps. don't forget to do a search before posting as someone else may have asked the same question.

Problem is the size of the group is fixed - so it's clipping the field. Unfortunately you need to pre-allocate space for the note in the group. I've n...

Got it working - give this a go. Note that the data is returning at line level so if you want it at order level it needs Group criteria (as mine has...

You have the COLOFEE filter on the wrong table (needs to be SOLine2). And you'll also need to join InventoryItem to SOLine2 to apply the filter on Inv...

Try Left Joining an additional SOLine and use it to filter your main query. Join on ordertype, ordernbr and filter where inventorycd=colofee. Add ...

@agupta I'm suggesting to write your GI based on selecting the data from the Item (POVendorInventory DAC). You won't be able to get the required outco...

Pretty sure what you want to do above can't be done in GI for the reasons you encountered. Why don't you just take the price from the Item directly?...

Dead Stock does have Excel export button so you are mistaken there.

I think lack of header record is your issue - it's required AFAIK. You can add a header record with a command script and possibly replace the pipes...

@nsyafika What about a data table widget with only 1 row shown? You can include the date and the KPI value as the columns. It doesn't look as nice as ...

Customizer is required to publish. Access rights in the target tenant are controlled by user security in that tenant - they do not need Customizer rol...

I'm a bit vague on your requirements. If you want to include a calculated field as a Caption on a KPI (which is what you have circled in red), that un...

Blank means false - are you certain there are Contacts where this property is true?