[probe_it]

Hi All,

We are currently with a very frustrating problem and would like to know if anyone has had this before and managed to get around it.

Are aim is to be able to get figures for Revenue, Profit and Balance of a Project (Job), both now and in the future!!. We use the following:

Revenue Comittments with Rev Rec Schedules.

Purchase Invoices with Amortizations Schedules

Time with labour cost.

You would have thought that bringing these together would be simple as they all share 1 common thing, being the Posting Period.

We have tried the following and ended up with cases or enhancements at every step:

1. Use native NetSuite reporting – non starter as there is no way to bring in more than 1 transaction type really!

2. Use scripted searches to roll the data up to the Project record – too many fields required as some projects may have 3 years to run and doesn’t offer much for extra analysis. And Amortization Schedules are not exposed to Suite Script

3. Create a Suitelet to run the Searches agains the Project and then embed this on a Tab – Job is not a valid filter on Rev Rec Schedules oh and Amortization Schedules are not ecposed the SuiteScript.

4. Use ODBC to extract all data and run bespoke reports – This is a cracker – the xml view of a Transaction shows Job_ID as a value, that field is not present in the ODBC views for Transaction, Rev Rec Schedule or Amortization Schedule at either Header or Line level.

Any help appreciated..

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

[Author]

Posts