Insight: The capacity to gain an accurate and deep understanding.
Accounts Payable – Outstanding Debts
An Accounts Payable Outstanding Debt overview (or ‘AP Outstanding Debt’) is a vital accounting document that outlines the overall debt a business needs to pay (‘State of Debt’, so to speak). Read how a tedious, manual, inaccurate and inefficient process of producing an Accounts Payable Outstanding Debt (broken-down into CapEx and OpEx debt classification) has shortened from over a month (for each report) to a one-time effort of slightly over a day that could be reused any time.
Running the AP Outstanding Debt overview powered by Insight SAP Suite assures it is native within SAP, unlimited in terms of the length of the overview’s period. For the office of the CFO, ultimately Insight SAP turns the issuing of the AP Outstanding Debt report from a liability to an asset. Consequently, the healthcare organization is in an advantageous proactive position (rather than a reactive one) with regards to its debt management and financial risk policies.
Sensitive fields – Approval Process
Accounts Payable – Aging Report
An Accounts Payable Aging Report (or ‘AP Aging Report’) is a vital accounting document that outlines the due dates of the payments a business needs to pay to its suppliers. Read how a tedious, manual, inaccurate and inefficient process of producing an AP Aging Report has shortened from over a month (per report) to a one-time effort of slightly over a day, followed by several hours of processing each new report.
Running an AP Aging Report powered by Insight SAP Suite assures it is native within SAP, unlimited in terms of the number of past years included within the report, while including the actuals for the present financial year. For the office of the CFO, ultimately Insight SAP turns the production of the AP Aging Report from a liability to an asset. Consequently, the Electrical equipment supplier organization is in an advantageous proactive position (rather than a reactive one) with regards to its debt management and financial risk policies.
Warehouse Work Order Monitor
In the semiconductor industry, downtime of manufacturing machines is very costly and must be minimized in order to optimize production.
, the leading foundry of high-value analog semiconductor solutions (‘Tower’) is very sensitive to manufacturing machinery’s downtime and is constantly seeking ways to reduce it. One of the identified improvement opportunities was by monitoring and improving the release time of ordered parts and items from the warehouse to the production line.
Newly appointed management changed the visibility, transparency and management standard of work orders’ turnaround. Ultimately, the better the Turnaround SLA KPIs are, the quicker the turnaround time between the posting of work-orders and releasing of the items. The result would reduce the downtime delays and extensions as a result of fewer delayed parts that are held back in the warehouse.
Until recently, the warehouse staff communicated with their internal customers by email. The warehouse received a work order by email, issued the requested item and communicated by email to the internal customer whenever needed. These emails were not consolidated in one place, nor the warehouse professionals or managers could have a high-level view of work orders status (e.g. Number of open items at any given moment, the processing status of each work order, or whether there were any issues worth mentioning).
The warehouse management sought a solution that could provide different views (depending on the role), such that it would be efficient to structure the monitoring of all work orders that arrived at the warehouse. The management sought also for a system that would reflect the live SAP ERP data and that would be very easy to create and later on to adjust and maintain.
The SAP competence team would have invested nearly a month in developing such a solution, had they been acquainted with Insight SAP Suite.
With SAP’s PM module, production line staff members may trigger a work-order which is routed through an approval workflow to the warehouse. Tower re-used an existing historic ABAP Query and diffused all work-orders through Insight SAP. With Insight SAP, Tower enhanced the ABAP Query & SAP standard report results by adding various columns. For instance, Tower added formula columns as well as columns with inventory information from other SAP tables. Each work-order is automatically tagged within the Priority Text column (please see the 4th column from the left at the screenshot below). Then, by using conditional formatting, Tower highlighted (in) and prioritized open work-orders which are causing machine-downtime delays, for immediate processing.
Tower defined the Warehouse turnaround SLA (between the work-order’s posting time and the item’s release time) as 20 minutes. With Insight SAP, Tower has easily highlighted work-orders that exceed this SLA definition. Moreover, the Operational Report is sorted by order of arrival of the work-order, its status, whether there is available stock to issue and if it is impossible to issue the item for whatever reason.
With Insight SAP, Tower created several layouts in no-time, as following:
- : layout with essential operational information (i.e. work order time and item delivery time), while highlighting with conditional formatting work orders that exceed the agreed SLA.
- : a
- : Insight SAP enables Tower to add free-text columns in seconds. By using such a column, Warehouse Managers may easily enter comments which are displayed within the SAP Report and shared with whoever has the right SAP authorization rights (for the PM module’s t-code report). Thanks to the created column, warehouse managers are now easily adding inputs per any line order or cell (inputs such as “item was not issued on time since the item was locked during the night shift…”).
- : A dedicated team layout which is placed at the warehouse, in which only open Work Orders are displayed and highly prioritized orders are highlighted in :
Last, With Insight SAP’s Publisher module, the reports are being sent regularly to relevant stakeholders through their email, in an automated way, with drill-down capabilities to the data on the transactional level from the email body, subject to SAP authorization.
With Insight SAP, Tower merged and displayed three different reports in one, added additional input and formula columns – in less than a day of work, without development, in Production. Tower could have pursued two alternative standard options: (i) Manually run excel V-Look ups and other calculations whenever a new report is needed, (ii) 1-month ABAP Development to set up the report, and further development and maintenance whenever adjustments would be needed.
Instead, Tower decided to invest a one-day one-time effort with Insight SAP. Now, 4 different Report layouts are a click away, always presenting the latest data since they are embedded within the SAP system.
Business-wise, the expected outcomes are shorter time-cycles of completion of work orders, which would lead to a reduction of Machine-Downtime. Shifting from an eMail based service to a service that is embedded within SAP ERP has led to simplification, transparency and streamlining of the warehouse work order monitoring processes.
Inventory Valuation Report
Inventory valuation is the cost associated with an entity’s inventory at the end of a reporting period. It forms a key part of the cost of goods sold calculation, and can also be used as collateral for loans. This valuation appears as a current asset on the entity’s balance sheet.
(‘Amiad’), a global leader in water treatment and filtration solutions, made a strategic decision to reduce inventory cost worldwide. Although inventory is managed within SAP ERP, it was challenging to produce an updated operational report, which reflected real-time data and 6-month forecast of inventory value, Globally, by site (Amiad operates 8 sites worldwide) and by material item. .
A one-time one-day work effort with Insight SAP replaced a 5-day labor needed whenever a new report was required. As a result, the execution of the corporate guidance was made easier and more effective, the agility of the mid-level managers to make the right decisions based on the accurate information has dramatically increased, and the company’s inventory forecasting unlocked saving potentials as a result of adjusting planning of replenishment orders when they seemed to surpass the defined thresholds.
The Company has taken a Z-Report that is using SAP MRP data (based on a Logical Database DBM), and uploaded it to Insight SAP as the baseline report. This table displays MRP data such as inventory levels at a specified moment, movement inventory data (move-in, move-out) and other relevant inventory control data.