Thursday, 19 September 2019

Shopbook Screenshots

Sales Register - Make Invoices and Bills, Quotations, Delivery Notes, Stores Demand and Issue Voucher and generate Daily Sales Report Purchase Register – Register Purchase Bills, Make Purchase Order, Request for Quotation, Goods Receipt Voucher and generate Daily Purchase Report Receipt Register - Manage Receivables, Generate Statement of Receivables, Receivables Summary and Vouchers List Payment Register - Manage...

Saturday, 24 August 2019

Recording Incomes and Expenses

On clicking the LEDGER button on the Keyboard, the GENERAL LEDGERS form opens, Expenses and other Incomes related to the business are recorded and accounted through this form. Enter the date of the transaction in the box on the extreme left and tab on to proceed to the subform where the details of expenses or incomes are entered Select the respective account head from the Account Combo box and proceed to enter the particulars, nature of transaction, amount and job in their respective fields’ viz. Particulars, Book, Income or Expense and Job  The...

Registering a Purchase

After Downloading, Installing and Launching the Software and Log in with the Admin Password of 12345 you will reach the Keyboard, On the Keyboard clicking the PURCHASE button will open the PURCHASE REGISTER, This form serves as the Purchase Register, where Purchase Orders can be made or Purchase Invoice registered. To register a Purchase, A Vendor / Supplier account should be created and the Purchasing materials added - To register a Vendor / Supplier click on the VENDORS button on the bottom of the form. The CONTACTS form will open, click...

Registering a Sale

Please go through Registering a Purchase before reading this post – Since, if you have learned the Purchase section you have also learned the Sales section as the layout and logic of both these sections are the sameOn clicking the SALES button on the Keyboard, the SALES REGISTER opens, This form serves as a Sales Register, where sales invoices can be made.To make a sale, A Customer account should be created, To register a Customer click on the CUSTOMERS button on the bottom of the form, The CONTACTS form will open, click on the ADD button to add...

Registering a Payment

On clicking the PAYMENT button on the Keyboard, the PAYMENT REGISTER opens, Accounts Payable is made easier and dealt with in this form. Select the name of the Vendor / Supplier to which money is paid in the Paid To combo field on the top left of the PAYMENT REGISTER form and tab on to enter the Total Paid Amount, Remarks and proceed to the subform. All the Purchase Orders / Purchase Invoice made or entered through the PURCHASE REGISTER will be available in the subform, select the order / invoice against which the payment...

Registering a Receipt

Please go through Registering a Payment before reading this post – Since, if you have learned the Payment section you have also learned the Receipt section as the layout and logic of both these sections are the same.On clicking the RECEIPTS button on the Keyboard, the RECEIPT REGISTER opens, Accounts Receivable is made easier and dealt with in this form.Select the name of the Customer from which money is received in the Received From combo field on the top left of the RECEIPT REGISTER Form and tab on to enter the Total Receipt Amount, Remarks and...

Use of Keyboard Shortcuts

Not familiar with keyboard shortcuts? Most likely using the mouse to select and item from the drop down list (eg. customer id, vendor id or material code etc.) Using the mouse for this purpose will slow the work.So here is a way to speed up, To select an item from a drop down list (combo box) just bring the curser to the field and press Control (Ctrl) and then down Navigation Key, this will open the drop down list from where you can select the required item by further pressing the down Navigation Key.Likewise the following keyboard shortcuts will...

Material Registration and Generating Barcodes

In the Material Register form (path – PURCHASE REGISTER > MATERIALS > CLICK HERE TO ADD NEW MATERIAL) you will find field in the name of Category. when you determine a code for an item, it should be in such a way that it is identifiable with the Category under which it is registered. for eg. let’s register a Dell Laptop. This item will fall under Catagory: Laptop So the Coding for this item can be LAP001 (With Catagory Code LAP and Serial No. 001)Another Acer Laptop can be registered as LAP002 and so onFor Category Mobile Phone...

Generating Statements and Reports

On clicking the STATEMENT button on the Keyboard, the STATEMENTS & REPORTS form opens, This form contains a variety of financial and accounting reports which can be accessed by clicking on their respective buttons; the reports on the form are as below: ITEM LIST PRICE LIST STOCK UPDATE STRAY STOCK SALES STATEMENT PURCHASE STATEMENT COSTING & PRICING REPORTS...

Login and Password

Looking for Password?… Select User Name as “Admin” and type Password “12345” and press ENTER on the Keyboard.Note: it is recommended that users change the default Admin Password for better security and to avoid unauthorized acce...

Friday, 23 August 2019

Adding Users and Business Setup

On clicking the ADMIN button on the Keyboard, the ADMINISTRATION form opens, this is the form where new user accounts are created, click on ADD USER and fill in the required fields to add new user. Existing Users and their Level of Access can be edited by selecting the user in the box on the bottom right and clicking on the OPEN button. For Setting Business Details open Shopbook and follow the Path - KEYBOARD >> ADMIN >> ADD USER - Now Add or Edit the already existing credentials of Users with your Business Name and Details. The ADMIN...

Explaining the Keyboard

After login with User Name and Password, the Keyboard opens with a variety of buttons and Parameter fields, The buttons include, Purchase, Sales, Payment, Receipt, Ledgers, Statement and Admin - on clicking which will open the respective forms for Data Entry.In the middle of these buttons, you will find the SUPER button which will open the Super Sales Register suitable for Supermarkets and busy cash counters where invoices can be generated with great speed and enhanced security. Selecting any particular Branch in the Branch Combo box will show...

Install Instructions

After download unzip the shopbook.zip folder and run setup to install software, Upon opening will be prompted for UserName and Password Select UserName as Admin and type Password 12345To install the barcode font open the barcode folder and right click on IDAutomation-Barcode-Font.ttf and click Install and complete the installation.For users who would like to use the latest version of Microsoft Access Runtime can download and install the latest Runtime365 from Microsoft website athttps://support.office.com/en-us/article/download-and-install-office-365-access-runtime-185c5a32-8ba9-491e-ac76-91cbe3ea09c9Notes:...

Thursday, 1 August 2019

Disable Microsoft Access Security Notice

Access 2007 and later versions of Access use trusted locations as a security measure to help prevent users opening a database from an unknown source. Typically, if you open a database that is not in a trusted location, Access will display a security message asking if you want to open the file. With the full version of Access trusted locations can be added manually using the Trust Centre, for this follow the steps provided below:…Open Microsoft Office Access on you computer, thenClick the Microsoft Office Button and then click Access Options. In...