Quicksoft PetrolPump Software Updated – Version 2.1.49

Version 2.1.49
Date Updated: 14th June, 2012

All Daily Transaction can now be exported to Excel.

Reports->Petrolpump->Daily MIS: All Petrol-pumps maintain their daily transactions on piece of paper or excel sheet, therefore we thought of providing them with the data on excel sheet so that they can easily verify the details and keep record of shift data in excel also.

Daily Entries

You can now select particular shift and export all the transaction mentioned below for the chosen shift

a) Meter Reading

b) Credit Sales Slip Details with Vehicle Details

c) Credit Card Sales

d) Petrol Card Sales

e) Credit Service (Fuel) Sales

f) Cash Sales (Fuel)

g) Cash Sales (Non-Fuel)

h) Credit Sales (Non- Fuel)

i) Credit Card / Petro Card Sales (Non-Fuel)

j) Credit Service Non-Fuel

k) Cash Receipt

l) Cash Payments

m) Purchase

n) Dip Entry for the Shift.

2.Bank Reconcilliation

can now be Printed without Clicking the Update Button. Now you can edit or delete the Uncleared cheques of the last year.

3. Purchase->Fuel Item Pricing

can now simply be Edited by Pressing Enter Key on the Last Column (Current Sell Price) . If Item Pricing for the Selected Date is already existing then system will just update the price and if the pricing does not exist for the chosen date then it will create the entry for the selected date. It will also warn you if you do not save before exiting.

4. Letter Head Printing:

Report->Sales->Customer Details (CRM)-> Misc Tab now allows you to print the Letter Head for the stationery chosen by user. Report file(s) needs to be sourced from quicksoft.

5. Cheque Printing:

Reports->Accounts->Voucher/Cheque Printing: Now you can print the Cheques as per your cheque size by clicking on Cheque Printing Tab on the form and select the date range and click on the transaction to print the cheque. You can simply key in the information for

a) Name of the Party

b) Cheque Amount  and

c) Cheque Date

Click on Print Preview Button to print the Cheque. Report to be sourced from quicksoft.

6. Meter Reading

is now Changed / Resized so as to not scroll and resize the columns which was earlier required. Also now you don’t need to use Mouse to use this module as it automatically positions to the Meter Closing/End.

7. Vehicle Master

was not opening, bug now fixed.

8. Customer Master:

New Account Number now automatically assigned to new customer and Mandatory field phone number is now brought on top frame so that user no longer need to press several Tab or Enter key to reach the phone number field. Just Enter the Name, Phone Number and press Alt-S to save the data.

9. Customer A/c Opening Form:

Customer Details Tab New button is provided to print the contract for credit custoemrs. Just click on “Credit A/c Contract” button to print the A/c opening form for credit customer.  Report to be sourced from quicksoft

Advertisement

Import Meter Reading and Dip Data.

28/09/2010

Now, it is possible to Import the bulk meter reading data and dip entry data in the software without keying in manually. This is very useful particularly, in case when user intends to go online without entering data manually for past months.

Import Meter Reading Data
It is now also possible to Import Meter Reading Entry data. You will find a New Tab introduced in the Meter Reading and Dip Entry form. In the Import tab you will be asked to select the Excel File containing the Meter Reading Data / Dip Data, Click on button to select the excel file. After choosing the Excel File, user will be asked to select the Sheet containing the data for the Meter Reading/Dip Entry. By Default Excel Workbook has Sheet1, Sheet2 and Sheet3 but user may have renamed the excel sheet and therefore user will be asked to select the sheet name in which the data for the Meter Reading and Dip entry is stored. After choosing the Sheet, user has to click on the button to populate the data for the sheet in the Grid below the Populate button. If the data contained in the sheet is verified as correct then user has to click on to Import the data to the Shift Meter Reading.

Data contained in the Excel sheet should be as per the Specification given below:

Meter Reading Data

Column 1: Should contain the Shift Date, which should be in dd-MMM-yy format i.e. 01-APR-10
Column 2: Should contain the Shift_ID (1,2,3) as created in Shift Master.
Rest of the columns can contain the Meter Reading data as desired but the Column heading specification should be as given under:
e.g.
where stands for Nozzle Description as given in Nozzle Master for ULP/Petrol Nozzle Number 1 in above example. should be followed by to specify that the column contains the Meter Reading Data for the said nozzle.

Similarly for Testing data for the said nozzle you have to specify the column name as to contain the data for Petrol Nozzle 1 and so on.

Please note that the First row of the excel sheet should contain the Column Heading specifying the Data contained in the column, Second Row being the Opening Meter Reading for the First day in the sheet and third row containing the Meter closing for the first day and Meter Opening for the next day, fourth row onwards the closing meter reading data for the date in the first column and so on.

Import Dip Entry Data
Just as Import Meter Reading data mentioned above, it is now also possible to import Dip Entry data. To Import the Dip Entry data, procedure to be follow is exactly as mentioned in import meter reading data above.

1. Select the Excel File
2. Select the Excel Sheet to Import which contains the Dip Entry Data
3. Click on Button to populate the data contained in the selected sheet to preview before actually imprting data.
4. Click on Import Data button to Import the data.

Data contained in the Excel sheet should be as per the Specification given below:

Import Dip Reading Data

Column 1: Should contain the Shift Date, which should be in dd-MMM-yy format i.e. 01-APR-10
Column 2: Should contain the Shift_ID (1,2,3) as created in Shift Master.
Rest of the columns can contain the Dip Reading data as desired but the Column heading specification should be as given under:
e.g.

where stands for Tank Name as given in Tank Master for ULP/Petrol Tank in the above example. ULP should be followed by to specify that the column contains the Dip Stock Volume Data for the said Tank.

Similarly for importing the Dip Reading data for the said Tank you have to specify the column name as to contain the Dip Reading data in CM as per the calibration chart for Petrol Tank and so on.

Please note that the First row of the excel sheet should contain the Column Heading specifying the Data contained in the column, Second Row onwards being the Dip Reading data for the date in the first column and so on.