I am trying to make a statement for every month that will determine if we should bill our company or not; and if so the amount of total workable hours per month or if the employee has submitted hours the amount of hours submitted.
For example:
If the PO starts on 9/1/18 then we would bill the normal 152 workable hours unless the employee has submitted their hours. Then we would want to bill their submitted hours.
If the PO ends before 8/31/19 then we would not want to bill for any month’s after the contract end date they submitted hours worked.
So if the employee’s PO ends on 3/1/19 then we would bill up to that point but not after unless hours have been submitted.
Finally this needs to be done for every month but also keep a running record of the amount of PO hours available after being billed.
So if the employee has 2080 hours to work on the entire PO, and September has already passed and they submitted 160 hours to the PO then we would want October to be 1920-Est Billed Hours.
So Sept Remaining Hours = Initial PO (2080) – Sept Hours (160) = (1,920)
Oct Remaining Hours = (Sept Remaining Hours (1920)) – Oct hours (152) = (1,768)
The Hours per month would either be the amount of workable hours per employee (assuming full month’s hours submitted) or the amount of hours they have submitted per their contract. So we don't want to bill hours before a contract start date and we don't want to bill hours (unless hours are worked) after a contract end date.
I am running into the issue of combining the two if statements for the start and end date to properly bill for each month. Please let me know if you have any questions.
