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 Reporter, 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.
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 analysis to evaluate procurement, for instance, using the Count Perfect Order metrics.
Reports/Analysis
- Analysis on supplier’s delivery reliability and quality (using actual delivery quantities, actual delivery dates,
scrap/return information etc.)
- Analysis on purchases from each supplier in a given period.
Main Features
Zoom In: Available for all the measure items.
Drill Down: Not available.
Writeback: Not available.
URL Navigation: To Purchase Order Lines IEE form, showing details with respect to the order line.
Access Types
- Online
- DataMart
Specific Attributes
- 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 Promised 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 Promised 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; Promised 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 - Promised 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 (Promised 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).
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 analysis to evaluate purchases including its charges.
Reports/Analysis
- Analysis on charges per project.
- Analysis on charges per supplier/part.
Main Features
Zoom In: Available for all the measure items.
Drill Down: Not available.
Writeback: Not available.
URL Navigation: Not available.
Access Types
- Online
- DataMart
Specific Attributes
- Accounting Period
Based on Order date.
- Count Charge Line
Identifying a purchase order charge line which is connected to purchase orders but not canceled.
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 analysis to evaluate procurement, for instance, using the Count Perfect Receipt lines.
Reports/Analysis
- Analysis on supplier’s delivery quality.
- Analysis on results of carried out inspections.
Main Features
Zoom In: Available for all the measure items.
Drill Down: Not available.
Writeback: Not available.
URL Navigation: To Purchase Order Receipts IEE form, showing details with respect to the order receipts.
Access Types
- Online
- DataMart
Specific Attributes
- 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.
General Description
The main purpose of this information source is to present data based on the
business opportunity to support high level summarizations and analysis to
evaluate opportunities.
Reports/Analysis
- Analyzes opportunity values based on the markets, regions.
- Analysis on estimated opportunity value and actual opportunity value
based on the opportunity type.
Main Features
Zoom In: Available for all the measure items.
Drill Down: Not available.
Writeback: Not available.
URL Navigation: To Business Opportunities IEE
form, showing details with respect to the opportunity.
Access Types
- Online
- DataMart
Specific Attributes
- Count Opportunities
Identifying a business opportunity.
General Description
The main purpose of this information source is to present data based on the
business opportunity lines to support high level summarizations and analysis to
evaluate opportunity lines.
Reports/Analysis
- Analysis on won opportunity lines based on the sales representative.
- Analysis on lost opportunity lines based on the lost competitor.
Main Features
Zoom In: Available for all the measure items.
Drill Down: Not available.
Writeback: Not available.
URL Navigation: Not available.
Access Types
- Online
- DataMart
Specific Attributes
- Count Opportunity Lines
Identifying a business opportunity line.
General Description
The main
purpose of this information source is to present data based on the
business opportunity snapshots to support high level summarizations and analysis to
evaluate the progress of a business opportunity.
Reports/Analysis
- Analyzing the trends on business opportunities over the months
- Understanding the changes on opportunity values since an opportunity is
initiated
Main Features
Zoom In: Available for all the measure items.
Drill Down: Not available.
Writeback: Not available.
URL Navigation: To Business Opportunity
Snapshots IEE
form, showing details with respect to the opportunity snapshot.
Access Types
- Online
- DataMart
Specific Attributes
- Count Unconfirmed Business Opportunities
Identifying unconfirmed opportunities
- Count Confirmed Business Opportunities
Identifying opportunities that are confirmed
- Count In-progress Business Opportunities
Identifying the business opportunities that are progressing
- Count On Hold Business Opportunities
Identifying the opportunities that are inactive due to an interruption
- Count Master Business Opportunities
Identifying business Opportunity that is marked as a 'Master'
- Count Duplicate Business Opportunities
Identifying Business Opportunities that is referenced as a duplicate of another opportunity
- Count Normal Business Opportunities
Identifying business opportunities which are not marked as duplicate or a master
General
Description
The main objective
of this
information source is
to provide users the ability to create high level analytical reports and
evaluate business activities.
Reports/Analysis
-
Analyze
activities in different perspectives (by activity type, representative, status
..etc,.)
Main Features
Zoom In: Available for all the measure items.
Drill Down: Not available.
Writeback: Not available.
URL Navigation: Not available.
Access Types
1.
Online
2.
DataMart
Specific
Attributes
- Count Activities
Identifying a business activity.
-
Count
NotStarted Activities
Identifying business activities that are in
status NotStarted.
- Count
InProgress Activities
Identifying business activities that are in
status InProgress.
-
Count Completed Activities
Identifying business activities that are in
status Completed.
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 analysis to
evaluate sales, for instance, using the Count Perfect Order metrics.
Reports/Analysis
- Analysis on outstanding orders and our delivery quality.
- Profit analysis.
Main Features
Zoom In: Available for all the measure items.
Drill Down: Not available.
Writeback: Not available.
URL Navigation: To Customer Order Lines IEE form, showing details with respect to the order line.
Access Types
- Online
- DataMart
Specific Attributes
- 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.
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 analysis to evaluate sales including its charges.
Main Features
Zoom In: Available for all the measure items.
Drill Down: Not available.
Writeback: Not available.
URL Navigation: Not available.
Access Types
- Online
- DataMart
Reports/Analysis
- Analysis on charges against campaigns/sales promotions.
- Analysis on charges per customer/site.
Specific Attributes
- 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.
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
analysis to evaluate sales and its deliveries.
Main Features
Zoom In: Available for all the measure items.
Drill Down: Not available.
Writeback: Not available.
URL Navigation: Not available.
Access Types
- Online
- DataMart
Reports/Analysis
- Analysis on delivered quantities on each delivery note.
- Analysis on deliveries made using load list.
Specific Attributes
- Accounting Period
Based on Date Delivered, or not delivered, on Created Date.
- Count Delivery Line
Identifying delivery line.
General Description
The main purpose of this information source is to
present data based on the sales quotation lines to support high level summarizations and analysis to
evaluate the success or failure of sales quotations.
Reports/Analysis
- Analyzing the success of quotations against selected competitors.
- Analysis on main reasons for quotation rejection based on customers and
period of the year.
Main Features
Zoom In: Available for all the measure items.
Drill Down: Not available.
Writeback: Not available.
URL Navigation: To Sales Quotation Lines IEE
form, showing details with respect to the quotation line.
Access Types
- Online
- DataMart
Specific Attributes
- Count Planned/Cancelled/Released/Won/Lost/Rejected Sales Quotation
Lines
Identifying quotation lines based on the status
- Lead time from release to answer
Time taken to respond to the
quotation (print/e-mail) since it was released
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
analysis to evaluate sales including returns..
Reports/Analysis
- Analysis on quantities returned for each return reason.
- Analysis on returns to inventory verses scraps.
Main Features
Zoom In: Available for all the measure items.
Drill Down: Not available.
Writeback: Not available.
URL Navigation: Not available.
Access Types
- Online
- DataMart
Specific Attributes
- 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.
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
analysis to evaluate sales including its returns and charges.
Main Features
Zoom In: Available for all the measure items.
Drill Down: Not available.
Writeback: Not available.
URL Navigation: Not available.
Access Types
- Online
- DataMart
Reports/Analysis
- Analysis on returned charge amounts approved by each return approver.
- Analysis on returns by each customer/ for each part during a given period.
Specific Attributes
- 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.
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 analysis to evaluate changes in
inventory, for instance, using the Count metrics.
Main Features
Zoom In: Available for all the measure items.
Drill Down: Not available.
Writeback: Not available.
URL Navigation: To Inventory Transactions History IEE form, showing details with respect to the inventory transaction.
Access Types
- Online
- DataMart
Reports/Analysis
- Analysis on internal movements of a part in a given period.
- Analysis on counting differences in a given period.
Specific Attributes
- 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".
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 analysis to evaluate inventory quantities, movements and
turnover rates.
Reports/Analysis
- Analysis on total inventory issues.
- Analysis on inventory turnover rate per each commodity group.
Main Features
Zoom In: Available for all the measure items.
Drill Down: Not available.
Writeback: Not available.
URL Navigation: Not available.
Access Types
- Online
- DataMart
Specific Attributes
- 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.
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.
Reports/Analysis
- Analysis on changes of inventory value.
- Analysis on inventory cost of different condition codes of parts.
Main Features
Zoom In: Available for all the measure items.
Drill Down: Not available.
Writeback: Not available.
URL Navigation: Not available.
Access Types
- Online
- DataMart
Specific Attributes
- 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.