Loading data in the DC1 Distribution base system

Mandatory data

The following information must be entered for DC1 Distribution:

Table/File	To do
Percentage table	The percentages to be created may be predefined, depending on the country where the system is installed. Otherwise you enter the percentages to be used when creating the VAT handling codes. Percentages may also be created for use in DC1 Report Writer.
VAT handling code table	The VAT handling codes to be created may be predefined, depending on the country where the system is installed. Otherwise you enter the codes to be used when automatically calculating VAT, based on the transaction amounts and percentages.
VAT import/export table	Enter the import/export codes to be used as default for sales and purchase orders. The information controls if sales and purchase order should be included in the Intrastat declaration. For sales orders it also controls if the order should be included on the Quarterly sales report. Note: Even if the EU reporting function is not activated, at least one code has to be defined, both for A/R and A/P, since the information is mandatory in the DIS control file.
Number series table	Enter the number series for the different documents you intend to use. The number series set-up for invoice related documents differs from other types of documents that require a number series. See Setting up number series for invoice related documents for instructions.
Warehouse table	At least one warehouse must be defined, which will be used as the main warehouse if DC1 Inventory Control is not installed, defined in DIS Control file. Warehouses are also used in the Sales prices & discount methods key table, which in turn is used to find the correct sales price when selling items. Warehouses are also used in the Sourcing policy functionality – whereby you define the sequence in which the system searches for available stock for delivery to the customer. (See Sourcing policy table and Business partner file for more information).
DIS control file	If DC1 Financials is not installed, you must define the handling of the accounting period, i.e. Actual year/period and Last closed period. The following fields must also be defined: Multi-currency Invoice round off Cost type Statistic base level BTB feature used Sep cost handling Delayed statistics Margin cost basis Main warehouse No of workdays/year Turn of year period Number series (connect the number series per document printout). Note: Temporary numbers must have it’s own number series and it must be a unique number range. Standard price list One order/item Pricing parameters (Sequence for pricing) Cost mark-up base Find best price Chain discount Cost per warehouse Item segmentation Await cost check Unit for volume Unit for weight Default VAT handling codes Default exchange rates, period and level Default Import/export codes Package reporting feature If you want to use the Work with Package reporting functionality allowing you to create packages with the unique 18-digit serial shipping container code (SSCC), define the following three fields on the Extension package and shipment info panel: Length of com prefix Company prefix (is assigned to a company via the EAN organisation) Code for Extended package number series Note: The package number series must be defined in the Extended number series table. Shipment preparation feature: You can automatically re-assign sales order lines to a new route, in the event that they were removed from the original shipment. A removal of a sales order line from the original shipment occurs when any of the following is changed: Manual of transport Dispatch date Warehouse Destination Shipping agent Route ID Departure ID If you are setting up Routes for your company and you want to be able to automatically re-assign sales order lines to a new route, define the following four fields on the Extension package and shipment info panel, under the Re-assign shipment section: Manual change Re-planning BtB/MDC change DI change
Exchange rate table	Exchange rates must be entered for all currencies to be used, according to the periods and levels you intend to employ.
Area table	Enter the areas to use for different customers and suppliers. Areas are used for statistical and accounting purposes to classify customers/suppliers in the Business partner file. Areas are also used in the Sales prices & discount methods key table, which in turn is used to find the correct sales price when selling items.
Terms of delivery table	Enter the terms of delivery to use for different customers and suppliers. The code is entered in the Business partner file and used as default when entering sales and purchase orders. When using the Landed cost function, the terms of delivery also defines if landed costs have to be defined for purchase order with this terms of delivery. Terms of delivery codes are also used in the Sales prices & discount methods key table, which in turn is used to find the correct sales price when selling items.
Terms of payment table	Enter the terms of payment to use for different customers. The code is entered in the Business partner file and used as default when entering sales and purchase orders. Terms of payment codes are also used in the Sales prices & discount methods key table, which in turn is used to find the correct sales price when selling items.
Manner of transport table	Enter the manner of transport to use for different customers and suppliers. The code is entered in the Business partner file and used as default when entering sales and purchase orders. The manner of transport can also be defined in the Item file/Supplier information panel, allowing you to use different manner of transport codes per item/supplier. Manner of transport codes are also used in the Sales prices & discount methods key table, which in turn is used to find the correct sales price when selling items.
Unit table	Define the different units in which items can be purchased, sold and manufactured.
Customer/Supplier group table	Enter the customer/supplier groups to use for different customers and suppliers. At least one customer/supplier group must be defined. Customer/supplier groups are used for statistical and accounting purposes to classify customers/suppliers in the Business partner file. They are also used in the Sales prices & discount methods key table, which in turn is used to find the correct sales price when selling items.
Account group table	Enter the account groups to use for different customers, suppliers and items. At least one account group must be defined. Account groups are used for statistical and accounting purposes to classify customers, suppliers and items. They are also used in the Sales prices & discount methods key table, which in turn is used to find the correct sales price when selling items.
Document output format table	This table is preloaded with the different documents that can be printed within DC1 Distribution. You define for each document you want to use if the document should be printed in landscape format, portrait format or in Accelio format. The default value at installation is portrait format.
Signature table	Enter the different signatures used for handlers, salesmen and responsibles. If using ISO9002 these codes are also used to define the authoriser during quality control. In addition, the signatures are also used as attesters in DC1 Financials and in the Purchase order attesting routines.
Country table	Enter the countries with which your company is doing business. If the EU reporting function is activated, the country of origin has to be defined for the items in the Item file.
Item group table	Enter the item groups to use for items. At least one item group must be defined. Item groups are used for statistical and accounting purposes to classify items in the Item file. They are also used in the Sales prices & discount methods key table, which in turn is used to find the correct sales price when selling items.
Business partner file templates and defaults	Define the templates to be used when adding, maintaining and enquiring about customers and suppliers in the Business partner file.
Sourcing policy table	Create sourcing policies for groups of warehouses. You define, per sourcing policy, the sequence in which the system will search for available stock. You connect the sourcing policies to the applicable customers in the Business partner file.
Business partner file	Enter all your customers and suppliers.
Item file templates and defaults	Define the templates to be used when adding, maintaining and enquiring about items in the Item file. These are also used in the Item file printout.
Item file	Enter all your items.
Calendar file	This table does not have to be loaded until you run the system. Define the working and non-working days of your company. Note: It is important that the first (earliest date) in the calendar is earlier than the earliest date the user wants to use in the system. Once the system has been taken into production, you cannot enter a date before the first date in the calendar. This means that if you are going to, e.g., convert statistics from another system into DC1, the first day in the calendar should be before the first day of "oldest" date on a converted order. Note: If you are going to install DC1 Inventory Control later on, you are able to save one or two years of demand history, i.e. that you should, at least, start the calendar one/two years before the current day.

Optional data

The tables described below are not vital to the basic routines of the system. Entries can be made now, later or not at all.

Table/File	To do
Assortment group table	The entries in this table are used to create Assortments for items. Assortments can be used as an aid when entering sales and purchase order lines.
Budget curve table	Entries must be created in order to be able to use curves when distributing budgets in the Budget file.
Budget number table	Budget numbers can be entered now and/or later.
Budget file	Budgets can be entered now and/or later.
Cash register codes	If you are going to use the Cash sales function in the Sales order entry routine, cash register codes have to be defined.
Credit card table	Enter the different credit cards used for payment by the customer. Note: This table is only used for informational purposes when entering cash sales orders.
Credit stop code table	Enter the different credit stop codes you want to use for customers. The codes are defined in the Business partner file and control the terms of payment code on the sales order, if you are allowed to enter sales order to a customer at all or if all sales orders should be held automatically.
Customer commission group	If the Sales commission handling is to be used, the customer commission group can be used as a selection criterion when calculating commissions to be paid to salesmen. In the Business partner file you define to which customer commission groups the customer belongs.
Customer restriction group table	The purpose of this table is to define a customer restriction group, which can be used as a key when Sales restrictions are defined. The customer restriction group is connected to a customer in the Business partner file.
Customer transport time table	This table is only used if Batch handling is used for items. Enter the different transport times for delivery from your warehouse to the customer’s premises.
Customer/Salesmen table	The purpose of this table is to define additional salesmen for customers to be used when calculating commissions to be paid to salesmen. The main salesman for a customer is defined in the Business partner file.
Discount group table	Enter the discount group to use for grouping customers/suppliers to different discount groups. Discount groups are used for statistical purposes to classify customer in the Business partner file, as well as in the Sales prices & discount methods key table, which in turn is used to find the correct sales price when selling items.
Discount ID table	If you offer your customers sales price discounts that are manually entered, or form part of a customer contract then these will need to be defined in this table. Enter the codes to identify each discount together with their description.
Fictitious item type table	Enter the different fictitious item types to be used for fictitious items.
Handling status table	Enter the different handling status codes that are used in the Item file to define if the item is valid to enter on different types of orders.
Insurance table	Enter the different insurance percentages per customer/manner of transport/terms of delivery which are used in the insurance calculation on customer level during sales order entry.
Item category 1-6 tables	Any entries are for statistical purposes only and are used in the Item file to categorise items in whatever manner desired. The categories are also used in the Sales prices & discount methods key table, which in turn is used to find the correct sales price when selling items.
Item commission group	If the Sales commission handling is to be used, the item commission group can be used as a selection criterion when calculating commissions to be paid to salesmen. In the Item file you define to which item commission groups the item belongs.
Item discount group table	Enter the discount group to use for grouping items to different discount groups. Discount groups are used for statistical purposes to classify items in the Item file, as well as in the Sales prices & discount methods key table, which in turn is used to find the correct sales price when selling items.
Item family table	Enter the item families to use for grouping items to different families in the Item file. Families are used for statistical purposes, as well as in the Sales prices & discount methods key table, which in turn is used to find the correct sales price when selling items.
Item note group table	Enter the item note groups you want to use. The entries are used in the Item note file, where you can enter text which shall appear when entering an item, belonging to the item note group, on sales and purchase orders.
Item note group member table	In this table you define which items belongs to which item note group.
Item note file	In this file you enter the text that should appear when entering items on sales and purchase orders. The text can also be copied into the orders.
Item price group table	Enter the item price groups to use for grouping items to different price groups in the Item file. The price groups can be used for statistical purposes, as well as in the Sales prices & discount methods key table, which in turn is used to find the correct sales price when selling items. The Item price group is also used as a selection criterion when re-calculating sales and purchase prices.
Item restriction group table	Enter the item restriction groups you want to use as keys to which your items can be connected when Sales restrictions are defined.
Item sector table	Enter the item sectors to use for grouping items to different sectors in the Item file. The item sector can be used for statistical purposes, as well as in the Sales prices & discount methods key table, which in turn is used to find the correct sales price when selling items. The Item price group is also used as a selection criterion when re-calculating sales and purchase prices.
Item segment values table	If the Item segmentation function is activated, enter the valid item segments valid in this table. The records are used when maintaining items to validate the values defined for each segment.
Item segmentation type table	If the Item segmentation function is activated, enter the segmentation types to be used. The segmentation type holds information about the rules and controls the segmentation of the item when an item is added to, or changed, in the Item file.
Landed cost types	Enter the landed cost types to be used when calculating landed costs. Landed costs are costs that are over and above the price paid to a supplier for the goods (purchase orders).
Lost sale reason table	If the Lost sales tracking function is activated, enter the reason codes to be used for lost sales. This information is used during Sales order entry and Quotation entry.
Name category 1-3 tables	Any entries are for statistical purposes only and are used in the Business partner file to categorise customer and supplier in whatever manner desired. The categories are also used in the Sales prices & discount methods key table, which in turn is used to find the correct sales price when selling items.
Name note file	In this file you enter the text that should appear when entering sales and purchase orders to customer/suppliers. The text can also be copied into the orders.
Name note group table	Enter the name note groups you want to use. The entries are used in the Name note file, where you can enter text which shall appear when entering a customer/supplier, belonging to the name note group, on sales and purchase orders.
Name note group member table	In this table you define which customers/suppliers belong to which name note group.
Order held reason code table	Enter the user-defined codes, indicating the reason for holding sales and purchase orders from further being processed. The table is pre-loaded with 4 reasons for sales orders and 3 reasons for purchase orders. When an order is manually held in the sales and purchase order maintenance routine, a reason code from this table has to be defined.
Order value discount table	Enter the different order value discount codes to be used for each customer in the Business partner file. This information is defaulted during Sales order maintenance and Quotation maintenance.
Package type table	Enter the package types used when shipping goods to your customers. If the function for package reporting is activated for sales order types, you can define how goods are packed when delivering to customers.
Profit/margin limits table	Enter the different lower and upper limit percentages per item group or sales order type. This information is used during Sales order maintenance and Quotation maintenance when a profit check is performed.
Purchase order type table	Enter the different purchase order types that define the handling of purchase orders in the system. Purchase order types can also be used for statistical and accounting purposes.
Quantity limits table	Enter the codes and define the different quantity limits to be used when retrieving the correct discount on sales orders. The quantity limit code is entered in the Item file/Sales prices panel to define the quantity limits to be used when selling the item.
Sales order priority table	Enter the sales order priorities to be used for sales order. In the event of a shortage in stock, the sales orders can be handled in the Work with allocation program, in which sales orders can be treated differently according to their priority code.
Sales order type table	Enter the different sales order types that define the handling of sales orders in the system. Sales order types can also be used for statistical and accounting purposes, as well as in the Sales prices & discount methods key table, which in turn is used to find the correct sales price when selling items.
Sales pricing & Discount method keys table	Activate and define the sequence for the keys to be used when defining sales prices and discounts in the Sales pricing & discounts methods file.
Sales price list table	Enter the price lists codes to be used in the Item file when defining the sales prices for items. Note: The actual prices are defined in the Item file and not in this table.
Salesman commission table	If commissions are to be paid to salesmen, enter the salesmen and the information about the commission to be paid.
Sales restriction key table	This table is preloaded with all the keys that can be used when a Sales restriction is defined. The purpose of the keys in this table is to prevent a sales order or quotation from being entered in the system. The restriction can be soft or strong; strong means no entry allowed; soft means that entry is allowed, but the order will be held.
Standard text table	Enter the different text codes to be used during Sales order maintenance and Purchase order maintenance. The actual text will be printed on the valid documents.
Structure type table	Enter the structure type codes to be used in the Item file to determine the structure handling of the items.
Function control table	Activate the functions that you want to use in the company. The functions can be activated now or later.
Supplier quotation group table	Enter the supplier quotation groups to be used when selecting from which suppliers a request for quote should be required. In the Item file the item is connected to a supplier quotation groups. In the Business partner file a supplier can be connected to one, or several, supplier quotation groups.
Supplier transport time table	Enter the different transport times for delivery from the supplier to the warehouse where the goods are received.
Summary level definition maintenance	There are two Summary levels preloaded in the system that must be active if the Items not bought enquiry is to be used. In that enquiry the sales information is displayed by Item group and is retrieved from the DC1 balance files. Therefore a summary level with keys Customer and Item group must be active. There is also a possibility to drill down by Item. In that case a summary level with keys Customer, Item group and Item must be active. Summary levels 996 and 997 are preloaded for these purposes.

Mandatory data

Optional data

Related topics