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 isselected,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 physicalmaterial 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 isselected,the barcode specified inBarcode 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 isselected,the barcode specified inBarcode 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 Classesare 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 theUnit 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 asColumn, 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 thematerial 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 theMaterial 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 Pricesin 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 materialis 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 Recordfor 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.
Code: The 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 | |
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 Slipssection, 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. |
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 Codesare 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 Classtransaction. 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.
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 LOGOapplication.
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. ThePost 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 Slipslist. 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. |
| 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 transactionsare 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 thatcost 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 thatservicedistribution 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 Closeoperation 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 Datecan 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 Dateand 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 theCosting 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 MaterialClass 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. Codeare 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 definedslips 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 Accountingfeature 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 LOGOapplication, 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 Setswindow 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 + Amountis 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 alsoindicates 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 priceis 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 warehousefrom 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 warehouseto 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 sectionand 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 |