Daily MIS on TIPS Page and Improved Workflow.

13th January, 2014

Greetings!

Wish you all a Very Happy New Year.

With the new update, now you need not worry about the Date Selection while entering Meter Reading Entry, Slip Entry, Voucher, Dip, etc., Whatever Date and Shift is selected on the TIPS page will now be set for the respective from called from TIPS page. Earlier user would forget to Select the Date/Shift and data would get entered for different Date/Shift, which requried to be Edited and so on…

Also New, Button <MIS> is Introduced Next to Date/Shift selection on the TIPS page as shown below:

Daily MIS on TIPS

Daily MIS on TIPS

When you click on MIS button you will see All the Transaction for the selected Date/Shift with Opening Cash Balance for the Selected Date/Shift and actual Cash Receipt/Payment duly Added/Subtracted from the opening balance and available Cash Balance duly computed shown at the bottom-left of the screen as shown below:

Daily MIS with Cash Balance

Daily MIS with Cash Balance

Also find new Grids, Item-wise Sales summary and Sale Type Wise Item-wise Sales Summary below the Meter Reading Grid. The best part is that all the Information displayed on the form can be exported to Excel by just pressing the <Export to Excel> Button on Bottom-Left of the Screen. Please find below the screen dump of Excel Export Screen of MIS:

Daily MIS Export to Excel

Daily MIS Export to Excel

How To Cut Back Your Car Fuel Consumption Costs

artrmpp:

Nice Tips on Increasing fuel efficiency of your car.

Originally posted on sampsonewuzie's Blog:

Cars And Fuel Consumption

Cars And Fuel Consumption

Everybody knows, even the whole world know it, that to own a car is not an easy task most especially here in Nigeria very expensive. It’s not enough, you will need to pay for your car documentation and the renewal every year, you’ve also got to deal with equally ridiculous fuel and maintenance costs. Maybe that’s why we have such a love/hate relationship with car ownership in Nigeria. But we hate the huge cost that comes with owning a car.

While you can’t lower the cost of buying a car, you can lower your fuel and maintenance costs with some cheap and simple guidelines. Here are experts’ advices on what you can do to make driving less expensive and drive safely this festive period and later as the case maybe:

Watch your speed limits: The biggest way you can save money on petrol is to obey…

View original 524 more words

How to become Dealer/Distributor for IOC Oil Marketing Business.

How to become Dealer/Distributor for IOC Oil Marketing Business.

Q: How to get a New Dealership/Distributorship of Oil Marketing Companies in India.

Ans: Generally Oil Marketing companies releases advertisements for new Distributorships in Newspapers in Hindi, English and other vernacular language of the area. Kindly look for such advertisement, in your location of interest. Selection would be made from the applications received in response to such advertisements meeting the eligibility criteria given therein. For further details you may view our Brochure/Application form on dealership/distributorships of respective oil marketing companies as given below or contact regional office :

Indian Oil Corporation Ltd.
http://www.iocl.com/Talktous/Guidelines.aspx

Hindustan Petroleum Corporation Ltd.
http://hindustanpetroleum.com/Downloads

Bharat Petroleum Corporation Ltd.
http://www.bharatpetroleum.in/dealer/dealerSection.asp

Bulk Voucher Posting and Merge Account Ledger…

Greetings!

Release Date: 11th Nov, 2013.

Ver: 2.1.100

Club Accounts

Now you can merge two ledger with ease. There are times when user by mistake creates the same ledger account twice and after having entered vouchers in both ledgers realizes to club them and get rid off one.

To Merge two accounts and get rid off one ledger Just go to Masters->Account->Ledger Master. On the Ledger Master form you will find new Tab <Merge Ledger> as shown below.

Image

In the “Transfer Transaction From Source Ledger” frame, Just Select the Account you wish to get rid off

and

Select the Account with which you wish to merge/club In the “Merge Transaction with the Existing Ledger” frame

On Selecting the respective ledger it will show you the Ledger Entity Type, Number of entries found and opening balance entered, if any.

On Clicking the <Merge> button it will ask you to confirm the action and finally before deleting the Source Ledger, it will again ask you to confirm the deletion of the ledger.

Bulk Voucher Posting

Voucher->Auto Post Voucher Tab

At petrol-pumps daily there are repetitive work and regular expenses which is some times forgotten just due to work-load. Also at the month-end there are regular expense vouchers like salary payment which is really cumbersome for petrol-pump as there are 15-25 pump boys and entering voucher for each of them is really time taking.

We have tried to simplify the above process by allowing user to select the multiple ledger accounts and create the list of expenditure for which you wish to automatically post the voucher as shown below:

Image

 

Just Select the ledger in “Create Expense List for Auto Voucher Posting” frame and Click on [ -> ]  or  [ <- ] button to select and un-select the ledger from the list and then cilck on <Bulk List> button to populate the list in “Bulk Post Pre Defined Payment Voucher” frame as shown above. The Voucher Date will make sure the voucher is posted on the date entered. Just make sure you enter the correct value and Click on <Save Bulk Voucher> button to save the list and also save each account as a separate voucher.

Pressing <Clear> button will clear the list and allow you to generate the fresh list.

 

User Access Changed to Revoke Edit/Delete Records.

6th Nov, 2012

Important Security Fix to Protect Editing and Deletion of Transaction by Users.

Now, you can disable your users from editing or deleting of transactions by Revoking Edit/Delete rights through Employee Master as shown in below given screen.

Apply / Revoke Edit/Delete rights for Users

Apply / Revoke Edit/Delete rights for Users

Just Click on <List of Employees>and Click on the Name of Employee in the Grid and Click on Edit to Change the Access Rights for the Employee.

On Removing the <CheckBox> Edit/Delete Records the Employee logging with his/her username, password will not be able to edit or delete any record for any Master or Transaction.

The Employee to whom the rights are given and Default Admin user will be able to edit or delete records.

Other Changes Include, change of background color for the row/record which you wish to edit/delete is now same for all the modules, which was not visible earlier in various modules. Also Edit/Delete button is now Switched On and Off correctly on Single Click and Double Click through out all the modules.

* Also Customer Selection by Name in Slip Entry is fixed to select the Customer by Name if set in Configuration Screen instead of Default selection by Account Number.

Now, you can easily find the difference in Sale as per Meter Reading and as per the sale entered through Slip/Indents/Coupons.  Ideally, you Sale as per Slips should tally with the Meter Sale, but if there is any descripancy then so far it was difficult to find the mistake in particular day/date/shift. With the New Tab introduced in Report->Sales->Sales Analysis, now you can easily find the descripancy in a particular month with just a single click as shown below:

Meter Sale v/s Slip Sale

Meter Sale v/s Slip Sale

Just Click on Meter Reading Tab on Top Left.

then Click on the Particular Month for which you wish to View descripancy, if any.

then Click on <Daily Meter Sale vs Slip Sale> Tab next to <Daily Meter Sale – Itemwise > to see the date wise descripancy.  If there is any descripancy then you will see it in the last Column <Diff>.

Ideally, the Diff should be 0.00 or at most less than Rs.1.00, but if the diff is in thousands then either of the following:

Either the Auto Cash Sale entry for the day / shift is not entered

or

There may be a change in selling rate in slip as against the rate in Meter Entry

or

The Slip sale is entered or edited after the Auto Cash Sale is done and so on.

Ledger code can now be Edited/Updated!

Version 2.1.55

Since, quicksoft ArtRMPP – petrolpump management software is creating separate database for each year, at times there are issues relating to ledger synchronization and this feature update is to handle that issue.  There are pros and cons of having separate database file for different accounting years. With separate database for each accounting year there is a safety of data, it is also faster to work on less amount of data for the chosen year as compared to several years data to be queried. From statutory point of view also it is advisable to not allow to edit/update balances or stock after the finalization of balance sheet and so on.

However, when new year gets created ArtRMPP software allows to transfer all the ledger and item stocks to new year on 31st March or 1st April of next year so that one can start working in the new year immediately and avoid back-log. By practice, the provisional trial balance is carried forward to new year on 1st April as some expense voucher, journal entries and adjustment entries are being posted at a later date, even some provisional and outstanding entries are required to be posted over a period of time.

So far, it was not possible to assign code to ledger by users as it was protected and automatically assigned by system.  But because new ledgers are created in new financial year as well as previous financial year, which lead to descripancy.

We will explain above with an example: Let’s say accounting year (1-4-2011 – 1-4-2012) had 235 ledgers, which when carried forward to (1-4-2012  to 31-03-2013)  all the 235 ledger gets carried forward and if there are no new ledger codes created in either of year then there is no problem in again carrying forward closing balance from previous years database, which is possible through Administration->Update Oepning Balance from Previous Year (closing balance) option.

The problem was when in the new year say a New customer ABC is created, which automatically get 236 ledger code assigned and similarly in previous year say a ledger required to be created say OUTSTANDING EXPENSES… which also get ledger code 236, so when user updates opening balance from previous year the wrong balances get carried forward for ledger code 236 as ledger ABC would have balance of OUTSTANDING EXPENSES… With Version (2.1.55) you can now create new ledger with ledger code of your choice and even edit the existing code to new ledger code of your choice and system will change ledger code for any existing data in the system as shown below:

ledger code validation

ledger code validation

In fact, user need not worry about new ledger code, as system automatically assigns new available ledger code as earlier, but simply allows user to edit/change which earlier was not available.

Ideally, in the New Financial Year, one should create just one ledger with value 1001 instead of 236 as the first new ledger to be created and after that all new ledgers will be created with ledger code 1002, 1003, 1004… and so on. So, when you update opening balance from previous year all the new ledgers created in previous year 236,237,238… will automatically get transferred correctly without any problem.

Follow

Get every new post delivered to your Inbox.

Join 1,178 other followers

%d bloggers like this: