ERP FOR ENGINEERING MANUFACTURING COMPANIES

No. 19

Newsletter

01 December 2024

  Tip

In OurSys, in every report there is a provision to select the date range and you can set the date range permanently using the masters.

But there is a shortcut to do so as well. In the filter page click on "Columns to Display". You will find 3 dots on the right side. Click on them to see a dropdown of date ranges to select. Select the period as required and click on 'Save Date Range' link.

For example, all report by default are set to financial year and thus in April suddenly the data is not visible. But you can change the range to something like 'Since 3 months' to see last 3 months data every time.

  Did you know?

Customer Outstanding report, by default, shows receipts tagged to invoices as well as Advances or On Account receipts.

But you can choose to see either 'Pending Bills Only' or 'Advances & On Account Only'

In the filter pop-up under 'Show' choose the desired option.

 

  Understanding Reports

Report Name Stock Ageing Valuation Report
Where to find it Under Stores under the Reports section under Stock Valuation Sub Section
Who should use this Management, Planning & Finance
What frequency to check: Once a month
Filters for the report You can filter the report by many parameters. It is recommended to filter this report before opening as it could be heavy. You may filter by Item Category or Sale / Purchase etc.

Screenshot of the Report

This report can be filtered in various ways as shown above.

This report can be filtered in various ways as shown above.

You can click on any amount to check the lot details and reach upto Purchase requisition to investigate why the stock was bought.

You can click on any amount to check the lot details and reach upto Purchase requisition to investigate why the stock was bought.

 

Information in the report & how to use it:

  • This report shows the stock value with ageing.
  • You can filter this report in various ways such as filtering by item categories and find why the stock has not been utilised.
  • This report should be part of your monthly management review.
  • Keeping a tab on the report can help you free up precious cashflow. Team can be made more accountable for the items being bought or produced. Inventory to turnaround ratio will improve.

 

  Notification

  • OurSys version 24.48 has been released. Many new features added.

  • We hold workshops to introduce and discuss new features released in the version. We request all to attend these workshops to utilise OurSys in a better way.

  • Those who have missed earlier workshops can see the video recordings

 

  What's new

  • Record of Deleted Uploads now available
    Earlier it was not possible to know whether any uploaded document was deleted. It is now possible to track the deleted documents.
  • Option to list 'Amended Sales Orders'
    It is now possible to filter out only amended sales orders.
  • Previous BOM copy option added to Enquiries as well
    For customers using Enquiry level BOM, it is now possible to quickly copy BOM from previous enquiry.
  • Batch size added for distributing Setup Cost
    This will make cost estimation more realistic.

  Article

An article on 'Distinct advantages of OurSys AMC'

This is the best time for Indian manufacturing companies and we can actually see global opportunities for our customers.

Most of our customers are growing at a good speed which is reflected in their growing shopfloors, setting up of new factories and even getting listed on the stock exchange.

Read the full article

 

  Case Study

Tagging Transporter expenses to multiple invoices

Customer Introduction:

This customer is a major valve manufacturer and supplies valves & fittings for various projects.

Problem / Goal:

It is required to calculate gross profit for every order that is executed. The material cost and the process cost gets captured in OurSys as the item gets manufactured. But one important component of transport cost was getting missed. The transporter gave one invoice at the end of the month with details of the trips made. The cost was not getting transferred to individual sales orders.

The Solution:

We have provided a feature in OurSys ERP to tag single invoice of transporter to multiple sales invoices. The transport cost gets auto allocated proportionately on the sales invoices that are tagged based on their values.

The Result / Benefits:

The transport cost thus got accounted for each sales invoice. OurSys Sales Order wise Gross profit report and Invoice wise gross profit report now started showing profits after accounting for transport charges.