OpenERP: Supplier Sales Report


We are discussing about business where company is getting products from suppliers, stores it in warehouse or any other locations, and selling of it. Sometimes it requires to inform supplier that how many daily sales occur for products and how much remain at the end of the day.

Some companies are not buying products from suppliers but keep it in their warehouses and selling on behalf of suppliers.

In intial state, we have define and assume that one product is supplied by one supplier only.

OpenERP Product Supplier
OpenERP Product Supplier

For sending email we have created email template which make it more generic.

OpenERP Email Template
OpenERP Email Template

And for automatic sending emails, we used cron jobs which makes work very easy.

OpenERP Schedular
OpenERP Schedular

It is possible that all supplier don’t require notification about products those sold today. We make it optional also.

OpenERP Supplier
OpenERP Supplier

Now going to make sales order where one product has supplier defined and require to get notification about sales.

OpenERP Sales Order
OpenERP Sales Order

And we have completed all process of delivery order also.

OpenERP Delivery Order
OpenERP Delivery Order

When cron job is going to execute, it is sending email like below:

OpenERP Email
OpenERP Email

You can find PDF report as a attachment.

OpenERP Report
OpenERP Report
Advertisements

OpenERP: Calculate resource hours based on job position


In many industries it requires to distribute work between employees as per their skills and availability. Without proper management, we never know that how many total working hours in our company according to designation or job position and how many in use and pending.

OpenERP Job Position
OpenERP Job Position

Here we are linking job position with working time.

Job Position Worktime
Job Position Worktime

This is configuration detail of working time.

Working Time
Working Time

For our example, there are three employees related with Marketing job position.

OpenERP Employees
OpenERP Employees

Now we are going to create Project Task for marketing employee. Still now this task is not assigned to any particular employee. This way we have created 2 Tasks.

OpenERP Project Task
OpenERP Project Task

As you can see there is one approved leave request of employee who belongs to maketing designation.

OpenERP Leave Request
OpenERP Leave Request

We can see now how many hours available with us for particular job position between some periods. There are total 3 employees related with that job position.

Working hours for 1 person for 1 day is 9 hours. so it is 9 * 3 = 27 hours for 3 persons.
Allocated Hours means total task hours assigned to that job position. Holiday Hours in below screen considered as approved leave of any employee related with that job position.

Job Position Status
Job Position Status

You can create directly task for remaining hours for same job position on particular date.

Task Form Default Value
Task Form Default Value