IFS Supply Chain Information Sources in IFS Business Analytics

An information source is a combination of facts and dimensions (base data) which are structured to hold information designed to be used to compile reports and analytics using the IFS Business Analytics tool, where you can read more about this tool via IFS Online Help and eLearning.

In the information sources an Accounting Period dimension has been introduced, which can be used to group on or combine with one or more information sources in IFS Financials using an accounting period as a common grouping. The accounting periods are defined per company in the Accounting Periods window found in IFS/Accounting Rules.

All information sources are available as both Online and Data Mart, where Zoom In is available for all measure items, but Write Back is never allowed.

Purchase Order Line

General Description

The main purpose of this information source is to present data based on the purchase order lines to support high level summarizations and analyzes to evaluate procurement, for instance, using the Count Perfect Order metrics.

Specific Items

• Accounting Period
  Based on Latest Arrival Date, or not shipped, on Created Date.
• Count Damage Order Line
  Identifying a purchase order line where Inv Qty Damage = 0.
• Count Early Order Line
  Identifying a purchase order line where Wanted Delivery Date > Latest Arrival Date.
• Count Incomplete Order Line
  Identifying a purchase order line where Inv Qty Incomplete = 0.
• Count Late Order Line
  Identifying a purchase order line where Wanted Delivery Date < Latest Delivery Date.
• Count on Time Order Line
  Identifying a purchase order line where Delivery Days Off Time = 0.
• Count Order Line
  Identifying a purchase order line (that is not cancelled).
• Count Perfect Order Line
  Identifying a purchase order line where Inv Qty Incomplete = 0 and Inv Qty Damage = 0 and Delivery Days Off Time = 0.
• Delivery Days Early
  Count the days an order line is early; Wanted Delivery Date - Latest Delivery Date, else, if not early then set to 0 (zero).
• Delivery Days Late
  Count the days an order line is late; Latest Delivery Date - Wanted Delivery Date, else, if not late then set to 0 (zero).
• Delivery Days Off Time
  Count the days an order line is off time; absolute value (Wanted Delivery Date - Latest Delivery Date), where a zero indicates on time.
• Inv Qty Damaged
  Any returned quantity as identified on the customer order line; absolute value of (Scrapped for Credit + Qty Scrapped For No Credit + Return for Credit + Return for Rework).
• Inv Qty Incomplete
  Calculated as the absolute value of (Invent Qty – Inv Qty Arrived).

Purchase Order Charges

General Description

The main purpose of this information source is to present data based on the charges connected to the purchase orders to support high level summarizations and analyzes to evaluate purchases including its charges.

Specific Items

• Accounting Period
  Based on Order date.
• Count Charge Line
  Identifying a purchase order charge line which is connected to purchase orders but not canceled.

Purchase Order Receipt

General Description

The main purpose of this information source is to present data based on the purchase order receipts to support high level summarizations and analyzes to evaluate procurement, for instance, using the Count Perfect Receipt lines.

Specific Items

• Accounting Period
  Based on Real Arrival Date or if not arrived, on Order Date.
• Count Receipt Line
  Identifying a purchase order receipt line (that is not canceled).
• Count Perfect Receipt Line
  Identifying a purchase order receipt line where Inv Qty Incomplete = 0 and Inv Qty Damage = 0 and Arrival Days Off Time = 0.
• Count On Time Receipt Line
  Identifying a purchase order receipt line where Wanted Delivery Date = Real Arrival Date.
• Count Late Receipt Line
  Identifying a purchase order receipt line where Wanted Delivery Date < Real Arrival Date.
• Count Incomplete Receipt Line
  Identifying a purchase order receipt line where Qty Arrived < Purchase Qty.
• Count Early Receipt Lines
  Identifying a purchase order receipt line where Wanted Delivery Date > Real Arrival Date.
• Count Damage Receipt Lines
  Identifying a purchase order receipt line that has a returned quantity; absolute value of (Qty Rejected + Qty Return Credit + Qty Return Rework + Qty Reworked + Qty Scrapped).
• Delivery Days Off Time
  Count the days a purchase order line is off time; absolute value (Planned Delivery Date – Real Arrival Date).
• Delivery Days Early
  Count the days a purchase order receipt line is early; Real Arrival Date – Planned Delivery Date, else, if not early then set to 0 (zero).
• Delivery Days Late
  Count the days a purchase order receipt line is late; Planned Delivery Date – Real Arrival Date, else, if not early then set to 0 (zero).
• Delivery Work Days Early
  Count the working days a purchase order receipt line is early; Real Arrival Date – Planned Delivery Date, else, if not early then set to 0 (zero). Sites distribution calendar is referred to get working days.
• Delivery Work Days Late
  Count the working days a purchase order receipt line is late; Planned Delivery Date – Real Arrival Date, else, if not early then set to 0 (zero). Sites distribution calendar is referred to get working days.

Customer Order Line

General Description

The main purpose of this information source is to present data based on the customer order lines to support high level summarizations and analyzes to evaluate sales, for instance, using the Count Perfect Order metrics.

Specific Items

• Accounting Period
  Based on Last Actual Ship Date, or if not shipped, on Created Date.
• Count Delivered as Requested
  Identifying a shipped customer order line where Actual Delivery Date <= Wanted Delivery Date.
• Count Delivered as Promised
  Identifying a customer order line where Actual Delivery Date <= Promised Delivery Date.
• Count Delivered as Planned
  Identifying a customer order line where Actual Delivery Date <= Planned Delivery Date.
• Count Damage Order Line
  Identifying a customer order line that has a returned quantity.
• Count Delivered Not Invoiced
  Identifying a shipped customer order line that has "Partially Delivered" or "Invoiced/Closed".
• Count Delivered Order Lines
  Identifying a shipped customer order line.
• Count Early Order Line
  Identifying a customer order line where Planned Ship Date > Last Actual Ship Date.
• Count Incomplete Order Line
  Identifying a customer order line where Inv Qty Incomplete = 0.
• Count Late Order Line
  Identifying a customer order line where Planned Ship Date < Last Actual Ship Date.
• Count On Time Order Line
  Identifying customer order line where Planned Ship Date = Last Actual Ship Date.
• Count Order Line
  Identifying an customer order line (that is not cancelled).
• Count Perfect Order Line
  Identifying customer order line where Inv Qty Incomplete = 0 and Inv Qty Damage = 0 and Delivery Days Off Time = 0.
• Days Ship Early
  Counting the days an order line is shipped early as Planned Ship Date - Last Actual Ship.
• Days Ship Late
  Counting the days an order line is shipped late as Last Actual Ship - Planned Ship Date.
• Days Ship Off Time
  Counting the days an order line is shipped of date as the absolute value of Planned Ship Date - Last Actual Ship.
• Inv Qty Damage
  Any returned quantity as identified on the customer order line.
• Inv Qty Delivered
  The shipped quantity as identified on the customer order line.
• Inv Qty Incomplete
  Any incomplete quantity shipped quantity calculated as the absolute value of Inv Qty Ordered - Inv Qty Delivered.
• Inv Qty Ordered
  The ordered quantity as identified on the customer order line.
• Planned Delivery Date Time
  The date/time on which the goods are planned to be delivered to the customer's address..
• Planned Due Date
  The date on which the goods are planned to be available for reservation in stock.

Customer Order Charges

General Description

The main purpose of this information source is to present data based on the charges connected to the customer orders to support high level summarizations and analyzes to evaluate sales including its charges.

Specific Items

• Accounting Period
  Based on Real Ship Date or Created Date.
• Count Charge Lines
  Identifying a customer order charge line which is not canceled and has a Charged Qty > 0.
• Count Charge Line Return
  Identifying a customer order charge line where Charged Qty and Qty Returned > 0.

Customer Order Delivery

General Description

The main purpose of this information source is to present data based on the update of delivery confirmation lines to support high level summarizations and analyzes to evaluate sales and its deliveries.

Specific Items

• Accounting Period
  Based on Date Delivered, or not delivered, on Created Date.
• Count Delivery Line
  Identifying delivery line.

Return Material Authorization (RMA)

General Description

The main purpose of this information source is to present data based on the return material authorization lines to support high level summarizations and analyzes to evaluate sales including returns.

Specific Items

• Accounting Period
  Based on Date Returned, or not returned, on Date Requested.
• Count Order Line
  Identifying return material authorization line that is not denied.
• Count Returns to Inventory
  Identifying return material authorization line where qty to return > 0.
• Count Returns to Scrap
  Identifying return material authorization line where qty scrapped > 0.

RMA Charges

General Description

The main purpose of this information source is to present data based on the credit charges connected to the return material authorizations to support high level summarizations and analyzes to evaluate sales including its returns and charges.

Specific Items

• Accounting Period
  Based on Returned Complete Date, or if not returned, on Date Entered.
• Count Charge Line
  Identifying an RMA charge line that is not denied.
• Count Credit Charge Line
  Identifying an RMA charge line with the Credited status.
• Count Denied Charge Line
  Identifying an RMA charge line with the Denied status.
• Count Planned Charge Line
  Identifying an RMA charge line with the Planned status.
• Count Released Charge Line
  Identifying an RMA charge line with the Released status.

Inventory Transaction History

General Description

The main purpose of this information source is to present data based on the inventory transactions history to support high level summarizations and analyzes to evaluate changes in inventory, for instance, using the Count metrics.

Specific Items

• Accounting Period
  Based on Date Applied.
• Count Transaction
  Identifying a transaction record.
• Count Decrease Transaction
  Identifying a transaction where the Direction is "-".
• Count Increase Transaction
  Identifying a transaction where the Direction is "+".
• Count Unaffected Transaction
  Identifying a transaction where the Direction is "0".
• Quantity
  The absolute value of the Quantity.
• Quantity Direction
  Displayed as "+" identifying a receipt, as a "-" identifying a shipment or as a "0" identifying a none quantity change.
• Quantity Change
  The plus or minus Quantity as identified by the direction, or 0 (zero) when the direction is "0".

Inventory Turnover

General Description

The main purpose of this information source is to present data based on the average issues connected to the receipts per period to support high level summarizations and analyses to evaluate inventory quantities, movements and turnover rates.

Specific Items

• Accounting Period
  Based on Date Created.
• No of Adjustments
  Number of inventory alterations done for the inventory part for the given period. For example, adjustments made via inventory counting.
• Adjusted Qty
  Inventory quantity altered due to inventory adjustments for the given inventory part for the given period. For example, adjustments made via inventory counting.
• Number of Issues
  Number of instances where the given inventory part is issued for the given period. For example, the manual issue of inventory parts from stock.
• Issued Qty
  Inventory quantity issued for the given inventory part for the given period. For example, the manual issue of inventory parts from stock.
• Number of Issues - Abnormal Demands
  Number of issues where the given inventory part is issued for abnormal demands for the given period. For example, customer order lines marked as abnormal demand.
• Issued Qty - Abnormal Demands
  Inventory quantity issued for abnormal demands for the given inventory part for the given period. For example, customer order lines marked as abnormal demands.
• Number of Total Issues
  The sum of the number of issues and the number of abnormal issues.
• Issued Total Qty
  The sum of the quantity issued and the abnormal quantity issued.
• Received Qty
  Inventory quantity received for the given inventory part for the given period. For example, the manual receipt of inventory parts.
• On Hand Qty
  The inventory quantity currently on hand for the given inventory part for the given period.
• Inventory Value
  The quantity on hand multiplied by the inventory part unit cost.
• Issued Inventory Value
  The quantity issued multiplied by the inventory part unit cost.
• Issued Inv Value - Abnormal Demands
  The abnormal quantity issued multiplied by the inventory part unit cost.
• Turnover Rate excluding Abnormal Issues
  The inventory turnover rate calculated without considering the abnormal issues for the given part for the given period.
• Turnover Rate
  The inventory turnover rate calculated for the given part for the given period.

Inventory Value

General Description

The main purpose of this information source is to present data based on the inventory values per period to support high level summarizations and analyses to evaluate changes of inventory values in different perspectives.

Specific Items

• Accounting Period
  Based on Date Created.
• Quantity at Customer
  The quantity of parts that is in consignment at a customer site. These parts are included in the total inventory value since they are not owned by the customer.
• Quantity in Transit
  The quantity of parts in transit when the inventory value was calculated.
• Supplier Owned Quantity
  The quantity of externally-owned parts (consignment) that is supplied by a supplier.
• Unit Cost
  The unit cost for the specified part. If the cost level is different from the cost per part, a weighted average cost for the total quantities in stock for the specified part is calculated and displayed as the unit cost.
• Total Inventory Value
  The inventory part unit cost multiplied by the quantity on hand.