Incodev Factblending en US
Incodev Factblending en US
1
Technical Paper
Infor Blending
Service description 7.2
Contents
Blending Basis 3
System integration 4
System administration 4
Basic data 5
Purchasing 12
Production organization 15
Production planning/control 17
Development recipes 19
Gross requirements 19
Blending base
2
Blending base
Microsoft Office
Free definition of user queries
• Office 2007
• for the individual design of evaluations
• Office 2010
• with dynamic date filters, groupings, etc.
• MS Report Builder & Reporting Services
• Chart output (e.g. bars, columns, pies ...)
• Data export (MS-Excel, Access, ASCII)
Audit Trail
• Integrated print function with standard layout or
• For the documentation of all master data changes special layout for each query
• Integrated OLAP client
Customizing Tool
• Evaluation of cubes based on SQL Server 2008 Analysis
• for mask design without source code changes Services, pre-formulated cubes
• Fields visible / invisible
• Positioning on masks and tab sequences Event monitor / workflow control
• Function and field size changes • Definition of tasks & warnings (recipe blocked, credit
limit exceeded, sales order with negative DB etc.)
Graphical user interface with • Definition of addressees (users or groups)
• Uniform page layout • Event monitor selected by status, name, priority, escalation
• Standard function bar level or deadlines
• Variable grid design • Direct call-up and processing of the program on
• Formatting of special events, values through color which the event is based
coding & symbols • Logging of all processing steps of an event
• Escalation management, status management and
Online help forwarding options for actions
• German, English, French • Substitution rules & team leader functions
Multilingual capability
• Support for data storage in the form of Unicode and double-
byte as the basis for processing & outputting international
character sets
3
System integration System
administration
User administration
Online integration with financial accounting
• Assignment to user groups & roles
• IGF (Infor® Global Financials) or
• Varial (World Edition) incl. extended DB interface Password management according to 21 CFR Part 11
• DIAMANT/2 (financial accounting+ cost accounting) • Password rules (number of characters, duration, etc.)
• Encrypted input for all passwords
EVA 6.1 interface (export, dispatch, processing) from Anton
• Password check via Active Directory (AD)
to create export and dispatch documents.
• Export and shipping documents Role-dependent authorizations
• Long-term supplier declarations • for notes (display, change)
• for program functions (hide, execute)
Shipping interface
• for administrative tasks (e.g. menu maintenance or
• Data exchange via XML when creating delivery notes
parameters)
• for individual data fields and grids of programs (hide,
Interface DMS d.3
display, change)
(Document Management System)
• for individual columns in user queries and data
• Archiving of documents, notes and SOPs etc.
views
• Direct call from blending via research client • for the right to export grid content (e.g. Excel)
• or alternatively from document overview in Blending
User-dependent menus
Weighing dialog • with program history and last key for each program
as core functionality of existing blending programs • Favorites menu configurable by the user
Integration of weighing systems
• Mettler Toledo ID30 User-dependent dialog templates
• others on request • For calling up programs with preset start
parameters and selection criteria
• Central purchasing
Process computer interface
• Project-specific realization Any number of clients
• as company codes within a database
Electronic document output
• Quotations, order confirmations, orders etc. optionally Plant levels
as print, fax, e-mail or in XML format • for separate planning and material disposition of
locations/production sites
Data export to
• MS Excel, MS Access, text, printer Management of plant-related master data
• From all grid displays, optional storage of templates per • Storage locations
grid • Disposition data from the article master such
• Default layouts for printouts from grid as minimum stock, quantity order point etc.
• Recipe and parts list variants
Assignment of MS Office documents
Automation of batch programs
(Excel, Word etc.) at mask or field level
• Combination of several batch programs to be
executed into one batch
User-dependent variable grid displays
• Showing and hiding columns
• Sorting and line sequences
Logbook
• Display by user, program, status and execution
date etc.
4
Basic data
5
Basic data Warehouse &
Logistics
Quality-oriented batch inventory management Free assignment of warehouse and parking space
• Receipt, production and expiry date numbers Free definition of posting types
• Remaining shelf life, general and business partner-dependent • Internal and external outgoing goods
• Quality status and batch texts • Internal and external receipts with possible automatic
• Target and actual specification (also expiry date calculation and blocking for quality control
customer/article-related values) • Inventory and stock correction
• External batch data (contract manufacturing) • Stock transfers
• Article transfers (from/to article)
Sub-batches (esp. also for filling into containers) • Batch transfer postings (from/to batch)
• Division of a main batch into several sub-batches • Valuation change
• Management of quality data on main or sub-batch • Quality postings (status, receipt, expiry and production
• Stock view of individual sub-batches date, error code, etc.)
• Provision of sub-batches according to container • Automatic storage bin search for receipt postings
• Batch release of containers
Supplementary description of batch stocks
through error codes / properties Any booking types
• with user role authorization and optional
Mixed chaotic storage location management with password assignment
• Max. Volume and weight data • Differentiation between manual and automatic booking
• Pallet types types (delivery bill, production access, etc.)
• Article permissibility checks
• Index for separate picking sequence Free definition of quality and error codes
• E.g. free, in quarantine, blocked, etc.
Creation of reservation areas • Assignment of an MRP code (e.g. goods receipt with status
• for cross-storage location reservations blocked but available for MRP)
Withdrawal strategies
• Manual specification
• FIFO (first in-first out)
• FEFO (first expired-first out)
6
Warehouse &
Logistics
Valuation levels Dispo-Trail / Dispo-Controller
• Article or article/storage location or article/batch or • All changes to MRP data are logged (sales plans,
article/storage location/batch orders, production and order proposals, etc.)
• Alternatively, several storage locations can be • Automatic calculation of change proposals for planning
combined into one valuation location changes, taking into account quantity and deadline
tolerances
Valuation prices • Release functions for the above-mentioned
• Last purchase price changes for the MRP controller
• Moving average price
• Cumulative average price Material provision for production
• Allocation price / cost of goods manufactured • Selection criteria: Production orders, dates and machines
• Lowest purchase price • Consideration of existing stocks in the target
• Individual valuation price warehouse possible
• In addition to the above valuation prices, a fictitious or • Display of missing quantities in the source warehouse
replacement price is also used. • Reference to stocks in other storage locations
• Consideration of container sizes / stock transfer only in
Planning grid whole units
• Calculation by period, calendar week, day or • Stock transfer of required quantities in batch
campaign • Stock transfer log or movement command for logistics
7
Warehouse & Sales &
Logistics Distribu
Queries / evaluations tion
• Stock query (incl. wildcards) by item, container, Flexible, multi-level business partner hierarchy
storage location and bin with all relevant batch • Management of addresses and conditions (also for mapping
data (list also available) different customers, goods and invoice recipients as well as
• Period-specific article statistics (quantities per booking for controlling branch and central processing (association
type) billing))
• Stock movement log by item, storage location, • Graphical representation of the business partner hierarchy
booking type, user, date, etc. as a tree structure with simplified copy function (drag & drop)
• Month-end values per stock account
Variably definable order types
Intrastat With free assignment and sequence of:
• Countries and regions of origin • Picking slip / picking list incl. SSCC
• Commodity codes, transaction types • delivery note
• Ports and airports, modes of transport • invoice
• Creation of a transfer file • Payer lists
All of the above documents also with collective
function Release procedure per processing
Financial accounting integration
stage for mapping the following order types,
• Provision of integration data for the
among others:
journalization of values based on stock
• Immediate invoice, cash sale
movements
• Flexible G/L account structure • Domestic order, export order
• External warehouse delivery notes
Mobile posting • Cross warehouse dispatch, external warehouse stocking
• Definition of barcode schemes • Sample dispatch (check for max. number of permitted
• Barcode type (EAN-13, Code-128 etc.) samples)
• Barcode content (article no., batch, storage bin etc.) • Value and quantity credits
• Special posting programs for stock corrections, stocktaking,
Order type-dependent mask design
transfer postings, confirming production orders, etc.
• Queries on batch status, stocks, etc. • Normal entry with complex checks
• Booking server that executes the bookings initiated by • Quick entry with asynchronous storage
the mobile device via WTS or Citrix • (item pre-assignment from listing, special prices or
customer article structure)
Mobile picking
• For manual creation of pick lists with scanners Prices
• For confirmation / correction of pick list items • Customer special prices (optionally quantity- and
currency-dependent)
• To generate SSCCs (or SSCC Serial Shipping Container
Code) as part of the picking process
• Customer/article exclusion/authorization to purchase
• Consideration of picking sequences and employee • Price lists (optionally quantity- and currency-dependent)
assignments • Copy price lists and special prices
• Prices generally with 2 item discounts and price change date
Container management with new price and new discounts
• Management of containers with serial numbers and • Article group prices
sales containers (such as barrels etc.) without serial • Standard sales price in the article master
numbers • Different price units and price units of measure for price
• Breakdown of the goods receipt or production quantity into lists and special prices
containers with details of the filling quantities • Discounts in kind in price lists / special prices
• Container breakdown in order entry for sales order • Indication of price origin (promotions etc.)
production with different containers • Retail prices
/ containers and order-specific filling quantities
• Target container breakdown in production order printing Listings for wholesale agreements
• Automatic debiting of empty containers when the • Discontinuation control for markets etc.
filled product is posted as a receipt
• Stock differentiation of container stocks with filling Purchase authorizations
quantities • Pharma: certain product groups may only be sold to
• Sale and provision of whole containers (with parameters defined customer groups
for over- and under-deliveries in %)
• Automatic updating of the returnable container account
• Container disposition
• Container return from customers and suppliers using
special booking programs with container identification via
serial number
• Container labels with possible assignment to
container key and integration with Envicon
8
Sale
9
Sale
10
Sale
Integration of EVA
Customer information system
(export and dispatch processing) The required order-specific
• Information on open items, credit limit and open data is transferred to create all standard dispatch and export
order value documents (approx. 60 forms) as well as long-term supplier
• Sales, turnover, contribution margin in value in declarations
comparison to plan and previous period, over any period • EDI / data import/export
at item level or as an overall view • Configurable interface for data import and export of
• Invoice itemization with detailed information at item level blending documents
• Support for common EDI formats
Document information query
• Customs where-used list
Fast sales document query via any document entry
• Proof of quantity for tax-privileged materials
• Display of all preceding and subsequent documents
for the selected document type and the initial
CRM (Customer Relationship Management)
document
• Management of additional information on the
• Detailed information at document header, item and batch
business partner
level
• Configurable key, date and description
• Drill-down function
fields etc.
• Display of symbolized processing status
• Projects with defined additional fields
• Predefined user queries for order, document and invoice
• Contact person with functions
queries for purchasing / sales
• Editing notes and documents for the above contacts
• Display of printed documents
and projects
• Selection of companies/persons for serial letter creation
Statistics
• Creation of visit reports with internal task
• Individual invoice statement with detailed information at
assignment (process complaint, instruct
item level
replacement delivery, etc.) via event monitor
• Period statistics with previous year or plan comparison by
• Integration with MS Word and Outlook, e.g. creation of
company code, customer, article, statistics codes per
tasks with reminders
customer and article, results with sales, turnover,
contribution margin, sales deductions in value and
• Search functions with free design of search
masks
percentage
'CRM monitor' as a summarized display of all relevant customer
• Hit lists with previous year or plan comparison,
information (master and transaction data)
number of results can be limited (e.g. the top 50)
• Hit lists with hierarchical order of statistics codes, transfer of
subtotals to higher levels (e.g. subtotals for federal state,
country, continent)
Queries/evaluations
• Order backlog by order, external order number, customer,
delivery date, dispatch date, blocking and processing
indicator, entry type and storage location with item-related
order details
• Document verification: Display of all documents
generated for an order and its items with the
corresponding detailed information and original
document display
Shipping interface
• Data exchange via XML when creating delivery notes
11
Purcha
sing
Order types Edit order proposals
• Individual orders for one plant Proposals can be narrowed down for processing by
• Central purchasing of an article for several plants article, article group, MRP controller, supplier, status and
• The main item with the total quantity is used to determine order date and sorted by
prices and conditions; different delivery addresses or dates • Supplier, article / article, supplier
can be managed for each sub-item. • Supplier, article group / article group, supplier
• Create proposals manually, edit individually,
Entry & processing types summarize, release, block, delete or change and
• Entry type-dependent mask and password management generate purchase orders
• Fast entry with asynchronous saving • Automatic contract assignment when creating or
• (item presetting from special prices or supplier- editing order proposals, taking into account any
article structure) deviating delivery times for scheduling
12
Purcha
sing
Purchase costing
• Free design of a calculation schema in Excel
• Assignment of a calculation schema to the article or Debit notes
supplier/article structure • with or without goods return
• Reading of blending data and transfer to Excel
• Simulation mode for checking the calculation Document reversal
• Calling up the calculation schema from the order item • of goods and/or invoice receipts and debit notes
• Manually or automatically in the background
• Manual override of the designated items possible: freight, Complaint management
collection fee, commission, etc. • with batch and order reference
• Valuation at goods receipt based on the calculated • Documentation of complaints
purchase price incl. calculated freight and other • Free definition of complaint reasons and
procurement costs possible classifications
• Generation of follow-up activities such as debit notes
Drop shipment with/without return of goods
• Order generation from customer orders • Monitoring and statistical evaluation of initiated activities
• Invoicing to customers, triggered by proof
of dispatch from the supplier Procurement authorizations / supply chain
• Which group of goods may be procured from which
Notifications supplier
• Management of quantities announced for delivery, • Definition of permitted manufacturers (not suppliers)
accurate to order item and batch
Returnable packaging
Goods receipt • Free definition of returnable containers (containers,
• Goods receipt with and without order reference pallets, etc.) from suppliers
• Item reconciliation with updating of order status, stocks • Consideration for goods receipt and returns
(warehouse, batch and storage location-specific, goods • Batch-specific inventory management possible via
receipt number), scheduling and batch tracking batch or serial number
• Automatic allocation of batch numbers from running • Update of returnable packaging stocks on
counters or by manual allocation goods receipt and return delivery
• Automatic or manual batch status assignment (in • Query and evaluation of supplier-related returnable
quarantine etc.) packaging stocks
• Check for remaining shelf life / block the batch if necessary
• Check for authorized manufacturer / batch block if applicable Supplier information system
• Check for one-time delivery of the batch (pharmaceuticals) • Information on open items, credit limit and open order value
• Search for free storage locations by the system • Quantity, value compared to plan and previous period for
• Partial, under and over deliveries possible any period at item level or as an overall view
• Goods receipt against non-ordered items • Invoice itemization with detailed information at item level
• Goods receipt in batch (fast entry)
• Optional change of cost center, cost unit, posting text,
document number, number of labels, procurement costs
and value
Invoice receipt
• Invoice receipt with and without order reference and item-
related processing with updating of order status, valuation
prices and statistics; data can be changed or supplemented
as required:
• Target storage location, price, currency, discounts
• tax key, procurement costs, unit of measure
• Cost center and cost unit
• Unloading location, mode of transport
• Invoice receipt against non-ordered items
• Invoice receipt fast entry
Goods/invoice receipt
• Combined goods and invoice receipt with and without
purchase order reference and individual item processing
with scope of services for goods and invoice receipt
• Goods/invoice receipt of several orders from one supplier
13
Purcha
sing
Order BOMs Vendor evaluation
• Management of order BOMs for mapping purchasing Vendor / supplier article evaluation (before the start of the
BOMs, multi-component systems, dependent containers, business relationship) Vendor / supplier article evaluation
additional costs, deposits, etc. (during the ongoing business relationship)
• Free definition of any number of purchasing BOMs with • Management of evaluation criteria incl. K.O. criteria
specification of the respective structural quantity, • Summary of criteria into evaluation catalogs
currency, validity, automatic BOM explosion or dialog • Creation of evaluation classes
processing during order management • Management of static data (such as ISO-certified? audit
• Dependency on article items successful? etc.) separately for assessment and evaluation
• Any number of items can be assigned to each BOM, possible
with specification of the quantity ratio (optionally also • Automatic determination of variable data such as
with price and discount) deadline, quantity and price deviations as well as quality
inspection data etc.
Bonus accounting • Carrying out the supplier evaluation
• Management of bonus scales and assigned bonus • Documentation of the results on screen or as a printout
percentages • Function link from the evaluation to basic data such as
• Assignment of customer and article groups to purchase order, inspection order, etc.
bonus scales • Determination of the supplier for order proposals after
• Generation of bonus accounting for freely selectable classification of the evaluation
periods (months) • Blocking or release of the supplier or supplier-
• Display of billing data with export function to Excel article relationship in purchasing
Statistics
• Individual invoice statement with detailed information at
item level
• Period statistics with previous year or plan comparison by
company code, supplier, article, supplier and article
statistics codes
• Hit lists with previous year or plan comparison,
number of results can be limited (e.g. top 50)
Queries/evaluations
• Order stock by order number, orderer, delivery date,
availability date, blocking and processing indicator, entry
type and storage location
• Document verification: Display of all documents
generated for a purchase order and their items with the
associated detailed information and original documents
14
Production organization
Recipes
• User group-dependent authorization concept per function Production organization
(create / change / delete) and status (free / in development
/ locked etc.) Parts lists for filling / packaging
• Production process-oriented description of the • User group-dependent authorization concept per function
recipe structure based on resources (create / change / delete) and status (free / in development /
• Unlimited number of stages (semi-finished products) locked etc.)
• Any number of variants (production or • Production process-oriented description of the
structure variants) parts list structure based on resources
• Recipe status (free, blocked, in development) per • Any number of variants (production or composition
variant with comments variants) per parts list
• Validity period / quantity validity per variant • BOM status (free, blocked, under development) with
• Any number of production steps (partial recipes) with comments per variant
capacity positions, quantity basis and batch size • Validity period / quantity validity per variant
• Any number of items/resources of the type • Any number of parts lists, each with its own capacity
−Input (material, operation) point and batch size for mapping multi-level assembly
−Neutral (auxiliary materials, catalysts) • Any number of items/resources per parts list with definition
−Output materials: finished product(s) or of type
−Coupling/by-products −Input (material, operation)
• Copy recipes −Neutral (auxiliary materials, catalysts)
• Copying a recipe and creating the output in the article −Output materials: finished product(s)
master on the basis of a source article −Co-products / by-products
• Change index with history per recipe / variant • Copying a parts list and creating the output in the article
• Option to copy any parts from another recipe master on the basis of a source article
• Automatic creation of the output from the sum of the inputs • Change index with history per parts list / variant
(optional) • Possibility to copy any parts from other parts lists
• Quantity basis target in any quantity and unit • Quantity basis target in any quantity and unit (e.g. piece,
• Different calculation quantity and unit (e.g. recipe in carton, bottle, can, etc.)
kilograms, calculation in liters) • Different calculation quantity and unit (e.g. parts list in
• Comparison of target and actual quantity basis (optional cans, calculation in liters)
with maximum permissible deviation in percent) • Specification of gross and net quantities for materials for
• Comparison of still open production orders with changed shrinkage at item level (for costing and planning)
recipe variants and, if necessary, adjustment of the • Optionally with display of costs at item level
production order with PA pressure reversal -
• Integrated hazardous substance determination and
classification (when using the Envicon hazardous
substance module)
• Consideration of shrinkage at item level (for costing and
scheduling)
15
• Item-by-item assignment of work instructions as specific Recipe / parts list costing
texts or text blocks (SOPs & safety instructions) • Preliminary costing of processes based on the
• Operations with fixed or proportional times (for costing flexibly definable costing scheme
and capacity planning) • Totalization of costs according to characteristics/groups
• Specification of several output materials per variant to define (e.g. raw materials, packaging, semi-finished products, etc.)
the finished products and possible rejects • with absolute or percentage surcharges
• Characteristic assignment individually or • Consideration of co-products (distribution of costs or fixed
via resource group frameworks value for a product)
• Dialog calculation of costs and technical characteristics Costing results
• Transfer from the preliminary cost estimate to the
valuation price in inventory management
16
Production planning/ control
Combined production
(as an alternative production type)
• Determination of a bulk quantity from all associated
container items for a defined period of time
• Summary of bulk and filling items (several sales items) in
one production order
• Separation of production and filling possible via partial
recipes
17
Production planning/ control
Production costs
• Item-related final costing over a selected
period
• Determination of average manufacturing costs per variant
and variant comparison
18
Cross-departmental additional programs
19