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, 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 page,
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
page, page, 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
, 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
- Online
- 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 page, 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
page, 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 page,
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.