ERP FOR ENGINEERING MANUFACTURING COMPANIES

Book Demo

Home

Industries

Processes

About

Blogs

Book Demo

No. 42

Newsletter

13 November 2026

 Tip

In case you wish to see what was the sales last year upto today's date, go to DiY setting wheel and select "Year to Date" (YTD) function to see data compared between last year and this year until today's date. Similarly you can apply this YTD filter to any report.

 

 Did you know?

Did you know that you when you click on any document number in OurSys it gets copied automatically. You can then paste (CTRL+V) any where to use it. This is handy to copy and paste in filters to view data for the document. Example copy the PONO and paste in the filter for GRN to see all the GRNs connected to the PO.

 Best Practice

You must ideally use Title Case for masters such as Customer names, Employee names and Supplier names. The legibility is better than full capital case and technically more correct than sentence case. You must also maintain consistency for better looking reports and a better impression on customers & suppliers. Example Sunil Gavaskar is better than Sunil gavaslar or SUNIL GAVASKAR.

 

 Understanding Reports

Report Name Items not sold & having stock Report
Where to find it MIS >> Invoice >> Insights
Who should use this Production, PPC, Finance and Management
What frequency to check: Once a month
Filters for the report Between dates, Customer and for a condition when Stock >0

Screenshot of the Report

Report showing list of saleable items which have not been sold in the selected period.

Report showing list of saleable items which have not been sold in the selected period.

Image 3: Nov26_Report_Img03

Image 3: Nov26_Report_Img03

Set the filter to show items where Stock >0

Set the filter to show items where Stock >0



Information in the report & how to use it:

  • This report shows all the Saleable items which have not been sold in the selected period and yet they are available in the stock
  • This informs PPC to study and take a call on the stock of these items. Planners can either salvage these items or management can push Sales to sell these items.
  • This report also shows WIP of these items. Ideally this should have been zero. You can also create another version of this report showing Items which have not been sold in the given period and WIP >0
  • This report thus helps to free-up precious cashflow and reduces ageing of inventory.
 

 Notification

  • We are launching Ziddle AI next week. This will be available for all our OurSys customers from 23rd November. Ziddle AI advises the CEO on which decisions must be taken and which questions to be asked based on the trend of data recorded in various departments of OurSys ERP. Ziddle is an independent software and after the first phase where it runs over OurSys, it will also run on any other ERP and for any other industry as well. Interested customers can see a free demo of how Ziddle works on OurSys. Do let us know if you are interested. See theziddle.com

  • In order to increase effectiveness of OurSys, please run the Qualitative Audit Report. You will find it under MIS >> System Health. We recommend that this report must be printed and filed every month. The deviations and mistakes are listed department wise. Department heads must be given this information so as to help them improve the quality of their data. Your data is most precious in this AI world and therefore this our attempt to help you control the quality on continual basis. Such a facility is called DataOps and there are separate software for the purpose. We have provided this free of charge within OurSys. Kindly take advantage of the same.

 

 What's new

  • You can now assign a secondary location to an employee in addition to the primary location. This is useful in various scenarios like running MRP where the user can then select the location before running the MRP.
  • Just like the Purchase Requisition we have introduced Job Order Request feature to request manufacturing of a certain item. This is an optional feature control feature.
  • Just like material purchase followup email, we have now introduced automated follow up email for pending outsourced material.

 Article

From ERP to AI: It's Time to Unlock the Goldmine of Information in Your Manufacturing Business

Back in the late 1990s, ERP systems began making their way into India's SME manufacturing sector. Until then, most businesses used software primarily for accounting. But as the new millennium approached, customers began demanding ISO certifications, documented processes and better control over business operations. Manual systems were becoming increasingly cumbersome, while Excel spreadsheets had their limitations in handling growing volumes of business data.

Read the full article
 

 Case Study

Employee Master Asset History

Customer Introduction:

This company is a multi-location manufacturing company.

Challenge

Company provides laptops, mobile phones and sometime instruments to their staff depending upon their department and roles. But a formal record of these assets was not getting recorded in the ERP. Therefore finding out who has what assets was cumbersome.

The Solution:

OurSys introduced Asset Master, Asset Handover and an Asset history tab in the Employee master.

Whenever an asset like the laptop is handed over to an employee, admin has to go to Asset Handover menu and make an entry. This reflects in the employee master under the Asset tab as well. Plus it makes an entry into Asset history.

This is a very simple yet useful functionality of OurSys ERP.

The Result / Benefits:

We can now easily find out assets with an employee and the history of movement of assets over the period of time.