Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Current »

Demand Transactions

 

The option used to track the Demand Transactions of the Materials. It’s located in the right mouse button menu of the Materials List. The Demand Transactions window is in the form of a table. The upper part of the table displays the Material Code, Description and Main Unit information. The lines list the material transactions along with the following information:

 

  • Slip Date
  • Slip No.
  • Slip Aux. Code
  • Slip Status
  • Division, Department, Plant, Warehouse
  • Delivery Date
  • Quantity
  • Delivered Quantity
  • Unit

 

The transactions are filtered using the Filters option of the Demand Transactions list and only the transactions matching these conditions are listed. The filter value is specified by making a group or range definition or by selecting from the list.

Once the condition is specified, “OK” button is clicked and the transactions meeting the condition are listed. “Save Filter” button is used to record the filter conditions and list the transactions again with the same conditions, and “Load Filter” button is used to use the saved filter file again. The filter options and values of the material Order Transactions:

 

Filter

Value

Demand Slip Date

Start / End

Demand Slip Number

Group / Range

Demand Slip Aux. Code

Group / Range

Demand Slip Document Code

Group / Range

Demand Slip Status

Proposal / Waiting for Approval / Approved / Delivering / Closed / Cancelled

Division

Defined divisions

Department

Defined departments

Plant

Defined plants

Warehouse

Defined warehouses

Delivery Date

Start / End

Undelivered Quantity

Quantity range

 

 

Planned Transactions Tracking

 

The Planned Transactions Tracking is used to list all the planned transactions and their affect on the inventory starting from the Report Dates. The Planned Transactions option is located in the right mouse button menu of the Materials List.

 

The Orders, Planned Input from Production/Usage/Scrap/Warehouse Slips, Demand Slips and Production Planning Proposals that are not realized yet, but are likely to be realized are listed by plant. The Orders and Demand Slips and the Planned Material Slips affect the inventory at the Delivery Date and the slip date respectively by Slip Type.

 

The plant where the transaction will be tracked is specified in the Plant field located at the upper part of the window. The planned transactions of the selected material are listed in the following columns:

 

  • Slip Date
  • Slip Type
  • Slip No.
  • Variant Code
  • Variant Description
  • Warehouse
  • Dependent Requirement Quantity
  • Input Quantity
  • Output Quantity
  • Remaining Quantity
  • Customer Order No.
  • AR/AP Code / AR/AP Title
  • Slip Approval Info
  • Transaction Aux. Code
  • Production Order No.
  • Work Order No.
  • Product Code
  • Description

 


 

The physical inventory status of the materials is tracked from the Physical Inventory field. This field lists the total number of physical inventory for all warehouse of all transactions listed when this window opens for the first time. Physical inventory number can also be displayed on warehouse basis. The relevant warehouse(s) is selected in the filter page, and Physical Inventory field shows the inventory number of the selected warehouse(s) only. “View” button is used to access the slip information of the transaction.

 

The Sales Orders, Demand Slips, Planned Usage, Planned Scrap and output Warehouse Transfer Slips reduce the inventory.

 

The Purchase Orders, MPS-MRP Proposals, Planned Input from Production and input Warehouse Transfer Slips increase the inventory.

 

The Orders for which a Dispatch/Receipt is issued are not listed. If an order is partially transferred, the quantity of the order that is not transferred is listed as Main Unit.

The line description and the description of the relevant Production Order are transferred into the Description field for Orders, Demand Slips and MPS Proposals and Planned Material Slips respectively.

 

Distribution Orders

 

The option used to list the distribution orders that the material taken part. It's located in the right mouse button menu of the Materials List. The Distribution Orders window is in the form of a table. The upper part of the table displays the Material Code, Description and Main Unit information defined in the material card. The lines list the material transactions along with the following information:

 

  • Slip Date
  • Slip No.
  • Slip Aux. Code
  • AR/AP Title
  • Division
  • Department
  • Warehouse

 

The transactions are filtered using the Filters option of the Distribution Orders list and only the transactions matching these conditions are listed. The filter value is specified by making a group or range definition or by selecting from the list.

Once the condition is specified, “OK” button is clicked and the transactions meeting the condition are listed. “Save Filter” button is used to record the filter conditions and list the transactions again with the same conditions, and “Load Filter” button is used to use the saved filter file again. The filter options and values of the material Distribution Order Transactions:

 

Filter

Value

Distribution Order Number

Group / Range

Distribution Order Date

Start / End

Out For Distribution Date

Start / End

Return From Distribution Date

Start / End

Distribution Order Aux. Code

Group / Range

Distribution Order Auth. Code

Group / Range

Distribution Order Status

Proposal / Shipping… / Shipped

AR/AP Code

Group / Range

AR/AP Title

Group / Range

AR/AP Aux. Code

Group / Range

AR/AP Auth. Code

Group / Range

Division

Defined divisions

Department

Defined departments

Warehouse

Defined warehouses

 

 

Material Purchase Prices

 

In purchase transactions, the price bids from the vendors, discounts for purchases exceeding certain amounts, the payment conditions to be applied to price bids and the delivery times are recorded on a separate Material Class Purchase Price. Recording this information decreases the data entry error rate by allowing to select the defined prices in purchase transactions and applying them automatically to the transaction.

 

The defined prices are applied by selecting the defined price in the Unit Price column of the slip lines of the Purchase Receipts, Invoices and Order Slips. If the Purchase Price the material processed in the slip line is defined and the information entered in the slip matches the conditions specified in the definition record, the Unit Price in the record is automatically transferred into the slip when the defined price is selected.

 

In the LOGO application as many Purchase Prices as required can be generated for the Material Classes.

 

Once the application conditions and priorities of the recorded prices are set, the prices are transferred into the slips and invoices. This information is recorded in the relevant fields of the Material Class Purchase Prices window.

 

On the upper part of the Material Purchase Prices, the information of the Material the price belongs to are displayed. The middle part of the window is used to record the price information and the lower part is used to identify for which AR/AP Code and under which Conditions. The following information is recorded in the Material Purchase Prices window:


Code: The code of the Purchase Price.


Type: This field is used to select the type in order to specify that the Price belongs to the Material or the Material Class.


Authorization Code: The authorization code of the Purchase Price.


Material Code: The code of the Material for which the defined Purchase Price will be applied. The Material Code field is mandatory.


Material Description: The name or description of the Material for which the Purchase Price will be applied.

 

Division: Indicates the divisions that the defined price is valid for. It provides to define prices based on divisions.

 

If the defined price will be used for more than one division, the related divisions are selected one by one or collectively at “Divisions” window.

 

Status: Indicates whether or not the price card will be used in slips or invoices. This field has two options: Active and Passive. When Active option is selected, the price card is in active state and can be used in slips and invoices. When Passive is selected, the price card is in the passive state and therefore can not be used in slips and invoices.

 

Unit Price: The unit Purchase Price defined in the record for the material.

 

Unit Set: Indicates the Unit Set to which the price will be applied.

 

Unit: Indicates the Unit within the selected Unit Set that price will be applied to. With Material Characteristics, transactions can be performed for more than one unit due to various package and presentation methods.

 

VAT: This field indicates whether or not the specified Unit Price is VAT included. There are two options: Included and Excluded.

 

F. Currency: This field is used to indicate the Currency Type of the price specified in the Unit Price field. The Foreign Currency Types are listed and the appropriate Currency Type is selected.

 

Convertible To Other Units: Allows the defined price to be used for other units that are valid for the material but that do not constitute a Price. If a unit with no defined Unit Price is selected in the Material Transactions, the Conversion Factor specified in the Unit Price, Priority and Unit definitions are processed and the price is calculated by being converted into the unit used in the slip line.

 

Group Code: Used for grouping the purchase price cards.

 

AR/AP Code: The code of the AR/AP to which the Purchase Price will be applied. The price applications may vary according to the quantity purchased or the payment types. Applying these conditions to the AR/AP transactions after defining them in different prices prevents the loss of time and decreases the error rate.

 

AR/AP Title: The title of the AR/AP specified in Code field. This is displayed if AR/AP Code is used in price cars directly, that is to say, if “*” and et cetera characters are not added to the end of AR/AP code.

 

AR/AP Aux. Code: The Aux. Code of the AR/AP. The defined prices can be selected by the AR/AP Aux. Code and transferred into the slips and invoices.

 

Payment Plan: This field indicates the payment conditions in which the price bid will be valid. The Purchase Price may vary depending on the quantity purchased and the payment type. For instance, purchases under a certain amount may be subject to Cash payments, while more convenient prices and payment conditions may be applied to higher amounts. The payment type is defined by selecting a Payment Plan from the Payment Plans list.

 

Trading Group: Indicates the trading group to which the price will be applied.

 

Priority: The usage priority of the defined price. This field is used to determine which price will be primarily transferred into the slips and invoices in cases that there are multiple Purchase Prices for the same Material Class. The Priority must be numeric.

 

Start/ End Date and Time: Indicates the date and time range for which the Purchase Price specified in the record will be applied.

 

Sorting: The sequence number of the price definition.

 

Delivery Code: Indicates how the material will be received (land or air transport, post, etc.) and how the transport expenses will be met. For instance, the Delivery Code field can be used to specify whether or not the transport prices are included in the price bid.

 

Lead Time: The lead time of the material. Purchase Prices may vary depending on the lead times. Furthermore, the prices of certain materials may reflect periodic changes. Specifying the Lead Time in the Purchase Prices allows the prices to be tracked periodically and different prices to be applied to materials required to be procured immediately.

 

Price Update Limit: It is the user based price changing limit which is determined as percentage or amount for probable changes in predefined material / service price for any reason later on. The users are authorized to change predefined material / service prices at System Administration program part.

 

Condition: The Condition field at the lower part of the record is used to record the conditions in which the Purchase Price will be applied using parameters. The formulas defined in the Material Purchase Prices can include both arithmetical operations and functions. The conditions in which the defined Purchase Price will be used are determined with logical and arithmetical operations. In this way, the transactions are automatically performed, minimizing the usage errors. Prices may be defined by warehouse using the X1 parameter in the Condition field.

 

For instance, if the defined price is wanted to be applied to Warehouse number 2, X1=2 is entered. If the same price will be applied to more than one warehouse, the condition is set as (X1=[Warehouse Number 1.....Warehouse NumberN]).

 

Valid in E-Business Environment: Indicates that the Sales Price can be used in electronic commerce applications.

 

Valid in E-shop: Indicates that the Sales Price can be used in e-shop applications.

 

Valid in Points of Sale: Indicates that the Sales Price can be used in points of sale.

 

Description: This field can be used to enter a detailed description about the Sales Price.

 

 

Variant Characteristic Determination

 

The option located in the F9/right mouse button menu of the material sales/purchase price cards for the configurable materials. After entering the configurable material code in the price card, by the Variant Characteristic Determination/Batch Selection of Variant options, a window opens that lists the material characteristics and values. The preferred values are marked and the defined price card is assigned for that material variant with selected characteristic values. 


 

Material Sales Prices

 

In sales transactions, the price bids made to the customers, discounts for purchases exceeding certain amounts, the payment conditions to be applied to price bids and the delivery times are recorded on a separate Material Class Sales Price. Recording this information decreases the data entry error rate by allowing to select the defined prices in sales transactions and applying them automatically to the transaction.

 

The defined prices are applied by selecting the defined price in the Unit Price column of the slip lines of the Sales Receipts, Invoices and Order Slips. If the Sales Price of the material processed in the slip line is defined and the information entered in the slip matches the conditions specified in the definition record, the Unit Price in the record is automatically transferred into the slip when the defined price is selected.

 


 

In the LOGO application, as many Sales Prices as required can be generated for the Materials.

 

The conditions and priorities with which the recorded prices will be applied are specified in the record and transferred into the slips and invoices. The Material Sales Prices are recorded using the Sales Prices option of the right mouse button menu accessed when the relevant Material is selected. The New button located in the Material Sales Prices List is used to generate a new price.

 

On the upper part of the Material Class Sales Prices, the information of the Material the price belongs to are displayed. The middle part of the window is used to record the price information, and the lower part is used to identify for which AR/AP Code and under which Conditions the Sales Price will be applied. The following information is recorded in the Material Sales Prices window:

 

Code: The code of the Sales Price.


Type: This field is used to select the type in order to specify that the Price belongs to the Material or the Material Class.

 

Authorization Code: The authorization code of the Sales Price.

 

Material Code: The code of the Material for which the defined Sales Price will be applied. The Material Code field is mandatory.


Material Description: The name or description of the Material for which the Sales Price will be applied.

Division: Indicates the divisions that the defined price is valid for. It provides to define prices based on divisions.

 

If the defined price will be used for more than one division, the related divisions are selected one by one or collectively at “Divisions” window.


Status: Indicates whether or not the price card will be used in slips or invoices. This field has two options: Active and Passive. When Active option is selected, the price card is in active state and can be used in slips and invoices. When Passive is selected, the price card is in the passive state and therefore can not be used in slips and invoices.

 

Unit Price: The Unit Sales Price defined in the record for the material.


Unit Set: Indicates the Unit Set to which the price will be applied.


Unit: Indicates the Unit within the selected Unit Set that price will be applied to. With Material Characteristics, transactions can be performed for more than one unit due to various package and presentation methods.

 

VAT: This field indicates whether or not the specified Unit Price is VAT included. There are two options: Included and Excluded.

 

F. Currency: This field is used to indicate the Currency Type of the price specified in the Unit Price field. The Foreign Currency Types are listed and the appropriate Currency Type is selected.

 

Convertible To Other Units: Allows the defined price to be used for other units that are valid for the material but that do not constitute a Price. If a unit with no defined Unit Price is selected in the Material Transactions, the Conversion Factor specified in the Unit Price, Priority and Unit definitions are processed and the price is calculated by being converted into the unit used in the slip line.

 

Group Code: Used for grouping the sales price cards.

 

AR/AP Code: The code of the AR/AP to which the Sales Price will be applied. The price applications may vary according to the quantity sold or the payment types. Applying these conditions to the AR/AP transactions after defining them in different prices prevents the loss of time and decreases the error rate.

 

AR/AP Title: The title of the AR/AP specified in Code field. This is displayed if AR/AP Code is used in price cars directly, that is to say, if “*” and et cetera characters are not added to the end of AR/AP code.

 

AR/AP Aux. Code: The Aux. Code of the AR/AP. The defined prices can be selected by the AR/AP Aux. Code and transferred into the slips and invoices.

 

Payment Plan: This field indicates the payment conditions in which the price bid will be valid. The Sales Price may vary depending on the quantity sold and the payment type. For instance, sales under a certain amount may be subject to Cash payments, while more convenient prices and payment conditions may be applied to higher amounts. The payment type is defined by selecting a Payment Plan from the Payment Plans list.

 

Trading Group: The trading group to which the price will be applied.

 

Priority: The usage priority of the defined price. This field is used to determine which price will be primarily transferred into the slips and invoices in cases that there are multiple Sales Prices for the same Material Class. The Priority must be numeric.

 

Start/ End Date and Time: Indicates the date range for which the Sales Price specified in the record will be applied.

 

Sorting: The sequence number of the price.

 

Delivery Code: Indicates how the material will be received (land or air transport, post, etc.) and how the transport expenses will be met. For instance, the Delivery Code field can be used to specify whether or not the transport prices are included in the price bid.

 

Delivery (Days): The delivery time of the material. Sales prices may vary according to delivery times. Furthermore, the prices of certain materials may reflect periodic changes. Specifying the Delivery Time in the Sales Prices allows the prices to be tracked periodically and different prices to be applied to materials required to be procured immediately.

 

Price Update Limit: It is the user based price changing limit which determined as percentage or amount for probable changes in predefined material / service price for any reason later on. The users are authorized to change predefined material / service prices at System Administration program part.

 

Condition: The Condition field at the lower part of the record is used to record the conditions in which the Sales Price will be applied using parameters. The formulas defined in the Material Sales Prices can include both arithmetical operations and functions. The conditions in which the defined Sales Price will be used are determined with logical and arithmetical operations. In this way, the transactions are automatically performed, minimizing the usage errors. Prices may be defined by warehouse using the X1 parameter in the Condition field.

 

For instance, if the defined price is wanted to be applied to Warehouse number 2, X1=2 is entered. If the same price will be applied to more than one warehouse, the condition is set as (X1=[Warehouse Number 1.....Warehouse NumberN]).

 

Valid in E-Business Environment: Indicates that the Sales Price can be used in electronic commerce applications.

 

Valid in E-shop: Indicates that the Sales Price can be used in e-shop applications.

 

Valid in Points of Sale: Indicates that the Sales Price can be used in points of sale.

 

Description: This field can be used to enter a detailed description about the Sales Price.

 

 

Variant Characteristic Determination

 

The option located in the F9/right mouse button menu of the material sales/purchase price cards for the configurable materials. After entering the configurable material code in the price card, a window listing the specified material characteristics and values is opened by using Variant Characteristic Determination/Batch Selection of Variant options. The preferred values are marked and the defined price card is assigned for that material variant with selected characteristic values.

 

Lot / Serial Numbers

 

The Lot/Serial Numbers of the material tracked are recorded using the Lot / Serial Numbers option located in the right mouse button menu of the Materials list.

 


 

The relevant lot or serial numbers for the Tracking Method are recorded clicking “New” button.

 


 

The Serial Number can be directly entered by the user or assigned automatically by the application. To do so, “Generate Lot/Serial No.” option located in the right mouse button menu of the Lot/Serial Numbers window is used. The Lot/Serial Numbers can be automatically generated by specifying the Start Number and the Quantity.

 

Warehouse Parameters

 

The warehouse information of the material is recorded using the Warehouse Parameters option. The Warehouse Parameters option is located in the right mouse button menu when the Material List is open. Each good has different locations in different warehouses. In addition to the location, the minimum and maximum material quantities and safety inventory level can be different for each warehouse. The following information is entered in the Warehouse Info window:

 


 

Warehouse No. / Warehouse Name: The locations that are used to store the company’s goods or used for other purposes such as scrap or production are called Warehouses. The warehouses defined for the company and divisions and their numbers and names are displayed in the Warehouse Nr. and Warehouse Name fields. This window is used to record the Minimum, Maximum and Safety material levels (Warehouse Parameters) and the necessary codes for the ABC Analysis. The Warehouse Nr. and Warehouse Name fields can not be filled in from the table.

 

The Warehouses are defined using Warehouses option and according to the Company and Division definitions in the System Administration section. The warehouse specific information of the goods is recorded in the relevant field after the warehouse is selected. The following information is recorded:

 

Minimum, Maximum and Security Inventory Levels: It is crucial for the material requirement planning to know the minimum, maximum and security inventory levels to be kept. The material levels can be regularly tracked and the materials to be sold or produced can be procured in time using this information. The maximum and minimum options indicate the maximum and minimum amount of material to be kept respectively, and the security inventory level indicates the quantity of material required to be kept at all times.

 

Default Location: The default location of the material in the warehouse. The defined Location Codes are listed and the location of the material in the warehouse is selected. If “Track by Location” option is applied, the location of the material within the warehouse must also be specified in purchasing transactions of the material class or the material.

 

ABC Code: The code to be used in the analysis reports of the material is recorded in this field. The ABC Code allows the analysis reports that are important for the sales and costs of the material classes to be generated. The ABC method is one of the Inventory Revaluation methods. In addition to the Inventory Control, this method is also applied to the Sales, Distribution, Inspection, Finished Good Type, Material Procurement and Production Planning transactions. The usage of the ABC method in Inventory control is limited to the classification of the inventory items according to their cumulative percentages within the whole. This classification divides the inventories typically into three groups:

 

Group A inventory items account for 15-20% of the total quantity and 75-80% of the total value.

Group B inventory items account for 30-40% of the total quantity and 10-15% of the total value.

Group C inventory items account for 40-50% of the total quantity and 5-10% of the total value.

Some companies may classify their inventories in more than three groups or define sub-groups within the ABC groups. It’s natural that each company implements an adequate classification according to the properties of their inventory and defines the quantity and value percentages according to this criterion.

The amount percentages of the defined inventory classes are specified in a manner to facilitate an efficient control.

For example, Inventory Group A is predicted to account for 20%, Group B for 30% and Group C for 50% of the total quantity. There are two rules to be processed when applying the ABC principal: To possess large quantities of low value items; and to improve the control mechanism for high value items while decreasing their quantities.

When the inventory control is performed using the ABC method, the following method is used in order to apply a strict control over the Group A items:

 

  • Detailed record systems are arranged.
  • The inspection responsibility is assigned to higher level personnel.
  • Reviews periods are more frequent.
  • Procurement Time, Order Point, Safety Inventory Level and Order Quantity values are carefully calculated.
  • Procurement transactions are closely monitored.

 

For Group C items, the points specified below are adhered to in the lowest extent possible. The control, order and record transactions are kept simple, and some are cancelled. Since the material quantity is high, frequent review and order transactions are not necessary. Since the transactions are simple, less qualified personnel can handle them. For Group B items, a way in between the groups A and C is followed.

In other words, the ABC Analysis is the qualification of the materials according to certain criteria and by assigning Priority Levels. The analysis provides data to help various management techniques to be implemented, necessary decisions to be made and the methods to be adopted. The letters and respective priority levels:

 

A: Very important .............. The class with the highest percentage in the general total

B: Medium importance ....    The class with the medium percentage in the general total

C: Not very important .........     The class with the lowest percentage in the general total

 

This classification considers the percentages of the materials within the general total. The rates defining the Priority Levels are given in the filter.

 

Input Control / Output Control: It is possible to determine the warehouses in which the materials / materials of a certain class are located and to allow the Input and Output transactions to be performed only from these warehouses. This control and performance method is defined in the Input Control and Output Control fields of the Warehouse Parameters section. The Input Control and Output Control defaults are recorded using the Material Management Parameters.  The default values defined there are transferred into the material/material class warehouse parameters page. If different control methods will be used, the methods can be changed on the record.

 

Input Control and Output Control fields have three options:

 

  • Proceed
  • Block
  • Warn User

 

When Proceed is selected, warehouse control is not performed on the slip and invoices for the material / material class.

When Warn User is selected, the user is warned and prompted to confirm the record while the slip containing the material / material class transactions is recorded.

When Block is selected, if the warehouses specified in the slips will not be used in input and output transactions, the slips containing the input and output transactions are not recorded.

 

The slips and invoices are controlled according to the Maximum, Minimum and Security quantities specified in the Warehouse Parameters and the material level is checked with every transaction.

 

Note: Input and Output control also comprises the orders in “Proposal” status and the orders which are not reserved.

 

Negative Inventory Level Control: Certain companies may have negative inventories due to operational conditions. This situation must be avoided in terms of cost. If the material inventory is negative, the cost calculations can not be performed using the Average of On Hand, FIFO and LIFO methods. Only the Average of inputs and Periodic Average costing methods can be used for materials with negative inventory.

If the material level is allowed to be negative, such level must not exceed a certain quantity. In such cases, negative values can be entered in the minimum material field.

 

It is possible to print “Items with Negative Inventory Level” list which appears while saving slips.

 

Negative inventory level control can also be performed during “update” and “delete” transactions. When negative inventory level control parameters are selected, the inventory quantity cannot decrease below the negative inventory level.

 

During transaction entries, material level control is performed in three different ways. The control method is specified in the Material Management Parameters section. If the material level is below or above the Minimum, Maximum or Security levels, the application may proceed with one of the following:

 

  • Records the transaction without any warning,
  • Displays a warning message and prompts for confirmation to record the transaction,
  • Displays a warning message and does not record the transaction.

 

Note:  When materials, of which quantity level is below zero, are selected in slips and invoices, the relevant slip lines are highlighted in green.

 

Note: If it is required to apply the previously defined warehouse parameters for the new material card while copying the relevant material card, "Copy Plant and Warehouse Parameters While Copying Material Cards" parameter line located under Material Management parameters must be approved by selecting Yes option.

 

 

Material Status

 

The general status of the selected material in all warehouses is tracked using the Status option located in the right mouse button menu of the Materials list.

 

The Status window accessed through the right mouse button menu of the Materials list displays the Quantity and Amount totals of the warehouse transactions recorded in the Material Management, Sales and Distribution and Purchase sections. The following information is displayed in the Status window:

 

Purchase Orders

The amount of orders placed for the procurement of the material.

Delivered Sales Orders

The amount of delivered sales orders.

Sales Orders

The amount of orders received for the procurement of the material.

Delivered Orders

The amount of delivered purchase orders.

Planned Input from Production

If the Production Control section is used, this option indicates the planned input from production quantity.

Planned Other Inputs

If the Production Control section is used, this option indicates the planned other inputs quantity.

Planned Warehouse Inputs

If the Production Control section is used, this option indicates the planned warehouse inputs quantity.

Total of Planned Inputs

If the Production Control section is used, this option indicates the total planned inputs.

Planned Usages/Scraps

If the Production Control section is used, this option indicates the planned usage and scrap quantity.

Planned Other Outputs

If the Production Control section is used, this option indicates the planned other outputs quantity.

Planned Warehouse Outputs

If the Production Control section is used, this option indicates the planned warehouse outputs quantity.

Planned Total Outputs

If the Production Control section is used, this option indicates the total planned outputs.

Purchase Quantity

The quantity of purchased materials.

Input from Production

The quantity of material input from production.

Other Inputs

The quantity of material input from user defined slips.

Opening Amount

The amount of materials carried over from the previous fiscal year.

Total Inputs

The total quantity of purchased materials.

Warehouse Inputs

The quantity of materials input from warehouse.

Consignments Received

The quantity of consignments received.

Sales Quantity

The total quantity  of sales in TL and foreign exchange.

Usages/Scraps

The amount of used and scrap material.

Other Outputs

The quantity of material output from user defined slips.

Total Outputs

The amount of output materials including all transactions.

Warehouse Outputs

The quantity of materials output from warehouse.

Consignments Issued

The quantity of consignments issued.

Reserved Quantity

The amount of materials reserved for production or orders.

Physical Inventory

Indicates the total amount of inventory including the consignments received and issued.

Actual Inventory

Indicates the total amount of inventory excluding the consignments received and issued.

Cycle Count Excess

The amount of cycle count excess.

Cycle Count Deficit

The amount of cycle count deficit.

In Distribution

If the Distribution section is used, this indicates the quantity of materials in distribution.

Reserved for Distribution

If the Distribution section is used, this indicates the quantity of materials reserved for distribution.

Last Transaction Date

The transaction date of the material.

Purchase Amount

Indicates the monetary value of the purchases for each warehouse.

Sales Amount

Indicates the total sales amount for the warehouse.

Average Value

The average value of the material in TL and foreign exchange.

Last Transaction Date

Indicates the last transaction date of the material in the warehouse. The status information is tracked by date by selecting the date of transaction.

 

 

Purchases

 

The totals of the purchase transactions of the material in all warehouses are tracked using the Purchases option located in the right mouse button menu of the Materials list and the Material record. The Purchases window is in form of a table. The table lines contain the months within the fiscal year.

 


 

The columns display the Purchase Amount information in terms of,

 

  • Purchase Quantity
  • Purchase Amount in Local Currency
  • Purchase Amount in Reporting Currency

 

Add warehouses not effecting the status: In the event that you mark this field, beside default warehouses, all other warehouse transaction totals are listed as well used in purchasing transactions.

 

Sales

 

The totals of the sales transactions of the material in all warehouses are tracked using the Sales option located in the right mouse button menu of the Materials list and the Material record. The Sales window is in form of a table. The table lines contain the months within the fiscal year.

 

The columns display the Sales Amount information in terms of,

 

  • Sales Quantity
  • Sales Amount in Local Currency
  • Sales Amount in Reporting Currency

 

Add warehouses not effecting the status: In the event that you mark this field, beside default warehouses, all other warehouse transaction totals are listed as well used in sales transactions.


 

Status Graphic

 

The option used to display the material status information as a graphic.

 

 

Warehouse Totals

 

The status of the material in all warehouses where it is processed is tracked using the Warehouse Totals option located in the right mouse button menu of the Materials list and on the Material record. The defined warehouses are listed on the Warehouses section of the Warehouse Totals window and the status information of the warehouse selected as default is displayed at the right side of the window.

 

The warehouse to be displayed is selected from the Warehouse Name list and the Transactions option located in the right mouse button menu is used to list the Warehouse Transactions of a warehouse.

 

Purchase Orders

The amount of orders placed for the procurement of the material.

Delivered Sales Orders

The amount of delivered sales orders

Sales Orders

The amount of orders received for the procurement of the material.

Delivered Orders

The amount of delivered purchase orders.

Planned Input from Production

If the Production Control section is used, this option indicates the planned input from production quantity.

Other Planned Inputs

If the Production Control section is used, this option indicates the planned other inputs quantity.

Planned Warehouse Inputs

If the Production Control section is used, this option indicates the planned warehouse inputs quantity.

Total Planned Inputs

If the Production Control section is used, this option indicates the total planned inputs.

Planned Usages/Scraps

If the Production Control section is used, this option indicates the planned usage and scrap quantity.

Other Planned Outputs

If the Production Control section is used, this option indicates the planned other outputs quantity.

Planned Warehouse Outputs

If the Production Control section is used, this option indicates the planned warehouse outputs quantity.

Total Planned Outputs

If the Production Control section is used, this option indicates the total planned outputs.

Purchase Quantity

The quantity of purchased materials.

Input from Production

The quantity of material input from production.

Other Inputs

The quantity of material input from user defined slips.

Opening

The quantity of materials carried over from the previous fiscal year.

Total Inputs

The total quantity of purchased materials.

Warehouse Inputs

The quantity of materials input from warehouse.

Consignments Received

The quantity of consignments received.

Sales Quantity

The total quantity of sales in TL and foreign exchange.

Usages/Scraps

The amount of used and scrap material.

Other Outputs

The quantity of material output from user defined slips.

Total Outputs

The amount of output materials including all transactions.

Warehouse Outputs

The quantity of materials output from warehouse.

Consignments Issued

The quantity of consignments issued.

Reserved Quantity

The amount of materials reserved for production or orders.

Physical Inventory

Indicates the total amount of inventory including the consignments received and issued.

Actual Inventory

Indicates the total amount of inventory excluding the consignments received and issued.

Cycle Count Excess

The amount of cycle count excess.

Cycle Count Deficit

The amount of cycle count deficit.

In Distribution

If the Distribution section is used, this indicates the quantity of materials in distribution.

Reserved for Distribution

If the Distribution section is used, this indicates the quantity of materials reserved for distribution.

Last Transaction Date

The transaction date of the material.

Purchase Amount

Indicates the monetary value of the purchases for each warehouse.

Sales Amount

Indicates the total sales amount for the warehouse.

Average Value

The average value of the material in TL and foreign exchange.

Last Transaction Date

Indicates the last transaction date of the material in the warehouse. The status information is tracked by date by selecting the date of transaction.

 

 

Material Warehouse Transactions

 

It lists transactions of the material in the selected warehouse in accordance with filter definitions. Conditions are determined for material transactions by using filters, and only those transactions which are complying with these conditions are listed. Material Transactions window is in a form of a table. Material code, description and main unit info specified in material card are displayed on the upper section of the material card. Material transactions are listed along with the following details in lines.

 

  • Date
  • Slip Number and Slip Type
  • AR/AP Title
  • Division, Department, Plant and Warehouse
  • Line Type
  • Line Description 
  • Input/Output
  • Quantity, Unit, Unit Price and Amount 
  • Pricing Currency Type and Pricing Currency Amount 
  • Transaction Aux. Code

 

Conditions are determined with filters, and transactions complying with these conditions are listed. Filter options and their usage are stated below.

 

Filter

Value

Slip Type

Purchasing Receipt / Retail Sales Return Dispatch / Wholesale Return Dispatch / Consignment Return Dispatch / Sales Return Dispatch / Purchase Return Receipt / Retail Sales Dispatch / Wholesale Sales Dispatch / Consignment Dispatch (Issued) / Consignment Return Receipt / Scrap Slip / Usage Slip / Input From Production Slip / Opening Slip / Warehouse Slip / Producer Slip / Cycle Count Slip (+) / Cycle Count Slip (-)

Slip Date

Start / End

Slip Number

Group / Range

Slip Document Number

Group / Range

Slip Aux. Code

Group / Range

Slip Status

Planned/Actual

Billing Status

Unbilled / Billed

AR/AP Code

Group / Range

AR/AP Title

Group / Range

Division

Defined divisions

Plant

Defined plants

Department

Defined departments

Destination Warehouse

Defined warehouses

Source Warehouse

Defined warehouses

Work Station Codes

Group / Range

Work Station Description

Group / Range

Transaction Direction

Input / Output

Transaction Type

Material Transaction / Promotion Transaction / Deposit Transaction/ Mixed Case Transaction / Optional Material Transaction

Transaction Aux. Type

Group / Range

Unit

Group / Range

Input From Production Tracking Number

Group / Range

Dispatch/Receipt Status

Actual / Proposal


 

Material Purchases F. Currency Totals

 

Used to display the Purchase Transactions of the Material along with Transaction Currency and Reporting Currency information. To display the F. Currency Totals, the Material for which the F. Currency Totals will be displayed is specified in the Materials list and then the Purchase F. Currency Totals are selected from the right mouse button menu.

 

The defined filter values are written to a file using “Save Filter” button. The defined filter file is opened and the totals are listed according to the specified conditions using “Load Filter” button. Once the condition is specified, “OK” button is clicked and the totals are listed. The filter options of the Purchase Transactions in F. Currency:

 

Filter

Value

Slip Date

Start / End

Division

Defined divisions

Department

Defined departments

Warehouse

Defined warehouses

Slip Type

Purchase Invoice / Purchase Return Invoice / Purchase Price Diff. Invoice / Producer Invoice

Slip No.

Group / Range

Slip Aux. Code

Group / Range

Slip Document No.

Group / Range

Transaction Aux. Code

Group / Range

Invoice Status

Actual / Proposal

 

 

Material Sales F. Currency Totals

 

Used to display the Sales Transactions of the Material along with Transaction Currency and Reporting Currency information. To display the F. Currency Totals, the Material for which the Sales F. Currency Totals will be displayed is specified in the Materials list and then the Sales F. Currency Totals are selected from the right mouse button menu.

 

The defined filter values are written to a file using “Save Filter” button. The defined filter file is opened and the totals are listed according to the specified conditions using “Load Filter” button. Once the condition is specified, “OK” button is clicked and the totals are listed. The filter options of the Sales Transactions in F. Currency:

 

Filter

Value

Slip Date

Start / End

Division

Defined divisions

Department

Defined departments

Warehouse

Defined warehouses

Slip Type

(02) Retail Sales Return Invoice / (03) Wholesale Return Invoice / (07) Retail Sales Invoice / (08) Wholesale Invoice / (14) Sales Price Diff. Invoice

Slip No.

Group / Range

Slip Aux. Code

Group / Range

Slip Document No.

Group / Range

Transaction Aux. Code

Group / Range Definition

Invoice Status

Actual / Proposal

 

 

Material Extract

 

The Extract lists the Total Amount, Quantity and Slip information of Material Transactions within certain dates. The extract can also be obtained from the Materials list. To do so, the relevant material is selected in the Materials list and the Extract option of the right mouse button menu is used.

The extract conditions are set using the Filters option. The filter options of the material extract are:

 

Filter

Value

Slip Dates

Start / End

AR/AP Code

Group / Range

AR/AP Title

Group / Range

AR/AP Status

Active / Passive

AR/AP Aux. Code

Group / Range

Trading Group

Group / Range

Transaction Type

Material Transaction / Material Class Transaction / Promotion Transaction / Deposit Transaction / Mixed Case Transaction / Fixed Asset Transaction

Transaction G/L Code

Group / Range

Overhead Pool Code

Group / Range

Transaction Aux. Code

Group / Range

Slip Type

Purchase Receipt / Retail Sales Return Dispatch / Wholesale Return Dispatch / Consignment Return Dispatch / Consignment Receipt / Purchase Return Receipt / Retail Sales Receipt / Wholesale Receipt / Consignment Dispatch / Consignment Return Receipt / Scrap Slip / Usage Slip / Input From Production Slip / Opening Slip / Warehouse Transfer Slip / Producer Slip / Cycle Count Slip (Excess) / Cycle Count Slip (Deficit)

Warehouse Slip Type

All / Generated From Material Slips / Generated From Nationalization Slip

Slip Status

Actual / Planned

Slip Number

Start / End

Slip Aux. Code

Group / Range

Slip Document Number

Group / Range

Cancellation Status

Not Cancelled / Cancelled / All

Dispatch/Receipt

Billed Receipts/Dispatches / Unbilled Receipts/Dispatches

Dispatch/Receipt Status

Actual / Proposal

Report Unit

Group / Range

Units

Convert to Main Unit / Convert To Report Unit / List the Unit Used in Transaction

Divisions

Defined divisions

Plants

Defined plants

Warehouses

Defined warehouses

Departments

Defined departments

Currency Amount Type

Pricing Currency / Transaction Currency

F. Currency Type

Currency options

Price Difference

Included / Excluded

Lot Number

Group / Range

Lot Description

Group / Range

Serial Number

Group / Range

Serial Description

Group / Range

Serial Group Number

Group / Range

Serial Group Description

Group / Range

Expiry Date

Date entry

Workstation Code

Group / Range

Workstation Description

Group / Range

Workstation Aux. Code

Group / Range

Workstation Auth. Code

Group / Range

Location Code

Group / Range

Discounts

Will Be Removed From The Amount / Will Not Be Transacted

Surcharges

Will Be Added To Amount / Will Not Be Transacted

Subtotal

Weekly / Monthly / Without Subtotal

Print Report

Same Page / Different Page

Unit Set Code

Group / Range

Unit Set Description

Group / Range

Unit Set Aux. Code

Group / Range

Unit Set Auth. Code

Group / Range

Line Barcode

Group / Range

Unit Code

Group / Range

Unit Description

Group / Range

List Serial/Lot/Location Info

Yes / No

Input from Production Tracking No.

Group / Range

Project Code

Group / Range

Project Description

Group / Range

List By Variants

Yes / No

AR/AP Auth. Code

Group / Range

 

Save Filter” button is used to record the filter conditions and list the transactions again with the same conditions, and “Load Filter” button is used to use the saved filter file again.

 

An extract covering only the purchase and sales totals between the selected dates can be generated by specifying the Start Date and End Date in the Slip Dates filter line. Conditions are set in the Warehouse and Division filter lines to filter the Material Transactions separately by warehouses and divisions. A group or range definition and a condition is specified in the Transaction Aux. Code filter line to generate a material extract according to the Aux. Code entered in the Transaction Aux. Code filter of the slip lines. When the extract is generated after the conditions are set, the purchase and sales transactions between the specified dates are listed along with the Date, Slip Type, AR/AP, Purchase Quantity, Sales Quantity, Amount, Net Amount and Total column information. The upper part of the extract report displays the Material Code and Description, the Unit that the extract is generated with and the physical material information before the start date of the fiscal period, while the lower part displays the Total information of the purchase and sales transactions.

 

Material / Material Class Batch Update

 

Material / Material Class records’ information can be updated in batch. In order to update material records in batch, use Batch Update option located in the F9 /right mouse button menu of the material records.

 

For batch update, first the records are selected to be updated. The information of the records to be updated are determined by the filter lines of the batch update window. The material / material class information is updated according to the defined values at the filter lines. The filter options are:

 

Filters

Values

Status

Active / Passive

Aux. Code 1-5

Aux. code entry

Auth. Code

Auth. code entry

Group Code

Group code entry

Vendor Code

Vendor code entry

Purchase VAT Rate (%)

New VAT Rate

Sales VAT Rate (%)

New VAT Rate

Return VAT Rate (%)

New VAT Rate

Retail Sales VAT Rate (%)

New VAT Rate

Retail Return VAT Rate (%)

New VAT Rate

Shelf Life (Day)

Value entry

Shelf Life Type

Day / Week / Month / Year

Access Info

Accessible at E-Business Environment / Accessible at E-Shop / Accessible at Points of Sale

 


 

Standard Material Costs

 

This option is used to record the standard material costs. The option is located in the right mouse button menu of the Materials list. The Standard Material Cost is recorded by selecting the Plant and Cost Period. When the Standard Material Costs is selected, the standard cost records defined for the material are listed. New Standard Cost information is recorded in the blank line.

   

Plant: The plant for which the Standard Cost Amount will be applied. Defined plants are listed and the appropriate definition is selected.

 

Period Code / Description: Indicates the period to which the Standard Cost Amount belongs. The Standard Cost Periods are listed and the appropriate period is selected.

 

Unit Cost: Indicates the valid unit cost amount for the selected plant and period.

 

Unit Cost (RC): Indicates the valid unit cost reporting currency amount for the selected plant and period.

 

Unit Cost (TC): Indicates the valid unit cost reporting currency amount for the selected plant and period.

 

Transaction Currency Type: The transaction currency type to be applied for the standard unit cost. The F. Currency Types are listed and the appropriate option is selected.

 

Transaction Currency Exchange Rate: The average transaction currency exchange rate defined for the relevant period and transaction currency.

 

Reporting Currency Exchange Rate: The field where the Reporting Currency Exchange Rate is selected or entered directly.

 

 

Printing (Label)

 

The label forms of the Material are printed using “Print option. The application includes the standard label definition used as default. The labels can be printed using the standard label definition, or new definitions can be made. Once the filters are set as required; “OK” button is clicked. The defined label forms are listed and the definition to be used is selected using “Select From List” option of the Form To Be Printed field of “Print” window. Printing environment can be specified and the label to be printed can be controlled using the Form Unit field. The filter options are:

 

Filter

Value

Material Type

Commercial Good / Mixed Case / Deposited Item / Fixed Asset / Raw Material / Semi Finished Good / Finished Good / Consumer Good

Material Code

Group / Range

Material Description

Group / Range

Material Aux. Code

Group / Range

Material Authorization Code

Group / Range

Material Group Code

Group / Range

Material Vendor Code

Group / Range

Material Status

Active / Passive

Material Characteristics

Characteristic 1-10 (Characteristic Code / Characteristic Values)

Parent Class Code

Group / Range

Tracking Method

No Tracking / Lot Number /Serial Number

Location Tracking

Location Tracking / No Location Tracking

Lot Size Divisible

Not Divisible / Divisible

Warehouses

Defined warehouses

 

Selected material’s code or material codes are assigned to Material Code filter line as default (as detailed filter). When printing barcodes, because material codes are displayed in “Material Code” filter line as default, after “Quantity” filter line’s value is entered, printing transaction can be started.

 

 

Printing (Letter)

 

The letter forms of the Material are printed using “Print” option. The application includes the standard letter definition used as default. The letters can be printed using the standard letter definition, or new definitions can be made. Once the filters are set as required, “OK” button is clicked. The defined letter forms are listed and the definition to be used is selected using “Select From List” option of the Form To Be Printed field of “Print” window. Printing environment can be specified and the label to be printed can be controlled using the Form Unit field. The filter options are:

 

Filter

Value

Material Type

Commercial Good / Mixed Case / Deposited Item / Fixed Asset / Raw Material / Semi Finished Good / Finished Good / Consumer Good

Material Code

Group / Range

Material Description

Group / Range

Material Aux. Code

Group / Range

Material Authorization Code

Group / Range

Material Group Code

Group / Range

Material Vendor Code

Group / Range

Material Status

Active / Passive

Material Characteristics

Characteristic 1-10 (Characteristic Code / Characteristic Values)

Parent Class Code

Group / Range

Tracking Method

Do Not Track / Lot Number / Serial Number

Location Tracking

Location Tracking / Do Not Location Tracking

Lot Size Divisible

Not Divisible / Divisible

Warehouses

Defined warehouses

 

 

Barcode Label Designs and Printings

 

In Logo applications, limitless barcodes can be defined for each unit of the unit set that the material is tracked by. Product input and output transactions are recorded by these barcodes determined at material records.

 

Barcode Entry

 

The barcodes of the materials are defined by Units tab of the material definition windows or by using “Barcode” option which is located at the right mouse button menu of the materials list.

 

Barcode option contains the followings:

 

  • Quick Barcode Entry
  • Automatic Barcode Assignment

 

Quick Barcode Entries

 

With this option, the barcodes of the materials are recorded separately for each unit of the unit set that the related material uses. This option is used when the barcodes will be entered directly by hand.

 

At Quick Barcode Entry window, the materials that the barcodes will be defined for are determined by Filters option. The filter options to be used to select materials are:

 

Filter

Value

Material Type

Commercial Good / Mixed Case / Deposited Item / Fixed Asset / Raw Material / Semi Finished Good / Finished Good / Consumer Good / Material Class (General / Table)

Material Code

Group / Range

Material Description

Group / Range

Material Aux. Code

Group / Range

Material Auth. Code

Group / Range

Material Group Code

Group / Range

Material Vendor Code

Group / Range

Material Tool Mark

Yes / No

AR/AP Code

Group / Range

AR/AP Description

Group / Range

Customer/Supplier Code

Group / Range

Customer/Supplier Description

Group / Range

Material Characteristics (1-10)

Group / Range

Parent Class Code

Group / Range

Parent Class Description

Group / Range

Parent Class Aux. Code

Group / Range

Parent Class Auth. Code

Group / Range

Parent Class Group Code

Group / Range

Parent Class Vendor Code

Group / Range

Parent Class Status

Active / Passive

Configurable Sign

Yes / No

Brand Code

Group / Range

Barcode

Group / Range

Unit Line Number

Start / End

Show Existing Records

Yes / No

 

Once the conditions are set, “OK” button is clicked. The materials suited to the conditions are listed at the upper side of the Quick Barcode Entries window as separate lines with the following column info:

 

  • Type
  • Material Code
  • Material Description

 

In the bottom of Quick Barcode Entry window, the units are listed which belong to the unit set of the material for which barcode will be defined. The barcode and barcode with unit, valid for each unit, is recorded in “New Line” and “Barcode With Unit” fields. In the event of selecting “Yes” in “Show Existing Records” filter line of Filtering window, all previously defined barcodes for related material are listed in the lines of quick barcode entry window; they can be changed if necessary. This filter line default is “Yes”. When “No” selected, related material’s barcode data is not listed and cannot be updated; only new barcodes can be defined for that material.

 

During quick barcode entries, it is possible to find proper barcode and to prevent wrong entries by using the options located at the right mouse button menu.

 

These options are:

 

Find Empty Barcode: Used to find the materials that any barcode in not defined for.

Find Erroneous Barcode: It is controlled according to EAN13 and if an erroneous barcode if found, it is positioned on that material.  It is corrected by using “Transfer The Correct Barcode” option.

Transfer the Correct Barcode: It can be used only for calculating control code for EAN 13 and assign a code again. A control code calculation is performed on line and if control code is wrong its value is corrected.

 

Assigning Barcodes Automatically - Barcode Templates

 

The barcodes can be assigned to materials automatically by using “Automatic Barcode Assignment” option of the Barcode menu. As well as assigning barcodes to materials which have no barcode, new barcodes are also assigned to materials which have barcodes already.

 

Automatic barcode assigning standards and numbering data are determined by using barcode numbering templates. These templates are defined by Barcode Numbering Templates option which is located under Main Records menu of Material Management program section.

 

Barcodes are assigned to materials using standard and record numbering characteristics selected from the related template used in assignment transaction.

 

Automatic Barcode Numbering Templates

 

Automatic barcode assigning standards and numbering data are determined by using barcode numbering templates. Numbering templates are defined by Barcode Numbering Templates option which is located under Main Records menu of Material Management program section.

 

The fields and functions on the barcode numbering templates are:

 

Code: The record code of the template which will be used for automatic barcode assignment. This field is mandatory.

 

Description: The name or explanatory info of the template.

 

Aux. Code: A second coding field that is used to group template definitions according to specific criteria. It can also be used as a filter in reports.

 

Auth. Code: The barcode assignment template auth. code. Used for data security. Only the users who own the code specified here can work on the related template. 

 

Barcode Type: Used to determine the standards to be used when creating barcodes. 

 

Contains the following options:

 

EAN13

Code 128

 

Template: It is the barcode record numbering template that will be used for barcode assignments. By clicking “…” symbol the Barcode Record Number Templates are listed and related record is selected or new one is defined. 

 

Unit Line Number: Used to specify one of the unit of material that the barcode will be printed for.

 

Check Digit: When this option is marked, one digit control character is calculated for the created number.

 

Barcode Label Printings

 

As barcode labels can be printed one by one or collectively, they can also be printed after material input transactions by using following options:

 

  • Print (Label) at right mouse button menu of materials lists
  • Print Barcode at right mouse button menu of purchase and sales orders, dispatch/receipt and invoices lists

 

Barcode Label Printing from Materials List

 

Material barcode labels are printed by using “Print (Label)” option located at the right mouse button menu of Materials list.

 

The materials for which barcodes will be printed are specified in filter lines. The filter options are:

 

Filter

Value

Material Type

Commercial Good / Mixed Case / Deposited Item / Raw Material / Semi Finished Good / Finished Good / Consumer Good

Material Code

Group / Range

Material Description

Group / Range

Material Aux. Code

Group / Range

Material Auth. Code

Group / Range

Material Group Code

Group / Range

Material Vendor Code

Group / Range

Material Status

Group / Range

Material Characteristics (1-10)

Group / Range

Parent Class Code

Group / Range

Tracking Method

No Tracking / Lot Number / Serial Number / Serial Group Number

Location Tracking

Location Tracking Will Be Done / Location Tracking Will Not Be Done

Lot Size Divisible

Not Divisible / Divisible

Warehouses

Defined warehouses

Quantity Value

The value on filter / Actual quantity in the warehouse / Physical quantity in the warehouse

Quantity

Quantity entry

Unit Line Number

Line number entry

Barcode Order Number Value

First One / Last One / The value on filter

Barcode Order Number

Barcode order number entry

Printing Criterion

All / Ones Have Barcode / Ones Don't Have Barcode

 

Materials for which barcodes will be printed are filtered according to their types at material type filter line. 

 

In material code, description, aux. code, auth. code, group code and vendor code fields, the materials for which barcodes will be printed are filtered according to these data defined at material cards.

 

Selected material’s code or material codes are assigned to Material Code filter line as default (as detailed filter). When printing barcodes, because material codes are displayed in “Material Code” filter line as default, after “Quantity” filter line’s value is entered, printing transaction can be started.

 

It is possible to filter materials according to material characteristics and to print labels to materials appropriate for the desired conditions by using material characteristics filter line.

 

By the selecting one of the material tracking method in tracking method filter line, labels can be printed separately for the materials tracked by lot, serial, serial groups.

 

Depending on the selection in “Quantity Value” filter line, the serial and lots of materials (not issued yet) can be printed. 

 

For example: if quantity value is selected as “Physical quantity in the warehouse” and if “serial no” is defined to barcode design, 10 serial numbers belonging to material are printed to related field in label design. So, labels are printed belonging to 10 different serial numbers of the same material.

 

Same is valid for materials tracked by lot system when printing barcode labels. For example, if there are 3 different lot with 5-10-15 units, giving 30 to quantity value filter, 30 units of label printing can be done including the lot numbers.

 

With quantity value filter, in case serial and lot numbers do not match, labels are printed as many as the value specified in quantity filter line.

 

Quantity Value filter line is used to determine how many barcode labels will be printed. Contains the following options:

 

  • The value on filter
  • Actual quantity in the warehouse
  • Physical quantity in the warehouse

 

In the event of selecting the value on filter, number of barcode labels to be printed is specified in Quantity filter line. 

If actual quantity in the warehouse is selected, barcode labels are printed as many as the actual material quantity of specified warehouse in warehouses filter line.

If physical quantity in the warehouse is selected barcode labels are printed as many as the physical material quantity of specified warehouse in warehouses filter line.

 

Unit Line Number filter line is used to specify one of the unit of material that the barcode will be printed for.

 

Barcode Order Number Value filter is used to specify the barcodes to be printed which have been entered for the units of the material unit set.

Contains,

 

  • First One
  • Last One
  • The Value on Filter

 

options.

 

When First One is selected, the first barcode entered for the unit is used for label printing.

When Last One is selected, the last barcode entered for the unit is used for label printing.  

If The Value on Filter is selected, the barcode specified in Barcode Order Number filter line is printed.

 

Printing Criterion filter is used to specify the materials that barcode labels will be printed for. This filter line contains,

 

  • All
  • Ones Have Barcode
  • Ones Don't Have Barcode

 

options.

 

When All is selected, barcode labels are printed for all materials.

If Ones Do Not Have Barcode is selected, labels are printed only for the materials that have no barcode.

If Ones Have Barcode is selected, labels are printed only for the materials that have barcode.

 

Barcode Label Printing over Transactions

 

Material barcode labels can also be printed thru material transactions) material slips, purchasing and sales dispatches and invoices). To do that, “Print Barcode” option is used which is located at the right mouse button menu of the material slips / dispatches / receipts / order and invoice lists. The conditions to be valid for label printing are determined by filtering options. The filter options are:

 

Filter

Value

Unit Line Number Value

The Value on Line / Value on Filter

Unit Line Number

Line Number Entry

Barcode Order Number Value

First One / Last One / The Value on Filter

Barcode Order Number

Line Number Entry

Printing Criterion

All / Ones Have Barcode / Ones Don't Have Barcode

Barcodes To Be Printed

Barcode / Barcode With Unit

List Slip Lines

Yes / No

 

Unit Line Number Value filter line is used to determine which unit of the material's unit set will be printed. If "The Value on Line" is selected, the unit in the relevant slip line is used in barcode printing. If "The Value on Filter" is selected, the next unit specified in the Unit Line Number filter line is used in printing.

 

Unit Line Number is used to specify one of the unit of material that the barcode will be printed for.

 

Barcode Order Number Value filter is used to specify the barcodes to be printed which have been entered for the units of the material unit set. This filter line contains the following options:

 

  • First One
  • Last One
  • The Value on Filter

 

When First One is selected, the first barcode entered for the unit is used for label printing.  

When Last One is selected, the last barcode entered for the unit is used for label printing.  

If The Value on Filter is selected, the barcode specified in Barcode Order Number filter line is printed.

 

Printing Criterion filter is used to specify the materials that barcode labels will be printed for. This filter line contains the following options:

 

  • All
  • Ones Have Barcode
  • Ones Don't Have Barcode

 

When All is selected, barcode labels are printed for all materials.

If Ones Do Not Have Barcode is selected, labels are printed only for the materials that have no barcode.

If Ones Have Barcode is selected, labels are printed only for the materials that have barcode.

 

Barcodes To Be Printed: This filter line is used to determine which of the barcodes defined in the material card will be used for barcode label printing. Contains the following options:

 

  • Barcode
  • Barcode With Unit

 

If "Yes" option is selected in List Slip Lines filter line, a window listing all slip lines will open. Users determine the slip lines of which barcodes will be printed by entering quantity information.

 

After the conditions are set in filter lines, “OK” button is clicked and after label form is selected, printing process is started.

 

Barcode Field on Report / Form Printouts

 

With the new additions on reports and forms, it is provided to print barcodes directly on reports and forms. When barcodes are printed on to forms and reports, it will be possible to reach related materials by using barcode reader from form and report printouts.

 

After barcode icon is selected by left mouse key, the part, which the barcode will be written to, is selected on the report or form to generate the barcode field.

 

Double click the related field to reach the options.

 

By using Barcode Type field, you choose one of an appropriate barcode type from the existing barcode type options to take printout according to appropriate barcode type.

 

When the barcodes with different length will be printed to the repots or forms at the same time, the barcode types can be selected as Code128, Code 128 Set: Code B which supports different lengths.

 

The general outlook of barcode is determined by “View” tab of Barcode definition window.

 

Bar Color: Used to determine bar color of barcode.

 

Background Color: Used to determine background color of barcode.

 

Hide Code: Used to determine whether the related code/numbers will be written to the bottom part of the barcode bar or not.

 

Use Perpendicularly: Provides top print barcode bars perpendicularly.

 

Width: The width of the barcode to be printed.

 

Data Matrix Barcode Label Printing

 

Datamatrix barcode labels are used to facilitate tracking of medical equipments and drugs, especially in health care systems.

 

Alongside the barcodes being used in drug packages required for drug tracking system, datamatrix barcodes including product code, serial number, the restarting sequence number for each serial, production date and expiry date are used by producer companies.

 

Similarly, data matrix barcodes including product code, serial number, order number (restarting for each serial), production/import date are used in optical sector. (Ps: The same serial number can be used for multiple products in optical sector.) In glasses frames or optical glass applications, while barcode-datamatrix can be used together, they can also be used separately.

 

Data matrix code is a 2d barcode type consisting of black and white cells. These cells can be square or rectangular. Both text and raw data can be entered in Data matrix barcode.

 

Symbols and data matrix cell number determine information storage dimension in this technology which enables to store data up to 2KB. Thanks to error correction codes, barcode can be read even in case of any deformation on barcode. Standard DataMatrix can keep 2335 alphanumeric characters.

 

In Logo application, serial number and lot number info of traceable material is required to perform data matrix barcode printing. In order to use serial and lot numbers, tracking method must be selected as serial group. 

 

Lot/Serial Number Entry for Material

 

Serial numbers that will be valid for the material are entered by using Lot/Serial Numbers option located in F9-right mouse button menu of Materials list.

 

In Lot/Serial Numbers window accessed by “New” option, serial group which will be valid for the material is entered in Lot No field.

 

Data entered in Lot No field is transferred to data code field. Serial number is written next to this transferred code. Serial number entry is performed by user. Data transferred from lot no field can not be changed. Material serial number is considered as data (lot no + code) entered in code field.

 

Data Matrix Barcode Label Designs

 

It is provided to print data matrix barcodes on forms and reports and access materials by barcode reader over form or report outputs when required.

 

In order to add datamatrix to a form, Datamatrix icon located on the form design page and the relevant spot on form you want to display the datamatix must be selected respectively. 

 

Drug:

 

The relevant field is double clicked for datamatrix barcode information, and the barcode information is recorded over the following fields:

 

  • Barcode Number
  • Serial Number
  • Expiry Date
  • Lot Number

 

Visual Aids Medical Equipments:

 

  • Barcode Number
  • Serial Number
  • Production/Import Date
  • Lot Number

 

All data entry fields include the following options:

 

  • Fixed
  • Standard field
  • User-defined field

 

If a fixed info is to be printed, Fixed option is selected, or Standard field and User defined field can also be selected in accordance with the required data.

 

When code type is Standard or User-defined, “Lot no” field added to material card serial group definition must be selected for lot no field.

 

When code type is Standard or User-defined, “code field” defined in serial group must be selected for serial no field.

 

Only entered values will be printed next to barcode. Application separators (2 digit numbers located at the top of field name) related to these values will also be available.

 

Material Filters

 

Filter option is used to display the records of the Materials list that match specific conditions. In this way, the requested record can easily be found and tracked. The filter option is located in the F9 key and right mouse button menu of the Materials list. The filter options and values are:

 

Filter

Value

Material Type

Commercial Good / Deposit Item / Fixed Asset / Raw Material / Semi Finished Good / Finished Good / Consumer Good / Mixed Case / Material Class (With Table) / Material Class (General)

Material Code

Group / Range

Material Description

Group / Range

Material Aux. Code

Group / Range

Material Auth. Code

Group / Range

Material Group Code

Group / Range

Material Vendor Code

Group / Range

Material Tool

Yes / No

AR/AP Code

Group / Range

AR/AP Description

Group / Range

Customer/Supplier Code

Group / Range

Customer/Supplier Description

Group / Range

Material Characteristics

Characteristic 1-10

Parent Class Code

Selection by list

Parent Class Description

Selection by list

Parent Class Aux. Code

Selection by list

Parent Class Auth. Code

Selection by list

Parent Class Group Code

Selection by list

Parent Class Vendor Code

Selection by list

Parent Class Status

Active / Passive

Physically Inventory Quantity

Negative / 0 / Positive

Configurable Sign

Yes / No

Brand Code

Group / Range

Use Warehouse Filter in Totals

Yes / No

Warehouse to be used in Totals

Defined warehouses

Added By

User selection

Addition Date

Start / End

Addition Time

Hour entry

Last Updated By

User selection

Last Update Date

Start / End

Last Update Time

Hour entry


 

Material / Material Class Tree

 

The Material Classes and the materials they include are recorded using the Material and Material Class Access Tree. The defined material classes and their materials are displayed in the access tree. Only the ALL MATERIALS folder is defined as default in the access tree.

 

When a Material Class is selected, the Child Material Classes and Materials connected to that class are listed.

 

The material classes and materials can be recorded on the Material/Material Class Tree window using “New” button. The Child Material Classes of the Material Classes are recorded by clicking “New” button while the relevant Material Class is selected.

 



 

Unit Sets

 

The Main Unit and the other units that will apply to the Material and Material Class are defined using the Unit Set Definitions. The Unit Set Definitions are recorded using the Unit Sets option of the Main Records menu. The Unit Sets window displays the following unit types:

 

  • Weight
  • Length
  • Area
  • Volume
  • User Defined

 

The unit assignments of the Materials and Material Classes are done according to the Unit Sets. Each Material and Material Class can use only one Unit Set. The first unit entered for each type is determined as Main Unit and is displayed bold in the list. The conversion to Main Unit factor must be entered for the other units of the same type.

The Weight, Length, Area and Volume unit types are used to enter the Width, Length, Height, Area, Volume and Weight information while the Material and Material Class specific units are defined. In this way, all units and material quantities used in the company can be expressed and reported using the same units.

 


 

The conversion factors of the Unit Sets are recorded using the Conversion Info option located in the right mouse button menu while the Unit Sets list is open. The Unit Set information for which the conversion information will be applied is recorded using the Factor field on the Conversion Info window.

 

The Material and Material Classes that use the defined Unit Set are listed using Used in Cards option located in the right mouse button menu while the Unit Sets list is open.

 

The Unit Sets are used to define a Main Unit and as many sub-units as necessary for each Material or Material Class. The Main Unit factors of the sub-units are specified.

 

The Weight, Length, Area and Volume Unit Sets are defined as default in the application. These units are used in the dimension information of the material. The units to be applied for the Material Class or the Material are recorded by the user. A Unit Set is defined as default in the application and such default value is transferred into the cards.

 

The Unit Set Definition is used to define the Main Unit and other units to be applied for the material. The dimension and volume information of these units are also defined using the Unit Set.

 

The buttons located at the lower part of the Unit Sets list and the options and functions of the right mouse button menu are:

 


New

Used to define a new unit set.


Update

Used to change the unit set definitions.


Delete

Used to delete the unit set definition.


View

Used to view the unit set information without making changes.


Copy

Used to create a new record by copying the information of the unit set definition.

 

Database Extensions

Additional info forms to be defined by the user.

 

Multiple Delete

Used to delete more than one records simultaneously.

 

Conversion Info

Used to record the conversion Info of the selected Unit Set.

 

Used in Cards

Used to list the material classes or materials that use the selected unit set.


Filter

Used to access the unit sets according to the filter conditions specified in the Unit Set list.


Record Information

Indicates the users who performed the entry and update transactions of the selected record and the time of these transactions.

 

Number of Records

Used to display the number of defined unit sets.

 

Refresh

Displays the list of the defined records with the latest information.

 

Back to Defaults

Used to display the active window with the standard dimensions defined in the application.

 

The following information is recorded in the Unit Set Definition window:

 

Code: The definition code of the Unit Set.

 

Description: The definition or description of the Unit Set.

 

Aux. Code: The Auxiliary Code indicating the Company specific conditions of the Unit Set.

 

Authorization Code: The authorization code of the Unit Set.

 

Type: The type of the unit set. When unit set is chosen, the type is automatically transferred into this field. This option is used for tracking purpose.

 

Usage Criteria: This field is used to determine the usage type of the Unit Set. The Usage Criteria field consists of two options:

 

  • General
  • For Material/Service

 

When General is selected, the Unit Set definitions can be used in all Materials and Material Classes.

When For Material/Service is selected, the Unit Set definitions can only be used in Materials and Services they are connected to.

 

Each Unit Set has a Main Unit and sub-units defined based on this Main Unit. First the Main Unit is defined in the Unit Set. Once the Main Unit is recorded, the next line is proceeded in the Unit field and the other units corresponding to this Main Unit are defined.

 

Main Unit Code: The main unit code of the unit defined in the Unit Set.

 

Main Unit Description: The main unit description of the unit defined in the Unit Set.

 

Conversion Factors: The Main Unit conversion factors of the units defined in the Unit Set. The Main Unit factor of each unit is specified in the Conversion Factors field.

 

Dimensions: This section is used to record the dimension information (Width, Length, Height, Area, Volume and Weight) to be applied for each unit to be used in the material or material class.

 

 

Unit Set Conversion

 

Conversion Info option is used to record the conversion info between the Unit Sets. To record the Conversion Info of the Unit Sets, first the definition for which the conversion definition will be recorded is selected from the list. Then Conversion Info located in the right mouse button menu is selected.

 

The following information is entered in the Unit Set Conversion Info window:

 


 

Divisor: The conversion divisor information.

 

Unit Set Code: The Unit Set Code that the Conversion Info will be based on. The Unit Sets are listed and the appropriate option is selected. The description of the Unit Set Definition for which the code is provided is transferred into the description field.

 

Unit Set Description: The description of the Unit Set that the Conversion Info will be based on. The unit sets can also be displayed and selected on this field.

 

Factor: The Factor that will be used in Unit Set conversions.

 

Unit Set Code: The code of the unit set for which the conversion info is entered.

 

 

Used in Cards

 

“Used in Cards” window lists the units in each Unit Set and the relevant usage points. The Material Class and Materials used by the Unit Sets are displayed on this window. The following information is displayed on Used in Cards window:

 


 

Type: Indicates the unit type used in the Unit Set.

 

Material (Class)/Service Code: The code of the Material, Material Class or Service using the unit.

 

Material (Class)/Service Description: The name or description of the Material, Material Class or Service using the unit.


 

Material Characteristics

 

The Material Characteristics are distinctive properties of a material. These characteristics can be quantitative or qualitative. The Materials are automatically generated by the application according to the characteristic definitions. The materials can be easily grouped and reported according to their characteristics.

 

The characteristic definitions are recorded using the Material Characteristics option of the Main Records menu. The Material Characteristics menu options are:

 


New

Used to generate a new characteristic definition.


Update

Used to change characteristic information.


View

Used to view the characteristic information without making changes.


Delete

Used to delete the characteristic definition.


Copy

Used to create a new record by copying the definition information.

 

Database Extensions

Used for additional information forms.

 

Multiple Delete

Used to delete more than one records simultaneously.


Record Information

Indicates the users who performed the entry and update transactions of the selected record and the time of these transactions.

 

Number of Records

Displays the number of recorded cards.

 

Refresh

Displays the list of the defined records with the latest information.

 

Back to Defaults

Displays the window dimensions with the size defined in the program.

 

The following information is recorded in the Material Characteristic window accessed by clicking “New” button located at the bottom of the Material Characteristics list:

 


 

Code: The definition code of the material characteristic.

 

Description: The definition or description of the material characteristic.

 

Aux. Code: The Auxiliary Code indicating the Company specific conditions of the material characteristic.

 

Authorization Code: The authorization code of the material characteristic.

 

The values and descriptions of the material characteristics are recorded in the Values field of the Material Characteristic window.

 

Value: The name or code of the Characteristic Value (such as color, size)

 

Description: The name or description of the Characteristic Value.

 

The Usage of Material Characteristics

 

The Material Characteristics are used in the Materials and Material Classes (with Table). The Material Characteristics tab of the Material Class is used to define the characteristics to be applied for the Material or Material Class (with table).

 

The fields of the Material Characteristics tab and their functions are:

 

Characteristic Set Code/Description: The field that the characteristic set is selected for the configurable materials.

 

Characteristic Code: The definition code of the material characteristic applied for the Material or the Material Class (With table).

 

Characteristic Description: The definition or description of the material characteristic applied for the Material or the Material Class (With table). When the Characteristic Code is entered, the Characteristic Description is automatically transferred into this field. The Material Characteristics list can be accessed from the Characteristic Description field and a new definition can be selected.

 

Line/Column: Indicates the table location where this characteristic will be used. It has three options as Column, Line and None. When None is selected, the characteristic is not used in the table.

 

Priority: Indicates the usage priority of the characteristic. The Priority is a numeric value. The characteristics are applied according to the priority defined here.

 

Characteristic Value: Indicates the value of the characteristic to be used in this field. The characteristics recorded in the definition are listed, and the appropriate option is selected.

 

Different characteristics of the same material are recorded in the Material Characteristics tab. The Characteristic definitions facilitate material tracking and makes the opening of cards in compliance with the characteristics specified in the Material Class (with Table) section.

 

Characteristic Sets

 

Material characteristic sets are defined so as to generate material variants by congregating different characteristics. Material characteristic sets are located in Main Records menu of material management module. Defined characteristic sets are selected in “Material Characteristic” page of the material card that the variant will be generated for, and the characteristics defined by the characteristic sets are automatically displayed in material characteristics page lines.

 

The characteristic set definitions are recorded using the Material Characteristics Set option of the Main Records menu. The Material Characteristic Set menu options are:

 


New 

Used to define a new characteristic set.


Update

Used to change the characteristic set definitions.


Delete

Used to delete the characteristic set definition.


View

Used to view the characteristic set information without making changes.


Copy

Used to create a new record by copying the information of the characteristic set definition.

 

Database Extensions

Additional info forms to be defined by the user.

 

Multiple Delete 

Used to delete more than one records simultaneously.


Record Info

Indicates the users who performed the entry and update transactions of the selected record and the time of these transactions.

 

Number of Records

Used to display the number of defined characteristic sets.

 

Refresh

Displays the list of the defined records with the latest information.

 

Back to Defaults

Used to display the active window with the standard dimensions defined in the application.

 

The following information is recorded in the Material Characteristic Set window accessed by clicking on “New” button located at the bottom of the Material Characteristics Sets list:

 


 

Header Info

 

Code: The definition code of the material characteristic set.

 

Description: The definition or description of the material characteristic set.

 

Aux. Code: The Auxiliary Code indicating the Company specific conditions of the material characteristic set.

 

Authorization Code: The authorization code of the material characteristic set.

 

The characteristic info recorded in the Characteristic Set part of the window.

 

Characteristic Code: The material characteristic code that will be located in characteristic set. The material characteristics are listed by clicking on “...” icon or by F10 and the appropriate material characteristic is selected which is in use. The number of lines in this part is not limited.

 

Characteristic Description: The definition or description of the material characteristic. The material characteristics are listed by clicking on “...” icon or by F10 and the appropriate material characteristic is selected by this field too.

 

Material Group Codes

 

The group codes to be used to group the Materials or Material Classes are recorded by clicking Material Group Codes option located in the Main Records menu of the Material Management section.

 

The products can be grouped according to their types and characteristics with independent grouping methods provided by the Group Codes. In this way, detailed reports about the transaction, sale and purchase total information of the materials can be generated. Sales targets can be specified by material group.

 

The fields and functions on the Material Group Codes window are:

 


 

Material Group Code: The Group Code to be applied for the material.

 

Definition: The name or description of the Material Group Code. The Material Group Codes are specified in the Group Code field located in the Material and Sales Targets records. The defined group codes are listed in the Group Code field and the appropriate option is selected.

 

Number of Records: The field that displays the total number of records.

 

 

Location Codes

 

The location information of the Materials or Material Classes is recorded by clicking on Location Codes option located in the Main Records menu of the Material Management section.

 

The Location Codes are separately recorded for each warehouse in the LOGO application.

 

To record the Location, first the appropriate warehouse is selected. Then the Location Codes of the Material or Material Class are recorded using “New” button located at the bottom of the Location Codes list.

 


 

Code: The code of the location of the material or material class in the selected warehouse.

 

Description: The description of the location of the material or material class in the selected warehouse.

 

The default value of the Location Tracking field is defined in the Material Management Parameters of the Definitions menu located in the Administration section. The selection made here is transferred as default to the materials and material classes.

 

The location of the goods belonging to the Materials or Material Classes in a warehouse is recorded using the Warehouse Parameters option of the right mouse button menu in the definition window of that Material. The defined locations are listed on the Default Location field of the Warehouse info window displayed, and the location within the warehouse is selected and specified.

 

Delivery Codes

 

The delivery types of the materials should be known in order to track the material transactions in detail. The delivery type may be different for each material. Certain additional transactions may be required depending on the delivery type since some inventory may be delivered with air, sea or land transport vehicles and the transport charges may be paid by the company.

 

The delivery types of the materials are tracked and reported on the Delivery Codes list accessed by clicking the Delivery Codes option of the Main Records menu located in the Material Management section.

 

Each definition is made in a separate line in the Delivery Codes list. The fields of the Definition window are:

 


 

Delivery Code: The definition code of the delivery.

 

Definition: The name or the description of the delivery type.

 

Number of Records: The field that displays the total number of records.

 

The delivery or receipt type of the material is specified in the Delivery Code column and the Material Receipts, Order Slips and Invoice lines. The defined Delivery Codes are listed and a selection is made.


 

Optional Materials

 

The Optional Materials section is used to define the optional materials that can be supplied with the materials during the purchase and sales transactions. The optional materials are accessory-like materials that are not mandatory to be delivered; they can be selected by the customers if requested. The optional material selection is made from among the recorded materials and the quantity to be delivered is entered in the line as additional information.

 

Once the options are defined for a material, the required options can be selected in transactions such as order and invoice and the optional material lines are automatically added to the material line. The optional materials are defined using the optional materials option located in the Main Records menu of the Material Management section.

 

The Optional Materials menu options are:

 


New

Used to generate a new optional material definition.


Update

Used to change the record information.


View

Used to view the optional material information without making changes.


Delete

Used to delete the record definition.


Copy

Used to create a new record by copying the definition information.

 

Database Extensions

Used for additional information forms.

 

Multiple Delete

Used to delete more than one records simultaneously.


Record Information

Indicates the users who performed the entry and update transactions of the selected record and the time of these transactions.

 

Find

Used to find the record by entering the code information.

 

Number of Records

Displays the number of recorded cards.

 

Refresh

Displays the list of the defined records with the latest information.

 

Back to Defaults

Displays the window dimensions with the size defined in the program.

 

 

The Optional material information is recorded in the Optional Material window accessed by clicking on “New” button located at the bottom of the Optional Materials list. The fields and functions of the window are:

 


 

Code: The code of the defined Optional material. Each Optional Material is tracked through a code. The code field is a 16-characters long key field. The optional materials are kept in order according to their codes. Alphanumeric characters can be used to generate the code.

 

Description: The name or description of the Optional material. The Optional Materials are also sorted by the first ten characters of the Description field. Therefore, it would be useful in terms of Reporting that the first ten characters of the Description field include distinctive information, as in the Optional Material Code.

 

Aux. Code: A second field in which a code can be entered to group the Optional materials. The string is 10 characters long. Alphanumeric characters can be used to generate the code. The code allows the user to group the Optional Materials by company specific criteria.

 

Authorization Code: Used to define detailed authorizations. The string is 10 characters long. Each user may be authorized to use different records depending on the job definitions. A planning process must be performed for detailed authorization definitions. First of all, the users or user groups that can access the optional materials, the Optional Materials they can access to and the transaction types they can perform must be specified. Then the slip types must be assigned with different Authorization Codes according to the defined authorization groups.

 

Type: Indicates the Record Type that the Optional Material defined in the record will be used in. There are two options:

 

  • Material
  • Material Class

 

In case that the Optional Material is opened from the Materials or Material Classes list, the information will be automatically displayed according to the record selected in the Type and Material (Class) fields.

 

Material (Class) Code / Description: These fields are used to enter the Material or Material Class Code and Description to which Optional Materials are applied, according to the selection made in the Type field. The point to be considered is that each Optional material will be applied only for one Material or Material Class. If the same process will be applied to more than one material, a separate Optional Material with a different code must be generated for each material.

 

Unit Price: The Unit Price of the Material or Material Class that uses the Optional material. The price specified here is transferred into the Unit Price field during the transaction. In this way, the user does not have to remember or type the price of the good to which Optional Materials will be applied.

 

The fields at the lower part of the record are used to record the information about the material(s) defined as Optional material.

 

Start / End Date: Indicates the time range in which the Optional material will be used in transactions. The most important characteristic of the Optional Materials is that they will be applied for a certain period. The dates recorded in the Optional Material fields indicate the time range in which the Optional Material will be applied. In the Optional Material lines of the slips and invoices, the Slip Date and the dates on the Optional Material record are compared. The Optional Material Definitions list accessed through the lines of the slips and invoices lists the records that match the Date of transaction and the Stare and End Dates specified for the Optional material.

 

Usage Point: Indicates the application section(s) in which the Optional material defined in the record will be used. There are two options: Purchase Receipts and Sales and Distribution Receipts. The receipt types in which the Optional Material will be used are checked.

 

In the LOGO application, the Usage Point default is defined using the Usage Point filter located in the Material Management Parameters. The selection made here is transferred into the cards.

 

The Usage Point information can be changed on the Material Record. The selection made in the Usage Point fields of the materials used in Material Management, Purchase and Sales and Distribution slips and invoices can not be changed. When attempted to be changed, the application warns the user and blocks the check removal operation.

 

Material Code / Description: The code and description of the defined Optional material.

 

Variant Code / Description: The code and description of the material variant in case the optional material is configurable.

 

Formula: Indicates the calculation method of the Optional material. This field is used to specify the calculation method with logical and arithmetical operations, using arithmetical operations and functions. In this way, the transactions are automatically performed, minimizing the error rate.

 

Logical operations are applied on the Formula field of the Optional Material, and the Optional material is specified to be applied or not according to the resulting criteria. The aim of using functions along with the parameters is to generate and apply detailed Optional material calculation methods.

 

Round To: Indicates the rounding base if the calculation results in decimal values.

 

Unit: The unit of the Optional Material entered in the line. This value is automatically inserted when the Optional material is selected.

 

Unit Price: The Unit Price of the Optional material. The invoice and receipt Slip Date and the Start and End Date specified in the Optional Material are checked by the application. When Optional materials are applied to the material selected in the line using “Apply Optional Materials” option, the Sales Slip or Invoice Date and the Optional material Start and End Dates are processed and only Optional Material definitions that match this date range are listed.

 

The parameters used in the Formula field:

 

Parameter

Description

P1

Quantity (Main Unit)

P2

Unit Price (Main Unit)

P3

Quantity (Line Unit)

P4

Unit Price (Unit in Line)

P5

Total

P20

Quantity Total (Line Unit)

P21

Quantity Total (Main Unit)

P22

Surcharges

P24

Gross Total

P25

Total Line Discount

 

The arithmetical and logical functions used in the Formula field:                 

 

Numerical Functions


Name

Description

MIN ( , )

Returns the parameter with the lower value.

MAX ( , )

Returns the parameter with the higher value.

DIV ( , )

Indicates the integer part of the division result.

MOD ( , )

Shows the remainder of the division.

ABS ( )

Shows the absolute value of the number.


Logical Functions (Conditions)


Name

Description

AND

AND (If all the conditions are true)

OR

OR (If at least one of the conditions is true)

Greater than

Smaller than

>=

If greater or equal

<=

If smaller or equal

=

If equal

<> 

If not equal

 

 

Optional Material Usage

 

Information about optional materials given along with the materials on purchase slips and invoices are recorded using either of the following methods:

 

  • Optional material application
  • By selecting Optional material as the line type

 

Apply Optional Materials

 

If the materials complementing the child materials of the Materials and Material Classes are specified by defining Optional Materials, “Apply Optional Materials” option of the right mouse button menu is used. Optional materials for the purchased material or material class are listed, and a selection is made.

 

If a condition is specified in the Formula field of the Optional Material, the Quantity and Unit Price information is displayed under the relevant columns in accordance with the definition.

 

Optional Material Lines

 

In Optional material slip lines, the line type is selected and recorded as Optional material. Or defined optional materials are used for optional material line entry.

 

Optional material cards may not be defined for the materials to be provided with the goods sold. In this case, the information about the material is recorded by selecting Optional Material as the line type under the related material line. The materials are listed and the appropriate record is selected.

 

Additional Taxes

 

The Additional Tax is a proportional consumption tax collected from certain goods and products. The tax payers are the importers and first vendors.


Unlike VAT, the Add. Tax is not applied every time the same product is sold. The Add. Tax is applied only when the product is imported or the produced goods are delivered to their first buyer. For motor vehicles, the Additional Tax is applied to the end user during the first registry.


The Add. Tax entered in force in August 1, 2002. The tax declaration and payment periods are monthly periods. The goods in list nr. 1 (oil products) are declared and paid on the 10th of each month and all other products on 15th. The tax is declared and paid before the registry in the first purchase of transport vehicles. The Add. Tax is paid within the Sales Prices in the first stage; in later sales, it is included in the VAT calculations as a cost item.

 

The products to which Additional Tax will be applied are classified in 4 groups. These groups are:

 

  • Fuel oil, natural gas, lubricants and solvent derivatives,
  • Automobile, motorcycle, plan, helicopter, yacht and cutters,
  • Alcohol drinks, cigarette and tobacco products and soda,
  • The products included in the luxury class of the VAT

 

The Additional Tax is included in the VAT tax base according to the VAT law. Therefore, the consumer also has to pay the VAT for the Additional Tax they paid.

 

In the LOGO application, the Additional Tax information is recorded using Additional Taxes option located in the Main Records menu of the Material Management section. The buttons of the Additional Taxes list or the options of the right mouse button menu are used to define Additional Tax or to modify the existing definitions. These options and their functions are:

 


New

Used to generate a new additional tax definition.


Update

Used to change additional tax information.


Delete

Used to delete the additional tax definition.


View

Used to view the additional tax information without making changes.


Copy

Used to create a new record by copying the additional tax definition information.

 

Database Extensions

Used for additional information forms.

 

Multiple Delete

Used to delete more than one record simultaneously.


Record Information

Indicates the users who performed the entry and update transactions of the selected record and the time of these transactions.

 

Number of Records

Displays the number of recorded cards.

 

Refresh

Displays the list of the additional taxes with the latest information.

 

Back to Defaults

Displays the additional taxes window with the dimensions recorded in the system.

 

The Additional Tax information is recorded on the Additional Tax window accessed by clicking on “New” button located at the bottom of the Additional Taxes list. The fields and functions of the window are:

 

Additional Tax Code: The code of the defined Add. Tax.

 


 

Additional Tax Description: The name or the description of the defined tax.

 

Additional Tax Group Code: The Group Code of the defined tax.

 

Affects VAT Base: This box is checked in case that the additional tax affects the VAT base. Then VAT amount is calculated over the material amount + additional tax amount totals.

 

If this box is not checked, VAT amount is calculated by material amount.

 

Included in Amount: This option is used for calculations of the additional taxes which will be included to amounts. In additional tax definitions, this field is marked if unit price will be calculated containing the VAT for VAT included amounts.

 

If the amount will be calculated in this way, you must select “Rate” option in “Rate/Amount” field of Additional Tax definition lines and “Exception Rate” option at Trading Group definitions. The selections except “Rate” and “Exception Rate” are not considered in calculations.

 

When “Included in Amount” field is marked, the additional tax amount is calculated over amount. Slip net total is always the same with line amount. Additional tax definitions included to amount are applied to purchase orders, receipts, purchase invoices, sales orders, dispatches and sales invoices which the VAT included amount can be entered to.

 

The lines of the tax definition are used to record the properties of the taxes within this group. Such as:

 

Start Date: The date on which the tax became effective. The amounts and rates specified in the definition are applied according to the date specified in this field.

 

Rate/Amount: The field used to define the tax type. This field includes the following options:

 

  • Rate
  • Amount
  • Rate + Amount

 

The Additional Tax may be applied as an amount to certain materials or calculated on a fixed rate for some others. When Rate + Amount is selected, both the amount and rate are applied.

The amount or rate to be applied are specified in the Rate or Amount lines according to the selection made in this field.

 

Rate to be Collected / Amount to be Collected: Indicates the rate/amount that will be used in additional tax calculation when additional tax exception is applied.

 

Exception Rate: The additional tax exception rate. Determines the collection rate and tax assessment.

 

Exception Amount: The additional tax exception amount.

 

Unit Type: Indicates the unit type for which the specified rate and/or amount will be applied. The unit types are listed and the appropriate unit is selected.

 

Unit Set Code: The Unit Set Code to be applied to tax definitions of which the tax type is Amount and the unit type is Quantity. The Unit Sets are listed by clicking on “...” icon and the appropriate Unit Set is selected.

 

In the LOGO application, the Unit Set Code is not specified for lines of which the tax type is Rate.

 

Unit Code: The field used to specify the unit to which the tax will be applied in lines with Quantity or Size Unit Type. The units are listed by clicking on “...” icon and the appropriate unit is selected.

 

Discount Amount: The discount amount for the additional tax.

 

Each tax to be applied is recorded on a different line in the Additional Tax definition. The tax type and characteristics are recorded by clicking on “Save” button. The definition is listed with the Tax Code, Tax Description and Tax Group Code information in the Additional Taxes list.

 

The Add. Tax Code field of the material is used to specify whether or not the Additional Tax will be applied for a material. The defined Additional Taxes are listed in the Additional Tax Code field and the record that will be applied to the material is selected.

 

The Additional Tax can also be applied by Trading Group. To do so, the Trading Groups menu option located in the Company Info menu of the System Administration section is used.

 

The Additional Tax calculations to be done for Material Purchase, Sales, Return, Usage and Scrap transactions vary depending on the applied regulations.

 

In the material Input/Output slips and invoices, the totals of the Material Transactions eligible for Additional Tax application are located in the Additional Tax Amount column of the slip or invoice lines, and the totals of the Slip Bottoms are located in the Total Additional Tax field at the bottom of the slip.

 

When the information of the material transactions subject to Additional Tax application is recorded, the Additional Tax Amounts are calculated by processing the Add. Tax Code specified in the Material Record or the default specified in the Trading Group of the AR/AP of the transaction.

 

If Additional Tax will be applied to the purchased material in purchase transactions, the Add. Tax equal to the amount calculated using the Rate of the Add. Tax definition specified in the Material Record or the Amount is transferred into the Additional Tax Amount column of the slip line.

The calculated Additional Tax Amount and Total Slip Amount are processed as VAT base and the VAT Amount is calculated accordingly. When the purchase transaction is posted to G/L, the Additional Tax is not tracked on a different G/L Account. The calculated amount is automatically reflected on the cost of material.

 

The Additional Tax application is different if the purchased material is used in production or within the company. Therefore, the Usage and Scrap slips issued in the Material Management section contain “Calculate Add. Tax Amount” option. If the purchased material will be used in production, “Calculate Add. Tax Amount” option of the Usage and Scrap slips must be checked.

 

If the returned material in the purchase return transactions is subject to Add. Tax, the Additional Tax amount of the returned material is displayed on the Additional Tax Amount column of the related line.

 

If the sales dispatches and invoices indicate that the Additional Tax will be applied in the Material Record for the material in line, the Add. Tax is calculated by processing the Start Date and Transaction Date specified in the Add. Tax record. The calculated Additional Tax Amount is displayed on the Additional Tax Amount column of the line, and the slip bottom amount is displayed on the Total Add. Tax field located in the lower pane.

 

The VAT is calculated based on the Total Amount and Additional Tax Amount total and using the current VAT rate.

When the sales transaction is posted to G/L, the Additional Tax Amount is recorded under the relevant G/L account as Sales Add. Tax.

 

Additional Tax Calculation Over Amount without Discount

 

When “Apply Special Assessment” option located in Material Card is checked, additional tax amount calculated over the relevant material card will be calculated based on amount without discount even if trading group is not selected in invoice or “VAT Will Be Counted Before Discount” option is not checked for the selected trading group.

 

 

Brand Definitions

 

The option used to record the brands of the materials to be used in the Internet virtual shop. The option is located in the Main Records menu of the Material Management section. The buttons at the lower part of the Brand Definitions window and the options of the right mouse button menu are used for brand definition transactions. These options and their functions are:

 


New

Used to generate a new Brand Definition.


Update

Used to change brand definition information.


Delete

Used to delete the brand definition.


View

Used to view the brand definition information without making changes.


Copy

Used to create a new record by copying the brand definition information.

 

Multiple Delete

Used to delete the selected records in batch.


Record Information

Indicates the users who performed the entry and update transactions of the selected record and the time of these transactions.

 

Number of Records

Displays the number of recorded brands.

 

Refresh

Displays the list of the Brand Definitions with the latest information.

 

Back to Defaults

Displays the Brand Definitions window with the dimensions recorded in the system.

 

The Brand Information to be used in e-commerce applications is recorded using the Brand Definition window accessed by clicking on “New” button located at the bottom of the Brand Definitions list. The fields and functions of the window are:

 


 

Code: The brand code.

 

Description: The name or the description of the brand.

 

Aux. Code: The aux. code of the brand. The code allows the user to group the brands by company specific criteria. The Aux. Code field is used for reporting purposes.

 

Authorization Code: The authorization code of the brand. Each user may be authorized to access different records depending on the job definitions. This field is used to define detailed authorizations.

 

The brand definition is recorded by clicking on “Save” button. The brand definitions are accessed through the Brand Code field of the Material records. The brand definition to be used for this material in e-commerce applications is selected from the list.

 

The brands can also be assigned in batches. To do so, Material Brand Update option located in the Operations menu of the Material Management section is used. The brand to be assigned and the materials it will be assigned to are specified on the filter lines.

 

Product Catalogue

 

Product category definitions are used for grouping the materials according to their characteristics. The option is located in the Main Records menu of the Material Management section. The buttons at the lower part of the Product Categories list and the options of the F9/right mouse button menu are used for product category transactions. These options and their functions are:

 


New

Used to generate a new product category.


Update

Used to change product category information.


Delete

Used to delete the category definition.


View

Used to view the product category information without making changes.


Copy

Used to create a new record by copying the product category information.

 

Multiple Delete

Used to delete the selected records in batch.


Record Information

Indicates the users who performed the entry and update transactions of the selected record and the time of these transactions.

 

Number of Records

Displays the number of recorded categories.

 

Refresh

Displays the list of the product category with the latest information.

 

Back to Defaults

Displays the product category window with the dimensions recorded in the system.

 

 

Category Info

 

In order to define product category and determine materials located under this category, “New” option located at the bottom of the product category is used.

 

The fields located in the upper part of the page are used to enter the category recording info and lines are used for recording the material info belonging to the defined category.

 

CodeThe code of the product category. The code field is a 24-character long key field. The product categories are kept in order according to their codes. Alphanumeric characters can be used to generate the code.

 

Description: The name or description of the product category. The product categories are also sorted by the first ten characters of the description field. Therefore, it would be useful in terms of Reporting that the first ten characters of the Description field include distinctive information, as in the product category code.

 

Aux. Code: A second field in which a code can be entered to group the product categories. The string is 10 characters long. Alphanumeric characters can be used to generate the code. The code allows the user to group the product categories by company specific criteria. 

 

Authorization Code: Used to define detailed authorizations. The string is 10 characters long. Each user may be authorized to use different records depending on the job definitions. A planning process must be performed for detailed authorization definitions. First of all, the users or user groups that can access the product categories, the product categories they can access to and the transaction types they can perform must be specified.

 

Will be Used on Web: This option is checked when the product category definition will be used in the transactions on the web.

 

Material Info  

 

The materials belonging to the defined category are determined in the lines of the product category window.

Materials can be selected either one by one or transferred to the lines by “Transfer batch materials” option.

 

Material Code: The material code belonging to the defined category.

 

Material Description: The material description belonging to the defined category.

 


 

Transfer Batch Materials

 

The option is located in right mouse button menu of Product Categories window. It is used to select materials in batch that will take place under product category. Materials are specified using relevant filter lines:

 

Filter

Value

Material Type

Commercial Good / Deposit Item / Fixed Asset / Raw Material / Semi Finished Good / Finished Good / Consumer Good

Material Status

Active / Passive

Material Code

Group / Range

Material Description

Group / Range

Material Aux. Code

Group / Range

Material Auth. Code

Group / Range

Material Group Code

Group / Range

Material Vendor Code

Group / Range


 

Configuration Management

 

Especially in sectors producing by orders (textile, furniture, computer etc.), combination of various characteristics and values pertaining to a material is in question and these combinations are exclusive for customers making the orders and it is usually a production of one time. It is possible to create multiple variations of a material with different values of different characteristics with LOGO application. Variations of ordered and purchased materials are described as variants connected to the material without opening a different material card in the system. By this means material tracking becomes easy and all relevant processes (proposal, production etc) are automated with condition descriptions. Description of material variations, their control and management are named as configuration management.  Thanks to configuration management, number of records such as material and bill of materials will be entered to the system decreases. Ease of use is provided by means of using material characteristics in material entries.

 

Material Variants

 

It may be necessary to make more than one description of combination of a material by combining various characteristics and characteristic values of a material in material purchases and sales transactions. For this, different characteristics and characteristic values of a material are described and material variants are generated by combining these values.

 

Variations generated are recorded with different code and description information connected to a single material record. In order to make a variation description in a material record, “configurable” field which shows that the material is configurable, located in material card general information page is selected and material card is described in the field of “Characteristic Set” or by means of entering characteristics one by one on the page of material characteristics of material card.

 

Material characteristics are entered for a material card selected as configurable; however characteristic values are not selected. Characteristic values create variants of the material. You can access Material Variants by using Variants option located in F9/right mouse button menu in Materials list.  

 

In order to describe the variants of a material and record them as to be connected to the material, Variants option located in F9/right mouse button menu above the relevant record in materials list is used. Material Variant list opened is the list where variants of variable materials are generated and tracked.

In order to describe a material variant or for modifications and transactions will be performed on present descriptions, options located in F9/right mouse key menu on the subsection of the window in material variants list are used. Menu options are:

 


New

Used to create a new material variant.


Update

Used to modify record information.


Delete

Used to delete material variant.


Copy

Used to create a new record by copying the information of the selected variant information.

 

Multiple Delete

Used to delete the selected records in batches.

 

Database Extensions

Used for displaying additional information forms for material variants with Logo Objects Designer.

 

Automatic Variant Assignment 

Used to create various combinations of material variants specified with specific characteristic automatically. 

 

Inspection Criteria Assignment 

Used to determine inspection criteria of material variant. Inspection criteria values assigned to the materials are displayed as default and updated on request.

 

Variant Transactions

Used to access material variant transactions according to the filter conditions specified.

 

Order Transactions

Used to access material variant order transactions according to the filter conditions specified in the material variants list.

 

Demand Transactions 

Lists the material variant demands along with the demand slip information.

 

Planned Transactions Tracking

The planned transactions tracking is used to list all planned
transactions of material variant and their affect on the inventory from the report dates.

 

Claimant Stocks

Used to record the shipping transactions of unsent claimant stocks of the customer which are entrusted to the company and kept at warehouses temporarily.

 

Shipped Claimant Stocks

Used to list claimant stocks which have been already shipped.

 

Distribution Orders

Used to list the distribution orders from the material variant list and view the material transactions.

 

Purchase Prices

Used to specify the purchase prices of the selected record.

 

Sales Prices

Used to specify the sales prices of the selected record.

 

Warehouse Parameters

Used to record the warehouse parameters of the material variant. Parameters specified for the materials are displayed as default on variant and updated on request.

 

Plant Parameters

Used to record material variant plant parameters. Parameters specified for the materials are displayed as default on variant and updated on request.

 

Lot/Serial Numbers

The Lot/Serial Numbers of the material tracked are recorded using this option located in the menu above the material record tracked by giving lot or serial number.

 

Status

Used to track the general status information for all the material variant warehouses.

 

Purchases

Used to track the monthly totals of the material variant purchase transactions on local currency and reporting currency.

 

Sales

Used to track the monthly totals of the material variant sales transactions on local currency and reporting currency.

 

Status Graphic 

Used to display general status information of all material variant warehouses as graphics.

 

Warehouse Totals

If there are more than one warehouses, this option is used to display the information of all warehouses.

 

Purchase FC Totals

Used to display the purchase transactions of the material variant with transaction currency and reporting currency information.

 

Sales FC Totals

Used to display the sales transactions of the material variant with transaction currency and reporting currency information.

 

Search

Used to access the record of which the Code or Description is provided in the Material Variants list.


Filter

Used to access the materials according to the filter conditions specified in the material variants list.


Record Info

Indicates the users who performed the entry and update transactions of the selected record and the time of these transactions.

 

Number of Records

Lists the total numbers of the records in the list of materials variants and the numbers by card type.

 

Update

Used to update material variants list.

 

Back to Defaults

Used to display the active window with the standard dimensions defined in the application.

 

Print (Label)

Used to print the variant information in the label form.

 

Print (Letter)

Used to print the variant information in the letter form.


 

Material Variant Descriptions

 

Material variants screen consists of two sections. On the right section, there is variant adding section created along with characteristic set assignments assigned for the material that will be configured and on the left section there is record information.

 

In order to record material variant, “New” option located in Material Variants window is used. Code and description of the main material of which variants will be created are on the left top of the window.  Other information in material variants window are:

 


 

Material Code: The code of the material whose variant description will be made. It can not be updated.

 

Material Description: The description of the material whose variant description will be made. It can not be updated.

 

Variant Information

 

Code: The code of the variant. It is an alphanumeric field and the string is 24 characters long.   The code field is mandatory and the code given for a variant can not be used for any other variant.

 

Description: The name or the description of the variant.

 

Aux. Code: A second field to which codes can be entered and is used to group the material classes. It contains 10 characters and allows the user to group the materials by certain company specific criteria. The user can use auxiliary code in order to process date s/he wants to enter which does not exist on material variant card. 

 

Auth. Code: Used to define detailed authorizations. The string is 10 characters long. Each user may be authorized to use different records depending on the job definitions. A planning process must be performed for detailed authorization definitions. First of all, material variant groups should be specified which users or user groups can access and make transactions with. Later on, each material variant can be used by all authorization groups should be given a different authorization code. Encryption is performed on slip base according to authorization code. It is ensured that slip is accessed and processed only with the authorization code specified inhere and by those who login the program. 

 

Status: Indicates whether or not the material will be used in slips or invoices. This field has two options: Active and Passive. When Active option is selected, the material is in active state and can be used in slips and invoices. When Passive is selected, the material is in the passive state and therefore can not be used in slips and invoices.

 

Characteristics

 

Characteristics of material variant are recorded in this field. If there are any characteristic set or characteristics defined in material card, they are displayed directly and updated on request.

 

Code: The code of the characteristic. Defined material characteristic list is accessed and relevant description is selected in this field.

 

Description: The description of the material characteristic. Material characteristics list is accessed and relevant description is selected in this field.

 

Value: The value of the material. Value information of the characteristic is defined with material characteristic and/or characteristic sets located in Material Management Main Records menu. Values of material characteristics are accessed and requested value is selected in this field. By this means, variations of this material are created.

 

Value Description: It is material characteristic value’s description. Characteristic values are also listed from this field and appropriate one is selected.

 

Units

 

In variant description window, material dimension information, barcode information and conversion info of unit sets located under Units tab are recorded. Material Variant unit set and unit information are displayed as they are in material card and can not be updated. 

 

Each variant is given a different barcode number. While barcode number is used for slip and invoice transactions, material descriptions and barcode numbers in material variants are checked and material entry is done accordingly. Number of barcode information can be entered for material variant is limitless.

 

G/L Accounts

 

This is the option where account codes used to track variant transactions when they are posted to G/L accounts, can be accessed.

 

Prices

 

It is used to view variant prices and for tracking purposes. Variant prices are specified with “Variant Characteristic Determination” option located in F9/right mouse button menu of Price Cards. Variant Information – Information present in prices window are as below:

 

Record Type: Indicates price record type. (Purchase/Sales)

 

Code: Price record code.

 

AR/AP Code: Code of AR/AP will be valid in Purchase/Sales transactions.

 

Unit Price: Variant unit price.

 

Unit: Variant unit information.

 

VAT: Indicates whether VAT is included or excluded in unit price. 

 

F. Currency: The currency type of the price.

 

Start/end Dates: Indicated validity dates of the price.

 

Customers / Suppliers

 

This option is used to define customers and suppliers separately on variant basis. When users want to procure materials, orders are generated for defined supplier pursuant to the relevant variant of the material in case the relevant material is configurable.

 

Recorded material variant is listed with code, description, physical inventory and actual inventory in Material Variants window. 

 

Points to take into consideration in configurable materials

 

  • Configurable material characteristic of a material that had transaction as a variant can not be deleted.
  • Unit sets and units of variants can not be updated. Only fields apart from units in units tab can be updated. Validities of usage point, e-business environment and sales points are read from material card.
  • When a variant description of a material is made, configurable material characteristic of the material can not be deleted.
  • Configurable materials can not be deleted.
  • Materials such as Mix Case, Material Class, Fixed Asset can not be used as configurable material.
  • Materials with configurable characteristics can not be selected as Material Class child material. 
  • Tracking method, location tracking characteristics, additional tax card value of the variant are taken from relevant material.

 

When a configurable material is selected for slips, variant should be selected as well. A material whose “Configurable” field selected can not appear in slips as non-configurable.

Inspection criteria values assigned to the material are displayed as default in material variants, but they can be updated.

Variants take their unit sets from their relevant material. However dimension information, barcode information and conversion factor may differ on variant basis. Materials selected as package or tool can not be selected as configurable material. Warehouse and plant parameters differ on variant basis.

However values entered for a material are displayed as default in variants.

 

In the event of using more than one variant belonging to a material definition in sales / purchasing transactions, on the purpose of providing convenience for entries of variants’ quantity and price data, which have been generated according to materials’ various characteristics, Distribution Templates are defined.

 

Variant Distribution Templates

 

In the event of using more than one variant belonging to a material definition in sales / purchasing transactions, on the purpose of providing convenience for entries of variants’ quantity and price data, which have been generated according to materials’ various characteristics, Distribution Templates are defined. In variant distribution templates, the variant definitions belonging to material and their quantity info is specified in relevant lines.

Distribution templates are recorded with “Distribution Templates” option which is located at F9/right mouse button menu of configurable materials.

 

The buttons of the Distribution Templates list or the options of the right mouse button menu are used to define distribution templates or to modify the existing definitions. These options and their functions are:

 


New

Used to create a new distribution template record.


Update

Used to modify distribution template information.


Delete

Used to delete the distribution template definition.


View

Used to view the distribution template without making changes.


Copy

Used to create a new record by copying the information of the selected record.

 

Database Extensions

Used to record the additional fields to be defined by user.

 

Multiple Delete

Used to delete the selected distribution templates in batch.


Record Info

Indicates the users who performed the entry and update transactions of the selected record and the time of these transactions.

 

Number of Records

Lists the total numbers of the records in the distribution templates list.

 

Refresh

Used to refresh the distribution templates list.

 

Back to Defaults

Used to display the active window with the standard dimensions defined in the application.

 

 

Variant Distribution Template / Applying Variant Distribution Templates

 

In the event of using more than one variant belonging to a material definition in sales / purchasing transactions, on the purpose of providing convenience for entries of variants’ quantity and price data, which have been generated according to materials’ various characteristics, Distribution Templates are defined. In variant distribution templates, the variant definitions belonging to material and their quantity info is specified in relevant lines. When a configurable material is selected on sales / purchasing transactions’ lines (order, dispatch, invoice), if more than one material variant will be processed, “Apply Distribution Template” option is used which is located in F9/right Mouse button menu of slip lines. Predefined distribution templates are listed and related one is applied to slip. When distribution template is selected, material variants located at template lines and their specified quantities are transferred to slip lines as they are. These quantities can be changed from slip lines. When distribution template is applied, predefined prices for material variants are also transferred to lines; can be changed if necessary.

Distribution templates are recorded with “Distribution Templates” option located in F9/right mouse button menu of materials defined as configurable on materials list.

 


 

Variant distribution template information is recorded on Distribution Template window accessed by clicking “New” button located at the bottom of the Distribution Templates list. The fields and functions of the window are:

 

Code: The record code of the distribution template.

 

Description: The definition or description of the distribution template.

 

Unit: The unit of the distribution template is specified in this field. In case, configurable material in template uses more than one unit, this fields shows which unit will be used for sales/purchasing transactions when distribution template is applied to slip lines.

 

Aux. Code: A secondary code field used to classify template definitions.

 

Auth. Code: The authorization code of the template. It provides secured data entry.

 

Start Date / End Date: Indicates the time range in which the distribution template will be valid.

 

The lines of the Distribution Template window are used to record the information of the material variants defined for main configurable material:

 

Code: It is the variant record code defined for configurable material. Defined variants are listed an done of them is selected.

 

Description: The name or the description of material variant. This field can also be used for record selection.

 

Quantity: The quantity of material variant selected in line to be used in transactions. In slips and invoices, when this distribution template is selected for example, the variant quantity specified in this field will be transferred to slip lines. 

 

Transfer Batch Materials

 

Used to transfer the materials collectively to the product category window lines. The materials that will be located under the product category are determined by the filters. The filters display the records that match certain conditions. The filter options are:

 

Filter

Value

Material Type

Commercial Good / Deposit Item / Fixed Asset / Raw Material / Semi Finished Good / Finished Good / Consumer Good

Material Status

Active / Passive

Material Code

Group / Range

Material Description

Group / Range

Material Aux. Code

Group / Range

Material Auth. Code

Group / Range

Material Vendor Code

Group / Range

Material Group Code

Group / Range

 

 

 

Claimant Stocks

 

Materials’ shipping statuses are tracked through material and AR/AP records and the shipping transactions can be realized if necessary.

 

Whether the materials at invoice lines will be shipped or not is determined by using “Claimant Stock” option which is located at the heading info part of the slips/invoices.

 


 

Checking “Claimant Stock” option means that the materials in slip/invoice will not be shipped; they will be kept at safekeeping warehouse of the company.

 

Regardless of the determined dispatch shipping status from the sales/purchasing parameters, the status of the dispatch which belongs to the invoice that its “Claimant Stock” option is marked, will be “Not Shipped”.

 

When a dispatch in “Delivered” status is transferred to an invoice, whose “Claimant Stock” option is marked, the status of the dispatch is kept. When an invoice’s “Claimant Stock” option is removed, all the dispatches’ shipping statuses are changed.

 

The claimant materials that have not been sent and kept at firm’s warehouses can be tracked from both AR/AP and related material definitions and shipping transactions are done.

 

Sales invoices including claimant stock and carried over due to any reason apart from the company and period carry-over, can be recorded manually to the system. In order to do so, "Carrying Over" control box located in the relevant sales invoice must be checked. Invoice is recorded in "Proposal" status, therefore stock totals and AR/AP balance are not affected. It also cannot be changed, posted to G/L or returned. When shipment date arrives, the relevant quantity is shipped. If users require to list this invoice in invoices browser, "Show Invoices Received from Claimant Transfer" filter option must be selected as "Yes".


Tracking the Claimant Stocks and Shipping Transactions

 

The users can reach the claimant materials, which are kept at company warehouses in deposit, by using “Claimant Materials” option which is located at the F9 / right mouse button menu of the Material and AR/AP record lists.

 

Claimant Stock Transactions at Materials List

 

The dispatches receipts, belonging to the invoices which have been recorded after “Claimant Stock” option is checked, are listed for the selected material from materials browser. By using “Filters” option of Claimant Materials list, the shipping transactions are performed for a definite AR/AP or slip.

 


 

At Claimant Stock list, the sales dispatches are listed belonging to the related sales invoice of a material, which have been saved after “Claimant Stock” option is marked. And then the materials’ shipping transactions are performed one by one or collectively.

 

In the event of performing the shipping transaction collectively, the materials to be shipped at claimant stocks list are selected and “Deliver” button is clicked. The related dispatches are listed according to slip numbers. The quantity to be delivered is entered and a new dispatch is generated in “Delivered” status.

 

The materials’ discount and surcharge amounts are recalculated according to the delivered quantities.

 

When the dispatches’ statuses are changed into “Delivered” status by users which have been generated in “Not Shipped” status (belonging to the invoices containing claimant materials), the related material quantity is subtracted from the claimant stock, the quantities of the claimant stock list are updated.

 

Claimant Stock Transactions at AR/AP Lists

 

“Claimant Stocks” option can also be reached from the AR/AP records list’ F9 menu, in order to track and deliver the claimant stocks.

 


 

By using “Filters” option of Claimant Materials list, the shipping transactions are performed by filtering the transactions according to material or slip numbers.

 

At Claimant Stock list, the sales dispatches are listed belonging to the related sales invoice of a material, which have been saved after “Claimant Stock” option is marked. And then the materials’ shipping transactions are performed one by one or collectively.

 

When “Deliver” button is clicked for the related line, the related dispatch is opened only for that line and the quantity to be delivered is entered.

 

In the event of performing the shipping transaction collectively, the materials to be shipped at claimant stocks list are selected and “Deliver” button is clicked. The related dispatches are listed according to slip numbers. The quantity to be delivered is entered and a new dispatch is generated in “Delivered” status.

 

The materials’ discount and surcharge amounts are recalculated according to the delivered quantities.

 

When the dispatches’ statuses are changed into “Delivered” status by users which have been generated in “Not Shipped” status (belonging to the invoices containing claimant materials), the related material quantity is subtracted from the claimant stock, the quantities of the claimant stock list are updated.

 

Tracking the Claimant Stock Quantities from Materials List

 

The firm’s remaining claimant stock quantities at warehouses are tracked at “Claimant Stock Quantity” column of materials browser. The dispatches and invoices quantities in “Proposal” status are not included to that quantity.

Shipped Claimant Stocks

 

It is the option which is used to list shipped claimant stocks from material cards or AR/AP records browser. Located in F9/right mouse button menu of AR/AP cards and material cards lists. Shipped claimant stock are listed in this window with Shipment Date, Date, Slip Number, Slip Status, AR/AP Code/Title, Quantity and Unit info. Materials can be filtered with Filters option and so it is provided to list the materials matching with the specified conditions in filter lines. By using “Undo Shipment” option, a part of shipped materials or all of them can be taken back. When this option is clicked, the dispatch belonging to related material is displayed; after the amount to be taken back is entered in related slip line, the slip is saved. A new slip is generated for the returned mateial amount.

 


Transactions

 

 

Material Management Slips

 

In the LOGO application, the slips that are similar to the real-life receipts and invoices are used to record the material transactions. The Material Management Slips used in input and output transactions other than material purchases and sales are located in the Transactions menu of the Material Management section.

 

In the Material Management Slips section, the material transactions other than sales and purchases are recorded. The transactions are grouped by Slip Types to classify the Material Transactions functionally.

 

The Material management slips can only be saved on the Material Management section. Despite this restriction in slip entries, all material transactions including sales and purchases can be tracked, reported and their costs can be calculated from the Material Management section.

 

The buttons of the Material Slips list or the options of the right mouse button menu are used to save, view and update the Material management slips. These options and their functions are:

 


New

Used to create a new material slip.


Update

Used to modify material slip information.


Delete

Used to delete the material slips.


View

Used to view the material slip without making changes.

 

Cancel/Undo

This option is displayed in the menu if Business Automation System is inspected. Used to cancel or undo the slips posted to G/L accounts.


Copy

Used to create a new slip by copying the information of the selected slip.

 

Find

Used to find slips that match the required number or date in the Material Slips List. Once the process is started by entering the number or date, the cursor will point to the first record matching such number or date.


Record Information

Indicates the users who performed the entry and update transactions of the selected record and the time of these transactions.

 

Database Extensions

Used for additional information forms.

 

Number Of Records

Displays the number of recorded slips.

 

Multiple Delete

Used to delete the selected records in batch.

 

G/L Codes

Used to define the G/L Account Codes to be tracked once the transaction is posted and the overhead pools of the transactions.

 

Post to G/L

Used to post the material slips to G/L directly.

 

Post to G/L in Batch

Used to post the selected slips to G/L in batches.


Print

Used to print the material slips one by one on the printer or screen.

 

Batch Printing

Used to print the material slips in batches.

 

Print Barcode

Used to print barcode labels from material slips list.


Filter

Used to display the material slips list with the requested records.

 

Refresh

Used to display the material slips list with the latest information.

 

Back to Defaults

Used to display the active window with the standard dimensions defined in the application.

 

Slips Generated By Mixed Case Parting

This option applies for the warehouse slips including mixed case lines. It is used to display Usage and Input From Production slips generated automatically for the mixed cases and mixed case materials in slip lines when "Warehouse Slip" option is selected in the Transactions To Be Applied Mixed Case Parting While Saving The Slip parameter line located in Purchasing Parameters.

 

Remittance Connection

This option, located in right mouse button menu of usage and input from production slips (generated as a result of remittance operation), is used to display the slip that is connected to related usage or input from production slip. For example, when “Remittance Connection” option is used on usage slip (generated after remittance operation for transferred materials), related input from production slip (generated for materials to which the main material are transferred after remittance) is displayed.

 

Lock

Used for record based approval.

 

Multiple Lock

Used to approve selected records collectively.

 

Unlock

Used to cancel record based approval.

 

Multiple Unlock

Used to cancel record approvals collectively for the selected records.

 

Create Shortcut

Used to create shortcuts of the records.

 

Send Shortcut

Used to send the created shortcuts to related users.

 

Deleted Records

Used to list deleted records and rerecord if necessary in the event of using record revision history feature. The deleted records are listed with user and deleting time info.

 

Modification History

Used to list the updated records with user, record description and modification time info in the event of using record revision history feature.

 

 

Material Management Slip Types

 

The Material Transaction information is entered using the material slips. The Slip Type is used to classify the transactions. In Material Management, the material transactions are recorded by selecting one of the slip types showed in the table below. The slip types are:

 

Scrap Slip

Used to record the scraps occurred during production or due to any other reason.

Usage Slip

Used to record the materials used during production or due to any other reason.

Input from Production Slip

Used to record the input to warehouse transactions of the produced materials.

Opening Slip

The Slip Type used to carry over the inventory amount and quantity at the fiscal year end

to the new period. This information can be entered by the user or automatically created during the year end carry over transactions.

WH Transfer Slip

Used to record the Material Transactions between warehouses.

User

Defined Slips

The Slip Type used to record the company specific Material Transactions. In the LOGO application 5 input and 5 output slips can be defined by the user.

Cycle Count Excess Slip

Used to record the cycle count excess material.

Cycle Count Deficit Slip

Used to record the cycle count deficit material.

 

 

Material Slip Structure

 

The material slip information is recorded in the Slip and Details tabs.

 

The general information and line information of the slips are recorded on the Slip tab. The information recorded can be categorized in three groups:

 

  • Slip Heading
  • Slip Lines
  • Slip Totals

 

The Slip Header is located in the uppermost section of the Slip tab. This section is used to record the common Material Transaction information that will be entered in the slip, such as Slip Nr, Slip Date and Document Nr.

 

The Slip Lines are located in the middle section of the Slip tab. This section is used to record the Material Code, Quantity and Unit Price information of the processed Materials. The number of lines in this section is not limited to what is displayed on the screen. In other words, as many material lines as required can be recorded on the material slip in the LOGO application.

 

The Slip Totals are located in the lower section of the Slip tab. The Total Amount information of the recorded material lines and the currency type to be used in the slip are displayed in this section. The Total field of this section can not be altered by the user since the amount is automatically calculated by the application every time the material lines are changed.

 

Slip Header

 

The following information is recorded in the Slip Header section:

 

Slip No: The tracking number of the slip. Alphanumeric characters can be used to enter the number. The slips are sorted by their numbers. Each slip type used in the material management section uses a different sequence number. The slip number field is mandatory.

           

Slip Date: The date of the transaction. The Slip Date field is mandatory.

 

Hour: Indicates the hour that the slip is recorded.

 

Document No: The number of the transaction document. This is an 8-character, alphanumeric field. The slips used to record the transactions of the same material can have the same document number.

 

Slip Status: This field is used to specify the Slip Status if the Production section of the LOGO application is used. This field contains two options: Actual and Planned. If the Production section is not used, the Actual option is displayed and the content cannot be changed.

 


 

Group Company Transaction: Used to indicate whether the transaction in the line is a group company transaction or not, in case of using the consolidation feature.

 

Aux. Code: A second field to which codes can be entered and is used to group the slips. Contains 10 characters. The Aux. Code allows the user to group the slips according to certain company specific criteria and to generate reports. The user can use this field to record any necessary information that is not included in the slip.

 

Authorization Code: Used to define detailed authorizations. The string is 10 characters long. Each user may be authorized to use different records depending on the job definitions. A planning process must be performed for detailed authorization definitions. First of all, the users or user groups that can access the Material management slips; the Material management slips they can access to; and the transaction types they can perform must be specified. Then the slip types must be assigned with different Authorization Codes according to the defined authorization groups.

 

Project Code: The project code of the slip. Defined projects are listed, and the appropriate definition is selected.

 

Production Order No: If the Production section is used, the slips generated in this section are also used. This field indicates the number of the relevant production order.

 

Work Order: If the Production section is used, the connection with the Material Management section is established using this field.

 

Workstation: This field is used to record the Workstation information if the Production section is used.

 

Division: In the LOGO application, each unit that is connected to the headquarters of a company or organization and that manages its own commercial transactions independently is considered as a Division. This field is used to associate the material transactions with one of the defined Divisions of the company.

 

Department: In the LOGO application, each organizationally independent activity or activity group is considered as a Department. This field is used to associate the material transactions with one of the defined Departments of the company.

 

Plant: This field is used to record the Plant information if the Production section is used.

 

Warehouse: Indicates the warehouse of the transaction. If the transaction of the materials included in the slip line will be performed in a different warehouse than the one selected in the Slip Heading, such situation is specified in the Warehouse column of the line. In other words, the Warehouse field can be filled in for the whole slip or separately for transactions in each line. In this way, the transactions of the same AR/AP with different warehouses can be recorded on a single slip. To do so, Yes option must be checked Changing Slip Lines Warehouse Info of the Material Management Parameters. By doing so, the warehouse information of the material in the line can be recorded on the Warehouse field.

 

Calculate Add. Tax Amount: This field is available only on Usage and Scrap Slips. The Add. Tax application varies depending on the fact that the material is used within the company or for production purposes. If Add. Tax Amount has to be calculated for the material used, “Calculate Add. Tax Amount” box must be checked.

 

Slip Lines

 

The transactions of different material items can be recorded on the same slip. The information such as Material Code, Quantity, Unit and Unit Price that has to be recorded for each material is entered to the line reserved for that material. In other words, a line is added to the slip for each material transaction. The line where the material transaction information is saved is called Material Line or Material Transaction. As many Material Lines as required can be added to the material slips. The following information is recorded in the Slip Lines section:

 

Type: Indicates the line type. The following line types can be used in material slips:

 

  • Material
  • Fixed Asset
  • Material Class

 

The Type cannot be selected in Opening Slips.

 

Code: The code of the material processed in the line. The Code of the material to be used is selected from the Material List accessed by clicking on “...” icon.

 

The LOGO application supports the use of barcodes in material input and output transactions. If barcode is used, the Material Code is not necessary. The Material input is performed using the barcode reader.

 

Description: When the Code field is filled in, the description of the relevant material is automatically displayed on this field.

 

Variant Code / Description: The code or description of the material variant in case the processed material in line is configurable. The defined material variants are listed by clicking on “... icon on both fields, and a selection is made.

 

Quantity: This column is used to indicate the number of unit inputs and outputs from the relevant material item. If the barcode reader is used, the Quantity column of the material is automatically updated when the material barcode is read.

 

Unit: This field is used to specify the unit used for the input or output transaction. The Material and Material Class transactions are recorded by selecting one of the units listed in the Unit Set specified in the Material or Material Class record. The Main Unit specified in the Unit Set is transferred to the slip as default. A separate barcode can be defined for each Unit in the Materials. In this case, the unit selection is made by the application according to the number received by the barcode reader.

 

Unit Price: The unit price of the material. The Defined Purchase or Sales Price, Average Price, Last Purchase or Sales Price, Last Purchase/Sales Proposal Price, Average of On Hand, Average of inputs, Periodic Average, LIFO, FIFO and Physical Cost options are listed for the inventories by clicking on “...” icon and the Unit Price value to be used is selected.

 

Unit Price in F.C: The unit price in F.C information of the transaction.

 

F. Currency Type: The currency type to be applied to the transaction.

 

Amount: The amount of the transaction. The value is calculated by multiplying the Quantity and Unit Price, and automatically inserted in this field by the application.

 

Amount in F. Currency: The amount in F. Currency of the transaction. The value is calculated by multiplying the Quantity and Unit Price in F. Currency, and automatically inserted in this field by the application.

 

Inspection Result: The field used to record the inspection result information.

 

Transaction Aux. Code 1/2: Used to group the slip lines, filter a group of information during report generation and to display the totals of the grouped information. The user can use this field to record any necessary information that is not included in the slip.

 

Attention: The Transaction Aux. Code is different from the Aux. Code on the upper side of the slip. The Aux. Code field displays the aux. code of the whole slip, while the Transaction Aux. Code field of the line is used to group the transactions.

 

In the LOGO application, filtering can be done by Transaction Aux. Code information in all slip reports. However, the slips can not be sorted by Transaction Aux. Code.

 

F. Asset Record: When Fixed asset is selected on the Type field, the Fixed Asset Record Code is displayed on this field of the slip line.

 

Additional Tax Amount: In Usage and Scrap Slips, this field displays the Additional Tax amount of the material selected in the line.

 

Description: The description of the transaction.

 

Project Code: The project code of the transaction of the slip line. Defined projects are listed, and the appropriate definition is selected.

 

Warehouse: This information can be entered separately for the transaction in the slip or line. In this way, the transactions of the same AR/AP with different warehouses can be recorded on a single slip. To do so, Yes option must be checked on Changing Slip Lines Warehouse Info of the Material Management Parameters. By doing so, the warehouse information of the material in the line can be recorded on the Warehouse field.

 


 

Slip Total Info

 

The following information is recorded in the Slip Total Info section:

 

The currency type to be used in the whole slip and slip lines is specified in the Currency Type field located in the Slip Totals section of the material slip. One of Reporting Currency or Euro, and Local Currency, Reporting Currency or Euro options is selected for the whole slip and slip lines respectively.

 

When Reporting Currency or Euro is selected for the slip lines, the Unit Price and Amount of the processed material are recorded in the Unit Price in F.C. and Amount in F.C. fields.

 

The Total Additional Tax and Total of the slip are calculated by the application in the Local Currency and the Currency Type specified for the whole slip and transferred into the relevant fields.

 

Details

 

The Description, Document Tracking Number and the Input from Production Tracking Number the slip are recorded in the Details tab of the material slip.

 

The Quick Production Slip Number field is available only in Usage, Scrap and Input from Production slips. For slips with Quick Production connection, the number of the Quick Production Slip is automatically inserted in this field.

 


 

Material Management Slip Right Mouse Button Menu

 

In addition to the fields displayed on the screen, the windows accessed through the options of the right mouse button menu can be used to record information on the Material Line. The functions of these options are:

 

Dimension Totals: The option used to track the dimension totals of the material in slip line.

 

General Ledger Codes: Used to enter and apply the G/L account codes using the slip. Displays the Journal Slip generated by Posting to G/L Accounts.

 

Barcode Entry: Used to record the material transactions using the barcode reader.

 

Unit Conversion: Located in the right mouse button menu of the Usage, Scrap and Input from Production slips. The dynamic unit conversion allows the materials for which the units do not have fixed connections to be accurately converted. By doing so, the sales and inventory reports are generated using the requested unit and with accurate numbers. The unit conversion rate specified in the material may not be applied to certain material lines. In this case, after specifying the unit in the material line of the slips and invoices, the conversion factor to be applied only to that transaction is entered using Unit conversion option.

 

F. Currency Info Entry: Used to record the Reporting Currency information for the selected transaction.

 

Batch Selection of Variants: In slips and invoices, in case processed material is a configurable item, it is used to transfer material variants to slip lines in batch after selecting them according to their characteristics and after determining their quantity and unit prices.

 

Apply Alternative Material: Used to apply the material alternative to the transaction.

 

Vendor Code Entry: Used to save the material with the Vendor Code according to the transaction in the slip line.

 

Customer/Supplier Code Entry: Used to record the material transactions with Customer/Supplier Code.

 

Material Status: Used to display the latest status information of the material.

 

Warehouse Totals: Used to view the material status by warehouse.

 

Material Level: Indicates the impact of the transaction entered to the line on the material status.

 

Cost Factors: If the Production Control section is used, the cost factors to be used in the calculation of realized production order costs are recorded using this option. This option is available only in the right mouse button menu of the Inputs from Production Slip.

 

Detailed Info: Used to record the detailed description of the transaction line.

 

Costs: This option is located in the right mouse button menu of the usage and scrap slips. The cost and profit rate of each line in the slip is tracked according to the selected costing method.

 

Find: Used to search the requested material in the slip lines.

 

Number of Lines: Displays the total number of lines in the slip.

 

Back to Defaults: Displays the material management slip with the dimensions recorded in the system.

 

Associate with Fixed Asset Records: Used to associate the transaction with the fixed asset.

 

Material Class Detail Lines: Used to record the line distribution details in transactions of material class type.

 

Apply Distribution Template: Used to record the material class details by applying distribution templates to the lines of the general material class.

 

 

General Ledger Codes

 

The General Ledger Codes to be applied to the transaction are recorded using the General Ledger Codes option of the right mouse button menu, and the journal slip lines to be generated when the transactions are posted to G/L accounts are tracked.

 


 

The lines of the journal slip generated when the transaction is posted are displayed on the General Ledger Codes window as a table.

 

The General Ledger Code, G/L Account Description and Overhead Pool fields are for data entry. Indicates the G/L Accounts that the transaction will be posted to and the transaction’s Overhead Pool. The other fields of the table display the Debit and Credit amounts reflected to the G/L accounts of the slip.

 

The general ledger codes can be applied to the whole slip or to the slip lines if the slip includes more than one material transaction. To do so, the following options located in the right mouse button menu of the General Ledger Codes window are used:

 

  • Apply G/L Codes (General)
  • Apply G/L Codes (Line)

 

Apply G/L Codes (General): Apply G/L Codes (General) option includes Empty Codes Only and All Codes options. When All Codes is selected, all the codes specified in the G/L Connection Codes are applied to the transaction; when Empty Codes Only option is selected instead, the application is done for empty connections.

 

When the General Ledger Codes are applied, the Journal Slip to be generated when the transactions are posted is displayed on the screen as a table.

 

If a transaction in any line of the slip will be tracked under a different G/L account, the code can be changed. In this case, only the transaction entered with this slip will be posted to the G/L account under the general ledger code specified here.

 

Apply G/L Codes (Line): The General Ledger Codes can be applied to the whole slip or to requested lines of the slip. “Apply General Ledger Codes (Line)” option of the right mouse button menu is used to apply the General Ledger Codes to the line. In this case, the General Ledger Codes are applied only to the transaction of the selected line and the Journal Slip to be generated when the transactions are posted is displayed on the screen.

 

The General Ledger Codes are recorded using the G/L Connection Codes located under the Main Records menu of the General Ledger section. During the G/L connection codes definitions, it is also specified that whether or not the G/L Account and Overhead Pool Codes defaults will be displayed in the General Ledger Codes window.

 

 

Dimension Totals

 

The option used to track the dimension totals. The dimension information for the Material or Material Class in the line is recorded using the Unit Sets option. The values specified here are transferred into the Material and Material Classes using the Units option. As many units as required can be defined in the Unit Set for the material, and the corresponding dimension information is separately recorded for each unit.

 

In the Material Slips, all material dimension information is tracked according to the unit processed in the line, using the Dimension totals option. The Width, Length, Height, Area, Volume and Weight information specified in the unit definitions of the materials is displayed in the relevant lines of the Dimension totals window.

 


 

 

F. Currency Info Entry

 

Reporting currency information of the transaction in line is saved by using F. Currency Entry option in material slips. F. Currency Info Entry option is located in right mouse button menu.

 

Reporting currency type specified in period definition, daily exchange rate belonging to the slip date read from daily exch. rate table for that currency type and amount in FC against unit price calculated over this value are displayed automatically in F. Currency Info window. If transactions will be performed over a different exchange rate, exchange rate can be changed.  

 


 

Reporting Currency: It is displayed in currency field automatically. Reporting currency is specified in Working Info page while defining Company and it is transferred to transactions automatically. Reporting currency type can not be changed during transactions.

 

Amount in F. Currency: It refers to transaction amount (TL) in foreign currency type. It is calculated over daily exchange rate read from daily exchange rate table by the application and transferred to the relevant field.

 

Exchange Rate: It refers to daily exchange rate of reporting currency. If daily exchange rates belonging to the transaction date are not entered, they are transferred to the field automatically.

 

Daily exchange rate belonging to the slip date which is read from daily exchange rate table and unit price against amount in FC calculated over this value are transferred to the relevant fields automatically. When any data is entered in a field located in transaction window, values of other fields are written after recalculating. That is to say;

If we are to perform transaction over a different exchange rate, new value is written directly in exchange rate field or exchange rate of the required day is selected from exchange rate table. In this case, local currency against unit price in FC calculated over the new exchange rate is calculated by the application and written in Unit Price in F. Currency field.

 

Updating Pricing Currency Exchange Rate for all Slip Lines

 

In material slip, it is possible to determine reporting currency exchange rate and to reflect this to all slip lines. “Exchange Rate will be Updated for all Lines” option of the F. Currency Entry window is used for this logic. In the event of marking this option, the exchange rate changes for reporting currency, will be valid for all lines of material slip.

 

 

 

Barcode Entry

 

If the information of the materials processed in the slip lines will be recorded using a barcode reader, Barcode Entry option located in the right mouse button menu is used. 

 

When the Barcode Entry is selected in the slip lines, the Barcode Entry window where the barcode will be read or directly inserted is opened. The Code and Description of the Material for which the barcode is read are transferred into the Code and Description fields of the slip line using the Add to Line button. When a new barcode is entered for the same material, Quantity changes automatically.

 


 

Batch Selection of Variants

 

In slips and invoices, in case processed material is a configurable item, it is used to transfer material variants to slip lines in batch after selecting them according to their characteristics and after determining their quantity and unit prices.

 

Related material’s previously defined characteristics and their values are listed in this window with their descriptions. Desired characteristics are selected and variant properties for which slip or invoice will be generated are specified.

 

Selected characteristics can be corresponded to more than one variant. With this window, more than one line can be added to slip / invoice.

 

If there is not a variant description in system containing desired characteristics “Automatic Variant Assignment” option is used.  When this option is clicked, “In case of a variant not found with selected characteristic values, it will be generated automatically” message is displayed. If “OK” is selected, material variant is generated containing  selected characteristics.

 

Add Material Code To The Beginning Of Variant Code: If you want to add the relevant material code to the beginning of new variant code when variant is assigned automatically, this field is checked.

 

Add Material Description To The Beginning Of Variant Description: If you want to add the relevant material description to the beginning of new variant description when variant is assigned automatically, this field is checked.

 

In Batch Selection of Variants window, each material characteristic is displayed in a separate tab. “All” tab displays all caharacteristics and their values of material with their descriptions. This tab provides ease of use in case there are numerous material characteristic values.

 

The quantity, unit price and unit info to be valid for each variant is recorded from the fields located at the bottom of Batch Selection of Variants window.

 

The Physical Inventory and Actual Inventory information of each material variant is displayed in related fields at the bottom of window as well.

 

All variants specified in Batch Selection of Variants window are transferred to slip / invoice lines with their quantity and unit price info by using “Transfer” button.

 

 

Batch Update of Variants

 

Material variant data can be updated in batch. To do that “Batch Update” option is used which is located in F9 / right mouse button menu of Material Variants list.

For batch update, firstly the records to be updated are selected. The information to be updated is specified in Batch Update filter lines displayed when Batch Update option is selected. Selected variant information is updated with the information entered in filter lines. They are the followings:

 

Filter

Value

Status

Active / Passive

Aux. Code

Group / Range

Auth. Code

Group / Range

 

 

Variant Browser Filters

 

Filter option is used to display the records of the materials variants list that match specific conditions. In this way, the requested record can easily be found and tracked. The filter option is located in F9 key/right mouse button menu of the Variants list. The filter options and values are:

 

Filter

Value

Variant Code

Group / Range

Variant Description

Group / Range

Variant Aux. Code

Group / Range

Variant Auth. Code

Group / Range

Variant Characteristics

Characteristics 1 – 10 (Code / Value)

Physical Inventory Quantity

Negative / 0 / Positive

 

 

Vendor Code Entry

 

The Vendor Code is the code of the material processed in the vendor. The material code used by a company is generally different from the one used by the vendor of that material. In such cases, the user has to find the corresponding internal code for the material code specified on the slip when recording the invoices and Disp./Receipt supplied by the vendor. This method is time consuming and open to errors. The Vendor Code recorded in the material allows such problem to be resolved. In other words, the Vendor Code is sort of a second Material Code field.

 

The information of the Purchase Orders and the materials processed in the purchase receipts and invoices can also be saved by assigning a Vendor Code. The user can easily reach the company’s own material definition by using the Vendor Code when entering the slip or invoice. The Vendor Code Entry located in the right mouse button menu is used to select materials by Vendor Code. The Code and Description of the material for which the Vendor Code is entered is transferred into the Code and Description fields of the slip line.

 

Unit Conversion

 

The Unit Conversion allows the materials for which the units do not have fixed connections to be accurately converted. In this way, the purchase and inventory reports are generated accurately according to the desired unit.

The Material Transactions are recorded, tracked and reported with more than one unit type. A Unit Set is generated for each Material when the Materials are recorded. A main unit and units in the required number are recorded in these Unit Sets and used in transactions.

 


 

The Quantity is displayed in the Status Info window using the Main Unit. The reports can be generated using the requested Unit type. If unit conversion is required for reporting, the Unit Conversion Factors are used and the correct quantity information is calculated.

 

However, the Unit Conversion Rate specified in the Material or Material Class may not be applied to certain material lines. In this case, a different Unit Conversion Factor to be applied to that transaction can be entered using the Unit Conversion option located in the right mouse button menu accessed by clicking the Unit column of the related material while the slip or invoice window is open.

 

 

Lot/Serial/Location Info

 

If the Materials are tracked by Serial Number or Lot Number, the Lot/Serial Numbers are recorded using the Serial/Lot/Location Info option located in the right mouse button menu.

 

Tracking is performed by assigning a Lot Number if Lot Number tracking will be used, or by assigning a Serial Number if Serial Number tracking will be used.

 


 

The Lot/Serial Number Entry window displays the Location Code, material Expiry Date and Note (the degree of conformity determined after inspection) information along with the Lot or Serial Number. If the material is processed with units other than the Main Unit, the Unit Conversion information and the dimension information are recorded using the Unit Conversion option located in the right mouse button menu of the Lot/Serial Number Entry window.

 

In output transactions, the Input Transactions are listed and the related Lot or Serial Number is selected.

 

 

Material Slips Lot/Serial Info

 

In Input from Production, Carrying Over and Cycle Count Excess slips, the Lot and Serial Numbers can be entered according to the Tracking Method specified, using the Serial/Lot/Location Info option of the right mouse button menu while the slip is open.

 

In tracking by serial number operations, different serial numbers are assigned in the quantity specified in the line. The serial numbers can be defined by the user or generated by the application.

 

The user defined serial numbers are recorded using “New” option of the Select Serial Number window located in the right mouse button menu. The serial number and description are recorded in the code and description fields.

 

The user can define serial or lot numbers during transaction according to the selection made in the Lot/Serial Numbers line which is one of the Material Management Parameters options of the Definitions menu of the Administration section. This parameter consists of two options: “Do Not Enter During Material Transaction” and “Enter During Material Transaction”. If “Do Not Enter During Material Transaction” is selected, the user can only use the defined numbers but can not define serial or Lot number on the slip.  

 

Using “Generate Lot/Serial Number” option, the serial numbers can be automatically generated by the application once the start number and quantity are specified. The serial numbers to be transferred to the transaction are specified by selection, and transferred to the material in the line by clicking the Transfer button.

 


 

The quantity of the materials for which the tracking method is Lot is specified in the quantity column of the Serial/Lot/Location window. In this method, each material input and output transaction is assigned with a lot number. This lot number is applied to any input or output quantities in the slip or invoice.

 

The other information recorded and tracked in the Serial/Lot/Location entry window are:

 

Location Code: The code of the material location in the warehouse. If the material’s location code in the warehouse is specified using the Warehouse Parameters in the material record, such code is transferred into the field as default. The location definitions are listed and the related definition is selected. If “Track by Location” operation is specified for the material, the location is controlled during the transaction. Depending on the inspection method, the slip is not recorded or is allowed to be recorded under the control of the user.

 

Expiry Date: Indicates the expiry date of the material in the line. The current date comes into field as default.

 

Grade: The evaluation grade of the material resulting from the inspection is recorded in this field if the Inspection system is used.

 

If the Material Management Parameters option of the Definitions menu located in the Administration section is specified as Divisible Lot Size and if the quantity specified in the line is less than the lot numbers, the remaining lot numbers can be used in another output transaction.

 

In the Usage, Scrap, Cycle Count Deficit and Warehouse Transfer Slips, the output lot/serial numbers of the material tracked by lot/serial numbers are recorded in association with the input transactions. When the Serial/Lot/Location is selected in the material line of the slip, the output transactions window is opened. The Input Transactions located in the right mouse button menu are selected. The recorded input transactions are listed by entering the serial number of the material. The serial and lot transactions to be associated to the output transactions in the line are checked by selecting with the mouse or search button and transferred to the related field by clicking “Transfer” button.

 

In the Warehouse Transfer Slips, the serial or lot numbers of the output transactions are recorded by associating with the input transactions. For transactions between the warehouses, the location codes belonging to the warehouses which the material is output from or input to are tracked and recorded under the Source Warehouse, Destination Warehouse and Location Code columns of the lot/serial output window.

 

 

Material Class Detail Lines

 

In case that the transaction in the slip or invoice line belongs to a Material Class, the line Type is selected as Material Class. The Material Class can be either Material Class (General) or Material Class (With table).

 

If the line transaction belongs to a Material Class, the Code of the Material Class is defined in the Code field. Then the Material Class Details located in the right mouse button menu is selected.

 


 

The child materials connected to the Material Class are listed in the Material Class Detail Lines window that opens. The material of the transaction is selected. The Code, Description, Quantity, Unit, Unit Price, Unit Price in F.C., Currency Type, Amount, Amount in F.C. and Transaction Aux. Code information for each material within the Material Class is recorded in a separate line.

The slip detail lines with line type of Material Class and Class type of Material Class (General) can also be recorded using the Distribution Templates.

 

In Material Class (General) type slip lines, the information of the Child Materials are recorded using the right mouse button menu options of the Material Class Detail Lines window. The menu options are:

 

Times Increment: Used to increment the child material quantity.

 

Serial/Lot/Location: Used to record the Lot/Serial and location information of the child materials for tracked materials.

 

F. Currency Info Entry: Used to record the f. currency info of the transaction.

 

Dimension Totals: Used to track the dimension totals.

 

Warehouse Totals: Used to track the Child Materials of the Material Class.

 

Material Status: Used to track the general status of the Child Material in all the warehouses.

 

Inventory Level: Indicates the actual material summary including the transaction in the line.

 

 

Material Input on Table

 

In lines for which the Material Class is selected as Material Class (With table), the slip line details are recorded using the Material Table option of the right mouse button menu. The Material Input using Matrix Interface window consists of three main sections: Slip Line Info, Detail Line Info and Material Class.

 

The general information of the slip line is displayed on the Slip Line Info section. The following information is recorded in this section:

 

Quantity: Indicates the transaction quantity of the Material Class. The Times Increment button is used to specify the quantity related to the Material Class Detail Lines.

 

Unit: This field is used to specify the unit to be applied to the Material Class transaction. The units belonging to the Material Class are listed and a selection is made.

 

Description: The description of the slip line.

 

The material table generated according to the Material Characteristics is displayed in the Material Class section. The transaction quantities are recorded to the related columns of this table.

 

The Detail Line Info section is used to record the details of the line information. The following information is recorded in this section:

 

Quantity: The total purchase or sales quantity of the material class processed in the line.

 

The Transaction Aux. Code of the Material Class type line is specified in the Transaction Aux. Code field. The defined transaction Aux. Codes are listed. The appropriate definition is selected or a new definition is made.

 

Description: The description of the Material Class (With table) line.

 

Project Code: The project code of the material connected to the Material Class. Defined projects are listed, and the appropriate definition is selected.

 

Unit Price: The unit price of the material connected to the Material Class. The Unit Price can be directly entered or transferred into the field by selecting the requested option after the Unit Price options are listed.

 

The values to be applied to the materials within the table for Material Class (With table) purchase and sales transactions are recorded using Multiple Value Assignment to Matrix option. The Unit Price, Transaction Aux. Code, Expiry Date and Description information of the materials transacted using the Material Class (With table) is recorded in batch in the Multiple Value Assignment to Matrix window.

 


 

Material Class (With table) Right Mouse Button Menu

 

Material Status (General): Used to track the general status information in all warehouses.

 

Warehouse Totals: Used to view the material status and transactions by warehouse.

 

Costs: This option is located in the right mouse button menu of the usage and scrap slips. The cost and profit rate of each line in the slip is tracked according to the selected costing method.

 

Material Level: Indicates the existing material status during transaction entry to the slip and the impact of the entered transaction on the material quantity and is used to track the material status in real time during slip entries.

 

Number of Lines: Displays the total number of lines in the slip.

 

 

Apply Distribution Template

 

In the slip lines of Material Class (General) type, the details of the Child Materials of the Material Class can also be recorded using the Distribution Template by selecting “Apply Distribution Template” option of the right mouse button menu. The Child Materials of the Material Class and their quantities specified in the template are automatically transferred into the line. If the Child Material quantity in the line is different from the template, an increment value is entered using the Times Increment option of the right mouse button menu.

 

In the LOGO application, information about the child materials for which the lines are generated by applying the Distribution Template, -such as the Unit Price and Transaction Aux. Code- can be recorded using the Material Class Detail Lines option of the right mouse button menu. Furthermore, in Material Class type slip lines, the Lot/Serial and Location Info information are recorded using the Serial/Lot/Location option located in the right mouse button menu of the Material Class Detail Lines window.

 

 

Apply Alternative Material

 

If the alternative of the Material processed in the slip line is required to be used, “Apply Alternative Material” option of the right mouse button menu is used. The alternatives of the materials are recorded in the Alternatives tab of the Material.

 

 

Print

 

The material slips are individually printed using “Print” option. The default value specifying printing method for the material slips is located in the Material Management Parameters. The material slips can be printed either at the moment they are recorded or later. In order to print the material slips individually, first the slip to be printed and then “Print” option is selected. Print window is used to specify the form to be used and the unit to be used for printing. The Material Slips can be reviewed on the screen before printing.

 

 

 

 

Batch Printing

 

Batch Printing option located in the right mouse button menu of the Material Slips list is used to print the slips in batches. The slips to be printed are selected on the Material Slips Batch Printing filter window. The filter options are:    

 

Printing Queue: This filter line is used to specify how the batch printing will be done. There are two options:

 

  • By date
  • By number

 

The Slip Date or Slip Number filter lines are used according to the selection made.

If By date option is selected, the start and end dates are entered in the Slip Date filter line and the slips between these dates are printed in batch.

If By number is selected, the start and end numbers are entered in the Slip Number filter line and the slips within this range are printed in batch.

 

Slip Date: This line is used to filter the slips by date.

 

Slip Aux. Code: Used to filter the slips to be printed in batch by Aux. Code. The slips with the specified Aux. Code can be printed in batch by making a group or range definition.

 

Division Number: This filter line is used to specify the division for which the batch printing will be applied. Defined divisions are listed and the division for which the slips will be printed is selected by checking.

 

All defined Divisions are selected as default in the LOGO application.

 

Department Number: The line used to filter the slips to be printed by the department number assigned while the slip is generated. The defined departments are listed and the requested department is selected.

 

All defined Department Numbers are selected as default in the LOGO application.

 

Warehouse Number: This filter line is used to filter the slips to be printed by Warehouse Number. The window that opens displays the warehouses of the division selected in the Division filter line. The warehouses to be processed for printing operation are selected by checking them using the Search button.

 

All defined Warehouses are selected as default in the LOGO application.

 

Slip Type: The slip types to be printed are specified in the filter lines of the material section that include the issued slip types. If more than one form definition exists for slip types, the relative forms are listed in each line and the Form Definition to be used for printing is specified.

 

Form Print Status: This filter line includes the Unprinted forms and all options. When Unprinted forms are selected, only the unprinted forms are printed.

 

The Batch Printing is performed by clicking “OK” button after setting the conditions in the filter line.

 

Post to G/L

 

Posting to G/L can be done either in the General Ledger section or in other sections of the application. “Post to G/L” or “Post to G/L in Batch” options located in the right mouse button menu of the Material Slips list is used to post the material slips to G/L. First the materials to be posted and “Post to G/L” or “Post to G/L in Batch” options located in the right mouse button menu are selected.

 

If multiple slips will be posted to G/L, the concerned slips are selected and posted in batches using Post to G/L in Batch menu.

 

The posting conditions are set in the Posting Material Transactions window. The defined conditions can be recorded using “Save Filter button. To use the conditions in the saved filter file, the saved files are listed and selected using “Load Filter” button. The Post to G/L filter options are:

                                              

Filter

Value

Posting Control

Will Be Done / Will Not Be Done

Posting Flag

Mark / Will Not Be Marked

Line Combining

Yes / No

 

Generate Budget Transaction

Yes / No

G/L Slip General Description

Will Be Regenerated / Will Be Taken From Posted Slip

G/L Slip Line Description

None /  Transaction Number / Document Number / Transaction Type / Line Comment / Material Description / General Description (1-6) / Material Code

G/L Slip Date Assignment

Posted Slip Date Will Be Assigned / Will Be Assigned From G/L Slip Date Filter

G/L Slip Date

Date entry

 

The Control option is checked in the Posting Control filter line if the Journal Slip resulting from the posting transaction will be recorded after the control. In this case, each generated journal slip is displayed and saved after being checked. If Do Not Control is selected in the Posting Control filter, the generated slips are checked directly in the relevant sections and written to the Posting file.

 

The Line Combining filter is used to define how the lines of the same record with the same G/L Connection Codes will be posted in the material slips posted to G/L. If Yes is selected in the Line Combining filter, the lines that belong to the same record within the slip and that will be tracked using the same G/L Account Codes are combined and displayed as one line in the resulting journey slip.

 

The content of the general description of the journey slip resulting from posting is specified in the G/L Slip General Description filter line. If the general description is to be regenerated, “Regenerate” option is selected. In this way, the description is generated by the application. However, if Will be Taken from Posted Slip is selected, the general description of the posted invoice is transferred into the generated journey slip.

 

The G/L Slip Date Assignment filter line is used to define the default G/L slip date to be applied. If Posted Slip Date Will Be Assigned option is selected, the date of the posted slip is transferred into the journey slip. In this case, the date to be applied is the date entered into the G/L Slip Date filter line.

 


 

Filter Material Slips

 

It is possible to display only the records matching the requested characteristics in the Material Slips list. To do so, “Filter” option located in the right mouse button menu of the Material Slips list is used. The records to be listed are specified with the selections made in the filter lines. The filter options are:

 

Filter

Value

Slip Date

Start / End

Slip No.

Group / Range

Document No.

Group / Range

Slip Aux. Code

Group / Range

Production Order No.

Group / Range

Status

Planned / Actual

Status

Planned / Actual

Division

Defined divisions

Department

Defined departments

Warehouse No.

Defined warehouses

Plant

Defined plants

Slip Type

Scrap Slip / Usage Slip / Input from Production Slip / Opening Slip / WH Transfer Slip / Cycle Count Excess Slip / Cycle Count Deficit Slip

Posting Status

Posting To G/L / Not Posting To G/L

Document Tracking Number

Group / Range

Slip Amount

Amount entry

Remittance Connection

Yes / No

Added By

User selection

Addition Date

Start / End

Addition Time

Hour entry

Last Updated By

User selection

Last Update Date

Start / End

Last Update Time

Hour entry


 

Quick Production Slips

 

The Quick Production Slips are used to generate the Input from Production, Usage and Scrap Slips quickly. The slips belonging to Mixed Case, Finished Good and material lines can be automatically generated using these slips. The Quick Production Slips are located in the Transactions menu of the Material Management section.

The options and functions of the right mouse button menu of the Quick Production Slips list are:

 


New

Used to create a new quick production slip.


Update

Used to modify quick production slip information.


Delete

Used to delete the quick production slip.


View

Used to view the quick production slip without making changes.


Copy

Used to create a new slip by copying the information of the selected slip.

 

Find

Used to access the record of which the code or date is provided in the slip list.


Filter

Used to access the fast production slips according to the filter conditions specified in the slip list.

 

Multiple Delete

Used to delete the selected quick production slips in batch.

 

Print

Used to print the material slips one by one on the printer or screen.

 

Material Slips

Lists the material slips connected to the quick production slip.

 

Requirement List

Used to generate the quick production requirement list.

 

Batch Printing

Used to print the selected slips in batch.


Record Information

Indicates the users who performed the entry and update transactions of the selected record and the time of these transactions.

 

Number of Records

List the total number of records and the number by card type in the Quick Production Slips list

 

Refresh

Used to update the quick production slip information.

 

Back to Defaults

Used to return the window dimensions into the application default.

 

Lock

Used for record based approval.

 

Multiple Lock

Used to approve selected records collectively.

 

Unlock

Used to cancel record based approval.

 

Multiple Unlock

Used to cancel record approvals collectively for the selected records.

 

The information of the quick production transactions are recorded in the Quick Production Slip window accessed by clicking on “New” button located at the bottom of the Quick Production Slips list. During the quick production transactions the Finished Good, the Child Materials of the finished good, the Mixed Case and the lines of the mixed case are used.

The quick production slip consists of the following info used for the production of the finished good sections:

 

  • General Slip Info
  • Finished Good
  • Child Materials

 

 

 


General Slip Info

 

The fields and functions of the Quick Production Slip window are:

 

Slip Number: The computer tracking number of the Quick Production Slip. Alphanumeric characters can be used to enter the number. The slips are sorted by their numbers. Each Slip Type has an independent sequence number. The Slip Number field is mandatory.

 


 

Date: The date of the transaction. The Slip Date field is mandatory.


Hour: Indicates the hour that the Quick Production Slip is recorded.


Aux. Code: A second field to which codes can be entered and is used to group the Quick Production Slips. Contains 10 characters. The aux. code allows the user to group the Quick Production Slips according to certain company specific criteria and to generate reports. The user can use this field to record any necessary information that is not included in the slip.

 

Authorization Code: Used to define detailed authorizations. The string is 10 characters long. Each user may be authorized to use different records depending on the job definitions. A planning process must be performed for detailed authorization definitions. First of all, the users or user groups that can access the Quick Production Slips; the Quick Production Slips they can access to; and the transaction types they can perform must be specified. Then the slip types must be assigned with different Authorization Codes according to the defined authorization groups.

The second field on the slip is used to record the information regarding the good to be produced.

 

Project Code: The project code of the slip. Defined projects are listed, and the appropriate definition is selected.

 

Finished Good Code: The code of the finished good or the mixed case to be produced. Material type can be selected as Finished Good or Mixed Case in the Materials list accessed by clicking on “...” icon.

 

Description: The description of the Finished Good or Mixed Case selected in the Code field. When information is entered into the Code field, the description of the Finished Good or the Mixed Case is automatically transferred into this field.

 

Order Slip Number: The Order Transactions of the Finished Good or the Mixed Case can be accessed by clicking on “...” icon located next to the field. The transactions other than the Order Transactions with Proposal or Cancel status can be selected.

 

Quantity: This field is used to indicate the number of units that the related Finished Good or Mixed Case will be produced. Decimal entries can be made depending on the divisibility of the unit to be produced. If the unit is divisible, decimal entries are allowed; otherwise decimal values can not be entered.

 

Unit: The Main Unit of the finished good is automatically inserted; however, a selection can be made from other defined units if necessary.

 

Warehouse: When the Finished Good is selected, the Finished Good Warehouse specified in Finished Good Child Materials definition is automatically inserted in this field. If a material with Mixed Case Type is selected, the Central Warehouse number “0” is automatically inserted in the field; however, the warehouse can be changed if necessary.


The third field consists of the lines belonging to the child materials generated using “Calculate Materials” option located in the right mouse button key. This field consists of the Child Materials window if the material to be produced is a Finished Good; or from the Mixed case lines if the material is a Mixed Case.


If the Quantity, Unit or Warehouse fields are changed after the Child Materials of the Finished Good or Mixed Case are generated, the Child Materials must be recalculated using “Calculate Materials” option. If the slip is attempted to be generated without recalculation, the application displays “Recalculation must be made” message and generates the relevant slips by recalculating them. The quantity calculation is performed as in the example below:

 

Example:

 

A = Production Quantity

B= The Production unit - Main Unit conversion factor

C= The finished good quantity in the Child Materials window (C=1 for Mixed Case)

D= The Finished Good Unit in the Child Materials window (Main Unit for Mixed Case) x Main Unit conversion factor

P = Quantity Factor

P = [AXB] / [CXD]

Material Quantity = The Quantity in the Child Materials lines x P

 

Let’s assume that the Unit Set of the material code MM.001 is defined as follows:

 

Main Unit = Box

1. Child unit = Quantity (2 pieces = 1 box)

2. Child unit = Parcel (1 parcel = 10 boxes)

 

Child Materials

 

Quantity: 1 Unit : Quantity

 

 

Material Code

Material Description

Quantity

Unit

Scrap Rate

Warehouse

HM.001

Raw Material

10

Quantity

 

Center

 

The HM.001 quantity required to produce 2 parcels of MM.001 is calculated as follows:

 

A = 2

B = 10 (10/1)

C = 1

D = 0,5 (1/2)

P = (2*10) / (1*0,5) = 40

 

HM.001 Quantity = 10*40 = 400 pieces.

 

Recording the Quick Production Slip

 

When the Quick Production Slip is recorded, the Material management slips of the material lines and the finished good are automatically generated. The generated slips are Input from Production Slip for finished goods, and Usage and Scrap Slips for child materials. These slips are accessed using the Material Slips option located in the right mouse button menu of the Quick Production Slips list.

The Date and Hour information of the Quick Production Slip are inserted as default in the Date and Hour fields of the Input from Production, Usage and Scrap Slips.

Only the Finished Good transactions are displayed in the generated Input from Production Slip. The Quantity and Unit information of the slip is the Quantity and Unit information of the finished good. Also the Warehouse, Plant and Division information of the slip is transferred from the Quick Production Slip. The department number “0” is automatically inserted in the Department field.

The Warehouse of the Usage and Scrap Slips generated for the child materials is the Warehouse specified in the child material lines; and the Plant and Division are the Plant and Division that the Warehouse is related to. The department number “0” is automatically inserted in the Department field.

 
The Line Quantity of the related child material is multiplied with the Scrap Rate while the Scrap Slip is generated. If the resulting value is decimal and the Unit applied to the child material is ‘divisible’, the result of the multiplication indicates the Scrap Transaction Quantity. If Unit applied to the child material is ‘not divisible’, the Scrap Transaction Quantity is calculated by rounding the result of the multiplication upwards. The value of the Scrap Rate field must be different from zero for the Scrap Slip to be generated.

During slip generation, the Usage and Scrap Transactions of the same warehouse are collected in separate slips.

 

Requirement List

 

The report option used to generate the Material Requirement List of the Quick Production Slip. The Requirement List displays the gross and net requirements for the materials listed in the Quick Production Slip. The Requirement List report is located in the right mouse button menu of the Quick Production Slips list.

The filter options of the Requirement List report are:

 

Filter

Value

Finished Good Code

Group / Range

Finished Good Description

Group / Range

Finished Good Aux. Code

Group / Range

Material Code

Group / Range

Material Description

Group / Range

Material Aux. Code

Group / Range

 

 

Parting Transactions

 

In addition to saving quick production slips for finished good and mixed case materials, Quick Production Slips can also be used to record Parting Transactions.

 

Parting transactions are recorded by first clicking the slip type field on the quick production slips list and then selecting Parting slip type.

 

The parting operation information record is recorded on the window that opens.

 

General slip information is recorded on the fields at the top of the slip.

 

The fields on the finished good section are used to record transaction information.

 


 

Finished Good Code: This field is used to indicate the finished good to be parted. Recorded materials are listed by clicking on “…” icon and the related material is selected.

 

The Quantity field is used to enter the transaction quantity.

 

Once the finished good information is entered, “Calculate Materials” option located in the right mouse button menu is used to list child materials and their quantities.

 

Parting operation is completed when “Save” button is clicked.

 

Cost Distribution Slips

 

Cost distribution slips are used to distribute purchased services within the period to the material costs. Cost distribution transaction can be done for only “affects cost” field checked service card transactions.

 

The Cost distribution slips are located in the Transactions menu of the Material Management section.

The options and functions of the right mouse button menu of the Cost Distribution Slips list are:

 


New

Used to create a new cost distribution slip.


Update

Used to modify cost distribution slip information.


Delete

Used to delete the cost distribution slip.


View

Used to view the cost distribution slip without making changes.

 

Database Extensions

Used for additional information forms.

 

Multiple Delete

Used to delete the selected cost distribution slips in batch.

 

G/L Codes

Used to define the G/L Account Codes to be tracked once the transaction is posted.

 

Post to G/L

Used to post the cost distribution slips directly to G/L.

 

Post To G/L in Batch

Used to post the selected slips to G/L in batches.

 

Find

Used to access the record of which the Code or Description is provided in the cost distribution slips list.


Filter

Used to access the cost distribution slips according to the filter conditions specified in the slip list.


Record Information

Indicates the users who performed the entry and update transactions of the selected record and the time of these transactions.

 

Number of Records

List the total number of records and the number by card type in the cost distribution slips list.

 

Refresh

Used to update the cost distribution slip information.

 

Back to Defaults

Used to return the window dimensions into the application default.

 

Lock

Used for record based approval.

 

Multiple Lock

Used to approve selected records collectively.

 

Unlock

Used to cancel record based approval.

 

Multiple Unlock

Used to cancel record approvals collectively for the selected records.

 

 

Cost Distribution Slip Info

 

The fields and functions of the Cost Distribution Slip window are:

 


 

Slip Number: The record number of the cost distribution slip.

 

Date: The date of the transaction. The Slip Date field is mandatory.


Hour: Indicates the hour that the cost distribution slip is recorded.

 

Aux. Code: A second field to which codes can be entered and is used to group the cost distribution slips. Contains 10 characters. The aux. code allows the user to group the cost distribution slips according to certain company specific criteria and to generate reports. The user can use this field to record any necessary information that is not included in the slip.

 

Authorization Code: Used to define detailed authorizations. The string is 10 characters long. Each user may be authorized to use different records depending on the job definitions. A planning process must be performed for detailed authorization definitions. First of all, the users or user groups that can access the cost distribution slips; the cost distribution slips they can access to; and the transaction types they can perform must be specified. Then the slip types must be assigned with different Authorization Codes according to the defined authorization groups.

The second field on the slip is used to record the information regarding the good to be produced.

 

Document Number: The document number of the cost distribution slip.

 


Surcharges To Be Distributed

 

In this part of the slip, the surcharges are entered that will be distributed to material costs. The surcharges are determined by “Filters (Surcharge to Distribute)” option located in the F9/right mouse button menu of the slip. The filter options are:

 

Filter

Value

Slip Type

Service Purchased Invoices / Service Sales Invoices

Slip Number

Group / Range

Document Number

Group / Range

Slip Date

Start / End

Service Code

Group / Range

Service Description

Group / Range

Service Aux. Code

Group / Range

AR/AP Code

Group / Range

AR/AP Title

Group / Range

Trading Group

Group / Range

Division

Defined divisions

Department

Defined departments

Plant

Defined plants

Warehouse

Defined warehouses

 

Once the conditions are set, “OK” button is clicked and the surcharges are distributed to material costs.

 

The slip lines contain the following info:

 

Slip Type: The slip type of the surcharge that will be distributed to materials. Contains the following options:

 

  • Service Purchased Invoices
  • Service Sales Invoices

 

According to the selection on the filter line one of the option displays in the slip line.

 

Slip Number: Slip number of the service purchased invoice or service sales invoice.

 

Slip Date: Slip date of the service purchased invoice or service sales invoice.

 

Service Code: The code of the service purchased or service sale.

 

Service Description: The description of the service purchased or service sale.

 

Distribution Type: Indicates how the purchased/sale service amount will be distributed to materials.

This field contains the following options:

 

  • Material Value
  • Material Quantity
  • Weight
  • Volume
  • Rate    
  • Amount
  • Will not be Distributed

 

Amount: The amount of the service invoice.

 

Amount (R.C.): The amount of the service invoice in reporting currency.

 

Distributed Amount: Displays the service distributed amount before.

 

Distributed Amount (R.C.): Displays the service distributed amount before in reporting currency.

 

Total To Be Distributed: Used to enter the amount to be distributed to the materials in distribution slip.

 

Total To Be Distributed (R.C.): Used to enter the amount to be distributed to the materials in distribution slip in reporting currency.

 

In addition to service invoice amounts that will be distributed, the amount of these invoices subjected to the rediscount can also be distributed with Cost Distribution Slip. For this, Amount (IFRS), Amount (IFRS) (RC), Distributed Amount (IFRS), Distributed Amount (IFRS) (RC), Total to Distribute (IFRS), Total to Distribute (IFRS) (RC) fields are used.  

 

Materials

 

In this part of the slip, the material info is entered that that the surcharges will be distributed to. The materials are determined by “Filters (Materials)” option located in the F9/right mouse button menu of the slip. The filter options are:

 

Filter

Value

Slip Type

Purchase Receipt / Retail Sales Return Dispatch / Wholesale Return Dispatch / Consignment Dispatch / Consignment Receipt / Input From Production Slip / Opening Slip / Warehouse Transfer Slip / Producer Slip / Cycle C. Slip (Excess)

Slip Number

Group / Range

Document Number

Group / Range

Slip Date

Start / End

Invoice No.

Group / Range

Billing Status

Billed Dispatch/Receipts / Unbilled Dispatch/Receipts

Document Tracking Number

Group / Range

AR/AP Code

Group / Range

AR/AP Title

Group / Range

AR/AP Aux. Code 1-5

Group / Range

Data Interchange ID

Group / Range

AR/AP Auth. Code

Group / Range

Trading Group

Group / Range

Material Type

Commercial Good / Mixed Case / Deposit Item / Fixed Asset / Raw Material / Semi Finished Good / Finished Good / Consumer Good

Material Code

Group / Range

Material Description

Group / Range

Material Aux. Code

Group / Range

Material Auth. Code

Group / Range

Material Group Code

Group / Range

Material Vendor Code

Group / Range

Material Characteristics

Characteristic 1-10 - Characteristic Code/Value

Division

Defined divisions

Department

Defined departments

Plant

Defined plants

Warehouse

Defined warehouses

Warehouse Cost Group

Defined cost groups

Variant Code

Group / Range

Variant Description

Group / Range

Variant Aux. Code

Group / Range

Period Closing Records

List / Do Not List

 

Once the conditions are set, “OK” button is clicked and material transactions to which surcharges will be distributed are transferred to the slip lines.

 

Slip Type: Material slip type that the cost distribution will be done to.

 

Slip No: Material slip number.

 

Slip Date: Material slip date.

 

Warehouse: The warehouse that the material in line belongs to.

 

Material Code/Description: The material code/description that cost distribution will be done to.

 

Variant Code/Description: The code or description of the material variant in case the processed material in line is configurable. The defined material variants are listed by clicking on “... icon on both fields, and a selection is made.

 

Quantity: Material slip quantity.

 

Unit Price: The unit price entered in the material slip.

 

Main Unit: The main unit info of the material slip.

 

Distribution Rate: If the distribution type is selected as “Rate”, the distribution rate is indicated in this field.

 

Distribution Amount: Indicates the distribution amount of cost for the material transaction in line.

 

Distribution Amount (IFRS): Specifies expense’s distribution amount, subjected to the rediscount, for this material transaction.

 

If “List” option is selected in Period Closing Records filter line located in Material filters, Latest Period Closing records generated by the cost method which is specified in Material Cost Method parameter line located in Material Management Parameters, will be listed in Materials section of Cost Distribution Slips and Sales Provision Slips. Cost is distributed to the period closing records listed inhere. In order to list period closing lines by materials, material code filter is used.

 

If any of the period closing lines are used in cost distribution or sales provision distribution slips, period closing record of the relevant materials can not be undone while undoing material period closing transaction.

 

Sales Provision Distribution Slips

                     

Sales Provision Distribution Slips are used to distribute purchased / sold services within the period to the sold material costs. Service worth is distributed to sales transactions.

Sales provision distribution slips are located in the Transactions menu of the Material Management section.

The options and functions of the right mouse button menu of the sales provision distribution slips list are:

 


New

Used to create a new sales provision distribution slip.


Update

Used to modify slip information.


Delete

Used to delete sales provision distribution slip.


View

Used to view slip without making changes.

 

Database Extensions

Used for additional information forms.

 

Multiple Delete

Used to delete the selected slips in batch.

 

G/L Codes

Used to define the G/L Account Codes to be tracked once the transaction is posted.

 

Post to G/L

Used to post the sales provision distribution slips directly to G/L.

 

Post to G/L in Batch

Used to post the selected slips to G/L in batches.

 

Find

Used to access the record of which the Code or Description is provided in slips list.


Filter

Used to access the sales provision distribution slips according to the filter conditions specified in the slip list.


Record Info

Indicates the users who performed the entry and update transactions of the selected slip and the time of these transactions.

 

Number of Records

List the total number of recorded slips.

 

Refresh

Used to update slip list information.

 

Back to Defaults

Used to return the window dimensions into the application default.

 

Lock

Used for record based approval.

 

Unlock

Used to cancel record based approval.

 

Multiple Lock

Used to approve selected records collectively.

 

Multiple Unlock

Used to cancel record approvals collectively for the selected records.

 


 

Sales Provision Distribution Slip Info

 

Sales provision distribution slip consists of 3 parts. Upper part of the slip is used to record general info to be valid for slip. These are:

 

Slip No: The record number of the sales provision distribution slip.

 

Date / Hour: The date / hour of the transaction. The Slip Date field is mandatory.

 

Aux. Code: A second field to which codes can be entered and is used to group the sales provision distribution slips.

 

Auth. Code: Sales provision distribution slip authorization code.

 

Document No: The document number of the sales provision distribution slip.

 


 

Services to be Distributed

 

In this part of the slip, the sold / purchased services are entered that will be distributed to sold material costs. The services are determined by “Filters (Services to be Distributed)” option located in the F9/right mouse button menu of the slip. The filter options are:

 

Filter

Value

Slip Type

Service Purchased Invoices / Service Sales Invoices

Slip No.

Group / Range

Document No.

Group / Range

Slip Date

Start / End

Document Tracking Number

Group / Range

Service Code

Group / Range

Service Distribution

Group / Range

Service Aux. Code

Group / Range

AR/AP Code

Group / Range

AR/AP Title

Group / Range

Trading Group

Group / Range

Division

Defined divisions

Department

Defined departments

Plant

Defined plants

Warehouse

Defined warehouses

Invoice Input Location

From Safe Deposit / From Bank

 

Once the conditions are set, “OK” button is clicked and the services are distributed to material (sold) costs.

 

The slip lines contain the following info:

 

Slip Type: The slip type of the service that will be distributed to materials. It contains the following options.

 

  • Service Purchased Invoices
  • Service Sales Invoices

 

According to the selection on the filter line one of the option displays in the slip line.

 

Slip No: Slip number of the service purchased invoice or service sales invoice.

 

Slip Date: Slip date of the service purchased invoice or service sales invoice.

 

Warehouse: The warehouse info that the service belongs to.

 

Service Code: The code of the service purchased or service sale.

 

Service Distribution: The description of the service purchased or service sale.

 

Distribution Type: Indicates how the purchased/sale service amount will be distributed to materials.

This field contains the following options:

 

  • Will Not Be Distributed
  • Material Value
  • Material Quantity
  • Weight
  • Volume
  • Rate
  • Amount

 

If Will Not Be Distributed is selected, purchased/sold service worth is not distributed to sales transactions.

When Material Value is selected, the value of the material is considered during distribution.

If Material Quantity is selected, the quantity of the material is considered during distribution.

When Weight is selected, material’s gross weight is considered.

When Volume is selected, material’s gross volume is considered.

If Rate is selected, material will be affected from service cost for a specific rate. Distribution rate is recorded in Materials part of slip.

If Amount is selected, related material amount is taken into consideration. Distribution amount is recorded in Materials part of slip.

 

Amount: The amount of the service invoice.

 

Amount (R.C.): The amount of the service invoice in reporting currency.

 

Distributed Amount: Displays the service distributed amount before.

 

Distributed Amount (R.C.): Displays the service distributed amount before in reporting currency.

 

Total to Be Distributed: Used to enter the amount to be distributed to the materials in distribution slip.

 

Total to Be Distributed (R.C): Used to enter the amount to be distributed to the materials in distribution slip in reporting currency.

 

In addition to service invoice amounts that will be distributed, the amount of these invoices subjected to the rediscount can also be distributed with Sales Provision Distribution Slip. For this, Amount (IFRS), Amount (IFRS) (RC), Distributed Amount (IFRS), Distributed Amount (IFRS) (RC), Total to Distribute (IFRS), Total to Distribute (IFRS) (RC) fields are used.

 

Materials

 

In this part of the slip, the material info is entered that that the services will be distributed to. The materials are determined by “Filters (Materials)” option located in the F9/right mouse button menu of the slip. The filter options are:

 

Filter

Value

Slip Type

Retail Sales Dispatch / Wholesale Dispatch / Consignment Dispatch

Slip No.

Group / Range

Document No.

Group / Range

Slip Date

Group / Range

Invoice No.

Group / Range

Billing Status

Billed Receipts/Dispatches / Unbilled Receipts/Dispatches

Document Tracking Number

Group / Range

AR/AP Code

Group / Range

AR/AP Title

Group / Range

AR/AP Aux. Code 1-5

Group / Range

Data Interchange ID

Group / Range

AR/AP Auth. Code

Group / Range

Trading Group

Group / Range

Material Type

Commercial Good / Mixed Case / Deposit Item / Fixed Asset / Raw Material / Semi Finished Good / Finished Good / Consumer Good

Material Code

Group / Range

Material Description

Group / Range

Material Aux. Code 1-5

Group / Range

Customer / Supplier AR/AP Code

Group / Range

Customer / Supplier AR/AP Description

Group / Range

Customer / Supplier Code

Group / Range

Customer / Supplier Description

Group / Range

Material Auth. Code

Group / Range

Material Group Code

Group / Range

Material Vendor Code

Group / Range

Material Characteristics

Characteristic 1-10

Division

Defined divisions

Department

Defined departments

Plant

Defined plants

Warehouse

Defined warehouses

Warehouse Cost Group

Defined cost groups

Variant Code

Group / Range

Variant Description

Group / Range

Variant Aux. Code

Group / Range

Period Closing Records

List / Do Not List

 

Once the conditions are set, “OK” button is clicked and material transactions to which services will be distributed are transferred to the slip lines.

   

Slip Type: Material’s slip type that the service distribution will be done to.

 

Slip No: Slip number of the material.

 

Slip Date: Slip date of the material.

 

AR/AP Code: AR/AP info of the slip that material belongs to.

 

Warehouse: The warehouse that the material in line belongs to.

 

Material Code / Description: The material code/description that service distribution will be done to.

 

Variant Code/Description: The code or description of the material variant in case the processed material in line is configurable. The defined material variants are listed by clicking on “...” icon on both fields, and a selection is made.

 

Quantity: Material’s slip quantity.

 

Unit Price: The unit price entered in the material’s slip.

 

Main Unit: The main unit info of the material’s slip.

 

Distribute: In this field, there is a box to determine whether services in upper side of slip will be distributed to the material in line or not. This field is checked if services will be distributed to relevant slip.

 

Distribution Rate: If the distribution type is selected as “Rate” in Distribution Type field, the distribution rate is indicated in this field.

 

Distribution Amount: If the distribution type is selected as “Amount” in Distribution Type field, the distribution amount is indicated in this field.

 

Invoice No: The invoice info that dispatch is belonging to.

 

Distribution Amount (IFRS): When “Amount” is selected as distribution type in Services to be Distributed part, the distribution amount subjected to the rediscount is specified in this field.

 

If “List” option is selected in Period Closing Records filter line located in Material filters, Latest Period Closing records generated by the cost method which is specified in Material Cost Method parameter line located in Material Management Parameters, will be listed in Materials section of Cost Distribution Slips and Sales Provision Slips. Cost is distributed to the period closing records listed inhere. In order to list period closing lines by materials, material code filter is used.

 

If any of the period closing lines are used in cost distribution or sales provision distribution slips, period closing record of the relevant materials can not be undone while undoing material period closing transaction.

 

Operations


The inventory levels of the materials including the transactions performed in the Sales and Distribution and Purchase departments are tracked, and the costing, period operations and material VAT Update transactions are performed in the Operations menu of the Material Management section.

 

 

Batch Generation Of Material (Class) Records

 

The Batch Generation of Material (Class) Records option located in the Operations menu is used to generate multiple Material or Material Class records at the same time. The conditions and characteristics to be applied to the production are defined in the Batch Generation of Material Class filter lines.

 

Only one record for one material or material class type at a time can be generated in the LOGO application.

 

The type selection is done in the Material (Class) Type filter line. The number of records to be produced is specified in the Number of cards filter line.

 

To generate a record, first of all the type and number of cards to be produced and some basic properties of the records to be produced are defined in the filter lines. Then the material code appointment method is defined. In code definitions, the Material Characteristics and the characteristic values are reflected on the codes. By doing so, the characteristic assignment records are generated for the materials to be produced.

 

The general options recorded in the General Info tab of the material (class) record are displayed in the Automatic Material field lines. The filter options are:

 

Filter

Value

Material (Class) Type

(CG) Commercial Good / (DM) Deposited Item / (FA) Fixed Asset / (RM) Raw Material / (SF) Semi Finished Good / (FG) Finished Good / (COG) Consumer Good / (MC) Material Class (General) / (MT) Material Class (with Table)

Purchase VAT Rate (%)

Vat rate

Sales VAT Rate (%)

Vat rate

Return VAT Rate (%)

Vat rate

Retail Sales VAT Rate (%)

Vat rate

Retail Sales Return VAT Rate (%)

Vat rate

Material Tool

Yes / No

Unit Set Code

Group / Range

Tracking Method

Do Not Track / Serial Number / Lot Number

Usage Point

Material Management / Purchasing / Sales And Distribution

Location Tracking

Track / Do Not Track

Number of Cards

Number of Cards To Be Produced

Configurable Sign

Yes / No

 

Once the conditions are set, “OK” button is clicked. The characteristics of the codes of the records to be produced are specified in the Batch Generation of Material (Class) Records window. Each line defined in the left pane of the window has a section displaying the codes of records to be generated. The list on the right pane is activated only if a Characteristic Code is selected in the line selected on the left pane, and is used to define the value of that characteristic.

 

In the LOGO application, the code type can be Fixed or Incremental. Characteristic can not be selected in Incremental sections.

 

If the values of the Material Characteristics are desired to be reflected into the code, after selecting Fixed in the Type column and a Characteristic Code in the Characteristic column, the values of such characteristic is selected on the right pane and the abbreviation method is defined depending on the number of characters. Length (char.) column is used to define the length of the code sections in terms of characters.

 

If no characteristic is selected for a Fixed type line, the fixed value has to be entered into the Start column; and the Start and End values must be entered into the lines with Incremental type.

 

When “OK” button is clicked, the Material (Class) Records are automatically generated according to the specified characteristic and code generation system. If the Number of cards is not specified in the filter window, the maximum possible number of records will be generated for the defined template.

 

Period Close

 

The aim of the Period Close operation is to finalize the Material Transactions within a certain date range to ensure the data security. The Period Close operation is done by entering a Period Close Date and specifying the materials for which the operation will be applied. The period close range is defined by the user; it does not have to be periodical. Slips dated before the Period Close Date can not be entered for materials for which the period is closed, and the transactions before this date can not be modified.

 

When Period close is selected from the Operations menu, the materials for which the period close operation will be performed are specified in the Period Close filter window. The options of the filter lines are:

 

Material Type: Used to specify the material types for which the Period Close operation will be performed. This filter line includes the following options:

 

  • Commercial Good
  • Mixed Case
  • Deposited Item
  • Fixed asset
  • Raw Material
  • Semi Finished Good
  • Finished Good
  • Consumer Good

 

In LOGO application, all Material Type options are selected as default and included in the period close operation. The check marks next to the Material Types for which the Period Close will not be applied are removed.

 

Material Status: This field has two options: Active and Passive When Active is selected, the Period Close is applied to Materials that have the Active Material Status.

 

Material Code/Description: This line is used to filter the materials for which the period close operation will be applied by defining groups or ranges.

 

Material Aux. Code: This line is used to filter the materials for which the period close operation will be applied by Material Aux. Code and by defining groups or ranges.

 

Material Auth. Code: This line is used to filter the materials for which the period close operation will be applied by Material Auth. Code and by defining groups or ranges.

 

Material Group Code: This line is used to filter the materials for which the period close operation will be applied by Material Group Code and by defining groups or ranges.

 

Material Vendor Code: This line is used to filter the materials for which the period close operation will be applied by Material Vendor Code and by defining groups or ranges.

 

Parent Material Class Code/Description: This line is used to filter the materials for which the period close operation will be applied by Parent Material Class Code and by defining groups or ranges .

 

Material Characteristics: This line is used to filter the materials for which the period close operation will be applied by Material Characteristics and by entering the Characteristic Code and Value.

 

Period Close Date: This line is used to enter the Period close date. After the Period Close operation, the transactions performed on and before the date entered in this line can not be modified. In materials for which the period is closed, slips with dates before the Period Close Date can not be issued.

 

Configurable Sign: In case of selecting “Yes” option in this filter line, the period close operation is done for the configurable materials basis on variants.

 

Variant Code / Description / Aux. Code: In case of selecting “Yes” option in “configurable sign” filter line, the material variants are determined in these filter lines that the period close operation will be done for.

 

The Period Close Log is generated after the Period Close operation performed after defining the period close criteria. The report includes the Period Close Date and the Number of Records for which the period close operation is performed. When multiple Period Close operations are performed on the same date, the Period Close Log displays the materials which were previously closed on the same date with the Incorrect Close Date description.

 

When the Period Close operation is performed, the materials are costed according to the Costing Method specified in the Parameters, and the costing result is saved. In this way, when the costs of the Material Transactions after the closing date are calculated, the transactions performed until the closing date are not costed again. The material quantity and unit costs resulting from the period close operation are used in the costing operation.

 

Since the Period Close operation is performed by warehouse, each warehouse is scanned during the close operation and the costing operation is performed by considering the transactions of each warehouse. When the Consignments Receipts are billed, the costing is done by processing the Receipt Date. Furthermore, all invoices are costed by processing the Receipt Date.

 

After the Period close operation is completed, the receipts included in the operation are not billed. If such receipts contain material lines excluded from the close operation, these lines are not changed either since the period close control is done according to the slip as a whole.

 

After the Period Close operation, the purchase return slips are reflected as inputs to the cost calculations.

 

The Costing Methods Used in Period Close Operations

 

The Costing Method to be used for the Period Close operation is defined using the Parameters. The cost types are:

 

When Average of inputs is selected as the Costing method, only the material input transactions are processed for cost calculations. The Outputs are not included. When the period close operation is performed using this method, total inputs are calculated as material inventory and the average cost of inputs as the cost.

 

When Average of On Hand is used as the Costing Method, both inputs and outputs are processed and used for costing. During the period close operation, the output total is subtracted from the input total and the costing is done based on the remaining quantity.

 

When FIFO is used as the Costing method, the operation is performed based on the first in first out principle. When this costing method is used for the period close operation, the first input transaction is processed while the unit cost of the output transaction is being calculated. In this way, only the remaining quantity resulting from the previous output transaction will be processed to calculate the cost of the next output transaction.

 

When LIFO is used as the Costing method, the operation is performed based on the last in first out principle. When this costing method is used for the period close operation, the last input transaction is processed while the unit cost of the output transaction is being calculated. In this way, only the remaining quantity resulting from the previous output transaction will be processed to calculate the cost of the next output transaction.

 

When Periodic Average is used as the Costing Method, the unit cost is calculated according to the Average of inputs and all the outputs within the period are costed using this unit cost.

 

When Physical Cost is used as the Costing Method, one by one costing is performed for the materials tracked by Lot/Serial Numbers during the period close operation, and the materials that are not tracked are costed using the FIFO method.

 

When the Average of inputs method is used, all inputs up to the closing date are processed. Furthermore, as the cost of all outputs is not the same, each output transaction is costed by taking into consideration all the inputs up to that moment. The material quantities of the outputs are not processed in the Average of Inputs. However, when the Periodic Average method is used, none of the outputs are processed and the unit costs of all the materials of that period are calculated separately. The Total Outputs are subtracted from Total Inputs to find the material quantity at the end of the period.

 

Undo Period Close

 

When the period close operation is performed, the Material Transactions are finalized and no operations can be performed on or before the period close date. If the period close operation has to be undone for any reason, “Undo Period Close” option is used.

 

The materials for which the period close operation will be undone are specified in the Material Code and Material Aux. Code filter lines. A Undo Period Close Log containing the date of transaction, the filters used and the total number of records for which the operation is undone is generated after the Undo Period Close operation.

 

 

 

 

 

 


 

Period Close Log

 

The Period Close Log can be generated immediately after the closing operation or afterwards. The report lists the date and time of the period close operation, the materials involved and the Total Number of Records.

 

Price Assignments Based On Costs

 

This operation is performed using Price Assignments Based on Costs option located in the Operations menu of the Material Management section. The Costing system is used to recalculate the costs of the Input and Output Slips using the defined inventory valuation method.

 

The costing operation means assigning costs by warehouse to the output slips. This operation is performed using the Costing option located in the Operations menu. The Costing operation means assigning costs by Warehouse Cost Group to the output slips.

 

The Costing system is used to recalculate the costs of the Input and Output Slips using the inventory valuation method defined by warehouse. The costing operation must be performed prior to reporting to ensure that the Summary Cost Analysis, Detailed Cost Analysis and the Inventory Report are generated accurately.

 

The Costing Method to be used for the Costing operation is defined using the Material Costing Method option of the Material Management Parameters located in the Definitions menu of the Administration section. The conditions indicating the slips that the costing will be applied to using the method specified here are selected in the filter lines of the Costing window. The Costing filter options are:

 

Date Range: This filter line is used to specify the date range in which the slips will be costed. The filtering is performed by entering the start and end date ranges.

 

Run Cost Maintenance First: Used to run cost maintenance that calculates the cost, before assigning costs by warehouse to the output slips.

 

Material Type: The parameter used to specify the material types to be processed in the costing operation.

 

Material Code: The line where the material(s) to be costed are specified. The material slips for which the costing will be performed are specified using the Group or Range definition filter.

 

Material Description: The line where the material(s) to be costed are specified by defining groups or ranges. By doing so, the material slips to be costed are identified.

 

Parent Material Class Code: The option used to select the materials to be costed by Parent Material Class Code. The Class Code is entered or selected from the defined classes list.

 

Material Aux. Code: The line used to select the materials using group or range definitions according to the Aux. Code entered in the Material record. The Material Slips with the specified Aux. Code are included in the costing operation.

 

Material Authorization Code: The line used to select the materials using group or range definitions according to the Auth. Code.

 

Material Vendor Code: This line is used to select the materials to be costed by Vendor Code and by defining groups or ranges.

 

Material Unit Set Code: The line used to select the materials to be costed using group or range definitions according to the Unit Sets.

 

Material Add. Tax Code: The line used to filter the materials using group or range definitions according to the Material Add. Tax Code.

 

Material Add. Tax Group Code: The line used to filter the materials using group or range definitions according to the Material Add. Tax Group Code.

 

AR/AP Code: The slips to be included in costing can be selected by making group or range definitions according to the AR/AP Code.

 

AR/AP Description: The materials to be included in costing can be selected by AR/AP Description.

 

AR/AP Aux. Code: The materials are filtered by the Aux. Code entered in the AR/AP record. By doing so, the transactions of the AR/AP with the specified Aux. Code are included in the costing operation.

 

Slip Aux. Code: The slips are filtered by the Aux. Code of the On Slip Bottom and only the specified slips are included in the costing operation.

 

Slip Types: This filter line is used to specify the slip types for which the costing will be performed. The costed slip types can be listed as Purchase Return Receipt, Retail Sales Receipt, Wholesale Receipt, Consignment Dispatch, Scrap Slip, Usage Slip, Input from Production Slip, WH Transfer Slip, Cycle Count Deficit Slip and user defined slips if any.

 

The slip types to be included in costing are selected.

 

Transaction Types: The option used to select the materials to be costed by transaction types. This filter line includes the following options:

 

  • Material Transaction
  • Promotion Transaction
  • Mixed Case Transaction
  • Fixed Asset Transaction
  • Material Class Transaction
  • Optional Material Transaction

 

All Transaction Types are selected as default in the LOGO application.

 

Warehouses: The filter line where the warehouse(s) where the costing will be performed are specified.

 

All defined Warehouses are selected as default in the LOGO application. The checks of the warehouses to be excluded from costing are removed using the search button. Since the cost assignment is made by warehouse, at least one of the defined warehouses must be selected.

 

Warehouse Cost Group: This line used to filter by cost groups.

 

All cost groups are selected as default and included in the costing operation in the LOGO application. The checks of the cost groups to be excluded from costing are removed using the search button or the mouse.

 

Material Transaction Price: This filter line consists of the following options:

 

  • All
  • Existing Ones
  • Do Not Exist

 

When Existing Ones is selected, all previously calculated costs are ignored, and the cost is recalculated.

 

When Do Not Exist is selected, the costing operation is not performed for the materials for which the unit cost is previously calculated.

 

When All is selected, all transactions are included in the costing operation, even if they were previously costed.

Once the date range, and the materials and AR/AP of which the slips will be included in costing are specified, the costing operation is started. The input and output slips are costed according to the Cost Type defined in the Material Working Info.

 

Assign Price Indices: The option used to assign price indices to slips if the Inflation Accounting feature is used.

 

Configurable Sign: In case of selecting “Yes” option in this filter line, the price assignment operation is done for the configurable materials basis on variants.

 

Variant Code/Description/Aux. Code: In case of selecting “Yes” option in “configurable sign” filter line, the material variants are determined in these filter lines that the price assignment operation will be done for.

 

In the LOGO application, the costing operation must be performed prior to reporting to ensure that the Summary Cost Analysis, Detailed Cost Analysis and the Inventory Report are generated accurately.

 

The Costing Group is a priority number assigned during Warehouse definition in USYS. When the Material Transactions are sorted by date, the Cost Group of the warehouse is processed. The transactions of the same Cost Group are costed together even if they belong to different warehouses. In other words, the materials are costed by considering each cost group as an independent whole. The Cost Group number is used for the costing of Warehouse Transfer Slips.

The Listing Order of Material Slips in Cost Reports

The listing order of material slips in cost reports depends on certain priorities. The sorting made by priorities has a significant effect on cost calculations.

The listing order or each material is as follows: The slips of the same cost group are sorted by Time (Date-Hour-Minute-Second) with input transactions first and output transactions last. The slips issued at the same time are sorted by Slip Type numbers, as Input slips first and Output slips last.

 

The Costing System Filter Options

 

Before this application assigning costs to output slips is run, a sorting is made by the filters located in the Cost window. The filters are:

 

Filter

Value

Date Range

Start / End

Run Cost Maintenance First

Yes/No

Material Type

Commercial Good / Mixed Case / Deposit Item / Fixed Asset / Raw Material / Semi Finished Good / Finished Good / Consumer Good

Material Code

Group / Range

Material Description

Group / Range

Parent Material Class Code

Group / Range

Material Aux. Code

Group / Range

Material Authorization Code

Group / Range

Material Vendor Code

Group / Range

Material Unit Set Code

Group / Range

Material Add. Tax Code

Group / Range

Material Add. Tax Group Code

Group / Range

AR/AP Code

Group / Range

AR/AP Description

Group / Range

AR/AP Aux. Code

Group / Range

Slip Aux. Code

Group / Range

Slip Types

Purchase Return Receipt / Retail Sales Receipt / Wholesale Receipt / (09) Consignment Dispatch / Scrap Slip / Usage Slip / Input From Production Slip / Warehouse Transfer Slip / Cycle Count Slip (Excess) / Cycle Count Slip (Deficit)

Transaction Types

Material Transaction / Promotion Transaction / Mixed Case Transaction / Fixed Asset Transaction / Material Class Transaction / Optional Material Transaction

Warehouses

Defined warehouses

Warehouse Cost Group

Defined cost groups

Material Transaction Price

All / Existing Ones / Does Not Exist 

Assign Price Indices

Yes / No

Configurable Sign

Yes / No

Variant Code

Group / Range

Variant Description

Group / Range

Variant Aux. Code

Group / Range

 

In the LOGO application, the filters do not change the cost calculation; they are only used to limit the slips to which the calculated costs will be assigned.


The functions of the Costing filter options are:


Date Range: The cost assignment is performed between the dates specified here. However, when the calculation is performed to assign costs to the output slips between these dates, all the slips entered up to that moment are included in the cost calculation.


Material Code and Description: The line where the material(s) to be costed are specified. The material slips for which the costing will be performed are specified using the Group or Range definition filter.

Material Aux. Code: The materials are filtered by the Aux. Code given in the Material record. The slips with the specified Aux. Code defined by making a group or range definition are included in the costing operation.

Material Authorization Code: The line used to filter the materials by the Auth. Code given in the Material record. The slips with the specified Auth. Code defined by making a group or range definition are included in the costing operation.


Material Vendor Code: The line used to filter the materials by the Vendor Code given in the Material record. The slips with the specified Vendor Code defined by making a group or range definition are included in the costing operation.


Unit Set: The requested Unit Set range is selected on the Unit Sets window accessed by clicking on “...” icon. The unit filter is used to assign costs to the slips only for the material transactions with the specified Unit Sets. This option is for filtering only.


AR/AP Code: Costs can be assigned to material transactions belonging to the requested AR/AP. The operation is started according to the selection made in this filter.


AR/AP Aux. Code: The AR/AP Aux. Code filter is used to perform the costing operation only for the material transactions with AR/AP in certain groups.

 

Slip Aux. Code: The filter used to apply the costing operation only to the slips within a certain group.

Slip Types: Costs can be assigned only to desired slip types according to the selection made using this option. Since Cost assigns costs only to the output slips, the filter options are:

 

  • Purchase Return Receipt
  • Retail Sales Receipt
  • Wholesale Receipt
  • Consignment Dispatch
  • Scrap Slip
  • Usage Slip
  • Input from Production Slip
  • WH Transfer Slip
  • Cycle Count Slip (Excess)
  • Cycle Count Slip (Deficit)
  • Defined Output Slips
  • Defined Output Dispatches

 

Transaction Types: Costs can be assigned only to desired transaction types according to the selection made using this option. The transaction types included in the filter are:

 

  • Material Transaction
  • Promotion Transaction
  • Mixed Case Transaction
  • Fixed Asset Transaction
  • Material Class Transaction
  • Optional Material Transaction

 

Cost Group: Since the cost assignment is made by Cost Group in the Cost application, at least one of the defined group numbers must be selected. The cost assignment is performed for the selected group numbers.

Warehouses: The filter used to apply the costing operation only to the slips within certain warehouses. Warehouses are costed by Cost Groups.


Material Transaction Price: The Existing Ones, Do Not Exist and All values can be entered in the Material Transaction line of this filter.

When Existing Ones is selected, all previously calculated costs are ignored, and the costs are recalculated. When Do Not Exist is selected, the materials for which the Unit Costs are not previously calculated are selected and the lines with empty Material Transaction lines are costed; while all slips are costed if All is selected.

Attention

 

  • The Costing is performed for the Cost Type specified in the Material Management Parameters located in the Definitions menu of the Administration section.
  • The Material Classes are costed only for the materials in their child classes. The Material Classes to be costed are specified using the Parent Material Class Code filter.
  • The filter lines are used to define the date range and the slip types of the transactions to be costed. If the transactions that are previously costed are required to be included in the costing operation, “All” option must be selected in the Material Transaction Price filter line.
  • If a material is output without being input, the cost will not be calculated since such material will have no cost.
  • The Costing is reflected on all transactions except purchase, Producer, other inputs and consignments received.
  • The Purchase Return Receipts are processed as output transactions in the Cost application, while they are processed as inputs during cost calculation. When Cost encounters a Purchase Return Slip, considers it as an output transaction and assigns a Unit Cost price by scanning all the input/output transactions up to date, taking into consideration the Return Type. When the Cost application is run without selecting the slips constituting the purchase return transactions, such transactions are inserted in the Cost Analysis report with their unit prices in the slips.
  • Using Cost of Input/Output and Return Cost for return slips, reduces the cost of the remaining materials in the rate of their own return costs. See the Costing Return Slips section for detailed information.
  • When the Cost Analysis report is generated after the Cost application is run, the Amount and Cost columns of that material will be equal. The reason of this equality is that the Unit Price will be equal to the Unit Cost by warehouse since the Unit Price and Output Amount information will be changed in the output slips once the Cost application is run.

However, such result will not be achieved when the report is generated by running the Costing before the Cost application. Because, the Unit Price and Output Amount does not change in the slips when the Costing is run. In such cases, Profit or Loss would result since the Unit Price will be different from the Unit Cost.

  • When the Cost application is run by selecting the FIFO cost method, if an output transaction is costed using more than one input transaction, such output transaction will be displayed in more than one line in the Cost Analysis report since each line is costed with different Unit Prices according to FIFO.
  • When the Cost application calculates the costs using the FIFO method, it calculates the average of all the lines and assigns a single Unit Cost to the output slip. In this case, certain lines of the same output may display profits while others display losses in the Cost Analysis report. When the lines of this output transaction are added the profits will be equal to the losses. In this way, the totals of the Output Amount and Cost columns of that slip line are equalized.
  • If Discount is selected in the Purchase and Sales and Distribution Parameters, and Material Cost is selected as the cost tracking method, the Unit Cost inserted in the slip line will not match with the Unit Price displayed in the Cost Analysis report since the Cost application will insert a cost only to the Unit Price field of the slip.

The reason for this result is the fact that the discounts and surcharges are not processed while the Unit Price is calculated in the Cost Analysis report. Whereas the Cost application processes using the Unit Price in the slip line. Therefore, in order to achieve accurate results, discounts and surcharges should not be entered into the slips to be costed using Cost.

 

Costing Maintenance

 

The service is used to define costs for Output Slips. This service should not be confused with the Cost application. While the Cost application assigns costs to Output Slips, The Costing Maintenance specifies costs for the Output Slips but does not insert these costs into the slips.

 

The Costing system is used to recalculate the costs of the Input and Output Slips using the inventory valuation method defined by warehouse. The costing operation must be performed prior to reporting to ensure that the Summary Cost Analysis, Detailed Cost Analysis and the Inventory Report are generated accurately.

 

The conditions indicating the slips that the costing will be applied to using the method specified here are selected in the filter lines of the Costing Maintenance window. The Costing Maintenance filter options are:

 

Filter

Value

Date Range

Start / End

Material Type

Commercial Good / Mixed Case / Deposit Item / Fixed Asset / Raw Material / Semi Finished Good / Finished Good / Consumer Good

Material Code

Group / Range

Material Description

Group / Range

Parent Material Class Code

Group / Range

Material Aux. Code

Group / Range

Material Auth. Code

Group / Range

Material Vendor Code

Group / Range

Material Unit Set Code

Group / Range

Material Add. Tax Code

Group / Range

Material Add. Tax Group Code

Group / Range

Assign Price Indices

Yes / No

Assign Remaining Quantity / Cost To Transactions

Yes / No

Consider Inputs First For Daily Transactions

Yes / No

Configurable Sign

Yes / No

Variant Code

Group / Range

Variant Description

Group / Range

Variant Aux. Code

Group / Range

 

Material Code / Description: The materials for which the costing will be performed are specified using the Group or Range definition filter.

 

Parent Material Class Code: The option used to select the materials by Parent Material Class Code. The Class Code is entered or selected from the defined classes list.

 

Material Aux. Code / Auth. Code / Vendor Code: The line used to select the materials using group or range definitions according to the Aux. / Auth. / Vendor Code entered in the Material record.

 

Unit Set Code: Used to filter materials according to their unit set code.

 

Material Additional Tax Code: The line used to filter the materials using group or range definitions according to the Material Add. Tax Code.

 

Material Additional Tax Group Code: The line used to filter the materials using group or range definitions according to the Material Add. Tax Group Code.

 

Assign Price Indices: The option is used to determine whether or not price indices assignment will be done if the Inflation Accounting feature is used.

 

Assign Remaining Quantity / Cost To Transactions: Used to assign remaining quantities or costs to transactions. Contains Yes / No options. The default option is “No”.

 

Consider Inputs First For Daily Transactions: When costing system is run, the inventories can be decreased under negative level. So it is important to consider input transactions first. When you approve this filter, during the costing operation, the inputs are considered first.

 

Configurable Sign: In case of selecting “Yes” option in this filter line, the costing operation is done for the configurable materials basis on variants.

 

Variant Code / Description / Aux. Code: In case of selecting “Yes” option in “Configurable Sign” filter line, the material variants are determined in these filter lines that the costing operation will be done for.

 

VAT Updates For Materials (Classes)

 

To update the materials individually for changing VAT rates is a time consuming operation. Performing such operations in batches prevents the loss of time and decreases the error rate.

 

To update the VAT defaults in batch, VAT Updates for Materials option located in the Operations menu of the Material Management section is used. The materials to be included in and the method to be used for VAT updates are specified on the VAT Updates for Materials filter window. The filter options and functions are:

 

Filter

Value

Material Type

The filter used to select the materials to be updated by material types.

Material Code

The filter line used to specify the materials for which the VAT update will be performed. The material(s) to be included in the update are specified by making a Group or Range definition.

Material Description

The materials to be updated are filtered by description. The group or range definition filter is used.

Material Aux. Code

The materials to be updated are filtered by the Aux. Code given in the Material record.

Material Auth. Code

The materials to be updated are filtered by the Auth. Code given in the Material record.

Material Group Code

The materials to be updated are filtered by the Group Code given in the Material record.

Material Vendor Code

The materials for which the VAT will be updated are filtered by vendor codes.

Parent Material Class Code

The filter option used to define the materials to be updated by Parent Material Class Code.

Parent Material Class Definition

The filter option used to define the materials to be updated by Parent Material Class Description.

Material (Class) Characteristics

The filter option used to define the materials to be updated by material characteristics.

Present VAT Ratio (%)

Indicates the old VAT rate to be updated. The VAT rates of the records having the VAT rate specified here are updated with the new VAT rate.

Update Method

This filter line is used to specify the VAT update method. The update

is performed by entering New Rate or Factor. The fixed VAT amount or factor must be specified in the other filter lines depending on the selection made.

Update Factor (%)

If Factor is selected in the Update Method line, the factor is entered in this field. In this case, the update is performed by processing the VAT Rate (prev.) and the factor entered here.

Rounding Base

The filter line used to specify the rounding base to be used if the update result is decimal.

New VAT Rate (%)

The new VAT rate to be transferred into the records is entered in this field if New Rate is selected in the Update Method line.

VAT Type

Purchase VAT / Sales VAT / Return VAT

Configurable Sign

Yes / No

 

Once the condition is specified in the filter lines, “OK” button is clicked. Once the setting is done, the VAT rates of the materials matching the conditions set in the filter lines are updated with new VAT rates. The updated VAT rates are automatically transferred into the VAT Rate field of the Material record.

 

Variant Characteristic Update

 

The Variant Characteristic Update option is located in the Operations menu of Material Management section is used to update variant templates in the event of adding new characteristic values to existing variant characteristic set values.

 

The materials and variant templates to be updated are specified with the selections made in the filter lines. The filter options are:

 

Filter

Value

Material Type

Commercial Good / Deposit Item / Fixed Asset / Raw Material / Semi Finished Good / Finished Good / Consumer Good

Material Code

Group / Range

Material Description

Group / Range

Material Aux. Code

Group / Range

Material

Auth. Code

Group / Range

Material Auth. Code

Group / Range

Material Vendor Code

Group / Range

Variant Template Characteristics

Characteristic selection / Characteristic Value selection

Variant Template Abbreviations

Characteristic selection / Abbreviation entry

Length

Length value

 

 

Cycle Count

 

Material counts are regularly performed in order to see if the material count on hand resulting from material purchase, material returns, returns from sales and scraps is equal to the material count on hand after the material purchase and sales operations or not. The quantity at hand is compared to the quantity resulting from the operations. The number found after the cycle counts is recorded by using one of the following material slip types:

 

  • Cycle Count Deficit Slip
  • Cycle Count Excess Slip           

 

In the LOGO application, the information of manually counted materials can be recorded on tables in batches and according to the conditions to be defined using the Cycle Count option located in the Operations menu. In this case, the Cycle Count Deficit or Cycle Count Excess Slip is automatically generated by the application.

 

The conditions to be applied to the count are specified using the Filter Options of the Cycle Count window. The quantity of materials in warehouses in a given date is recorded by selecting Material Characteristics and Cost Type using the Cycle Count. The slips of the count are automatically generated using “Generate Slip option.

 


 

When the conditions are set in the Cycle Count filter lines and “OK” button is clicked, the table where the count information will be recorded is opened. The left side of the table displays the defined warehouses. When the warehouse to be counted is selected, the materials in that warehouse are listed with Physical Inventory (Main Unit) and cost information.

 

The quantity resulting from the count is manually entered by the user and recorded in the Cycle Count Quantity field. The physical inventory quantity resulting from the operations is compared to the cycle count quantity entered. In this way the excess or deficit quantity of the material in that warehouse is found and the quantity is displayed in the Excess/Deficit column of the Cycle Count list.

 

The cycle count deficit or cycle count excess slips are generated by clicking “Generate Slip” button located in the Cycle Count list. A Cycle Count Deficit or Cycle Count Excess Slip is opened according to the cycle count status of the selected table line. The necessary inspection and changes are performed and the slip is recorded.

 

The warehouses for which the cycle count information will be entered are specified using the relevant filter lines of the Cycle Count window. The Cycle Count filter options are:

 

Filter

Value

Counting Date

Date entry

Material Type

Commercial Good / Mixed Case / Deposited Item / Fixed Asset / Raw Material / Semi Finished Good / Finished Good / Consumer Good

Material Code

Group / Range

Material Description

Group / Range

Material Aux. Code

Group / Range

Material Authorization Code

Group / Range

Material Group Code

Group / Range

Material Vendor Code

Group / Range

Parent Material Class Code

Group / Range

Material Characteristics

Characteristic 1 – 10 (Characteristic Code / Characteristic Values)

Division Number

Defined divisions

Department Number

Defined departments

Warehouse Number

Defined warehouses

Plant Number

Defined plants

Department Default

Defined departments

Cost Type

Inventory Cost / Last Purchase Price / Last Sales Price / Unit Price Will Not Be Assigned

Slip Control

Yes / No

Configurable Sign

Yes / No

Variant Code

Group / Range

Variant Description

Group / Range

Variant Aux. Code

Group / Range

Materials Without Transaction

Display / Do not display

 

Copying from/to Excel

 

You can copy cycle count screen to Excel and after you update counting quantities you can paste relevant data to cycle count window again. There are two ways to do that:

 

1. Cycle count window is selected by mouse while pressing “Shift-Tab” keys at the same time, and information displayed in the columns of cycle count window is copied (CTRL+C) and pasted (CTRL+V) to Excel. After necessary changes, count data is pasted to cycle count window again with “ctrl-c” and “ctrl-v” keys.

 

2. Cycle count window can also be copied to Excel file by clicking “Excel” symbol which is located at lower-left corner of the window. When this symbol is clicked, Data Export Wizard window is displayed. The columns to be transferred are selected and data is exported to specified folder.

 

Distribution to Output Slips

 

The differences between the required material quantity and the counted material quantity during inventory count are distributed to the output slips recorded in the system using “Distribute to Output Slips” operation. “Distribute to Output Slips” option located in the Cycle Count list is used for the distribution operation.

 

The method of distributing the excess or deficit quantities into the slips is specified using “Distribute to Output Slips” filter lines. The filter options are:

 

Filter

Value

Slip Type

Usage Slip / Scrap Slip

Production Connection Options

Distribute to Production Connected Slips / Distribute to Production Unconnected Slips

Distribution Parameters

By Number of Slips / Counter Order List

 

The Slip Type filter is used to define the slips to which the differences will be distributed. The differences may be distributed to either usage or scrap slips, or to both.

 

The production connection status of the slips to be distributed is processed in the Production Connection Options filter line. This filter line includes the following options:

 

  • Distribute to Production Connected Slips
  • Distribute to Production Unconnected Slips

 

When Distribute to Production Connected Slips is selected, the differences are distributed to production connected usage and scrap slips.

 

The Distribution Parameters filter is used to define the distribution method for the differences. This filter includes the following options:

 

  • By Number of Slips
  • Counter Order List

 

When Counter Order List is selected, a distribution rate is calculated by dividing the difference resulting from the slips matching the selections made in the Slip Type and Production Connection Options filters to the total material quantity. The distribution is made according to this rate.

When By Number of Slips is selected, a distribution coefficient is calculated by dividing the difference to the number of slips matching the selections made in the Slip Type and Production Connection Options filters.

 

In the LOGO application, the slips to be distributed have to be posted to G/L and belong to an unclosed period for the Distribute to Output Slips operation.

 

Batch Generation Of Sales Order Slips

 

Using the Batch Generation of Sales Order Slips option, orders are given to the plants for materials that fall below the minimum inventory levels in the warehouses. The Batch Generation of Sales Order Slips option is located in the Operations menu of the Material Management section. The materials to be ordered are specified in the Batch Generation of Sales Order Slips filter lines. The filter options are:

 

Filter

Value

Date

Date entry

Material Type

Commercial Good / Mixed Case / Deposited Item / Fixed Asset / Raw Material / Semi Finished Good / Finished Good / Consumer Good

Material Code

Group / Range

Material Description

Group / Range

Material Aux. Code

Group / Range

Material Authorization Code

Group / Range

Material Vendor Code

Group / Range

Material Group Code

Group / Range

Parent Material Class Code

Group / Range

Material (Class) Characteristics

Characteristic  1-10 (Characteristic Code / Characteristic Values)

Unit Set Code

Group/Range

Material Tracking Method

No Tracking / Lot / Serial

Location Tracking

Checked / Not Checked

Warehouse

Defined warehouses

ABC Code

A / B / C

Order Quantity

By Maximum Level / By Safety Inventory Level / By Minimum Inventory Level

Process Undelivered Orders

Yes / No

Configurable Sign

Yes / No

Variant Code

Group / Range

Variant Description

Group / Range

Variant Aux. Code

Group / Range

 

Once the condition is specified in the filter lines, “OK” button is clicked. The window containing the information of the material for which Sales Order will be generated by Warehouses is opened. The batch order generation window consists of two main panes. The left pane displays the material warehouse info. The batch order slips are individually generated for the materials within each warehouse. First the related warehouse is selected and the Material Code, Description, Unit, Minimum Inventory Level, Maximum Inventory Level, Physical Inventory, Order Quantity, AR/AP Code and AR/AP Title of the material are listed in accordance with the material and date filters. The Main Unit of the Unit Set specified in the record is inserted as default in the Unit field. However, the order can also be placed using the other units.

 

The Minimum Inventory Level and Maximum Inventory Level are the quantities entered using the Warehouse Parameters of the related Material record, while the Physical Inventory is the actual material quantity in the selected warehouse. The Physical Inventory of the warehouse at the specified date is processed when the materials to be ordered are listed.

 

In the LOGO application, the order quantity is calculated by the application using the Minimum Inventory Level and Physical Inventory information.

 

The AR/AP code and title of the order are recorded in the AR/AP Code and AR/AP Title fields.

 

When “Generate Slip” button is clicked, the order slips that have the Approval Status of Deliverable are generated by the application. When the order slips are generated, the Order Transactions that belong to the same AR/AP and that will be placed in the same warehouse are collected in a single slip. If the AR/AP Material Consistency control is performed, the control is conducted by the application with the control method specified during slip generation. The generated slips are located in the Sales Orders list of the Transactions menu of the Sales and Distribution section.

 

Standard Material Costs Updates

 

The standard material costs are separately recorded for each material using the Standard Material Costs option located in the right mouse button menu of the Materials list. Standard Material Costs Update option is used to update these costs in batch. This option is located in the Operations menu of the Material Management section. The operation updates the standard material costs records defined for a certain period and transfers them into another period. The filter options are:

 

Filter

Value

Transaction Type

Transfer Only Updated Ones / Transfer All

Cost Period to Update

Period selection

New Cost Period

Period selection

Card Type

Materials / Variants

Material Code

Group / Range

Material Description

Group / Range

Material Aux. Code

Group / Range

Material Authorization Code

Group / Range

Variant Code

Group / Range

Variant Description

Group / Range

Variant Aux. Code

Group / Range

Parent Material Class Code

Group / Range

Plants

Defined plants

Update Type (TL)

By Cost(LC) / By Cost(TC) / By Transaction Currency Exchange Rate / By Reporting Currency Exchange Rate

Update Method

Change With Fixed Value / Multiply By Factor

Actual Cost

Cost value

New Cost

Cost value

Cost Update Factor

Value entry

Cost Rounding Base

Value entry

Actual Exchange Rate

Amount entry

New Exchange Rate

Amount entry

Exchange Rate Update Factor

Value entry

Exchange Rate Rounding Base

Rounding value

F. Currency Type

Currency type options

Configurable Sign

Yes / No


 

Additional Tax Rate Updates

 

The changes in the Additional Tax rate and information can be reflected on the tax definition records in batches. To do so, Additional Tax Update option located in the Operations menu of the Material Management section is used. The tax definition records to be included and the method to be used for Additional Tax updates are specified in Additional Tax Update filter window. The filter options are:

 

Filter

Value

Additional Tax Code

Group / Range

Additional Tax Group Code

Group / Range

Effective Date for the Tax

Date entry

Current Rate

Rate range

Current Amount

Amount range

Update Type

New Value Assignment / Multiply Value With Coefficient

Area Whose Value Will Be Changed

Rate / Amount / Rate + Amount

Rate

Rate entry

Amount

Amount entry

Rounding Base

Rounding Base value

Factor

Factor

 

Additional Tax Code: The filter line used to specify the tax definitions to be updated. The taxes to be updated are specified by making a Group or Range definition.

 

Additional Tax Group Code: The option used to specify the tax definitions to be updated by group codes. The taxes to be updated are specified by making a Group or Range definition.

 

Effective Date for the Tax: The option used to specify the tax definitions to be updated by effective dates. The taxes to be updated are specified by entering the effective date.

 

Current Rate: The option used to specify the tax definitions to be updated by tax type. The taxes to be updated are specified by entering a rate range.

 

Current Amount: The option used to specify the tax definitions to be updated by tax type. The taxes to be updated are specified by entering an amount range.

 

Update Type: The update type for Add. Tax is defined in this filter line. This field contains two options:

 

  • Assign New Value
  • Multiply Value with Coefficient

 

The new rate or coefficient must be specified in the other filter lines depending on the selection made.

 

Area Whose Value Will Be Changed: The types of information to be updated are specified in this filter line. There are three options: Rate / Amount / Rate + Amount. The rate information of the tax definition is updated when the rate is selected, and the amount information is updated when the amount is selected. When Rate + Amount is selected, the information of both fields is updated.

 

Rate: The filter line used to specify the new rate information. If Assign New Value is selected in the Update Type field, the update is performed according to the rate information on this field.

 

Amount: The filter line used to specify the new amount information. If Assign New Value is selected in the Update Type field, the update is performed according to the amount information on this field.

 

Rounding Base: The filter line used to specify the rounding method if the value resulting from the update is decimal.

 

Factor: If Multiply Value with Coefficient is selected in the Update Type field, the factor is entered into this field. In this case, the update is performed by multiplying the old rate or amount with the Coefficient.

 


Material Brand Update

 

The option used to assign brands to Material records in batches or to update the brands. This option is located in the Operations menu of the Material Management section. The materials for which the brands will be updated are specified in the Material Brand Update filter lines. The filter options are:

 

Filter

Value

Material (Class) Type

Commercial Good / Mixed Case / Deposited Item / Fixed Asset / Raw Material / Semi Finished Good / Finished Good / Consumer Good / Material Class (General) / Material Class (With Table)

Material (Class) Code

Group / Range

Material (Class) Description

Group / Range

Material (Class) Aux. Code

Group / Range

Material (Class) Auth. Code

Group / Range

Material (Class) Group Code

Group / Range

Material (Class) Vendor Code

Group / Range

New Brand Code

Group / Range

Configurable Sign

Yes / No

 

 

Material In Warehouse Average Duration Update

 

The option used to update average warehouse duration of the materials. It’s located in the Operations menu of the Material Management section.

 

In order to perform this operation in the LOGO application, first of all By Material Turnover Rate must be selected as the Assignment Type of Price Indices in the Material Management Parameters of the Definitions menu located in the Administration section.

 

The update type Tax is defined in the filter lines. The filter options of the Update Average Warehouse Duration Of Materials operation are:

 

Filter

Value

Material Type

Commercial Good / Mixed Case / Deposited Item / Fixed Asset / Raw Material / Semi Finished Good / Finished Good / Consumer Good

Material Code

Group / Range

Material Description

Group / Range

Parent Material Class Code

Group / Range

Material Aux. Code

Group / Range

Material Auth. Code

Group / Range

Material Vendor Code

Group / Range

Start Date

Date entry

End Date

Date entry

Configurable Sign

Yes / No

 

For the index to be assigned to the material input, the number of days of the Average Warehouse Duration is subtracted from the date of update, and the index at the date found is assigned to the material input lines in batch. This operation can also be used to edit the lines of the material slips posted to G/L.

 

Batch Purchase/Sales Price Entry

 

Purchase and sales prices of materials/material classes and services can be entered individually or in batches using the Purchase/Sales Prices on cards and card lists or the Purchase/Sales Prices options in the Purchasing and Sales sections.

 

Batch price entries are performed using the Batch Purchase/Sales Price Entry option located under the Operations menu of the Material Management section.

 

The fields on the header section of the window are used to record the default information on the price card. This feature facilitates the price list generation transaction significantly. When the header fields are modified, the price card lines entered so far are not touched, and the data entry for any new lines is performed using the new defaults.

 

This is important for the firs line on the Batch Price entry window. If the first line of the price list is blank when the information on the header section of the definition window is modified, in other words if the material (class)/service code is not entered, all the fields on the line are updated according to the header fields.

 

A batch selection is made by accessing the material (class)/service lists while the price list is open, and the selection can be dragged and dropped to the price list. The type information of dragged and dropped material (class)/service cards are also transferred into the price list lines.

 

A memory space is allocated for each price card line entered before the transaction is recorded. Therefore, entering more than 500 records on the price card entry window is not recommended for dynamic memory management.

 

General price card information is recorded on the fields at the top of the batch price entry window. The information to be entered is:

 

Type: Indicates the card type for which the batch purchase or sales price is entered. The field contains the following options:

 

  • Material
  • Material Class
  • Service

 

The related price card type is selected.

 

Card Type: The type of the price card to be generated. This field contains the Purchase and Sales options.

 

AR/AP Code: The AR/AP code for which the entered price will be applied.
Price applications may vary depending on the quantity of service/material purchased/sold or the payment methods. Applying these conditions to the AR/AP transactions after defining them in different prices prevents the loss of time and decreases the error rate.

 

AR/AP Aux. Code: The Aux. Code of the AR/AP. The defined prices can be filtered by the AR/AP Aux. Code, and transferred into the slips and invoices.

 

Group Code: The price group code. Grouping purchase and sales prices provides ease of use. Furthermore, the group code can be used as a filter on reports.

 

Trading Group: Indicates the trading group for which the material price specified in the card will be applied.

 

Start/ End Date and Time: Indicates the date range for which the material price specified in the card will be applied.

 

Payment Plan: This field indicates the payment conditions in which the price will be valid. The Purchase Price may vary depending on the quantity purchased and the payment type. Purchases under a certain amount may be subject to Cash payments, while different prices and payment conditions may be applied for higher amounts. The payment method for the defined price is recorded by selecting a payment plan on the payment plan line.

 

Delivery Code: Indicates the delivery method of the material or service (land, air transport, mail, etc). Delivery Code also indicates how the delivery expenses will be paid. For instance, the Delivery Code field can be used to specify whether or not the transport prices are included in the price bid.

 

VAT %: This field indicates whether or not the specified Unit Price is VAT included.

 

Foreign Currency Type: This field is used to indicate the Currency Type of the price specified on the Unit Price field. The F. Currency Types are listed and the appropriate currency type is selected.

 

Convertible to Other Units: Allows the defined price to be used for other units that are valid for the material/service but that do not constitute a Price. If a unit with no defined unit price is selected in material transactions, the conversion factor specified in the unit price, priority and unit definitions are processed and the amount specified in the price definition is calculated through conversion to the unit used on the slip line.

 

Valid in E-Business Environment: Indicates that the purchase or sales price will be used in E-Business applications.

 

Valid in E-shop: Indicates that the purchase or sales price will be used in E-Shop applications.

 

Valid in Points of Sale: Indicates that the purchase or sales price will be used in points of sale.

 

The lines of the batch price entry window are used to record price information for the material or service. Information entered on the header section of these fields is transferred as default into the line. The information is changed in case of a difference.

 

Vendor Code: Indicates the vendor code of the Material/Material Class. Recorded materials are listed and the related material is selected.

 

Type: Indicates that the price is entered for a material/material class or service. The selection made on the top section of the price entry window is transferred into this field.

 

Code: The code of the material/service for which the price is entered. Recorded material/service definitions are listed and the related definition is selected.

 

Unit: Indicates the unit to which the price will be applied.

 

Unit Price: The unit price of the material/material class or service.

 

VAT: Indicates whether or not the specified price is VAT included. The selection made on the top of the definition window is transferred as default. However, this information can be changed if necessary.

 

F. Currency: Indicates the currency type with which the price is given.

 

Card Type: Indicates that the price is either a purchase or a sales price.

 

Authorization Code: The authorization code of the price.

 

Convertible to Other Units: Allows the defined price to be used for other units that are valid for the material but that do not constitute a Price. If a unit with no defined unit price is selected in material transactions, the conversion factor specified in the unit price, priority and unit definitions are processed and the amount specified in the price definition is calculated through conversion to the unit used on the slip line.

 

Group Code: The price group code. Grouping purchase prices provides ease of use. Furthermore, the group code can be used as a filter on reports.

 

AR/AP Code: The AR/AP code for which the price will be applied.


Price applications may vary depending on the quantity of material or the payment methods. Applying these conditions to the AR/AP transactions after defining them in different prices prevents the loss of time and decreases the error rate.

 

AR/AP Aux. Code: The Aux. Code of the AR/AP. The defined prices can be filtered by the AR/AP Aux. Code, and transferred into the slips and invoices.

 

Payment Plan: This field indicates the payment conditions in which the price will be valid. The Purchase Price may vary depending on the quantity purchased and the payment type. Purchases under a certain amount may be subject to Cash payments, while different prices and payment conditions may be applied for higher amounts. The payment method for the defined price is recorded by selecting a payment plan on the payment plan line.

 

Trading Group: The trading group code for which the price will be applied.

 

Delivery Time: The delivery time of the material. Purchase Prices may vary depending on the delivery times. For example, the prices of certain materials may reflect periodic changes. Specifying the delivery time in the Purchase Price allows the prices to be tracked periodically and different prices to be applied to materials required to be procured immediately.

 

Delivery Code: Indicates the delivery method of the material (land, air transport, mail, etc). The Delivery Code also indicates how the delivery expenses will be paid. For instance, the Delivery Code field can be used to specify whether or not the transport prices are included in the price bid.

 

Priority: The usage priority of the defined price. This field is used to determine which price will be primarily transferred into the slips and invoices in cases that there are multiple Purchase/Sales Prices for the same material/material class. The Priority must be numeric.

 

Start/ End Date and Time: Indicates the time range in which the price will be valid.

 

Condition: The conditions for the price are recorded using parameters. The formulas defined in the Material Sales Prices can include both arithmetical operations and functions. The conditions in which the defined Purchase Price will be used are determined with logical and arithmetical operations. In this way, the transactions are automatically performed, minimizing the usage errors.

Prices per warehouse can be defined using the X1 parameter on the condition field. For instance, if the defined price will be applied for warehouse no. 2;


X1=2

is entered. If the same price will be applied to more than one warehouse, the condition is set as
(X1=[Warehouse Number 1.....Warehouse NumberN]).


By doing so, the slip and invoice lines display the price for which the selected warehouse is specified as the Condition when Defined Unit Price is selected on the Unit Price field.

 

Valid in E-Business Environment: Indicates that the price will be used in E-Business applications.

 

Valid in E-shop: Indicates that the price will be used in E-Shop applications.

 

Accessible at Points of Sale: Indicates that the price can be used in points of sale.

 

Price Description: The detailed description field of the price.

 

Division: Indicates the divisions that the defined price is valid for.  It provides to define prices based on divisions.

 

Price Update Limit: It is the user based price changing limit which determined as percentage or amount for probable changes in predefined material / service price for any reason later on. The users are authorized to change predefined material / service prices at System Administration program part.

 

Material Transaction Transfer

 

Material transaction transfer allows transactions performed with multiple cards with a single material if more than one card is created for whatever reason for the same material. The material transaction transfer option is located under the Operations menu of the Material Management section.

 

The source materials are entered on the material code and description fields, and the target materials are entered on Material to Be Transferred Code and Material to Be Transferred Description fields. Recorded materials are listed on all these fields and the related material is selected.

 

Batch selections can be made using “*” symbol on the material code and description fields. For instance, when M* is entered on the material code field, transactions of all materials of which the code starts with M are transferred into the material specified on the Material to Be Transferred field.

 

Transfer Period Selection

 

Material transactions can be transferred for a specific period or for all periods. Periods are selected on the Periods to Be Transferred field located at the bottom of the material transaction transfer window. Periods defined in the Periods section are listed on the Period Selection window accessed by clicking on (...) icon. “New” option is clicked on the period to be transferred, and the period is transferred into the selected field. All option is used to select all periods.

 

Points to Consider in Transaction Transfer

 

The following points should be considered when transferring material transactions.

 

1. Ensure that the following sections are not used before starting the material transaction transfer and all lists in the following modules are closed:

 

  • Material Management
  • Production Definitions
  • Production Control
  • Planning
  • Demand Management
  • Import/Export
  • Purchase and Sales and Distribution

 

2. If the unit sets of transferred materials are different, the main units are processed during the transfer. Transactions using units other than the main unit are not processed for materials with different unit sets.

 

3. If any of the inter-connected slips (order dispatch, dispatch invoice, invoice/dispatch returns, etc) contains transactions other than the main unit, the related transactions are not transferred. For instance; if an order of 200 pieces is transferred to the dispatch as 20 boxes, the order and the dispatch are not transferred.

 

4. Material type control is performed during the transfer.

 

  • Deposited material transactions can be transferred into a material of the same type.
  • Fixed Asset material transactions are transferred into materials of the same type.
  • Consumption Good material transactions are transferred into materials of the same type.
  • Type control is not performed for SFG and Finished Good materials.
  • Type control is not performed for commercial goods and raw materials.
  • Transfers are not performed for material class (general), material class (with table) and mixed case materials.

 

5. Child materials are not transferred for material classes (with table).

 

6. If the material to be transferred is part of a material class, the unit sets of this material class and the new material must be the same. The transfer is not allowed if the unit is not the same. If the new material does not belong to the related material class, a class connection is established for the new material. If the transfer is to be made even if the units are different, the user will have to remove the material class connection of the old material.

 

Matching Material Input/Output Transactions

 

Matching of Material Input / Output Transactions option is used concerning the transactions in the scope of Free Zone Computer Application Program.

 

By this operation, each output item, which is not below the negative inventory level, is matched with an input transaction. When the operation is started, the application warns the user for the items with negative inventory level.

 

The necessary conditions for the operation are specified filter lines. The filter options are:

 

Filter

Value

Date Range

Start / End

Material Type

Commercial Good / Mixed Case / Deposit Item / Fixed Asset / Raw Material / Semi Finished Good / Finished Good / Consumer Good

Material Code

Group / Range

Material Description

Group / Range

Parent Material Class Code

Selection from list

Material Aux. Code

Group / Range

Material Auth. Code

Group / Range

Material Vendor Code

Group / Range

Material Unit Set Code

Group / Range

Material Add. Tax Code

Group / Range

Material Add. Tax Group Code

Group / Range

Configurable Sign

Yes / No

Variant Code

Group / Range

Variant Description

Group / Range

Variant Aux. Code

Group / Range

 

 

Material Production Inputs Level Update

 

Material production inputs level update is an operation which is used to calculate materials’ production levels and to perform posting transactions according to this calculation. The option is located under the Operations menu of Material Management program section. The operation’s filter options are:

 

Date: The calculation is done according to the production receipt belonging to the specified date in filter line.

 

Plant: When calculating production level, the production receipts are taken into consideration belonging to the specified plant in filter line.

 

The calculated value is written to the “Production Input Level” field of the material records’ “General Info” tab.

 

Material Remittance

 

Remittance Transaction is used to assign materials as fixed assets by performing transfers between materials when a part or entire of materials purchased for a different purpose are required to be used as fixed asset, and perform quantity/stock transfer between materials.

 

Stock quantity of materials is updated by performing input-output transactions between materials subject to remittance transaction, and a stock transfer is provided between materials.

 

Material Remittance is located under Operations menu of Material Management module.

 

Date and time information is entered in Date and Time fields located at the upper section of Material Remittance window in order to specify date and time of slips to be generated. Division, plant and warehouse information of materials which will be used or transferred to are recorded in the upper section as well.

 


 

Material Code / Description: Materials which will be used/transferred are specified in these fields. Recorded material definitions are listed in both of these fields, and the relevant material is selected.

 

Variant Code / Description: If material to be used/transferred is configurable, variant of the relevant material is selected in these fields. Material variant definitions are listed by clicking on “…” icon located on these fields, and the required variant is selected.

 

Quantity: It indicates the quantity of material to be used/transferred. 

 

Unit: The unit over which material to be used/transferred will be processed is specified in this field.

 

Warehouse: It indicates warehouse from which material to be used/transferred is withdrawn.

 

Transfer To (Material Code) / Transfer To (Material Description): Material to which the main material will be transferred is specified in these fields. Recorded material definitions are listed in both fields and the relevant material is selected.

 

Transfer To (Variant Code / Description): If the material to which the main material will be transferred is configurable, material variant is selected in these fields. Material variant definitions are listed by clicking on “…” icon located on these fields, and the required variant is selected.

 

Transferred Quantity: It indicates the quantity of transferred material.

 

Transferred In (Unit): It indicates the unit in which material will be transferred.

 

Transfer To (Warehouse): It indicates warehouse to which material will be transferred.  

 

After entering the required information, Usage Slip is generated for used/transferred materials and Input from Production slip is generated for materials to which the main material will be transferred by using “Transfer” button.

 

A mark is put at the heading of these slips in order to indicate that they are generated as a result of material remittance transaction. This field can not be changed.

 

When one of the relevant slips is required to be deleted, the application warns by displaying “This slip is related to remittance transaction. Relation will be broken,” message. If you approve this message by selecting “Yes” option, remittance mark of the relevant slip is removed. If you disapprove by selecting “No” option, slip is not deleted.

 

 

 

Material Management Reports

 

  • Records and Assignments Lists
  • Summary Reports
  • Slip Lists & Extracts
  • Lot / Serial Number Reports
  • Cost Reports
  • Query Assistant Reports 

 

 

Records and Assignments Lists

 

The reports under this option are:

 

Unit Sets List

 

This report is located in the Records and Assignments List menu of the Material Management section and is used to list the defined Unit Sets. The Unit Sets matching the specified definition are listed by using a group or range filter in the Unit Set Code, Description, Aux. Code and Authorization Code lines. The filter options of the Unit Sets list are:

 

Filter

Value

Unit Set Code

Group / Range

Unit Set Description

Group / Range

Unit Set Aux. Code

Group / Range

Unit Set Auth. Code

Group / Range

Unit Set Type

User Defined / Length / Area/ Volume / Weight

Unit Set Usage Condition

General / For Material - Service

Unit Code

Group / Range

Unit Description

Group / Range

Dimension Units

Width Unit

Length Unit

Height Unit

Area Unit

Volume Unit

Weight Unit

Select from the List

Select from the List

Select from the List

Select from the List

Select from the List

Select from the List

Listing Method

By Unit Sets / By Units

Unit Set Content (Units)

List / Do Not List

Unit Dimensions

List / Do Not List

Conversion Factors of Unit Sets

List / Do Not List

 

 

Characteristics List

 

This list is located in the Records and Assignments List menu of the Material Management section and is used to list the defined Material Characteristics. The Material Characteristics matching the specified definition are listed by using a group or range filter in the Material Characteristic Code, Description, Aux. Code and Authorization Code lines. The filter options are:

 

Filter

Value

Material Characteristic Code

Group / Range

Material Characteristic Description

Group / Range

Material Characteristic Aux. Code

Group / Range

Material Characteristic Auth. Code

Group / Range

Material Characteristic Values

List / Do Not List

Material Characteristic Value

Group / Range

Material Characteristic Value Description

Group / Range

 


 

Material (Class) List

 

This list is located in the Records and Assignments List menu of the Material Management section and is used to list the defined material classes. The material classes matching the specified definition are listed by using a group or range filter in the Material Class Code, Description, Aux. Code, Auth. Code, Vendor Code and Group Code lines. The Material Class List filter options are:

 

Filter

Value

Material (Class) Type

(MT) Material Class (With Table) / (MC) Material Class (General) / (RM) Raw Material / (SF) Semi Finished Good / (FG) Finished Good / (CG) Commercial Good / (MX) Mixed Case / (DI) Deposited Item / (COG) Consumer Good

Material (Class) Status

Active / Passive

Material (Class) Code

Group / Range

Material (Class) Description

Group / Range

Material (Class) Aux. Code

Group / Range

Material (Class) Authorization Code

Group / Range

Material (Class) Vendor Code

Group / Range

Material (Class) Group Code

Group / Range

Material (Class) Characteristics

Characteristic  1-10 (Characteristic Code / Characteristic Values)

Parent Material Class Code

Select from the List

Unit Set Code

Group / Range

Unit Set Description

Group / Range

Tracking Method

Do Not Track / With Tracking Lot (Serial) Number / With Tracking Serial Number

Location Tracking

Checked / Not Checked

Purchase VAT Rate (%)

VAT rate

Sales VAT Rate (%)

VAT rate

Return VAT Rate (%)

VAT rate

Usage Point

Material Management / Purchasing / Sales and Distribution

Tool Flag

Items With Tool Flag / Items Without Tool Flag

Plant Parameters

List / Do Not List

Plants

Defined Plants

Warehouse info Details

List / Do Not List

Warehouses

Defined warehouses

Mixed Case Details

List / Do Not List

 

 

Material Units List

 

This list is located in the Records and Assignments List menu of the Material Management section and is used to generate the Unit Sets used in material (class) records by materials.

 

The material units matching the specified definition are listed by using a group or range filter in the Material Class Code, Description, Aux. Code, Auth. Code, Vendor Code and Group Code lines. The Material Units List filter options are:

 

Filter

Value

Material (Class) Type

(MT) Material Class (With Table) / (MC) Material Class (General) / (RM) Raw Material / (SF) Semi Finished Good / (FG) Finished Good / (CG) Commercial Good / (MX) Mixed Case / (DI) Deposited Item / (COG) Consumer Good

Material (Class) Status

Active / Passive

Material (Class) Code

Group / Range

Material (Class) Description

Group / Range

Material (Class) Aux. Code

Group / Range

Material (Class) Auth. Code

Group / Range

Material (Class) Vendor Code

Group / Range

Material (Class) Group Code

Group / Range

Material (Class) Characteristics

Characteristic  1-10 (Characteristic Code / Characteristic Values)

Parent Material Class Code

Select from the List

Unit Code

Group / Range

Unit Description

Group / Range

Unit Set Code

Group / Range

Unit Set Description

Group / Range

Barcode

Group / Range

Divisible Flag

Checked / Not Checked

Priority Degree - Material Management

Group / Range

Priority Degree - Purchasing

Group / Range

Priority Degree - S&D

Group / Range

Usage Point

Material Management / Purchasing / Sales and Distribution

Width Unit

Select from List - Group

Length Unit

Select from List - Group

Height Unit

Select from List - Group

Gross Weight Unit

Select from List - Group

Net Weight Unit

Select from the List

Area Unit

Select from the List

Net Volume Unit

Select from the List

Gross Volume Unit

Select from the List

 


 

Alternative Materials List

 

This list is located in the Records and Assignments List menu of the Material Management section and used to list the alternatives of the materials. The alternative materials specified in the material (class) records are listed by the defined filters.

 

The alternative materials matching the specified definition are listed by using a group or range filter in the Material Code, Description, Aux. Code, Auth. Code, Vendor Code and Group Code lines. The Alternative Materials List filter options are:

 

Filter

Value

Material Type

(RM) Raw Material / (SF) Semi Finished Good / (FG) Finished Good / (CG) Commercial Good / (DI) Deposited Item / (COG) Consumer Good

Material Status

Active / Passive

Material Code

Group / Range

Material Description

Group / Range

Material Aux. Code

Group / Range

Material Authorization Code

Group / Range

Material Vendor Code

Group / Range

Material Group Code

Group / Range

Material (Class) Characteristics

Characteristic 1-10 (Characteristic Code / Characteristic Values)

Alternative Material Code

Group / Range

Parent Material Class Code

Select from the list

Alternative Material Description

Group / Range

Usage Private

Direct data entry

Start Date Range

Start / End

End Date Rage

Start / End

Minimum Quantity

Direct data entry

Maximum Quantity

Direct data entry

 

 

Optional Materials List

 

This report option is located in the Records and Assignments List menu of the Material Management section and is used to list the defined Optional Materials. The Optional Materials List filter options are:

 

Filter

Value

Optional Material Code

Group / Range

Optional Material Description

Group / Range

Optional Material Aux. Code

Group / Range

Optional Material Auth. Code

Group / Range

Material (Class) Type

(MT) Material Class (With Table) / (MC) Material Class (General) / (RM) Raw Material / (SF) Semi Finished Good / (FG) Finished Good / (CG) Commercial Good / (MX) Mixed Case / (DI) Deposited Item / (COG) Consumer Good

Material (Class) Status

Active / Passive

Material (Class) Code

Group / Range

Material (Class) Description

Group / Range

Material (Class) Aux. Code

Group / Range

Material (Class) Authorization Code

Group / Range

Material (Class) Vendor Code

Group / Range

Material (Class) Group Code

Group / Range

Material (Class) Characteristics

Characteristic  1-10 (Characteristic Code / Characteristic Values)

Parent Material Class Code

Group / Range

Optional Material Code

Group / Range

Optional Material Description

Group / Range

Optional Material Unit

Unit Set / Unit

 

 

Characteristic Assignments List

 

This report option is located in the Records and Assignments List menu of the Material Management section and is used to characteristics definitions used in Material records by materials. The Characteristic Assignments List filter options are:

 

Filter

Value

Listing Method

By Material Code / By Characteristic Code

Material (Class) Type

(MT) Material Class (with table) / (RM) Raw Material /(SG) Semi Finished Good / (FG) Finished Good / (CG) Commercial Good / (MX) Mixed Case / (DI) Deposited Item / (FA) Fixed Asset / (COG) Consumer Good

Material (Class) Status

Active / Passive

Material (Class) Code

Group / Range

Material (Class) Description

Group / Range

Material (Class) Aux. Code

Group / Range

Material (Class) Auth. Code

Group / Range

Material (Class) Vendor Code

Group / Range

Material (Class) Group Code

Group / Range

Parent Material Class Code

Select from the List

Material Characteristic Code

Group / Range

Material Characteristic Description

Group / Range

Material Characteristic Aux. Code

Group / Range

Material Characteristic Auth. Code

Group / Range

Material Characteristic Values

List / Do Not List

Material Characteristic Value

Direct data entry

Material Characteristic Value Description

Direct data entry

 

 

G/L Account Assignments List

 

This report option is located in the Records and Assignments List menu of the Material Management section and is used to list the G/L Account codes to be used to track the material transactions by materials after being posted to G/L. The G/L account Assignments List filter options are:

 

Filter

Value

Material (Class) Type

(MT) Material Class (With Table) / (MC) Material Class (General) / (RM) Raw Material / (SF) Semi Finished Good / (FG) Finished Good / (CG) Commercial Good / (MX) Mixed Case / (DI) Deposited Item / (COG) Consumer Good

Material (Class) Status

Group / Range

Material (Class) Code

Group / Range

Material (Class) Description

Group / Range

Material (Class) Aux. Code

Group / Range

Material (Class) Auth. Code

Group / Range

Material (Class) Vendor Code

Group / Range

Material (Class) Group Code

Group / Range

Material (Class) Characteristics

Characteristic 1 - 10 Characteristic Code / Characteristic Values

Parent Material Class Code

Group / Range

Purchases Account

Group / Range

Other Input G/L Codes

Group / Range

Sales Account

Group / Range

Other Outputs

Group / Range

Usages

Direct data entry

Scraps

Direct data entry

Input from Production

Direct data entry

User Defined Inputs

Group / Range

User Defined Outputs

Group / Range

Purchase Returns

Group / Range

Sales Returns

Group / Range

Purchase Discounts

Group / Range

Sales Discounts

Group / Range

Purchase Surcharges

Group / Range

Sales Surcharges

Group / Range

Promotions Received

Group / Range

Sales Promotions

Group / Range

Promotion VAT Expenses

Group / Range

Accounts to List

Purchases Account / Other Inputs G/L Codes / Sales Accounts / Other Outputs / Usages / Scraps / Input from Production / User Defined Inputs / User Defined Outputs / Purchase Returns / Sales Returns / Purchase Discount / Sales Discounts / Purchase Surcharges / Sales Surcharges / Promotion Received / Sales Promotions / Promotion VAT Expenses / Profit/Loss on Sales / Depreciation and Depletion Portions / Revaluations / Deferred VAT / Accumulated Depreciations / Fixed Asset Expenses / Cycle Count (+) Account / Cycle Count (-) Account / Cost of Good Sales / Price Difference / Quantity Difference / Transfer / Add. Tax Deferred / Purchase Price Diff. / Sales Price Diff. / International Sales

Report Page Layout

Print All Materials On Different Page / Print All Material By Turns

 

 

Class Connections List

 

This report option is located in the Records and Assignments List menu of the Material Management section and is used to list the classes of the material. The Class Connections List filter options are:

 

Filter

Value

Listing Method

By Child Material / By Parent Material Class

Material (Class) Type

(MT) Material Class (With Table) / (MC) Material Class (Not Table) / (RM) Raw Material / (SG) Semi Finished Good / (FG) Finished Good / (CG) Commercial Good / (MX) Mixed Case / (DI) Deposited Item / (FA) Fixed Asset / (COG) Consumer Good

Material (Class) Status

Active / Passive

Material (Class) Code

Group / Range

Material (Class) Description

Group / Range

Material (Class) Aux. Code

Group / Range

Material (Class) Auth. Code

Group / Range

Material (Class) Vendor Code

Group / Range

Material (Class) Characteristics

Characteristic 1 - 10 Characteristic Code / Characteristic Values

Parent Material Class Code

Group / Range

Parent Material Class Definition

Group / Range

Child Material (Class) Code

Group / Range

Child Material (Class) Description

Group / Range

 

 

Supplier/Customer Assignments List

 

This report option is located in the Records and Assignments List menu of the Material Management section and is used to list the Supplier/Customer Records by Material (Class) Records. The report filter options are:

 

Filter

Value

Material (Class) Type

(MT) Material Class (With Table) / (MC) Material Class (Not Table) / (RM) Raw Material / (SG) Semi Finished Good / (FG) Finished Good / (CG) Commercial Good / (MX) Mixed Case / (DI) Deposited Item / (FA) Fixed Asset / (COG) Consumer Good

Material (Class) Status

Active / Passive

Material (Class) Code

Group / Range

Material (Class) Description

Group / Range

Material (Class) Aux. Code

Group / Range

Material (Class) Auth. Code

Group / Range

Material (Class) Vendor Code

Group / Range

Material (Class) Group Code

Group / Range

Material (Class) Characteristics

Characteristic 1 - 10 Characteristic Code / Characteristic Values

Parent Material Class Code

Direct data entry / Group

Assignment Type

Customer / Supplier

AR/AP Code

Group / Range

AR/AP Title

Group / Range

Trading Group

Group / Range

Customer / Supplier Code

Group / Range

Customer / Supplier Description

Group / Range

Delivery / Procurement Time

Direct data entry

In Case Of Insp. Criteria Not Specified

User Proceed Assignments / User Warning Assignments / User Block Assignments 

Listing Method

Material Code (Verbal) / By AR/AP Code

Type

By AR/AP / By Trading Group

 

 

Distribution Templates List

 

This report option is located in the Records and Assignments List menu of the Material Management section and is used to list the distribution templates. The report filter options are:

 

Filter

Value

Material Class Status

Active / Passive

Material Class Code

Group / Range

Material Class Description

Group / Range

Material Class Aux. Code

Group / Range

Material Class Auth. Code

Group / Range

Material Class Vendor Code

Group / Range

Material Class Group Code

Group / Range

Parent Material Class Code

Select from the list

Distribution Template Code

Group / Range

Distribution Template Description

Group / Range

Distribution Template Aux. Code

Group / Range

Distribution Template Auth. Code

Group / Range

Distribution Template Start Date

Start / End

Report Unit

Unit Set / Unit

Distribution Lines

List / Do Not List

Child Material Code

Group / Range

Child Material Description

Group / Range

Listing Method

By Material Class Code / By Distribution Template Code

 

 

Bill of Materials / Material Relations List

 

This report option is located in the Records and Assignments List menu of the Material Management section and is used to list the materials used in Bill of Materials. The report filter options are:

 

Filter

Value

Material (Class) Type

(MT) Material Class (with table) / (MC) Material Class (Without Table) / (FG) Finished Good / (SF) Semi Finished Good

Material (Class) Status

Active / Passive

Material (Class) Code

Group / Range

Material (Class) Description

Group / Range

Material (Class) Aux. Code

Group / Range

Material (Class) Authorization Code

Group / Range

Material (Class) Group Code

Group / Range

Material (Class) Characteristics

Characteristic 1 - 10 Characteristic Code / Characteristic Values

Parent Material Class Code

Select from the List

Bill of Materials Code

Group / Range

Bill of Materials Description

Group / Range

Bill of Materials Aux. Code

Group / Range

Bill of Materials Auth. Code

Group / Range

Start Date Range

Start / End

Priority

Group / Range

Minimum Quantity

Group / Range

Maximum Quantity

Group / Range

Plant No.

Defined plants

Standard Cost

Yes / No

Planning

Yes / No

 

 

Additional Tax List

 

This report option is located in the Records and Assignments List menu of the Material Management section and is used to list the recorded Add. Tax definitions. The report includes the Add. Tax Group Code, Add. Tax Code and Add. Tax Description and lists the Add. Tax definitions within a certain time range. The Add. Tax List filter options are:

 

Filter

Value

Additional Tax Group Code

Group / Range

Additional Tax Code

Group / Range

Additional Tax Description

Group / Range

Start Date

Date Range

Line Type

Rate / Amount / Rate + Amount

Unit Type

Quantity / Width / Length / Height / Area / Net Volume / Net Weight / Gross Volume / Gross Weight

Rate

Value entry

Amount

Value entry

Rate To Be Collected

Rate range

Amount To Be Collected

Amount range

Exception Rate

Rate range

Exception Amount

Amount range

Unit Set Code

Group / Range

Unit Code

Group / Range

 

 

Finished Good Child Materials List

 

This report option is located in the Records and Assignments List menu of the Material Management section and used to list the finished good child materials. The Finished Good Child Materials filter options are:

 

Filter

Value

Material Type

Mixed Case / Finished Good

Material Code

Group / Range

Material Description

Group / Range

Material Aux. Code

Group / Range

Material Vendor Code

Group / Range

Material Group Code

Group / Range

Parent Material Class Code

Group / Range

Child Materials

List / Do Not List

Child Material Code

Group / Range

Child Material Description

Group / Range

Child Material Aux. Code

Group / Range

 

 

Summary Reports


The reports under this option are:

 

Material Summary Report

 

This report is located in the Status Reports menu of the Material Management section and is used to list the physical and actual quantity of materials in a given date and the quantity of consignments received and issued. The report filter options are:

 

Filter

Value

Material (Class) Type

(MT) Material Class (With Table) / (MC) Material Class / (RM) Raw Material / (SG) Semi Finished Good / (FG) Finished Good / (CG) Commercial Good / (MX) Mixed Case / (DI) Deposited Item / (FA) Fixed Asset / (COG) Consumer Good

Material (Class) Status

Active / Passive

Material (Class) Code

Group / Range

Material (Class) Description

Group / Range

Material (Class) Aux. Code 1-5

Group / Range

Material (Class) Auth. Code

Group / Range

Material (Class) Vendor Code

Group / Range

Material (Class) Group Code

Group / Range

Material (Class) Characteristics

Characteristic 1 - 10

Characteristic Code / Characteristic Values

Parent Material Class Code

Direct data entry

Main Unit Code

Unit Set / Unit

Warehouse Totals

Combined / Not Combined

Warehouses

Defined warehouses

Last Transaction Date

Date entry

Has No Transactions

Will Not Be Listed / Will Be Listed

Listing Method

By Materials / By Warehouses

Purchase Orders

Direct data entry

Received Orders

Direct data entry

Purchase Quantity

Direct data entry

Planned Inputs from Production

Direct data entry

Actual Production Inputs

Direct data entry

Planned Warehouse Inputs

Direct data entry

Actual Warehouse Inputs

Direct data entry

Planned Other Inputs

Direct data entry

Actual Other Inputs

Direct data entry

Opening Amount

Direct data entry

Consignments Received

Direct data entry

Sales Orders

Direct data entry

Delivered Orders

Direct data entry

Sales Quantity

Direct data entry

Planned Usages and Scraps

Direct data entry

Actual Usage and Scraps

Direct data entry

Planned Warehouse Outputs

Direct data entry

Actual Warehouse Outputs

Direct data entry

Planned Other Outputs

Direct data entry

Actual Other Outputs

Direct data entry

Real Inventory

Direct data entry

Consignments Issued

Direct data entry

Reserved Quantity

Direct data entry

Physical Inventory

Direct data entry

 

 

Material Value Report

 

This report is located in the Status Reports menu of the Material Management section and used to list the material value (total amount) on hand at a given date in accordance with the filter lines. The Material Value Report filter options are:

 

Filter

Value

Material (Class) Type

(MT) Material Class (With Table) / (MC) Material Class / (RM) Raw Material / (SG) Semi Finished Good / (FG) Finished Good / (CG) Commercial Good / (MX) Mixed Case / (DI) Deposited Item / (FA) Fixed Asset / (COG) Consumer Good

Material (Class) Status

Active / Passive

Material (Class) Code

Group / Range

Material (Class) Description

Group / Range

Material (Class) Aux. Code 1-5

Group / Range

Material (Class) Auth. Code

Group / Range

Material (Class) Vendor Code

Group / Range

Material (Class) Group Code

Group / Range

Material (Class) Characteristics

Characteristic 1 - 10

Characteristic Code / Characteristic Values

Parent Material Class Code

Direct data entry / Group

Warehouse Totals

Combine / Do Not Combine

Warehouses

Defined warehouses

Listing Method

By Materials / By Warehouses

Main Unit Code

Unit Set / Unit

Last Transaction Date

Date Entry / Selection

Total Value Calculation Method

Average Value / From First Purchase / From First Sales / Last Purchase / Last Sales / Over User Defined Purchase Price / Over User Defined Sales Price / Over Purchase Price Group Code / By Sales Price Group Code

Has No Transactions

List / Do Not List

Average Value Calculation

On Actual Inventory Quantity / On Physical Inventory Quantity

Purchase Price

Price entry

Sales Price

Price entry

RD Exchange Rate

Exchange Rate entry

Purchase Price Group Code

Group / Range

Sales Price Group Code

Group / Range

Applied Discounts and Surcharges

Process / Do Not Process

 

 

Level Control Report

 

This report is located in the Status Reports menu of the Material Management section. The materials exceeding or falling below the Minimum or Maximum Level Quantity specified in the Material record can be listed separately or together in the Level Control Report. This report allows the inspection of material sales in specific periods and a healthy order planning. The report filters are:

 

Filter

Value

Material (Class) Type

(MT) Material Class (With Table) / (MC) Material Class / (RM) Raw Material / (SG) Semi Finished Good / (FG) Finished Good / (CG) Commercial Good / (MX) Mixed Case / (DI) Deposited Item / (FA) Fixed Asset / (COG) Consumer Good

Material (Class) Status

Active / Passive

Material (Class) Code

Group / Range

Material (Class) Description

Group / Range

Material (Class) Aux. Code

Group / Range

Material (Class) Auth. Code

Group / Range

Material (Class) Vendor Code

Group / Range

Material (Class) Group Code

Group / Range

Material (Class) Characteristics

Characteristic 1 - 10

Characteristic Code / Characteristic Values

Parent Material Class Code

Direct data entry / Group

Warehouses

Defined warehouses

Warehouse Totals

Combined / Not Combined

Main Unit

Unit Set / Unit

Material Level

All / Below Minimum Level / Above Maximum Level / Below Safety Inventory Level

Last Transaction Date

Date entry

Listing Method

By Materials / By Warehouses

Level Control Not Used

List / Do Not List

 

 

Material Summary Report  (Multi Unit)

 

The report used to display the material status by selecting more than one unit from the unit set. The report option is located in the Status Reports option of the Material Management section. The report filter options are:

 

Filter

Value

Material (Class) Type

(MT) Material Class (With Table) / (MC) Material Class / (RM) Raw Material / (SG) Semi Finished Good / (FG) Finished Good / (CG) Commercial Good / (MX) Mixed Case / (DI) Deposited Item / (FA) Fixed Asset / (COG) Consumer Good

Material (Class) Status

Active / Passive

Material (Class) Code

Group / Range

Material (Class) Description

Group / Range

Material (Class) Aux. Code

Group / Range

Material (Class) Auth. Code

Group / Range

Material (Class) Vendor Code

Group / Range

Material (Class) Group Code

Group / Range

Material (Class) Characteristics

Characteristic 1 - 10

Characteristic Code / Characteristic Values

Parent Material Class Code

Direct data entry / Group

Unit Sets

Unit Set / Unit (1,2,3)

Warehouses

Defined warehouses

Last Transaction Date

Date entry

Has No Transactions

Will not Be Listed / Will Be Listed

Purchase Orders

Quantity Range

Received Orders

Quantity Range

Purchase Quantity

Quantity Range

Consignments Received

Quantity Range

Sales Orders

Quantity Range

Delivered Orders

Quantity Range

Sales Quantity

Quantity Range

Real Inventory

Quantity Range

Consignments Issued

Quantity Range

Physical Inventory

Quantity Range

 

 

Material Class Totals

 

The report used to list the material class totals.  The report option is located in the Status Reports option of the Material Management section. The report filter options are:

 

Filter

Value

Material Code

Group / Range

Material Description

Group / Range

Material Aux. Code

Group / Range

Material Auth. Code

Group / Range

Unit Code

Group / Range


 

Slip Lists and Extracts


The reports under this option are:

 

Slip List


The report option is located in the Slip Lists and Extracts menu of the Material Management section and is used to record the material transactions and list the slips. The filter options of the Slip List report are:

 

Filter

Value

AR/AP Code

Group / Range

AR/AP Title

Group / Range

AR/AP Status

Active / Passive

Trading Group

Group / Range

Slip Number

Group / Range

Slip Document Number

Group / Range

Slip Status

Actual / Planned

Slip Aux. Code

Group / Range

Slip Dates

Start / End

Slip Type

(01) Purchase Receipt / (02) Retail Sales Return Dispatch / (03) Wholesale Return Receipt / (04) Consignment Return Dispatch / (05) Consignment Receipt / (06) Purchase Return Receipt / (07) Retail Sales Dispatch / (08) Wholesale Receipt / (09) Consignment Dispatch / (10) Consignment Return Receipt / (11) Scrap Slip / (12) Usage Slip / (13) Input From Production Slip / (14) Opening Slip / (25) Warehouse Transfer Slip / (26) Producer Slip / (50) Cycle Count Slip (Excess) / (51) Cycle Count Slip (Deficit)

Warehouse Slip Type

All / Generated From Material Slips / Generated From Nationalization Slip

Cancellation Status

Not Cancelled Slips / Cancelled Slips

Dispatch/Receipt

Unbilled Disp./Rec. / Billed Disp./Rec.

Dispatch/Receipt Status

Actual / Proposal

Dispatch/Receipt Shipping Status

Not Shipped / Shipped

Material Slip Status (Warehouse Slips)

Actual / Proposal

Output Department

Defined departments

Output Division

Defined divisions

Source Warehouse

Defined warehouses

Output Plant

Defined plants

Input Department

Defined departments

Input Division

Defined divisions

Destination Warehouse

Defined warehouses

Output Work Station Code

Group / Range

Output Work Station Description

Group / Range

Output Work Station Auth. Code

Group / Range

Output Work Station Aux. Code

Group / Range

Input Plant

Defined plants

Input Work Station Code

Group / Range

Input Work Station Description

Group / Range

Input Work Station Aux. Code

Group / Range

Input Work Station Auth. Code

Group / Range

Project Code

Group / Range

Project Description

Group / Range

Invoice Auth. Code

Group / Range

AR/AP Auth. Code

Group / Range

Remittance Connection

Yes / No

Shipment Address Code

Group / Range

Shipment Address Description

Group / Range

 

 

Transaction List

 

The report option is located in the Slip Lists and Extracts menu of the Material Management section and is used to list the slip lists of the material transactions in detail. The report filter options are:

 

Filter

Value

Material (Class) Type

(MT) Material Class (With Table) / (MC) Material Class / (RM) Raw Material / (YM) Semi Finished Good / (FG) Finished Good / (CG) Commercial Good /  (MX) Mixed Case / (DI) Deposited Item / (FA) Fixed Asset / (COG) Consumer Good

Material (Class) Status

Active / Passive

Material (Class) Code

Group / Range

Material (Class) Description

Group / Range

Material (Class) Aux. Code

Group / Range

Material (Class) Auth. Code

Group / Range

Material (Class) Vendor Code

Group / Range

Material (Class) Group Code

Group / Range

Material (Class) Characteristics

Characteristic 1 - 10

Characteristic Code / Characteristic Values

Parent Material Class Code

Select from the List

Material Tracking Method

No Tracking / Lot / Serial

Transaction G/L Code

Group / Range

Transaction Aux. Code

Group / Range

Transaction Type

Material Transactions /  Promotion Transaction / Deposit Transaction / Mixed Case Transaction / Fixed Asset Transaction / Material Class Transaction

AR/AP Code

Group / Range

AR/AP Title

Group / Range

AR/AP Status

Active / Passive

Slip Type

(01) Purchase Receipt / (02) Retail Sales Return Dispatch / (03) Wholesale Return Receipt / (04) Consignment Return Dispatch / (05) Consignment Receipt / (06) Purchase Return Receipt / (07) Retail Sales Dispatch / (08) Wholesale Receipt / (09) Consignment Dispatch / (10) Consignment Return Receipt / (11) Scrap Slip / (12) Usage Slip / (13) Input From Production Slip / (14) Opening Slip / (25) Warehouse Transfer Slip / (26) Producer Slip / (50) Cycle Count Slip (Excess) / (51) Cycle Count Slip (Deficit)

Warehouse Slip Type

All / Generated From Material Slips / Generated From Nationalization Slip

Slip Status

Actual / Planned

Slip Number

Group / Range

Slip Document Number

Group / Range

Slip Aux. Code

Group / Range

Slip Dates

Start / End

Cancellation Status

Not cancelled slips / Cancelled slips

Dispatch/Receipt

Unbilled Dispatch/Receipt / Billed Dispatch/Receipt

Dispatch/Receipt Status

Actual / Proposal

Material Slip Status (Warehouse Slips)

Actual / Proposal

Plants

Defined plants

Departments

Defined departments

Divisions

Defined divisions

Warehouses

Defined warehouses

Workstation Code

Group / Range

Workstation Description

Group / Range

Workstation Aux. Code

Group / Range

Workstation Auth. Code

Group / Range

Pricing Currency Type

Currency options

Report Unit

Unit Set / Unit

Units

Convert To Main Unit / Convert To Report Unit / List By Unit In Transaction

Width Unit

Select from the List

Length Unit

Select from the List

Height Unit

Select from the List

Weight Unit

Select from the List

Area Unit

Select from the List

Volume Unit

Select from the List

Material Class Details

List / Do Not List

Lot Number

Group / Range

Lot Description

Group / Range

Serial Number

Group / Range

Serial Description

Group / Range

Serial Group No.

Group / Range

Serial Group Description

Group / Range

Expiry Date

Start / End

Location Code

Group / Range

Salesperson Code

Group / Range

Salesperson Description

Group / Range

Salesperson Position Code

Group / Range

Salesperson Status

Active / Passive

Unit Set Code

Group / Range

Unit Set Description

Group / Range

Unit Set Aux. Code

Group / Range

Unit Set Auth. Code

Group / Range

Line Barcode

Group / Range

Unit Code

Group / Range

Unit Description

Group / Range

Input From Production Tracking No.

Group / Range

Project Code

Group / Range

Project Description

Group / Range

Remittance Connection

Yes / No

Shipment Address Code

Group / Range

Shipment Address Description

Group / Range

 

 

Input / Output Totals

 

The report option is located in the Slip Lists and Extracts menu of the Material Management section and is used to summarize the Material Transactions for given periods. The filtering is done by Material (Class) Type and Material Transactions and the Input/Output Totals are reported in the desired date range. The Input/Output Totals report filter options are:

 

Filter

Value

Listing Method

By Materials / By Warehouses

Slip Dates

Start / End

Material (Class) Type

(MT) Material Class (With Table) / (MC) Material Class / (RM) Raw Material / (YM) Semi Finished Good / (FG) Finished Good / (CG) Commercial Good /  (MX) Mixed Case / (DI) Deposited Item / (FA) Fixed Asset / (COG) Consumer Good

Material (Class) Status

Active / Passive

Material (Class) Code

Group / Range

Material (Class) Description

Group / Range

Material (Class) Aux. Code 1-5

Group / Range

Material (Class) Auth. Code

Group / Range

Material (Class) Vendor Code

Group / Range

Material (Class) Group Code

Group / Range

Material (Class) Characteristics

Characteristic 1 - 10

Characteristic Code / Characteristic Values

Parent Material Class Code

Direct data entry

Material Tracking Method

No Tracking / Lot / Serial

Report Unit

Unit Set Code / Unit

Units

Group / Range

Transaction Type

Material Transaction / Promotion Transaction / Deposit Transaction / Mixed Case Transaction / Fixed Asset Transaction / Material Class Transaction

Transaction G/L Code

Group / Range

Overhead Pool Code

Group / Range

Transaction Aux. Code

Group / Range

AR/AP Code

Group / Range

AR/AP Title

Group / Range

AR/AP Status

Active / Passive

AR/AP Aux. Code 1-5

Group / Range

Trading Group

Group / Range

Slip Type

(01) Purchase Receipt / (02) Retail Sales Return Dispatch / (03) Wholesale Return Receipt / (04) Consignment Return Dispatch / (05) Consignment Receipt / (06) Purchase Return Receipt / (07) Retail Sales Dispatch / (08) Wholesale Receipt / (09) Consignment Dispatch / (10) Consignment Return Receipt / (11) Scrap Slip / (12) Usage Slip / (13) Input From Production Slip / (14) Opening Slip / (25) Warehouse Transfer Slip / (26) Producer Slip / (50) Cycle Count Slip (Excess) / (51) Cycle Count Slip (Deficit)

Warehouse Slip Type

All / Generated from Material Slips / Generated from Nationalization Slip

Slip Number

Group / Range

Slip Aux. Code

Group / Range

Departments

Defined departments

Divisions

Defined divisions

Warehouses

Defined warehouses

Plants

Defined plants

Cancellation Status

Not Cancelled Slips / Cancelled Slips

Dispatch/Receipt

Unbilled Dispatch/Receipt / Billed Dispatch/Receipt

Dispatch/Receipt Status

Actual / Proposal

Material Slip Status (Warehouse Slips)

Actual / Proposal

Has No Transactions

List / Do Not List

Lot Number

Group / Range

Lot Description

Group / Range

Serial Number

Group / Range

Serial Description

Group / Range

Serial Group No.

Group / Range

Serial Group Description

Group / Range

Expiry Date

Start / End

Location Code

Group / Range

Warehouse Totals

Combine / Do Not Combine

Project Code

Group / Range

Project Description

Group / Range

List Basis on Variants

Yes / No

Variant Code

Group / Range

Variant Description

Group / Range

Variant Aux. Code

Group / Range

 

 

Material Extract

 

The report option is located in the Slip Lists and Extracts menu of the Material Management section and is used to display the material transactions with Slip Type, daily Quantity and totals. In the Material Extract, the transactions are listed with separate slip information for each material. The filter options of the Material Extract are:

 

Filter

Value

Listing Method

By Materials / By Warehouses

Slip Dates

Start / End

Material (Class) Type

(MT) Material Class (With Table) / (MC) Material Class / (RM) Raw Material / (YM) Semi Finished Good / (FG) Finished Good / (CG) Commercial Good /  (MX) Mixed Case / (DI) Deposited Item / (FA) Fixed Asset / (COG) Consumer Good

Material (Class) Status

Active / Passive

Material (Class) Code

Group / Range

Material (Class) Description

Group / Range

Material (Class) Aux. Code 1-5

Group / Range

Material (Class) Auth. Code

Group / Range

Material (Class) Vendor Code

Group / Range

Material (Class) Group Code

Group / Range

Material (Class) Characteristics

Characteristic 1 - 10

Characteristic Code / Characteristic Values

Parent Material Class Code

Select from the List

Material Tracking Method

No Tracking / Lot / Serial

AR/AP Code

Group / Range

AR/AP Title

Group / Range

AR/AP Status

Active / Passive

AR/AP Aux. Code 1-5

Group / Range

Trading Group

Group / Range

Transaction Type

Material Transactions / Promotion Transaction / Deposit Transaction / Mixed Case Transaction / Fixed Asset Transaction / Material Class Transaction

Transaction G/L Code

Group / Range

Overhead Pool Code

Group / Range

Transaction Aux. Code

Group / Range

Slip Type

(01) Purchase Receipt / (02) Retail Sales Return Dispatch / (03) Wholesale Return Receipt / (04) Consignment Return Dispatch / (05) Consignment Receipt / (06) Purchase Return Receipt / (07) Retail Sales Dispatch / (08) Wholesale Receipt / (09) Consignment Dispatch / (10) Consignment Return Receipt / (11) Scrap Slip / (12) Usage Slip / (13) Input From Production Slip / (14) Opening Slip / (25) Warehouse Transfer Slip / (26) Producer Slip / (50) Cycle Count Slip (Excess) / (51) Cycle Count Slip (Deficit)

Warehouse Slip Type

All / Generated from Material Slips / Generated from Nationalization Slip

Slip Number

Group / Range

Slip Status

Actual / Planned

Slip Aux. Code

Group / Range

Slip Document Number

Group / Range

Cancellation Status

Not Cancelled / Cancelled / All

Dispatch/Receipt

Unbilled Dispatch/Receipt / Billed Dispatch/Receipt

Dispatch/Receipt Status

Actual / Proposal

Material Slip Status (Warehouse Slips)

Actual / Proposal

Report Unit

Unit Set / Unit

Units

Convert To Main Unit / Convert To Report Unit / List By Unit In Transaction

Divisions

Defined divisions

Plants

Defined plants

Warehouses

Defined warehouses

Departments

Defined departments

Currency Amount Type

Pricing Currency / Transaction Currency

F. Currency Type

Currency options

Price Difference

Included / Excluded

Lot Number

Group / Range

Lot Description

Group / Range

Serial Number

Group / Range

Serial Description

Group / Range

Serial Group No.

Group / Range

Serial Group Description

Group / Range

Expiry Date

Start / End

Workstation Code

Group / Range

Workstation Description

Group / Range

Workstation Auth. Code

Group / Range

Workstation Aux. Code

Group / Range

Location Code

Group / Range

Discounts

Will Be Removed From The Amount / Will Not Be Transacted

Surcharges

Will Be Added To Amount / Will Not Be Transacted

Print Report

Same Page / Different Page

Unit Set Code

Group / Range

Unit Set Description

Group / Range

Unit Set Aux. Code

Group / Range

Unit Set Auth. Code

Group / Range

Line Barcode

Group / Range

Unit Code

Group / Range

Unit Description

Group / Range

List Serial/Lot/Location Info

Yes / No

Input From Production Tracking Number

Group / Range

Project Code

Group / Range

Project Description

Group / Range

List Basis on Variants

Yes / No

Variant Code

Group / Range

Variant Description

Group / Range

Variant Aux. Code

Group / Range

AR/AP Auth. Code

Group / Range

Remittance Connection

Yes / No

Shipment Address Code

Group / Range

Shipment Address Description

Group / Range

 

 

Daily Summary Extract

 

The report option is located in the Slip Lists and Extracts menu of the Material Management section and is used to display the input and output transactions with Date, Amount and Quantity information. The filter options of the Summary Daily Extract are:

 

Filter

Value

Listing Method

By Materials / By Warehouses

Slip Dates

Start / End

Material (Class) Type

(MT) Material Class (With Table) / (MC) Material Class / (RM) Raw Material / (YM) Semi Finished Good / (FG) Finished Good / (CG) Commercial Good /  (MX) Mixed Case / (DI) Deposited Item / (FA) Fixed Asset / (COG) Consumer Good

Material (Class) Status

Active / Passive

Material (Class) Code

Group / Range

Material (Class) Description

Group / Range

Material (Class) Aux. Code

Group / Range

Material (Class) Auth. Code

Group / Range

Material (Class) Vendor Code

Group / Range

Material (Class) Group Code

Group / Range

Material (Class) Characteristics

Characteristic 1 - 10

Characteristic Code / Characteristic Values

Parent Material Class Code

Select from the List

Material Tracking Method

No Tracking / Lot / Serial

AR/AP Code

Group / Range

AR/AP Title

Group / Range

AR/AP Status

Active / Passive

AR/AP Aux. Code

Group / Range

Trading Group

Group / Range

Transaction Type

Material Transactions / Promotion Transaction / Deposit Transaction / Mixed Case Transaction / Fixed Asset Transaction / Material Class Transaction

Slip Type

(01) Purchase Receipt / (02) Retail Sales Return Dispatch / (03) Wholesale Return Receipt / (04) Consignment Return Dispatch / (05) Consignment Receipt / (06) Purchase Return Receipt / (07) Retail Sales Dispatch / (08) Wholesale Receipt / (09) Consignment Dispatch / (10) Consignment Return Receipt / (11) Scrap Slip / (12) Usage Slip / (13) Input From Production Slip / (14) Opening Slip / (25) Warehouse Transfer Slip / (26) Producer Slip / (50) Cycle Count Slip (Excess) / (51) Cycle Count Slip (Deficit)

Warehouse Slip Type

All / Generated from Material Slips / Generated from Nationalization Slip

Slip Status

Actual / Planned

Cancellation Status

Not Cancelled Slips / Cancelled Slips

Dispatch/Receipt

Unbilled Dispatch/Receipt / Billed Dispatch/Receipt

Dispatch/Receipt Status

Actual / Proposal

Material Slip Status (Warehouse Slips)

Actual / Proposal

Report Unit

Unit Set / Unit

Units

Convert To Main Unit / Convert To Reporting Unit

Divisions

Defined divisions

Plants

Defined plants

Warehouses

Defined warehouses

Departments

Defined departments

Pricing Currency Type

Currency options

Transaction Currency Type

Currency options

Lot Number

Group / Range

Lot Description

Group / Range

Serial Number

Group / Range

Serial Description

Group / Range

Serial Group No.

Group / Range

Serial Group Description

Group / Range

Expiry Date

Start / End

Location Code

Group / Range

Discounts

Will Be Removed From The Amount / Will Not Be Transacted

Surcharges

Will Be Added To Amount / Will Not Be Transacted

Slip Aux. Code

Group / Range

Print Report

Same Page / Different Page

Project Code

Group / Range

Project Description

Group / Range

 

 

ABC Analysis

 

The analysis option is located in the Slip Lists and Extracts menu of the Material Management section. The data source of the analysis is the Material Transactions between the specified dates. The transactions to be scanned are defined using filters. The existing codes are compared with the codes resulting from the report and the values resulting from the analysis are recorded on the relevant Material record by the user.

 

Filter

Value

Analysis for Warehouse

General / Separate

Warehouses

Defined warehouses

Material Type

Raw Material / Semi Finished Good / Finished Good / Mixed Case / Deposited Item / Fixed Asset / Consumer Good

Date Range

Start / End

Primary Criteria

Sales Transactions / Output Transactions for Production / Other Output Transactions

Sales Transactions Criteria

Turnover/ Sales Cost / Sales Profit

Currency Amount Type

Local Currency / Reporting Currency Type

Secondary Criteria

Average Unit Price/Cost/ Profit / Quantity

A Code Rate (%)

Direct data entry

B Code Rate (%)

Direct data entry

C Code Rate (%)

Direct data entry

Sorting Type

By ABC Coding / By Material Codes

Code Limit

First Value Exceeding Ratio / Last Value Not Exceeding Ratio

Update Status

Track / Do Not Track

Project Code

Group / Range

Project Description

Group / Range

 

First the ABC analysis scans the transactions of a material that match the filters. Each transaction is converted to the Main Unit and the Amount (Quantity * Unit Price/Cost/Profit) is calculated. The sum of the Amounts of all transactions is written to the Amount column. This operation is repeated for each material matching the selected types. If the Price/Cost/Profit of the Main Unit is not defined in the Transactions, the Unit Conversion Factors are used to calculate an appropriate value for the Main Unit.


Filters

 

The Sales Dispatches and Sales Invoices (excluding orders) are used if Sales Operations is selected as the primary criteria; Usage Slips and Scrap Slips are used if Output to Production Operations is selected; and the User Defined Output Slips are used if Other Output Operations is selected.
When “Sales Operations” is selected as the primary criteria for the analysis, the Transaction Amount is calculated as follows:

Sales Volume (Turnover)

Amount=(Quantity * Unit Price)+Surcharges of the line-(line discounts)

 

Sales Cost

Amount=Quantity*Unit Cost

 

Sales Profit

Amount=(Sales Volume)-(Sales Cost)

 

Average Unit Price/Cost/Profit or Quantity can be selected as the secondary criteria. Since the ABC Codes are entered as percentages, values can be between 0 and 100.

The first value exceeding the rate or the last value within the rate are processed respectively when The First Value Exceeding the Rate or The Last Value Not Exceeding the Rate is selected in the Coding Limit filter and the sorting is done accordingly.


The materials are first sorted by the Total Amount obtained in the first step and then by the criteria set in the ABC analysis filters. The values calculated for all sorted materials and sorted in the Amount column are added and the Total Amount is written to the last line of the same column. The (Amount/Total Amount)*100 is calculated for each material and is written to the % Amount column.

Then the (%Amount + the % Amount of the previous material in the list) is calculated for each material and written to the relevant column. The A, B and C codes are assigned by taking into consideration the Cumulative % Amount and the percentage segments defined in the filters. Here the parameter that specifies the stopping point between the codes is activated.

For example, lets assume that The First Value Exceeding the Rate is selected in the filter field for this parameter, the A=75%, B=20% and C=5% values are given and the Cumulative % Amount reached 73,5% after the first five materials.

If this value exceeds 75% with the 6th material, the ABC code of the first six materials is A. 7. Starting from the 7th material, the B code is assigned in a similar way.

If The Last Value Not Exceeding the Rate is selected in the Coding Limit filter, the first 5 materials are given the A code and the B code is given starting from the 6th material in the same example.

After obtaining these results, the ABC Code fields located in the Warehouse Parameters of the materials are updated by the user and the report is printed on the screen, printer or disk.

 

Material / Location Distribution

 

This report option is located in the Slip Lists and Extracts menu of the Material Management section and is used to list the materials by Location Codes. The report filter options are:

 

Filter

Value

Listing Method

By Materials / By Warehouses

Material Type

(RM) Raw Material / (YM) Semi Finished Good / (FG) Finished Good / (CG) Commercial Good /  (MX) Mixed Case / (DI) Deposited Item / (FA) Fixed Asset / (COG) Consumer Good

Material Status

Active / Passive

Material Code

Group / Range

Material Description

Group / Range

Material Aux. Code

Group / Range

Material Auth. Code

Group / Range

Material Vendor Code

Group / Range

Material Group Code

Group / Range

Material Characteristics

Characteristic 1 - 10

Characteristic Code / Characteristic Values

Parent Material Class Code

Select from the List

Material Tracking Method

No Tracking / Lot / Serial

Location Code

Group / Range

Location Description

Group / Range

Dispatch/Receipt Status

Actual / Proposal

Material Slip Status (Warehouse Slips)

Actual / Proposal

Slip Type

(01) Purchase Receipt / (02) Retail Sales Return Dispatch / (03) Wholesale Return Receipt / (04) Consignment Return Dispatch / (05) Consignment Receipt / (06) Purchase Return Receipt / (07) Retail Sales Dispatch / (08) Wholesale Receipt / (09) Consignment Dispatch / (10) Consignment Return Receipt / (11) Scrap Slip / (12) Usage Slip / (13) Input From Production Slip / (14) Opening Slip / (25) Warehouse Transfer Slip / (26) Producer Slip / (50) Cycle Count Slip (Excess) / (51) Cycle Count Slip (Deficit)

Warehouse Slip Type

All / Generated from Material Slips / Generated from Nationalization Slip

Slip Status

Actual / Planned

Slip Number

Group / Range

Slip Aux. Code

Group / Range

Slip Dates

Start / End

Report Unit

Unit Set / Unit

Units

Convert To Main Unit / Convert To Reporting Unit

Lot Number

Group / Range

Lot Description

Group / Range

Serial Number

Group / Range

Serial Description

Group / Range

Serial Group No.

Group / Range

Serial Group Description

Group / Range

Expiry Date

Start / End

Barcode

Group / Range

Plants

Defined plants

Warehouses

Defined warehouses

Lot / Serial Detail Lines

List / Do Not List

Project Code

Group / Range

Project Description

Group / Range

 

The Material/Location Distribution report can be listed by either Materials or Location Codes depending on the selection made in the Listing Method filter line. When By Materials is selected, all quantities and amounts of each material are separately listed by Material records. When By Location Code is selected, the results are listed by materials using the entered Location Code.

 

Material Totals By Units

 

This report option is located in the Slip Lists and Extracts menu of the Material Management section and is used to list the material totals by selected unit. The report filter options are:

 

Filter

Value

Material (Class) Type

(MT) Material Class (With Table) / (MC) Material Class / (RM) Raw Material / (YM) Semi Finished Good / (FG) Finished Good / (CG) Commercial Good /  (MX) Mixed Case / (DI) Deposited Item / (FA) Fixed Asset / (COG) Consumer Good

Material (Class) Status

Active / Passive

Material (Class) Code

Group / Range

Material (Class) Description

Group / Range

Material (Class) Aux. Code

Group / Range

Material (Class) Authorization Code

Group / Range

Material (Class) Vendor Code

Group / Range

Material (Class) Group Code

Group / Range

Material (Class) Characteristics

Characteristic 1 - 10

Characteristic Code / Characteristic Values

Parent Material Class Code

Direct data entry / Group

Unit Set

Unit Set / Unit

Warehouses

Defined warehouses

Plants

Defined plants

Unit Conversion Factors

From Unit Set Definitions / From Unit Conversions Of Transactions

Has No Transactions

Will Not Be Listed / Will Be Listed

Last Transaction Date

Start / End

Purchase Orders

Direct data entry

Delivered Orders

Direct data entry

Purchase Quantity

Direct data entry

Opening Amount

Direct data entry

Planned Input From Production

Direct data entry

Actual Production Inputs

Direct data entry

Planned Warehouse Inputs

Direct data entry

Actual Warehouse Inputs

Direct data entry

Planned Other Inputs

Direct data entry

Actual Other Inputs

Direct data entry

Consignments Received

Direct data entry

Sales Orders

Direct data entry

Delivered Orders

Direct data entry

Sales Quantity

Direct data entry

Planned Usages and Scraps

Direct data entry

Actual Usages and Scraps

Direct data entry

Planned Warehouse Outputs

Direct data entry

Actual Warehouse Outputs

Direct data entry

Planned Other Outputs

Direct data entry

Actual Other Outputs

Direct data entry

Consignments Issued

Direct data entry

Reserved Quantity

Direct data entry

Physical Inventory

Direct data entry

Real Inventory

Direct data entry

Project Code

Group / Range

Project Description

Group / Range

Dispatch/Receipt Status

Actual / Proposal

 

 

Material Class Totals

 

This report option is located in the Slip Lists and Extracts menu of the Material Management section and is used to list the material class totals. The report filter options are:

 

Filter

Value

Listing Method

By Materials / By Warehouses

Slip Dates

Start / End

Material Class Type

(MC) Material Class (without table) / (MT) Material Class (with table)

Material Class Status

Active / Passive

Material Class Code

Group / Range

Material Class Description

Group / Range

Material Class Aux. Code

Group / Range

Material Class Auth. Code

Group / Range

Material Class Vendor Code

Group / Range

Material Class Group Code

Group / Range

Material Class Characteristics

Characteristic 1 - 10

Characteristic Code / Characteristic Values

Report Unit

Unit Set / Unit

Units

Convert to Main Unit / Convert to Reporting Unit

Transaction Type

Material Transactions / Promotion Transaction / Deposit Transaction / Fixed Asset Transaction / Mixed Case Transaction / Material Class Transaction

Transaction G/L Code

Group / Range

Overhead Pool Code

Group / Range

Transaction Aux. Code

Group / Range

AR/AP Code

Group / Range

AR/AP Title

Group / Range

AR/AP Aux. Code

Group / Range

AR/AP Status

Active / Passive

Trading Group

Group / Range

Slip Type

(01) Purchase Receipt / (02) Retail Sales Return Dispatch / (03) Wholesale Return Receipt / (04) Consignment Return Dispatch / (05) Consignment Receipt / (06) Purchase Return Receipt / (07) Retail Sales Dispatch / (08) Wholesale Receipt / (09) Consignment Dispatch / (10) Consignment Return Receipt / (11) Scrap Slip / (12) Usage Slip / (13) Input From Production Slip / (14) Opening Slip / (25) Warehouse Transfer Slip / (26) Producer Slip / (50) Cycle Count Slip (Excess) / (51) Cycle Count Slip (Deficit)

Warehouse Slip Type

All / Generated from Material Slips / Generated from Nationalization Slip

Slip Number

Group / Range

Slip Aux. Code

Group / Range

Departments

Defined departments

Divisions

Defined divisions

Warehouses

Defined warehouses

Cancellation Status

Not Cancelled Slips / Cancelled Slips

Dispatch/Receipt

Unbilled Dispatch/Receipt / Billed Dispatch/Receipt

Dispatch/Receipt Status

Actual / Proposal

Material Slip Status (Warehouse Slips)

Actual / Proposal

Has No Transactions

List / Do Not List

Lot Number

Group / Range

Lot Description

Group / Range

Serial Number

Group / Range

Serial Description

Group / Range

Serial Group No.

Group / Range

Serial Group Description

Group / Range

Expiry Date

Start / End

Location Code

Group / Range

Warehouse Totals

Combine /  Do Not Combine

Project Code

Group / Range

Project Description

Group / Range

 

 

Input/Output Totals By Transaction Aux. Code

 

This report option is located in the Slip Lists and Extracts menu of the Material Management section and is used to generate the summary of Material Transactions in given periods. The conditions are set by Material (Class) Type and Material Transactions, and the Input/Output Totals are reported in the desired date range. The Input/Output Totals by Transaction Aux. Code report filter options are:

 

Filter

Value

 

Slip Dates

Start / End

 

Material (Class) Type

(MT) Material Class (With Table) / (MC) Material Class / (RM) Raw Material / (YM) Semi Finished Good / (FG) Finished Good / (CG) Commercial Good /  (MX) Mixed Case / (DI) Deposited Item / (FA) Fixed Asset / (COG) Consumer Good

 

Material (Class) Status

Active / Passive

 

Material (Class) Code

Group / Range

 

Material (Class) Description

Group / Range

 

Material (Class) Aux. Code

Group / Range

 

Material (Class) Auth. Code

Group / Range

 

Material (Class) Vendor Code

Group / Range

 

Material (Class) Group Code

Group / Range

 

Material (Class) Characteristics

Characteristic 1 - 10

Characteristic Code / Characteristic Values

Parent Material Class Code

Direct data entry

 

Material Tracking Method

No Tracking / Lot / Serial

 

Report Unit

Unit Set Code/ Unit 

 

Units

Convert to Main Unit / Convert to Reporting Unit

 

Transaction Type

Material Transactions / Promotion Transaction / Deposit Transaction / Fixed Asset Transaction / Mixed Case Transaction / Material Class Transaction

 

Transaction G/L Code

Group / Range

 

Overhead Pool Code

Group / Range

 

Transaction Aux. Code

Group / Range

 

AR/AP Code

Group / Range

 

AR/AP Title

Group / Range

 

AR/AP Status

Active / Passive

 

AR/AP Aux. Code

Group / Range

 

Trading Group

Group / Range

 

Slip Type

(01) Purchase Receipt / (02) Retail Sales Return Dispatch / (03) Wholesale Return Receipt / (04) Consignment Return Dispatch / (05) Consignment Receipt / (06) Purchase Return Receipt / (07) Retail Sales Dispatch / (08) Wholesale Receipt / (09) Consignment Dispatch / (10) Consignment Return Receipt / (11) Scrap Slip / (12) Usage Slip / (13) Input From Production Slip / (14) Opening Slip / (25) Warehouse Transfer Slip / (26) Producer Slip / (50) Cycle Count Slip (Excess) / (51) Cycle Count Slip (Deficit)

 

Warehouse Slip Type

All / Generated from Material Slips / Generated from Nationalization Slip

 

Slip Number

Group / Range

 

Slip Aux. Code

Group / Range

 

Departments

Defined departments

 

Divisions

Defined divisions

 

Warehouses

Defined warehouses

 

Plants

Defined plants

 

Cancellation Status

Not Cancelled Slips / Cancelled Slips

 

Dispatch/Receipt

Unbilled Dispatch/Receipt / Billed Dispatch/Receipt

 

Dispatch/Receipt Status

Actual / Proposal

 

Material Slip Status (Warehouse Slips)

Actual / Proposal

 

Lot Number

Group / Range

 

Lot Description

Group / Range

 

Serial Number

Group / Range

 

Serial Description

Group / Range

 

Serial Group No.

Group / Range

 

Serial Group Description

Group / Range

 

Expiry Date

Start / End

 

Location Code

Group / Range

 

Workstation Code

Group / Range

 

Workstation Description

Group / Range

 

Workstation Aux. Code

Group / Range

 

Workstation Auth. Code

Group / Range

 





 

 

Material Extract By Transaction Aux. Code

 

This report option is located in the Slip Lists and Extracts menu of the Material Management section and is used to display the Slip Type, Daily Quantity and totals of material transactions. The transactions are listed with separate slip information for each material in the Material Extract. The Material Extract By Transaction Aux. Code filter options are:

 

Filter

Value

Slip Dates

Start / End

Material (Class) Type

(MT) Material Class (With Table) / (MC) Material Class / (RM) Raw Material / (YM) Semi Finished Good / (FG) Finished Good / (CG) Commercial Good /  (MX) Mixed Case / (DI) Deposited Item / (FA) Fixed Asset / (COG) Consumer Good

Material (Class) Status

Active / Passive

Material (Class) Code

Group / Range

Material (Class) Description

Group / Range

Material (Class) Aux. Code

Group / Range

Material (Class) Auth. Code

Group / Range

Material (Class) Vendor Code

Group / Range

Material (Class) Group Code

Group / Range

Material (Class) Characteristics

Characteristic 1 - 10

Characteristic Code / Characteristic Values

Parent Material Class Code

Select from the List

Material Tracking Method

No Tracking / Lot / Serial

AR/AP Code

Group / Range

AR/AP Title

Group / Range

AR/AP Status

Active / Passive

AR/AP Aux. Code

Group / Range

Trading Group

Group / Range

Transaction Type

Material Transactions / Promotion Transaction / Deposit Transaction / Fixed Asset Transaction / Mixed Case Transaction / Material Class Transaction

Transaction G/L Code

Group / Range

Overhead Pool Code

Group / Range

Transaction Aux. Code

Group / Range

Slip Type

(01) Purchase Receipt / (02) Retail Sales Return Dispatch / (03) Wholesale Return Receipt / (04) Consignment Return Dispatch / (05) Consignment Receipt / (06) Purchase Return Receipt / (07) Retail Sales Dispatch / (08) Wholesale Receipt / (09) Consignment Dispatch / (10) Consignment Return Receipt / (11) Scrap Slip / (12) Usage Slip / (13) Input From Production Slip / (14) Opening Slip / (25) Warehouse Transfer Slip / (26) Producer Slip / (50) Cycle Count Slip (Excess) / (51) Cycle Count Slip (Deficit)

Warehouse Slip Type

All / Generated from Material Slips / Generated from Nationalization Slip

Slip Status

Actual / Planned

Slip Number

Group / Range

Slip Document Number

Group / Range

Slip Aux. Code

Group / Range

Cancellation Status

Not Cancelled Slips / Cancelled Slips

Dispatch/Receipt

Unbilled Dispatch/Receipt / Billed Dispatch/Receipt

Dispatch/Receipt Status

Actual / Proposal

Material Slip Status (Warehouse Slips)

Actual / Proposal

Report Unit

Unit Set / Unit

Units

Convert to Main Unit / Convert to Reporting Unit / List By Unit in Transaction

Departments

Defined departments

Divisions

Defined divisions

Plants

Defined plants

Warehouses

Defined warehouses

Currency Amount Type

Pricing Currency / Transaction Currency

F. Currency Type

Currency options

Price Difference

Included / Excluded

Lot Number

Group / Range

Lot Description

Group / Range

Serial Number

Group / Range

Serial Description

Group / Range

Serial Group No.

Group / Range

Serial Group Description

Group / Range

Expiry Date

Start / End

Location Code

Group / Range

Workstation Code

Group / Range

Workstation Description

Group / Range

Workstation Auth. Code

Group / Range

Workstation Aux. Code

Group / Range

Unit Set Code

Group / Range

Unit Set Description

Group / Range

Unit Set Aux. Code

Group / Range

Unit Set Auth. Code

Group / Range

Line Barcode

Group / Range

Unit Code

Group / Range

Unit Description

Group / Range

 

 

Quick Production Slips List

 

This report option is located in the Slip Lists and Extracts menu of the Material Management section and is used to list the Usage, Scrap and Input from Production Slips generated by quick production operation.

The report filter options are:

 

Filter

Value

Slip Type

Production / Parting

Quick Production Slip Number

Group / Range

Quick Production Date

Start / End

Quick Production Aux. Code

Group / Range

Quick Production Auth. Code

Group / Range

Finished Good Code

Group / Range

Finished Good Description

Group / Range

Finished Good Aux. Code

Group / Range

Finished Good Vendor Code

Group / Range

Finished Good Group Code

Group / Range

Child Materials

List / Do Not List

Child Material Code

Group / Range

Child Material Description

Group / Range

Child Material Aux. Code

Group / Range

Project Code

Group / Range

Project Description

Group / Range

 

 

Quick Production / Material Slip Connections

 

This report option is located in the Slip Lists and Extracts menu of the Material Management section and is used to list the Usage, Scrap and Input from Production Slips generated by quick production operation in detail according to the Lot/Serial/Location information. The report filter options are:

 

Filter

Value

Quick Production Slip Number

Group / Range

Slip Type

Production / Parting

Quick Production Date

Start / End

Quick Production Aux. Code

Group / Range

Quick Production Auth. Code

Group / Range

Finished Good Code

Group / Range

Finished Good Description

Group / Range

Finished Good Aux. Code

Group / Range

Slip Type

Scrap Slip / Usage Slip / Input From Production Slip

Slip Date

Start / End

Slip Aux. Code

Group / Range

Slip Auth. Code

Group / Range

Division

Defined divisions

Plant

Defined plants

Department

Defined departments

Warehouse

Defined warehouses

List Material Transactions

Yes / No

Material Code

Group / Range

Material Description

Group / Range

Material Aux. Code

Group / Range

Material Auth. Code

Group / Range

Transaction Aux. Code

Group / Range

Lot / Serial / Location Info

Yes / No

Lot / Serial No.

Group / Range

Location Code

Group / Range

Project Code

Group / Range

Project Description

Group / Range

 

 

Material Slips G/L Codes List

 

This report option is located in the Slip Lists and Extracts menu of the Material Management section and is used to list the G/L Codes of the material slips recorded in the production process. The filter options are:

 

Filter

Value

Listing

Connected to P.O / Not Connected to P.O

Production Order Number

Group / Range

Production Order Date

Start / End

Production Order Aux. Code

Group / Range

Production Order Status

Not Proceed / Proceed / Stopped / Finished / Closed

Finished Good Code

Group / Range

Finished Good Description

Group / Range

Finished Good Aux. Code

Group / Range

Finished Good Auth. Code

Group / Range

Work Order Number

Group / Range

Work Order Aux. Code

Group / Range

Work Order Auth. Code

Group / Range

Work Order Document No.

Group / Range

Workstation Code

Group / Range

Workstation Description

Group / Range

Slip Type

Scrap Slip / Usage Slip / Input from Production Slip / WH Transfer Slip / Cycle Count Slip (+) / Cycle Count Deficit Slip(-)

Warehouse Slip Type

All / Generated from Material Slips / Generated from Nationalization Slip

Slip Status

Planned / Actual

Slip No.

Group / Range

Slip Date

Start / End

Slip Aux. Code

Group / Range

Slip Authorization Code

Group / Range

 

 

Lot/Serial Number Reports

 

The information about Lot/Serial Number tracking operations are reported using the options located in the Lot/Serial Number Reports menu. The reports under this option are:

 

Forward Tracking


This report is located in the Lot/Serial Number Reports menu of the Material Management section and is used for forward tracking of material transactions divided by Lot/Serial Numbers. The report filter options are:

 

Filter

Value

Material Type

(RM) Raw Material / (YM) Semi Finished Good / (FG) Finished Good / (CG) Commercial Good /  (MX) Mixed Case / (DI) Deposited Item / (FA) Fixed Asset / (COG) Consumer Good

Material Status

Active / Passive

Material Code

Group / Range

Material Description

Group / Range

Material Aux. Code

Group / Range

Material Auth. Code

Group / Range

Material Vendor Code

Group / Range

Material Group Code

Group / Range

Material Characteristics

Characteristic Code 1 - 10 And Group / Range for Characteristic Value

Parent Material Class Code

Direct data entry / Group

Material Tracking Method

Lot / Serial

Lot / Serial Determination Method

LIFO/FIFO

Lot / Serial No. Default Value

Value Entry

Lot Size

Production Quantity / Constant Size

Lot Number

Group / Range

Lot Description

Group / Range

Serial Number

Group / Range

Serial Description

Group / Range

Serial Group No.

Group / Range

Serial Group Description

Group / Range

Expiry Date

Start / End

Location Code

Group / Range

Slip Type

(01) Purchase Receipt / (02) Retail Sales Return Dispatch / (03) Wholesale Return Receipt / (04) Consignment Return Dispatch / (05) Consignment Receipt / (06) Purchase Return Receipt / (07) Retail Sales Dispatch / (08) Wholesale Receipt / (09) Consignment Dispatch / (10) Consignment Return Receipt / (11) Scrap Slip / (12) Usage Slip / (13) Input From Production Slip / (14) Opening Slip / (25) Warehouse Transfer Slip / (26) Producer Slip / (50) Cycle Count Slip (Excess) / (51) Cycle Count Slip (Deficit)

Slip Date

Start / End

Slip No.

Group / Range

Slip Document No.

Group / Range

Slip Aux. Code

Group / Range

Transaction Type

Material Transaction / Promotion Transaction / Mixed Case Transaction / Fixed Asset Transaction

Transaction Aux. Code

Group / Range

AR/AP Status

Active / Passive

AR/AP Code

Group / Range

AR/AP Title

Group / Range

Trading Group

Group / Range

Plants

Defined plants

Departments

Defined departments

Divisions

Defined divisions

Warehouses

Defined warehouses

Dispatch/Receipt

Unbilled Dispatch/Receipt / Billed Dispatch/Receipt

Dispatch/Receipt Status

Actual / Proposal

Material Slip Status (Warehouse Slips)

Actual / Proposal

Workstation Code

Group / Range

Currency Amount Type

Local Currency / Reporting Currency / Transaction Currency / Pricing Currency

F. Currency Type

Currency options

Report Unit

Unit Set Code / Unit Code

Units

Convert to Main Unit / Convert to Reporting Unit / List By Unit in Transaction

Project Code

Group / Range

Project Description

Group / Range

 

Tracking info for all materials in report is listed separately on warehouse basis according to date info. Material code, description and unit info is located in material info section. Lot/Serial number, description, transaction date, slip type, quantity, price and amount info of input transactions and output transactions, net amount and remaining column headings and tracking info are reported in the lines located under this general info.

 

Backward Tracking

 

This report is located in the Lot/Serial Number Reports menu of the Material Management section and is used for backward tracking of material transactions divided by Lot/Serial Numbers. The report filter options are:

 

Filter

Value

Material Type

(RM) Raw Material / (YM) Semi Finished Good / (FG) Finished Good / (CG) Commercial Good /  (MX) Mixed Case / (DI) Deposited Item / (FA) Fixed Asset / (COG) Consumer Good

Material Status

Active / Passive

Material Code

Group / Range

Material Description

Group / Range

Material Aux. Code

Group / Range

Material Authorization Code

Group / Range

Material Vendor Code

Group / Range

Material Group Code

Group / Range

Material Characteristics

Characteristic Code 1 - 10 And Group / Range for Characteristic Value

Parent Material Class Code

Direct data entry / Group

Material Tracking Method

Lot / Serial

Lot / Serial Determination Method

LIFO/FIFO

Lot / Serial No. Default Value

Value Entry

Lot Size

Production Quantity / Constant Size

Lot Number

Group / Range

Lot Description

Group / Range

Serial Number

Group / Range

Serial Description

Group / Range

Serial Group No.

Group / Range

Serial Group Description

Group / Range

Expiry Date

Start / End

Location Code

Group / Range

Slip Type

(01) Purchase Receipt / (02) Retail Sales Return Dispatch / (03) Wholesale Return Receipt / (04) Consignment Return Dispatch / (05) Consignment Receipt / (06) Purchase Return Receipt / (07) Retail Sales Dispatch / (08) Wholesale Receipt / (09) Consignment Dispatch / (10) Consignment Return Receipt / (11) Scrap Slip / (12) Usage Slip / (13) Input From Production Slip / (14) Opening Slip / (25) Warehouse Transfer Slip / (26) Producer Slip / (50) Cycle Count Slip (Excess) / (51) Cycle Count Slip (Deficit)

Slip Date

Start / End

Slip No.

Group / Range

Slip Document No.

Group / Range

Slip Aux. Code

Group / Range

Transaction Type

Material Transaction / Promotion Transaction / Mixed Case Transaction / Fixed Asset Transaction

Transaction Aux. Code

Group / Range

AR/AP Status

Active / Passive

AR/AP Code

Group / Range

AR/AP Title

Group / Range

Trading Group

Group / Range

Plants

Defined plants

Departments

Defined departments

Divisions

Defined divisions

Warehouses

Defined warehouses

Workstation Code

Group / Range

Dispatch/Receipt

Unbilled Dispatch/Receipt / Billed Dispatch/Receipt

Dispatch/Receipt Status

Actual / Proposal

Material Slip Status (Warehouse Slips)

Actual / Proposal

Workstation Code

Group / Range

Currency Amount Type

Local Currency / Reporting Currency / Transaction Currency / Pricing Currency

F. Currency Type

Currency options

Report Unit

Unit Set Code / Unit Code

Units

Convert to Main Unit / Convert to Reporting Unit / List By Unit in Transaction

Project Code

Group / Range

Project Description

Group / Range

 

Tracking info for all materials in report is listed separately on warehouse basis according to date info. Material code, description and unit info is located in material info section. Lot/Serial number, description, transaction date, slip type, quantity, price and amount info of input transactions and output transactions, net amount and remaining column headings and tracking info are reported in the lines located under this general info.

 

Lot/ Serial Transactions List

 

This report is located in the Lot/Serial Number Reports menu of the Material Management section and is used to list the Lot/Serial Transactions of the materials. The filters of the Lot/Serial Transactions List are:

 

Filter

Value

Material Type

(RM) Raw Material / (YM) Semi Finished Good / (FG) Finished Good / (CG) Commercial Good /  (MX) Mixed Case / (DI) Deposited Item / (FA) Fixed Asset / (COG) Consumer Good

Material Status

Active / Passive

Material Code

Group / Range

Material Description

Group / Range

Material Aux. Code

Group / Range

Material Authorization Code

Group / Range

Material Vendor Code

Group / Range

Material Group Code

Group / Range

Material Characteristics

Characteristic Code 1 - 10 And Group / Range for Characteristic Value

Parent Material Class Code

Direct data entry / Group

Material Tracking Method

Lot / Serial

Lot Number

Group / Range

Lot / Serial Determination Method

LIFO/FIFO

Lot Description

Group / Range

Lot Size

Production Quantity / Constant Size

Serial Number

Group / Range

Serial Description

Group / Range

Serial Group No.

Group / Range

Serial Group Description

Group / Range

Expiry Date

Start / End

Location Code

Group / Range

Slip Type

(01) Purchase Receipt / (02) Retail Sales Return Dispatch / (03) Wholesale Return Receipt / (04) Consignment Return Dispatch / (05) Consignment Receipt / (06) Purchase Return Receipt / (07) Retail Sales Dispatch / (08) Wholesale Receipt / (09) Consignment Dispatch / (10) Consignment Return Receipt / (11) Scrap Slip / (12) Usage Slip / (13) Input From Production Slip / (14) Opening Slip / (25) Warehouse Transfer Slip / (26) Producer Slip / (50) Cycle Count Slip (Excess) / (51) Cycle Count Slip (Deficit)

Slip Date

Start / End

Slip No.

Group / Range

Slip Document No.

Group / Range

Slip Aux. Code

Group / Range

Transaction Type

Material Transaction / Promotion Transaction / Mixed Case Transaction / Fixed Asset Transaction

Transaction Aux. Code

Group / Range

AR/AP Status

Active / Passive

AR/AP Code

Group / Range

AR/AP Title

Group / Range

Trading Group

Group / Range

Plants

Defined plants

Departments

Defined departments

Divisions

Defined divisions

Warehouses

Defined warehouses

Dispatch/Receipt

Unbilled Dispatch/Receipt / Billed Dispatch/Receipt

Dispatch/Receipt Status

Actual / Proposal

Material Slip Status (Warehouse Slips)

Actual / Proposal

Workstation Code

Group / Range

Workstation Description

Group / Range

Workstation Aux. Code

Group / Range

Workstation Auth. Code

Group / Range

Currency Amount Type

Local Currency / Reporting Currency / Transaction Currency / Pricing Currency

F. Currency Type

Currency options

Report Unit

Unit Set Code / Unit Code

Report Direction

From Today to Backwards / From Past To Forward

Unit

Convert to Main Unit / Convert to Reporting Unit / List By Unit in Transaction

Project Code

Group / Range

Project Description

Group / Range

 

The materials that are not tracked or tracked by lot are reported separately. The transactions of the materials tracked by Serial Number are displayed on a separate line for each Serial Number.

 

Cost Reports

 

The reports under this option are:

 

Summary Cost Analysis

 

This report is located in the Cost Reports menu of the Material Management section and is used to summarize the cost and profitability numbers of each material within certain dates. The information of each material is displayed as a line in the Summary Cost Analysis. The report contains the Material Code, Description, Amount of Input Material, Input Cost, Output Quantity, Output Material Amount, Output Cost, Sales Amount, Sales Cost, Profit and Profit Rate column information.

 

In the LOGO application, the Costing has to be run before generating the Summary Cost Analysis report.

 

The report filter options are:

 

Filter

Value

Listing Method

By Materials / By Warehouses

Run Costing Maintenance First

Yes / No

Slip Dates

Start / End

Material Type

Raw Material / Semi Finished Good / Finished Good / Mixed Case / Deposit Item / Fixed Asset / Consumer Good

Material Status

Active / Passive

Material Code

Group / Range

Material Description

Group / Range

Material Aux. Code

Group / Range

Material Auth. Code

Group / Range

Material Vendor Code

Group / Range

Material Group Code

Group / Range

Material Characteristics

Characteristic 1 - 10

Characteristic Code / Characteristic Values

Parent Material Class Code

Direct data entry / Group

Material Tracking Method

No Tracking / Lot / Serial / Serial Group

Variant Code

Group / Range

Variant Description

Group / Range

Variant Aux. Code

Group / Range

Transaction Type

Material Transaction / Promotion Transaction / Mixed Case Transaction/ Deposit Transaction / Fixed Asset Transaction / Optional Material Transaction

AR/AP Code

Group / Range

AR/AP Title

Group / Range

AR/AP Status

Active / Passive

AR/AP Aux. Code

Group / Range

Trading Group

Group / Range

Slip Type

(01) Purchase Receipt / (02) Retail Sales Return Dispatch / (03) Wholesale Return Receipt / (04) Consignment Return Dispatch / (05) Consignment Receipt / (06) Purchase Return Receipt / (07) Retail Sales Dispatch / (08) Wholesale Receipt / (09) Consignment Dispatch / (10) Consignment Return Receipt / (11) Scrap Slip / (12) Usage Slip / (13) Input From Production Slip / (14) Opening Slip / (25) Warehouse Transfer Slip / (26) Producer Slip / (50) Cycle Count Slip (Excess) / (51) Cycle Count Slip (Deficit)

Warehouse Slip Type

All / Generated from Material Slips / Generated from Nationalization Slip

Transaction G/L Code

Group / Range

Overhead Pool Code

Group / Range

Transaction Aux. Code

Group / Range

Disp. / Receipt

Unbilled Disp./Rec. / Billed Disp./Rec.

Disp. / Receipt Status

Actual / Proposal

Material Slip Status (Warehouse Slips)

Actual / Proposal

Report Unit

Unit Set / Unit

Units

Convert to Main Unit / Convert to Reporting Unit / List By Unit in Transaction

Slip Number

Start / End

Slip Aux. Code

Group / Range

Departments

Defined departments

Divisions

Defined divisions

Warehouses

Defined warehouses

Warehouse Cost Group

0 / 1 / 2

Currency Amount Type

Local Currency / Reporting Currency

Lot Number

Group / Range

Lot Description

Group / Range

Serial Number

Group / Range

Serial Description

Group / Range

Serial Group No.

Group / Range

Serial Group Description

Group / Range

Expiry Date

Start / End

Location Code

Group / Range

Has No Transactions

List / Do Not List

Cancellation Status

Not Cancelled Slips / Cancelled Slips

Adjustment Date

Date entry

Project Code

Group / Range

Project Description

Group / Range

Consider Inputs First For Daily Transactions

Yes / No

 

The Summary Cost Analysis report can be generated using the Reporting Currency Type or the Local Currency by making a selection in the Type of F. Currency Amount filter line. This filter line contains the Local Currency and Reporting Currency Type options. The total amount of the purchase and sales price differences for each material is listed in the Purchase Price Differences and Sales Price Differences columns. The date of the price difference invoices is not processed. What is important is the date of the transactions to which the price difference is applied.

 

The Sales Cost Differences column displays the total difference between the Material Sales Costs calculated without processing the price differences for the relevant material sales transaction and he Material Sales Cost calculated by processing the Purchase Price Differences.

 

Detailed Cost Analysis

 

This report is located in the Cost Reports menu of the Material Management section and is used to list all input and output transactions of each material by warehouse and the quantity, amount and profit information of these transactions sorted by date. The material information is separately listed for each material in the report.

 

The Material Name, Description, the Unit of the report and the Warehouse Name are displayed in the upper side. The report is generated with the Date, Slip Type, Input Quantity, Unit Price, input Material Amount, Cost, Output Quantity, output Material Amount, Profit and Profitability Rate information. The application runs the Costing automatically before generating the report. If the Costing is not required to be run, “No” must be selected in the filter line.

 

In the LOGO application, the default value of the Run The Costing First filter is set as “Yes”.

 

This report is used to obtain the cost and profit numbers of the required materials between the specified dates and according to the requested warehouses and connected Material groups, and by the cost type selected in the Parameters in detail. The profit and rate calculations for the Detailed Cost Analysis are done as follows:

 

Profit=(Output Material Amount + Sales Price Difference) - Output Cost

Rate=(Profit/Cost) * 100

 

In the LOGO application, the Costing has to be run before generating the Detailed Cost Analysis report.

 

The report filter options are:

 

Filter

Value

Listing Method

By Materials / By Warehouses

Run Costing Maintenance First

Yes / No

Slip Dates

Start / End

Material Type

Raw Material / Semi Finished Good / Finished Good / Mixed Case / Deposit Item / Fixed Asset / Consumer Good

Material Status

Active / Passive

Material Code

Group / Range

Material Description

Group / Range

Material Aux. Code

Group / Range

Material Authorization Code

Group / Range

Material Vendor Code

Group / Range

Material Group Code

Group / Range

Material (Class) Characteristics

Characteristic 1 - 10

Characteristic Code / Characteristic Values

Parent Material Class Code

Direct data entry / Group

Material Tracking Method

No Tracking / Lot / Serial / Serial Group

Variant Code

Group / Range

Variant Description

Group / Range

Variant Aux. Code

Group / Range

Transaction Type

Material Transaction / Promotion Transaction / Mixed Case Transaction/ Deposit Transaction / Fixed Asset Transaction / Optional Material Transaction

AR/AP Code

Group / Range

AR/AP Title

Group / Range

AR/AP Status

Active / Passive

AR/AP Aux. Code

Group / Range

Trading Group

Group / Range

Slip Type

(01) Purchase Receipt / (02) Retail Sales Return Dispatch / (03) Wholesale Return Receipt / (04) Consignment Return Dispatch / (05) Consignment Receipt / (06) Purchase Return Receipt / (07) Retail Sales Dispatch / (08) Wholesale Receipt / (09) Consignment Dispatch / (10) Consignment Return Receipt / (11) Scrap Slip / (12) Usage Slip / (13) Input From Production Slip / (14) Opening Slip / (25) Warehouse Transfer Slip / (26) Producer Slip / (50) Cycle Count Slip (Excess) / (51) Cycle Count Slip (Deficit)

Warehouse Slip Type

All / Generated from Material Slips / Generated from Nationalization Slip

Transaction G/L Code

Group / Range

Overhead Pool Code

Group / Range

Transaction Aux. Code

Group / Range

Dispatch/Receipt

Unbilled Dispatch/Receipt / Billed Dispatch/Receipt

Dispatch/Receipt Status

Actual / Proposal

Report Unit

Unit Set / Unit

Material Slip Status (Warehouse Slips)

Actual / Proposal

Units

Convert to Main Unit / Convert to Reporting Unit / List By Unit in Transaction

Slip Number

Start / End

Slip Aux. Code

Group / Range

Departments

Defined departments

Divisions

Defined divisions

Warehouses

Defined warehouses

Warehouse Cost Group

0 / 1 / 2

Currency Amount Type

Local Currency / Reporting Currency

Page Setup

Same Page / Different Page

Serial / Lot / Location Info

List /Do Not List

Lot Number

Group / Range

Lot Description

Group / Range

Serial Number

Group / Range

Serial Description

Group / Range

Serial Group No.

Group / Range

Serial Group Description

Group / Range

Expiry Date

Start / End

Location Code

Group / Range

Cancellation Status

Not Cancelled Slips / Cancelled Slips

Period Closing Info

List / Do Not List

Adjustment Date

Date entry

Consider Inputs First For Daily Transactions

Yes / No

 

If any of the billed or unbilled receipts is not wanted to be included in the Detailed Cost Analysis report, the Dispatch/Receipt Filter is used. If ‘all options are checked’ in this line, all receipts/dispatches will be included in the Detailed Cost Analysis regardless of their status as billed or unbilled.

 

The warehouses of which the transactions will be processed in the report are specified with the selection made in the Warehouses filter line. If more than one warehouse will be used, the defined Warehouses are listed.

 

In the LOGO application, all defined Warehouses are selected as default.

 

The Cost Analysis can be generated using the Reporting Currency Type or the Local Currency Type  by making a selection in the Type of F. Currency Amount filter line.

 

The report is generated with the Date, Slip Type, Input Quantity, Unit Price, Output Material Amount, Sales Price Difference, Cost, Sales Cost Differences, Profit and Profitability Rate information. The total amount of the purchase and sales price differences for each material is listed in the Purchase Price Differences and Sales Price Differences columns. The date of the price difference invoices is not processed. What is important is the date of the transactions to which the price difference is applied.

 

The Sales Cost Differences column displays the difference between the Material Sales Costs calculated without processing the price differences for the relevant material sales transaction and he Material Sales Cost calculated by processing the Purchase Price Differences.

 

Inventory Report

 

This report is located in the Cost Reports menu of the Material Management section and is used to display the latest inventory information for the requested materials at any date. Inventory means the “materials on hand”. The report filter options are:

 

Filter

Value

Material Type

Raw Material / Semi Finished Good / Finished Good / Mixed Case / Deposit Item / Fixed Asset / Consumer Good

Material Status

Active / Passive

Material Code

Group / Range

Material Description

Group / Range

Material Aux. Code

Group / Range

Material Authorization Code

Group / Range

Material Vendor Code

Group / Range

Material Group Code

Group / Range

Material (Class) Characteristics

Characteristic 1 - 10

Characteristic Code / Characteristic Values

Parent Material Class Code

Direct data entry / Group

Variant Code

Group / Range

Variant Description

Group / Range

Variant Aux. Code

Group / Range

Warehouse No.

Group / Range

Warehouse Cost Group

0 / 1 / 2

Listing Method

Details / Summary

Unit Set

Direct data entry

Last Inventory Date

Date entry

Inventory Level

Amount entry

Listing

By Code / By Description

Standard Cost Period

By Last Inventory Date / By Transaction Date

Project Code

Group / Range

Project Description

Group / Range

 

The warehouses of which the transactions will be processed in the Inventory Report are specified with the selection made in the Warehouses filter line. If more than one warehouse will be used, the defined Warehouses are listed.

 

In the LOGO application, all defined Warehouses are selected as default.

 

The report contains the Material Code, Description, Warehouse Name, Unit, Inventory Quantity, Inventory Amount (TL and Reporting Currency), Level and Inventory Date column information.

 

The difference between the Unit Inventory Amount calculated without processing the purchase price differences and the Inventory Amount calculated by processing the price differences is displayed in the Price Difference column.

 

Lot/Serial Inventory Report

 

This report is located in the Cost Reports menu of the Material Management section and is used to display the latest status information and transactions of the materials by Lot/Serial Numbers. The report filter options are:

 

Filter

Value

Listing Method

By Material / By Warehouses

Material Type

Raw Material / Semi Finished Good / Finished Good / Mixed Case / Deposit Item / Fixed Asset / Consumer Good / Commercial Good

Material Status

Active / Passive

Material Code

Group / Range

Material Description

Group / Range

Material Aux. Code

Group / Range

Material Auth. Code

Group / Range

Material Vendor Code

Group / Range

Material Group Code

Group / Range

Material (Class) Characteristics

Characteristic 1 - 10

Characteristic Code / Characteristic Values

Parent Material Class Code

Direct data entry / Group

Variant Code

Group / Range

Variant Description

Group / Range

Variant Aux. Code

Group / Range

Inventory Tracking Type

No Tracking / Lot / Serial

Warehouse No.

Defined warehouses

Warehouse Cost Group

Defined cost groups

List Material Slip Info

Yes / No

Unit Set

Group / Range

Last Inventory Date

Date entry

Lot / Serial No.

Group / Range

Lot / Serial Description

Group / Range

Standard Cost Period

By Last Inventory Date / By Transaction Date

Decisive Day Analysis

All / Over Dated / Not Over Dated

Decisive Day

Info entry

Project Code

Group / Range

Project Description

Group / Range

 

If the Production Control section is used, the report is generated with the Standard Unit Cost, Standard Cost Amount information and Standard Cost Amount as Reporting Currency.

 

If LIFO, FIFO and Physical cost are used as the costing method, the period range of the slip date and the Procurement Type of the material are processed to calculate the standard unit cost of the transactions in the Inventory Report. If the Procurement Type of the material is Purchase, what is important is the presence/absence of a defined Standard Cost for the period and plant in question. If the Procurement Type of the material is Production, what is important is the presence/absence of a defined Standard BOM Costs for the period and plant in question. If there is a Standard Cost record, it is reflected on the Standard Unit Cost field. If not, the cost will be 0. The Standard Cost Amount (TL) is calculated by multiplying the Standard Unit Cost (TL) with the Remaining Transaction Quantity.

 


Decisive Day Analysis in Inventory Report

 

The number of days is entered by the user into the Decisive Date field. Decisive Date is calculated by adding the number of decisive days specified to the Lot/Serial Input Date. Decisive Day can be written to the transaction line by selecting from the standard fields within the report design.

 

When Over Dated is selected in the Decisive Day Analysis filter, the Lot/Serial records that are present in the inventory even after the number of Decisive Days is passed after the Purchase Date are listed.

 

When Not Over Dated is selected in the Decisive Day Analysis filter, the Lot/Serial records for which the number of Decisive Day is not passed after the Purchase Date are listed.

 

When All is selected in the Decisive Day Analysis filter, the reporting is done processing the other report filters and ignoring the Decisive Day filter.

 

The Decisive Date Difference field added to the standard fields of the Report Design indicates the number of days between the Last Inventory Date and Decisive Date.

 

The RC Standard Cost Amount is calculated by multiplying RC Standard Unit Cost with the Remaining Transaction Quantity.

 

If the Last Inventory Date is selected in the standard cost filter line, the Standard Unit Cost and amount is calculated according to the Last Inventory Date and not to the period cost of the transactions constructing the inventory. The Standard Unit Cost and amounts are reported based on the standard cost defined for the period and the plant matching the Last Inventory Date.

 

If Average of On Hand, Average of inputs and Periodic Average are used as the costing method, the Standard Unit Cost and amounts are calculated by processing the Last Inventory Date specified in the Inventory Report filters. The standard cost defined for the plant and period matching with the Last Inventory Date is used for the calculation.

 

Location Inventory Report

 

This report is located in the Cost Reports menu of the Material Management section and is used to display the location inventory information. The filter options of the Location Inventory Report are:

 

Filter

Value

Listing Method

By Material / By Location

Material Type

Raw Material / Semi Finished Good / Finished Good / Mixed Case / Deposit Item / Fixed Asset / Consumer Good / Commercial Good

Material Status

Active / Passive

Material Code

Group / Range

Material Description

Group / Range

Material Aux. Code

Group / Range

Material Authorization Code

Group / Range

Material Vendor Code

Group / Range

Material Group Code

Group / Range

Material (Class) Characteristics

Characteristic 1 - 10

Characteristic Code / Characteristic Values

Parent Material Class Code

Direct data entry / Group

Inventory Tracking Type

Do Not Track / Lot Number / Serial Nr.

Warehouse No.

Defined warehouses

Warehouse Cost Group

Defined cost groups

Listing Material Slip Info

Yes / No

Unit Set

Group / Range

Last Inventory Date

Date entry

Location Code

Group / Range

Location Description

Group / Range

Standard Cost Period

By Last Inventory Date / By Transaction Date

Project Code

Group / Range

Project Description

Group / Range

 

If the Production Control section is used, the report is generated with the Standard Unit Cost, Standard Cost Amount information and Standard Cost Amount as Reporting Currency.

 

If LIFO, FIFO and Physical cost are used as the costing method, it won’t be available on the inventory report. The period range of the slip date and the Procurement Type of the material are processed to calculate the standard unit cost of the Detailed transactions. If the Procurement Type of the material is Purchase, what is important is the presence/absence of a defined Standard Cost for the period and plant of the material. If the Procurement Type of the material is Production, what is important is the presence/absence of a defined Standard BOM Cost for the period and plant in question. If there is a Standard Cost record, it is reflected on the Standard Unit Cost field. If not, the cost will be 0. The Standard Cost Amount (TL) is calculated by multiplying the Standard Unit Cost (TL) with the Remaining Transaction Quantity. The RC Standard Cost Amount is calculated by multiplying the RC Standard Unit Cost with the Remaining Transaction Quantity.

If the Last Inventory Date is selected in the standard cost filter line, the Standard Unit Cost and amount is calculated according to the Last Inventory Date and not to the period cost of the transactions constructing the inventory. The Standard Unit Cost and amounts are reported based on the standard cost defined for the period and the plant matching the Last Inventory Date.

 

If Average of On Hand, Average of inputs and Periodic Average are used as the costing method, the Standard Unit Cost and amounts are calculated by processing the Last Inventory Date specified in the Inventory Report filters. The standard cost defined for the plant and period matching with the Last Inventory Date is used for the calculation.

 

 

 

Standard Material Costs List

 

This report is located in the Cost Reports menu of the Material Management section and is used to list the standard material costs. The filter options of the Standard Material Costs are:

 

Filter

Value

Listing Method

By Materials / By Periods

Material Code

Group / Range

Material Description

Group / Range

Material Aux. Code

Group / Range

Material Auth. Code

Group / Range

Material Group Code

Group / Range

Parent Material Class Code

Group / Range

Variant Code

Group / Range

Variant Description

Group / Range

Variant Aux. Code

Group / Range

Period Code

Group / Range

Period Description

Group / Range

Period Start Date

Start / End

Period End Date

Start / End

Plants

Defined plants

Transaction Currency Type

Currency types

 

 

Materials Not Having Standard Cost

 

This report is located in the Cost Reports menu of the Material Management section and is used to list the materials with no material costs assigned. The filter options of the Materials Not Having Standard Cost List report are:

 

Filter

Value

Listing Method

By Material / By Period

Material Code

Group / Range

Material Description

Group / Range

Material Aux. Code

Group / Range

Material Auth. Code

Group / Range

Material Group Code

Group / Range

Parent Material Class Code

Group / Range

Procurement Type

Purchase / Production

Period Code

Group / Range

Period Description

Group / Range

Period Start Date

Start / End

Period End Date

Start / End

Plants

Defined plants

 

 

Production Cost Analysis

 

This report is located in Cost Reports menu of Material Management section. It is used to perform cost analysis of a bill of material, work order or a production order. The filter options of Production Cost Analysis report are:

 

Filter

Value

Listing Method

Summary / Detailed

Costing Method

Standard / Actual / IFRS Actual

Details of Listing

Material / Resource / Overhead

Date Range

Start / End

Finished Good Code

Group / Range

Finished Good Description

Group / Range

Finished Good Aux. Code

Group / Range

Finished Good Auth. Code

Group / Range

Production Order Number

Group / Range

Production Order Date

Start / End

Production Order Aux. Code

Group / Range

Production Order Status

Not Proceed / Proceeded / Stopped / Completed / Closed

Material Code

Group / Range

Material Description

Group / Range

Workstation Code

Group / Range

Workstation Description

Group / Range

Overhead Code

Group / Range

Overhead Description

Group / Range

Overhead Group Code

Defined group codes and descriptions

Variant Code

Group / Range

Variant Description

Group / Range

 

 

Cost Distribution Analysis

 

This report is located in the Cost Reports menu of the Material Management section and is used to view the cost distribution. The filter options of the Cost Distribution Analysis report are:

 

Filter

Value

Listing Method

By Materials / By service Invoices

Material Type

Raw Material / Semi Finished Good / Finished Good / Mixed Case / Deposit Item / Fixed Asset / Consumer Good / Commercial Good

Material Status

Active / Passive

Material Code

Group / Range

Material Description

Group / Range

Material Aux. Code

Group / Range

Material Auth. Code

Group / Range

Material Group Code

Group / Range

Material Characteristics

Characteristic 1-10 / Characteristic Code/Value

Parent Material (Class) Code

Selection from List

Service Type

Service Purchased / Service Sales

Service Purchase Code

Group / Range

Service Purchase Description

Group / Range

Service Purchase Aux. Code

Group / Range

Service Purchase Auth. Code

Group / Range

Service Sales Code

Group / Range

Service Sales Description

Group / Range

Service Sales Aux. Code

Group / Range

Service Sales Auth. Code

Group / Range

 

 

Sales Provision Distribution Analysis

 

This report is located in the Cost Reports menu of the Material Management section and is used to view the sales provision distribution. The filter options of the Sales Provision Distribution Analysis report are:

 

Filter       

Value

Listing Type

By Materials / By Service Invoices

Sales Provision Distribution Slip Date

Start / End

Service Invoice Date

Start / End

Material Type

Commercial Good / Mixed Case / Deposit Item / Fixed Asset / Raw Material / Semi Finished Good / Finished Good / Consumer Good

Material Status

Active / Passive

Material Code

Group / Range

Material Description

Group / Range

Material Aux. Code

Group / Range

Material Auth. Code

Group / Range

Material Group Code

Group / Range

Material Characteristics

Characteristic 1-10

Parent Material Class Code

Select from list

Service Type

Services Purchased / Services Sales

Service Purchase Code

Group / Range

Service Purchase Description

Group / Range

Service Purchase Aux. Code

Group / Range

Service Purchase Auth. Code

Group / Range

Service Sales Code

Group / Range

Service Sales Description

Group / Range

Service Sales Aux. Code

Group / Range

Service Sales Auth. Code

Group / Range


 

  • No labels