reinnovate database

Download the Sample Application

We are going to learn more automation features with the illustrations of a real life sample application. You can download the app files to play with it side by side. You are going to understand how easy and simple it is to build a multi-functional real database application by using BAU DB.

Open Workbook (Application Files)

You can download and unzip the sample application files in any location. Let’s say it is saved in the drive D:. It looks like this :
the files inside the program folder of the application.
Inside the folder, there are one setting file “trade-goods.dbp” which holds the settings and formulas of the worksheets, one database file “trade-goods.mdb” which is the actual database file holding the working data, and 3 Excel spreadsheet files which are the document printout template files for the worksheets.
After downloading the files, you can open the application by selecting the setting file “trade-goods.dbp” from Mian Menu:
open and select the dbp file in main menu

About the Sample Application

This application is made for merchandise company which buys goods from suppliers and sells goods to customers. The application includes the following worksheets listed in the normal operation flow:

Order > Purchase Order > Supplier Invoice > Invoice > Stock
worksheets of the trading system
The system starts off by entering confirmed Order from Customer in Order worksheet. The ordered articles are checked if there are any in Stock items. Purchase Order is then sent to supplier requesting for the necessary items. When supplier’s articles arrived, Supplier Invoice is entered. It is then ready to send the requested articles to customer and create an Invoice entry.

In case the goods needs to be returned to customer or supplier, Customer Return and Debit Note are used respectively.

Order > Invoice > Customer Return

Order
Confirmed order is received from customer. Customer Order worksheets includes customer information and requested articles.
customer order worksheet
Invoice
When item goods are to be sent to customer, an Invoice entry is created. Stock quantity will be subtracted when Invoice is created.
invoice worksheet
Customer Return
When articles needs to be returned from customer, create an entry in Customer Return. The articles will be added back to stock quantity.
customer return worksheet

Purchase Order > Supplier Invoice > Debit Note

Purchase Order
Purchase Order is created to request goods delivery from suppliers.
purchase order worksheet request goods from supplier
Supplier Invoice
After sending purchase order request to supplier, the goods arrived and supplier invoice is created. Stock quantity will be added to the inventory.
supplier invoice worksheet
Debit Note
When articles needs to be returned to supplier, create a Debit Note to supplier.
debit note send to supplier with returned goods

Stock, Activity

Stock
The Stock worksheet shows the quantity of each articles in inventory. This is a reporting worksheet so that people cannot update data here. Records in the Stock worksheet are created and calculated from these worksheets – Invoice, Customer Return, Supplier Invoice and Debit Note.
stock shows the quantity of articles in stock
Activity
This is also a reporting worksheet which enclosed all document entries created in Order, Invoice, Customer Return, Purchase Order, Supplier Invoice and Debit Note. This is provided as a quick tracing of the works happened.
activity worksheet shows all kinds of document entries

Customer, Supplier, Articles

Customer
This worksheet holds customer records.
customer worksheet
Supplier
This worksheet holds supplier records.
supplier worksheet
Article
This worksheet holds article records.
article worksheet

Working with an Example Application

Download the example application files to better understand how BAU DB works. Unzip the file folder in any location of your hard drive. In Main Menu of BAU DB, click "O" to open the file "trade-goods.dbp", which is inside the unzipped folder.