Few Updates…

The Software has been updated to optimize and give better experience of performance.

In Reports->Automation Analysis module earlier the Lost Customer used to take lot of time to generate report, now it is optimized to give faster result with accuracy.

Reports->Inventory->Stock/Product Ledger-><Stock Ledger>. Pressing <Stock Ledger> button used to ask a question, which was confusing and people used to get misled and not decide whether to click yes/no. Now software automatically decided it needs to be ReProcessed or give report from last processed. In fact you can now over-ride to Re-Process the data to give updated result. Earlier it used to take lot of time to process all the items sometimes even 15-30 minutes, Now it is optimized and gives result lightening fast and almost instantly. In-fact now one can generate daily stock movement report without wasting any time.

Reports->Accounts->Ledger Accounts is also optimized to automatically decide if it requires to fetch the data again. If you do not change the Date selection period and ledger that you want to print but wish to select different format would earlier reprocess every time you chose to select different format or just plan to print ledger with Narration or without, but now it will instantly print the result if you choose to view report with different combination of choice.

Reports->Sales->Sales Analysis is also updated to allow you to export only monthly summary data, which earlier would export all the transaction for the selected month(s) and would take too long depending on the number of transactions, now warns you of time it would take and omit exporting transactions detail thereby finishing task swiftly.

Reports->Sales->Sales Register (Credit Sales), which earlier allowed you to select only specific month, now allows you to select any period for all or selected customer and may be get details of all the bills of a particular customer in entire year and so on….

sales register credit sales

sales register

Reports->Sales->Sales Register (Credit Sales), <Sales Register Tab> is also updated with two more options a) Customer wise Item Value (Invoice_No) and b) Customer wise Item Qty (Invoice No) to extract and export customer-wise lifting details invoice wise as shown in image below:

Invoice Item Details

Invoice Item Details

Just click on the Customer Name in the Top Grid and it will list out all the Invoices for the customer with Item details in every Invoice and Just click on Export to Excel button at the bottom of the screen to export all the Invoices details as you see on the screen.

Reports->Accounts->Tax Details->Sales Tax Details, now gives Yearly/Monthly Tax analysis for purchase as well as sales along with the Category-wise, Tax% wise and Item-wise tax calculation as shown in the screen below:

Vat Tax Analysis

Vat Tax Analysis

Just Click on Export to Excel button at the bottom of the screen to analyse the data and use for tax submission.

All above requirements are also very much useful for auditing purposes.

Advertisements

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

 

%d bloggers like this: