Comments
This indeed is a real-must have.
The fact that a lot settings are defined on entity level remains a big problem.
I can add another example to the long outstanding list of issues:
In some countries, when working with cash discounts, the cash discount is deducted from the sales tax calculated. In other coutries, the cash discount is not deducted from the sales tax calculated on the invoice.
The parameter for this is defined on entity level ('Deduct cash discount before sales tax calculation').
We had to customize this to have a compliant invoicing proces & a correct VAT declaration...
The API and web services are lacking functionality and are much to slow to expose the BC data, so this would indeed be a better solution.
Anything you can do to make it easier and faster (more performant) to perform ETL/ELT on all BC-tables would be great.
It's kind of strange that this is something that get so little attention from Microsoft, since being able to create fast BI solutions and get access to all your data in an ERP system is something every customers wants...
Every BC customer takes all the effort to implement BC, enter the data, post transactions, setup the system,... But getting the data out is a real nightmare, especially because of 2 facts: current api's/ws are very slow and not all data is exposed...
We have been requesting this from MS for years. Looks like they have finally listened.
I just checked in 10.0.15 and there looks to be many more entities added including:
- Project Quotation Headers
- Project Quotation Lines
- Project Quotation Work Breakdown Structure
(Plus a whole heap of Project Operations Entities).