IBS Enterprise Help Centre 8.0Business Suite 2014/2015

What’s new in Release 8 of IBS Enterprise

This document summarizes the new/changed functionality in the Release 8.00 version of IBS Enterprise.

Click the applicable link below to navigate to that section.

IBS Distribution

The following functionality has been added/changed in IBS Distribution:

Functionality Module Description Release
Activity based pricing Sales pricing & Sales This functionality provides the possibility to charge a customer an extra amount for a sales order related activity. The charge can be seen as a type of surcharge for performing any such activities that warrant this kind of extra charge.

Examples:

  • In, for example, the pharmaceutical industry, it is common practice to receive sales orders via data interchange. If, for example, one of your customers wants you to place their order for them, this could warrant an extra charge for the time/administration needed to perform such an activity.
  • You may deem it necessary to charge a customer for picking goods after work hours for manually entered orders.
  • You may deem it necessary to charge a customer for the cost incurred to take a different route for manually entered orders.

The activities that are chargeable can occur during sales order entry, picking, delivery or transport and can be based on an order, order line, unit, volume or weight if certain criteria are met. Valid criteria include the order type, order source, ABP item group, route or route group.

ABP charge determination

When a sales order, which fulfils the activity-, base- and criterion, makes its way through the sales order cycle an ABP charge calculation program is called to check if a charge is defined for the current activity and order. The charge calculation program searches for an amount to be charged on the basis of the activated activity-, base- and criterion code combinations in the ABP chargeable activity table. For each of the combinations, the Work with ABP conditions file is checked if an amount is defined for the current criterion contents of the processed order (e.g. order type or route). Determined charges are added to an ABP charge file to be the basis for the ABP invoice generation. You can view the records in the charge file via the ABP charges enquiry.

ABP order generation and invoicing

On a regular basis you can generate the ABP sales orders. This is done via the ABP invoice selection routine which uses the DI interface. This routine selects all charges from the ABP charge file according to the selection and will create normal sales orders of type ABP in the regular sales order entry routine. The fictitious item for which the charge will apply will be assigned as well as the default order type for activity based pricing orders. In addition, if the sales order type that is to be used for ABP invoice (sales order) creation was set up with no documents except for invoice, the order status will automatically be set to 45. During the ABP invoice selection routine, a list will also be printed. You can choose if you want to have the charges summarized on the printout per fictitious item. If you set the Create details field to NO, the amount to charge will be summarized per customer and fictitious item. If you set the Create details field to YES, every line on the order will be printed.

The actual invoice to send to the customer is retrieved via the normal invoicing routine.

0800A
Alternative item handling (IBS Pharma) Sales If the IBS Pharma application is activated along with specific function controls, and cross reference items exist, you can search for, select and sell items that are used as alternatives in the pharmaceutical industry. This functionality allows you to:

  • Find an alternative item to sell in place of the regularly sold item during sales order entry. When you enter a regularly sold item in the Item/Assortment field on the Order lines panel and click OK, the Alternative items, Selection panel will prompt displaying the alternative items available from which you can select that applicable.
  • Use the smart sales order entry routine to search for the item instead of the regular item search. If you enter an item in the Item/Assortment field on the Order lines panel that does not exist and click OK, you will access the Smart sales order entry, Item search panel where you can search for the item.
  • Exit smart sales order entry after the alternative item is selected.
0800A
Assignment and valid dates for customer buying groups Basic data, Sales pricing, Sales The assignment of customer buying groups has been modified making it more user-friendly. You can still use the Buying groups function key from the Customer file to sequence (which attaches) a buying group for one specific customer, but it is not required.

Now one or several customers can be assigned and un-assigned via the new Customers option in the Work with buying groups file. The "Assigned customers" mode is the default mode when you first access the new Work with buying groups, Customers panel, but you can toggle to "All customers" mode to assign the buying group to one or several customers simultaneously by clicking the Assign option, or by entering a sequence number for the applicable customer(s).

When you use the Assign option, the sequence number is defaulted depending on the customer. This means that if the customer is not assigned to any buying group, the sequence will be set equal to 10. If the customer is already assigned to a buying group, the sequence will be set to the highest sequence for customer (by adding 10 to the currently highest sequence number for the customer).

In addition, you can also set up a time span denoting the valid from/to dates under which the buying group is valid. A date update can be performed per assigned customer in both locations, or for all selected assigned customers via the Work with buying groups, Customers panel.

In all programs where the DIS control key for buying group is used (e.g., in pricing routines), the date intervals will be considered in order to determine whether or not the buying group is currently valid for the customer.

0800F
Auto sourcing/fulfillment Sales The following has been changed:
  1. When auto fulfillment is used, order fulfillment rule will be considered even if a warehouse has been manually entered, i.e. dispatch date can be automatically adjusted (OFR 2), quantity can automatically be adjusted (OFR 3) or the order can be split into two deliveries (OFR 4). Note that a split on different warehouses will not be performed if a warehouse was manually entered for the sales order line.
  2. The Stock before BtB field (formerly called Check all whs first) in the Sourcing policies table has been renamed to BtB sourcing rule. Instead of a Y/N setting, this field can be set to one of the following:
    CodeDescription
    0 No BtB check. (No auto BtB creation.)
    1 After last warehouse. (All warehouses are checked before BtB creation.)
    2 After each warehouse. (Only first warehouse checked before BtB creation.)
0800A
Automatic EAN-13 number creation Basic data Functionality has been added to support the automatic creation of EAN-13 numbers, promoting ease-of-use when creating new items. Note: Usage of EAN-8 or IFT14 requires manual creation of EAN numbers.

This automatic EAN-13 numbering functionality requires that the following is done:

  1. The EANCRT (Automatic create of EAN number) function is activated in the Function control file.
  2. An extended number series is set up for this type of numbering. This can be done by combining any required company prefix with a number series or strictly a number series.
  3. The types of items that allow this automatic numbering are defined in the EAN-creation setup program (which is accessed via the DIS control file). Exceptions can also be defined, thereby excluding items that are not to be included in the automatic EAN-13 numbering.

All new Item/Unit records created for the types of items that allow this automatic EAN-13 number creation will automatically receive an EAN-13 number; updated to the EAN number field in the Item/Units panel.

0800D
Barcode scanning during reception and picking Basic data, Stock replenishment and Dispatching Functionality has been added allowing you to scan barcoded labels when performing a reception to stock as well as a pick from stock. The content of the barcode is automatically converted and updated in the system, and if all information is correct, the reception/pick is automatically confirmed. This is achieved by the addition of the following:
  • A new Application identifier table in which common, widely used industry related identifiers have been pre-loaded. The possibility also exists to add your own. You simply define the ID, description, number of characters in the string, whether it is a fixed length or not, and the referencing field in the system. If the identifier is not a fixed length, you can enter the separator that is to be used to differentiate the segments.
  • A new Identifier option within the Barcodes table allowing you to connect the applicable Application identifier(s) to the barcode. A barcode must be set as the default barcode in the system. You can, however, override this default barcode per supplier if they use specific barcodes. For reception scanning this is done by clicking the new Barcodes function key in the Business partner/Supplier file and activating the applicable barcode. For pick scanning, the default barcode that is set in the Barcodes table is used.

The actual scanning procedure during reception and picking is a simple process and can be performed via:

  • Work with receptions (for reception scanning). When you select the Scan option the barcode that is used for reception scanning for the supplier is retrieved (if one has been defined in the Business partner/Supplier file); otherwise the default barcode from the Barcodes table is retrieved. You simply scan the label.
  • Work with pickings (for pick scanning). When you select the Scan option the default barcode from the Barcodes table is retrieved. You simply scan the label.
  • The new Work with batch receive and pick program (for both reception and pick scanning). The default barcode from the Barcode table is retrieved and displayed on the first scanning panel, since at this point no business partner has been selected. This can be changed. You simply choose the activity that is relevant (i.e. Reception or Dispatch), highlight the applicable reception or picking number, select the Scan option then scan the label.

The content of the barcode is read, the fields corresponding to the connected application identifier are automatically updated, and the reception or picking is automatically confirmed if the information is validated. Note: If any information from the label is erroneous or missing, the scan-related fields will become open for input, allowing you to manually correct or add the information. You can also press enter in the scan box area without entering any input to open up the input fields for values.

0800D
Batch ID generation during reception Basic data, Stock Replenishment The existing batch mask functionality has been enhanced. It is now also applicable for batch controlled items which are purchased; not just those that are manufactured (as it was before this enhancement). With this functionality the system can automatically generate a suggested Batch ID for all batch controlled items which are being received into stock. During the actual reception the possibility exists to change the automatically generated batch ID. The following variables are now available (and can be entered in the Batch mask field on the Inventory information panel in the Item file):
VariableDescriptionNew Y/N
ORD Order number N
YMD Transaction date in format YYMMDD N
DMY Transaction date in format DDMMYY N
MDY Transaction date in format MMDDYY N
YWW Transaction week N
WYY Transaction week in format WWYY N
YMM Transaction date in format YYMM (not century) N
MYY Transaction date in format MMYY (not century) N
SER Batch number created from number series defined in the MFG control file (For manufactured items only) N
OLN Order line number (For purchased items only) Y
EXP Batch expiry date Y
TME Time in format HHMMSS Y
RCN Reception note number (For purchased items only) Y
RCL Reception note line number (For purchased items only) Y
0800C
Batch selection handling during picking Basic data, Dispatching The existing batch selection rule functionality, which denotes if and how to select batches during picking, has been enhanced with expiry date related variables. The following selections are now available for batch controlled items that are "date handled" (and can be entered in the Batch selection rule field on the Inventory information panel in the Item file):
0 No batch suggestion.
1 One batch FIFO sequence. Pick the ordered quantity from one batch in First in First Out sequence. (This is the creation date sequence, meaning the date when the batch was received into stock.)
2 Several batches, FIFO sequence. Pick the quantity from as many batches as required to cover the ordered quantity in First In First Out sequence. (This is the creation date sequence, meaning the date when the batch was received into stock.)
3 One batch, expiry sequence. Pick the quantity from one batch in expiry date sequence. (When the batch is date handled, the expiry date must be entered when the batch is received into stock.)
4 Several batches, expiry sequence. Pick the quantity from as many batches as required to cover the ordered quantity in expiry date sequence. (When the batch is date handled, the expiry date must be entered when the batch is received into stock.)
0800C
Bonus handling (for same item) Sales This functionality gives you the possibility to offer a sales incentive in the form of a "same item bonus", i.e. the customer is not charged for one or more of the same item on a sales order. If this functionality is set up and the setup stipulations are met for the item on the order line, the quantity that is invoiced to the customer will be less than the ordered quantity for the item. The functionality is activated via the Bonus flag on the Pricing policies panel in the DIS control file and is valid when pricing your items using sales price lists. When that flag is set to YES, the bonus related information will become visible in the system.

This functionality requires that the following is set up:

  • The Bonus conditions flag must be set to YES for the sales order type to be used on the order.
  • Bonus conditions (header and details) for the item's sales price list (i.e. Quantity to deliver and Quantity to invoice within a date interval).
  • The Order qty to deliver flag, per customer in the Business partner file, must be set to YES or NO denoting if the order quantity must be delivered in full to be able to receive any same item bonus.

Examples:

  • The customer requires the entire order quantity to be delivered (i.e. the Order qty to deliver flag for the customer is set to YES). The customer orders 10 pieces. The bonus is calculated based on the ordered quantity (10 pieces). The system will look at the bonus condition details for the valid date interval and calculate the quantity to invoice for the item on the order line if the ordered quantity matches or exceeds the Quantity to deliver (set up in the bonus conditions on the sales price list) for the item. A full delivery must be confirmed to be able to receive any same item bonus; partial delivery is not allowed.
  • The customer does not require the entire order quantity to be delivered (i.e. the Order qty to deliver flag for the customer is set to NO). The customer orders 10 pieces, but the delivered quantity may be less than the ordered quantity. The system will look at the bonus condition details for the valid date interval and calculate the quantity to invoice for the item on the order line if the ordered quantity matches or exceeds the Quantity to deliver (set up in the bonus conditions on the sales price list) for the item. A partial delivery is allowed.
0800C
Call planning Sales The call plan functionality is a telephone based contact system allowing you to schedule customer contact lists. The functionality encompasses contact plans and call plans. You manually create contact plans, which hold, e.g., the entries of who to call/contact, when to call/contact and how to contact the customers. These contact plans are the basis for the generated call plan. You also decide if the entries to be generated should be done on a role basis (in which case the entries in the call plan will be generated per user that is connected to the contact plan role) or a single user (handler).

You generate the call plan, retrieving the values from the contact plan, from a menu item or via an automatic run (job control). One entry per contact occasion is created. The call plan is generated per user.

From the generated call plan it is possible to directly access sales order entry and create sales orders for the customer in the plan. There is also a connection from the call plan to the route planning, i.e. if routes are set up for the customer, then the next available routes are displayed.

0800A
Catch weight Dispatching, Sales, Stock replenishment Price unit functionality caters to handling when an item is stored (and picked) in one unit but is priced in another unit. This is handled by a conversion factor between the sales unit and price unit.

The Catch weight functionality caters to situations when you weigh your goods during reception and/or picking and you want to manipulate the price unit quantity instead of letting the system calculate it using the conversion factor. It is an extension of the Price unit functionality, allowing you to manually change the price unit quantity/quantities for a sales/purchase order line should the need arise. This can be done for each individual order line quantity during the following:

  • Reception confirmation
  • Purchase order entry if the order line is a direct reception
  • Pick list confirmation
  • Sales order entry if the order line is without pick list

During any of the above mentioned stages, the price unit quantity may have changed compared to the conversion factor set up for the item, i.e. the weight for the item on the order line may not be accurate for the price unit setup.

Example:
Your price unit setup is as follows: 1 each = 2 Kg
Order line qty = 1
However, the actual weight for one item is actually 2.5 Kg.

If the new CTCH-WGT (Catch weight handling) function is activated in the Function control file, this functionality allows you to enter the accurate weight. A new Catch weight entry panel will be displayed allowing you to enter the catch weight quantity. Multiple catch weights can be entered for one order line, allowing you to have a separate weight for each individual item. All catch weights are then accumulated to be the price unit quantity for the order line and will also be used to re-calculate the order line value.

0800E
Ceiling control for promotion pricing Sales pricing, Sales The former budgets and targets functionality for promotion pricing has been renamed to ceiling control. All associated fields have been renamed along with panel titles. The basis of the functionality remains the same and works as follows:

The duration of the promotion is controlled by the validity dates but you can also place stricter control over the duration of the promotion pricing by setting up ceiling values (values and quantities) for any or all of the following:

  • Sales value
  • Sales quantity
  • Discount value
  • FOC item quantity

The ceiling values and quantities are driven by the Ceiling control flag. Placing a ceiling control on any of the above mentioned values/quantities works like a "counter". As you enter sales order lines for promotional items, the system will keep track of the applicable ceiling value/quantity and update the ceilings/quantities reached on the sales pricing method.

It is possible to specify/run ceiling control both on header level and on detail level. You can choose to do either, but you can also do a combination. The control will work as follows:

  • If you specify ceiling control solely on header level, the whole promotion (and all details) will be closed when any of the ceiling values/quantities are reached. The promotion pricing will no longer be valid and the sales pricing method will be closed.
  • If you specify/run ceiling control solely on detail level, the single detail will be closed when a ceiling for the detail is reached, but the header will remain open and other details will still be valid for the promotion.
0800A
Container handling Basic data, Dispatching, Sales IBS Enterprise now supports container handling for items stored in WHM controlled warehouses, allowing you to pick and report items by container. This new functionality is available if the CONTAINR (Container handling) function is activated in the Function control file.

The setup is flexible depending on your requirements. One or many types of containers can be defined according to the usage of the container (i.e. Delivery box or Packaging) allowing you to pack the goods in a container or a container within a container. A Container control file is used to set default and basic information, such as the default container type, the maximum number of containers that can be assigned to one order line, the maximum filling %, the conversion factors for the item dimensions and weight (e.g., to convert millimeter from the Item file to centimeter, and gram from the Item file to kilogram as required in container assignment), as well as if container labels should be printed automatically when the container is confirmed - to what printer and how many).

Container types hold the control parameters for the container. In the Work with container types file you must set up various parameters for your types of containers, e.g., the size (width, height and length), volume and weight as well as the types of items that the container is allowed to hold, choosing from the following:

  • Normal item
  • Fragile item
  • Inflammable item
  • Cold storage item

Default values can, optionally, be set up on warehouse level for the WHM controlled warehouse on the new Container handling panel in the Work with warehouses file. An example of a default value is the maximum number of sales order lines that are allowed per container. Another is the container type.

The system will search/select the type of container to be used in the following order:

  1. Container type from the Container type table. If it is not sufficient in size and volume for container assignment, then
  2. Container type from the warehouse. If not defined on the warehouse, or one is defined but it is not sufficient in size and volume for container assignment, then
  3. Default container type from the Container control file (which is a mandatory entry), even if that container is not permitted for the item.

Containers are automatically assigned based on the volume of goods and the volume of the container during pick list creation if the following stipulations are met:

  • The function control is activated.
  • At least one type of container has been set up in the Work with container types file, and a default container type has been defined in the Container control file.
  • The item on the sales order line is defined as a Normal, Fragile, Inflammable or Cold storage item.

Logging is, optionally, available allowing you to log/track entries in the Container log denoting when the container was created (date and time) and by whom.

Container handling in combination with Outbound shipments

The container handling functionality can be run with or without using the Outbound shipment functionality, but it is advantageous with outbound shipments since that functionality is the connection point to all sales orders that are to be dispatched to the same customer. The system will keep track of the number of containers needed for the outbound shipment.

Container simulation functionality is available for outbound shipments and is executed using a new pre-loaded data queue routine (CASIM – Container simulation). You decide on warehouse level (on the new Container handling panel in the Work with warehouses file) if you want to utilize this functionality by setting the Simulation option flag to the applicable value; choosing from the following:

  • Automatic
  • Manual
  • None

The new pre-loaded CASIM Data queue routine must be activated and defined in the Routine Id field on that same panel. If the Simulation option flag is set to Automatic the system will immediately simulate how many containers the sales order will require for the shipment, (or if the item can be put in an existing container), when the sales order lines are created and attached to the outbound shipment. If that flag is set to Manual, the simulation functionality must be manually triggered via a new option on the outbound shipment.

The number of simulated containers is displayed on the outbound shipment regardless if you choose the Manual or Automatic simulation option. This is invaluable information to know in advance, allowing you to more accurately plan for the number and size of vehicles needed to deliver the goods.

Container confirmation

When confirming the container you can choose from the following routines:

  • The new Work with containers routine. From this routine you can view all created containers. Information such as weight and volume is displayed both on total container level, and also on included item level. When confirmation reporting is selected from this routine, the confirmation reporting is done per container, and not by pick list.
  • The new Container confirmation routine.
  • Work with pickings: A new Container view has been added as well as a new View control, (i.e. Start view) where you can choose what view you want to display as the default (i.e. Pickings view, Shipments view, Pick consolidations view or Container view). From the Container view, the confirmation reporting is done per container and not by pick list.
  • Pick confirmation flow. This routine can be used for containers that are not flagged for PQC (Pick quality control).
  • Work with outbound shipments.
0800E
Default BtB supplier Sales When a back to back order is created in the system, either automatically by the sourcing or decided by the order handler, the supplier used for each order line is always the item's main supplier. If you want another supplier instead of the item's main supplier to be used when a BtB order is created, you can enter the default BtB supplier when creating a new order on the Work with sales orders, Create new panel. If entered, this supplier will be stored in the order header and used for all order lines when a back to back order is to be created. It will, however, still be possible to change the supplier on individual order lines after they have been created. Note, however, that the default BtB supplier stored in the order header cannot be changed once the order has been created. 0800A
Expected delivery date on all open purchase orders Stock Replenishment The existing Update earliest shipment date functionality allows you to update "new" purchase orders with the earliest shipment date for the item/supplier.

An Update open orders flag has been added to the Update earliest shipment date window allowing you to update the dispatch date for all "open" purchase order lines (status < 30), i.e. the dispatch date will be set to Earliest ship date. In addition, the Update earliest ship date program can now also be accessed via a new Update earliest ship date menu option.

0800F
Fast entry for purchase/return order lines Stock Replenishment A Fast entry mode has been added where you can quickly add/maintain several purchase/return order lines at the same time. You can also define, via a new First panel order view control, that the Fast entry panel should be accessed first when a purchase order is added. (Note that if there is an Assortment for the supplier, the Assortment panel will be the first accessed regardless of the Fast entry view control setting.) A similar First panel return view control is available for Return orders. These view controls are accessed via the View controls function key on the Work with purchase orders, Header view panel. See View control handling for purchase orders below for more information about the view controls. 0800D
Fast entry for sales/credit order lines Sales A Fast entry mode has been added where you can quickly add/maintain several sales/credit order lines at the same time. You can also define, via a new First panel order view control, that the Fast entry panel should be accessed first when a (normal) sales order is added. A similar First panel credit view control is available for Credit orders. These view controls are accessed via the View controls function key on the Work with sales orders, Header view panel. See View control handling for sales orders below for more information about the view controls. 0800C
Freight fees - automatic calculation Dispatching, Sales pricing & Sales Functionality has been added enabling the system to automatically calculate freight fees at sales order entry (i.e. a preliminary fee). Similar to the existing administration and invoice fee handling, the real fee is displayed during the pick list confirmation process. Note: No calculation is done for internal replenishment sales orders (IRO's).

Freight fees must be set up per shipping agent, based on either a minimum weight limit of the goods on the order or a fee per package regardless of the weight, and can be dependent on a specific manner of transport and/or destination or valid for all. You can prevent back order lines from being included in the freight fee calculation by setting a fee limit on system level (DIS control file) or overriding that limit per customer.

Per customer, you have the possibility to:

  • Define exceptions, thereby excluding specific customers from being charged a freight fee based on their total order value.
  • Reduce the fee charged to a customer by granting a freight fee discount.
  • Override the fee limit for back order lines on system level (if any was defined in the DIS control file) thereby preventing these kinds of lines from being included in the calculation on customer level.

Regardless of how many freight fees are set up, the following two higher level controls dictate whether freight fees could/will be automatically calculated/retrieved:

  1. The FREICALC (Freight fee calculation) function must be activated in the Function control file.
  2. The terms of delivery code on the sales order. When the above mentioned function is activated, the Freight fee field in the Terms of delivery table must be set to YES for the terms of delivery code used on the sales order to denote that freight is to be calculated. If this field is set to NO, freight will not be calculated for the sales order. Note: If a manual terms of delivery (999) is defined on the sales order, this will be considered as a terms of delivery with freight fee calculation if the new function control is active.

During sales order line entry, the search for a freight fee occurs in a specific sequence. (This is done first for the order currency; if nothing is found, the same sequential search will be performed for the system currency.) If found, it will automatically be retrieved to the sales order header, as a preliminary freight fee, if the user does not manually enter a freight fee. Freight fee calculation for the real fee is performed at pick list confirmation if the user does not manually enter (or change an automatically retrieved preliminary freight fee) on the sales order header.

0800A
Integration to external WMS system Dispatching, Sales, Stock Replenishment, Stock Control Exit and entry points have been implemented in IBS Enterprise allowing for the communication/transmission of the following information to/from an external Warehouse Management System, e.g., IBS Dynaman:

  • Basic data - Items and Business partners. (This data is sent to the external Warehouse Management system.)
  • Sales order information to be used for Dispatch planning
  • Pick list information
  • Purchase order information to be used for Reception planning
  • Reception information
  • Inventory adjustment
  • Stock synchronization (a check against the "other" system ensuring you have the same on hand quantity in both systems)

If the IBS WMS Interface application is activated in IBS Enterprise, the Picking, Reception and Inventory routines support the update and validation from an external client, e.g., IBS Dynaman. Any erroneous transactions sent from IBS Dynaman are saved. All transactions sent from an external client are stored in the WMS transaction log file. Depending on the type of error, you can manually correct the error in the Work with pickings/Work with reception/Work with inventory routines if applicable, or click the Retry option from the WMS transaction log (for the transaction). If the error is caused because of a lack of information, the error should ideally be corrected in the external client if possible; else in the above mentioned routines after communication with the warehouse personnel.

0800A
Inventory handling Dispatching, Sales, Stock Replenishment, Stock Control The inventory related routines have been rewritten and amalgamated into one Work with inventory routine. From this one location you can handle all adjustments and movements for normal inventory, transit inventory and NCC inventory. This routine supports the update and validation from an external client, e.g., IBS Dynaman. If the IBS WMS Interface application is activated in IBS Enterprise, the stock situation can be sent to IBS Enterprise from the external client. If the transactions received for the warehouse are in error, the user will automatically access "Transaction in error" mode when they select the warehouse from the initial Work with inventory panel. Examples of errors include:

  • Erroneous number of decimals
  • Standard cost price is missing
  • The inventory transaction lacks information (e.g., a transaction for a batch item was sent but the batch ID was not supplied)

The routines are also used when inventory transactions from other internal processes need to be validated and updated. Examples of this include:

  • Re-stock actions from IBS Request and Returns
  • Quality Control reporting from IBS Request and Returns
  • Inventory transactions from CMI processes like Ownership transfer
0800A
Invoice split Sales The invoice split functionality allows you to decide what items you want printed on invoices for your customers that are flagged for split invoicing. The following three alternatives are available, which is dictated by an Invoice split option code assigned to your items:
  • Print with same split code: All items for the customer on the order with this invoice split option code will be printed on the same invoice.
  • Print with same split category: This requires that your items for the customer on the order are attached to an Invoice split category. The end result is that all items for the customer on the order with this invoice split option code and the same invoice split category will be printed on individual invoices based on the category.
  • Print on a separate invoice: This does not require that your items are attached to an invoice split category. The end result is that all items for the customer on the order with this invoice split option code will be printed on individual invoices, i.e. one invoice per item.

Note that the merged invoicing functionality is not allowed for customers that are flagged for split invoicing.

0800B
Item matrix Stock Control, Sales & Sales pricing The item matrix functionality allows you to create a set of items that share the same characteristics but something differs (e.g., different colours and sizes). Such a group of items, created from a matrix base item, are gathered into an item matrix.

This functionality expedites the entry of sales and purchase order lines for items that belong to an item matrix. Rather than registering order lines one by one for items that belong to an item matrix during order line entry, the item matrix panel, which holds the matrix items for the warehouse, can be accessed. (You can click the prompt icon (green arrow) in every matrix cell to access the Time axis enquiry for the item in the matrix cell.)

The user simply enters the applicable quantities for the items required from one window and clicks OK to register the lines in one go. (If the IBS Multi Distribution Centre (MDC) application is activated and the matrix base item has been set up for MDC (even though it will never appear on any MDC orders), the MDC availability function key will be visible to be able to view the available quantity for the main MDC supplier for each item.)

Sales pricing can also be set up to price the item matrix items as you see fit, using normal pricing techniques as you would set up for any other item, or special item matrix pricing (quantity dependent) for the individual item lines or for the entire item matrix. The latter means that the accumulated quantity for all item combinations within the matrix is used to retrieve the sales price for the sales order lines that the user will create.

0800A
Item's extended description part of Item search field functionality Basic data The item's extended description has been added to the Item search field controls table (type = 16) giving you the possibility to use it in Item file search fields. The first line of any extended item description will be added to the Item file maintenance, Item search fields panel if the text for the description is entered in the same language as the system language. 0800E
Line delivery address Sales The delivery address for all lines on the order is retrieved from the Business partner file for the customer on the order, and defaulted to the Order addresses panel. Functionality has been added allowing you to define a different delivery address for a specific line(s). If you want a different delivery address for a specific line, click the Delivery address option and enter that applicable. The country for the line specific delivery address must be the same country of the delivery address for the order. Note that this option is not available for the following types of orders:
  • Delivery schedule order
  • Service order
  • MDC order in supplying company
  • Order defined for complete delivery

In addition, you cannot add a line delivery address for a sales order line if the following is true:

  • The sales order line has status 30 or higher.
  • The sales order line is a BtB direct line and a connected purchase order has been created.
  • The warehouse on the sales order line is defined as a WMS warehouse.
0800A
MDC enhancements Sales, Stock Replenishment, Stock Control MDC has been "prepared" to handle companies with different PTF levels. The PTF levels supported in standard include:

Demanding company Supplying company
500E 800A
550L 800A
600I 800A
800A 500E
800A 600I

All communication between two Enterprise companies within MDC is handled by unique transactions sent through data queues. Hence, the difference in the databases between the PTF levels mentioned above is not an issue when two Enterprise companies are communicating. See the MDC between different IBS Enterprise releases technical reference in the Help Centre (or on the Intranet) for more technical information.

Note: The system may need to be modified to make MDC work for all other combinations of PTF levels.

0800A
Narcotic movement handling Stock Control This functionality, which is applicable for IBS Pharma, allows you to collect information (inventory transactions in and out of stock) for narcotic related items which can be sent to the relevant authority. Every time a narcotic related item is moved in or out of stock, the transaction is marked as a narcotics transaction. You create, delete and print the list of movements via the Narcotic movements create/delete/print menu item. The movements can be viewed in the Narcotics enquiry. 0800A
Order source handling Sales The order source functionality allows you to track from where a sales order was created. When this functionality is activated, an order source field will be displayed on various panels when the user creates orders from the following:

  • Sales order entry
  • Activity based pricing
  • Call plans
  • IBS Requests and Returns
  • IBS NetStore for web based orders
  • IBS Mobility
0800A
Package reporting Dispatching Two different levels of package reporting have been introduced: H (Header level) and L (Line level). You define the Package report level on each warehouse.

Header level:
Header level is applicable when doing package reporting via the following routines:

  • Work with pickings
  • Pick confirmation flow

If the warehouse on the sales order is set up with package reporting on Header level, simplified package reporting will be available where you simply enter the number of packages without having to be concerned with what goes in each package. This (simplified) package reporting is typically used when your company uses external carriers to ship the goods.

Line level:
Line level is applicable when doing package reporting via the following routines:

  • Work with pickings
  • Work with package reporting
  • Work with outbound shipments

If the warehouse on the sales order is set up with package reporting on Line level, the reporting is the same as in previous releases, i.e. you select the package type and the sales order lines that go into each package.

0800A
Payee for freight delivered by external shipping agent Dispatching When an external shipping agent is responsible for the transport of the goods dispatched to customers, the shipping agent needs to know who is responsible for paying the freight (i.e. the sender or the receiver).

Receiver customer functionality has been added for third-party freight documents (DOC04). In the new Receiver customer number table, which is accessed via the Customer file, you can enter the customer number for the receiver on third-party freight documents (DOC04). These numbers can be defined per shipping agent or per shipping agent in combination with freight document. This new table is used to determine how to update the freight document field for "Sender/Receiver pays" (i.e. Pay send/rec flag) in the standard Third-party freight document DOC04.

The standard Third-party freight document DOC04 in IBS Enterprise has also been enhanced with the sender customer number and receiver's customer number. This information, which can be found in the Work with freight documents file on the Header information, part 2 panel, can be transferred to the third-party freight document software via IFTMIN.

The way the system updates the Pay send/rec flag on the created freight document has changed. You can still choose to use Freight standard values, or manually update the flags on the created freight document, but now automatic update of those flags is possible. The update to those flags works as follows:

  1. (not new) If standard freight values were set up these will be retrieved, and depending on what was set up, the "Sender pays" (Pay send) flag or the "Receiver pays" (Pay rec) flag will be set to Y.
  2. (new) If no standard freight values were found, the system will check if any freight fee was entered for any of the orders. If found, the "Sender pays" (Pay send) flag will be set to Y.
  3. (new) If no freight fee was found, the system will check for a receiver customer number. If found, the "Receiver pays" (Pay rec) flag will be set to Y. If not found, and there is a Sender customer number (retrieved from the Our customer field for the shipping agent/freight document), the "Sender pays" (Pay send) flag will be set to Y.

In the event that none of the above are found, the Pay send/rec flag will not be automatically updated. The possibility still exists to manually update those flags.

0800D
Phonetic correction handling All modules with item Search fields The phonetic correction functionality provides the capability to look up items without having to know the full item code. This functionality is applicable wherever item Search fields can be entered. If the system is set up for this functionality (i.e. the PHNECORR (Activation of Phonetic correct) function is activated in the Function control file and the Work with phonetic string corrections file is manually loaded with the applicable Internal text and Output text), the user simply enters the abbreviated code (Internal text) for the item in any item related Search field. A list of items will be retrieved that contain the matching output text in the item's internal name. 0800A
Pick confirmation Dispatching There are now two solutions for confirming the picking:

  • Work with pickings (completely redesigned and formerly called Work with sales order pick lists)
  • Pick confirmation flow (New)

Depending on your needs, you can choose one or the other or utilize both. Both routines support the update and validation from an external client, e.g., IBS Dynaman, but the Work with pickings routine should be used if you plan on implementing IBS Dynaman in one of your main warehouses since any erroneous transactions sent from IBS Dynaman are saved. If an IBS Dynaman transaction ends up on error, you would use this routine to view and manually correct the erroneous transaction.

Both routines also support the logging/tracking of who confirmed the picking. The PICK-HND function in the Function control file controls the entry of a pick handler during confirmation. If activated, the pick handler will be a mandatory entry. If not activated, the pick handler will be an optional entry, and if no pick handler is entered, the user ID will be used to update the files.

Picking details can now be accessed via the Sales order enquiry.

Work with pickings

In this routine you are able to view all non-confirmed and confirmed pick lists via three different views:

  • Picking view
  • Shipments view (outbound) - Typically used when your own fleet delivers the goods (i.e. you need to know the lines)
  • Consolidations view for pick consolidations

You must select the task you need to work with. All tasks are available behind options. Tasks include:

Lines If any of the items are an IBS Warehouse Management controlled item, or batch item or serial number controlled item, you will first access the Details panel where you can:

  • enter/change the picked quantity (or click Full dispatch which will move the suggested quantity to the picked quantity (i.e. the customer's order quantity) to the picked quantity field if zero). The confirm full dispatch can be viewed as a type of "exception handling" whereby only picks where changes were made need to be first corrected e.g., correct locations or quantities using lines and then confirm.
  • select the batch.
  • create a duplicate reception line if, e.g., you need to pick from two different batches and thus need to add a second batch, or when one suggested pick line needs to be received from two different locations instead of the one suggested.

After clicking OK, the next panel depends on the following:

  • If any of the items are serial number controlled you will access the Serial number entry panel where you enter the serial number information corresponding to the quantity you are picking and click OK to access the Lines panel.
  • If no items on the pick line are serial number controlled you will access the Lines panel to enter/change the backlog code and then confirm the picking.

If the items are not an IBS Warehouse Management controlled item, or batch item, or serial number controlled item, you will access the Lines panel directly where you can:

  • enter/change the picked quantity (or click Full dispatch which will move the suggested quantity to the picked quantity (i.e. the customer's order quantity) to the picked quantity field if zero). The confirm full dispatch can be viewed as a type of "exception handling" whereby only picks where changes were made need to be first corrected e.g., correct quantities using lines and then confirm.
  • enter/change the backlog code.

and then confirm.

Display errors View errors for any transactions sent from an external client, e.g., IBS Dynaman. Examples of errors are:

  • The order is being held by another user.
  • The pick confirmation lacks information (e.g., a batch item was sent but the batch ID was not supplied).

All transactions sent from an external client are stored in the WMS transaction log file. Depending on the type of error, you can manually correct the error in this Work with pickings routine if applicable, or click the Retry option from the WMS transaction log (for the transaction) if the IBS WMS Interface application is activated. If the error is caused because of a lack of information, the error should ideally be corrected in the external client if possible; else in this Work with pickings routine after communication with the warehouse personnel.

Confirm Allows you to first maintain the line information (manually enter the picked quantity) and confirm.
Confirm full dispatch Allows you to confirm a full dispatch without maintaining the line information (i.e. the suggested quantity (i.e. customer’s order quantity) will be moved to the picked quantity field if zero; else accept the picked quantity). In addition, all picks that are picked according the pick suggestion could be confirmed here. The confirm full dispatch can be viewed as a type of "exception handling" whereby only picks where changes were made need to be first corrected e.g., correct locations or quantities using lines and then confirm.
Extras Accept/enter additional fees (freight, administration and invoice).
Package reporting This routine supports package reporting on both Line level and Header level.

Line level:
If the warehouse on the sales order is set up with package reporting on Line level, the procedure is the same as in previous releases, i.e. you can do it from this location or via the Work with package reporting menu item. You select the package type and the sales order lines that go into each package.

Header level:
If the warehouse on the sales order is set up with package reporting on Header level, simplified package reporting will be available which includes:

Enter the number of packages for the entire picking.

After clicking OK, the system will generate as many package type lines as the number of packages entered. Package type is defaulted from the warehouse if a default package type has been defined. The total net weight of the pick list is retrieved and distributed equally among the packages. If a default package type is defined for the warehouse, the weight of the default package type from the Warehouse table is added to each line.

Accept or change the manner of transport

Accept/change any automatically calculated/retrieved freight fee or change any freight fee that was manually entered on the order at sales order entry. (No other fees are relevant at this stage, and thus are not displayed).

Freight documents (for a confirmed pick list) If package reporting for the warehouse on the sales order is defined on Header level, only third-party freight documents are available, if that functionality is activated.
Transport note (for a confirmed pick list)

Pick confirmation flow

This new routine combines the tasks into one outbound sequential flow incorporating the confirmation, package reporting and print of third-party freight documents (if activated). You do not have to select what task you need to work with. This routine supports package reporting on Header level. This (simplified) package reporting is typically used when your company uses external carriers to ship the goods.

The following tasks (panels) will automatically be prompted accordingly:

1. Pick list confirmation (or Location confirmation - if WHM is activated) Enter the pick list number and pick handler.
2. Detail lines You manually enter or accept the picked quantity or click Full dispatch to move the suggested quantity (i.e. customer’s order quantity) to the picked quantity field if zero. In addition, all picks that are picked according the pick suggestion could be confirmed using the confirm Full dispatch functionality. The confirm full dispatch can be viewed as a type of "exception handling" whereby only picks where changes were made need to be first corrected e.g., correct locations or quantities using lines and then confirm. You can also create a duplicate record if, e.g., you need to pick from, e.g., two different batches and thus need to add a second batch, or when one suggested pick line needs to be picked from two different locations instead of the one suggested.
3. Lines Enter/change the backlog code if applicable. You can also confirm the picking. Note that the Confirm function key is only displayed if the pick list is ready for confirmation (not, e.g., during zone pick).
4. Package reporting panel if the warehouse on the sales order = H (Header) level
  • You enter the number of packages.
  • After clicking OK, the system will generate as many package type lines as the number of packages entered. Package type is defaulted from the warehouse if a default package type has been defined. The total net weight of the pick list is retrieved and distributed equally among the packages. If a default package type is defined for the warehouse, the weight of the default package type from the Warehouse table is added to each line.

    Accept or change the manner of transport

    Accept/change any automatically calculated/retrieved freight fee or change any freight fee that was manually entered on the order at sales order entry. (No other fees are relevant at this stage, and thus are not displayed).
5. Freight documents Only Third-party freight documents are available if that functionality is activated (and package reporting for the warehouse on the sales order is set up on header level).

Note: If the IBS Third party freight doc (TFD) application and the AUTOTFD (Auto crt 3rd party freight doc) function control are activated, the DOC04 document is created automatically. If DOC04 is the only active document, this panel is not displayed.

0800A
0800B
0800D
Pick list print for outbound shipments Dispatching, Sales Functionality has been added allowing you to prevent pick lists from being printed too early for sales orders on outbound shipments. This allows you to keep the orders open as long as possible should you need to change the quantity or add more lines and gives you the space and time to do the picking to make the departure date. New Pick release day and Pick release time fields drive this functionality whereby you denote on what day and at what time the pick list is allowed to be printed per outbound shipment.

For sales orders that are part of the Shipment preparation process (i.e. the Shipment prep flag on the order type is set to YES), these fields are first defined on the Route (which are then copied to the generated Route list and then the generated Outbound shipment). At each stage the entry in those fields can be changed. For outbound shipments that you create manually (i.e. that are not part of the shipment preparation process), you define these fields on the manually created outbound shipment.

The actual printing of the pick lists for outbound shipments can be done via the following:

  • Print sales order pick lists menu item whereby pick lists for up to eight selected orders can be printed at a time (existing functionality). See Check for valid pick release day/time below. If you do not select a specific order and just enter the Dispatch date and Warehouse, the system will select all sales orders according to the dispatch date and warehouse, and create pick lists.
  • Pick list option in Work with outbound shipments (existing functionality).
  • Job control. By using Job control you can automate the printing of pick lists for outbound shipments by scheduling a job to run as often as you need, e.g., five times/day.

Check for valid pick release day/time
For all of the above, the system will check that the pick release day and time are valid (i.e. it will compare the actual day and time to the Pick release day and time. If the Pick release day and time are prior to the actual day and time the pick list(s) will be printed.

An alert can be configured to flag the user should a pick list fail to be printed. The event type for this alert is PCKLNOTPRT (Pick list not printed).

0800A
Print VAT information on sales order confirmation Sales If the VATCONF (VAT info on SO confirmation) function is activated in the Function control file, VAT information will be printed on the sales order confirmation. 0800E
Pro forma invoices Sales Pro forma invoices can be printed when required from the following:

  • Sales quotation entry for quotations of type 1 (will produce a sales order), 3 (will produce a service order) and 4 (template).
  • Sales order entry for sales orders of type 1 (will produce an invoice) with a status of less than 60.

if the following situations arise:

Banking/funding/letters of credit Your customer requires a Pro forma invoice to present to the bank to show the scope of their investment. At this stage it is unlikely that you need to allocate stock since it is not known if the customer will be able to raise the necessary funding. This kind of document requires all fees and surcharges to be specified and included in the total amount.

To create a Pro forma invoice for this scenario, quotations are used. The quotation functionality provides the possibility to add information without allocating stock and yet be able to convert into a sales order. Since the quotation number and line is written to the sales order header line, it also provides a path from the Pro forma invoice (the Quotation) and the final financial invoice via the sales order.

Customs purpose, FOC goods In this situation a Pro forma invoice must be sent with the goods for customs clearance. Since the goods have already been shipped the Pro forma invoice reflects the normal invoice in full. The only reasons for not sending a copy of the actual invoice with the goods could be, e.g., merge and/or periodic invoicing.
International trade In some cases a Pro forma invoice could help the customer to plan for currency allocations and exchange rate issues before receiving the goods and the final invoice.
Bad debtor You may have a requirement to produce a Pro forma invoice towards a "bad debtor". The supplier does not wish to reserve stock or send any goods until the customer has transferred the payment. The Pro forma invoice will provide the customer with the necessary information.
0800A
Purchase order line split during purchase order confirmation Stock Replenishment Functionality has been added in the purchase order confirmation routine allowing you to split purchase order line(s) to create new order line(s). This is achieved via the new Split option. If the supplier cannot deliver the entire quantity on the dispatch date for the purchase order line, you can split any line that is not a BtB order line (i.e. enter the new dispatch date and quantity denoting when the quantity can be delivered, which will create a new line). The quantity on the original line will be reduced with the quantity that was split and the new line will receive status 20. The Set OK option can be used on the new split lines just like any other line; the status will subsequently be set to 25. 0800D
Purchase order reception Stock Replenishment There are now three solutions for receiving goods:

  • Work with receptions (completely redesigned and formerly called Confirm purchase order reception notes)
  • Receive replenishment line (rewritten)
  • Work with purchase order reception (no changes)

Depending on your needs, you can choose one or the other or utilize all. All routines support the update and validation from an external client, e.g., IBS Dynaman, but the Work with receptions routine should be used if you plan on implementing IBS Dynaman in one of your main warehouses since any erroneous transactions sent from IBS Dynaman are saved. If an IBS Dynaman transaction ends up on error, you would use this routine to view and manually correct the erroneous transaction.

All routines also support the logging/tracking of who confirmed the reception. The REC-HAND function in the Function control file controls the entry of a reception handler during confirmation. If activated, the reception handler will be a mandatory entry. If not activated, the reception handler will be an optional entry, and if no reception handler is entered, the user ID will be used to update the files.

Reception details can now be accessed via the Purchase order enquiry.

Work with receptions

In this routine you are able to view all non-confirmed and partially confirmed receptions via five different views:

  • Reception view
  • Shipments view (inbound) - Typically used when your own fleet returns the goods (i.e. you need to know the lines)
  • Order view
  • Supplier view
  • Item view

You must select the task you need to work with. All tasks are available behind options. Tasks include:

Lines If any of the items are an IBS Warehouse Management controlled item, or batch item or serial number controlled item, you will first access the Details panel where you can:

  • enter/change the received quantity (or click Full reception which will move the suggested quantity to the received quantity).
  • select the batch.
  • create a duplicate reception line if, e.g., you need to receive two different batches and thus need to add a second batch, or when one suggested reception line needs to be received from two different locations instead of the one suggested.

After clicking OK, the next panel depends on the following:

  • If any of the items are serial number controlled you will access the Serial number entry panel where you enter the serial number information corresponding to the quantity you are receiving and click OK to access the Lines panel.
  • If no items on the reception line are serial number controlled you will access the Lines panel to enter/change the backlog code, or perform a partial reception without creating a backlog line, and then confirm the reception.

If the items are not an IBS Warehouse Management controlled item, or batch item, or serial number controlled item, you will access the Lines panel directly where you can:

  • enter/change the received quantity (or click Full reception which will move the ordered quantity to the received quantity).
  • enter/change the backlog code.
  • perform a partial reception (and confirm without creating a backlog line on the purchase order).

and then confirm.

Close reception Allows you to confirm and close the reception. When this option is run, it will no longer be possible to change anything for the reception. If at least one reception line has zero for received quantity you will be flagged with a warning when you select this option, allowing you to first maintain the line before confirming.
Confirm full reception Allows you to confirm a full reception (for both a goods reception (debit purchase order) and return (credit purchase order) without maintaining the line information (i.e. the suggested quantity (i.e. supplier's order quantity) will be moved to the received quantity field if zero; else accept the received quantity).
Display errors View errors for any transactions sent from an external client, e.g., IBS Dynaman.

Examples of errors are:

  • The order is being held by another user.
  • The reception lacks information (e.g., a batch item was sent but the batch ID was not supplied).

All transactions sent from an external client are stored in the WMS transaction log file. Depending on the type of error, you can manually correct the error in this Work with receptions routine if applicable, or click the Retry option from the WMS transaction log (for the transaction) if the IBS WMS Interface application is activated. If the error is caused because of a lack of information, the error should ideally be corrected in the external client if possible; else in this Work with receptions routine after communication with the warehouse personnel.

Re-print rec note Allows you to re-print a reception note.

Receive replenishment line
This functionality is used for purchase order lines that do not have a printed reception note. As in previous releases, it can be done via this menu item or via the Rcv line option on line level in Work with purchase orders. You will access the Work with receptions program where a reception note will temporarily be created. You simply enter the received quantity and click Confirm twice to confirm. If a confirm is done for the entire quantity the reception note will disappear from the Work with receptions program after confirming. If a partial reception is done the reception note will remain in this program until the entire quantity is confirmed.

0800A
0800D
Quota goods handling Sales Functionality has been added allowing you to limit the quantity of goods you sell to a customer. This functionality is useful when you, e.g., have limited stock and you do not want to deplete the stock by selling it to just any customer. By setting up this functionality, you can prioritize the customers you want to sell to.

This new functionality is available if the QUOTAGDS function is activated in the Function control file.

New Valid and Active flags for Quota goods have been added in the DIS control keys file. There are several item, customer, warehouse and order type related keys from which you can choose.

In the new Work with quota goods file you set up the information. You link the DIS control keys defining what should be limited and to whom, as well as define the maximum quantity that can be sold per time period (i.e. day, week or month), within a date span.

When entering sales orders, the system keeps track of the remaining quota balance. The user will be flagged with a message should the quantity on the order line exceed the remaining quota balance. You can also view the remaining quota balance in the following:

  • Quota goods transactions enquiry. This enquiry displays the original quota quantity, used quantity and remaining quota quantity per quota goods record. You can also drill down on detail level to view the customer/item/sales order and sales order line that consumed from the quota goods quantity.
  • Customer service enquiry
  • All "modes" in Smart sales order entry
0800E
Route handling Dispatching, Sales The following has been added to the route functionality:
  1. Route restriction groups allowing you to restrict items from being delivered on specific routes. This is done via the creation of Route restriction groups. A route restriction group can hold one or more items. You create the route restriction group, and specify the route group type denoting if the restriction is for a route defined for delivery of Narcotic related items only, or a Combined delivery (i.e. all kinds of goods may be included in the route dispatch). You then attach the items to the route restriction group via Item maintenance. Route restriction groups can then be attached on different levels. For example:
  2. Route
    • Route level only. This means that the restriction will also apply for all destinations and customers for that route.
    • Route/Destination level. This means that the restriction will also apply for all customers for that destination.
    • Route/Customer level.
    Route list
    • Route list level only. This means that the restriction will also apply for all destinations and customers for that route list.
    • Route list/Destination level. This means that the restriction will also apply for all customers for that destination.
    • Route list/Customer level.
    Outbound shipment
    • Outbound shipment level only. This means that the restriction will also apply for all customers (delivery addresses) for that shipment.
    • Outbound shipment/Delivery address level.
    Sales order line

    Since a route list and outbound shipment can automatically be created from a route, it is advantageous to set up the route restriction functionality on the route since the route list and outbound shipment will automatically inherit any route restriction information set up on the route. If you choose to manually create a route list, or an outbound shipment, the restriction can be applied on those above-mentioned levels.

  3. A Route group table and subsequently a Route group field in the Work with routes file which is a mandatory entry. It is used to group the routes and can also be used in the Activity Based Pricing (ABP) functionality as a criterion when setting up ABP conditions.
  4. A new Customer data window that is automatically displayed during sales order entry if the new ADDCUST1 (Additional customer info) function is activated in the Function control file. This window displays the route information for the customer on the order (i.e. dispatch address, phone number, next available route to the customer, cut-off time and remaining time).
  5. Wake up call functionality, which is a type of notification service that generates entries of when to phone customers before an order on an outbound shipment departs, allowing them to make additions to the order should this be required. See Wake up call functionality for outbound shipments below.
0800B
Sales quotations Sales Maintain sales quotations has been rewritten to the "Work with" concept. In combination with this, a new view control has been added making it possible to list sales quotations in ascending or descending sequence, and a More selections panel has been added where you can narrow down the records you want to work with. 0800A
Serialized tracking for batch controlled items Basic data, Stock Replenishment, Dispatching and Stock Control This functionality is available if the SERTRACK (Serialized tracking) function is activated in the Function control file and the batch controlled item is flagged for Serialized tracking in the Item file. Any time you receive, pick or perform inventory adjustments (decreasing a quantity and/or a stock movement) for a batch controlled item that has been flagged for Serialized tracking, it will be mandatory to enter/scan a unique serialized tracking ID per stock unit (for a reception), and select a unique serialized tracking ID per stock unit (for a picking or inventory transaction), thereby ensuring that the correct tracking ID’s are validated and logged. The serialized tracking ID’s are logged per reception, picking and inventory transaction and can be viewed via the Serialized tracking enquiry. This functionality is typically used in the pharmaceutical industry to prevent counterfeit medicines from reaching consumers but can also be used by other industries with a tracking requirement. 0800D
Target pricing Sales & Sales pricing This functionality provides the possibility to price sales order lines based upon a reached target for the customer, e.g., you want those customers that purchase for 1 million SEK during a specified date range to receive better pricing or discounts. The target turnover accumulation upon which the target pricing is measured can be a sales amount, weight, volume or defined unit.

The target pricing agreements hold all information about the agreement. These agreements are connected to sales pricing methods of type N (Normal), C (Chain discounts) or P (Promotions). When a sales pricing method is linked to such an agreement, it has to be defined with a new limit type called T for target. The limits that are defined for the sales pricing method will be compared, during sales price retrieval, to the accumulated value for the linked agreement. Price, or discount, will be retrieved from the highest limit that is reached based on the accumulated value.

The target pricing agreement accumulation is based on invoiced sales order lines. No open sales order lines are included.

0800A
Value date handling for invoice due date calculation Sales Sales order entry has been enhanced to allow the entry of a value date. If you require an invoice due date for a particular order that is not handled by the customer’s regular terms of payment, a value date can be entered on the Create new panel when registering the sales order (or added/changed on the Order header, Additional info 2 panel). All terms of payment conditions/incentives that may be set up for the customer are still applied, but the value date will be used as the basis when calculating the invoice due date. This functionality requires that the VALUDATE (Value date) function is activated in the Function control file. When this is activated, the Value date field is available for input. The Invoice enquiry header will display the Invoice/value date, i.e. the invoice date and the value date. 0800C
View control handling for purchase orders Stock Replenishment The following two view controls have been added, (accessible from the Work with purchase order, Header view panel), allowing you to configure what panel you want to access first when adding a purchase or return order line:
  1. First panel order
  2. First panel return

For each view control you can choose to set the following default panel per user:

  • Fast entry
  • (normal) Line entry

Note that if there is an Assortment for the supplier, the Assortment panel will be the first accessed regardless of the Fast entry view control setting.

0800D
View control handling for sales orders Sales The following two view controls have been added, (accessible from the Work with sales order, Header view panel), allowing you to configure what panel you want to access first when adding a (normal) sales or credit order line:
  1. First panel order
  2. First panel credit

For each view control you can choose to set the following default panel per user:

  • Fast entry
  • (normal) Line entry
  • Smart order – history
  • Smart order – item search
  • Smart order – previous order
0800C
Wake up call functionality for outbound shipments Dispatching, Sales Some customers require that they receive notification, via a phone call, before an order on an automatically created outbound shipment is picked and ultimately departs, allowing them to make additions to the order should this be required. This functionality handles this kind of notification service. The customer decides at what time and how often they want to be notified.

This functionality requires that the WAKEUP (Wake up call interface) function is activated in the Function control file. When the system is set up with the necessary parameters, you simply activate the WAKEUP data queue. (The Load balance setting in the data queue, which you can set to whatever you like, denotes at what interval the WAKEUP transaction program should be executed). If required, a setting is available for the WAKEUP group in the Default and replacements table allowing you to configure the number of minutes in advance that the wake up call entry can be created in the interface file.

The routine then runs by itself, checking the shipments that are scheduled to depart per day and the customers holding the Wake up parameter. It creates records in the Wake up interface file, denoting which customers should be contacted and when, which can be viewed via the Wake up call enquiry. You can also, optionally, set the system up to trigger an alert message to be sent to the person who should make the call. The event type for this alert is WAKEUP (Wake up call alert). The same information in the Wakeup interface file is included in the alert message.

The Monitor start time on the route (i.e. the time at which the system starts checking entered sales orders) and the Cut-off time of the route (the time when the outbound shipment is closed for new orders) are the driving factors of this functionality, and determine when the customer should receive a wake up call, i.e. a customer should receive a wake up call when no order has been entered between the Monitor start time of the route and the Cut-off time of the route. The wake up call interface program checks if the customers connected to the route have already ordered. It finds the real wake up time on the Route list under the customer.

0800B

IBS Financials

The following functionality has been added/changed in IBS Financials:

Functionality Module Description Release
Asset Management external/internal depreciation Asset Management A basic definition of the term "external" vs "internal" in relation to a depreciation type has been set. ("External = depreciation types that will end up in balance and trade accounting for external reporting purposes.") As a consequence of this definition, some modifications have been made in the system.

The possibility to exclude residual values of an asset and profit/loss amounts of disposed assets has been added to Work with depreciation types.

0800A
Leased assets Asset Management A new way of treating assets that are not owned, meaning they do not represent a real acquisition amount (e.g. leased assets), has been introduced in Work with acquisition types. For non-owned assets, no calculations will be performed and balances must be reversed manually during disposal. 0800A
Asset reporting enhancements Asset Management Acquisition account reconciliation list printout: If a break was created on selected sequence item(s), then total lines will now be printed.

Asset disposal list: It is now possible to print this report without selection on depreciation type, meaning that all depreciation related values are excluded.

Investment budget analysis list: The following minor changes have been implemented:

  • Investment budgets without any asset assigned can now be printed
  • Line totals are printed
0800A
0800B
Cheque inventory Accounts Payable The program has been rewritten to the "Work with" concept and new cheque status codes have been introduced. When printing the Cash book transaction list, the possibility to select on Value date has been added. This date is used in the Cash book reconciliation routine during confirmation.

The reorganization program has been extended to allow deletion of cheques in the cheque inventory with the Cleared and Cancelled status codes, and the possibility to delete cheques with a Cleared date interval.

0800A
Credit Transfer/SEPA MDR2009 Accounts Payable The Credit Transfer/SEPA XML scheme has been changed to adapt to the updated ISO MDR 2009, pain.001.001.03, payments message. New fields are added to the A/P payment order Credit transfer file and mapped to the XML file. The development was done in service package A700D. In Release 8, the possibility to maintain the Credit Transfer and SEPA information has been added.

Note: The old payments message ISO MDR2006 is still available in the system.

Work with credit transfer elements has been renamed to Work with ISO 20022 external code lists.

0800A
A/P payment proposals Accounts Payable The printing of an A/P remittance advice has been separated from the Work with A/P payment proposal, Create payment orders routine. An option has been added which accesses a new Print remittance advice panel. The Original selection option has been added to view the specification values and selection criteria entered when an A/P payment proposal was originally created. 0800A
SEPA Direct Debit Accounts Receivable The SEPA Direct Debit functionality (originally developed in service package A700C) is used in the Work with A/R payment proposals routine. This functionality is used to create bank payment files for collecting payments that should be electronically paid and transferred between debtors, creditors and their banks in the XML format outlined in the standard or local guideline according to the SEPA Direct Debit schemes launched by the EPC (European Payments Council). This is based on an authorization, which is referred to as a mandate. Mandates must be handled directly between the creditor and the debtor and their banks. IBS Enterprise will only hold necessary information about the mandates that needs to be included in the XML scheme for collection. 0800A
A/R interest invoicing Accounts Receivable The existing interest notes routine has been replaced by the new Work with interest invoice proposals routine. The design pattern is similar to the one applied for the reminders routine.
  • Several proposals can be created and processed at the same time.
  • New selection and sequence fields are available.
  • It is possible to delete as well as inactivate a document in the interest invoice proposal.
  • An interest rule can be defined for Business partners, hence it is no longer required to define the interest calculation method on the A/R control file level.
  • Interest invoice proposal can be created per "Debtor/Currency/Cost centre" or as previously "per Debtor/Currency".
  • Interest percentages can now be defined in a dedicated table accessed from the Countries table.
  • Already printed Interest invoices can be viewed and their copies can be printed via the new Work with interest invoice history routine.
0800D
A/R interest invoicing history Accounts Receivable This program holds historical information of interest invoices that have been sent to debtors. Historical details are available on both document level and transaction level. You can drill down to the A/R transactions enquiry to view the invoices that were not paid and those that are the basis for the interest invoice. It is also possible to reprint an invoice, either as an original or a duplicate. A reorganization program is provided in order to remove old interest invoices. 0800A
0800B
0800C
A/R payment proposals Accounts Receivable The Work with A/R payment proposals program has been rewritten to the "Work with" concept. Previous proposal activities are changed to options. An unlock program has been created to release a locked A/R payment proposal.

The Remittance advice option has been added for printing an A/R remittance advice. The Original selection option has been added to view the specification values and selection criteria entered when an A/R payment proposal was originally created.

Calendar handling has been implemented in the Work with A/R payment proposals routine. When the applicable calendar is defined for an A/R payment mode, the system automatically adjusts the proposed payment date according to the calendar definition during proposal creation.

It is now possible to require a cash discount due date to be the proposed A/R payment's document date (as in A/P payment proposals). On the A/R open items selection panel, a new field has been introduced making it possible to forcibly apply a cash discount amount on a paid document.

An unlock program has been created to release a locked A/R payment proposal.

0800A
A/R and A/P analysis list/reports Accounts Receivable

Accounts Payable
Template handling for A/R analysis list/report and A/P analysis list/report has been modified. The same design pattern as the one already applied for A/R, A/P and G/L transaction list templates has been applied. 0800B
A/R and A/P analysis reports Accounts Receivable

Accounts Payable
All the columns displaying the data for the reports are now presented at once (i.e. function keys used to scroll right/left are obsolete and have been removed). This means that the complete set of data can now be exported to Excel.

In addition, more business partner information has been added as hidden columns in the detailed overview (on business partner level). For example, name of the business partner, address information, country, VAT registration number, etc.

0800C
0800E
A/R and A/P invoice entry templates Accounts Receivable

Accounts Payable
A new attribute code has been introduced for the Document type field. It indicates that the system should always propose the next document number, (from the number series defined for the document type), and if any number has already been registered it should be overwritten. 0800B
Work with A/R / A/P transactions Accounts Receivable

Accounts Payable
A new column has been added denoting if there is a text for the transaction. 0800C
Template handling for A/R, A/P and G/L transaction lists Accounts Receivable

Accounts Payable

General Ledger
In the Print A/R transactions, Print A/P transactions and Print G/L transactions programs, the SYSTEM template is now pre-loaded. The panels will be initiated from the System template if the User template is missing. 0800D
VAT daybooks Accounts Receivable

Accounts Payable
The Trader country has been included in the setup of A/R and A/P daybooks. If a company has multiple VAT registration numbers (multiple trader countries) it is now possible to print the VAT daybooks for each trader country, since you can now define the setup of the columns per trader country. 0800E
Calculation/redistribution General Ledger This routine has been rewritten and extended with more flexibility for the treatment of calculations and redistributions. The routine is used for apportioning fixed or variable overheads on monthly or annual accounts. It can also be used for fixed and dynamic calculations.

The possibility to run calculation/redistribution both at journal direct update and periodically in batch (concerns both fixed and dynamic calculation/redistribution) has been added.

Both the fixed and dynamic calculation/redistribution are now handled from the same menu item. In the routine, strict "into account" and "into contra account" handling has been implemented. The previous debit/credit code setup no longer applies. The into accounting postings will receive the same sign as the base transaction and the into contra accounting postings will receive reversed sign compared to the base transaction. Consequently, the calculation/redistribution percentage must be positive. Redistribution "into account" will be pre-loaded with "base account" and cannot be changed.

For all account parts, underscore (___) can be used, completely or now also a masked part of the account. The system will substitute the remaining characters in the account number with the characters from the base account number in that account part. There is no limitation of the number of account parts that are treated in this way.

In the dynamic calculation/redistribution, a special case of underscoring of an account has been implemented. The entry must match the underscored account in the "dynamic base account" specification, and then the creation of dynamic bases will be repeated for every possible value of the account part (or masked part of it) at update of the dynamic base file. In this way, all the calculation/redistribution transactions which are for the same purpose do not have to be entered. An account part can also be entered with all '-' (dash signs). Then, the creation of the dynamic base account will be independent of this account part.

The possibility to enter relative periods (only backwards) has been added in the Dynamic base options routine.

Date handling at batch creation of calculation/redistribution transactions has been changed. The date search in the table will be based on voucher date (or period when applicable) for the incoming transaction and the created calculation/redistribution transaction will get the voucher date from the last date in the G/L control file for the accounting period.

Connection to Corporate Data Maintenance (CDM) for transfer to other companies has been implemented, as well as connection to the Text Editor.

0800A
Sundry invoicing - Delivery address possibility on sundry invoices SIP It is now possible to register, save and print a delivery address for sundry invoices (A/R invoices). The address is handled in a similar manner as is done for DIS sales invoices. 0800C
Sundry invoicing – A/P invoice for EU trade SIP It is possible to register A/P invoices for EU purchase; reverse VAT handling is now supported by the Sundry invoicing application. 0800B
Miscellaneous All modules The following programs have been rewritten to the "Work with" concept: G/L summary identity file, Year end accounts, VAT code combination checks, VAT box descriptions, Pseudo accounts, Entry options.

The Template handling for A/P and A/R balance lists has been changed.

0800A
0800D

IBS Manufacturing

Functionality Description Release
Actual cost at product reception In previous releases the pre-calculated unit cost on a manufacturing order was used to calculate the reception amount (stock value) in the event that the cost type was average cost or FIFO (not standard cost). When component prices change frequently, the reception amount can differ greatly from order to order.

A new field in the Manufacturing order table has been added (Actual cost for reception) to give the possibility to handle actual value (cost control) from the manufacturing order as reception amount. However, to use the actual value there are restrictions in the way manufacturing order reporting can be performed.

  • It is not possible to use "Backflushing material at delivery to stock", as the backflushing is based on the reception quantity and cost control value is not calculated at the time of performing the reception.
  • It is not possible to use "Reception at last operation", as material can be attached to the last operation and the previous operation(s) could be based on the reporting made on last operation (milestone reporting).

In other words, operations must be reported and completed (status 60); material must be issued manually or backflushed at operation reporting and completed (status 60), and finally reception must be done manually from the issue/receive routine.

0800A
Manufacturing order status A New order status "99" (closed) has been introduced for manufacturing orders.

When a manufacturing order has been reported as complete the order receives the status "60" and can be re-opened and adjusted. When the cost control report is executed via the "Transfer to statistics" option the order status is changed to "99". The order remains in the operational files and is available for enquiries and for "copy from" order, but it cannot be re-opened.

0800A
Operation reporting in sequence A new field has been added in Manufacturing order type table to be able to control the operation reporting in a more strict way. The validation for this field will only be made from the "normal" operation reporting function within manufacturing and for sub-contract operations.

The field is called Op reporting check and can contain the following values:

Code Description
1 No validation. It is possible to do reporting on any operation that is defined as reporting operation and not defined as sub-contract operation, without any validation on any previous operation.
2 Warning on status. If previous reporting operation is not closed (status 60) the user receives a warning message saying "Previous operation is not reported as complete". In the event that the previous operation is not started (status 10, 20) the user receives an error message saying "Previous operation is not started".
3 Stop on status. If previous reporting operation is not closed (status 60) the user receives an error message saying "Previous operation is not reported as complete".
4 Warning on status and quantity. Same as status 2 but also validation on if previous reporting operation approved quantity is not equal to the total reported quantity (approved + scrapped) on reporting operation, the user receives a warning message saying "Total reported quantity not equal to previous operations approved quantity".
5 Stop on status and quantity. Same as code 3 but also validation on if previous reporting operation approved quantity is not equal to the total reported quantity (approved + scrapped) on reporting operation, the user receives an error message saying "Total reported quantity not equal to previous operations approved quantity".

In addition, a new option has been added in manufacturing order maintenance for operation to be able to re-open a completed operation (status 60). If an operation is re-opened the workload will be re-created and if there is connected material, in the event of backflushing at operation reporting, the attached material will also be re-allocated.

0800A
Set-up quantity in Bill of material Functionality has been added allowing you to define a fixed set-up quantity for materials. Typically used in the paper industry, this set-up quantity can be deemed as an estimated reservation that you plan on consuming for the machine set-up before real production, and is independent of the order's quantity. When manufacturing orders are entered, the components required quantity is calculated as follows: order quantity x component quantity + fixed set-up quantity.

Example:
Fixed set-up quantity = 10
Order quantity = 5
Component quantity = 1
Component required quantity = 15

The fixed set-up quantity on component/sub-assemblies has an impact in the following functions:

  • Basic data maintenance: New field(s) in material structure.
  • Product costing: Fixed set-up quantity cost is taken into account by unit.
  • MRP: When lower level component/sub-assemblies quantity is calculated the fixed set-up quantity is also included.
  • Manufacturing order creation: The fixed set-up quantity is added to the required component/sub-assemblies quantity.
  • Project structure: New field in material structure.
  • Product configurator: New field added in bill of material. In addition, the "structure unit" (unit) is also handled. Prior to this enhancement, the unit was only used for configured sales order structure. Now it is also used for normal manufactured items.
0800F

IBS Planning and Forecasting

Functionality Description Release
Additional functionality for demand plan copy Functionality has been added giving you the possibility to do the following when copying a demand plan:
  • Copy the details. When you copy a demand plan to create a new, the header is copied. Now you can also choose to copy the details.
  • Remove periods. The periods are removed from the beginning. E.g., if you are copying a plan in year 2014 for periods 01 through 12 and you enter 2, the periods 01 and 02 will be removed for the new demand plan you are creating.
  • Add periods. The periods are added to the end of the plan allowing you to move the plan forward. E.g., if you are copying a plan in year 2014 for periods 01 through 12 and you enter 2, periods 01 and 02 will be added to the new demand plan you are creating for year 2015.
0800F
Demand copy for new items with markup/down percentage Functionality has been added to be able to copy demand in combination with a markup/down percentage. The new Markup/down % field has been added on the last Item file/Inventory management panel (accessed by clicking the Copy demand function key on the first Inventory management panel). This functionality is typically used to get historical demand figures for new items/warehouses. 0800E
Forecast adjustment within Supply plan Functionality has been added to cater to situations when:
  • sales are made on a seasonal basis, and the sales are significantly higher compared to the replenishment capabilities (i.e. depending on the required workload, sales could exceed the capacity for the period (e.g., during the summer months)).
  • working with budget as a Demand plan for next year's forecast, and the budget forecast has not yet been accepted as next year's forecast. (The Demand plan must update the Inventory control forecast before the Supply plan can be created based on the Inventory control forecast). Prior to the new functionality, the inventory control "live forecast" needed to be updated with a budget forecast that had not yet been accepted as next year's forecast.

Production (or purchase) can now be done in advance to balance the sales forecast and the replenishment requirements allowing you to have an accurate picture of the stock level. To meet the sales order (forecast), you now have the following two possibilities:

  • Use a Supply profile
    or
  • Adjust the sales forecast X periods back in time

(The Supply profile and Supply adjustment fields have been added to the Item file/Inventory management panel.)

The forecast adjustment can now be done within the Supply plan. When the sales forecast has been retrieved into the Supply plan, the supply quantity is created based on the yearly sales forecast according to the Supply profile set-up if a Supply profile exists for the item. If the item has a Supply adjustment (number of periods) defined, the supply quantity will be "moved" X number of periods.

In addition, prior to these enhancements the Supply plan could only be created from the Inventory control forecast. Now it is also possible to create the Supply plan directly from a Demand plan (new feature).

  • If a Supply plan is created from an Inventory control forecast, the sales forecast is retrieved from the Inventory control forecast and put in the Supply Plan (period by period). The Supply quantity (production forecast) is calculated according to the supply profile or supply adjustment and the yearly forecast is then used for creating period supply plan quantity (production forecast). The Supply plan will keep track of how much of the stock is "reserved" for future sales orders by saving historical values in the Supply plan (save previous periods).
  • If a Supply plan is created from a Demand plan, (as it should be on a yearly basis in order to calculate Supply quantity in the same way as when created from Inventory control forecast), the Supply plan will keep track of how much of the stock is "reserved" for future sales orders by saving historical values in the Supply plan (save previous periods).

Note: The reserved quantity is calculated according to the supply profile/adjustment in the same way regardless if the supply plan is created from Inventory forecast or a Demand plan.

The Supply forecast is used as input to the MRP and when the item/warehouse has been defined with a Supply profile or Supply adjustment period(s), the MRP calculation uses the production forecast in passed time (calculated by supply plan) as the initial forecast as "reserved stock" to be used for future sales, presented as "reserved forecast" and "Res net forecast". The "Res net forecast" is the adjusted figure based on "reserved forecast" minus sales order in passed time.

When the MRP calculates the proposals the input as initial "stock" is quantity on hand - safety stock - Res net forecast.

0800E
Forecast file extension The Work with forecasts program has been extended with new fields in order to save data from the setup files when inventory calculation is run, for example, used demand plan quantity and suggested supply plan quantity. The purpose is to be able to more accurately verify the inventory calculation, should the setup have been changed after the inventory calculation was run.

The grouping of the fields has been changed on the detail panel for clearer understanding of the information. A new function has been added making it possible to view sales promotion history per forecast period, if more than one sales promotion exists for an item/warehouse/period combination.

0800A
Planner's collection view A new view has been implemented displaying data that could be useful for a planner when making different decisions for changes in the demand plan per period. The view also enables the planner to follow up on this work in coming periods. The number of historical periods that should be shown in the view must be defined, whereas values for future periods are shown one year ahead as default.

The data that could be shown for a selected period interval is, e.g., total demand, period forecast, deviation percentages and statistics. You can also drill down to display the included quantities that build up the forecast.

0800A
Total MAD A new MAD parameter has been introduced. The total calculated mean absolute deviation (MAD) parameter for an item/warehouse combination is based on the comparison between the total forecast (including forecast from additional demand plans) and the total demand (including demand from additional demand plans). It is used in the Service based method to calculate SST in order to get the service level percentage to reflect the real possibility of being able to deliver, taking both the uncertainty of the forecast calculated by IBS Inventory Control and the forecast handed over from a demand plan of type Additional forecast into consideration.

Note: If demand plans of type Additional forecast are not used in the system, then the total MAD is the same as the normal MAD.

0800A

IBS Project Chain Management

Functionality Description Release
PCM client integration The PCM client has been integrated with IBS Enterprise. This client replaces the previous APM client. 0800A

IBS Requests and Returns

Functionality Description Release
Connecting text to request codes Text can be set up for any type of request or return via the Work with notes routine for Note type 60 (BPR related notes). Functionality has been added allowing you to connect notes of type 60 to a request code. This is achieved by selecting the new Request code option on the Work with notes panel for Note type 60. You will access the new Work with notes, Request codes panel where you add the request codes that you want to be associated with the text. If the Ext request code is defined on the Requests and returns header, with the request code for which text is connected, the text will be retrieved. 0800C
Return document printout Return related documents can now be created and printed, either by processing an action or by selecting a dedicated option, on the following levels:

  • Action
  • Request and return header
  • Request and return line

The documents are:

  • Return note
  • Transport note
  • Investigation note.

These documents, except for the investigation note, can be sent back to the business partner, who raised the request, together with the goods. You also have the option to print labels to tag the goods before sending it in return. The investigation note is used to investigate availability, etc. of the ordered and delivered item. Miscellaneous information from the reference and the request is printed on the note.

0800A
Supplier return addresses When returning goods to a supplier, normally the goods are returned to a specific warehouse or address, which is set up for the supplier (Supplier dispatch address field) in the Supplier file. Functionality has been added allowing you to override the return address. If you have a need to return the goods to different supplier addresses as per type of return (e.g. batch return, damaged goods, etc), you can now specify the suppliers and address numbers, per request code, in the Work with request codes routine. This is achieved via the new Supplier returns option from the initial Work with request codes panel. You will access the new Supplier return addresses panel where you can define the suppliers and address numbers. The address is retrieved when a request for the supplier is created from Work with requests and return with the specific request code selected in the Ext request code field. 0800C

IBS Warehouse Management

Functionality Description Release
Pallet handling This new functionality enables you to keep track of all pallets entered into the system. You can work with the existing pallets in that you can hold a pallet, release it and view history details on zone/location level, e.g. the pallet movements, whether they are done by means of a sales/purchase order or a location movement. Detailed information from when the pallet was originally created is available, e.g. which purchase order created the pallet, on which date and by whom. The possibility to select whichever warehouse where pallets exist has been implemented. 0800D

Shared Logistics

Functionality Description Release
Stock Ownership This new functionality, which is activated via the STKOWNER (Stock Ownership) function control, deals with the ownership of internally/externally owned stock in your warehouse(s) and/or your business partner(s) warehouses.

It controls the ownership of:

  • Your own internal stock; regardless of whether you have one internal owner (e.g., one sales department) of the items in your standard stock at your warehouse site or several internal owners (e.g., several sales departments) of the items in your standard stock at your warehouse site.

  • Externally owned stock (your customers and/or suppliers) stored in your warehouse(s). This requires that you activate the IBS Contract Managed Inventory (CMI) application together with the Stock Ownership functionality and set up and sell from Inventory contracts. See Contract Managed Inventory (CMI) below for more information.

  • The storage of your stock in your business partner(s) warehouse(s). This requires that you activate the IBS Contract Managed Inventory (CMI) application together with the Stock Ownership functionality and set up and purchase from Inventory contracts and then sell. See Contract Managed Inventory (CMI) below for more information.

The control of ownership is achieved by:

  • Differentiating your warehouses into the following types of warehouses, which is done via a Warehouse characteristic setting on the warehouse: "Normal" (when there is one internal owner) and/or "Logical" and "Physical" warehouses (when there are several internal owners).
  • Assigning a cost centre (i.e. the owner) to your "Normal" and "Logical" warehouse(s).

All routines that deal with orders, availability (i.e. quantities) and finance are handled by the normal and logical warehouses. All routines that deal with warehouses, dispatching and reception are handled by the normal and physical warehouse. Whenever quantities are updated for a logical warehouse, the quantities will also be updated for the normal and physical warehouses.

Location owner handling for several internal and/or external owners

If you have several internal owners of the items in your standard stock and you allocate your stock into locations in your physical warehouse, you can set the system up to handle the owner of the location in different ways. Likewise, if you plan on storing/selling items for the following types of Inventory contracts:

  • Customer Deposit Stock (CDS) at your (the wholesaler) warehouse site
  • Supplier Consignment Stock (SCS) at your (the wholesaler) warehouse site

and you have several external owners of the items in your stock, and you allocate your stock into locations in your physical warehouse, you can also set the system up as you see fit when it comes to the owner of the locations in your warehouse.

The possibilities include:

  • No owner per location
    This is the easiest and most efficient way to run Stock Ownership, and is the advantage with the functionality. You do not wish to keep track of the location owners and the items will just be placed in locations. The physical warehouse will hold the total quantity for all logical warehouses that are linked to the physical. You do not want to keep control over which location in the warehouse belongs to which owner.
  • Owner per location, but with no owner restriction
    This kind of setup would be applicable if you do not want to mix the owners of goods in locations and you do not care in which location the goods are placed, but you do want everything that is placed in one location to be owned by one owner, regardless of the owner.
  • Owner per location, with owner restriction
    If you want to place a more strict control over the owners of your locations, you can set the system up with location owner groups. It will still only be possible to have goods belonging to one owner in one location, but you can control which owner will be allowed to store the items in that location.

Handling stock take differences for several internal and/or external owners

When you have several internal and/or external owners of the items in your standard stock and you perform a stock take for the physical warehouse, and there is a difference between the counted quantity in your physical warehouse compared to what the system states, you need to decide how the difference (gain or loss) is apportioned among the owners (i.e. who should take the loss or gain the extra item that is counted).

How you choose to apportion any stock take differences (gains or losses) among several owners is also something that can be set up. You can let the system automatically calculate and apportion the difference among the owners or you can manually enter the actual counted quantity per owner.

0800A
Contract Managed Inventory (CMI) The new IBS Contract Managed Inventory (CMI) application deals with the handling of:

  • Externally owned stock (your business partners) in your warehouse(s) which you can sell via Inventory contracts.
  • Your stock in your business partner(s) warehouses which you can purchase via Inventory contracts and then sell.

Types of inventory managed by contracts

IBS Enterprise supports the following types of inventory which must be purchased and/or sold via an Inventory contract:

Inventory types Description
Customer Deposit Stock (CDS) Goods are owned by the customer but physically located at your (the wholesaler) warehouse site.

With this type of inventory, the customer first "buys" the goods from you (i.e. you sell them to the customer) and then you perform an ownership transfer (i.e. transferring the ownership of the goods to the customer) but you physically keep them stored at your warehouse site. You take care of all handling of the goods. When the customer wants you to dispatch the goods that they own, you perform a call off of the dispatched quantity.

From a financial standpoint, you (the wholesaler) should gain something, somewhere in order to accept this kind of business deal. The following possibility allows you to recoup the cost that you would bear to store this externally owned stock at your warehouse site. It is up to you and the customer to agree about the solution.

  • Define a sales price on the inventory contract line that is higher than the normal sales price.
Supplier Consignment Stock (SCS) Goods are owned by the supplier but physically located at your (the wholesaler) warehouse site. This type of inventory gives you the possibility to sell the goods to your customers, without having to pay for them in advance. You only pay for them once they have been sold.

With this type of inventory, you create a logistic purchase order that is used to receive the goods into your warehouse site. The supplier ships the goods to you. You take care of all handling of the goods. When you sell from your supplier's consignment stock, you invoice the customer who bought the goods and notify the supplier (by creating a purchase order for financial purposes) about the quantity that you have consumed (i.e. sold to your customer).

Other than the benefit of only paying for the goods once you have sold them, you may want some other kind of incentive to enter into this kind of business deal. There are several possibilities in IBS Enterprise allowing you to justify the storage of this externally owned stock at your warehouse site. It is up to you and the supplier to agree about the solution. The following are some examples:

  • Set up an SMS agreement for the items on your SCS-contracts allowing you to claim SMS rebates from your supplier.
  • Define a purchase price on the inventory contract line that is lower than the normal purchase price.
  • You accept some supplier owned items in your warehouse, and the supplier accepts some of your owned items in their warehouse (i.e. you set up and run both SCS- and WDS-contracts).
  • Set up supplier rebate agreements.
Supplier Consignment Stock (SCS) - Logistic handling only Goods are owned by the supplier but physically located at your (the wholesaler) warehouse site. Logistic SCS contracts can be used to provide warehouse outsourcing for the supplier (i.e. store and dispatch the goods to their customer on more of an on-demand basis). The supplier informs you when their customer wants X number of items. The quantity for the contract will most likely be for the quantity that their customer wants. Hence, there will likely never be a remaining quantity. The quantity will be consumed when the request is dispatched. (Note: If the situation should arise where there is a remaining quantity when the contract ends, you decide what to do with the remaining stock. You can, e.g., transfer it back to the supplier, or take over the ownership and then sell the stock to your own customers as you normally would for your own goods, without any connection to an inventory contract.)

Stock is never sold (invoiced) by you, but only dispatched and shipped to their customer. No sales invoice is sent to their customer nor payment received from their customer, and no purchase invoice from the supplier is received. You are only involved with the storage, dispatch and shipment to their customer.

(Note: Although this type of contract is typically used for storage and delivery for/to the supplier's customer, you can also use this type of contract for your own customers, if you have an agreement with the supplier that all payments must be redirected to the supplier account.)

With this type of inventory, you create a logistic purchase order that is used to receive the supplier-owned goods into your warehouse site. You take care of all handling of the externally owned stock. At the supplier's request you dispatch the goods to their customer (i.e. you create a logistic sales order which means that every sales order line is set to FOC and there are no financial transactions). There is no invoice in this process, but the invoicing routine has to run to finalize the DIS process.

From a financial standpoint, you (the wholesaler) should gain something, somewhere in order to accept this kind of business deal. It is up to you and the supplier to agree about the solution. The activities that you perform, (e.g., storage at your warehouse site, quality control, re-labeling, packaging, and shipment to the customer), should be charged to the supplier.

Wholesaler Consignment Stock (WCS) Goods are owned by you (the wholesaler) but physically located (externally) at your customer's warehouse site.

With this type of inventory, you have two choices when supplying the goods to your customer's warehouse:

  • External supply - the goods that you want to physically store at your customer's site need to first be bought from your supplier (by you) and then shipped to the customer by the supplier.
  • Internal supply - supply the goods internally via an IRO (i.e. move goods from one of your internally owned warehouses set up in your system (either a normal or a trade warehouse) to supply your WCS warehouse (set up in your system).

When the customer calls off the goods (i.e. consumes the goods) you invoice the customer for the consumed quantity.

Wholesaler Deposit Stock (WDS) Goods are owned by you (the wholesaler) but physically located (externally) at your supplier's warehouse site.

With this type of inventory, you first "buy" the goods from the supplier via a purchase order. When you get the confirmation from the supplier you confirm the purchase order which updates the stock on hand figures for the WDS warehouse in your system, making you the owner of the goods. When you want to sell from this deposit stock that is "considered" as being located in one of your warehouses (even though it is not physically located in one of your warehouses), the sales order must run through the picking process, even though it has to be done by the personnel at the supplier's warehouse. Instead of a pick list, a "Dispatch request" is produced which must be sent to the supplier. When you receive a signal that the goods have been dispatched, the picking can be confirmed.
Customer Buffer Stock (CBS) Goods are owned by you (the wholesaler) and physically located at your warehouse site.

With this type of inventory, you promise a customer that you will keep a certain quantity as a buffer which will always be available (reserved) for the specific customer.

(This type of inventory deviates from the general rule for CMI that it only deals with externally owned or externally located stock. Even though this type of inventory is internally owned by you and (internally) stored at your warehouse site, it requires that the goods be sold from an inventory contract).

From a financial standpoint, you (the wholesaler) should gain something, somewhere in order to accept this kind of business deal. The following possibility allows you to recoup the cost that you would bear to enter into such an agreement. It is up to you and the customer to agree about the solution.

  • Define an inventory contract line sales price that is higher than the normal sales price.
Wholesaler Buffer Stock (WBS) Goods are owned by the supplier and physically located (externally) at the supplier's warehouse site.

With this type of inventory, the supplier promises you (the wholesaler) to keep a certain quantity as a buffer, allowing you to be sure that the promised buffer will always be available. You can sell the promised buffer to your customer via a back-to-back order and/or use the promised buffer (i.e. purchase) for your own replenishment. If you want to purchase the promised buffer for your own replenishment, which means that you will physically bring the stock into your own warehouse and become the owner of the stock, a normal purchase order will be created. When it resides in your own warehouse you can sell the stock as you normally would for your own goods, without any connection to an inventory contract.
Deferred Indent Stock (DIS) Goods are owned by the supplier but physically located (externally) at the customer's warehouse site.

You (the wholesaler) are only involved in the financial transactions. This means that you will be the one that:

  • sends the invoice to the customer
  • informs the supplier about the customer's consumption
  • receives the supplier invoice

You do not have to be involved in any purchasing or logistics. You sell the goods at the sales price to the customer and then inform the supplier when the customer has consumed the goods.

From a financial standpoint, you (the wholesaler) should gain something, somewhere in order to accept this kind of business deal. As long as the invoice to the customer holds a higher price than what you get on the supplier invoice, you will make a profit. Somehow it has to be assured that this profit is high enough for you to take on the administrative work around creating the invoices.

The Stock Ownership functionality must be activated together with the IBS Contract Managed Inventory (CMI) application, since it is this functionality that controls the setup of the warehouses. The concepts of handling physical and financial stock separately are all based on the Stock Ownership foundation which differentiates the warehouses into physical, normal and logical warehouses. There are specific Warehouse characteristic codes that must be assigned to the warehouse for each type of inventory contract you plan on entering into. Not all of the inventory contract types supported with IBS Contract Managed Inventory involve the physical storage of external stock in your warehouse. When it does not involve the physical storage of external stock, a "Logical" warehouse must, nevertheless, be set up to control the financial aspects of the stock you are purchasing/selling.

Inventory contracts and CMI processes

All items that you intend to purchase and/or sell that fall under any of the above types of inventory must be purchased and/or sold from an inventory contract. An inventory contract consists of a header and the contracted line(s) (which holds the item, quantity and other applicable purchase or sales information). Every inventory contract you create must be linked to an inventory contract type, which dictates the CMI processes that are available to be run for the purchase or sales order cycle. Some CMI processes are mandatory to run for an inventory contract type, while others can optionally be run. The optional CMI processes depend on the task you want to perform after the quantity is purchased or sold.

  • What routine you use for the purchase of an item depends on the inventory contract type and the associating CMI process available. All "Supply" purchases for a SCS, Logistic SCS, WCS (external supply only) and WDS contract can be done by running the CMI process via the Work with inventory contract routine or by manually linking the applicable inventory contract to a manually created purchase order in the purchase order entry routine. All other purchases for the other types of inventory contracts must be done by running one of the CMI processes via the Work with inventory contract routine instead of the regular purchase order entry routine.
  • What routine you use for the sale of an item depends on the inventory contract type and the associating CMI processes available. In some cases the sale can take place by running a CMI process via the Work with inventory contract routine, while in other cases the regular sales order entry routine must be used. For the latter scenario, the inventory contract must be connected to the sales order. See Creating sales orders for items managed by inventory contracts below for more information.

Duration of the inventory contracts

There is substantial flexibility when deciding the duration of inventory contracts. The following possibilities exist:

Running contract without a contract quantity on the contract line(s) This is applicable for all types of contracts except the CBS-, WBS-, and DIS inventory contracts. This gives you the possibility to have a running agreement with your customer or supplier without a contract quantity limit and time period. You can create one contract and add contract lines as the need becomes apparent.

If the CMI-MULT function is activated in the Function control file, you will be able to run multiple receptions during the initialization process of all applicable contracts (CDS-, SCS-, Logistic SCS-, WCS-, and WDS), for the same contract line, thereby constantly supplying the line as needed.
Time related contract with quantity limited contract line(s) This is applicable when you decide that you will accept such an agreement with your customer or supplier for a limited time period, and for a limited number of items.

If the CMI-MULT function is activated in the Function control file, you will be able to run multiple receptions during the initialization process of all applicable contracts (CDS-, SCS-, Logistic SCS-, WCS-, and WDS), for the same contract line, as long as the summarized quantity is not higher than the contract quantity limit. You will also be able to increase the contract quantity when needed and then perform a "supply" to initialize that increased quantity.
Quantity limited contract line(s), but no time related contract This is applicable when you decide that you will accept such an agreement with your customer or supplier without any time period restriction, but only for a limited number of items.

If the CMI-MULT function is activated in the Function control file, you will be able to run multiple receptions during the initialization process of all applicable contracts (CDS-, SCS-, Logistic SCS-, WCS-, and WDS), for the same contract line, as long as the summarized quantity is not higher than the contract quantity limit. You will also be able to increase the contract quantity when needed and then perform a "supply" to initialize that increased quantity.

If you choose to not have a running contract without a contract quantity limit (for the applicable types of contracts), the time span for how long the Inventory contract is valid is determined by the following:

  1. The contract quantity on the inventory contract line denoting that you want a quantity limit for the contract. (A contract quantity must be defined for a CBS-, WBS-, and DIS inventory contract but is an optional entry for the other types of contracts.) If an inventory contract was not set up to be valid within a specific date range, the contract line will be closed (i.e. cannot be used on any orders) as soon as the contract quantity is consumed (e.g., you have sold the quantity). You can always create a new line for the same item with a new quantity.
  2. (Optional) Specific date range on the contract header and/or contract line. The end date is the controlling date for the sale of the goods. You can leave the start/end control fields blank on each level; or define them only on the contract header; or only on contract line. If you define them in both places, the dates on the contract line must be within the dates on the header. If the quantity is consumed before the end date is reached, the contract line will be closed. If the end date is reached before the quantity is consumed the contract line will be closed. If the latter occurs, you will have to make some decisions about what to do with the left-over stock, depending on the type of contract.

    Example: If, for a Supplier Consignment Stock (SCS) contract, the end date was reached before the quantity on the contract line was sold, you have three possibilities from which to choose when determining what to do with the remaining externally owned stock in your physical warehouse:
    1. Extend the end date
    2. Take over the ownership
    3. Send it back to the supplier

All inventory contracts and inventory contract lines receive a status, that is automatically updated by the system, denoting the progress. Every action that is performed for an inventory contract and inventory contract line is logged and can be viewed via a log file. On inventory contract header level, the log file displays the status progression for the contract. On inventory contract line level, the log file displays the actions taken/achieved for the line.

Creating sales orders for items managed by inventory contracts

There are five different ways to create the sales orders for items that are managed by (applicable) inventory contracts. It will never be possible to create a sales order line for a CMI-related warehouse, without linking the sales order line to an inventory contract. If auto-sourcing is configured in your IBS Enterprise system, the fifth alternative uses auto-sourcing.

  1. The first alternative is when customer call off's or charge consumptions are created from the Work with inventory contracts routine. With this alternative the sales order line has already been provided with a warehouse from which to source from the inventory contract. Auto-sourcing is not applicable.
  2. The second alternative is when a reference is made to the inventory contract on the sales order header, alternatively on the sales order line during sales order entry. When such a reference is defined, the entered lines are validated against the inventory contract and the warehouse is retrieved from the inventory contract. Auto-sourcing is not applicable.

    A setting on the Inventory contract header allows you to control the possibility to combine sales order lines (i.e. lines connected to an inventory contract and others not connected to an inventory contract) on a sales order when the user defines the contract number on the sales order header.

    If the Off-contract sales flag is set to YES, and the warehouse for the non-contract item is included and activated in your sourcing policy, a warning will be issued, (denoting that the item is not found on the inventory contract and that normal sourcing will take place), but the user will be able to add sales order lines for non-contract items to the sales order as well as items from other inventory contracts.

    If the Off-contract sales flag is set to NO, an error message will be issued and it will not be possible to add a sales order line for a non-contract item to the sales order. It will also not be possible to add a sales order line for items from other inventory contracts. However, if this flag is set to NO and if the inventory contract is only defined on line level, it will still be possible to mix lines for this inventory contract together with non-contract items and/or items from other inventory contracts.
  3. The third alternative is by using the Inventory contract availability program during sales order entry. The panel can be accessed via the Inventory contr availability program function on the Order lines panel. All contract lines with an available quantity for a specific inventory contract will be listed. The inventory contract can either be the contract which was referred to when the sales order was created, or another inventory contract which can be defined on this panel. It will be possible to select lines and enter quantities for these lines, giving the user an easy and user-friendly way to create sales order lines that are to be linked to a specific inventory contract. Auto-sourcing is not applicable.
  4. The fourth alternative is by entering a warehouse manually during sales order entry. When a sales order is created, it is possible to enter a default "From warehouse". It is also possible to manually enter a warehouse on the sales order line panel. If the defaulted or entered warehouse is a CMI-related warehouse (i.e. a warehouse with warehouse characteristics code equal to 3, 4, 5 or 6), a search will take place to find an inventory contract automatically. This will be done even if auto-sourcing is not on for the sales order.
  5. The fifth alternative is when no reference against the inventory contract is made during sales order entry. Items are entered and if auto-sourcing is configured to be processed it will be processed. As a result of the auto-sourcing, the sales order line may be sourced using an inventory contract.

Batch handling

A function in the Function control file allows you to control the handling of batch controlled items during reception and picking. If the CMI-BATH (Batch handling) function is activated, the system will control and validate the matching between an Inventory contract line and a Batch number, i.e. each batch must be attached to a unique Inventory contract line during reception of goods on the line as well as during the picking of a batch on the line. In other words, there will not be any possibility to receive or pick two different inventory contract lines with the same batch number.

If that function is not activated, the system will not control the matching between an Inventory contract line and a Batch number. The user will be able to receive/pick items with the same batch more than one time (as new lines) for one inventory contract.

Sales restrictions

Sales restrictions can be set up to restrict the sale of either certain items, or to certain customers for an inventory contract.

Authority control

Authority control can be implemented on the following:

Authority group Routine
WWCMI ACTIVATE Controls the activation of inventory contracts per user.
CMI BATCRE
(Batch creation for credit order)
During credit order reception there is one validation for an entered batch which checks if the batch exists on another contract. This is controlled by the CMI-BATH function. If the CMI-BATH function is active then it is not allowed to enter a batch which already exists on another contract.

This authority routine adds one more validation. If the user does not have authority then there will not be any possibility to receive a batch that does not already exist in the system.

CMI WWBATCH
(Work with batches)
This authority routine will secure the "Work with batches" detail panel. If the user does not have authority, then it will be not be possible to access this detail panel for batch. Whether or not this authority routine can be used depends on the CMI-BATH function:
  • if the CMI-BATH function is active (i.e. there is strict control of batches per contract) then the setup of security per contract can be done for this authority routine. The setup done for contract in CMI secur group will work on the Work with batches panels.
  • if CMI-BATH function is not active there is no connection between batch and contract. This authority routine will not be applied. Setup done for contract in CMI secur group will not work on the Work with batches panels. Hence, there is only the possibility to secure the entire Batch file maintenance program (DMR081) using the Work with program/user security menu item.
CMI QUALCNT
(DIS Quality control note)
This routine will secure performing a quality control note confirmation by the user. If the user has no rights to the mentioned process the system will send the message denoting that they lack authorization to use the routine.
0800A
0800D
0800E

Miscellaneous

File/Table Description Release
Assign prefixes for printouts that are enabled to be exported via Excel New function controls are supplied with the system allowing you to define different prefixes for printouts that are enabled to be exported via Excel. Instead of the default "F" prefix, you have the possibility to define your own prefix per company (containing 1 to 3 alpha characters) for the following. The work file for the Excel temporary file created for the printout will contain the prefix defined. Note: The DBTEMP (Library for temp files) function control must be activated.
Function controlValid for
SRW0031 G/L
SRW0033 G/L transactions
SRW0042 A/P balances
SRW0604 Stock Evaluation
SRW2421 Stock on hand
0800F
Business partner contact handling The business partner contact handling has been modified making it more user-friendly. You can still use the Work with contacts routine to define/maintain your contacts and attach them to roles, but it is not required. Now all of this can be done via the Customer file in the Business partner file.

In addition, the following new fields have been added to the detail level of the Work with contacts panel, and are selectable UI columns:

  • Phone number (client type = *PHONE)
  • Fax number (client type = ACCEFAX)
  • Cell phone number (client type = GSM)
  • E-mail address (client type = ACCEMAIL)

You can now choose to enter that information on Work with contacts level or via the client type information on the Client parameters panel (accessed by clicking the Clients option). If you add/change/delete a record directly on Work with contacts level it will be added/changed/deleted for the client type in the Client parameters.

0800E
Budget interface This solution will use PlannerView as the client to extract (the whole or part of) the IBS Enterprise budgets, manage the budgets and also update into the IBS Enterprise budgets. PlannerView will also be used as the link between other budget tools, for example Excel, and IBS Enterprise budgets, since it can validate the entered values before updating IBS Enterprise. 0800A
Function control handling Previously the functions were pre-loaded and resided on company level, which meant that there could be different functions for different companies, making it cumbersome to find and maintain. In addition, it was possible to have duplicate names for a function you added for customer modifications and one that was pre-loaded from PD, which meant that those added for customer modifications could be overridden when the functions from PD were pre-loaded.

Now the functions have been placed on a higher level with the introduction of a new system file entitled Work with application functions. This system file is supplied by IBS PD (not pre-loaded) and contains a list of all supported functions that are available in IBS Enterprise. Each function name is unique and thereby eliminates any possibility of overriding any functions you have added for customer modifications.

All functions in this new system file are inactivated by default. You cannot activate the function on company level via the new system file. Instead you must activate/deactivate each applicable function, per company, via the existing Work with function controls. Note that the actual IBS application defined on the function in Work with application functions must be active to be able to see it in Work with function controls.

You can add new functions for customer modifications, but these must first be added in the new Work with application functions file.

(Access to Work with function controls to activate/deactivate each function is also possible via the Work with companies->Applications->Functions level, but note that you can only activate/deactivate the function on this level for the company that you are logged on to.)

0800B
0800E
Override batch jobs When you submit batch jobs to job queues (*JOBQ), the only values that can be changed at execution/order time are on what printer/output queue the printouts shall be printed. One can set up a configuration via Job Control, but that is a static setup and does not allow ad-hoc changes at submit.

Functionality has been added allowing the user to change/override more values for these jobs at execution/order time. This is controlled via the new Activate override batch jobs program, which is accessed via the Enquiry program function (by connecting that program to one of the F13 to F24 function keys, or the Enquiry program selection). You activate the override by setting the Activate flag to YES in this program. The activation is per user and IBS Enterprise company. Once activated, the activation remains until the user "Deactivates" the functionality by setting the Activate flag to NO. This is done either via the Activate override batch jobs program, or when submitting the batch program.

When activated, the Override batch jobs panel will prompt after pressing Enter on the last selection panel before the job is submitted, where you will be able to change/override values such as:

  • Job name
  • Job queue
  • Job priority, on JOBQ
  • Schedule date
  • Schedule time

The values are loaded with values first from entered values in the start program; secondly based on the setup in "Job Control" (if any exists); else with defaults like *CURRENT or *JOBD (exception is Job name where it will use any existing Job name value in Batch program table before *JOBD).

0800F
Period rollover The previous Execute period rollover/reorganisation/backup routine has been split into two separate routines ("Execute period rollover" and "Execute backup/reorganisation"). For each selected company, the Execute period rollover routine will submit a job, e.g. each company will have its own job. 0800A
Validity dates for Notes types Functionality has been added to Note types allowing you to specify a validity period via Valid from/to dates for Note id's connected to the Note type on Item, Business and Parent company level. This allows you to determine how long any text that you want to connect, e.g., to order related transactions, will be valid. 0800F
"Work with" concept A number of tables have been rewritten to the "Work with" concept. 0800A
0800D
0800E

Country Functionality

Country Functionality Description Release
Belgium Work with BP banks A/P supplier bank extension maintenance has been rewritten to the "Work with" concept. 0800A
Function controls The following function controls have been added to the Application functions file and the Function controls file:

C_DEB_L1
C_DEB_L2
C_DEB_L3
C_DEB_L4
C_DEB_L5
CODA_DEL
CODA_DUM
0800E
Denmark Automatic A/R payments The Create file and adv activity has been renamed to Collection to bank. The A/R payment proposal activities are changed to options. The Confirm advis activity has been renamed to Confirm advice. All A/R payment proposal activities are changed to options. Refer to the information in the Accounts Receivable section above. 0800A
France Ledger printouts Several programs have been developed for printing information from:

  • the A/R and A/P ledgers, such as balance sheets and balance statements,
  • the General ledger, such as G/L transactions per voucher type and a G/L summary list per voucher type. A report with extracted information from the G/L can be generated and the option to store the selected data in a work file for future use is available.
0800A
Bank data interchange This functionality has been developed to enable customers to send payment data to their banks via data interchange. An A/P or A/R payment proposal or an A/R portfolio remittance proposal is created and the payment mode entered defines the type of payment (A/R payment, national or international A/P payment) and what standardized format to use when the bank remittance file is created. The A/P and A/R payment modes used by the program are pre-loaded. When the remittance file is created you transfer it to the bank by use of a third-party software which must be received from the bank. The bank confirms when the payments have been processed.

The tasks involved in the functionality are identical for the following available menu items:

  • FBP A/P Bank data interchange
  • FBP A/P Bank data interchange international
  • FBP A/R Bank data interchange

Prerequisites:

  • The FR (French Modifications) and the FR2 (IBS French Best and Practice) applications must be activated in Work with companies/Applications.
  • The pre-load program for the FR2 application must be run in the company in which you are working.
  • Specific French parameters must be specified for the document types that you intend to use indicating how the bank should handle each payment.
  • The applicable bank must be activated for bank data interchange.
  • The third-party software supplied by the bank must be installed in order to send the bank remittance files to the bank. Otherwise, the remittance files are only stored locally.
0800A
G/L settlements The new G/L settlement program enables the user to make a selection of non-settled documents posted on a specific account to create G/L transactions in order to settle them. They are at the same time marked as reconciled in the General ledger.

Prerequisites
The FR (French Modifications) and the FR2 (IBS French Best and Practice) applications must be activated in Work with companies/Applications.

The following program activities are available:

    Creation
    In this activity the G/L transaction settlement is created. The G/L transactions that are selected for settlement will be marked as reconciled in the General ledger.
    Update
    In this activity an already created G/L settlement can be updated by adding a transaction to the settlement.
    Deletion
    In this activity all transactions for an already created G/L settlement or individual transactions that belong to the settlement can be deleted. G/L transactions that are deleted from the settlement will be reset as unreconciled in the General ledger.
0800A
Germany Credit Transfer/SEPA MDR2009 Refer to the information in the equivalent Accounts Payable section above. 0800A
Automatic A/R payments The Create DTA file activity has been renamed to Collection to bank and a new panel has been developed. All A/R payment proposal activities are changed to options. Refer to the information in the Accounts Receivable section above, except the paragraph about Cash discount due date which does not apply for Germany. 0800A
Upload of Item data from the IFA Item data delivered from the IFA can now be uploaded into IBS Enterprise via an Integrator script. The Integrator script reads the file containing the item data information for pharmaceutical products, (e.g., the unique PZN, units, supplier information) and loads the data into the new Pharma IFA data panel in the Item file. If the item does not already exist in the Item file, a new item record will be created. You can use the existing template handling functionality to complete additional information that is required for the item.

To be able to upload this information you must activate the following applications in IBS Enterprise:

  • DE (German modifications)
  • PHA (IBS Pharma)
  • DPH (DE Pharma)
0800D
Italy Fixed assets register enquiry This enquiry program has been created in order to either view or print asset information of selected asset numbers and depreciation types from the Fixed assets register. This register must be updated before running the enquiry. You have the option to either print the asset information in definitive mode or in simulation mode. In the enquiry, you are also able to view depreciation history details for the asset and transaction information for a split asset, if included. 0800A
Transport note printout This program enables to print and reprint transport notes, as well as return notes specifying the goods that should be returned to the supplier. Unique transport note number series are created per year. The number series in turn is connected to each applicable warehouse and is retrieved according to year/series combination when printing transport notes per warehouse. Several warehouses can use the same number series. In this case, lines from different warehouses can be included in the same transport note. However, when a transport note is printed per shipment, only one warehouse is included on the printout. Reasons of transport is another parameter that must be defined per printed transport note. 0800A
Comunicazione Polivalente procedure A new version of the Comunicazione Polivalente (abbreviated CP) VAT declaration procedure for sales/purchase transactions of goods and services related to 2012 and onwards has been issued. The new fiscal request is that Italian companies must create an electronic file of the CP declaration, either directly or through intermediaries, using the template available on the Agenzia Entrate official website, to be sent to the tax authorities.

The following declaration options are available:

Option Description
Spesometro This type of declaration is made annually. For invoice transactions, there is no amount limit. For transactions related to operations with no obligation to issue an invoice, the amount limit is EURO 3,600, including VAT. All cash receipt amounts (paid by debit or credit card) that are equal to or exceed the amount limit must be included in the declaration. Only Italian and Non-resident transactions must be included in the declaration.
Black list This type of declaration is made monthly or quarterly depending on the company business. The Black list is a list of countries with a privileged tax system, characterized mostly by low or even non-existent taxes. The aim is to limit or eliminate the distorted effects deriving from business relations with such countries.
Purchase from RSM This is a declaration of monthly purchase transactions made by operators in the Republic of San Marino.

The procedure is as follows:

  1. Create a declaration proposal.
  2. Specify additional data needed for the proposal.
  3. For a proposal created for the Spesometro declaration option, the system runs a check for errors which must be corrected. Examples of errors could be, e.g., a missing VAT registration number or company registration number (tax code) in the Business partner file. Once the errors are corrected, update the proposal.
  4. Print a control list of all transactions included in the proposal.
  5. Create an electronic file of the declaration data.
  6. Send the electronic file to the tax authorities, either yourself or through your intermediary fiscal associate.
0800A
0800B
0800C
VAT declaration This routine has been added in the system in order to declare periodical and annual VAT according to Italian fiscal law. The VAT declaration process is driven by the VAT registers and VAT register number series. According to Italian fiscal law all companies are obliged to keep VAT registers, such as the following:

VAT register Used for
VAT register of purchase
  • National purchase invoices
  • Custom bill of entry
  • Self-invoice
VAT register of sales invoices
  • Invoices issued for national and export (international) sales
  • Self-invoice for own consumption
VAT register of EU purchase
  • Invoices made in the EU
Sales VAT register related to EU purchase invoices
  • EU purchase invoice for the charging of VAT amounts
VAT register for extra EU purchase
  • Purchase made with countries outside the EU

A register is identified by a code that consists of a letter and a unique two digits number. The following applies:

Code letter Description
A Purchase VAT register
V Sales VAT register

You also have to connect the VAT register numbers to the A/R invoice number series, the sales order types to the correct VAT register code, and create a document number series which must be connected to the correct document type.

The VAT declaration process is as follows:

  1. Gaps related to the document numbering and the voucher date are not allowed in your VAT registers. These must be corrected.
  2. It is mandatory to print a report every month of all VAT registers with the transactions of the previous month. VAT register codes are used when printing the VAT period declarations. The VAT register report printout can be ordered as long as the VAT period declaration for the month is not printed in definitive mode.
  3. Print the VAT period declaration. This printout can be performed in simulation mode or definitive mode. To be able to print the VAT period declaration in definitive mode, all VAT register reports of each referenced period must have been printed at least once. You are also able to correct and adjust values in the declaration before printing. And, you can enter VAT amount compensations for the current declaration and view credit VAT compensations made in the previous declarations (during the year).
  4. Print the VAT annual declaration. All VAT period declaration reports for the year must have been printed in definitive mode before running this program. Information such as the following is printed:
    • VAT amounts related to all sales transactions during the referenced year.
    • VAT amounts related to all purchase transactions during the referenced year.
    • VAT deductible amounts related to purchase transactions.
    • Debit or credit VAT amounts for the year; these figures are retrieved by the value declared in all VAT period declarations which have already been printed.
0800A
RIBA payments This new functionality is driven by the A/R payment mode which must be defined as RIBA (RB) and is run within the A/R portfolio remittance routine. RIBA is the payment method mostly used between companies. It is a commitment of payment. Through a RIBA payment the selling company can request for a down-payment to their own bank. 0800A
Journal entry printout The new journal entry printout functionality is a legal monthly requirement. It is a history list based on the Italian G/L transaction summary file indicating all accounting transactions done in the fiscal year, day by day. The printout can be performed in simulation mode or definitive mode. When it is printed in definitive mode, the system updates the Italian Opening balance value file. For each transaction, the following is displayed on the printout:
  • journal line number
  • transaction date (voucher date)
  • document number
  • document date
  • ledger accounts
  • transaction description
  • debit and credit amounts for each separate ledger account

If errors exist in the journal, then you delete the accounting period and re-print the period in definitive mode. You are also able to maintain the opening balance for a printed accounting period.

This functionality is also used for a company about to "go live" with a new software system. You manually enter the journal's first accounting period that should apply for the company in the new system. The last balance, the last journal line and the last page printed in definitive mode in the "old" system is also set up and retrieved into the new system.

0800B
G/L transaction statement printout This new Italian program is used to make an enquiry on G/L accounts. The difference compared to the standard G/L transactions enquiry is that you are able to include interrupted batches and A/R and A/P payment transactions created in the OPW module and which are not yet transferred to IBS Enterprise.

You can display or print the enquiry. In Display mode, you can make a selection on one account number. In Print mode, you can make a selection on several account numbers. The enquiry information is retrieved from the Italian Account file. If you choose to display the result of the enquiry, then you are also able to drill down to the standard G/L transactions enquiry to view G/L details for the transaction you select and further on to A/R or A/P documents.

0800A
Trial balance printout

This new Italian program is used to make a trial balance enquiry including:

  • interrupted batches,
  • A/R and A/P payment transactions created in the OPW module,
  • and, the possibility to exclude the internal management accounts starting with the figure 9.

You can display or print the enquiry, but normally, the trial balance would be printed. When printing, you are also able to retrieve more detailed information from the Italian Account file, the G/L transaction summary file, the Interrupted batches file and the OPW file.

0800A
Bank branch table All Italian banks that should be used in IBS Enterprise must be defined in this new table. The bank branch number is used when adding a new bank in Work with banks or in the Business partner file, A/R-A/P bank data, but will not be validated by the system. Each bank is identified by two codes:

  • ABI = Institution name ID, identifies the bank group.
  • CAB = Institution branch number, identifies the specific bank.
0800A
Business partner VAT table This table is developed to define specific VAT handling parameters (exceptions) for certain Italian business partners in combination with specific countries (from-to countries). For a customer, this program is also used to indicate the Intent declaration data (number and date). You are also able to switch between viewing current, historic or all business partner VAT exception periods. When entering a sales or purchase order the system searches in the following order to find the correct VAT handling code:

  • Business partner VAT table

if not found,

  • Item file, Country/country VAT information

if not found,

  • Country/country VAT table

if not found,

  • DIS control file
0800A
Free of charge handling A new function (FOCTYPE) is created in the Function control file to be able to define a quotation or sales order line as a free from VAT charge type. When activating this function you can define that the VAT is to be charged to the customer, or that the VAT is to be charged to the company. When the order line is invoiced, different accounting transactions are created depending on the FOC type and VAT handling code on the line. 0800A
EU statistics and Intrastat declaration The new Italian INTRASTAT control file drives the Intrastat declaration functionality. This functionality is developed to enable declaration adjustments for sales and purchase transactions in order to correct errors that have been found in a previously submitted Intrastat declaration. The declaration adjustments are managed manually. Erroneous EU statistical information entered for an invoice can also be corrected by entering an invoice or credit note in the A/R or A/P invoice entry routines. When the Intrastat declaration routine is run the system retrieves the corrections entered either in the Work with Intrastat report corrections - purchase/sales program or in the A/R or A/P invoice entry routines. 0800A
Stock evaluation calculation This functionality is developed to be able to monthly calculate the cost of goods within the stock in order to obtain a stock value at the end of each month. This process consists of three steps which are automatically performed when running the Stock evaluation - Complete creation program. Values for months in the past can be calculated or re-calculated at any time. The calculated data, which is based on transaction types and cost types, is stored for each warehouse/item/period. You can exclude certain transaction types from the calculation. Some of the values for a calculated month can be manually corrected in the Work with monthly costs - Stock evaluation, Manual correction program. After confirmation, the changed values are automatically updated in the system. The stock evaluation calculation values can be printed via the Inventory transaction list printout program.

Prerequisites:

  • The transaction types that should be considered for stock evaluation calculation must be defined in Work with used transaction types.
  • Criteria for the used transaction types that should be excluded from the calculation must be entered in Stock evaluation - Work with exclusions.
  • The month (period) and the cost types that should be calculated must be defined in the Stock evaluation control file.
0800A
Netherlands Work with BP banks Supplier bank table extension maintenance has been rewritten to the "Work with" concept. 0800A
Automatic A/R payments The Process proposal activity has been renamed to Collection to bank. All A/R payment proposal activities are changed to options. Refer to the information in the Accounts Receivable section above. 0800A
Function controls The following function controls have been added to the Application functions file and the Function controls file:

FINSTDUM
IFSARPAY
NR_RABOB
REL_CODE
0800E
Poland VAT Proof of Delivery Date As of January 1, 2014 a new mandate is in place for Sales VAT and tax purposes which is regulated by the EU, and governed by the following legal regulations:
  1. Polish law regulation: Dz.U. 2013 poz. 35 "Ustawa z dnia 7 grudnia 2012 r. o zmianie ustawy o podatku od towarów i uslug oraz niektórych innych ustaw"
  2. 32010L0045 COUNCIL DIRECTIVE 2010/45/EU of 13 July 2010 amending Directive 2006/112/EC on the common system of value added tax as regards the rules on invoicing
  3. 32006L0112 COUNCIL DIRECTIVE 2006/112/EC of 28 November 2006 on the common system of value added tax

To fulfil these regulations, the PODD (Proof of Delivery Date) functionality has been implemented. This flexible functionality is controlled by the new PL_PODD (Proof of delivery and VAT) function control. Even when this function control is activated, you can set the system up to work as it currently does in Standard IBS Enterprise, i.e. use the "Invoice creation date" for sales VAT and taxes purposes. A special set-up can also be configured for some exceptions.

Standard IBS Enterprise uses the "Invoice creation date" for sales VAT and taxes purposes. With the PODD functionality, the Proof of Delivery Date is used for this. The following three new types of sales have been introduced:

  • Domestic sales (type 1)
  • Sales inside EU (type 2)
  • Sales outside EU (type 3)

The type of sale is recognized by the system based on the countries defined in the warehouse and delivery address. For each type of sale (along with some other selection parameters) you can define how the PODD date should be calculated and how the invoice accounting period should be determined. The following possibilities are available:

a) PODD date could be determined automatically based on:

A – invoice creation date (like in standard)
B – dispatch date
C – delivery date

b) The invoice accounting period could be determined automatically by:

A – invoice creation date (like in standard)
B – PODD date

Both PODD date and accounting period could also be entered manually.

For Poland, the system should be set up in the following manner:

1) for domestic deliveries (sales from Poland to Poland) you must use the "Proof of Delivery Date (PODD)" as "Confirm Delivery Date by Customer" (B or C or manually). Accounting period is determined based on PODD date (B).

2) for sales inside and outside the EU you must use the "Invoice creation date" (A). (This means it works as in Standard IBS Enterprise).

New PODD and correct accounting period is updated in FIN module and in "VAT Day Book".

You configure the system to handle this functionality in the new Proof of delivery setup table. You can also define some additional controls like, e.g., confirming if the PODD date is mandatory to enter before invoicing, or you can define the number of days when the invoice could be created before the PODD date, or the max day of the next month after the PODD date when the invoice could be created. Note: If the PL_PODD function is activated, and the set-up is not configured in the Proof of delivery setup table, the invoicing of orders will not be possible. Sales orders will remain on status 45.

During daily processes, you must enter/change and confirm the PODD date before invoicing when it is required (and set up). This is done in the new Work with proof of delivery file. In this program you can select the sales orders from status 40 using different filters. When the PODD date is confirmed, invoices can also be created from this program. The invoice printout has been enhanced with the printed PODD date (setup).

Additionally, this functionality is merged with the IBS Mobile module. The confirmed Proof of Delivery in IBS Mobile updates the PODD date in the Work with proof of delivery file.

0800C
Sweden Work with BP banks Business partner file maintenance has been rewritten to the "Work with" concept. 0800A
USA ARCOS reporting of controlled substances The Automation of Reports and Consolidated Orders System (ARCOS) is an automated drug-monitoring system. It was developed by the Drug Enforcement Administration (DEA) to monitor selected controlled substances. ARCOS software enables governments to maintain a current and historical record of selected controlled substance inventories by monitoring the movement of controlled substances from their point of manufacture through commercial distribution channels to point of sale or distribution or other disposition, and finally, to the dispensing (consumption) level.

Manufacturers and distributors must periodically report their inventory of selected controlled substances to the DEA (ARCOS), (i.e. any increases and decreases to the inventory of these substances). Reporting is mandated under the Code of Federal Regulations (CFR), 21 CFR 1304.

To meet these needs, new IBS Pharma functionality for US Pharma installations has been added making it possible for you to collect information (inventory transactions in and out of stock) for batch controlled narcotic related items. When the necessary information is set up, the transactions are logged and the ARCOS report, which you manually create for the logged transactions, can be sent to the relevant authority.

To set up and run this functionality you must activate the following applications:
  • PHA (IBS Pharma)
  • US (US modifications)
  • UPH (US Pharma)
0800A
ePedigree reporting It is now possible for IBS Enterprise to interface with the rfXcel Traceability system, (an external application that handles ePedigree processing), to report the Pedigree ID's electronically for pedigree compliance. This information provides data on the history of a particular batch of a drug. It is used to track the path of the drug providing an authenticated pedigree which shows how the drugs have traveled through the supply chain.

New IBS Pharma functionality for US Pharma installations has been added making it possible for you to keep track of the pedigree's for your batch- and date controlled items in a warehouse, generate the Pedigree ID's and transmit them to rfXcel, which in turn uses the Pedigree ID to generate a tracking id. The IBS Pedigree ID is recorded in the secondary ID field in rfXcel.

The Additional products table is used to accommodate multiple releases of the rfXcel interface and other interfaces. Currently rfXcel version 4.2 is supported.

When the necessary information is set up, and you receive goods into a warehouse and/or pick from a warehouse you will need to enter/select a Pedigree ID (i.e. the unique ID you get from the supplier for the quantity of a specific item) for any item, supplier and customer that has been activated for ePedigree tracking. In addition, any time you enter a new batch number, the expiration date will be mandatory. That Pedigree ID can be sent to rfXcel for tracking.

To set up and run this functionality you must activate the following applications:

  • PHA (IBS Pharma)
  • US (US modifications)
  • UPH (US Pharma)
0800A
Exit point from sales order entry An exit point from sales order entry has been added making it possible to hold a sales order for other reasons than what is available in IBS Enterprise. This is driven by a new CSMOCALC function control where you define the external program in the Character value field. When that function control is activated, the external program will be executed during sales order entry. The external program sends back a return code. If the return code holds a value, then the sales order will be put on hold with the pre-loaded NH (Controlled substance hold) reason code.

The plug-in program you choose could be for any purpose. An example is for Controlled Substance Monitoring.

To set up and run this functionality you must activate the following applications:

  • PHA (IBS Pharma)
  • US (US modifications)
  • UPH (US Pharma)
0800F