search

ivylabs / suitecrm-analytics

4 stars 4 forks source link

Add a new Sale Data Export solution #224

Closed harrisward closed 3 years ago

harrisward commented 3 years ago

Create a new Data Exporter for Sales base on the review design below

harrisward commented 3 years ago

Review the design: https://ivy-is.atlassian.net/wiki/spaces/SA/pages/1833795587/Sale+Data+Export

fraserward commented 3 years ago

Updated Export Job parameters Created new Sale Data Export Transformation Updated CDAs for the same

fraserward commented 3 years ago

Pull request https://github.com/ivylabs/suitecrm-analytics/pull/232

harrisward commented 3 years ago

Added a new Sales Export to the Data Exporter.

johnM2401 commented 3 years ago

Hi @harrisward, I had a question around this, that could use your insight!

The Sale Data Exporter appears to have a parameter for Invoice Status: image

However, correct me if I'm wrong, but I think the F_SALES table only consists of "Paid" Invoice items, right?

If so, the "Invoice Status" parameter may be redundant as only "Paid" will return Sale Records (Unless I have misunderstood its usage?)

Any thoughts?

harrisward commented 3 years ago

Yo uare correct. We will remove this parameter