Wednesday, July 16, 2014

Openbravo Singapore Localization - GST

Qualian - Singapore Localization module - User Manual for GST


We have 2 reports related to GST .


1) GST FORM





2)  GST Grouping Details



Let's see how to generate these reports.


We have 3 windows related to GST

1)     GST Form Setup

2)     GST Form

3)     GST Form History


1)  Initially configure the GST Form Setup


Navigate to Financial Management >> GST FORM >> GST Form Setup


GST Form Settings – Required for generating GST Form

Standard Tax : Business Partner Tax Category for Standard rate supplies Zero Tax : Business Partner Tax Category for Zero rate supplies
Exempt Tax : Business Partner Tax Category for Exempt rate supplies


Tax Payment Settings – Required for integrating GST form with Openbravo's Tax Payment

Business Partner : Business Partner record for IRAS Currency : Currency of the Client

General Ledger : General Ledger of the Client .

Sales Tax Register : Sales Tax register for recording sales related taxes in Tax Payment. Purchase tax Register : Purchase Tax register for recording sales related taxes in Tax Payment.


Note :

1) Only one record should be available in GST FROM Setup .

2)     Business Partners will be considered only if they are associated with any one of the tax selected in the Setup window . (Standard Tax , Zero Tax , Exempt tax )




2) Generate GST Form

Navigate to Financial Management >> GST FORM >> GST Form


Organization : select Organization to which GST Form should generate . (Invoice Organization) From Date : From Date of the GST Form (Invoice Date)

To Date : To Date of the GST Form (Invoice Date)


Click “Pdf Report” button to generate the report .



3) GST Form print will create a record in GST Form history .

GST Grouping Details report will be printed from the GST Form History window .


Navigate to Financial Management >> GST FORM >> GST Form History




Click the print icon to generate Grouping Details Report .


You can see all the invoice,tax details which are used to generate above reports in Tax Payment window.





Download:

Monday, May 26, 2014

Openbravo Challenges - Define Sales price in a volatile market


Challenge(s):
  • In Wholesale Fresh and Frozen meat business,market is volatile and product price will fluctuate everyday from -25% to +25% based on supply/demand.
  •  It's difficult or practically impossible for a manager to revise price/price-list every-time based on purchase. Why don't we let system to derive prices automatically? Is it possible?
  •  Sales man should know price limit,sales price,market price to tackle bargain.
  • System should throw alert if any product sales price is less than product cost and system should notify the same to manager.
  • In some cases,manager need permission to overwrite sales prices defined by system.
  • Don't show product if it's not active in sales.(Stock not available,Inactive Brand,etc..)
Solution(s):

  •   Used price-list schema and derived profit margin(list price,unit price)(user configurable) (i.e 2% - 4%)
  • Mapped pricelist schema with pricelist and applied check boxes "Enforce Price Limit","Price List based on Cost"
  • Wrote a new scheduler to create product prices based on pricelist schema.
  • Created a new tab "Warehouse" under pricelist to know about stocked products.
  • Enabled existing feature "Enforced Price Limit" and updated.
  • Created an alert and scheduled email to notify manager ( every 5 minutes).
  •  Added check box "Is Manual" to override product price
SCHEDULER RULE:
  • Remove all not stocked products from pricelist - product price.
  • Confirmed/added all stocked products from price list - product price.
  • Use Product cost "COSTING" and update all products price limit,price list and Sales price
  • If product cost not found(i.e new product,cost not calculated),scheduler will use last purchase price as COST.
  • Throw an alert if product list price,sales price is zero.
  • Scheduler will ignore product types "Service","Expense" and "Resource"
  • Scheduler will ignore products,if "Is Manual" is checked.





Thursday, April 10, 2014

Openbravo WebPOS - Customer address management

Contributed by Qualian Technologies (P) Ltd.

Customer address management and assigning to a ticket



Once customer is selected, system will automatically fetch default address and assigning it to ticket. If customer have multiple address, this can be changed by tapping the customer address button at the top of the ticket (next to customer name) which launches a address picker dialogue where a required address can be selected.
In this modal window, customer address are loaded automatically, which is read only at first. Tapping a address will get assigned to actual ticket. If customer have too many address, we can able to search customer address by name, filling the input text and pressing the magnifying glass button. Choosing New Address, new address can be added. Using the Edit Address, the address can be modified. The Assign to receipt button in New AddressEdit Addresswhich helps us to assign customer and address automatically to receipt after add new or edit address, without returning back to address menu.
To create a new customer address from menu:
  • Select Customers option in the menu.
  • Search and select customer which requires new address.
  • Tap Edit/New Address button in Customer Details popup.
  • Tap the NEW in the top left corner to add new address.



Thursday, August 15, 2013

Openbravo Retail : WebPOS Credit sales and collection

Credit sales functionality allows Openbravo WebPOS sales user to complete orders without paying and left it as credit based on customer credit limit/credit used.


To enable it, the POS Terminal Type must be configured.
Also, the Credit Line Limit of the Business Partner must be greater than zero.


If these two conditions are satisfied, a button with label Use Credit will appear in payments section.


Tap the button if the pending amount is wanted to leave as a credit. This process will check against the backend the available credit of the business partner. This quantity would be the difference between Credit Limit and Credit Used. If this amount is greater than the pending quantity of the sales order a confirmation popup will be shown. Pressing "Yes, use credit", the order will be processed. Pressing "Cancel", this action will be canceled.


On the other hand, if the outstanding amount exceeds the available credit, an information popup will be shown giving the information of available credit of the business partner, and it will not allow completing the order.

Source -http://wiki.openbravo.com/wiki/Retail:Web_POS_User_Guide#Credit_Sales

Credit Collection

Once Credit sales is done,customer used balance will be updated and system will ensure,customer is not exceeding his credit limit.Credit sales formula is  Credit Value <= Credit Limit - Credit Used.So customer need to pay outstanding amount(credit sales) in time(due date) to reduce credit used value.Currently Openbravo is allowing credit sales via WebPOS but we need to do credit collections via Back Office(limitation in WebPOS). So we faced following issues in implementation,

1.We need more Back Office licenses to do credit collection.
2.Retails user feels difficult to learn,access Back Office UI .End user feels,he need to do some additional work.
3.Time Delay.
4.In Truck sales,sales person is responsible for credit collection.So he need a option to do credit collection via WebPOS and the same need to be reflected in Cash Up process.

To overcome all ,we developed "Credit Collection" functionality in WebPOS. This functionality will allow user to do following operations in WebPOS.

1.Allow payment for credit sales.
2.Able to check receipt wise outstanding amount(credit sales) via separate menu.
3.Allow partial payment and leave remain as credit on existing credit sales receipts.
4.Credit payment amount update in Credit used value.
5.All payment methods are allowed to do payment for credit sales.
6.Allow Over payment(considered as tip and it won't be reflected in Credit Used)

Credit collection pop-up showing all outstanding receipt's(credit sales)



Partial Payment:
Selected Receipt VBS1/0000078 - 169.4 and doing a payment of 160 and leave remain 9.4 as credit.



After payment of 160,Outstanding amount updated as 9.4 for Receipt VBS1/0000078.


Over-Payment:
Allow user to pay 10 Euro against 9.4 Euro  and considered remain 0.6 Euro as TIP.


Credit collection menu and paid receipt is not showing now.(ensured)



If anyone interested in Openbravo Retail implementation or Openbravo Construction module MetR,please contact me via thirumalai@qualiantech.com

Qualian Technologies Pvt Ltd - Openbravo Certified Partnerhttp://www.qualiantech.com/qualian_openbravoindia_ERP_contact.php  


Sunday, August 4, 2013

Openbravo Retail : WebPOS Price Limit Validation

Openbravo for Retail offers a complete functionality for multichannel retailers, from Sales and Customer Relations to Finance and Operations. Its HTML5 web POS can be run on modern tablet devices, helping to improve dramatically the employees productivity and customer buying experience.

However, Openbravo for Retail is not only intended for pure retailers. Are you a distributor who is struggling with your mobilized sales force? Do you have trucks, and lack of complete control over their inventory levels in order to ensure they can fullfill all orders? Do you want to provide your drivers with a powerful tool that helps them to avoid data entry errors, improve your data quality and therefore provide support for a better decision making process?
If you have answered positively to some of these questions, Openbravo for Retail is also a solution for you !.
More Info @ http://planet.openbravo.com/?p=52313

We deployed Openbravo WebPOS in Truck sales for Wholesale & Retail distribution.So truck sales man face bargain and require option to change price. Normally Sales man will reduce price based on number of quantities,Customer relationship.This is fine but company want to ensure,sales man should have a limit for every product and system shouldn't allow any sales beyond that.So we utilized "Price Limit"  in pricelist and created a new module "WebPOS Price Limit Validations".
 
Case - 1:
Sales man requires price edit option and the system shouldn't allow any sales,less than product price limit.  
i)Add preference "Web POS action Change price" to "Y"
ii)Add preference(new) "Web POS Enforce Price Limit" to "Y"

Case - 2
Sales manager requires price edit option and the system shouldn't restrict sales based on price limit.
i)Add preference "Web POS action Change price" to "Y"
ii)Add preference(new) "Web POS Enforce Price Limit" to "N"

It's possible to set preference based on role,user.
http://wiki.openbravo.com/wiki/Preference 

 Example(case - 1): 1)Avalanche  Transceiver ,selling price is "150.5"  & Price Limit is "135.45"




2) Sales man selected  "Avalanche Transceiver" for sales.



3) Sales man changed price to "125" and got warning from system with detailed information.


4) Once user clicked okay or closed popup,selling price updated back to last value.


What's Next:

Price Limit validation override for certain products.Allow user to sell some products without any price limit(products going to expiry soon) and remain products with Enforce Price Limit(with Validation).New rule logic is product+role, product+user.

We released this module in Openbravo forge as Free Commercial Module(can only be used by Retail - Professional instances)

http://centralrepository.openbravo.com/heartbeat-server/org.openbravo.forge.ui/sso/ForgeModuleDetail?moduleId=041E19607D5B42A7901E26115948A2E9






If anyone interested in Openbravo retail implementation or Openbravo Construction module MetR,please contact me via thirumalai@qualiantech.com

Qualian Technologies Pvt Ltd - Openbravo Certified Partner
http://www.qualiantech.com/qualian_openbravoindia_ERP_contact.php 





 

Tuesday, July 16, 2013

Openbravo WebPOS - Android - Mobile Bluetooth printer

Openbravo for Retail offers a complete functionality for multichannel retailers, from Sales and Customer Relations to Finance and Operations.  HTML5 web POS can be run on modern tablet devices, helping to improve dramatically the employees productivity and customer buying experience.

However, Openbravo for Retail is not only intended for pure retailers. Are you a distributor who is struggling with your mobilized sales force? Do you have trucks, and lack of complete control over their inventory levels in order to ensure they can fullfill all orders? Do you want to provide your drivers with a powerful tool that helps them to avoid data entry errors, improve your data quality and therefore provide support for a better decision making process?

If you have answered positively to some of these questions, Openbravo for Retail is also a solution for you !. 

Please read more about  simple business scenario in following link, Openbravo for Retail for Wholesalers with mobile sales

 Do you need to provide a receipt for the mobile sales transaction? The best option in this scenario would be to use a bluetooth printer.Currently Openbravo is not supporting blue-tooth receipt printer.As I mentioned in my last post,we successfully printed Invoice receipt from Android device via Bluetooth(using our own Android Hardware Manager).

http://www.thirumalaik.blogspot.com/2013/06/openbravo-retail-webpos-varaiable.html

We tested this application in "Samsung Galaxy Tab 2" with "Zebra ez320" blue-tooth printer.We hope this application may support all Android devices and blue-tooth printers(If Android driver's already exists ).

I attached some sample screen-shots below. 


Application Homepage
 



Adding all available Printer's 


Listing Printer's:


Printer Information:


Mark Printer as default for seamless printing



Harware Manager running in Background:


Hardware Manager - Test


Openbravo WebPos Ticket


After payment ,Hardware Manager showing print options,




Now,we are testing our application with various Hardware's and we are planning to release this application in Google Play,free of cost :)
Very soon,we will release a video about Android mobile blue-tooth printer from our Retail - Hardware labs section.
If you are interested,please drop me an email ,thirumalai@qualiantech.com. I will provide application apk file(POSHardwareManager.apk) for Testing.

If anyone interested in Openbravo retail implementation,please contact us via http://www.qualiantech.com/qualian_openbravoindia_ERP_contact.php



 




Tuesday, June 25, 2013

Openbravo Retail WebPOS - Variable measure Barcode,Bluetooth Printer

Variable measure Barcode:

Openbravo WebPOS cannot read a variable EAN code that includes information about Item in different format according to GTIN specification. For example an EAN barcode may or may not include product price,product weight. In either case Openbravo WebPOS should be able to find the correct product and price/weight from Barcode.

Since Openbravo WebPOS doesn't support  variable measure barcode,we had to do a customization to support it.In our customers case,we have followed
the following format to support the barcode which contains Product code EAN and price/weight.
1-2(identify price(11)/weight(10)) // 3-7 digits product code EAN // 8-12 digits price or weight // 13 check sum

Barcode Implementation with Product code and Price/Weight:

The below example illustrates,how we were able to achieve the barcode Implementation which includes price of the product/weight of the product.
 
Product code for Chicken is 05187.


 Product Code for Tomato is 02398.





Retail store  purchased a bulk quantity of chicken, cleaned and packed into small bags.obviously weight will vary for every bag.So we need to bill based on weight and price need to be fetched from DB.Note:chicken price may vary everyday.We used Electronic Label Printer Scale + Barcode Weighing Scale and pasted barcode label on packet.This label have information of Product Name,packed date,Expiry date,etc.

In Billing counter,system will read this barcode and identify weight/product and fetched price from database.In our example,system red Barcode 1001587002505 and identified product as Chicken,quantity as 2.5 . System fetched price 36.50 from database and updated line net price as '701.25' (2.5*36.50)





In Saudi Arabia,people loved to select fruits and vegetables on their own(need to be weighed). Weighing is a time consuming process in final bill counter,so we placed an separate "Electronic Label Printer Scale , Barcode Weighing Scale" for weighing purpose(to speed up process,one weighing machine for every category). This machine is printing a label bar-code along with product name,weight,price per kg,packed date (information for customer) based on defined format and we pasted it on bag cover.

In Billing counter,system will read this barcode and identify price/product based on it. Based on Barcode 1102398005755,system identified product as Tomato,price as 5.75 and skipped the logic of fetching price from database.





Your customers are the reason your company exists: serving and retaining them is essential - Being Human is Good Business by Kristin Smaby
Very soon,we will release a video about variable measure barcode from our Retail - Hardware labs section.

What's Next?
A challenging task of Printing receipts via Bluetooth receipt printer from an Android tablet.We used printer "Zebra ez320" and successfully printed sample receipt without Hardware manager.Now,we are creating our own Hardware Manager for Android.Will get you soon with positive results.

Saudi Arabia - Retail Localization module
We created a Localization retail module for Saudi Arabia including all receipt's ,GS1 rules and barcode label printing.We removed all tax related information from display and also in Receipt .In addition to that,we printed Arabic product names along with English names in all receipt's.

If anyone interested in Openbravo retail implementation,please contact me via thirumalai@qualiantech.com
http://www.qualiantech.com/qualian_openbravoindia_ERP_contact.php

Qualian Retail RoadMap;
1.Employee Login Authentication via magnetic card reader.
2.Saudi Arabia - Payment gateway Integration
3.Variable measure barcode - User configurable screen
4.GS1 Integration (identifying Vendor and products)
5.Truck Sales - Hardware solution( Tablet/Mobile + Blue tooth printer + Blue tooth bar-code scanner)

Reference;
1.http://wiki.openbravo.com/wiki/POS_-_Reading_variable_measure_barcode

Sunday, May 26, 2013

Openbravo for Retail - Openbravo WebPOS

General Questions

What is Openbravo for Retail?

Openbravo for Retail is the Openbravo’s commercial offering for the Retail industry, providing a complete and modular multichannel retail solution, for supporting both the Channel and Head Office operations. Thanks to its breadth and robust platform, Openbravo for Retail can help any kind of retailer leverage IT to drive better business results:
  • Brick-and-mortar retailers, seeking a modern retail solution to improve operations and customer experience, while also providing support for opening the web channel. In this case, retailer can decide to adopt the complete solution or just integrate the new generation POS ready to be used with iPad or Android devices and with strong Store Operations management capabilities , with its legacy retail management system, with a single integration point.
  • E-Commerce retailers, seeking a back office solution to improve their logistic and financial processes
  • Franchisors, seeking a scalable solution with a clear cost model for their current or new franchisees and owned stores, to increase their network performance and reduce time-to-market when adding and opening new stores
  • Retailers seeking a solution to support international operations, with multi-language and multi-accounting schema capabilities

What does Openbravo for Retail include?

Openbravo for Retail is a multichannel retail management system, comprehensive and modular, for managing an entire Retail business, from Sales and Customer Relationships to Financials and Operations, across different channels. Based in the powerful Openbravo 3 platform, Openbravo for Retail delivers:
  • A full web based solution
  • A best in class productive user interface
  • A modular solution
  • A fully interoperable platform
Openbravo for Retail Solution business footprint includes:
  • Merchandise lifecycle management : items management, pricing, assortments
  • Supply chain management : procurement, warehouse and dc management, merchandise distribution
  • Multichannel : support for brick and mortar, e-commerce, wholesale
  • Enterprise management : financials, human resources, document management, e-learning support, CRM
Get here a detailed document about the solution description. Visit our on-line resources to learn more about our solution:

What is the price for Openbravo for Retail?

  • Openbravo for Retail has a highly competitive, clear and simple pricing model, which helps Retailer for having a clear picture about the expected costs through the whole solution lifecycle.
  • With a simple model based on the number of Backoffice users and POS terminals, a Retailer can start from a minimum yearly price of 1.675,00 € (Zone 1) including one POS terminal, and without needing to pay for initial licenses. From here, retailers can grow by simply adding additional Backoffice users at 500,00€ (Standard edition) or POS terminals at 175,00€ (Standard edition).
  • Are you interested in having a huge number of terminals? Check our volume discounts starting on 100 terminals, and finally if needed, Unlimited, with an unbeatable yearly price.
  • Do you want to focus on your business and forget about any hardware problems? Try On Demand, offering the maximum flexibility in terms of invoicing and users provisioning, starting from a mininum monthly price of 136,00€ (with one POS terminal), and including solution hosting.
  • And because we are really proud about our customers and want to create a long term relationship, from second year and ahead, a loyalty discount of 15% over the total subscription price and on top of the existing discounts will apply (not applicable for OnDemand). More detailed pricing information, with the pricing dependent on where you are browsing from.

What is the Retail Backoffice?

It is an Openbravo instance for supporting backoffice processes, at any retailer organizational level, for example Stores, Warehouses or Distribution Centers or the Central Head Office. Subscription for the Backoffice is based on users (concurrent, named or unlimited depending on the subscription type).

What is a POS Terminal?

A POS Terminal is a device running the Openbravo POS module, connected to the Openbravo Back Office (an Openbravo instance). It could be also possible from this terminal to access to the Back Office. It could be a fixed (PC, laptop) or a mobile (tablet) terminal. A terminal subscription is asigned to a concrete terminal and can’t be shared with another one. It could be possible to move it, and then leaving the first terminal unsubscribed.

Which deployment options are available for Openbravo for Retail?

As a vertical build on top of the Openbravo 3 platform, Openbravo for Retail can be deployed under the same scenarios that the standard Openbravo platform : On Premise, Hosted, in the Cloud or as a service with OnDemand.

Do you recommend a specific deployment option for Openbravo for Retail?

Openbravo On Demand may be particularly attractive to many retailers, who often face these common requirements and challenges:
  1. Highly distributed scenarios, e.g. multiple stores and mobile requirements
  2. Easy to integrate Web POS with existing back office through a single, secure web services based integration point in the cloud
  3. Seasonality aspects, along with the typical retail HR challenges (many part time employees or peak times require ability to cost-effectively scale up or down on demand)
  4. Quick up-and-running for new store openings, due to back office being implemented as a managed cloud service
  5. IT staff reduction or time invested in higher value activities
  6. Big Data influence, being able to access to more powerful servers offering higher analytics capabilities at a lower cost

I run international operations. Can Openbravo for Retail help me?

Yes. Openbravo for Retail provides full international operations support, thanks to its multi-language, multi-currency and multi-schema accounting.

I would like my suppliers to work more closely to my business. Could I give them acces to our system for example for Category Management or VMI scenarios?

Yes. Openbravo for Retail is a full web solution, therefore enabling retailers to implement new collaboration scenarios with your suppliers and partners by giving them access to your system. In this way, you can for example implement procurement strategies like Category Management or Vendor Managed Inventory (VMI) with your suppliers, or give more visibility to your customers about the status of their orders, let them modify personal data…

Is there a minimum number of backoffice users or terminals with Openbravo for Retail?

Openbravo for Retail has a different fee based on the subscription type. For each fee and depending on this subscription type, a number of users are included. Additional users can be purchased:
  • Standard Pricing : Initial fee includes up to 3 concurrent users
  • Enterprise Pricing : Initial fee includes up to 10 concurrent users
  • Unlimited Pricing : It includes unlimited concurrent users
  • OnDemand : Initial fee includes up to 3 named users
More detailed pricing information.

Is there a maximum number of backoffice users or terminals with Openbravo for Retail?

No. Customers can have as many backoffice users and terminals as they want.

Can I install additional modules with Openbravo for Retail?

Yes. Openbravo for Retail uses an Openbravo instance and customers can install there any module they want, including commercial modules.

Can I customize my Openbravo for Retail?

Absolutely, you can. The objective of Openbravo for Retail is to reduce your need of customization, but it does not limit at all your capacity to adapt it to your very specific needs. Any adaptation you can do in Openbravo core can be done, using the same tools and means, in Openbravo for Retail.

Which POS peripherals are supported?

Openbravo POS is designed to support multiple type of peripherals. Learn more about POS peripherals in the Hardware_and_Peripherals_Guide.

Does Openbravo POS support credit card payments?

Yes. Credit card payments are managed in conjunction with a multifunctional payment terminal, which communicates with a payment gateway. Different card types or transactions (like credit, debit, Chip&Pin) can be supported depending on the terminal type and payment processor. An integration with the desired terminals or payment gateway will typically be needed. Openbravo for Retail includes the core components that let integrate easily with any payment gateway (it may depend on the banks used by the retailer). Note that a payment gateway is usually only possible to use for a single country or a limited number of countries. For implementations that integrate an E-Commerce platform integrated with Openbravo for Retail, payments are typically managed directly by the E-Commerce platform payment component.

I have already a Retail system, and I’m seeking for a new system for supporting my Store operations. Can I integrate Openbravo for Retail with my existing system?

Yes. Openbravo for Retail is a modular and fully interoperable retail solution. In case you are only seeking for a system to support your store operations, it is possible you set up your system for that, and integrate it with your current retail system.

I’m an E-Commerce retailer with an existing E-Commerce platform. Can I integrate it with Openbravo for Retail?

Yes. Openbravo for Retail benefits from the powerful interoperabilities of the Openbravo 3 platform. Thanks to its complete web services layer, you can integrate your existing E-Commerce platform with the Openbravo for Retail server. Visit our Exchange to find existing connectors with E-Commerce platforms, such as the following Magento connectors:

When is Openbravo for Retail available?

Now! Visit our website and request a free Trial License.

Source:
http://wiki.openbravo.com/wiki/Retail:Frequently_asked_Questions


Contact us ; thirumalai@qualiantech.com

Friday, October 5, 2012

Openbravo ERP - Consignment Sales Management

Consignment sales management is a native Openbravo module that allows you to easily manage inventory at customer locations, invoicing your customer only when product is actually sold. In this type of streamlined trading arrangement between partners, you retain ownership of the stock until the final sale, and payment is not made until there is a sale. Unsold stock is returned back to you, without any money changing hands.
Consignment Sales is suitable for new product, used goods and new marketplace sellers. The module fully supports all standard consignment business process flows--directly inside of Openbravo!
 
 
A consignment sales process is used when you (the consignor) send goods to a selling agent (the consignee), and retain ownership until the final sale. The business process flow in Consignment Sales consist of four major parts:
  • Consignment Fill-up
  • Consignment Issue
  • Consignment Returns
  • Consignment Pick-up
  • Consignment Loss

Consignment Fill-up
Consignment Fill-up covers the replenishment of your stock at the customer site. The two steps up:
  • Consignment Fill-up Order
    The order is a request from your customer (typically through a sales representative of your company), based on the demand of the product in market. This order does not involve any pricing (only quantities), and will not result in invoicing.
  • Consignment Fill-up Delivery
    The delivery records the movement of the goods out of current stock, to the customer site. Even after the goods have been delivered, you will retain the ownership until the goods are sold.
Consignment Issue
Consignment issue records the sale, enabling the customer to sell the product from the stock available in their warehouse. This business transaction is relevant for billing (your customer now owes you money), because the customer has sold the goods.
Consignment Returns
The Consignment returns process enables the customer to return the goods into the consignment stock that were already taken out of it. After consignment Issue, if the end customer finds any defects or any discrepancies, they can return the product to consignment stock. This transaction is relevant for billing since your customer receives a credit for the returned goods.
Consignment Pick-up
If not all of the consignment inventory has been sold, the remaining products may be returned back to your warehouse. The two steps involved in this Consignment Pick-up process are:
  • Consignment Pick-up Order
    Based on products not utilized at the customer location, your Sales representative or some other in-charge person will place a pickup order.
  • Consignment Pick-up Delivery
    Based on a pickup order, the person in charge from your company takes the remaining products from the customer location and stores them in your warehouse.

Screenshots



 
 
 
 
Please contact me,if you are interested in this module.
 
 
 

Monday, May 28, 2012

Fifth year in Qualian with Openbravo:Travel in the Marines

I successfully completed my fourth year in Qualian with Openbravo.Now I entered into Fifth year and I'm very happy with my progress.

Thanks to Senthil and company for giving lot of responsibilities.WOW !!!,What a surprise growth in my career along with Openbravo.

ERP is a Ocean and just I learnt to swim,waving boats.Now,The ship is built and I need to travel in the marines :)

My Ship name is MetR,A solution for construction Industry in Openbravo ERP.

Monday, September 12, 2011

Consignment Sales Management

Qualiantech developed an extension module named Consignment Sales Management for handling Consignment Sales process.

This module is registered in Openbravo forge and Qualian have a plan to release it in Openbravo Exchange,probably by next week.


http://forge.openbravo.com/projects/consignmentsales



Functional Specification Document

Contents

1 Functional Specification: Consignment Sales Management
1.1 Section 1: Overview & Justification
1.1.1 Purpose:
1.2 Section 2: Users & Business process description
1.2.1 User goals
1.2.1.1 Consignment Fill-up
1.2.1.1.1 Consignment Fill-up Order
1.2.1.1.2 Consignment Fill-up Delivery
1.2.1.2 Consignment Issue
1.2.1.3 Consignment Returns
1.2.1.4 Consignment Pick-up
1.2.1.4.1 Consignment Pick-up Order
1.2.1.4.2 Consignment Pick-up Delivery

Functional Specification: Consignment Sales Management
Section 1: Overview & Justification
Purpose:


Consignment sales is a form of business in which, as a service to the customer (Eg. A Retail Store), the company or vendor maintains a stock of their materials at a customer’s location. The company or vendor retains ownership of the materials until they are withdrawn from the consignment stores. The customer is only charged for product once it is reported as used.

Module Name = “Consignment Sales Management”
Module language = English and Spanish translation
Module url = [1]
Module author = Qualian Technologies
Module License=OB Commercial License

Section 2: Users & Business process description
User goals


In trading arrangement, Consignment sales play a vital role in placing any material in the hand of another. Business process flow in Consignment Sales consists of four major parts. They are

Consignment Fill-up
Consignment Issue
Consignment Returns
Consignment Pick-up


Consignment Fill-up


The core functionality of Consignment Fillup explains that the stocks can be replenished at the customer site is not accounted for neither invoicing nor pricing because the goods remain the property of your company. The two steps involved in consignment Fill up are

Consignment Fill-up Order
Consignment Fill-up Delivery

Consignment Fill-up Order


It’s a request from the customer through the sales representative of your company based on the demand of the product in market. So it doesn’t involve any invoicing or pricing of the product.

Consignment Fill-up Delivery

After the company has received a fill up order either from customer or through sales representative, the company shall deliver the goods at the customer site based on current stock. Even after the goods have been delivered, the company will retain the ownership until the goods are sold.


Consignment Issue


Consignment issue involves & explains the significant process of selling the goods. It enables the customer to sell the product from the stock available in their warehouse. This business transaction is relevant for billing from company to customer because the customer has sold the goods.

Consignment Returns

Consignment returns enables the customer to return the goods into the consignment stock that were already taken out of it. After consignment Issue, if customer finds any defects or any discrepancies they can return the product to consignment stock. This transaction is relevant for billing since the customer receives a credit for the returned goods.


Consignment Pick-up

After the products have been sold, the remaining consignment goods have to return back to the warehouse of your company.The two steps involved in consignment Pick-up are

Consignment Pick-up order
Consignment Pick-up delivery

Consignment Pick-up Order

Based on products not utilized at customer location, Sales representative or some other in-charge person will place a pickup order.

Consignment Pick-up Delivery

Based on pickup order,the person in charge from company takes the remaining products from customer location and stored it in the warehouse of the company.


http://forge.openbravo.com/plugins/mwiki/index.php/ConsignmentSales/Functional_Specification_Document


http://forge.openbravo.com/plugins/mwiki/index.php/ConsignmentSales/User_Manual