Verified this fix on Production. Providerwise Billing Data export on Rowise , Columnwise Templates is working as expected.

Verified this on Stage on company level as well as on group level template. Working as expected.

We are BLOCKED to test WT-6949 and WT-5308 on Stage as we are unable to generate invoice and finalize it (as Export file needs finalized invoices).

We have committed 12/12/2016 Production date for this BCC Providerwise Export enhancement which can be delayed due to this. Will resume testing once WT-6989 gets deployed on stage

CC: Prasanna Karlekar Rohan J Khandave Satya Hrishikesh DeshpandeSamir

Updating hours including LB stage and Production testing estimates along developers time spent

Tested this change on LB with following scenarios

a) Generating invoice but not finalizing it.
b) Generating and finalizaing invoice

Both above scenarios are considered for Rowise Columnwise type of templates along with below

1) Verified on Changes and full files
2) Verified on Group Templates (Same Companies)
3) Verified on Group Templates (Different Companies)
4) Verified for Multiple Providers and single provider
5) Verified by deleting run dates from group as well as company level templates

Records exporting on files are as expected. Ready for Stage Deployement

Affected Files: OES_SP_Export_ProviderWiseInvoiceReport

Concern: Getting server error when exporting Billing Data Template when Invoice is generated and its finalized .

Cause: This issue is because of WT-6331 new enhancement during the this change column definition get changes

Correction: We handle this with code change.

CC-Rohan J Khandave,Vinayak Kulkarni,Rakesh Shahane