For a while , we have been trying out different possibility for our Malaysia SME Clients to handle their business processes and we are definitely a supporter for Cloud OpenERP solutions but because of internet connections are not available for some clients, i have been toying idea of
ONLINE and OFFLINE for my apps , so i wrote a XMLRPC engine for Delphi which has
- CRUD features
- Return Dataset for Delphi while READ
- Return ID for CREATE
- it can UPDATE with a given ids and
- it has a field mapper for local fields map to openERP fields
- it can use the ir.model.fields as a field object during development which able to detect the field size , field type ,etc.
A simple proof of concept apps is as follow , please feel free to comments so that i can improve it , thanks.
PROOF OF CONCEPT : online/offline model for HR Leave application Apps
1. Set up the Leave Type at OpenERP.
2. At the Instant-Payroll interface, synchronize the Leave Type data from OpenERP.
3. Set up the leave details at Instant-Payroll (e.g. leave grouping). Allocate the number of leave days for each leave type.
- Leave the Leave Setup , do not have to configure for the moment , as this is only a Proof Of Concept .
- And the Leave allocation is the place where you can configure to actually effect the Employee's entitlement for ANNU , ANNUAL leave only at this moment and for NONE category.
As my Proof Of Concept employee is 0671 (openerp user is administrator) , with department "NONE" and service year around 8 year 1 month , so it should be on the 1st row and if you change the entitlement column to any day , it will then sync back to openerp .
it will look for OpenERP whether this record exists , it will either CREATE new or Edit Existing but it will ALWAYS overwrite. (1 way from Payroll leave to OpenERP )
4. Process to generate leave entitlement for all the employee records.
(Currently the �Process� is still pending, so temporarily need to manually update the Employee Entitlement for each records. There is already an employee record with entitlement updated, user code: 0761) , it will be a automatic process which will generate all employee leave entitlement records. The record for Proof Of Concept can only be generated from the Employee Leave entitle form , select employee 0671 and then select leave code "ANNU" , it will generate and calculate the leave entitle.
5. Synchronize the leave entitlement to OpenERP.
what it does is that , whatever we generate from the payroll leave locally , it will be sync back to openERP.
6. Execute the leave transactions (apply leaves, approve/disapprove leaves) at OpenERP.
7. Synchronize the leave result from OpenERP to Instant-Payroll.
once we have sync form OE the leave record , it will show in the entitlement screen.
.
So that is all and hope this can be useful to my Malaysia SME clients , so that they can opt for offline if they want or somehow , some clients are concerns for security , then they can keep an offline DB at their site as well !
And for the rest of the communities from OpenERP ,do drop me a notes or in the forum let me know your answers or comments.
Cheers !
Update Contact :
No Wa/Telepon (puat) : 085267792168
No Wa/Telepon (fajar) : 085369237896
Email : Fajarudinsidik@gmail.com
No Wa/Telepon (puat) : 085267792168
No Wa/Telepon (fajar) : 085369237896
Email: Fajarudinsidik@gmail.com
atau Kirimkan Private messanger melalui email dengan klik tombol order dibawah ini :