Product Sales Analysis and Customer Analysis introduced.

New Feature introduced for Product wise Sales Analysis and Customer Analysis on product purchased by customers.

Just Click on Report->Inventory->Stock/Product Ledger.

to See the two new tabs added in the Stock Ledger form.

SALES ANALYSIS

For Item-wise Sales Analysis you may click on <Sales Analysis> Tab to see the following screen.

Item-wise, Sales type wise Sales Analysis

Product Sales Analysis

Please observe the TreeView populated with Items/Products on the Top Left Corner. Just Click on the Item or Category.

For e.g. You can click on Category FUEL ITEMS or ULP, HSD, etc., under the Fuel Items Category to see the Monthly summary for the Item/Category selected below the TreeView / Bottom Left Corner of the Screen.  Also you will find the Sales Type wise summary and Transactions for all the sales type below the summary grid for full financial year 1st April, 2011 to 31st March 2012 in the above screen. Also it gives the list of Customers who have purchased the selected product in the order of value highest to lower.

Just Click on a particular Month Grid (on lower left corner) to view the Sales Type wise Summary for the particular month and the transactions for the said month.

Now, you can also click on particular Sales Type to view the transactions for the selected Sales Type in the Transaction grid below the Sales Type summary grid.

Just click on the Excel <Button> with icon/logo  <X> ( a  logo for Excel) displayed to the left of Total on lower left of the screen to export all the grids in different sheets as shown below:

Sales Transaction Export to Excel

Sales Transaction Export to Excel

Please observe the Sheets at the bottom of the  image shown above.

Monthly_Movement showing the Monthly Sales summary

Sales_SlipType-wise showing the summary of Sales for the Sales Type

Transaction_Detail shown in the above image

and

Customer_Lifting showing the Customer-wise total purchase by each customer in the order of highest to lower.

CUSTOMER ANALYSIS

Just click on the Tab <Customer-wise Item-wise> to see the following screen:

Customer wise Sales Analysis showing Item-wise lifting.

Customer wise Sales Analysis showing Item-wise lifting.

Please observe the TreeView populated with Items/Products on the Top Left Corner. Just Click on the Customer to see the Monthly summary for the Selected Customer  below the TreeView / Bottom Left Corner of the Screen.  Also you will find the Item-wise lifting summary and Transactions for the All Items just below the summary grid for full financial year 1st April, 2011 to 31st March 2012 in the above screen.

Just Click on a particular Month Grid (on lower left corner) to view the Item-wise lifting/sales  Summary for the particular month and the transactions for the said month.

Now, you can also click on particular Item  to view the transactions for the selected Item  in the Transaction grid below the Item-wise Sales summary grid.

Please observe the Radio Button option

  • Date-wise
  • Vehicle-wise

on the center of the screen above.

Just click on the desired option to view/export data date-wise or vehicle wise as shown in the excel sheet image below:

Just click on the Excel <Button> with icon/logo  <X> ( a  logo for Excel) displayed to the left of Total on lower left of the screen to export all the grids in different sheets as shown below:

Customer-wise Sales Analysis Exported to Excel

Customer-wise Sales Analysis Exported to Excel

Top of the are in the above excel sheet image shows dump of transaction exported date-wise and bottom of the image shown in coloured shades showing vehicle-wise, date-wise export of transaction along with the following sheets.

Monthly_Movement

and

Item-wise lifting

Pump-boy/Salesman/Cashier-wise Sales and Collection.

Software updated to capture the salesman/cashier/pump-boy information for the following modules:

a) Credit Sales

b) Cash Sales

c) Credit Card Sales

d) Petro-card Sales

e) Cash Expenses and Cash Receipt

This feature is available by switching on the option by checking on the check-box -> Allow to Enter Salesman details for Sale/Cash  in

Administration->Configuration Screen->General Tab

Configure Software to Enter Salesman-wise, pump-boy wise sale/expenses

Turn on Salesman-wise, pump-boy wise sale/expenses

By turning on option, it will now allow to accept salesman, pump-boy, cashier name in the above modules  as shown in the following screen.

Pump-boy entry shown with Arrow in Credit Sales Module

Credit Sales Entry Screen

Same way you will find the Cashier name selection in voucher for Cash Receipt and Cash Payment – Expense vouchers.

Meter Reading module is also updated to Select pump-boy for the nozzle sale.

Various new reports will be provided to get cashier-wise / pump-boy wise details. Daily Shift Report (cashier / pump-boy wise / salesman wise).

The above was so far available in the system by keying in the salesman wise information in Meter Reading form <Denomination> button to key-in above sales information in the datagrid for the selected salesman/cashier/pump-boy. Also you could enter the cash receipt and payment in <Sales Summary> tab and enter in Cash Collection depsited with cashier/office with Denomination of notes and count as shown in image below:

Pump-boy / Cashier wise Sales Entry Module

Manual Salesman-wise Sales Entry Module

The advantage of manual entry for salesman meter reading / sales is you can enter two different sales man for the same nozzle in the same shift, which otherwise is not possible as unique salesman is assigned for meter reading for the given shift.

Note the <Fetch Data> button in the above image, Pressing this button will  fetch the data from the transaction for the salesman during the shift and refresh the figures in the Sales Summary Tab.

Whats New

30/09/2010
Introduced new features Whats New.

The New features Whats New is accessible from Menu Help->Whats New.

As the name suggests, Whats New pertains to what is new in the software or the new updates available in the software. Every time any changes or update in the software or fixing of bug in the software is now updated and uploaded on the blog, which can be viewed from the software by clicking on the whats new menu item.

So now, you can click on Whats new before downloading the software to check if any important changes/updates in the software useful for you, then you can download or continue using the same last version.

In fact, whats new takes you to in-built web browser now provided in the Quicksoft ArtRMPP software. So now, you don’t need to come out of the software to surf or visit any site or for google search, etc., When you click on whats new, it by default takes you to the https://artrmpp.wordpress.com a blog site created specifically to upload the changes in the petrol-pump software and notify existing customers of updates in the software, which otherwise was very difficult and time consuming to inform to all the customers. Informing all the customers would also be costly and highly time consuming if to be informed by calling each of them, even mailing would not reach to all the customers as people use multiple email accounts and so on.

In the browser, we have also provided the Bookmark Button button next to Go Button to save the url surfed by you just like add to favourite provided in Internet Explorer. Also you can goto any of your favourite site by clicking on the My favourite button in the tool bar. By default following sites are added in the My Fvourite
https://artrmpp.wordpress.com
http://www.quicksoftservices.com
http://www.petrolpump.co.in
http://www.google.com
http://www.teamviewer.com
http://www.iocl.com
http://www.hindustanpetroleum.com
http://www.bharatpetroleum.in
http://www.ril.com
http://www.essar.com
http://www.petrolplaza.com

Also there is a Quicksoft Services logo/button provided to switch to http://www.quicksoftservices.com

Mass Mailing / Mail Merge
Now you can send mail to your customers, suppliers or employees the email from inside the software by clicking on the Utilities->Mail Merge menu item. In fact, in the previous version also the Mail Merge was working to send the email, but it was using the cumbersome MAPI protocol, the Mail API Protocol would use the Mail Outlook which was also slow and not very reliable to send the mail through vb application. So now, we have changed it to use built in CDO protocol to send the email.

Just Select the customer, suppliers or employees to whom you would like to send the email. Click on the particular customer for which the email address is already entered in the customer master. As soon as you click on the customer it would display the email address for the selected customer in the text box. Next enter the text you would like to send and select the attachment / file to be send as attachment and select text format for body text as HTML or Text format. You can also copy paste you HTML code in the body text area to send the text as HTML message.

Click on the Send Message to send the email.

Loss on Sale of Lube

29/09/2010

While entering the Slip/Indent entry at times it is required to know, if there is no loss on sale of lube or fuel. ArtRMPP, now shows the alert for any loss on sale of every item that is being sold so as to correct the selling price or at-least have knowledge on loss that will be incurred. At the time of saving transaction also the ArtRMPP will show warning on loss that will be incurred if transaction is saved. However, user can change the selling price to minimize the loss or abandon the transaction altogether. If out of lets say three items in the bill say there is a loss in two items as given below but profit in one item will be calculated and will be notified of actual loss on bill

1. MAK 2T 5L -1200
2. ULP +200
3. MAK ELITE 1L -100

Will give the total loss of Rs.1100/-

Delete Fuel Item Pricing
Now it is possible to delete a particular Fuel Item pricing entry for a particular item for a given date. If user finds that there are wrong fuel item pricing entered in the system and would like to correct then it is now possible to remove the wrong fuel item pricing entry. Also you can search the Fuel Item Pricing for a particular item or for the particular date for all the item and so on.

Just double click on the Item for which the Item Pricing entry is to be removed and then click on the delete button to delete the entry.

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:

Excel Sheet containing Meter Reading Data

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

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.

Tax Invoice for Lube/Oil Sale

25/09/2010

At many petrol-pump outlets the Oil/Lube is sold in bulk or wholesale unlike the retail sale of oil. In such case it is required to issue Tax Invoice.

Quicksoft ArtRMPP now takes care of Tax Invoice generation. To be able to generate tax invoice and not disturb regular invoice as most users do not need tax invoice, we have provided this feature in
Administration->Configuration Screen->Invoice Tab.

You simply need to enable Tax Invoice by checking on the “Allow me to generate Tax Invoice by selecting Invoice type in Slip Entry” check-box. By Checking on the Check-box when you goto slip entry through credit slip or credit slip cum invoice option, it will now display the Invoice type frame above the save button for every transaction with default set to “Regular Invoice”, if you want the invoice being generated to be “Tax Invoice” then you need to select the Tax Invoice Radio Button. So when you print the invoice it will use the Tax Invoice file name specified in the Configuration Screen.

23/09/2010

Now you don’t need to goto Invoice form to edit/delete the “Slip Cum Invoice”, you simply need to click on “Slip Details” tab and select the Invoice you wish to edit/delete. Earlier version did not display the invoice generated in slip details. Please note that this feature is available only for Slip Cum Invoice i.e. Invoice generated for the slip right through slip entry form or invoice generated for the slip on the same day unlike Invoice generated for slips through invoice form.

Also lease note that Credit Slip Entry form will still not show the invoice generated as they are supposed to be edited/deleted through Invoice form. Slip Details tab will show only the slips for which the invoice is not generated. The slips get locked for which the invoices have been generated.

Department-wise billing: Now you can also generate Multiple Invoice for different departments for the same account/customer/party. All you need to do is while defining the vehicles for the customer you have to specify the department code/name for the vehicle for which it belongs to and also specify “Department-wise billing” as “Yes” in the customer master so as to generate different bills for the same account as the same customer would be making payment for all the departments.

Vehicle-wise Subtotal: If there are multiple vehicles for the customer and if customer wishes the single invoice to be generated for the multiple-vehicles but wants the subtotal to be printed for different vehicles then you just have to specify “Vehicle-wise Subtotal” as “Yes”. Otherwise it will print the Slip-Date/Slip No wise printing and not the vehicle-wise.

<span>%d</span> bloggers like this: