Query to get the prepayment Amount Values — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Query to get the prepayment Amount Values

Summary

Dear All,
I am creating a BIP report, In which I need to calculate the number of employees processed in the payroll run and sum of total amount in processed in prepayment stage of flow pattern. For the report, I have two parameters - 1. Payroll Run Month-year 2. Payroll Name.
Based on this 2 paramters I have to calculate the count of persons and sum of prepayment amount.
Currently I have created a query to get the desired results, but I am facing problem when I am using personal_payment methods table to join, Some employees are not getting picked, query is skipping some employees. I am attaching the code in below code section.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!