Download the Sample Application
We are going to learn more automation features with the illustrations of a real life 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 File)
You can download and unzip “Order, Purchase & Inventory System” application files in any location. Let’s say it is saved in the drive D:, and it looks like this :
Inside the folder, there are one setting file “order – with sample data.dbp” which holds the settings and formulas of the worksheets, one database file “order – with sample data.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 “order – with sample data.dbp” from Mian Menu:
About Order, Purchase & Inventory System
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:
Sales Order > Purchase Order > Supplier Invoice > Invoice > Inventory
Sales Order > Purchase Order > Supplier Invoice > Invoice > Inventory
The system starts off by entering confirmed orders from customer in Sales Order worksheet. The ordered articles are first checked in Inventory to find if there are enough existing items. Purchase Order is then sent to supplier requesting for the necessary items. When supplier’s articles arrived, the information of arrived articles is entered in Supplier Invoice. 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 issued respectively.
In case the goods needs to be returned to Customer or Supplier, Customer Return and Debit Note are issued respectively.
Sales Order > Invoice > Customer Return
Sales Order
Confirmed order is received from customer. Sales Order worksheets includes customer information and requested articles.
Confirmed order is received from customer. Sales Order worksheets includes customer information and requested articles.
Invoice
When item goods are to be sent to customer, an Invoice entry is created. Stock quantity will be subtracted when Invoice is created.
When item goods are to be sent to customer, an Invoice entry is created. Stock quantity will be subtracted when Invoice is created.
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.
When articles needs to be returned from customer, create an entry in Customer Return. The articles will be added back to stock quantity.
Purchase Order > Supplier Invoice > Debit Note
Purchase Order
Purchase Order is created to request goods delivery from suppliers.
Purchase Order is created to request goods delivery from suppliers.
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.
After sending purchase order request to supplier, the goods arrived and supplier invoice is created. Stock quantity will be added to the inventory.
Debit Note
When articles needs to be returned to supplier, create a Debit Note to supplier.
When articles needs to be returned to supplier, create a Debit Note to supplier.
Inventory, Activity
Inventory
The Inventory worksheet shows the quantity of each articles in inventory. This is a reporting worksheet so that people cannot update data here. Records in the Inventory worksheet are created and calculated from these worksheets – Invoice, Customer Return, Supplier Invoice and Debit Note.
The Inventory worksheet shows the quantity of each articles in inventory. This is a reporting worksheet so that people cannot update data here. Records in the Inventory worksheet are created and calculated from these worksheets – Invoice, Customer Return, Supplier Invoice and Debit Note.
Activity
This is also a reporting worksheet which enclosed all document entries created in Sales Order, Invoice, Customer Return, Purchase Order, Supplier Invoice and Debit Note. This is provided as a quick tracing of the works happened.
This is also a reporting worksheet which enclosed all document entries created in Sales Order, Invoice, Customer Return, Purchase Order, Supplier Invoice and Debit Note. This is provided as a quick tracing of the works happened.
Customer, Supplier, Articles
Customer
This worksheet holds customer records.
This worksheet holds customer records.
Supplier
This worksheet holds supplier records.
This worksheet holds supplier records.
Article
This worksheet holds article records.
This worksheet holds article records.
