[rpmartin]

Is an equivalent to ‘Created From’ available in Enterprise reporting? In Netsuite, I can create a search where type is (‘Invoice’ or ‘Cash Sale’) and ‘created from’ is null, but I can’t find a way to do it through odbc.

Thanks in advance,

Rob
This is a cached copy. Click here to see the original post.

[Nick Horowitz]

I think it’s called “related_tranid”. Which would contain the InternalID of the parent txn. Look in the “Transactions” table (not “Transaction Lines” table)

[rpmartin]

RE: ‘Created From’ in Transaction Search

Thanks Nick. But I get different results when I use the criteria ‘related_tranid is null’ than when I filter on ‘Created From’ through Netsuite. Am I filtering wrong? Is there another way?

thanks,

Rob

[Nick Horowitz]

Hmm. I could be wrong.

You can see in the ODBC tables, that the linkages are very granular…the links are done on each line versus the whole transactions like in a saved search. So you may have to analyze the Links table and just infer that an SO liked to an IN would have all the lines linked and they would all be linked to the same parent transaction. So it more like if the # of unique links = 1, then you can assume that is the created from.

Or maybe you actually intellectualize each transaction type. For example, and SO’s parent could only be blank or an OPPTY. An IN could only be blank or an SO. An IR could only be a PO or an RA. See what I mean? Then you look at the linkages table and all the links for every line will be back to the same parent (although it would be different lines in the parent txn--i.e., line 1 in the IN would be linked back to line 1 in the SO)

So it gets tricky with ODBC because it is so granular.

Maybe Evan could chime-in here and elucidate on this.

I agree it would be nice if they just had an ODBC field called CreatedFrom that did all this analysis for you and just gave you the value like in the saved search.

One of my gripes all along has been the inconsistency between UI fields, CSV fields, Saved Search fields, and ODBC fields. The problem is these are all separate subsystems and when they add a new field, they are really bad about making sure the new field is added to all these places. I’ve suggested that they reengineer this so it isn’t a manually development process, but rather just inherent in the Oracle tables, so when they add a new field to the table schema, it automatically appears in all these places because the fields aren’t hard-coded.

[rpmartin]

RE: ‘Created From’ in Transaction Search

Thanks Nick. I looked at the transaction_links table a bit and it looks like the answer is there, although I’ll have to play around a bit more to get it just right. That is much more complicated than through the interface.

thanks,

Rob

[Author]

Posts