How can I use the “created from, date created” field in Analytics?
In my transaction saved search, I am showing invoices created from sales orders. I can also pull the sales order creation date with the following:
{createdfrom.datecreated}
How can this be done in an Analytics transaction dataset?
The closest field I find is “{transactionlines.createdfrom#display}”, which gives us the SO #, but I cannot figure out how to pull the creation date for the SO.
Does anybody know how? Thanks!
Michael
Hi,
You need “Related Transaction – Previous” in this instance. You might also want to look at the Link Type and/or the Type of the transaction to filter it to Sales Orders.
This is the new way of doing Applied To / Applying Transaction. And, as with that, some links are at header level and there are also links at line level.
Thanks,
Chris
