Posted in OpenERP, Product, Sale, Stock

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

Author:

Specialised in OpenERP/CRM Solutions, software development, Web development, E commerce solutions & other open source solutions.

2 thoughts on “OpenERP: Supplier Sales Report

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s