OpenERP Product Barcode Report


Lets discuss about Product Barcode Report in OpenERP where you can print 40 barcodes in A4 page with user define currency and pricelist. And it is mainly work on available quantity of product in stock.

OpenERP Product Information
OpenERP Product Information

For that we have created new report in Product.

Product Barcode Report
Product Barcode Report

It will popup small window with some parameters.

Column : From which column you want to start printing
Row : From which row you want to start printing
Pricelist : Select sales pricelist
Currency : Select currency that print with price on barcode

Product Barcode Options
Product Barcode Options

This is a report of product barcode.

Full page with barcodes
Full page with barcodes
Close look of product barcode
Close look of product barcode

You can start printing barcode from any row and column on PDF.

Print barcode options
Print barcode options
Change barcode position
Change barcode position

Advertisements

OpenERP Point of Sale: Gift Coupon Feature


Video link for this feature: OpenERP POS Gift Coupon Feature

Enhancement in OpenERP Point of Sale for Gift Coupon feature.
This feature is very important when we are dealing with gift coupons in our routine life.

Lets see how this is working.
First of all we have to create coupons in OpenERP as a normal product but having Coupon option true.

New Coupon
New Coupon

In below screen we can see that only products having quantity > 0, and with 2 options for coupon feature. Create coupon from POS is also possible, and Show all coupons.

POS Coupon Options
POS Coupon Options

This view is to create coupon from POS. We can define validity periods so dates will be automatically calculated.

Create Coupon from POS
Create Coupon from POS

Once we create coupon, POS will load all products having Coupon = True. So these coupons can be allocated to our customers.

List of Coupons
List of Coupons

We have receipt with barcode, and other information like expiry date and all.

Barcode on Receipt for coupons
Barcode on Receipt for coupons

Here is the list of coupons when we click on “All Coupons”, but with condition that validity should be greater than today, and remaining balance also should be bigger than 0.

All Valid Coupons
All Valid Coupons

Now we have another option in the backend to check created coupons and history.

Created Coupons
Created Coupons

Now lets see how to use this coupon during POS payment. Here we have option to add multiple coupons and immediately available balance will be appear as soon as we select coupon barcode number.

POS Payment with coupons
POS Payment
with coupons

Once we process for payment, so coupon amount will be appear on receipt also.

Coupon amount in receipt
Coupon amount in receipt

Now in the backend, we can see remaining balance is decreased.

Remaining balance
Remaining balance

We have history also maintained here which are actually used on particular date with amount.

Coupon History
Coupon History

Now if we try to use amount which is bigger than available balance in coupon, then also POS will not allow us to do that.

Bigger Amount
Bigger Amount

More developments are on the way…

Contact: info@acespritech.com
Skype: acespritech

OpenERP Enhancement for product quantity in different warehouse


One more enhancement in our module “Product quantities in different warehouses” by adding more features.
Here is the old blog version:
V1 – Product Quantity in different Warehouse
V2 – Product Quantity in different Warehouse

So lets start again for new features.

OpenERP Sale Order
OpenERP Sale Order

Once we click on “View Stock” button, it will open popup window where we can add multiple products by checking their quantities at different warehouses.

View Product Stock
View Product Stock

There is a great improvement that when user will click on “Add Product” button, popup window will not close so user will add multiple products and “Selected Products” Tab will display that how many products still now added into order line.

Selected Product
Selected Product
After Adding Product
After Adding Product

During Internal Movement of stock it is very important to know which warehouse has how much stock for moving it from one warehouse to another. To make this work easy, we have added feature into “Internal Move” of OpenERP.

OpenERP Internal Move
OpenERP Internal Move

We can select Source Warehouse and Destination Warehouse for each product separately during internal move.

Popup product move
Popup product move

And user can also know that how many products (with warehouse) selected till now for internal move process.

Internal Selected Product
Internal Selected Product

We can see that each move line has source and destination location according warehouse select into popup window.

Internal Stock Move
Internal Stock Move

OpenERP Point of Sale: Restriction on return products from backend


For the moment, in OpenERP POS Back Order, we can return main order N times and also perform return operation on “Return Order”. Here we have improved some functionality and added new features like :

– Display Remaining Qty in main POS order
– Not allow to return which is already Returned.
– Not allow to add new product in “Return Order”
– Not allow to change product in “Return Order”

OpenERP POS Order
OpenERP POS Order

Once user will click on “Return Products” button from Main POS Order, it will open new window with all lines like below. As we can see there is no “Return Products” button available into “Return Order”.

POS Return Order
POS Return Order

This is an example that after creating “Return Order”, there are only few products exist.

POS Return Order
POS Return Order

After creating “Return Order”, we can check Remaining Qty into main POS order.

Main order after return
Main order after return

We are restricting user here for adding more quantities than what is Remaining in Main order.

Change qty error from return order
Change qty error from return order

User can not add new products into “Return Order”.

Restriction to add new line in return order
Restriction to add new line in return order

User will get following message when trying to save “Return Order” by modifying column other than “Quantity”.

Change return line
Change return line

After returning all products from Main POS Order, “Return Products” button will be disappear.

Can not return on main return order
Can not return on main return order