SPRING object for monthly changes

Asked

Viewed 125 times

0

Good morning,

I need to know if there is any SPRING object in vba for the monthly changes screen because I need to validate when a missing is launched.

vba

  • There is no.

  • It needed when an unjustified foul is launched to deduct the week’s salary if that foul was before or after a holiday/rest day, with the ERP only allowed to do this operation to discount food subsidy, how I would like to carry out this operation?

1 answer

4

Good morning Hugo.

I think the best option you can have is to execute some VBA when you open the company since you have no object in VBA that is related to HR. In this VBA, you could make a query to return all unjustified faults in the last "X" days that had not yet been processed.

select * from Registration fouls Where Numproc = 0 and Missing = 'FXPTO'

For each returned record, it would clear the absence if it complies with the conditions mentioned ("if the absence occurred before or after a holiday/rest day") and would mark a further unjustified misconduct (other code) for the specified period ("week").

Insert monthly change: Aplicacao.BSO.RecursosHumanos.AltMensaisDescontos.Actualiza

Delete monthly change: Aplicacao.BSO.RecursosHumanos.AltMensaisDescontos.Remove

To define the period (week) where to mark the new unjustified absences, you must obtain which week of the year in which the missing is to be eliminated (Format(Date, "ww")) and then get the first and last day of that week to mark the "new" fouls.

Browser other questions tagged vba

You are not signed in. Login or sign up in order to post.