v7 FreeBalance Help

Report Field

Description

Serial Number

the report must generate a correlative/total (see mockup) number for each printed vehicle in its corresponding grouping institution

Responsible Position

Display the position linked to the employee, look for the employee assignment linked to the employee that has: the max assignment ID, and the actual end date is null or is greater than system current date at reporting generation time.

Earning Scale

the cost item scale level is related to the generic position

Position Category

display the short description linked to the generic position

January amount

Group and sum the total cost for the vehicle in the comply with the following:

• date belong to the corresponding month (fiscal period)
• the status is “Delivered by Supplier"

February amount

same as above

March amount

same as above

May amount

same as above

June amount

same as above

July amount

same as above

August amount

same as above

September amount

same as above

October amount

same as above

November amount

same as above

December amount

same as above

Total of report

In case a single ministry (top level institution level) is displayed hide this row.