This topic contains 0 replies, has 0 voices, and was last updated by Darcy Wisniewski 9 years, 3 months ago.

  • Author
    Posts
  • #8391 Score: 0

    Darcy Wisniewski
    • Contributions: 0
    • Level 1

    Over the last several months we have developed custom reports using SuiteScript. Our custom reports are very complex due to the nature of our business and limitations of integrated systems.

    One of our reports, which is the foundation of all other reports, must capture every line item for Invoices and Credit Memos and give Gross to Net amounts. We understand NetSuite governance and usage limitations – especially when you are trying to report on totals from lines of Invoices and Credit Memos – our daily invoices can exceed 500 during promotions and holidays. A regular day we have about 300.

    We have used our internal developers, NetSuite Technical Consultants and have also outsourced our reporting requirements. We have had no success producing the above report for even a period of 4 days reporting on line detail.

    We have also concluded that webservices will not be fast enough to produce results.

    Our next option is a Data Warehouse. Can anyone provide any recommendations to efficiently and accurately extract data from NetSuite?
    This is a cached copy. Click here to see the original post.

You must be logged in to reply to this topic.