Wanda POS Administrator's Guide

Download as docx, pdf, or txt
Download as docx, pdf, or txt
You are on page 1of 65

Africa’s Gift To The World!

Wanda POS
ADMINISTRATOR’S GUIDE
Fonyuy T. Isidore

1.0 Land of Promise

IT Kamer Company Ltd.


Wanda POS

Administrator’s
Guide
Wanda POS

Administrator’s Guide

By Fonyuy T. Isidore
Developer
IT Kamer Company Ltd.
[email protected]
Tuesday, 23rd September 2014
Table of Contents
Minimum system requirements ............................................................................................................... 8
Recommended requirements ................................................................................................................... 8
Downloading the Software ....................................................................................................................... 8
1. GENERAL INFORMATION .................................................................................................................... 10
a. System Overview............................................................................................................................. 11
b. Product References......................................................................................................................... 11
c. Authorized Use Permission ............................................................................................................. 11
d. Points of Contact............................................................................................................................. 11
i. Help Desk .................................................................................................................................... 11
ii. Coordination ............................................................................................................................... 12
e. Acronyms and Abbreviations .......................................................................................................... 12
f. Document Conventions .................................................................................................................. 12
New chapter................................................................................................................................................ 13
Main heading .......................................................................................................................................... 13
Sub – heading...................................................................................................................................... 13
g. Buttons and Icons ........................................................................................................................... 13
h. Wanda Documentation................................................................................................................... 14
2. GETTING STARTED............................................................................................................................... 15
Logging On .............................................................................................................................................. 16
User Access Levels .................................................................................................................................. 16
Guest:.......................................................................................................................................... 16
Employee: ................................................................................................................................... 16
Manager:..................................................................................................................................... 16
Administrator:............................................................................................................................. 16
Changing User ID and Password ............................................................................................................. 17
Exit System .............................................................................................................................................. 17
3. USING THE SYSTEM ............................................................................................................................. 18
Quick Tour............................................................................................................................................... 19
............................................................................................................................................................19
............................................................................................................................................................19
............................................................................................................................................................19
................................................................................................................................................................ 19
Viewing customer information ........................................................................................................... 20
Closing Cash ........................................................................................................................................ 20
Using the clock ........................................................................................................................................ 21
Viewing Closed Cash ........................................................................................................................... 21
Adding New Customers....................................................................................................................... 22
Adding Stock ........................................................................................................................................... 24
Adding Product Categories ................................................................................................................. 24
Customer Tax Categories .................................................................................................................... 25
Tax Categories..................................................................................................................................... 26
Taxes ................................................................................................................................................... 26
Adding a new category ....................................................................................................................... 27
Adding a new product......................................................................................................................... 27
Adding attributes to products............................................................................................................. 28
Inventory................................................................................................................................................. 31
Managing Stock Diary ......................................................................................................................... 31
4. REPORTING ......................................................................................................................................... 33
Customer Reports ................................................................................................................................... 34
Reports for all customers.................................................................................................................... 34
Reports for a particular customer....................................................................................................... 34
Customer Debtors............................................................................................................................... 36
Customers Dairy.................................................................................................................................. 36
Stock Reports .......................................................................................................................................... 37
Products reports ................................................................................................................................. 37
Current Inventory................................................................................................................................ 38
Sales Reports........................................................................................................................................... 39
Category Sales..................................................................................................................................... 39
Product Sales....................................................................................................................................... 40
5. DRAWING CHARTS .............................................................................................................................. 41
Product sales charts ............................................................................................................................42
Sales charts ......................................................................................................................................... 43
Product time series charts .................................................................................................................. 44
Top 10 sales charts.............................................................................................................................. 46
6. POS INTEGRATION .............................................................................................................................. 48
Administrator’s Guide Authorization
Memorandum

I have carefully assessed the Administrator’s Guide for Wanda POS. This document has been completed
in accordance with the appropriate requirements.

MANAGEMENT CERTIFICATION – please check the appropriate statement

The document is accepted

The document is accepted pending the changes noted

The document is not accepted

X X
Redhuan D. Oon Dr. Ing Stanley Mungwe
Project Guru Project Leader / Manager
Revision sheet

Release Date Revision Description


No.
Rev. 0 Monday, September 23, 2014 Start administrator’s Guide
Rev. 1 Wednesday, October 14, 2014 Integration with iDempiere
Rev. 2 Wednesday, October 22, 2014 Wanda Documentation
Rev. 3 Friday, October 24, 2014 Stock Diary Management
System requirements

Minimum system requirements


Java Runtime Environment [JRE1.6]

Recommended requirements
Java Runtime Environment [JRE 1.8 or higher]

iDempiere

POS Integration Plugin for iDempiere

Downloading the Software


Just in case you don’t have the software yet and want to download it.

Visit the Wanda POS source forge page by clicking on the link below.

Wanda POS Source forge page

Or download directly by clicking on the download link below.

Click to download Wanda POS


Page intentionally left blank
1.GENERAL INFORMATION
a. System Overview
Wanda POS is a Point of Sale. It keeps track of all cash coming into or going out of a business by
monitoring purchase of supplies and raw materials and sales of finished products. This system is extensible
and suitable for all sorts of businesses, be them restaurants, stores, malls or supermarkets. It can be
configured to meet the particular needs of the business in question.

b. Product References

Reference Description Link


Wanda POS Support For users who seek support on http://wandaapos.com/support.html
certain issues concerning
Wanda POS
Wanda POS Download Link to download the latest http://sourceforge.net/projects/wan
version of Wanda POS daposdapos/files/latest/download?so
urce=files
Wanda POS Developers For developers who are http://wiki.idempiere.org/Cm:Camer
Support interested in working on oon
Wanda POS
Support Libraries for Wanda For other libraries needed for http://sourceforge.net/projects/wan
POS smooth operation of Wanda daposdapos/files/
POS

Wanda POS Site For users who want to visit the http://www.wandaapos.com
Wanda POS website
Wanda POS wiki For those who want to meet http://sourceforge.net/p/wandaposd
the real gurus behind the apos/wiki/Home/
success of Wanda POS

c. Authorized Use Permission


Wanda POS is a free and open source project. It is governed by the GNU Public license. As such,
anybody is free to copy any part or all of the code and modify as they please. However, whatever
development made as such must be uploaded and made open source for the world to benefit from.

d. Points of Contact

i. Help Desk

Contact Name Contact Type Department Telephone E-mail/Web


Redhuan D. Oon Project guru ERP Systems 76781554 [email protected]
Dr. Stanley Project leader Medical Surgery 79910862 [email protected]
Mungwe
Eyog Yvon Developer & Software 72469067 [email protected]
Leonce Tester Engineering
Tatiotir Developer & Software 70043657 [email protected]
Mbogning Raoul Project Manager Engineering
Sondi Michael Developer & Networks 76724430 [email protected]
Raphael Support Engineering
Fonyuy Taryuni Developer, Software 77952965 [email protected]
Isidore Support & Engineering
Documentation

ii. Coordination
This is a point of sale. Hence, Wanda POS on its own not perform any accounting operation. To
get this ability to perform various accounting tasks [such as tracking profits and losses and providing
business/managerial advice and predictions] Wanda POS works hand-in-glove with iDempiere.
IDempiere is an ERP system which Wanda POS uses to be able to perform accounting operations.

e. Acronyms and Abbreviations


Abbreviation / Acronym Meaning
POS – Point Of Sale Software system that tracks all inflow and outflow
of cash, how the cash moves, by whom, where,
when etc.
ERP – Enterprise Resource Planning Planning all financial resources well ahead of time.
Takes care of all financial calculations, predictions
based on present data and does all the accounting.

FOSS – Free and Open Source Software Software that you can obtain free of charge and
also have unlimited access to its source code.
Governed by the GNU public license. E.g. iDempiere,
OpenBravo POS, Wanda POS, VLC etc.

f. Document Conventions
Convention Explanation
Bold Buttons and links that appear the same as shown
in the demo
[This is a comment ] Any text that appears within square bracket is an
aside, a comment or an explanation of the
preceding concept.
This is the font for all new chapters.

New chapter
This is a main heading.
Main heading
This is a sub-heading.
Sub – heading
This is an example.
Example
Aside
This is an aside.

g. Buttons and Icons


Button Name Button Display Button Usage
Asterisk Use these to perform special operations on the
Plus currently open ticket
Equal
Minus
Cancel Cancel is used to abort an ongoing operation. OK is
OK used to effect it.
CE CE is used to clear a text field for new input.
Attributes Attributes is used to display the properties of an
item.
Edit Edit pops up a window for edit. Search opens a
Search filter window.
Execute Execute displays items that fulfill the specified
Reset conditions. Reset enforces default values.
Exit Exit closes your session. Logout brings you back to
Logout the welcome screen.
NO, Yes No denies an option. Yes accepts it. Save saves
Save changes.
Print Print instructs the printer to print the current
receipt.
Refund Refund opens the refund window. Refund one
refunds one unit of an item, refund line refunds all
units, refund all refunds all items.

Remove Remove drops an item from a ticket. New sale


New Sale starts a new entry. Drop sale discards the current
Drop Sale ticket from the ticket display.
Customers Displays a customer list filter. New customer adds a
New Customer new customer
Take all Used to split a bill, transfering items from one part
Take one to the other. Take all moves all units from right to
Send one left, Take one moves one unit from right to left, Send
Send all one moves one unit from left to right, Send all moves
all units from left to right.
Calculator Use calculator buttons to specify the number of
units of a particular item you want
Others

h. Wanda Documentation
The documentation of Wanda POS comprises the documents listed below

Wanda POS Installation Guide


Wanda POS User’s Guide
Wanda POS Administrator’s Guide
Wanda POS Implementer’s Guide
Wanda POS Quick Start Guide
2.GETTING STARTED
Logging On
When you launch Wanda POS for the first time you will receive a message prompting you to create a
database. Just click on Yes and let the software handle the database creation.

With subsequent launches your screen will be similar to the one shown below.

User Access Levels


There are four types of users who have different access levels.

Guest: Any user in this category is able to place an order by raising a new ticket.
Employee: Added to the abilities of a Guest user, any user in this category is able to Edit sales
and make/record payments. They can also change their password.
Manager: Added to the abilities of an Employee, any user in this category is able to manage
customers, close cash, view closed cash, manage stock and manage sales.
Administrator: Added to the abilities of a Manager, any user in this category is able to do
maintenance, configurations and printer settings.

NB: When you log in your information is displayed on the bottom right corner of the screen
Changing User ID and Password
To change passwords a user must login to their account. On the system panel [left side of the screen],

click on .

Exit System
Click on to get back to the welcome screen. It’s in the System panel on the left side of the

screen. Click on to exit the system. It’s at the bottom right corner of the window.
3.USING THE SYSTEM
Quick Tour

Horizontal Menu Vertical


Menu

Register Panel Ticket Display Calculator

Categories Display Items Display


System Panel
NB: This user guide will be approached from a user access level perspective. I.e. For any feature or
functionality under demonstration, we illustrate using a user with the minimum access levels required.

Viewing customer information


To view customer information proceed as follows

Click on in the Register panel

Click on the Customers button on the display that shows up

Click on to list all customers OR


On the pop up window use the text fields labeled Tax ID, Search key or Name, or a combination of

them to filter out the particular customer you’re looking for, then click on
From the list select the customer’s name and click on .

Example: Viewing customer information


Let’s display information about the customer named Izzy, whose search key is i.

Click on customers in the Register panel

Click on the Customers button on the display that shows up

Click on to list all customers, select Izzy from the list and click on OR

On the pop up window type i in the text field labeled Search key and click on ,

then select Izzy from the list and click on .

Closing Cash
To the cash over a specified period of time proceed as shown below.

Click on located on the Register panel to the left of the display.

Click on [located at the bottom left corner of your window], then click on

.
Example: Closing Cash
Let’s say we want to close the cash from August 20th, 2014 to October 20th, 2014. Follow the guidelines
below to do this
*1
Check below
Click on located on the Main panel to the left of the display. *1
for details on
how to use
Click on [located at the bottom right corner of your window], then click on the clock

Using the clock


Viewing Closed Cash
Usually we use the clock to set specific time frames over which we want to perform an action or get a
report. To do this we’ll use the example of a cash-by-user sales report. Let’s say we want to get a report
of all the cash that came in starting from the 3rd of April 2000, at 09:47 AM to this present moment.

Click on in the Administration panel to the left your window.

Under the Reports section click on .

Click on the clock button near the text field labeled Start date.

Click on the number on the calendar on the left side of the pop up window.

Use the Previous Month and Next Month buttons to select the appropriate
month.
If we’re in a month before April [i.e. January, February or March] click on the Next
Month button till you get to April.
If we’re in a month after April [i.e. May, June, July, August, September, October,

November or December] click on the Previous Month button till you get to April
If we’re in April, then we’re good. Just skip this step.

Use the Previous Year button and Next Year button buttons to select the
appropriate year.

Click on the Previous Year button till you get to the year 2000.

If we were in a year before 2000 you would use the Next Year button instead. *2
In the design
If we were in the year 2000 you would have to skip this step because you wouldn’t have
of Wanda
to worry. POS, for
consistency
Use the buttons to the right of the clock on the right side of this pop up window to locate the reasons and
to avoid
time. Next Hour adds an hour, Next Quarter adds a quarter of an hour [15 unnecessary
arguments, it
is assumed
that 12:00 AM
is at mid-night
minutes] and Next Minute adds a minute, while Previous Minute reduces a
minute, Previous Quarter reduces a quarter of an hour [15 minutes] and Previous
Hour reduces an hour from the current time on the clock. For this demo I will assume
that the time displayed on the clock is 12:00 AM [mid-night *2] and we want to set the start time
to 09:47 AM.

To get there from mid-night we have to go up. Click on Next Hour till the clock shows *3
If you are using
9:00 AM. Wanda POS
uses offline it
Click on Next Quarter till the clock shows 9:45 AM. uses the
timestamp
Then click on Next Minute till the clock shows 9:47 AM. from your
computer as
the current
That’s our start time. Click on to set this as the start time. time. On a
network
[online] Wanda
Click on the clock button near the text field labeled End date.
POS uses the
time from the
Click on to select the current time *3 as the end date, then click on . server.

Click on to display the report over the set period of time.

Example: Viewing Closed Cash


Let’s say we want a report on all cash closed from 20th April 2012 at 9:00 AM to 30th September 24, 2014
at 10:00 PM.

Click on in the Administration panel to the left your window.

Under the Reports section click on .


th
Use the clock to set the start date to 20 April 2012 and start time to 9:00 AM.
Use the clock to set the end date to 30th September 24, 2014 and end time to 10:00 PM.

Click on to display all cash closed within the specified time frame.

Adding New Customers


There are two ways to go about it: from the Sales window OR from the Administration panel.

Click on in the Register panel, and then click on the New Customer button
button at the top left corner of your window. OR

Click on in the Administration panel on the left side of your window and then

click on . Either one should lead you to the same


display.
The new window displayed contains a list of all customers currently on the system. Click on the

New button to clear the screen and start creating a new customer.
Provide a Search key, Name and Max debt for the customer, then fill in the rest of the
information.
If your business allows the use of cards you can provide a card number for the customer by

clicking on Create Key beside the text field labeled card. If you want to, you can remove

the key by clicking on Clear Key .


If for some reason you don’t want this customer’s name to be visible in search fields you can
toggle visibility by unchecking the check box labeled Visible .

Example: Adding New Customers


Let’s add a new customer with name Red1.

The new window displayed contains a list of all customers currently on the system. Click on the

New button to clear the screen and start creating a new customer.
Provide a Tax ID for the user e.g. Malaysia619.
We want it to be possible for someone to search r and find this user. In the text field labeled
Search key put in the letter r.
In the text field labeled Name put in the name Red1.

Click on the Edit button beside the text field labeled card.
A confirmation dialog box pops up.
Select to change the card value. If you want to remove the card value click on clear key

beside and select .


Click on the drop down menu labeled Customer tax category and select the appropriate tax
category from the drop down list.
Let’s assume we can trust this customer and allow him to burrow items to a maximum of
$10000. In the text field labeled Max debt and type in the amount 10000.
For the First name type in Redhuan and for the Last name type in Oon.
For the E-mail type in [email protected].
For the Phone type in (+237) 76 78 15 54.
Click on the Location/Address tab and type in Malingo for Address line 1.
Type in 237 for the Postal code, Buea for City, South West for the Region and Cameroon for the
Country.
Click on the Notes tab and write something to describe the user e.g. FOSS ERP Guru who is an

open source advocate. Then click on the Save button to the save the changes.

Adding Stock
Adding Product Categories
To add a new category,

Click on in the Administration panel of on the left side of your window.

In the Maintenance section click on . A list of all present


categories is displayed.

Click on Add New to clear the screen for a new category.


In the text field labeled Name, provide a name for the category.
If you want this to be a sub-category under another category click on the drop down menu
labeled Category and select the category you want to place it under.
If you have a representative image of the types of products in this category you can add it.

Example: Adding Product Categories


Let’s create a category for drinks
Click on in the Administration panel of on the left side of your window.

In the Maintenance section click on . A list of all present


categories is displayed.

Click on Add New to clear the screen for a new category.


In the text field labeled Name, type in the name Drinks.
We can make this a sub-category under Refreshments. However, we’ll have to create
the Refreshments category first.
Let’s provide an image for this category. Click on the Images button . Use the pop up
window to navigate the picture you want to use. Once you find the picture on disk, select the

picture and click on . Use Zoom Out [to add] and Zoom In [to reduce] to
adjust the size of the picture to your satisfaction. In case you don’t want the picture anymore
you can remove it by clicking on Remove Picture .
Click on to allow the category to be displayed on the catalog when queried OR

to stop it from being displayed.

Customer Tax Categories


To add a new Tax customer category

Click on in the Administration panel of on the left side of your window.

In the Point Of Sale section click on . A list of all present


categories is displayed.

Click on Add New to clear the screen for a new category.


Give a name for the category.
Click on the Save button to save.

Example: Customer Tax Categories


Let’s create a new customer tax category and call it Global Taxes.

Click on in the Administration panel of on the left side of your window.

In the Point Of Sale section click on . A list of all present


categories is displayed.

Click on Add New to clear the screen for a new category.


In the text field labeled Name, type in Global Taxes.
Click on the Save button to save.

Tax Categories

Click on in the Administration panel.

From the Point Of Sale section display select


Click on the New button to clear the screen for a new entry.
Give a name for the category.

Click on the Save button to save.

Example: Tax Categories


Let’s create a new customer tax category and call it Standard Taxes.

Click on in the Administration panel.

From the Point Of Sale section display select


Click on the New button to clear the screen for a new entry.
In the text field labeled Name, type in Standard Taxes.

Click on the Save button to save.

Taxes
To add a new tax,

Click on in the Administration panel.

From the Point Of Sale section of the display select .


Click on the New button to clear the screen for a new entry.
Provide a name for the tax.
Use the drop down menu called Tax category to select a category for the tax.
Use the drop down menu called Customer Tax category to specify a customer category for the
tax.
Enter the tax rate.

Click on the Save button to save.

Example: Taxes
Let’s add a new tax and call it VAT which we intend to make a Standard tax and Global tax effective 4
hours from now.
Click on in the Administration panel.

From the Point Of Sale section of the display select .


Click on the New button to clear the screen for a new entry.
In the text field labeled Name, type in the name VAT.
Click on the drop down menu labeled Tax category. From the list of tax categories displayed
select Standard taxes [which we created earlier].
Click on the drop down menu labeled Customer tax category. From the list of customer tax
categories displayed select Global taxes [which we created earlier].
Enter the tax rate, 1.25

Click on the Save button to save.

Adding a new category


To add a new category of products proceed as follows

Click on in the Administration panel.

Click on . A list of all present categories of products is


displayed.
Click on the New button to clear the screen for a new entry.
Provide a name for the category.
If you have an image that depicts the variety of products in this category you can upload it as
follows.
Click on the images button .
Use the pop up window to navigate to the location [on disk] where you have the image
stored.
Once you find the image, click on to upload it.

Click on to allow this category to appear on the display OR to stop it from


appearing.

Click on to register this new category.

Adding a new product


To add a new product proceed as shown below

Click on in the Administration panel.

Click on . A list of all present products is displayed.


Click on the New button to clear the screen for a new entry.
Provide a name for the product.
If you have an image that depicts the product you can upload it as follows.
Click on the images button .
Use the pop up window to navigate to the location [on disk] where you have the image
stored.
Once you find the image, click on to upload it.

Adding attributes to products

Click on in the Administration panel.

Use the buttons , ,

and to specify attributes for products.


There is no better way to illustrate this than the use of an example. Please follow the example
below.

Example: Adding Sub-categories, products and attributes to products


Let’s say our business also deals with the sale of drinks. We want to sell different kinds of drinks and
each of these drinks have specific properties that differentiate them and we want our customers to have
access to this information. E. g. consider the picture below

Drinks

Wine Guinness Booster

Red wine White Guinness Big Small Whisky Pina


wine smooth Guinness Guinness Cola Colada

Cold Cold Cold Cold Cold Cold Cold

Hot Hot Hot Hot Hot Hot Hot

Frozen
Hush up let’s make the necessary entries. First we’ll create a category called drinks, which will comprise
3 sub-categories; Wine, Guinness and Booster. We’ll create the attributes and finish by creating the
products placing them in the categories and giving them the attributes.

Click on in the Administration panel.

 Click on the , then click on the New button to clear the


screen for a new entry.
 In the text field labeled Name type in the word Drinks.
 If you have an image of a drink you can upload it as follows.
Click on the images button .
Use the pop up window to navigate to the location [on disk] where you have the image
stored.
Once you find the image, click on to upload it.

Click on to add it to the catalog, then click on to save.


Repeat the process to add 3 other categories; Wine, Guinness and Booster. To make them sub-
categories there’s just one extra thing you have to do.
When creating each of them click on the drop down menu labeled Category and, from
the drop down list, select the category called Drinks which we just created above.

To add the attributes we’ll start by creating attribute sets. Click on in the

Administration panel, then click on .

Click on the New button to clear the screen for a new entry.
In the text field labeled Name type in the word Red wine [this will be the name of the attribute

we shall attach to Red wine], then click on the Save button to save.
Repeat the process to add attribute sets for white wine, Guinness smooth, big guinness, small
guinness, whisky cola and pina colada.
Now we’ll add product attributes to each of these. To add the attributes we’ll start by creating

attribute sets. Click on in the Administration panel, then click on

.
Click on the drop down menu labeled Product attribute and select red wine from the drop down

list, then click on the New button to clear the screen for a new entry.
In the text field labeled Value type in the words Red wine [this will be one of the attributes Red

wine], then click on the Save button to save.


Do the same for the Hot and Frozen tastes of red wine, then also do for all the Cold and Hot
tastes of all the other drinks shown on the chart above.
We’ll now give attribute values to these. That’s what will be displayed on the customers ticket

when they make their order. To do this, click on in the Administration panel,

then click on .

Click on the New button to clear the screen for a new entry.
In the text field labeled Name type in the word Red wine - Cold [this will be the name of the

attribute we shall attach to Red wine], then click on the Save button to save.
Do the same for the hot and frozen tastes of red wine. Then, select a different product attribute
[Guinness smooth, Small Guinness, Djino cocktail etc.] and add their own attribute values until
you’ve gone through for all of them.

Now let’s attach these attribute values to our products. To do this, click on in the

Administration panel, then click on .

Click on the New button to clear the screen for a new entry.
In the text field labeled Order type in a number e.g. 1, click on the drop down menu labeled

Product attribute and select an attribute. then click on the Save button to save.

Click on the New button to clear the screen for another new entry. Enter a different
number for Order and select a different Product attribute.
Repeat the process till you have exhausted all product attributes. Then select a different
attributes set and do the same for all its attributes, till all product attributes of all product sets
are exhausted.

Let’s add products. Click on in the Administration panel, then click on


.
*4
Click on the New button to clear the screen for a new entry. The Barcode and
the Reference
Enter the words Red Wine in the text field labeled Name. Also, enter the number 1 in the text must be
numbers. They
field labeled Reference, same for the text field labeled Barcode *4. must each be
Enter the buy price [price at which you buy a product] and sell price [price at which you sell]. unique, but must
necessarily be
Click on the drop down menu labeled Tax category and select a tax category from the drop the same. i.e. if a
down list. If you don’t intend to place any taxes on this, select Tax Exempt. product has
barcode 1 no
For the category select Wine [Red wine is a drink, but it’s also a wine and all wines are drinks. other product
can have barcode
That’s why we’re not putting it under drinks.] 1, but any
For the attributes select Red Wine. product can have
reference 1. If a
If you have a photo for red wine you can upload it. To do that, follow the steps shown earlier. product has
reference 1 no
Once you’re done click on the Save button to save. Follow the same steps to add all the other product
can have
products shown on the chart above. reference 1.
Inventory
Managing Stock Diary
Every now and then you’ll have to get new stuff from your suppliers. You’ll have to record these
transactions such as purchases, refunds, movements, sales & breakage on the system.

(In) Purchase: Use this when you make a purchase.


(In) Refund: Use this if you sell products (in bulk) and the client wants to return them.
(In) Movement: Use this in case you receive products from another branch of your company.
(Out) Sale: Use this to make a bulk sale.
(Out) Refund: Use this in case you make a bulk purchase and decide to return the products to
your supplier.
(Out) Breakage: Use this when products in your stock get bad (and cannot be sold).
(Out) Movement: Use this when you are moving stock from your branch to another branch of
the business.

Example, Managing Stock Diary – (In) Purchase


Let’s assume we’ve just made a purchase and received 500 boosters, 100 bottles of white wine and 200
bottles of baileys. Let’s record this transaction.

Click on in the Administration panel.

In the Maintenance section click on .

Click on the New button to clear the screen for new input.
To go through with this transaction you have to search for the product. You can do this by using
the product id, barcode or product name. (NB: for this example we’ll be using the product
name.)

Click on the search button (Search Product List) to the right of the greyed-out text field
labeled Product.
On the product list window that pops up click on the drop-down menu labeled Category and
select Drinks from the drop-down list.

Click on to display the list of all products within this category [Drinks].

Select Booster from the list and click on .


Click on the text field labeled Units and enter the number 500.
Click on the drop-down menu labeled Reason, then select (In) Purchase from the drop-down
list.
Click on the drop-down menu labeled Location and select your stock location from the drop-
down list.
If the product has different flavours [different types of the same product which are registered on

the system] click on the Product Attributes button and select the particular flavor you just
added to your stock.

Click on the Save button to this transaction.


Repeat the same process to enter to enter 100 bottles of white wine and 200 bottles of Baileys.
Run an Inventory: Difference report to confirm that the products were actually recorded in the
system.
4.REPORTING
Customer Reports
At times we may want to know who our customers are, where they live, how much they owe, how much
they’re allowed to owe, payment deadlines etc. You can get this info for all customers or for a particular
customer.

Reports for all customers


Click on in the Administration panel on the left.

In the Reports section, click on .

Click on to generate the report for all customers.

Example, Reports for all customers

Click on in the Administration panel on the left.

In the Reports section, click on .

Click on to generate the report for all customers.

Reports for a particular customer


Click on in the Administration panel on the left.

In the Reports section, click on .

Click on the customer list button to the right of the text field labeled Customer.
Use the pop window to pick out the particular customer you’re searching for.
Click on , select the customer’s name, then click on .
Then click on .

Example, Reports for a particular customer


Let’s say we want reports on a customer named Pauline.

 Click on in the Administration panel on the left.

 In the Reports section, click on .

 Click on the customer list button to the right of the text field labeled Customer.
Enter the customer’s TaxID, Search key, Name or a combination of them. In our case I’ll just
enter p for the search key.

Click on . [This filters out all customers with a search key that starts with p].
Click on the customer’s name [in our case I’ve clicked on Pauline].
Then click on to single out the customer.

Then click on Execute report to display a report on this particular customer [Pauline].
NB: Use the tools in the toolbar to customize the view or size of the display. You can also print of export
to a specific document format.

Customer Debtors
Every now and then customers will fail to meet their payment deadlines. It’s very easy to know who has
and who hasn’t met their deadlines. You must not go through every customer report to know who
hasn’t.

Click on in the Administration panel on the left side of the window.

Under the reports section click on .

Click on . A list of all customers is displayed alongside their account ID, address
and current debt.

Customers Dairy
At time we just want to look at the general picture. In-flow and out-flow of cash, payments, tickets etc.
Customers diary is the place for this.

Click on in the Administration panel.

 Under the reports section click on .


 Set the appropriate filters: customer, start date and/or end date.

Click on to display the report.

Example, Customers Dairy


Let’s say we want a report of all Pauline’s financial activities from September 7, 2013 at 12:47 AM to this
present moment.
Click on in the Administration panel.

Under the reports section click on .


Click on the Customer button to the right of the text field labeled Customer.
On the pop up window enter the Tax ID, Search key and/or name of the customer you’re
searching for.[in our case it’s Pauline, so I’ll just enter p for the search key].

Click on . In case you made a mistake click on to filter all over.


This on the customer’s name , then click on .

Click on the calendar to the right of the text field named Start date.
Set the date to September 7, 2014 and the time to 12:47, then click on .

Click on the calendar to the right of the text field labeled End date.
Click on , then click on .

Click on to display the output.

Stock Reports
Products reports
At times you want to know exactly what products you have and in what amounts, or what products
satisfy a certain constraint or set of constraints. This is how to go about it.

Click on in the Administration panel on the left side of your window.

In the reports section of the new window click on .


Click on to list all products in stock OR
Use the form above the display to set the appropriate constraints and then click on .

Example, Products reports


Let’s say we want a list of all drinks sold for $500 or greater. Proceed as follows

Click on in the Administration panel on the left side of your window.

In the reports section of the new window click on .


Click on the drop down menu labeled Category and select Drinks from the drop down list.
Click on the drop down menu labeled Sell Price and select Greater or equal from the drop down
list. In the text field beneath it type in the amount 500.
Use the form above the display to set the appropriate constraints and then click on .
Current Inventory
To get your current inventory proceed as shown below.

Click on in the Administration panel on the left side of your window.


In the reports section of the new window click on .
Click on to list all products in stock OR
Use the form above the display to set the appropriate constraints and then click on .
Sales Reports
Category Sales
Click on in the Administration panel on the left.
In the Reports section click on .
Use the calendar to set the Start Date and End Date for the report.
Click on to display the report for the set time period.
Product Sales
To get a product sales report,

Click on in the Administration panel on the left.

 In the Reports section click on .


 Use the calendar to set the Start Date and End Date for the report.
Click on to display the report for the set time period.
5.DRAWING CHARTS
Product sales charts
This gives a graphical representation of how much of each product that satisfied a specified constraint
(or set of constraints) was sold over a specified period of time.

Click on in the Administration panel on the left part of your window.

In the Charts section of the window displayed click on .


Use the clock to set the boundaries of the period under consideration and the form below it to
set the appropriate constraints.

Once the boundaries and constraints are set click on .

Example, Product sales charts


Let’s say we want to know how much of each drink was sold for $500 or greater from 1:00 PM of
Saturday, September 20, 2014 to this very moment.

Click on in the Administration panel on the left part of your window.


In the Charts section of the window displayed click on .
Click on the calendar beside the text field labeled Start Date, and then use the clock to set the *5

date to September 20, 2014 and time to 1:00 PM *5. Check above for
details on how to
Click on the calendar to the right of the text field labeled End Date, click on and then click use the clock.

on .
In the section just below the clock [the section labeled ‘By Form’]. Click on the drop down menu
labeled Category and select Drinks from the drop down list. Select Distinct from the drop down
list labeled Name.
Select Greater or equal from the drop down list labeled Sell Price. Click on the text field below it
and type in the amount 500.

Click on to display the appropriate chart.


Sales charts
This gives a graphical representation of the sales made for each category of products over a specified
period of time.

Click on in the Administration panel on the left part of your window.

In the Charts section of the window displayed click on .


Use the clock to set the boundaries of the period under consideration and the form below it to
set the appropriate constraints.

Once the boundaries are set click on .


Example, Sales charts
Let’s say we want a graphical representation of sales made for each category of products from 1:00 PM
of Saturday, September 20, 2014 to this very moment.

Click on in the Administration panel on the left part of your window.


In the Charts section of the window displayed click on .
Click on the calendar beside the text field labeled Start Date, and then use the clock to set the *5

date to September 20, 2014 and time to 1:00 PM *5. Check above for
details on how to
Click on the calendar to the right of the text field labeled End Date, click on and then click use the clock.

on .

Product time series charts


This gives information about the sales of products which satisfy a specified constraint over a specified
period of time.

Click on in the Administration panel on the left part of your window.

In the Charts section of the window displayed click on .


Use the clock to set the boundaries of the period under consideration and the form below it to
set the appropriate constraints.

Once the boundaries are set click on .

Example, Product time series charts


Let’s say we want information about drinks that were sold for $500 or greater from 1:00 PM of Saturday,
September 20, 2014 to this very moment.

Click on in the Administration panel on the left part of your window.


In the Charts section of the window displayed click on .
Click on the calendar beside the text field labeled Start Date, and then use the clock to set the *5

date to September 20, 2014 and time to 1:00 PM *5. Check above for
details on how to
Click on the calendar to the right of the text field labeled End Date, click on and then click use the clock.

on .
In the section just below the clock [the section labeled ‘By Form’]. Click on the drop down menu
labeled Category and select Drinks from the drop down list. Select Distinct from the drop down
list labeled Name.
Select Greater or equal from the drop down list labeled Sell Price. Click on the text field below it
and type in the amount 500.

Click on to display the appropriate chart.


Top 10 sales charts
This gives a graphical display of the top 10 most sold products. On the display a distinction is made total
sales (taxes included), taxes and net sales (without taxes). To get this display proceed as follows.

Click on in the Administration panel on the left part of your window.

In the Charts section of the window displayed click on .


Use the clock to set the boundaries of the period under consideration.

Once the boundaries are set click on .

Example, Top 10 sales charts


Let’s say we want to see the top 10 products sold from 1:00 PM of Saturday, September 20, 2014 to this
very moment.

Click on in the Administration panel on the left part of your window.

In the Charts section of the window displayed click on .


Click on the calendar beside the text field labeled Start Date, and then use the clock to set the
date to September 20, 2014 and time to 1:00 PM *5.
Click on the calendar to the right of the text field labeled End Date, click on and then click

on .

Click on to display the appropriate chart.


6.POS INTEGRATION
Wanda POS integration with iDempiere is very useful for businesses with different parts that have to put
up with asynchronous communication for data retrieval and synchronization. This asynchronous
communication is made possible by the use of a middle server, the ActiveMQ service. As such, this
section of the Administrator’s Guide is written with the assumption that you have iDempiere installed
and have the ActiveMQ service running properly. Screen shots are taken from the demo done on a
windows machine, but if you’re using a different operating system you’ll be just fine.

NB: For more information on using iDempiere [best ERP system in the world], visit …

First we have to start up the ActiveMQ middle server.

When you first start, as you see, there are no messages sent to ActiveMQ.
Now we switch to iDempiere where we have the POS Integration plugin installed already. Open up the
menu tree “External POS Integration.” It contains all the processes and windows necessary for
synchronization with Wanda POS.
For the purpose of this demo we’ve added a new product on iDempiere ERP, with product info shown
below.

Name: “Grass Seed Container”


Product Category: “Standard”
Tax Category: “Standard”
For this product we’ve also added a price list with info shown below

List price: “80.00”


Standard price: “75.00”
Limit price: “72.00”
Let’s assume we have 12 units of this product in stock at HQ. So we’ll set ‘quantity in hand’ for this
product to 12.

NB: The 12 units of this product we have are in the HQ stock. So when we synchronize with Wanda POS,
we’ll only be able to do so with the Wanda POS station for which POS Locator Name is “HQ.”
On the ‘External POS Synchronization’ tree, click on the process named “Export Data To Queue.” The
window shown below pops up.
We’ll use this to provide the necessary information that will enable us synchronize with the particular
Wanda POS station we’re targeting [in our case, “HQ”].
Host: localhost
~ The host to which ActiveMQ is currently listening. We’re doing this demo on our local
*5
machine, so we’ve set the host to “localhost.” Your case may be different if you’re no The value must be the
testing on a local machine. t
same as the value in
Port: 61616 the file
wandapos.properties.
~ The port to which the ActiveMQ server listens.
Products Queue Name: Products
~ This is the queue name in ActiveMQ to which the process will send the products during
synchronization *5.
Customers Queue Name: Products
~ This is the queue name in ActiveMQ to which the process will send customers during
synchronization *5.
Username: admin
~ This is the username for the ActiveMQ server.
Password: *******
~ This is the password for the ActiveMQ server.
Product Category: Standard
~ This is the product category for the product we want to synchronize.
Customer Category: “Standard Customers”
~ This is the customer category for the product we want to synchronize.
Price List: “Standard 2003”
~ This is the price list for the product we want to synchronize.

NB: This process exports products per POS Locator Name (Organisation / Station). i.e. if you are
exporting 20 products for 5 different Wanda POS stations, they will be exported in 5 different queues
(each indicating the number of products exported for that particular station) in ActiveMQ.

When all information is correctly entered, click on start. After synchronization you’ll see a confirmation
window similar to the one shown below.

Once you see the window shown above, switch to the ActiveMQ server. You’ll see a new message sent.
All products in all stations are sent to ActiveMQ, but only the Wanda POS station you targeted (i.e. pos =
HQ) can synchronize products and customers in the queues targetted. In our case, it’s “HQ.”
Note: The key used to identify each Wanda POS station is “POS Name Locator” (pos key in
wandapos.properties file)

As such, when you synchronize, you have to be sure of the following

Customers and Products Queue Names must be the same in both Wanda POS and iDempiere.
POS Name (<entry key="pos">HQ</entry> in wandapos.properties) must match one
organization in iDempiere ERP.

Now it’s time to lunch Wanda POS. When you lunch Wanda POS for the first time, as you can see below,
there is only one category: “Category Standard” which has one product.
Click on Maintenance in the Administration panel on the left side of the window, then click on

. Scroll down and select the resource named wandapos.properties. You have to modify
this file according to the ActiveMQ server configuration, queue name (Products and Customers) you set
when exporting the data from iDempiere.
Go back to the Maintenance menu [in the Administration panel on the left side of the window] and click

on . The database manager responds after a few seconds and we have a pop up
window displaying information about the imported data.
Go back to the Maintenance menu and click on Products. [Remember that initially we had just one
category: “Category Standard”, with one product]. After synchronization we see extra categories and
products which have been imported as a result of the synchronization.
Click on the Sales button on the Main panel. Make an order or a couple of orders [we’ll use this as a
demo for synchronizing orders back to iDempiere] as shown in the User’s Guide. Once you’re done
making the order(s) click once again on the Maintenance button in the Administration panel on the left

side of your window. Then click on . A few seconds later you’ll get a confirmation
similar to the one below.
Back in iDempiere ERP, click on the process “Import Orders from POS”. You’ll see a screen like the one
below.
Fill in the appropriate information and click on Start.

After a few seconds you should get a confirmation similar to the one in the screen shot below.
In the External POS Synchronization tree click on the process named “Process Imported Orders.” You’ll
see a pop up similar to that shown below. Click on the drop down arrow in the toolbar. Notice that there
orders information has changed as a result of the import from Wanda POS.

Special thanks to Redhuan D. Oon for his original idea about integrating aDempiere with OpenBravo
POS.

You might also like