| Element | Description |
|---|---|
| Total ABC code % | The total percentage of the criteria used to assign stock items to all ABC codes, 100%. |
| Column | Description |
|---|---|
| ABC code | The code defined in the system. |
| Description | A brief description of the code. |
| Counts per year | The number of stocktaking counts to be performed per year for the items with this code assigned. |
| ABC code % | A threshold value (%) of the criteria to be used to assign the stock items to this code. For details on assignment method, see About inventory ranking methods. |
| Button | Description |
|---|---|
| Release | Initiates document release, which changes the status of the adjustment to Released. |
| Reports | Provides direct access to the following inventory reports: |
| Element | Description |
|---|---|
| Ref. no. | The unique reference number of the adjustment, which the system automatically generates according to the numbering sequence assigned to adjustments in the Inventory preferences (IN101000). |
| Status | The status of the adjustment. The following options are available:
|
| Hold | A check box that, if selected, indicates that the receipt has the On hold status. Clear the check box to save adjustment with the Balanced status. |
| Date | The date when the adjustment was created. All transactions included in this document will have this transaction date. |
| Post period | The financial period to which the transactions from the adjustment should be posted. |
| External ref. | Any external reference number of the inventory adjustment document. |
| Description | A brief description of the document or the transactions entered. |
| Total qty. | The total quantity of stock items specified in the adjustment. |
| Control qty. | The manually entered quantity of items specified in the adjustment.
Note
This field is only available if the Validate document totals on entry option in the Inventory preferences (IN101000) is selected. Enter this value manually to confirm the total adjusted quantity of stock item as compared to the automatically calculated quantity of stock items included in this document. If the Control qty. and Total qty. values do not match, the system generates a warning message and the document cannot be saved. |
| Total cost | The total cost of stock items listed in the adjustment. |
| Control cost | The manually entered cost of stock items listed in the adjustment.
Note
This field is only available if the Validate document totals on entry option in the Inventory preferences (IN101000) is selected. Enter this value manually to confirm the total cost as calculated automatically for the document. If the Control cost and Total cost values do not match, the system generates a warning message and the document cannot be saved. |
| Button | Description |
|---|---|
| Add item | Opens the Item lookup dialog box so that you can add items to the adjustment document. |
| Inventory summary | Opens the Inventory summary (IN401000) window as a pop-up so you can view item availability data. |
| Element | Description |
|---|---|
| Item | The identifier of a particular item whose information you want to view. Leave the field blank to filter information by other criteria or type a string from the item ID to find the item. |
| Barcode | The barcode of the item to be listed. Leave the field blank to filter information by other criteria. |
| Item class ID | The item class of the items whose information you want to view. Leave the field blank to view information on items of all classes. |
| Show available items only | If you select this check box, the system will list only items whose available quantities are greater than zero in the table. |
| Warehouse | The warehouse where the item are stocked. Leave the field blank to view items from all warehouses.
Note
This field is only displayed if the Multiple warehouses functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Location | The location in the warehouse. Leave the field blank to view items in all locations.
Note
This field is only displayed if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Column | Description |
|---|---|
| Qty. selected | The quantity of the stock item (under the specified item ID and subitem code) in the base units that you want to add to the transfer. |
| Warehouse | The warehouse where the items are stocked. |
| Location | The location in the warehouse.
Note
This column is only displayed if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Item ID | The stock item by its item ID. |
| Description | The description of the item with the specified item ID and subitem code. |
| Base unit | The unit of measure used as a base unit for the stock item. |
| Qty. available | The available quantity of this item at the specified warehouse. |
| Qty. on hand | The quantity on hand of this item at the specified warehouse. |
| Button | Description |
|---|---|
| Add | Adds the selected items. |
| Add and close | Adds the selected items and closes the dialog box. |
| Cancel | Cancels the changes and closes the dialog box. |
| Element | Description |
|---|---|
| Batch no. | The reference number of the batch generated for the transfer. Click the number to open the Journal transactions (GL301000) window and view the transactions’ details. |
| Branch | The branch associated with the adjustment. |
| Button | Description |
|---|---|
| Process | Updates the replenishment parameters with the calculated values for the items you have selected in the table area. |
| Process all | Updates replenishment parameters (by replacing them with the calculated values) for all the items listed in the table area to determine whether they should be replenished and in what quantities. |
| Element | Description |
|---|---|
| Warehouse | The warehouse where the items to be shown are stocked. If you leave the field blank, the system displays the items of all warehouses.
Note
This field is only available if the Multiple warehouses functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Seasonality | The set of replenishment seasonality settings assigned to the items to be displayed. You can leave this field blank to view the items with various seasonality settings. |
| Item class | The item class of the items to be viewed. You can leave the field blank to view the items of various classes. |
| Column | Description |
|---|---|
| Selected | A check box you select to include this replenishment record in processing if you then click Process. |
| Warehouse | The warehouse where the stock will be replenished.
Note
This field is only available if the Multiple warehouses functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Item ID | The stock item for which stock replenishment is required. |
| Override default supplier | A check box that indicates to the system (if selected) that the default supplier is overridden for the warehouse. |
| Default supplier | The default supplier from which the item is generally purchased for stock replenishment, as specified for the item in the Stock items (IN202500) window. You can choose another supplier if necessary. |
| Default location | The location of the supplier from which the item is purchased by default. You can choose another supplier location if necessary.
Note
This field is only available if the Account locations functionality is enabled in the Enable/disable functionalities window. |
| Replenishment class | The replenishment class assigned to the item. |
| Override replenishment settings | This check box indicates (if selected) that the replenishment settings of the item have been overridden for the warehouse. |
| Seasonality | The set of seasonality settings for the item. |
| Replenishment method | The replenishment method assigned to the item. |
| Replenishment source | The source of replenishment for the item at this warehouse. |
| Replenishment warehouse | The warehouse that is the source of replenishment. |
| Override | This check box indicates (if selected) that the maximum shelf life parameter has been overridden for the warehouse. |
| Max. shelf life (days) | The maximum number of days the item can be stocked. |
| Override | This check box indicates (if selected) that the safety stock parameter has been overridden for this warehouse. |
| Safety stock | The safety stock value for the stock item as specified on the Replenishment info tab of the Item warehouse details (IN204500) window. |
| Safety stock suggested | The safety stock according to the forecast and the selected service level. |
| Override | This check box indicates (if selected) that the reorder point quantity of the item has been overridden for the warehouse. |
| Reorder point | The stock level that, when it has been reached, prompts the system to replenish the stock of the stock item. The minimum quantity of the stock item is specified on the Replenishment info tab of the Item warehouse details (IN204500) window. |
| Reorder point suggested | The reorder point quantity, according to the forecast. |
| Max. qty. | The maximum quantity of the item that can be stocked. |
| Max. qty. suggested | The maximum quantity of the item according to the forecast. |
| Override | This check box indicates (if selected) that the maximum quantity of the item has been overridden for the warehouse. |
| Last forecast date | The date of the last demand forecast. |
| Last forecast results application date | The date when the last demand forecast was applied. |
| Daily demand forecast | The daily demand for an item, according to the last forecast. |
| Daily demand forecast error (STDEV) | The standard deviation error for the daily demand according to the forecast. |
| Lead time average | The average lead time according to the forecast. |
| Lead time STDEV | The standard deviation for the average lead time according to the forecast. |
| Button | Description |
|---|---|
| Process | For the items you have selected, calculates the replenishment parameters according to the demand forecast method assigned to the item in the Stock items (IN202500) window. |
| Process all | Calculates the replenishment parameters for all items listed in the table. |
| Element | Description |
|---|---|
| Forecast date | The date of forecast calculation. |
| Action | Select one of the following options:
|
| Warehouse | The warehouse where the items to be displayed are stocked. If you leave the field blank, the system displays the items of all warehouses.
Note
This field is only displayed if the Multiple warehouses functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Seasonality | The seasonality settings assigned to the items to be shown. You can leave the field blank to view items with various seasonality settings. |
| Item class ID | The item class of the items to be viewed. You can leave the field blank to view items of multiple classes. |
| Column | Description |
|---|---|
| Warehouse | The warehouse of the stock item. |
| Item ID | The stock item for which stock replenishment is configured. |
| Override preferred supplier | This check box indicates to the system (if selected) that the preferred supplier is overridden. |
| Default supplier | The preferred supplier from which the item is generally purchased for stock replenishment, as specified for the item in the Stock items (IN202500) window. You can select another supplier if necessary. |
| Default location | The location of the supplier from which the item is purchased by default. You can select another supplier location if necessary.
Note
This column is only displayed if the Accounts locations functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Replenishment class | The replenishment class assigned to the item. |
| Override replenishment settings | This check box indicates to the system (if selected) that the replenishment settings has been overridden for the item at the warehouse. |
| Seasonality | The set of seasonality settings for the item. |
| Replenishment method | The replenishment method assigned to the item. |
| Replenishment source | The source of replenishment for the item at this warehouse. |
| Replenishment warehouse | The warehouse that is the source of replenishment.
Note
This column is only displayed if the Multiple warehouses functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Override | This check box indicates to the system (if selected) that the maximum shelf life parameter has been overridden for the warehouse. |
| Max. shelf life (days) | The maximum number of days the item can be stocked. |
| Override | This check box indicates to the system (if selected) that the safety stock parameter has been overridden for the warehouse. |
| Safety stock | The safety stock value for the item, which is specified on the Replenishment info tab of the Item warehouse details (IN204500) window. |
| Override | This check box indicates to the system (if selected) that the reorder point quantity has been overridden for the warehouse. |
| Reorder point | The stock level that, when it has been reached, will prompt the system to replenish the stock of the item. The minimum quantity of the stock item is specified on the Replenishment info tab of the Item warehouse details (IN204500) window. |
| Override | This check box indicates to the system (if selected) that the max. quantity has been overridden for the warehouse. |
| Max. qty. | The maximum quantity of the item that can be stocked. |
| Last forecast date | The date of the last demand forecast. |
| Daily demand forecast | The daily demand according to the last forecast. |
| Daily demand forecast error (STDEV) | The standard deviation error for the daily demand according to the forecast. |
| Lead time average | The average lead time according to the forecast. |
| Lead time STDEV | The standard deviation for the average lead time according to the forecast. |
| Reorder point suggested | The quantity (reorder point quantity) according to the forecast. |
| Safety stock suggested | The safety stock according to the forecast and the selected service level. |
| Max. qty. suggested | The maximum quantity of the item according to the forecast. |
| Button | Description |
|---|---|
| Close periods | Initiates the process of closing the chosen financial periods or those for which you have selected the check box in the Financial periods area.
Note
When the operation is completed successfully, the |
| Unreleased Documents | Generates the list of unreleased inventory documents for the selected financial periods (that is, the periods you have selected in the table), so you can view their details. The system generates this report in the PDF format and opens the created document. |
| Unposted to Inventory documents | Opens the All unreleased documents (GL65601S) report, which displays a list of all transactions that were entered but not released during the specified financial period. |
| Column | Description |
|---|---|
| Period | The identifier of the financial period. |
| Description | A description of the financial period. |
| Active | If you select this check box, the financial period can be used for posting transactions. This check box is read-only; to change the state of the financial period, use the Financial periods (GL201000) window. |
| Column | Description |
|---|---|
| FOB point ID | The ID of the point (such as a city or town) where the title of goods passes from the company to the customer or from the supplier to the company. You can use up to 20 characters, both letters and numbers. |
| Description | A description of the FOB point. You can use up to 30 characters, both numbers and letters. |
| Button | Description |
|---|---|
| Summary | Navigates to the Inventory summary (IN401000) window, where you can view the availability data of the stock item. |
| Element | Description |
|---|---|
| Item ID | The stock item for which you want to view data. You must select an item. |
| Warehouse | The warehouse for which you want to view data. Leave the field blank to view information about the stock item in all warehouses.
Note
This field is only displayed if the Multiple warehouses functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Location | The location for which you want to view data. Leave the field blank to view information on all locations.
Note
This field is only displayed if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Lot/serial no. | The lot or serial number for which you want to view data. Leave the field blank to view information not split by lot or serial numbers.
Note
This field is only displayed if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Base unit | Read only. This field shows the unit of measure (UoM) used as a base unit for this stock item. |
| On hand | Read only. This field shows the quantity on hand for this stock item. |
| Total addition | Read only. This field shows the total quantity of stock item to be added to the on-hand quantity at the warehouse. Computation is performed in accordance with availability calculation options specified for the item class. |
| Total deduction | Read only. This field shows the total quantity of stock item to be deducted from the on-hand quantity at the warehouse. Computation is performed in accordance with availability calculation options specified for the item class. |
| Available | Read only. This field shows the quantity of the stock item available at the warehouses. It is the sum of the quantity on hand plus the total addition value and minus the total deduction value. |
| Available for shipping | Read only. This field shows the quantity of the item available for shipping from this location. This value is calculated by the system based on the quantity on hand with the quantities shipped and on shipping deducted. |
| On loc. not available | The quantity of the stock item stored at locations not included in the availability calculation. For each warehouse location, the Include in qty. available option in the Warehouses (IN204000) window defines whether the quantity of items stored at this location is included in the quantity of available items.
Note
This field is only displayed if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled.
Note
If the functionality is disabled, all items from a single location (the MAIN location) are always available for shipping. |
| Expired [*] | The quantity of the stock item that has expired, based on the expiration date specified for the lot.
Note
This field is only displayed if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Sales order prepared | Read only. This field shows the quantity of the stock item listed on sales orders of the Sales, Common settings, and Inventory types with the On hold, Credit hold, Rejected, and Pending approval statuses. This quantity affects the available quantity only if the Deduct qty. on sales prepared option is selected for the item class (as reflected by a read-only check box to the right of the field). |
| Sales orders booked [**] | Read only. This field shows the quantity of the stock item listed on unreleased sales orders. This value is calculated as the total quantity of the item included in all sales orders after deduction of the quantities of shipped items and items being shipped. This quantity affects the available quantity only if the Deduct qty. on customer orders option is selected for the item class (as reflected by a read-only check box to the right of the field). |
| Sales orders allocated [**] | Read only. This field shows the quantity of the stock item on unconfirmed shipments. This quantity affects the available quantity only if the Deduct qty. shipping check box is selected for the item class (as reflected by a read-only check box to the right of the field). |
| Sales orders shipped [**] | Read only. This field shows the quantity of the stock item shipped according to the confirmed shipments. This quantity affects the available quantity only if the Deduct qty. shipped option is selected for the item class (as reflected by a read-only check box to the right of the field). |
| Back orders [**] | Read only. This field shows the quantity of the stock item on sales orders with the Back order status. Also includes the unallocated quantities (those which are unavailable at the specified locations) for On hold, Credit hold, Rejected, Pending approval, and Open orders of SA order type. This quantity affects the available quantity only if the Deduct qty. on back orders option is selected for the item class (as reflected by a read-only check box to the right of the field). |
| Inventory issues [**] | Read only. This field shows the quantity of the stock item included in the inventory issue documents that were not released yet. This quantity affects the available quantity only if the Deduct qty. on issues option is selected for the item class (as reflected by a read-only check box to the right of the field). |
| Sales order to purchase | Read only. This field shows the quantity of the stock item included in open purchase orders created for sales orders. This quantity doesn’t affect the item availability. |
| Sales order to drop-ship | Read only. This field shows the quantity of the stock item included in open purchase orders created for drop-ship orders. This quantity doesn’t affect the item availability.
Note
This field is only displayed if the Drop shipments functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Purchase prepared | Read only. This field shows the quantity of the stock item calculated for all purchase orders that are not yet open, that is, are in the On hold or Pending approval status. This value affects the Available quantity only if the Include qty. on purchase prepared option is selected for the item class in the Item classes (IN201000) window (as reflected by a read-only check field to the right of the field). |
| Purchase orders | Read only. This field shows the quantity of the stock item on all open purchase orders that affects the available quantity only if the Include qty. on purchase orders option is selected for the item class in the Item classes (IN201000) window (as reflected by a read-only check box to the right of the field). |
| Purchase order receipts | Read only. This field shows the quantity of the stock item on unreleased purchase receipts, which affects the available quantity only if the Include qty. on purchase orders receipts option is set for the item class (as reflected by a read-only check box to the right of the field). |
| Inventory receipts [*] | Read only. This field shows the quantity of the stock item on unreleased receipts. This quantity affects the available quantity only if the Include qty. on receipts option is selected for the item class (as reflected by a read-only check box to the right of the field). |
| In transit [**] | Read only. This field shows the quantity of the stock item on unreleased incoming two-step inventory transfers. This quantity affects the available quantity only if the Include qty. in transit option is selected for the item class (as reflected by a read-only check box to the right of the field). |
| In transit to sales order | Quantity of the stock item in transit to sales order. |
| Purchase for sales order (prepared) | Read only. This field shows the quantity of the stock item listed on purchase orders created for back orders and not yet open. This quantity doesn’t affect the item availability. |
| Purchase for sales order | Read only. This field shows the quantity of the stock item listed on open purchase orders created for sales orders. This quantity doesn’t affect the item availability. |
| Sales order receipts | Read only. This field shows the quantity of the stock item listed on purchase receipts that were created for back orders. This quantity doesn’t affect the item availability. |
| Drop-ship for sales order, prepared | Read only. This field shows the quantity of the stock item listed on drop-ship sales orders in the of On hold or Pending approval status. This value is not included in the quantity available.
Note
This column is only displayed if the Drop shipments functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Drop-ship for sales order | Read only. This field shows the quantity of the stock item listed on open drop-ship sales orders. This quantity doesn’t affect the item availability.
Note
This column is only displayed if the Drop shipments functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Drop-ship for sales order, receipts | Read only. This field shows the quantity of the stock item listed on receipts for drop-ship sales orders. This value is not included in the quantity available.
Note
This column is only displayed if the Drop shipments functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Column | Description |
|---|---|
| Workspace | The workspace where the document with the availability information about this stock item originated. |
| Allocation type | The type of allocation for the specified quantity of the stock item. |
| Allocation date | The date of the allocation. |
| Document type | The type of document used as a source of allocation information about the specified quantity of the stock item. |
| Ref. no. | The reference number of the document used as a source of allocation information about the specified quantity of the stock item. |
| Warehouse | The warehouse where the specified quantity of the stock item was allocated.
Note
This column is only displayed if the Multiple warehouses functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Location | The location where the specified quantity of the stock item was allocated.
Note
This column is only displayed if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Lot/serial number | The lot or serial number assigned to the specified quantity of the stock item.
Note
This column is only displayed if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Qty. | The quantity of the item allocated at the specified location. |
| Account ID | The identifier of the business account associated with the allocation. |
| Account name | The company name of the business account associated with the allocation. |
| Loc. not available | This check box indicates (if selected) that this quantity is not available (for example, broken) at the location. |
| Expired | This check box indicates (if selected) that the expiration date for quantity has passed. |
| Element | Description |
|---|---|
| Lot/serial no. | The lot or serial number for which you want to view transaction information. |
| Warehouse | The warehouse for which you want to view transaction information.
Note
This field is only displayed if the Multiple warehouses functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Location | The location for which you want to view transaction information.
Note
This field is only displayed if the Multiple warehouses and Multiple warehouse locations functionalities in the Enable/disable functionalities (CS100000) window are enabled. |
| Item ID | The stock item for which you want to view transaction information. |
| Start date | The start date of the date range for the inventory transactions to be displayed. |
| End date | The end date of the date range for the inventory transactions to be displayed. |
| Include landed cost in unit cost | A check box that indicates (if selected) that the system displays in the Unit cost column the sum of item unit cost and landed cost which is taken from a purchase receipt (if any) associated with the item. |
| Button | Description |
|---|---|
| Summary | Opens the Inventory summary (IN401000) window as a pop-up to display the availability data of the stock item. |
| Allocation details | Opens the Inventory allocation details (IN402000) window as a pop-up to display information about how the selected stock item is allocated at the specified warehouse. |
| Column | Description |
|---|---|
| Item ID | The stock item involved in the transaction. |
| Trans. date | The transaction date. |
| Trans. type | The inventory transaction type. For transactions originating in the Inventory workspace, the types can be:
For transactions originating in another workspace, the types can be:
|
| Ref. no. | The reference number of the document. |
| Warehouse | The warehouse where the inventory transaction was performed.
Note
This column is only displayed if the Multiple warehouses functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Location | The location where the inventory transaction was performed.
Note
This column is only displayed if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Lot/serial no. | The lot or serial number assigned to the unit or units with the specified item ID. |
| Expiration date | The expiration date of the specified unit or units under the same lot or serial number. |
| UoM | The unit of measure used for the stock item. |
| Quantity | The quantity of the item in the specified UoM. |
| Unit cost | The cost of the item for the specified UoM. |
| Sales order type | The type of the order that the inventory transaction is based on. |
| Order no. | The reference number of the order that the transaction is based on. |
| Customer no. | The number of the customer on the sales order that the transaction is based on. |
| Customer name | The name of the customer on the sales order that the transaction is based on. |
| Purchase receipt type | The type of the receipt the inventory transaction is based on. |
| Receipt no. | The reference number of the receipt the inventory transaction is based on. |
| Supplier | The ID of the supplier on the purchase receipt the inventory transaction is based on. |
| Supplier name | The name of the supplier on the purchase receipt the inventory transaction is based on. |
| Released | If this check box is selected, the inventory document has been released. |
| Description | The description of the transaction. |
| Element | Description |
|---|---|
| Batches | The number series to be used to assign reference numbers to batches generated for inventory documents. |
| Receipts/transfers | The series to be used to generate reference numbers for inventory documents created during receipt and transfer warehouse operations. |
| Issues | The series to be used to generate reference numbers for inventory documents created during issue warehouse operations. |
| Adjustments | The series to be used to generate reference numbers for inventory documents created during adjustment warehouse operations. |
| Kit assemblies | The series to be used to generate reference numbers for inventory documents created during kit assembly warehouse operations. |
| Stocktakings | The series to be used to generate reference numbers for inventory documents created during stocktaking operations. |
| Replenishments | The series to be used to generate reference numbers for replenishment documents. |
| Element | Description |
|---|---|
| Reschedule back orders | A check box that you select to indicate that the system should reschedule received quantities (update plan types) for sales orders with the back order status on release of inventory receipts. If this option is selected, you can run the Create shipments process in the Process orders (SO501000) window for back orders that can be fulfilled by the received quantities. If this option is not selected, after release of receipts, you have to open the back orders first (by using the Open orders action in the Process orders (SO501000) window) when you need to create shipments or you have to create shipments for back orders on a per-order basis. |
| Element | Description |
|---|---|
| Clearing account customers | The account to be used as an customer ledger clearing account for inventory transactions. |
| Clearing subaccount customers | The subaccount to be used with the customer ledger clearing account. |
| In-transit branch | The branch assigned to the in-transit warehouse, which is a hidden warehouse stock items become associated with when they have been issued from the source warehouse but have not yet been delivered to the destination warehouse. This field is available only if the Multiple warehouses feature is enabled in the Enable/disable functionalities (CS100000) window. |
| In-transit account | The account to be used to accumulate the amounts on uncompleted transfers. |
| In-transit sub. | The subaccount to be used with the in-transit account. |
| Work in progress account | The account to be used for work-in-progress transactions generated for kits in the processes of kit assembly and disassembly.
Note
This field is available only if the Kit assembly feature is enabled in the Enable/disable functionalities (CS100000) window. |
| Work in progress sub. | The subaccount to be used for the work-in-progress transactions generated for kits.
Note
This field is available only if the Kit assembly feature is enabled in the Enable/disable functionalities (CS100000) window. |
| Element | Description |
|---|---|
| Update general ledger | This check box (if selected) causes the inventory transactions to be posted to the General ledger. |
| Post summary when updating the general ledger | This check box (if selected) allows posting of batches with summary data to the General ledger. For these transactions, accounts that allow posting of summary values should be used. |
| Automatically post on release | This check box (if selected) causes inventory batches to be posted to the General ledger automatically once the inventory documents are released. |
| Element | Description |
|---|---|
| Hold documents on entry | This check box indicates (if selected) that new documents will be saved by default with the On hold status. If the check box is cleared, the documents by default can be saved in the Balanced status. |
| Validate document totals on entry | This check box indicates (if selected) that the user will need to enter the document control total before saving the document. |
| Add one unit per bar code | This check box indicates (if selected) that the item quantity on the receipt should be increased by one unit each time an item bar code is entered into the system, manually or by using a bar code scanner. |
| Automatically add receipt line for bar code | This check box indicates (if selected) that when a bar code scanner is used, lines should be added to receipts automatically once a bar code is scanned or entered. |
| Default stock item class | The default stock item class to be used to provide default settings for new items of the class and for new item classes. The stock item classes are defined using the Item classes (IN201000) window. |
| Default non-stock item class | The default non-stock item class to be used to provide default settings for new items of the class and for new item classes. The non-stock item classes are defined using the Item classes (IN201000) window. |
| Element | Description |
|---|---|
| Receipt reason code | The reason code to be used by default for generated receipts. You define the receipt reason codes, as well as the accounts and subaccounts related to these reason codes, by using the Reason codes (CS211000) window. |
| Reason code issue/return | The reason code to be used by default for all generated issue documents. You also define the issue reason codes, as well as the related accounts and subaccounts, in the Reason codes (CS211000) window. |
| Adjustment reason code | The reason code to be used by default for all generated adjustments. You define the adjustment reason codes, as well as the related accounts and subaccounts, in the Reason codes (CS211000) window. |
| Stocktaking reason code | The reason code to be used by default for all adjustment documents generated as the result of stocktaking. You define the stocktaking reason code, as well as the related accounts and subaccounts, in the Reason codes (CS211000) window. |
| Element | Description |
|---|---|
| Use tags | If you select this check box, Visma Net will use inventory tags for physical inventories. If you do not select this check box, the system will generate inventory documents with line numbers only. |
| Last tag number | The number of the last tag generated for physical inventory in the current financial year. Only digits are allowed. When the next physical inventory document ins generated, this value, incremented by 1, will be used as the first tag number in the document. Other tag numbers for the physical inventory document are generated successively by incrementing the previous tag number by 1. We recommend that you specify a relatively large number (for example 1000 or 10 000) as the Last tag number when you enter it for the first time. This makes the tag number s clearly distinguishable for the quantities specified on the tags. Then the users will not confuse tag number #1001 with a count quantity of 1 as they could with tag number #1 and a quantity of 1. |
| Turnover periods per year | The number of periods per year used to calculate the turnover for stock items. You can enter one of the following numbers here: 1, 2, 3, 4, 6 or 12. |
| Element | Description |
|---|---|
| Weight UoM | Here you can select the required unit of measurement. |
| Element | Description |
|---|---|
| Slow mover | Select this check box to see stock items that have had minimal customer demand based on the quantity on hand for a longer period of time. By selecting this check box, the field Not moved since becomes available, where you select a date. |
| Not moved since | Select a date to show slow moving stock items.
Note
This field only appears if the Slow mover check box is selected. |
| Item ID | The stock item for which you want to view data. You must select an item. |
| Warehouse | The warehouse for which you want to view data. Select a warehouse to view its data, or leave the field blank to view the data of the item at all warehouses.
Note
This field only appears if the Multiple warehouses functionality in the Enable/disable functionalities (CS100000) is enabled. |
| Expand by lot/serial number | A check box that you select to view the data related to each lot or serial number for the selected item on a separate line in the table. Clear the check box to instead view summary data for the item.
Note
This field only appears if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) is enabled. |
| Location | The location for which you want to view data; select a location, or make no selection to view data for all locations.
Note
This element only appears if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) is enabled. |
| Column | Description |
|---|---|
| Item ID | The selected stock item. Click the link in the Item ID column to open the Inventory allocation details (IN402000) window, where you can see more details about the allocation of the item. |
| Warehouse | The warehouse where the selected stock item is available.
Note
This column is only displayed if the Multiple warehouses functionality in the Enable/disable functionalities (CS100000) is enabled. |
| Location | The location where the selected stock item is available.
Note
This column is only displayed if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) is enabled. |
| Available | The quantity of the stock item available at the specific warehouse and location. |
| Available for shipment | The quantity of the stock item available for shipment at the specific warehouse and location, which is calculated based on the quantity on hand with the quantity of shipped items and items being shipped deducted. |
| Available for Issue | The quantity of the stock item available for issue at the specific warehouse and location, which is calculated based on the quantity on hand with the shipped quantity deducted. |
| Not available | The quantity of the stock item on locations for which the Include in qty. available option is not selected. |
| Sales order prepared | The quantity of the stock item listed on sales orders of the SO, CS, and IN types with the On hold, Credit hold, Rejected, and Pending approval statuses. This quantity affects the available quantity only if the Deduct qty. on sales on hold option is selected for the item class in the Item classes (IN201000) window. To view the list of sales orders, open the Inventory allocation details (IN402000) window. |
| Sales order booked | The quantity of the stock item booked according to sales orders. This value is calculated as the total quantity of the stock item included in all sales orders after deduction of the quantities of shipped items and items being shipped. To view the list of sales orders, open the Sales orders (SO301000) window. |
| Sales orders allocated | The quantity of the stock item currently being shipped according to the unconfirmed shipments. This value also includes the quantities on orders of the SA type with On hold, Credit hold, Pending approval, Rejected, and Open statues; it also includes the quantities specifically allocated for sales orders of the SO type with the On hold, Credit hold, Pending approval, and Open statuses. This quantity affects the available quantity only if the Deduct qty. allocated check box is selected for the item class. If the Multiple warehouses and Sales order to purchase order link features are enabled in the Enable/disable functionalities (CS100000) window, the sales orders allocated quantity includes the quantities on transfer orders based on sales orders. |
| Sales orders shipped | The quantity of the stock item shipped according to the confirmed shipments; also includes the quantities on open orders of the CS and IN types. This quantity affects the available quantity only if the Deduct qty. on shipments option is selected for the item class. |
| Back orders | The quantity of the stock item on sales orders with the Back order status. Also includes the unallocated quantities (those which are unavailable at the specified locations) for On Hold, Credit hold, Rejected, Pending approval, and Open orders of SA order type. This quantity affects the available quantity only if the Deduct qty. on back orders option is selected for the item class in the Item classes (IN201000) window. |
| Inventory issues | The quantity of the stock item included in the inventory issue documents that have not yet been released. This quantity affects the available quantity only if the Deduct qty. on issues option is selected for the item class in the Item classes (IN201000) window. |
| Inventory receipts | The quantity of the stock item included in the inventory receipt documents that have not yet been released. This quantity affects the available quantity only if the Include qty. on receipts option is selected for the item class in the Item classes (IN201000) window. |
| In transit | The quantity of the stock item included as in-transit quantities in the inventory transfer documents that have not yet been released. This quantity affects the available quantity only if the Include qty. in transit option is selected for the item class in the Item classes (IN201000) window. |
| In transit to sales order | The quantity of the stock item on transfer orders (not yet released) that were generated for sales order allocations.
Note
This column is available only if the Multiple warehouses feature is enabled in the Enable/disable functionalities (CS100000) window. |
| In assembly demand | The quantity of the stock item included in unreleased kit assembly documents as components or kits, depending on whether the item is a kit or a kit component. This quantity affects the available quantity only if the Deduct qty. of kit assembly demand option is selected for the item class in the Item classes (IN201000) window.
Note
This column is available only if the Kit assembly feature is enabled in the Enable/disable functionalities (CS100000) window. |
| In assembly supply | The quantity of the stock item listed on unreleased kit assembly documents. This quantity affects the available quantity only if the Include qty. of kit assembly supply option is selected for the item class in the Item classes (IN201000) window.
Note
This column is available only if the Kit assembly feature is enabled in the Enable/disable functionalities (CS100000) window. |
| Purchase prepared | The quantity of the stock item listed on purchase orders with the On hold and Pending approval statuses. This value affects the available quantity only if the Include qty. on purchase on hold option is selected for the item class in the Item classes (IN201000) window. |
| Purchase orders | The quantity of the stock item included in open purchase orders. To view the purchase orders, open the Purchase orders (PO301000) window. This value affects the available quantity only if the Include qty. on purchase orders option is selected for the item class in the Item classes (IN201000) window. |
| Purchase order receipts | The quantity of the stock item included in the purchase receipts that have not yet been released. To view the purchase receipts, open the Purchase receipts (PO302000) window. This quantity affects the available quantity only if the Include qty. on purchase order receipts option is set for the item class. |
| Expired | The quantity of the stock item that has reached its expiration date.
Note
This column is only displayed if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) is enabled. |
| On hand | The quantity of the stock item available on hand at the specified warehouse and location. |
| Sales order to purchase | The quantity of the stock item included in unreleased sales orders requiring creating purchase orders. |
| Purchase for sales order | The quantity of the stock item listed on open purchase orders created for sales orders. This value is not included in the quantity available.
Note
This column is available only if the Sales order to purchase order link feature is enabled in the Enable/disable functionalities (CS100000) window. |
| Purchase for sales order (prepared) | The quantity of the stock item listed on purchase orders with the On hold and Pending approval statuses created for back orders. This value is not included in the quantity available.
Note
This column is available only if the Sales order to purchase order link feature is enabled in the Enable/disable functionalities (CS100000) window. |
| Purchase for sales order receipts | The quantity of the stock item listed on purchase receipts for orders that were created for sales orders. This value is not included in the quantity available.
Note
This column is available only if the Sales order to purchase order link feature is enabled in the Enable/disable functionalities (CS100000) window. |
| Sales order to drop-ship | The quantity of the stock item included in open purchase orders created for drop-ship orders.
Note
This column is only displayed if the Drop shipments functionality in the Enable/disable functionalities (CS100000) is enabled. |
| Drop-ship for sales order | The quantity of the stock item listed on open drop-ship orders. This value is not included in the quantity available.
Note
This column is only displayed if the Drop shipments functionality in the Enable/disable functionalities (CS100000) is enabled. |
| Drop-ship for sales order, prepared | The quantity of the stock item listed on drop-ship sales orders with a status of On hold or Pending approval; this value is not included in the quantity available.
Note
This column is only displayed if the Drop shipments functionality in the Enable/disable functionalities (CS100000) is enabled. |
| Drop-ship for sales order, receipts | The quantity of the stock item listed on receipts for drop-ship sales orders; this value is not included in the quantity available.
Note
This column is only displayed if the Drop shipments functionality in the Enable/disable functionalities (CS100000) is enabled. |
| Base unit | The unit of measure (UoM) selected as the base unit for the stock item in the Stock items (IN202500) window. |
| Estimated unit cost | The estimated unit cost of the selected stock item. |
| Estimated total cost | The estimated total cost of the stock item available at the specified warehouse and location. |
| Button | Description |
|---|---|
| Summary | Navigates to the Inventory summary (IN401000) window, from which you can view the availability data of the stock item. |
| Allocation details | Navigates to the Inventory allocation details (IN402000) window, from which you can view information about how the selected stock item is currently distributed among warehouses and locations. |
| Element | Description |
|---|---|
| Inventory account | The inventory account for which you want to view the posted inventory transactions. |
| Subaccount | The subaccount for which you want to view the posted inventory transactions. |
| Period | The financial period for which you want to view the posted inventory transactions. |
| By financial period | A check box that you select to view the inventory transactions grouped by financial period. |
| Item ID | The stock item for which data will be displayed. |
| Warehouse | The warehouse for which data will be displayed.
Note
This field is only displayed if the Multiple warehouses functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Element | Description |
|---|---|
| Start date | The start date of the date range for the inventory transactions to be displayed. |
| End date | The end date of the date range for the inventory transactions to be displayed. |
| Summary by day | A check box that you select to display only summary values for each day in the table. Clear this check box to display detailed information for each day within the selected period. |
| Period start date | Read only. This value displays the start date of the selected financial period. |
| Period end date | Read only. This value displays the end date of the selected financial period. |
| Column | Description |
|---|---|
| Account | The account used to post the inventory transaction. |
| Subaccount | The subaccount used to post the inventory transaction. |
| Trans. type | The inventory transaction type, which can be a transaction type related to an inventory operation, or a transaction type, used in another system workspace if the account was shared by both that workspace and the Inventory workspace.
|
| Ref. no. | The reference number of the transaction. |
| Item ID | The stock item used in this inventory transaction. |
| Cost sub item | The sub item of the stock item if item cost is split by sub item segment values.
Note
This column is only displayed if the Stocky sub items functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Warehouse | The warehouse where the transaction was performed.
Note
This column is only displayed if the Multiple warehouses functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Location (if costed) | The location where the transaction was performed.
Note
You can only select locations for which the Cost separately check box on the Locations table tab in the Warehouses (IN204000) window is selected.
Note
This column is only displayed if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Cost adjustment | A read-only check box which (if selected) indicates that cost adjustment was generated for the transaction. |
| Date | The transaction date. |
| Beginning balance | The account beginning balance (before the transaction). |
| Debit | The debit amount related to the transaction. |
| Credit | The credit amount related to the transaction. |
| Ending balance | The account’s ending balance (after the transaction). |
| Period | The financial period to which the transaction was posted. |
| Transaction period | The financial period when the transaction was created. |
| Qty. | The quantity of the stock item involved in the transaction. |
| Unit cost | The unit cost of the stock item used in this transaction. |
| Description | The transaction description. |
| Sales order type | The type of order for items sold or to be sold. |
| Sales order no. | The number of the sales order for items sold or to be sold. |
| Purchase order receipt no. | The number of the purchase receipt for items purchased. |
| Button | Description |
|---|---|
| Summary | Navigates to the Inventory summary (IN401000) window to display the availability data of the stock item. |
| Allocation details | Navigates to the Inventory allocation details (IN402000) window so you can view information about the allocation of the selected stock item at the specific warehouse. |
| Element | Description |
|---|---|
| Period | (Required) The financial period for which you want to view inventory transactions. |
| By financial period (without running values) | A check box that you select to display the inventory transactions by financial period, and to not display the running values ( Beginning quantity, Ending quantity, Beginning balance, and Ending balance ) in the table. If the check box is cleared, the inventory transactions will be selected by the date range in the specified financial period and the running values will be displayed. |
| Warehouse | The warehouse for which you want to view inventory transactions.
Note
This field is only displayed if the Multiple warehouses functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Location | The location for which you want to view inventory transactions.
Note
This field is only displayed if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Item ID | The stock item for which you want to view inventory transactions. |
| Lot/serial no. | The lot or serial number for which you want to view inventory transactions. A value can be selected only for stock items with lot or serial numbers.
Note
This field is only displayed if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Sub item | The subitem of the stock item for which you want to view inventory transactions.
Note
This field is only displayed if the Stock sub items functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Element | Description |
|---|---|
| Start date | The start date of the date range for the inventory transactions to be displayed. |
| End date | The end date of the date range for the inventory transactions to be displayed. |
| Summary by day | A check box that you select to view only summary values for each day in the specified period. Clear this check box to display detailed information for each day within the specified period. |
| Include unreleased (without costs) | A check box that you select to view unreleased transactions along with posted transactions. All types of transactions will be displayed without costs. |
| Period start date | Read only. This value shows the start date of the selected financial period. |
| Period end date | Read only. This value shows the end date of the selected financial period. |
| Column | Description |
|---|---|
| Date | The date when the inventory transaction was performed. |
| Trans. type | The inventory transaction type. For transactions originating in the Inventory workspace, the types can be:
For transactions originating in another workspace, the types can be:
|
| Ref. no. | The reference number of the transaction. |
| Warehouse | The warehouse where the inventory transaction was performed.
Note
This column is only displayed if the Multiple warehouses functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Location | The location where the inventory transaction was performed.
Note
This column is only displayed if the Stock sub items functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Lot/serial number | The lot or serial number involved in the inventory transaction.
Note
This column is only displayed if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Period | The financial period to which the transaction was posted. |
| Transaction period | The financial period in which the transaction was created. |
| Released | This check box (if selected) indicates that the transaction was released. |
| Beginning qty | The quantity of the stock item in the beginning of the selected period. |
| Qty. in | The quantity of the stock item accepted at the warehouse within the selected period. |
| Qty. out | The quantity of the stock item removed from the warehouse within the selected period. |
| Ending qty. | The quantity of the stock item at the end of the selected period. |
| Beginning balance [*] | The inventory balance in the beginning of the selected period. |
| Cost in [*] | The cost of the stock items accepted at the warehouse within the selected period. |
| Cost out [*] | The cost of the stock items removed from the warehouse within the selected period. |
| Ending balance [*] | The inventory balance at the end of the selected period. |
| Unit cost in/out [*] | The cost of the unit of the item of inventory involved in the inventory transactions within the selected period. |
| Sales order type | The type of the sales order involved. |
| Sales order no. | The reference number of the sales order involved. |
| Purchase order receipt no. | The reference number of the purchase order involved. |
| Doc. type | The type of the documents within the selected period. |
| Grid line no. | The number of the grid line. |
| Item ID | The ID of the selected stock item. |
| Button | Description |
|---|---|
| Summary | Navigates to the Inventory summary (IN401000) window to display the availability data of the stock item. |
| Allocation details | Navigates to the Inventory allocation details (IN402000) window to display information about how the selected stock item is allocated at the specified warehouse. |
| Element | Description |
|---|---|
| Item ID | The stock item for which you want to view transaction information. |
| Warehouse | The warehouse for which you want to view transaction information.
Note
This field is only displayed if the Multiple warehouses functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Location | The location for which you want to view transaction information.
Note
This field is only displayed if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Lot/serial no. | The lot or serial number for which you want to view inventory transactions (if the stock item has lot or serial numbers).
Note
This field is only displayed if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Start date | The start date of the date range for the inventory transactions to be displayed. |
| End date | The end date of the date range for the inventory transactions to be displayed. |
| Summary by day | A check box that you select to display only the summary information for each day in the table. Clear this check box to display detailed information for each day within the selected period. |
| Include unreleased | A check box that you select to display the non-released transactions along with released transactions in the table. |
| Include landed cost in unit cost | A check box that you select to include the landed cost in unit cost. |
| Column | Description |
|---|---|
| Date | The transaction date. |
| Trans. type | The inventory transaction type. For transactions originating in the Inventory workspace, the types can be:
For transactions originating in another workspace, the types can be:
|
| Ref. no. | The reference number of the transaction. |
| Warehouse | The warehouse where the inventory transaction was performed.
Note
This column is only displayed if the Multiple warehouses functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Location | The location where the inventory transaction was performed.
Note
This column is only displayed if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Lot/serial number | The lot or serial number involved in the inventory transaction.
Note
This column is only displayed if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Released | A check box that indicates (if selected) that the transaction has been released. |
| Beginning qty. | The quantity of the selected stock item available at this warehouse before the inventory transaction was made. |
| Qty. in | The quantity of the selected stock item that were received at this warehouse as the result of the inventory transaction. |
| Qty. out | The quantity of the selected stock item that were issued from this warehouse as the result of the inventory transaction. |
| Ending qty. | The quantity of the selected stock item that were available at this warehouse after the inventory transaction was made. |
| Unit cost | The unit of measure used for the stock item. |
| Sales order type | The type of the sales order involved. |
| Sales order no. | The reference number of the sales order. |
| Purchase order receipt no. | The reference number of the purchase order. |
| Created by | The person who created the inventory transaction. |
| Doc. type | The type of the document |
| Grid line no. | The number of the grid line. |
| Item ID | The stock item of the inventory transaction. |
| Period | The financial period to which the transaction was posted. |
| Transaction period | The financial period when the transaction was created. |
| Button | Description |
|---|---|
| View |
|
| Element | Description |
|---|---|
| Period | The financial period for which you want to view data. This is a required element. |
| By financial period | A check box that you select to group the inventory transactions in the table by financial period. |
| Warehouse | The warehouse for which you want to view data.
Note
This field is only displayed if the Multiple warehouses functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Location | The location for which you want to view data.
Note
This field is only displayed if the Multiple warehouses and Multiple warehouse locations functionalities in the Enable/disable functionalities (CS100000) window is enabled. |
| Item ID | The stock item for which you want to view data. |
| Show items without movement | A check box that you select to display information on stock items for which no inventory transactions were made within the selected period. |
| Element | Description |
|---|---|
| Warehouse details | If you select this check box, the system displays the warehouse data in a single row of the table shown below. Clear this check box to show the summary information for all warehouses. |
| Location details | If you select this check box, the system displays the location data in a single row of the table shown below. Clear this check box to show the summary data for all locations. |
| Column | Description |
|---|---|
| Period | The financial period of the transaction summary data. |
| Item ID | The stock item for which the transaction summary data is displayed. |
| Warehouse | The warehouse for which the transaction summary data is displayed.
Note
This column is only displayed if the Warehouse details check box is selected, and if the Multiple warehouses functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Location | The location for which the transaction summary data is displayed.
Note
This column is only displayed if the Location details check box is selected, and if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Beginning qty. | The beginning quantity of the stock item (at the start of the selected period). |
| Issued | The issued quantity of the stock item for the selected period. |
| Received | The received quantity of the stock item for the selected period. |
| Sales | The quantity of the stock item in sales operations for the selected period. |
| Credit notes | The quantity of the stock item on credit note documents for the selected period. |
| Drop-ship sales | The quantity of the stock item included in the drop ship orders within the selected period.
Note
This column is only displayed if the Drop-shipments functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Transfer in | The quantity of the stock item transferred into the warehouse within the selected period. |
| Transfer out | The quantity of the stock item transferred out of the warehouse within the selected period. |
| Adjusted | The quantity of the stock item on adjustment documents created within the selected period. |
| Ending qty. | The quantity of the stock item at the end of the selected period. |
| Description | The description of the item. |
| Button | Description |
|---|---|
| Release | Initiates the release of the issue, which changes the status of the issue to Released. |
| Reports | Provides direct access to the following inventory reports: |
| Element | Description |
|---|---|
| Ref. no. | The unique reference number of the issue, which the system automatically assigns in accordance with the numbering sequence assigned to issues in the Inventory preferences (IN101000) window. |
| Status | The current status of the issue document. The following options are available:
|
| Hold | A check box that, if selected, indicates that the issue document has the On hold status. You can clear the check box to save it with the Balanced status. |
| Date | The date when the issue document was created. All transactions included in this document will have this transaction date. |
| Post period | The financial period to which transactions from the document should be posted. |
| External ref. | The external reference number of the inventory issue document (for example, the supplier’s reference code). |
| Description | A brief description of the inventory issue or its transactions. |
| Total qty. | The total quantity of stock items, which the system calculates automatically, for the document. |
| Control qty. | The manually entered quantity of stock items. Control qty. is available only if the Validate document totals on entry option is selected in the Inventory preferences (IN101000) window. If the Control qty. and Total qty. values do not match, the system generates a warning message and the issue cannot be saved. |
| Total amount | The total amount, calculated as a sum of amounts for all inventory issue operations included in this issue document. |
| Control amount | The manually entered summary amount for all specified stock items. Control amount is available only if the Validate document totals on entry option is selected in the Inventory preferences (IN101000) window. If the Control amount and Total a mount values do not match, the system generates a warning message and the issue cannot be saved. |
| Button | Description |
|---|---|
| Allocations | Opens the Allocations dialog box, from which you can define locations, lot or serial numbers, quantities, and expiration dates for the stock item received. |
| Add item | Opens the Item lookup dialog box so that you can add an item to the receipt. |
| Inventory summary | Opens the Inventory summary (IN401000) window as a pop-up so that you can view item availability data. |
| Column | Description |
|---|---|
| Branch | The branch of the inventory issue operation. |
| Trans. type | The type of inventory issue transaction. Select one of the following types:
|
| Item ID | The item ID of the stock item. Stock items are maintained by using the Stock items (IN202500) window. |
| Warehouse | (This column appears only if the Warehouses functionality is enabled in your system.) The warehouse from which the item is issued. |
| Location | (This column appears only if the Warehouse locations functionality is enabled in the Enable/disable functionalities (CS100000) window.) The warehouse location from which the item is issued. |
| Quantity | The quantity of the specified item (in the units of measure indicated below). |
| UoM | The unit of measure used for the stock item. |
| Unit price | The price of the specified unit of this stock item. |
| Manual amount | The extended price of the specified stock item, calculated automatically as the unit price multiplied by the quantity of the stock item involved in the inventory issue operation. The value can be edited manually later, for example, to round up or down the value. |
| Unit cost | The cost of the specified unit of this stock item. |
| Cost | The extended cost of the specified stock item. An extended cost is calculated automatically as the unit cost multiplied by the quantity of units involved in this transaction. The value can be edited manually later, for example, to round up the number. |
| Lot/serial no. | The lot or serial number of the stock item. To specify the lot or serial numbers of the particular units, click Allocations in the table toolbar. If multiple serial or lot numbers were specified, the column displays <SPLIT>. This column appears only if the Lot and serial tracking functionality is enabled. |
| Expiration date | The expiration date of the specified stock item. This column appears only if the Lot and serial tracking functionality is enabled. |
| Reason code | The reason code for the inventory transaction. |
| Project | The project with which this transaction is associated, or the code indicating that this transaction is not associated with any project; the non-project code is specified in the Project accounting preferences (PM101000) window. This column appears if the Projects module has been enabled and activated. |
| Project task | The particular task of the project with which this transaction is associated. This column appears if the Projects module has been enabled and activated. |
| Description | A brief description of the transaction. |
| Element | Description |
|---|---|
| Unassigned qty. | The quantity of the stock item that has no location specified or lot or serial numbers assigned. |
| Quantity to generate | The quantity of the stock item for which lot or serial numbers should be generated. |
| Lot/serial number from | The lot or serial number to be used as a start number. This field appears only if the Lot and serial tracking functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Generate (button) | A button that you click to initiate the generation of lot or serial numbers. (This button appears only if the Lot and serial tracking functionality is enabled in the Enable/disable functionalities (CS100000) window.) |
| Column | Description |
|---|---|
| Location | (This column appears only if the Warehouse locations functionality is enabled in the Enable/disable functionalities (CS100000) window.) The location in the warehouse. |
| Lot/serial no. | (This column appears only if the Lot and serial tracking functionality is enabled in the Enable/disable functionalities (CS100000) window.) The serial number of the unit of stock item or the lot number of the quantity of stock item received. |
| Quantity | The quantity of the stock item with the same sub item code and the same lot number. It is 1 for items with serial numbers. |
| UoM | The unit of measure (UoM) for the specified quantity of the stock item. |
| Expiration date | (This column appears only if the Lot and serial tracking functionality is enabled in the Enable/disable functionalities (CS100000) window.) The expiration date of the specified quantity of the stock item. |
| Button | Description |
|---|---|
| OK | Saves the records generated. |
| Element | Description |
|---|---|
| Item | The ID of a particular item whose information you want to view. Leave the field blank to filter information by other criteria or type a string from the item’s item ID to find the it. |
| Barcode | The bar code of the item to be listed. Leave the field blank to filter information by other criteria. |
| Item class ID | The item class of the items whose information you want to view. Leave the field blank to view information on items of all classes. |
| Warehouse | (This field is available for selection only if the Warehouses functionality is enabled in the Enable/disable functionalities (CS100000) window.) The warehouse where the item are stocked. Leave the field blank to view items from all warehouses. |
| Location | (This field appears only if the Warehouse locations functionality is enabled in your system.) The location in the warehouse. Leave the field blank to view items in all locations. |
| Show available items only | A check box that you select if only items whose available quantities are greater than zero should be listed in the table. |
| Column | Description |
|---|---|
| Qty. selected | The quantity of sales units of the stock item that you want to add to the document. |
| Warehouse | (This column appears only if the Warehouses functionality is enabled in your system.) The warehouse where the items are stocked. |
| Location | (This column appears only if the Warehouse locations functionality is enabled in the Enable/disable functionalities (CS100000) window.) The location in the warehouse. |
| Item ID | The stock item by its item ID. |
| Description | The description of the item with the specified item ID. |
| Base unit | The unit of measure used as a base unit for the stock item. |
| Qty. available | The available quantity of this item at the specified warehouse and location. |
| Qty. on hand | The quantity on hand of this item at the specified warehouse and location. |
| Button | Description |
|---|---|
| Add | Adds the selected items. |
| Add and close | Adds the selected items and closes the dialog box. |
| Cancel | Cancels the changes and closes the dialog box. |
| Element | Description |
|---|---|
| Batch no. | The reference number of the batch generated for the issue. Click the number to open the Journal transactions (GL301000) window and view the details of the transactions. |
| Branch | The branch that issues the products. |
| Button | Description |
|---|---|
| Actions | Provides the following menu commands, which you can use to invoke actions:
|
| Element | Description |
|---|---|
| Class ID | The unique identifier of the item class. |
| Description | A description of the item class. > [!NOTE] > This field supports the multi-language functionality, where you can translate the entered text to multiple languages. For more information, see: About multi-language support |
| Element | Description |
|---|---|
| Stock item | If you select this check box, this class only includes stock items. |
| Allow negative quantity | If you select this check box, negative quantities for items of this class are allowed.
Note
This setting should be avoided in your day-to day operations, as it will lead to differences between the physical values and the system values. This makes it difficult to do an inventory reconciliation. The reason why this setting exists is because there may be a need to allow negative quantities in given situations, where the warehouse needs to be corrected. |
| Webhook notification | If you select this check box, Webhook notifications are enabled for the item class. |
| Item type | The item type that will be selected by default for new items of this item class. For stock items, you can select one of the following options:
For non-stock items, you can select one of the following options:
The types of non-stock items are used mostly for informational purposes, except for the Labour; the items of this type appear on the lists filtered by Labour item type for selection in specific UI elements in windows related to project accounting, organisation structure, and employee time and expenses. |
| Valuation method | The valuation method to be assigned by default to all stock items of the class. You can select one of the following options:
Note
The option Specific only appears if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Posting class | The posting class selected for the item class. Use the Posting classes (IN206000) window to define posting classes and their settings. |
| Lot/serial class | The lot/serial class to be assigned by default to new items of this item class. Use the Lot/serial classes (IN207000) window to define lot/serial classes and their settings.
Note
This element only appears if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Price class | The price class to be assigned by default to new items of this item class. Use the Item price classes (IN209000) window to define lot/serial classes and their settings. |
| Default warehouse | The warehouse that will be used by default for receiving and issuing the items of this item class.
Note
This element only appears if the Multiple warehouses functionality in the Enable/disable functionalities (CS100000) window is enabled.
Note
If not, the MAIN warehouse is used as the default warehouse. |
| Element | Description |
|---|---|
| VAT category | The VAT code to be assigned by default to new items of this item class. VAT categories are defined by using the VAT categories (TX205500) window. |
| Sales VAT category | The VAT category for sales. |
| Export VAT category | The VAT category for export sales. |
| Sales EU VAT category | The VAT category for sales within the EU. |
| Exempt VAT sales VAT category | The VAT category for VAT-exempt sales. |
| Expense VAT category | The VAT category for purchases. |
| Import VAT category | The VAT category for import purchases. |
| Expense EU VAT category | The VAT category for import purchases within the EU. |
| Exempt VAT expense VAT category | The VAT category for VAT-exempt purchases. |
| Element | Description |
|---|---|
| Availability calculation rule | The unique ID of the availability calculation rule. You can use up to 10 characters, both numbers and letters. |
| Description | The description of the availability calculation rule. |
| Deduct qty. on open issues | If you select this check box, the system deducts (for items of the class) the quantities of issued items from the available quantities of these items. The documents in the On hold and Balanced statuses are used for availability calculation. |
| Deduct qty. on sales on hold | If you select this check box, the system will deduct the quantities of the item on sales orders (of the SO, IN, and CS types) with the On hold, Credit hold, Pending approval, and Rejected statuses from the available quantity. The quantity of each item on sales orders with these statuses is shown in the Sales order prepared field in the Inventory allocation details (IN402000) window. |
| Deduct qty. on sales orders | If you select this check box, the system will deduct (for items of the class) the quantities of items on sales orders with the Open status from the available quantities of these items. The item’s quantity on these sales orders is shown in the Sales orders booked field in the Inventory allocation details (IN402000) window. |
| Deduct qty. on shipments | If you select this check box, the system will deduct (for items of the class) the quantities of shipped items from the available quantities of these items. The item’s quantity on these sales orders is shown in the Sales orders shipped field in the Inventory allocation details (IN402000) window. |
| Deduct qty. allocated | If you select this check box, the system will deduct (for items of the class) the quantities of items being prepared for shipping (on unconfirmed shipments) and the quantities that were specifically allocated for sales orders (of the SA and SO types) from the available quantities of these stock items. The orders with the On hold, Credit hold, Rejected, Pending approval, and Open statuses are used for this calculation. The item’s quantity on these sales orders is shown in the Sales orders allocated field in the Inventory allocation details (IN402000) window. |
| Deduct qty. of kit assembly demand | If you select this check box, the system will deduct (for items of the class) the quantities of items allocated for kit assembly from the available quantities of these items. The documents with the On hold and Balanced statuses are used for availability calculation.
Note
This check box is available only if the Kit assembly functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Deduct qty. on back orders | If you select this check box, the system will deduct (for items of the class) the quantities of items allocated to sales orders with the Back order status from the available quantity of these items. The quantities on these sales orders are shown in the Back orders field in the Inventory allocation details (IN402000) window. |
| Include qty. on receipts | If you select this check box, the system will include (for items of the class) the quantities of items on inventory receipts (with On hold and Balanced statuses) in the available quantities of these items. |
| Include qty. in transit | If you select this check box, the system will include (for items of the class) the quantities of items in transit in the available quantities of these stock items. The documents with the On hold and Balanced statuses are used for availability calculation. |
| Include qty. on purchase order receipts | If you select this check box, the system will include (for items of the class) the quantities of items on unreleased purchase receipts in the available quantities of these items. |
| Include qty. on purchase on hold | If you select this check box, the system will include (for items of the class) the quantities of items on purchase orders (with the statuses of On hold and Pending approval ) in the available quantities of these items. The item quantity in the purchase orders with the On hold and Pending approval statuses is shown in the Purchase prepared field in the Inventory allocation details (IN402000) window. |
| Include qty. on purchase orders | If you select this check box, the system will include (for items of the class) the quantities of items on open purchase orders in the available quantities of these items. The item quantity in the purchase orders with the Open status is shown in the Purchase orders field in the Inventory allocation details (IN402000) window. |
| Include qty. of kit assembly supply | If you select this check box, the system will include (for items of the class) the quantities of items that are kits and listed in the kit assembly documents in the available quantities of these items.
Note
This check box is available only if the Kit assembly functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Include qty. on returns | If you select this check box, the system will include (for items of the class) the quantities of items on return orders and on shipments with the Receipt operation selected (in the Shipments (SO302000) window) in the available quantities of these items. In particular, quantities are affected as follows:
Thus, the quantities on shipments with the Receipt operation decrease the Total deduction quantities in the Inventory allocation details (IN402000) window. |
| Element | Description |
|---|---|
| Base unit | The UoM to be used as the default base unit for items of the class. Select the base unit from the list of UoMs defined in the Units of measure (CS203100) window. |
| Sales unit | The UoM to be used as the default sales unit for items of the class. Select this unit from the list of globally defined UoMs for which conversion factors to the chosen base unit are specified in the Units of measure (CS203100) window, or type the unit. Press Enter, and a new row will be appended to the unit conversion table for the class. In this row, specify a conversion rule between the UoM selected as the sales unit and the UoM selected as the base unit.
Note
This field is only displayed if the Multiple units of measure functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Purchase unit | The UoM to be used as the default purchase unit for items of the class. Select the unit from the list of globally defined UoMs for which conversion factors to the chosen base unit are specified in the Units of measure (CS203100) window, or type the unit. Press Enter, and a new row will be appended to the unit conversion table for the class. In this row, specify a conversion rule between the UoM selected as the purchase unit and the UoM selected as the base unit.
Note
This field is only displayed if the Multiple units of measure functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Undership threshold (%) | The minimal percentage of goods shipped (with respect to the ordered quantity) for the system to mark the order as shipped completely. This setting is not applicable to items with specified serial or lot numbers; these items should be shipped exactly as specified. This setting provides the default value for items of this class. |
| Overship threshold (%) | The maximum percentage of goods shipped (with respect to the ordered quantity) allowed by the customer. This setting is not applicable to items with specified serial or lot numbers; these items should be shipped exactly as specified. This setting provides the default value for items of this class. |
| Column | Description |
|---|---|
| From unit | The UoM to be converted to the base unit. |
| Multiply/divide | The operation to be performed for the unit conversion. You can select the Multiply or Divide option to perform the appropriate conversion from the unit specified in the From unit column to the unit specified in the To unit column. |
| Conversion factor | The factor to be used for conversion with the specified operation. |
| To unit | The target unit for the unit conversion, which is the UoM selected as the base unit. |
| Element | Description |
|---|---|
| Price work group | The default work group responsible for pricing items of the class. |
| Price manager | The default manager responsible for pricing items of the class. |
| Min. mark-up (%) | The default minimum mark-up percentage required for items of the class. |
| Mark-up (%) | The default mark-up percentage for items of the class. The mark-up is the difference between the price of the item and its cost, with respect to the cost. |
| Element | Description |
|---|---|
| Demand calculation | The demand calculation option defines how the system calculates the item quantity for replenishment. You can select one of the following options:
|
| Column | Description |
|---|---|
| Replenishment class ID | The replenishment class that applies to items of this item class. |
| Seasonality | The set of seasonality settings to be used with the replenishment class, by its ID. |
| Source | The source of replenishment used for the item class with this replenishment class. One of the following options can be selected:
|
| Method | The method of replenishment to be used for the class with this replenishment class. You can select one of the following options:
|
| Replenishment warehouse | The warehouse to serve as the source of replenishment if the source of replenishment is Transfer, Purchase to order, Drop shipment. |
| Stock transfer lead time | The number of days required for transferring goods from the source warehouse. |
| Transfer ERQ | The economic reasonable quantity (ERQ) for the item transfer. This value represents the level of inventory that minimises the total transfer costs. |
| Demand forecast model | The model to be used for calculating the revised replenishment parameters for this replenishment class when applied to items of the item class. The following options are available:
|
| Forecast period type | The type of time period to be used for selecting historical data for demand forecast model. The following options are available:
|
| Periods to analyse | The number of specified time periods for selecting historical data for the demand forecast model. |
| Launch date | The date when the current replenishment settings become effective for replenishment of items of the class. |
| Termination date | The date when the current replenishment settings of the replenishment class expire. |
| Service level (%) | The service level assigned to the item class.
Note
The default value is 84.0%, which results in zero level of safety stock. For details on usage of the service level parameter, see: About replenishment parameters based on demand forecast |
| Column | Description |
|---|---|
| Attribute ID | The identifier of the attribute. |
| Description | A read-only column that displays the detailed description of the attribute. |
| Sort order | A number that represents the order of the attribute in the list of class attributes. Type an integer directly in the column. The lower the integer, the higher the attribute will be in the list of class attributes. |
| Required | This check box indicates (if selected) that the attribute value is required for items of the class. |
| Control type | Read-only. This column displays the type of control (element) for the attribute:
|
| Element | Description |
|---|---|
| Item ID | The stock item, which may have specific properties in different warehouses. Select the item from this list. |
| Warehouse | The specific warehouse where the selected stock item is stocked in this case. |
| Status | The status of the stock item at this warehouse. Select one of the available options:
|
| Product work group | The product work group defined for the stock item at this warehouse. |
| Product manager | The product manager assigned to this stock item at this warehouse. |
| Element | Description |
|---|---|
| Default issue from | The default location to issue the stock items from this warehouse. |
| Default receipt to | The default location to receive the stock items at this warehouse. |
| Element | Description |
|---|---|
| Base unit | The UoM used as the base unit for the non-stock item. |
| Sales unit | The UoM used as the sales unit for the non-stock item.
Note
This field is only displayed if the Multiple units of measure functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Purchase unit | The UoM used as the purchase unit for the non-stock item.
Note
This field is only displayed if the Multiple units of measure functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Column | Description |
|---|---|
| From unit | The unit of measure to be converted to the base unit. |
| Multiply / divide | The operation to be performed for the unit conversion. You can select the Multiply or Divide option to perform the appropriate conversion from the specified UoM to the base unit. |
| Conversion factor | The factor to be used for conversion with the specified operation. |
| To unit | The target unit for the unit conversion, which is the UoM chosen as the base unit for the selected item. |
| Element | Description |
|---|---|
| Override inventory account/sub. | A check box you select to specify an inventory account and subaccount other than the default inventory account and subaccount for the warehouse. |
| Inventory account | The asset account to be used to post inventory transactions related to this stock item at this warehouse. |
| Inventory sub. | The subaccount to be used to post inventory transactions related to this stock item at this warehouse. |
| Element | Description |
|---|---|
| ABC code override | This check box indicates (if selected) that the ABC code assigned for the selected stock item can be overridden for this warehouse. |
| ABC code | The ABC code of the selected item at the selected warehouse. |
| Fixed ABC code | This check box indicates (if selected) that the ABC code is fixed for the selected stock item at the warehouse. |
| Movement class override | This check box indicates (if selected) that the movement class assigned for the selected stock item can be overridden for this warehouse. |
| Movement class | The movement class for the selected stock item at the specific warehouse. |
| Fixed movement class | This check box indicates (if selected) that the movement class is fixed for the chosen stock item at the specific warehouse. |
| Element | Description |
|---|---|
| Replenishment class | The replenishment class to be used for this item at this warehouse. |
| Override replenishment settings | A check box you select if you want to override the replenishment settings for this item at this warehouse defined by the selected replenishment class. |
| Seasonality | The set of seasonality settings (by its ID) to be used with the replenishment class, which the system uses to adjust the replenishment quantities to low and high seasons. To define the seasonality settings, use the Replenishment seasonality (IN206600) window. |
| Replenishment source | The replenishment source to be used for this stock item in this warehouse. By default, it is the replenishment source associated with the item. You can select one of the following options:
|
| Replenishment method | The replenishment method to be used for this stock item for the selected replenishment source in this warehouse. By default, it is the replenishment method associated with the item. The method can be one of the following options:
|
| Replenishment warehouse | The warehouse to be used as the source of replenishment. |
| Max. shelf life (days) | The maximum number of days that the stock item can be stored. |
| Override | If you select this check box, the system overrides the maximum shelf life for this stock item at this warehouse. |
| Launch date | The date starting the date range when the replenishment settings apply to the stock item as initially defined on Item classes window. |
| Override | If you select this check box, the system overrides the launch date for this stock item in this warehouse. |
| Termination date | The date ending the date range during which the replenishment settings apply to the stock item. |
| Override | If you select this check box, the system overrides the termination date for this stock item at this warehouse. |
| Service level (%) | The service level assigned to the item, affects the safety stock. For details, see: About replenishment parameters based on demand forecast. |
| Override | If you select this check box, the system overrides the service level assigned to this stock item at this warehouse. |
| Element | Description |
|---|---|
| Safety stock | The quantity of the stock item that is maintained in the warehouse to prevent possible stockouts during the time period between initiation of replenishment and receiving of the requested supply. |
| Override | If you select this check box, the system overrides the safety stock for this stock item in this warehouse. |
| Reorder point | The stock level that, upon its reach, should prompt the system to replenish the stock of the item at this warehouse. Minimum quantities should be set equal to anticipated demand during the lead time plus a safety stock. |
| Override | If you select this check box, the system overrides the reorder point for this stock item in this warehouse. |
| Max. qty. | The maximum stock level for the replenishment. When the quantity of the item falls below the Reorder point value, the order should be issued to replenish the stock up to the Max. quantity value. |
| Override | If you select this check box, the system overrides the maximum quantity for this stock item in this warehouse. |
| Economic transfer quantity | The economic reasonable quantity (ERQ) for the item transfer. This value represents the level of inventory that minimises the total transfer costs. |
| Override | If you select this check box, the system overrides the transfer ERQ for this stock item in this warehouse. |
| Element | Description |
|---|---|
| Daily demand forecast | The forecasted average daily demand for this item at this warehouse. |
| Daily demand forecast error (STDEV) | The standard deviation calculated for average daily demand for this item in this warehouse. |
| Lead time average | The average lead time calculated based on historical data. |
| Lead time STDEV | The standard deviation calculated for average lead time. |
| Safety stock suggested | The safety stock of the item at this warehouse calculated based on the forecast and the specified service level. |
| Reorder point suggested | The quantity to be used as the reorder point for stock item that is based on the forecast. |
| Last forecast date | The date when the forecast was done last. |
| Element | Description |
|---|---|
| Override preferred supplier | If you select this check box, the system overrides the preferred supplier for this item at this warehouse. |
| Preferred supplier | The supplier from which the item will be purchased for stock replenishment in this warehouse. By default, the preferred supplier specified in the Stock items (IN202500) window appears here. |
| Preferred location | The supplier location from which the item will be purchased for stock replenishment in this warehouse.
Note
This field is only displayed if the Account locations functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Supplier lead time (days) | Read only. This field shows the lead time for the selected supplier location. This lead time is defined in the Shipping instructions section on the General information tab of the Supplier locations (AP303010) window. |
| Shipment lead time (days) | The additional lead time for the selected item, which represents the additional time required by the supplier to produce, assemble, and dispatch the item. This value is added to the supplier Lead time value, defined in the Supplier locations (AP303010) window, to calculate the resulting lead time required to deliver the purchased item from the supplier’s location to your company’s warehouse. |
| Min. order freq. (days) | The minimum purchase frequency for the item required when purchasing from this supplier. |
| Min. order qty. | The minimum order quantity required for the item when purchasing from this supplier. |
| Max. order qty. | The maximum order quantity of the item required when purchasing from this supplier. |
| Lot size | The lot size for the item when purchased from this supplier. |
| EOQ | The economic order quantity (EOQ) when the item is purchased from this supplier. This value represents the level of inventory that minimises the total inventory holding costs and ordering costs. |
| Element | Description |
|---|---|
| Override standard cost | This check box indicates (if selected) that the standard cost can be overridden. Select this option to manually set the standard cost for the stock item at the warehouse. |
| Last cost | The last cost used for the stock item. |
| Current cost | Read only. This field displays the current cost of the stock item. |
| Effective date | Read only. This field displays the effective date for the current cost value of the stock item. |
| Pending cost | The pending cost value for the stock item, which becomes effective on the Pending cost date. This value can be set only if the Standard cost override check box is selected. |
| Pending cost date | The date when the pending cost value of the stock item will become effective. This value can be set only if the Standard cost override check box is selected. |
| Element | Description |
|---|---|
| Work group | The work group responsible for the product pricing of the item at this warehouse. Select the group from the list of the groups that were defined in the Company tree (EP204060) window. |
| Price manager | The manager responsible for the product pricing of the item at this warehouse. Select a company employee from the list of employees defined in the Employees (EP203000) window. If you have selected a specific work group as the Price work group, the list of employees contains only the members of the selected work group. |
| Subject to commission | This check box indicates (if selected) that commissions should be paid on sale of this stock item at this warehouse. |
| Override mark-up (%) | A check box that indicates (if selected) that the mark-up value can be overridden for this item in this warehouse. Select this option to set the mark-up value for the stock item in this warehouse in the Mark-up (%) field. |
| Mark-up (%) | The mark-up percentage to be used for this item stored in this warehouse. The mark-up is a percentage of cost added to the cost to get the selling price. |
| Override price | This check box indicates (if selected) that the manufacturer’s suggested price for the item can be overridden for this warehouse. |
| List price | The manufacturer’s suggested price of the stock item. This is the retail price suggested for stock item by its manufacturer. |
| Element | Description |
|---|---|
| Last cost | Read only. This field shows the last cost defined for the stock item. |
| Average cost | Read only. This field shows the average cost value defined for the stock item. |
| Min. cost | Read only. This field shows the minimum cost value defined for the stock item. |
| Max. cost | Read only. This field shows the maximum cost value defined for the stock item. |
| Column | Description |
|---|---|
| Price class ID | The alphanumeric ID of the price class. You can use 10 characters, both numbers and letters. |
| Description | A brief description of the price class. > [!NOTE] > This field supports the multi-language functionality, where you can translate the entered text to multiple languages. For more information, see: About multi-language support |
| Button | Description |
|---|---|
| Move node up | Moves the selected node one level up in the tree within the parent node. |
| Move node down | Moves the selected node one level down in the tree within the parent node. |
| Add category | Adds a subcategory to the category selected in the Categories pane.
Note
To add a new category on the first level, select your company name in the Categories pane. |
| Delete category | Deletes the category selected in the Categories pane and all subcategories of the selected category. |
| Column | Description |
|---|---|
| Description | The name of the selected category. > [!NOTE] > This field supports the multi-language functionality, where you can translate the entered text to multiple languages. For more information, see: About multi-language support |
| Parent category | The parent category of the selected category. |
| Button | Description |
|---|---|
| Add items | Opens the Add items dialog box, which you can use to add all items of an item class or all items to the selected category. Select an item class in the Item class field, and then click Add to add all items of the class to the table. Or click Cancel to close the dialog box without any changes. |
| Column | Description |
|---|---|
| Item ID | The identifier of the stock item. |
| Description | The description of the stock item. |
| Item class | The item class of the stock item. |
| Item status | The status of the stock item. |
| Element | Description |
|---|---|
| Add items | The drop-down list you use to select which items you want to add to the item sales category. The following options are available:
|
| Item class | The item class whose items you want to add to the item sales category. This field is available only when you select the By class option in the Add items drop-down list. |
| Add (button) | Adds the selected items to the item sales category and closes the dialog box. |
| Cancel (button) | Closes the dialog box without adding any items to the item sales category. |
| Button | Description |
|---|---|
| Release | Releases the kit assembly document, updates the availability data for items that are kits or kit components, and generates a batch of transactions to update the general ledger. |
| Review batch | Navigates to the Journal transactions (GL301000) window, to let you view the details of the batch. |
| Reports | Provides direct access to the following reports related to kit assembly:
|
| Element | Description |
|---|---|
| Type | The type of operation to be performed for this kit. You can select one of the following options:
|
| Ref. no. | The unique reference number of the kit assembly document, which the system automatically assigns according to the numbering sequence specified for kit assembly documents in the Inventory preferences (IN101000) window. |
| Status | The current status of the kit assembly document. The following options are available:
|
| Hold | This check box indicates (if selected) that the kit assembly document has the status On hold. Clear the check box to change the status to Balanced. |
| Date | The date when the kit assembly document was created. All transactions based on this document will have this transaction date. |
| Post period | The financial period to which the transactions from the document should be posted. |
| Item ID | The identifier of the kit as an stock item. When you are selecting an existing kit for viewing or modification, you can select from only the items marked as kits on the General settings tab of the Stock items (IN202500) or Non-stock items (IN202000) window. |
| Revision | The revision of the kit specification used for the kit assembling or disassembling. |
| Reason code | The reason code used for the kit disassembling operation. (This field is not available for the operations of the Production type.) |
| Description | A brief description of the kit assembly document. |
| Created from | If a kit assembly document has been created from a sales order line, this field displays a link to the sales document and the sales order line. |
| Warehouse | The warehouse where the assembly or disassembly is performed.
Note
This column is only displayed if the Multiple warehouses functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Location | The location where the assembly or disassembly is performed.
Note
This column is only displayed if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| UoM | The unit of measure used for the kit. |
| Quantity | The quantity of the kits assembled or disassembled. |
| Element | Description |
|---|---|
| Allocations | Opens the Allocations dialog box, so you can specify how the quantity of this specific component is split between sub items, locations, lot/serial numbers, and expiration dates for the component. This button is available if at least one of the following functionalities is enabled in the Enable/disable functionalities (CS100000) window: Multiple warehouse locations, Inventory sub items, or Lot serial tracking. |
| Column | Description |
|---|---|
| Item ID | The item ID of this kit component. |
| Description | A description of the kit component. |
| Location | The warehouse location where the component is stored.
Note
This field is only displayed if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| UoM | The unit of measure of this stock item added as a component of the kit. |
| Quantity | The actual quantity of this stock item added as a kit component. For the Production type of operation, you can change the quantities of the component only if quantity variance is allowed for it in the Kit specifications (IN209500) window, which is determined by the Allow component qty. variance check box. For the Disassembly type of operation, the quantity of the component is not validated. |
| Unit cost | The cost of the base unit of this stock item serving as a component of the kit. |
| Reason code | (Only available only for operations of the Disassembly type.) The reason code used to record costs for the kit disassembling operation. |
| Component qty. | A read-only column that shows the quantity of this stock item added as a kit component, as defined in the Kit specifications (IN209500) window. |
| UoM | A read-only column displaying the unit of measure (UoM) used for the stock item added as a kit component, as defined by the kit specification. |
| Disassembly coeff. | The coefficient indicating, for kit disassembly, to what extent the component can be returned to the inventory. This coefficient is a decimal value between 0 and 1. If the kit can be totally disassembled back to its components, the coefficient for every component is 1. If this component is included in a part of the kit that can not be disassembled completely, the value is less than 1. |
| Allow component qty. variance | (Only available for the Production type of operations.) This check box (if selected) indicates that the component quantity may be increased or decreased. You can change the quantity to 0 on kit assembly lines created from the Sales orders (SO301000) window when this option is set to true. This read-only column was set in the Kit specifications (IN209500) window. |
| Min. component qty. | (Only available for the Production type of operations.) Read only. This column displays the minimum quantity of the component that can be added to the kit, as defined by the kit specification. |
| Max. component qty. | (Only available for the Production type of operations.) Read only. This column displays the maximum quantity of the component that can be added to the kit, as defined by the kit specification. |
| Allow component substitution | This check box (if selected) indicates that the components can be substituted by another stock item. This read-only column was set in the Kit specifications (IN209500) window. |
| Element | Description |
|---|---|
| Unassigned qty. | The quantity of the stock item that has no location specified or lot or serial numbers assigned. |
| Quantity to generate | The quantity of the stock item for which lot or serial numbers should be generated. |
| Lot/serial number from | The lot or serial number to be used as a start number.
Note
This field is only displayed if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Generate (button) | A button that you click to initiate the generation of lot or serial numbers.
Note
This button is only displayed if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Column | Description |
|---|---|
| Location | The location in the warehouse.
Note
This column is only displayed if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Lot/serial no. | The serial number of the unit of stock item or the lot number of the quantity of stock item received.
Note
This column is only displayed if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Quantity | The quantity of the stock item with the same subitem code and the same lot number. It is 1 for items with serial numbers. |
| UoM | The unit of measure (UoM) for the specified quantity of the stock item. |
| Expiration date | The expiration date of the specified quantity of the stock item.
Note
This column is only displayed if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Button | Description |
|---|---|
| OK | Saves the records generated. |
| Column | Description |
|---|---|
| Item ID | The stock item of this kit component. |
| Description | A description of the kit component. |
| UoM | The unit of measure of this non-stock item added as a component of the kit. |
| Quantity | The actual quantity of the non-stock item as a kit component. For operations of the Production type, you can change the quantities of the component only if quantity variance is allowed for it in the Kit specifications (IN209500) window. For operations of the Disassembly type, the quantity of the component is not validated. |
| Unit cost | The cost of this non-stock item serving as a component of the kit. |
| Reason code | (Only available for operations of the Disassembly type.) The reason code used to record costs for the kit disassembling operation. |
| Component qty. | A read-only column that shows the quantity of this non-stock item added as a kit component, as defined by the kit specification in the Kit specifications (IN209500) window. |
| UoM | A read-only column showing the unit of measure used for the non-stock item added as a kit component, as defined in the Kit specifications (IN209500) window. |
| Allow component qty. variance | (Only available for the Production type of operations.) A check box that indicates whether the component quantity actually used in kit may differ from the quantity specified in the specification revision. This read-only value was specified in the Kit specifications (IN209500) window. |
| Min. component qty. | (Only available for the Production type of operations.) A read-only column displaying the minimum quantity of the component that can be added to the inventory kit, as defined in the Kit specifications (IN209500) window. |
| Max. component qty. | (Only available for the Production type of operation.) A read-only column that shows the maximum quantity of the component that can be added to the inventory kit, as defined in the Kit specifications (IN209500) window. |
| Element | Description |
|---|---|
| Unassigned qty. | The quantity of the stock item (kit) that has no lot or serial numbers assigned. |
| Quantity to generate | The quantity of the stock item for which lot or serial numbers should be generated. |
| Lot/serial number from | The lot or serial number to be used as a start number for these kits.
Note
This field is only displayed if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Generate | A button that, if clicked, initiates generation of lot or serial numbers.
Note
This button is only displayed if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Column | Description |
|---|---|
| Location | The location where the specific quantity of kits is stored.
Note
This column is only displayed if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Lot/serial no. | The lot or serial number assigned to the specific quantity.
Note
This column is only displayed if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| UoM | The unit of measure used for the kits as the base unit. |
| Quantity | The quantity of the kits with specific property: subitem, lot or serial number, or location. |
| Expiration date | The expiration date for the specific quantity of kits.
Note
This column is only displayed if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Element | Description |
|---|---|
| Batch no. | The reference number of the batch generated for the kit assembly document. Click the number to open the Journal transactions (GL301000) window, and you can view the transactions’ details. |
| Branch | The branch for which the kits have been assembled. |
| Element | Description |
|---|---|
| Kit item ID | The item ID of the kit, as assigned to the kit in the Stock items (IN202500) or Non-stock items (IN202000) window. |
| Non-stock | Read only. This check box indicates (if selected) that this is a non-stock kit. |
| Revision | The unique identifier of the kit specification revision. |
| Description | A brief description of the kit specification. > [!NOTE] > This field supports the multi-language functionality, where you can translate the entered text to multiple languages. For more information, see: About multi-language support |
| Active | If you select this check box, this kit specification is active. |
| Allow component addition | If you select this check box, it is permitted to add unlisted components to this kit on its assembly or shipping. |
| Total cost | The total cost of all components combined. |
| Column | Description |
|---|---|
| Component ID | The ID of the kit component.
Note
For non-stock kits, only stock components may be added. |
| Description | A description of the kit component. |
| UoM | The unit of measure (UoM) used for the item added as the component to the kit. |
| Component qty. | The quantity of the item added as a component to the kit. |
| Allow component qty. variance | A check box that indicates (if selected) that the component quantity of items may be increased or decreased. |
| Min. component qty. | The minimum quantity of the component that can be added to the kit. |
| Max. component qty. | The maximum quantity of the component that can be added to the kit. |
| Disassembly coeff. | The coefficient indicating, for kit disassembly, to what extent the component can be returned to the inventory. This coefficient is a decimal value between 0 and 1. If the kit can be totally disassembled back to its components, the coefficient for every component is 1. If this component is included in a part of the kit that can not be disassembled completely, the value is less than 1. |
| Allow component substitution | A check box that indicates (if selected) that a substitution can be made for this component in the kit. |
| Unit cost | The cost of a single piece. |
| Cost | The sum of unit cost multiplied by quantity. |
| Element | Description |
|---|---|
| Component ID | The ID of a non-stock item added as the kit component. |
| Description | A description of the kit component. |
| UoM | The unit of measure used for the item added as the component to the kit |
| Component qty. | The quantity of the item added as the component to the kit. |
| Allow component qty. variance | This check box indicates (if selected) that the component quantity may be increased or decreased. |
| Min. component qty. | The minimum quantity of the component that can be added to the kit. |
| Max. component qty. | The maximum quantity of the component that can be added to the kit. |
| Unit cost | The cost of a single piece. |
| Cost | The sum of unit cost multiplied by quantity. |
| Element | Description |
|---|---|
| Class ID | The unique ID of the lot/serial class. You can use up to 10 characters, both numbers and letters. |
| Description | A brief description of the lot/serial class. |
| Tracking method | The tracking method for the inventory lot/serial class. Select one of the following options:
|
| Track expiration date | This check box indicates (if selected) that the system will track the expiration date for stock items of this lot/serial class. This option is not used for classes with Not tracked selected as their tracking method. |
| Required for drop-ship | This check box indicates (if selected) that the stock items of this lot/serial class are required for drop-ship. |
| Assignment method | The method of assigning lot or serial numbers to the items. Select one of the following options:
|
| Issue method | The method used to issue the items of this lot/serial class, which is not applicable for items of the class for which the Not tracked tracking method is selected. You can select one of the following issue methods:
|
| Share the auto-increment value between all class items | This check box lets you use (if selected) the same auto-increment value for all stock items in the lot/serial class. If it is cleared, for each item, an individual auto-increment value may be set in the Stock items (IN202500) window; if such a number is not set, the initial value for each item will be 0000 by default. |
| Automatic incremental value | For a newly created class, the initial value to be used for generating new values (incremented by 1) in the lot/serial number segment that has the Automatic incremental value option selected in the Type column on this window. The value will change as follows:
|
| Automatically generate next number | This check box indicates (if selected) that the system will automatically generate the next number for items of the class with an auto-increment segment. If the check box is not selected, users should manually enter serial numbers. |
| Max. auto-generate number | The maximum number of serial numbers that can be generated at once for items of this lot/serial class. If a larger quantity of the item is specified on a document, you will get an error message telling you that you have more than enough quantity, and because of that there will be unassigned numbers. You need to enter a new line for the exceeding quantity. You can initiate assignment of serial numbers for unassigned quantity of the item manually. |
| Column | Description |
|---|---|
| Segment number | The segment number of a lot or serial number, which is assigned automatically by the system. |
| Type | The type of segment value to be used for this segment. You can use one of the following options:
|
| Value | The specific value to be used in the lot/serial number segment. Enter the value in this column taking into account the type of the value:
Values are not required for other types of segments. |
| Column | Description |
|---|---|
| Movement class ID | A one-letter ID of the movement class. |
| Description | A brief description of this movement class. |
| Counts per year | The number of stocktaking counts per year to be performed for items assigned to this movement class. |
| Max. turnover % | A threshold value (%) of the criteria to be used for assigning the stock items (in the specific warehouse in a specific turnover period) to this movement class. For details of the assignment method, see: About inventory ranking methods |
| Button | Description |
|---|---|
| Actions | Provides the following actions:
|
| Inquiries | Provides quick access to inquiry forms as follows:
|
| Element | Description |
|---|---|
| Item ID | The unique alphanumeric identifier of the non-stock item. The structure of identifiers is defined by the INVENTORY segmented key in the Segment keys (CS202000) window.
Note
At a later time, you can change the non-stock item ID by selecting Change ID on the Actions menu in the toolbar. |
| Item status | The status of the non-stock item. You can select one of the following options:
|
| Description | A brief description of the non-stock item. |
| Work group | The work group that is responsible for the non-stock item. |
| Product manager | The product manager who is responsible for the non-stock item. |
| Element | Description |
|---|---|
| Item class | The item class the item is associated with; only item classes for non-stock items appear on the list for selection. Item classes, which are used to group stock items and provide default settings for new items of the class, are defined in the Item classes (IN201000) window. |
| Type | The non-stock item type. You can select one of the following options:
|
| Posting class | The posting class the item is associated with. You can use posting classes to group non-stock items with similar properties and provide default settings used to post inventory transactions related to the items to the general ledger. The posting classes are defined in the Posting classes (IN206000) window. |
| Is a kit | Select this check box if the non-stock item is a kit. The components of the kit can be specified by using the Kit specifications (IN209500) window. |
| Webhook notification | When this check box is selected and saved for an item, you will be notified regarding changes. The Webhook notifications tab appears when you select the item. |
| VAT category | The VAT category of the non-stock item. By default, this is the VAT category specified for the item class to which this item has been assigned. If needed, another VAT category can be selected for the item. |
| Default warehouse | The warehouse whose settings can be used for this non-stock item on sales orders or purchase orders.
Note
This column is only displayed if the Multiple warehouses functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Require receipt | A check box that you select to require that the system create a purchase receipt for this non-stock item. If you select this check box, the system will not generate any inventory transactions for the non-stock item. |
| Require shipment | A check box you select to require that the system create a sales order receipt for this non-stock item. If you select this check box, you cannot have the system generate any inventory transactions for this non-stock item. |
| Complete purchase order line | Choose between:
|
| Reverse charge item | Select this check box if the non-stock item is a reverse charge item.
Note
This check box is only displayed if the Type is Expense and the Expense Integration functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| External ID | This field is automatically populated if the non-stock item is linked to an external expense type in the Expense receipt inbox (EP50605S) window.
Note
This field is only displayed if the Type is Expense and the Expense Integration functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Column | Description |
|---|---|
| From unit | The unit of measure for which the conversion parameters are specified. |
| Multiply/divide | The operation to be performed for unit conversion. You can select the Multiply or Divide option to perform conversions from different units of measure to the UoM specified as the base unit. |
| Conversion factor | The factor to be used for the unit conversion, along with the conversion operation specified in the Multiply/divide column. |
| To unit | The UoM selected as the base unit for the item. |
| Element | Description |
|---|---|
| Base unit | The UoM used as the base unit for the non-stock item. |
| Sales unit | The UoM used as the sales unit for the non-stock item. The default value (if any) is specified in the Item classes (IN201000) window. This field appears only if the Multiple units of measure functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Purchase unit | The UoM used as the purchase unit for the non-stock item. The default value (if any) is specified in the Item classes (IN201000) window. This field appears only if the Multiple units of measure functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Element | Description |
|---|---|
| Price class | The item price class associated with the non-stock item. These classes, which are used to group stock or non-stock items with similar price calculation methods, are defined in the Item price classes (IN209000) window. |
| Price work group | The work group responsible for product pricing. Select the pricing work group for the non-stock item. |
| Price manager | The manager responsible for the product pricing. |
| Subject to commission | A check box that indicates (if selected) that commission should be calculated on the sale of this non-stock item. The check box is available if the Commissions functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Min. mark-up (%) | The minimum mark-up percentage defined for this non-stock item. |
| Mark-up (%) | The mark-up percentage to be used for setting the price for the item. |
| List price | The manufacturer’s suggested retail price (MSRP) of this non-stock item. |
| Default price | The price of the non-stock item. This price is used as the default price if there are no other prices (from any price list) defined for this item in the Supplier ledger workspace. |
| Element | Description |
|---|---|
| Pending cost | The standard cost to be assigned to the non-stock item when the costs are updated. You can type the cost directly into the field. |
| Pending cost date | The date when the pending cost becomes effective. You can select the date for a pending cost. |
| Current cost | The current standard cost of the non-stock item. |
| Effective date | The date when the current standard cost became effective. |
| Last cost | The standard cost assigned to the non-stock item before the current standard cost was set. |
| Element | Description |
|---|---|
| ROT or RUT deductible item | Select this check box if the item should be used for ROT or RUT deduction. |
| ROT | Select this option if the work is related to ROT deduction (repairs, conversion, extension). |
| RUT | Select this option if the work is related to RUT deduction (cleaning, maintenance, laundry). |
| Type | Select one of the following types:
|
| Type of work | The following work types are available for RUT:
The following work types are available for ROT:
|
| Column | Description |
|---|---|
| Active | This check box indicates (if selected) that the supplier is active. |
| Default | This check box indicates (if selected) that the supplier is the default supplier for this item. Select this check box to mark the supplier that is the main supplier of the item. When you create a purchase order to purchase an item, the default supplier is selected for this purchase. |
| Supplier no. | The ID of the supplier. Supplier settings are specified in the Suppliers (AP303000) window. |
| Supplier name | The name of the supplier from which the item is purchased. |
| Location | The supplier location from which the item is purchased, which by default is the supplier’s default location. These locations are defined for the supplier in the Supplier locations (AP303010) window.
Note
This column is only displayed if the Account locations functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Purchase unit | The unit of measure in which the item is purchased. This UoM is specified on the General settings tab of this window. |
| Supplier item ID | The item ID used by the supplier for this item. |
| Currency ID | The currency used by the supplier to charge for the item. |
| Last supplier price | Read only. This column shows the last supplier price defined for the item. |
| Column | Description |
|---|---|
| Alt. item ID type | The type of alternate codification used for the item, You can select one of the following options:
|
| Supplier/customer | The supplier or customer (by its ID) that uses the alternative identification for this non-stock item. |
| Alt. item ID | The alternative ID of the non-stock item as used by the supplier or customer. |
| Description | Any comments applicable to the specified cross-reference. |
| Element | Description |
|---|---|
| Weight | The weight of the item. |
| Weight UoM | The unit of measure used for the weight of the item. |
| Volume | The volume of the item. |
| Volume UoM | The unit of measure used for the item volume. |
| Element | Description |
|---|---|
| Deferral code | The deferral code assigned to this non-stock item. The code specifies how the revenue from the sale of this item will be recognised. The deferral codes are defined in the Deferral codes (DR202000) window. |
| Default term | The date range defined for deferred revenue recognition (for example, 2 years for a two-year customer support subscription that you sell). The field is available for editing only if the Flexible by period, prorate by days or Flexible by days in period recognition method is selected for the deferral code selected in the Deferral code field. The maximum value is 10000. Possible time units are year(s), month(s), week(s), and day(s). |
| Use component subaccounts | This check box indicates (if selected) that the component subaccount is used to account for deferred revenue. |
| Total percentage | The total percentage of the item price as split among components. This value is calculated automatically as the sum of the percentages assigned to the components if the item is sold as a package and consists of components. When the item is not a package, the total percentage is set to 100. |
| Column | Description |
|---|---|
| Item ID | The item ID of the component of this non-stock item, which is sold as a package. |
| Sales account | The sales account used for this component. |
| Sales sub. | The sales subaccount used for this component. |
| UoM | The unit of measure used for this component. |
| Quantity | The quantity of the specified units for this component of the non-stock item. |
| Deferral code | The deferral code that has been specified for this component. |
| Default term | The date range defined for the process of the deferred revenue or expense recognition (for example, 6 months for a six-month support license). This field is available for editing only if the Flexible by periods, prorate by days, or Flexible by days in period method is specified for the deferral code that you have selected in the Deferral code column for this component. |
| Default term UOM | The unit of measure for the default term: year(s), month(s), week(s), or day(s). This field is available for editing only if the Flexible by periods, prorate by days or Flexible by days in period method is specified for the deferral code that you have selected in the Deferral code column for this component. |
| Allocation method | The method used to allocate the document amount between the components. The following options are available:
|
| Fixed amount | The fixed amount of the item price assigned to the component if the Fixed amount option is selected in the Allocation method column. |
| Percentage | The percentage of the item price for this component if the Percentage option is selected in the Allocation method column. |
| Element | Description |
|---|---|
| Expense accrual account | For a non-stock item, that is a component of a stock kit, this account (of the Expense or Liability type) will be used to accrue the costs (standard costs) of non-stock components in the process of kit assembly, if the option Item is selected in the Use inventory/accrual account from field in the General ledger accounts tab in the Posting classes (IN206000) window. For a Labour type item, the expense accrual account is used to accrue the cost of labour on projects (the account is credited on release of time cards). The account will be used for time card related transactions if Labour item accrual is selected as the Expense accrual account source setting in the Project accounting preferences (PM101000) window. |
| Expense accrual sub. | The subaccount to be used as the default expense accrual subaccount for this non-stock item. For kit assembly related transactions, this subaccount is one of the sources for selecting segment values for the expense accrual subaccount according to the rule defined by the posting class (the Combine inventory / accrual sub. from field in the Posting classes (IN206000) window). For transactions with labour items, this subaccount is one of the sources for selecting segment values for the expense accrual subaccount according to the rule defined by the Expense accrual sub. source setting in the Project accounting preferences (PM101000) window. |
| Reason code sub | The subaccount of the reason code for the item. |
| Expense account | The default expense account to be used for this non-stock item. If the Inventory module is enabled in your system, this account will be used for transactions with this item as the default expense account if Item is selected in the Use COGS / expense account from field for the posting class of the item. |
| Expense acct, non-taxable | The non-taxable expense account to be used for this non-stock item. |
| Expense EU account | The EU expense account to be used for this non-stock item. |
| Expense account, import | The import expense account to be used for this non-stock item. |
| Expense payroll taxable account | The expense payroll taxable account to be used for this non-stock item. This field is visible only if Expense Integration is enabled and the non-stock item is of type Expense. |
| Expense sub. | The subaccount to be used by default with the expense account for transactions related to this non-stock item. If the Inventory module is enabled in your system, this subaccount is used as one of the sources for selecting segment values for the default expense subaccount defined by the posting class (the Combine COGS / expense sub. from field in the Posting classes (IN206000) window). |
| Purchase accrual account | The liability account to be used for this non-stock item to accrue purchase order item amounts for this item, if the option Item is selected in the Use purchase accrual account from field in the posting class (the Posting classes (IN206000) window) for this item.
Note
This element is available only for non-stock items that require a receipt. |
| Purchase accrual sub. | Depending on the rule in the Combine purchase accrual sub. from field in the posting class for this item (the Posting classes (IN206000) window), this subaccount can be used as the source for one or more of the segment values of the purchase accrual subaccount to be used with the purchase accrual account.
Note
This element is available only for non-stock items that require a receipt. |
| Sales account | The account to be used as the sales account when this non-stock item is sold. |
| Sales - non-taxable account | The account to be used as the non-taxable sales account when this non-stock item is sold. |
| Sales - EU account | The account to be used as the EU sales account when this non-stock item is sold. |
| Sales - export account | The account to be used as the export sales account when this non-stock item is sold. |
| Sales sub. | The subaccount to be used by default for transactions recording a sale of this non-stock item. If the Inventory module is enabled in your system, this subaccount is used as one of the sources for selecting segment values for the default sales subaccount defined by the posting class (the Combine sales sub. from field in the Posting classes (IN206000) window). |
| Purchase price variance account | The account (of the Expense type) to be used as the default purchase price variance account to record purchases of this non-stock item on receipts if Item is selected in the Use purchase accrual account from field for the posting class of the item. The purchase price account is used to record any differences between the extended price on the purchase receipt and the extended price on the purchase invoice (if this item is assigned any of the valuation methods except for the standard cost valuation method). |
| Purchase price variance sub. | The corresponding subaccount. This subaccount is used as one of the sources for selecting segment values for the default purchase price variance subaccount defined by the posting class (the Combine purchase price variance sub. from field in the Posting classes (IN206000) window). |
| Deferral account | The account to be used to hold the deferred amount until it is fully recognised. The account type should be specified as follows:
|
| Deferral sub. | The subaccount to be used with the deferral account. |
| Column | Description |
|---|---|
| Attribute ID | The name of the attribute. |
| Required | This check box indicates (if selected) that the attribute value is required for a non-stock item of the class. |
| Value | The value of the attribute. |
| Column | Description |
|---|---|
| Category | The sales category identifier. |
| Element | Description |
|---|---|
| Browse | Click the button to locate the image you want to upload. |
| Upload | Click the button to upload selected image. |
| Element | Description |
|---|---|
| Class ID | The unique alphanumeric identifier of the posting class. You can use up to 10 characters, both numbers and letters. |
| Description | A brief description of the posting class. |
| Element | Description |
|---|---|
| Use inventory/accrual account from | The source of the inventory account (of the Asset type) for stock items or expense accrual account for non-stock items or labour items (of the Asset or Liability type) to be used for transactions that involve items assigned to this posting class. You can select one of the following options:
|
| Combine inventory/accrual sub. from | A rule that defines from where each inventory subaccount segment value, or expense accrual subaccount segment value, is collected. The resulting subaccount is used with the inventory account, or expense accrual account, for transactions that involve items of this posting class. The possible sources of the segment values are Item, Posting class, and Warehouse. |
| Use sales account from |
Note
for the Sales orders (SO301000) window, the sales account is retrieved according to the Use sales account from setting in the Order types (SO201000) window. See also: About suggested sales accounts. The source of the sales account to be used for inventory transactions involving items of the posting class. You can select one of the following options:
|
| Combine sales sub. from | A subaccount mask used to define how the subaccount used with the sales account is composed for inventory transactions that involve items of the posting class. |
| Use COGS/expense account from | The source of the COGS (for stock items) or expense (for non-stock items) account to be used for inventory transactions that involve items of the posting class. You can select one of the following options:
|
| Copy COGS sub. from sales | This check box indicates that the system will copy the COGS or expense subaccount from the sales subaccount. When this option is selected, you cannot define the rule to combine COGS subaccount from the related subaccounts. |
| Combine COGS/expense sub. from | A subaccount mask used to define how the subaccount used with the COGS (for stock items) or expense (for non-stock items) account is composed for transactions that involve items of the posting class.
Note
Combine COGS/expense sub. from is only enabled if the Copy COGS sub. from sales check box is not selected. The sources of the segment values are Warehouse, Posting class, and Item. |
| Use standard cost variance account from | The source of the standard cost variance account to be used for the inventory transactions with items of the posting class. You can select one of the following options:
|
| Combine standard cost variance sub. from | A rule that defines from where each standard cost variance subaccount segment value is collected. The resulting subaccount is used with the standard cost variance account for the inventory transactions that involve items of this posting class. The possible sources of the segment values are Item, Posting class, and Warehouse. |
| Use standard cost revaluation account from | The source of the standard cost revaluation account to be used for inventory transactions involving items of the posting class. You can select one of the following options:
|
| Combine standard cost revaluation sub. from | A rule that defines from where each standard cost revaluation subaccount segment value is collected. The resulting subaccount is used with the standard cost revaluation account for the inventory transactions that involve items of this posting class. The possible sources of the segment values are Item, Posting class, and Warehouse. |
| Use purchase accrual account from | The source of the purchase accrual account to be used for the purchase receipts and inventory transactions with items of the posting class. You can select one of the following options:
|
| Combine purchase accrual sub. from | A rule that defines from where each purchase accrual subaccount segment value is collected. The resulting subaccount is used with the purchase accrual account for purchase receipts and inventory transactions that involve stock items and non-stock items (that require a purchase receipt) of this posting class. The possible sources of the segment values are Item, Posting class, Supplier, and Warehouse. |
| Use purchase price variance account from | The source of purchase price variance account to be used for inventory transactions that involve items of the posting class. You can select one of the following options:
|
| Combine purchase price variance sub. from | A subaccount mask used to define how the subaccount used with the purchase price variance account is composed for the inventory transactions that involve items of the posting class. |
| Use landed cost variance account from | The source of landed cost variance account to be used for inventory transactions involving items of the posting class. You can select one of the following options:
|
| Combine landed cost variance sub. from | A subaccount mask used to define how the subaccount used with the landed cost variance account is composed for the inventory transactions that involve items of the posting class. |
| Stocktaking reason code | For stock items only. The reason code to be used by default for stocktaking involving items associated with this posting class. |
| Element | Description |
|---|---|
| Inventory/accrual account | The asset account to be used as the inventory account for stock items of this posting class, or the asset or liability account to be used as the expense accrual account for non-stock items or labour items of this posting class, if the option Posting class is selected in the Use inventory/accrual account from field in the Posting settings tab in this window. |
| Inventory/accrual sub. | Depending on the rule in the Combine inventory/accrual sub. from field in the Posting settings tab in this window for this posting class, this subaccount can be used as the source for one or more of the segment values of the inventory subaccount to be used with the inventory account, or the expense accrual subaccount to be used with the expense accrual account. |
| Reason code sub. | The subaccount to be used with the reason code for items of the posting class. |
| Sales account | The income account to be used as the sales account associated with the posting class. |
| Sales - non-taxable account | The income account to be used as the sales account associated with the posting class, for non-taxable income. |
| Sales - EU account | The income account to be used as the sales account associated with the posting class, for income from the EU. |
| Sales - export account | The income account to be used as the sales account associated with the posting class, for income from export. |
| Sales sub. | The subaccount to be used with the sales account associated with the posting class. |
| Standard cost variance account | The expense account to be used with the standard cost variance account associated with the posting class. |
| Standard cost variance sub. | The subaccount to be used with standard cost variance account associated with the posting class. |
| Standard cost revaluation account | The expense account to be used as the standard cost revaluation account associated with the posting class. |
| Standard cost revaluation sub. | The subaccount to be used with standard cost revaluation account associated with the posting class. |
| Purchase accrual account | The liability account to be used to accrue purchase order item amounts for items associated with this posting class, if the option Posting class is selected in the Use purchase accrual account from field in the Posting settings tab in this window. |
| Purchase accrual sub. | Depending on the rule in the Combine purchase accrual sub. from field in the Posting settings tab in this window for this posting class, this subaccount can be used as the source for one or more of the segment values of the purchase accrual subaccount to be used with the purchase accrual account. |
| Purchase price variance account | The expense account to be used as the purchase price variance account associated with the posting class. |
| Purchase price variance sub. | The purchase price variance subaccount to be used for the default posting class. |
| COGS/expense account | If this posting class will be used for stock items, this is the expense account to be used as the cost of goods sold (COGS) account associated with the posting class. If this class will be used for non-stock items or labour items, this is the expense account associated with the posting class. |
| Expense acct, non-taxable | The account to be used as the expense account associated with the posting class, for non-taxable expenses. |
| Expense EU account | The account to be used as the expense account associated with the posting class, for EU-related expenses. |
| Expense account, import | The account to be used as the expense account associated with the posting class, for import-related expenses. |
| Expense payroll taxable account | The account to be used as the expense account associated with the posting class, for payroll taxable expenses.
Note
This field is visible only if Expense Integration is enabled. |
| COGS/expense sub. | The subaccount to be used with the COGS or expense account associated with the posting class. |
| Landed cost variance account | The expense account to be used as the landed cost variance account associated with the posting class. |
| Landed cost variance sub. | The subaccount to be used with the landed cost variance account as associated with the posting class. |
| Deferral account | The general ledger account to hold the deferred revenue (liability account) or expense (asset account) amount. |
| Deferral sub. | The subaccount (if applicable in your system), for proper tracking of deferral transactions. |
| Element | Description |
|---|---|
| Sales account | The income account that is connected to the VAT payable account (it has a set VAT category). The excise duty amounts are recorded in credit. |
| Sales sub | The subaccount to be used with the sales account. |
| Sales offset account | The income account that is not connected to the VAT payable account (it does not have a set VAT category), used to balance the sales account. The excise duty amounts are recorded in debit. |
| Sales offset sub | The subaccount to be used with the sales offset account. |
| Payable account | The liability account that accumulates the excise duty amounts to be paid to a tax agency for the excise duty reporting period. The excise duty amounts are recorded in credit. |
| Payable sub | The corresponding payable subaccount. |
| Element | Description |
|---|---|
| Use Expense accounts | If this check box is selected and when a purchase invoice is released, the following transactions will be added to journal transactions. |
| Purchase P&L (debit) | Select an account here for a domestic supplier in P/L account. |
| Purchase P&L sub. | Select a subaccount here for a domestic supplier in P/L account. |
| Inventory changes P&L (credit) | Select an account for changes in inventories for goods and supplies in P/L account. |
| Inventory changes P&L sub. | Select a subaccount for changes in inventories for goods and supplies in P/L account. |
| Purchase EU | Select an account here for an EU supplier in P/L account. |
| Purchase EU sub. | Select a subaccount here for an EU supplier in P/L account. |
| Purchase import | Select an account for a non-EU supplier in P/L account. |
| Purchase import sub. | Select a subaccount for a non-EU supplier in P/L account. |
| Button | Description |
|---|---|
| View supplier inventory | Navigates to the Supplier inventory (PO201000) window so you can view supplier-specific details for the stock item if purchased from the supplier specified in the Preferred supplier column. |
| Process | Processes the items that have been selected by using the check boxes in the unlabelled column of the table. |
| Process all | Processes all the items listed in the table. |
| Element | Description |
|---|---|
| Warehouse | (This field appears only if the Warehouses functionality is enabled in your system.) The warehouse where the stock should be replenished. If the Warehouses functionality is disabled, the MAIN warehouse is assumed. |
| Purchase date | The date when the purchase will be made to replenish the stock. |
| Product manager | A field and the Me check box, which you can use to select the items to be displayed based on the product manager to whom the items are assigned for management:
|
| Work group | A field and the My check box, which you can use to select the items to be displayed based on the product work group the items are assigned to:
|
| Only suggested items | A check box you select to display only the items that require replenishment. |
| Supplier | The supplier from which the items will be purchased. |
| Item Class ID | The item class of the items to be purchased. You can leave the box blank to view the items of all item classes requiring replenishment. |
| Item ID | The item ID of the particular item to be purchased for stock replenishment. You can leave the field blank to view various items requiring replenishment. |
| Description | The description of the item to be purchased for stock replenishment. |
| Column | Description |
|---|---|
| Warehouse | (This column appears only if the Warehouses functionality is enabled in your system.) The warehouse where the stock will be replenished. |
| Item ID | The stock item for which stock replenishment is required. |
| Description | The description of the item for which stock replenishment is required. |
| Suggested qty. | The quantity to be replenished. By default, it is the value calculated based on replenishment parameters specified for the item in the particular warehouse minus the quantity on supply. The value can be manually adjusted. |
| Internal replenishment | The quantity (on internal replenishment requests) to be ordered to replenish the stock. |
| Qty. on hand | The quantity on hand of the stock item at this warehouse. |
| Qty. not available | The quantity that is not available. |
| Incoming | The quantity of items included in the purchase orders, purchase receipts, and inventory transfer documents that have not yet been released. This quantity is deducted from the planned replenishment quantity if the Minimum/maximum. replenishment method is used for this item, which is specified on the Replenishment info tab of the Item warehouse details window. |
| Outgoing | The quantity on shipments and sales orders calculated according to the availability settings of the item class. |
| Qty. on hard demand | The quantity on shipments and sales orders calculated as hard demand, that is, (Qty. sales order shipping) + (Qty sales order back-ordered) + (Qty sales order shipped). |
| Qty. available | The available quantity. |
| Safety stock | The safety stock value for the stock item, which is specified on the Replenishment info tab of the Item warehouse details window. |
| Reorder point | The stock level that, when it has been reached, prompts the system to replenish the stock of the item. The quantity is specified on the Replenishment info tab of the Item warehouse details window. |
| Max. qty. | The maximum quantity allowed at the warehouse. |
| Replenishment source | The source of replenishment for the item at this warehouse. |
| Source warehouse | (This column appears only if the Warehouses functionality is enabled in your system.) The warehouse that is the source of replenishment. |
| Default supplier | The preferred supplier from which the item will be purchased for stock replenishment, as specified for the item in the Stock items (IN202500) window. You can choose another supplier if necessary. |
| Default location | (This column only appears if the Account locations functionality is enabled in the Enable/disable functionalities (CS100000) window.) The supplier’s location from which the item can be purchased. You can choose a non-default location if necessary. |
| Default supplier name | The name of the selected supplier. |
| Item class | The item class to which the item was assigned. |
| Supplier class | The class of the supplier indicated in the Preferred supplier column. |
| Button | Description |
|---|---|
| Generate stocktaking | Generates the stocktaking document only for the items you have selected by using the check boxes in the table. You can also select all items in a page by selecting the unlabelled check box in the table column, next to the Item ID column. When the generation is done, you will be redirected to the Stocktaking review (IN305000) window, where you continue the stocktaking process. |
| Generate stocktaking all | Generates the stocktaking document for all items shown in the table. Any selections you may have done in the table will be overridden when you click this button. When the generation is done, you will be redirected to the Stocktaking review (IN305000) window, where you continue the stocktaking process. |
| Element | Description |
|---|---|
| Type ID | The type of stocktaking count to be used to generate the stocktaking sheets. |
| Description | The description of the type. |
| Warehouse | The warehouse for which the stocktaking should be prepared. By default, it is the warehouse defined by the stocktaking type. If no warehouse is specified by the type, you can select a warehouse for stocktaking.
Note
This field is only displayed if the Multiple warehouses functionality is enabled in the Enable/disable functionalities (CS100000) window is enabled.
Note
If not, the MAIN warehouse is selected by default. |
| Generation method | The generation method to be used to select stock items for counting. By default, the generation method is associated with the stocktaking type. |
| Blank lines to add | The number of lines to be added to the end of the list. These lines can be used to record additional information. |
| Include items with zero stock balance | When this is selected, the items listed in this window will include items with zero stock balance and the last previous warehouse. |
| Starting date to include from | The date selector filters the items with zero stock balance by date. For example, if you set the date to 01/01/2024, the list will only include items and locations in stock between 01/01/2024 and the current date. |
| Column | Description |
|---|---|
| Location | The warehouse location where the stocktaking will be performed. The structure of the warehouse is defined in the Warehouses (IN204000) window. |
| Description | The description of the warehouse location. |
| Pick priority | The pick priority specified for this location. |
| Column | Description |
|---|---|
| Line number | The line number in the stocktaking document. |
| Tag number | The tag number to be used for counting items with the properties specified on this line: item ID, sub item code, lot/serial number, and location.
Note
This column is only displayed if the Use tags option in the Inventory preferences (IN101000) window is selected. |
| Item ID | The identifier of the item. |
| Location | The warehouse location of the item.
Note
This column is only displayed if the Multiple warehouse locations functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Lot/serial number | The lot or serial number of the item.
Note
This column is only displayed if the Lot and serial tracking functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Expiration date | The expiration date for the specified quantity of the item with the specified lot number, if applicable.
Note
This column is only displayed if the Lot and serial tracking functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Book qty. | The quantity of the item available on hand at the specified warehouse location. |
| Base unit | The base unit of the item. |
| Description | The description of the item. |
| Item class ID | The item class to which the item belongs. |
| Field | Description |
|---|---|
| Reason code | The ID of the reason code. You can use an alphanumeric string of up to 10 characters. |
| Description | A description of the reason code. |
| Usage | An option indicating where this code can be used. The following options are available:
The rule governing how to combine subaccounts on issues is specified in Combine sub. from.
|
| Combine sub. from | The field is not available for reason codes with the Sales usage option. The adjustable subaccount mask that defines the rule of composing a default subaccount for specific types of documents on data entry forms. For each segment, point to a segment and press F3 to open the list of options. The available mask options depend on the Usage field value:
Note
The letter designating the option will be repeated as many times as there are characters in the segment. |
| Account | The general ledger account to be updated by the transaction amount for transactions marked by the reason code. Cash accounts cannot be used for any of the write-off types in the Usage field. For issues, this account will override the COGS account.
Note
The field is not available for reason codes with the Sales usage option. |
| Subaccount | The corresponding subaccount to be used with the reason code. This account is used for reason codes to be used in inventory.
Note
The field is not available for reason codes with the Sales usage option. |
| Sales account | The sales account to be updated by the transaction amount. The field is available for reason codes with the Sales and Issue usage options. |
| Sales sub. | The corresponding subaccount to be used with the reason code. The field is available for reason codes with the Sales and Issue usage options. |
| Button | Description |
|---|---|
| Release | Initiates document release, which changes the status of the receipt to Released. |
| Reports | Provides direct access to the following inventory reports related to receipts: |
| Element | Description |
|---|---|
| Ref. no. | The unique reference number of the receipt, which the system automatically assigns according to the numbering sequence selected for receipts in the Inventory preferences (IN101000) window. |
| Status | The current status of the receipt. The following options are available:
|
| Hold | A check box that you select to give the receipt the On hold status. Clear the check box to save the receipt with the Balanced status. |
| Date | The date when the receipt was created. All transactions included in this document will have this transaction date. |
| Post period | The financial period to which the transactions recorded in the document should be posted. |
| Transfer no. | The transfer number for the receipt operation. (Enter this number only if the two-step transfer operation is performed.) |
| External ref. | The external reference number of the inventory receipt (for example, the reference number used by the supplier). |
| Description | A brief description of the receipt or its transactions. |
| Total qty. | The total quantity of items to be received. |
| Control qty. | The control quantity of items specified in the receipt. Control qty. is available only if the Validate document totals on entry option is selected in the Inventory preferences (IN101000) window. The user enters this value manually to confirm the total quantity of stock items received as compared to the automatically calculated quantity of stock items included in this document. If the Control qty. and Total qty. values do not match, the system generates a warning message and the document cannot be saved. |
| Total cost | The total cost of the stock items received. The system automatically calculates this value as a sum of all extended cost values of all received stock items listed in the Transaction details tab of this window. |
| Control cost | The total cost of the stock items to be received. Control cost is only available if the Validate document totals on entry option is selected in the Inventory preferences (IN101000) window. The user enters this value manually to confirm the total cost as calculated automatically for the document. If the Control cost and Total cost values do not match, the system generates a warning message and the document cannot be saved. |
| Button | Description |
|---|---|
| Allocations | Opens the Allocations dialog box, from which you can define sub items, locations, lot or serial numbers, quantities, and expiration dates for the stock item received. |
| Add item | Opens the Item lookup dialog box so that you can add items to the receipt. |
| Column | Description |
|---|---|
| Item ID | The ID of the stock item received. Stock items are maintained in the Stock items (IN202500) window. |
| Warehouse | The warehouse where the stock item is received.
Note
This column is only displayed if the Multiple warehouses functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Location | The warehouse location where the stock item is received.
Note
This column is only displayed if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Quantity | The quantity of the received stock item (in the unit of measure indicated below). |
| UoM | The unit of measure of the received stock item. |
| Unit cost | The cost of a unit of the received stock item. |
| Cost | The extended cost of the received stock item. An extended cost is calculated automatically as the unit cost multiplied by the quantity (or amount) of item that was received. |
| Lot/serial no. | The lot or serial number of the received stock item. To specify the lot or serial numbers of the received item, click the Allocations action on the table toolbar. If multiple serial or lot numbers should be specified, the column displays <SPLIT>. This column appears only if the Lot and serial tracking functionality is enabled. |
| Expiration date | The expiration date of the received stock item.
Note
This column is only displayed if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Reason code | The reason code for the receipt transaction. |
| Project | The project with which this receipt line is associated, or the code indicating that this receipt line is not associated with any project; the non-project code is specified in the Project accounting preferences (PM101000) window. This column is only displayed if the Projects workspace has been activated. |
| Project task | The particular task of the project with which this receipt is associated. This column is only displayed if the Projects workspace has been activated. |
| Description | A brief description of the receipt transaction. |
| Element | Description |
|---|---|
| Unassigned qty. | The quantity of the stock item that has no lot or serial numbers assigned. |
| Quantity to generate | The quantity of the stock item for which lot or serial numbers should be generated. |
| Lot/serial number from | The lot or serial number to be used as a start number.
Note
This element is only displayed if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Generate | A button that you click to initiate the generation of lot or serial numbers.
Note
This button is only displayed if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Column | Description |
|---|---|
| Location | The location in the warehouse.
Note
This column is only displayed if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Lot/serial no. | The serial number of the unit of stock item or the lot number of the quantity of stock item received.
Note
This column is only displayed if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Quantity | The quantity of the stock item with the same lot number. It is 1 for items with a serial number. |
| UoM | The unit of measure (UoM) for the specified quantity of the stock item. |
| Expiration date | The expiration date of the specified quantity of the stock item.
Note
This column is only displayed if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Button | Description |
|---|---|
| OK | Saves the records generated. |
| Element | Description |
|---|---|
| Item | The ID of a particular item whose information you want to view. Leave the field blank to filter information by other criteria or type a string from the item ID to find the item. |
| Barcode | The bar code of the item to be listed. Leave the field blank to filter information by other criteria. |
| Item class ID | The item class of the items whose information you want to view. Leave the field blank to view information on items of all classes. |
| Show available items only | A check box that you select if only items whose available quantities are greater than zero should be listed in the table. |
| Warehouse | The warehouse where the item are stocked. Leave the field blank to view items from all warehouses.
Note
This field is only displayed if the Multiple warehouses functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Location | The location in the warehouse. Leave the field blank to view items in all locations.
Note
This field is only displayed if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Column | Description |
|---|---|
| Qty. selected | The quantity of sales units of the stock item (under the specified item ID) that you want to add to the document. |
| Site | The warehouse where the items are stocked.
Note
This column is only displayed if the Multiple warehouses functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Location | The location in the warehouse.
Note
This column is only displayed if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Item ID | The stock item by its item ID. |
| Description | The description of the item with the specified item ID. |
| Base unit | The unit of measure used as a base unit for the stock item. |
| Qty. available | The available quantity of this item at the specified warehouse and location. |
| Qty. on hand | The quantity on hand of this item at the specified warehouse and location. |
| Button | Description |
|---|---|
| Add | Adds the selected items. |
| Add and close | Adds the selected items and closes the dialog box. |
| Cancel | Cancels the changes and closes the dialog box. |
| Element | Description |
|---|---|
| Batch no. | The reference number of the batch generated for the receipt. Click on the number to open the Journal transactions (GL301000) window and view the details of the transactions. |
| Branch | The branch receiving the goods. |
| Button | Description |
|---|---|
| Release | Releases the documents whose check boxes you have selected (in the unlabelled column) in the Documents area. |
| Release all | Releases all documents listed in the Documents area. |
| Column | Description |
|---|---|
| Document type | The type of inventory document. The following types are available:
|
| Ref. no. | The unique reference number of the inventory document. |
| Status | The current status of the inventory document. |
| Date | The date when the inventory document was created. |
| Post period | The financial period to which the transactions generated by the inventory document should be posted. |
| Total qty. | The total quantity of goods from the inventory document. |
| Total cost | The total cost of goods from the inventory document. |
| Total amount | The total amount of goods from the inventory document. |
| Description | The brief description provided for the inventory document. |
| Column | Description |
|---|---|
| Class ID | The unique ID of the replenishment class. |
| Description | A brief description of the replenishment class. |
| Replenishment source | The default source used for stock replenishment. You can select one of the following options as the primary source of stock replenishment:
|
| Element | Description |
|---|---|
| Seasonality ID | The unique ID of the set of seasonality settings. You can use 10 characters, both numbers and letters. |
| Description | A brief description of the seasonality settings. |
| Calendar | The calendar to be used for determining low seasons and for gathering sales statistics. |
| Column | Description |
|---|---|
| Active | This check box indicates (if selected) that this low season record is active. |
| Season start date | The start date of the season. |
| Season end date | The end date of the season. CAUTION: Seasons should not intersect. |
| Factor | The factor (coefficient) used to reduce or increase the item replenishment quantity if replenishment is performed during the low season. CAUTION: Do not set factor equal to zero. |
| Element | Description |
|---|---|
| Ship via | The unique code associated with the non-integrated carrier, or the shipping option of your company. You can use up to 15 characters, both numbers and letters. |
| Description | A description of this shipping service or option. You can use an alphanumeric string of up to 30 characters. |
| Element | Description |
|---|---|
| Calendar | The calendar associated with the carrier. A calendar reflects the carrier’s work hours and the days when the carrier ships the goods. |
| Calculation method | The method used to calculate freight charges, by using the rate breakdown specified on the Freight rates tab. The following options are available:
|
| Base rate | The flat-rate charge to be added to the freight amount, which is calculated as specified on the Freight rates tab. |
| Common carrier | A check box that indicates whether this carrier is a common carrier. Because common carriers deliver goods from a company branch to the customer location which is the sales point, this check box controls which set of taxes applies to the invoice. If the check box is selected, the taxes associated with the address of the customer location are applied. If the check box is cleared, the taxes associated with the address of the selling branch are applied. |
| VAT category | The VAT category to be applied to the freight amount when goods are shipped with this code. For details, see: About freight calculation. |
| Freight sales account | The general ledger account of the Income type that is used to record the freight charges to be paid to the company. This account is associated with the ship via code and is used as one of the sources for the Use freight account from setting in the Order types (SO201000) window. |
| Freight sales sub. | The freight sales subaccount associated with the ship via code is used as one of the sources for generating the freight sales subaccount according to the rule specified in the Combine freight sub. from field in the Order types (SO201000) window. This field is available if the Subaccounts functionality is enabled in the Enable/disable functionalities window. |
| Freight expense account | The general ledger account of the Expense type to be used to record the freight amounts to be paid to the carrier. This account is not updated by the freight cost amounts from the sales orders shipped by the carrier. This account is updated on release of purchase orders by the amounts of the Freight -type lines with this ship via code specified in the Supplier location column. |
| Freight expense sub. | The freight expense subaccount associated with the ship via code. This field is available if the Subaccounts functionality is enabled in the Enable/disable functionalities window. |
| Column | Description |
|---|---|
| Weight | The minimum weight to which the rate may be applied. |
| Volume | The minimum volume to which the rate may be applied. |
| Zone ID | The shipping zone to which the goods with the specified weight and volume are shipped. |
| Rate | The flat rate or rate per weight unit, depending on the option (Net or Per Unit) selected in the Calculation method field on the Details tab. The number of decimal places for freight rates is defined by the value in the Price/cost decimal places field in the Organisations (CS101500) window. The freight amount is calculated as follows:
|
| Column | Description |
|---|---|
| Box ID | The ID of the type of boxes used by the carrier under this ship via code. |
| Description | A description of the type of field. |
| Tare weight | The weight of a box of this type. |
| Max. weight | The maximum weight of items that can fit into a box of this type. |
| Weight UoM | The unit of measure used for the weight. |
| Max. volume | The maximum volume a box of the type can hold. |
| Volume UoM | The unit of measure used for the volume. |
| Length | The length of a box of the type; along with width and height defines the three-dimensional shape of the box. |
| Width | The width of a box of the type; along with length and height, it defines the three-dimensional shape of the box. |
| Height | The height of a box of the type; along with width and length, it defines the three-dimensional shape of the box. |
| Button | Description |
|---|---|
| Actions | Provides the following actions:
|
| Inquiries | Provides quick access to inquiry forms as follows:
|
| Element | Description |
|---|---|
| Item ID | The unique alphanumeric identifier of the stock item. The structure of identifiers is defined by the INVENTORY segmented key in the Segment keys (CS202000) window.
Note
You can later change the stock item ID by selecting Change item ID in the Actions menu of the toolbar. |
| Item status | The status of the stock item. You can select one of the following options:
|
| Description | A brief description of the stock item. |
| Work group | The product work group to which the stock item is assigned. |
| Product manager | The product manager to whom this stock item is assigned for processing. |
| Element | Description |
|---|---|
| Item class | The item class to which the stock item is assigned. Selecting a class provides default settings for the item. The Item classes (IN201000) window is used to define settings and attributes for items of the class. |
| Type | The type of stock item. You can select one of the following options:
|
| Kit | A check box that indicates (if selected) that this stock item is a kit. The components of the kit can be specified using the Kit specifications (IN209500) window. |
| Valuation method | The method used for the item for inventory valuation, which by default is the valuation method associated with the item class. You can select another valuation method for the item from the following options:
|
| VAT category | The VAT code of the stock item, which by default is the VAT code associated with the item class. You can choose another VAT code if needed. |
| Posting class | The posting class of the stock item, which by default is the posting class assigned to the item class. You can select another posting class for the item. You use the Posting classes (IN206000) window to define posting classes and their properties. |
| Lot/serial class | The lot/serial class to which the stock item is assigned. Use the Lot/serial classes (IN207000) window to define lot/serial classes and their properties.
Note
This field is only displayed if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Automatic incremental value | The start value for the automatic incremented segment. Use the Lot/serial classes (IN207000) window to define this value.
Note
You can only set the start value for the auto-incremental segment if the option Share the auto-incremental value between all class items is cleared for the chosen class in the Lot/serial classes (IN207000) window.
Note
This field is only displayed if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Webhook notification | When this check box is selected and saved for a stock item, you will be notified regarding changes. The Webhook notifications tab appears when you select the stock item. |
| Element | Description |
|---|---|
| Default warehouse | The default warehouse used to store the stock item with the specified item ID. Use the Warehouses (IN204000) window to define warehouses and their properties.
Note
This field is only displayed if the Multiple warehouses functionality in the Enable/disable functionalities (CS100000) window is enabled.
Note
If the Multiple warehouses functionality is disabled, the MAIN warehouse is the default warehouse. |
| Default issue from | The location of the warehouse to be used by default to issue quantities of the selected stock item.
Note
This field is only displayed if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Default receipt to | The location of warehouse to be used by default to receive certain quantities of the specified stock item.
Note
This field is only displayed if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Element | Description |
|---|---|
| Base unit | The UoM used as the base unit for this stock item. All other units in the Unit conversion table are expressed with respect to this unit. |
| Sales unit | The UoM to be used as the sales unit for the stock item.
Note
This field is only displayed if the Multiple units of measure functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Purchase unit | The UoM to be used as the purchase unit for the stock item.
Note
This field is only displayed if the Multiple units of measure functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Undership threshold (%) | The minimal percentage of goods shipped (with respect to the ordered quantity) for the system to mark the order as shipped completely. This setting is not applicable to items with specified serial or lot numbers; these items should be shipped exactly as specified. This setting provides the default value for items of this class. |
| Overship threshold (%) | The maximum percentage of goods shipped (with respect to the ordered quantity) allowed by the customer. This setting is not applicable to items with specified serial or lot numbers; these items should be shipped exactly as specified. This setting provides the default value for items of this class. |
| Column | Description |
|---|---|
| From unit | The unit of measure for which the conversion parameters are specified. |
| Multiply/divide | The operation to be performed for unit conversion. You can select the Multiply or Divide option to perform conversions from different units of measure to the UoM specified as the base unit. |
| Conversion factor | The factor to be used for the unit conversion, along with the conversion operation specified in the Multiply/divide column. |
| To unit | The UoM selected as the base unit for the item. |
| Price adjustment multiplier | Changes the price automatically if you change the UoM. |
| Element | Description |
|---|---|
| Stocktaking cycles | The stocktaking cycle assigned to the stock item. The cycle defines how often the stocktaking counts will be performed for the stock item. Stocktaking cycles and their properties are defined in the Stocktaking types (IN208900) window. |
| ABC code | The ABC code this item is assigned to for the purpose of stocktaking. |
| Fixed ABC code | A check box that indicates (if selected) that the ABC code assigned to the item should not be changed automatically when ABC code assignments are updated. |
| Movement class | The movement class this item is assigned to for purpose of stocktaking. |
| Fixed movement class | A check box that indicates (if selected) that the movement class assigned to the item should not be changed automatically when movement class assignments are updated. |
| Element | Description |
|---|---|
| CN code | Commodity codes according to the Combined nomenclature (CN) annually revised and published as a Commission regulation in the EU, Requirement for Intrastat reporting. |
| Country of origin | The country the shipments is sent from. |
| Supplementary measure unit | Standardised codes (EU) for measure units for Intrastat reporting. Required for certain types of items. |
| Element | Description |
|---|---|
| Price class | The item price class associated with the stock item. These classes, which are used to group stock items with similar price calculation methods, are defined in the Item price classes (IN209000) window. |
| Price work group | The work group responsible for product pricing. Select the pricing work group for the stock item. |
| Price manager | The manager responsible for the product pricing. |
| Subject to commission | A check box that indicates (if selected) that commissions should be paid on the sale of this stock item. |
| Min. mark-up (%) | The minimum mark-up percentage defined for the stock item. |
| Mark-up (%) | The percentage of the item cost you add to get the selling price for this stock item. |
| List price | The manufacturer’s suggested retail price (MSRP) of the stock item. |
| Default price | The price of the stock item. This price is used as the default price, if there are no other prices (from any price list) defined for this item in the Customer ledger workspace. |
| Element | Description |
|---|---|
| Pending cost | The pending standard cost for the stock item. |
| Pending cost date | The date when the pending standard cost becomes effective. |
| Current cost | Read-only. This field displays the current standard cost for the stock item. |
| Effective date | Read-only. This field shows the effective date for the current standard cost of the stock item. |
| Last cost | Read-only. This field showing the last standard cost defined for the stock item. |
| Element | Description |
|---|---|
| Last cost | Read-only. This field showing the last standard cost used for the stock item. |
| Last cost incl. landed costs | Read-only. The last cost plus landed costs divided per item on the transaction from where the last cost is taken. This is available when the Include landed cost in unit cost check box is selected in the Inventory transaction history (IN405000) window. |
| Average cost | Read-only. This field that displays the average cost for the stock item. |
| Min. cost | Read-only. This field that displays the minimum cost for the stock item. |
| Max. cost | Read-only. This field showing the maximum cost for the stock item. |
| Element | Description |
|---|---|
| ROT | Select this option if the item is related to ROT deduction (repairs, conversion, extension). |
| RUT | Select this option if the item is related to RUT deduction (cleaning, maintenance, laundry). |
| Type | Select one of the following types:
|
| Type of work | The following work types are available for RUT:
The following work types are available for ROT:
|
| Button | Description |
|---|---|
| Add warehouse details | Navigates to the Item warehouse details (IN204500) window, where you can add warehouse-specific details of the item. |
| Column | Description |
|---|---|
| Standard | This check box indicates (if selected) that this is the standard warehouse for the stock item. |
| Warehouse | The warehouse where the stock item is available. |
| Default receipt to | The location where the stock item is received by default. The default shipping and receiving locations for the item are specified in the Item warehouse details (IN204500) window.
Note
This column is only available if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled |
| Default issue from | The location from which the stock item is issued by default.
Note
This column is only available if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled |
| Status | The status of the warehouse. |
| Inventory account | The default General ledger account to be used for transactions related to the stock item. This account can be defined for the warehouse in the Item warehouse details (IN204500) window. |
| Inventory sub. | The default General ledger subaccount to be used for transactions related to the stock item. This subaccount can also be defined for the warehouse in the Item warehouse details (IN204500) window. |
| Product work group | The product work group for this stock item, which is defined in The top part of this window. |
| Product manager | The product manager assigned to this stock item, which is defined in The top part of this window. |
| Override standard cost | This check box indicates (if selected) that the standard cost may be overridden for this stock item. This option is assigned on the Price/cost information tab of the Item warehouse details (IN204500) window. |
| Price override | This check box indicates (if selected) that the price can be overridden for this stock item. (This option is also assigned on the Price/cost information tab of the Item warehouse details (IN204500) window.) |
| Qty. on hand | The quantity of this item available (on hand) at the warehouse. This value is calculated based on the availability settings specified for the item class in the Item classes (IN201000) window. |
| Override preferred supplier | This check box indicates (if selected) that you may choose a supplier other than the preferred supplier for the item replenishment in this warehouse. |
| Default supplier | The preferred supplier for this stock item when stocked at this warehouse, as defined in the Item warehouse details (IN204500) window. |
| Override replenishment settings | This check box indicates (if selected) that you may change replenishment settings for this item at this warehouse. |
| Seasonality | The seasonality settings used for this item at this warehouse, by their ID. |
| Replenishment source | The source for the item replenishment. |
| Replenishment warehouse | The warehouse that serves as the replenishment source for the item if the item stock is replenished by a transfer. |
| Override | This check box indicates (if selected) that you may change the service level for this item. |
| Service level (%) | The service level assigned to this item at this warehouse. |
| Last forecast date | The date when the forecast for this item was calculated last. |
| Daily demand forecast | The daily demand for the item at this warehouse according to the forecast. |
| Daily demand forecast error (STDEV) | The standard deviation error calculated for the forecasted daily demand. |
| Column | Description |
|---|---|
| Active | This check box indicates (if selected) that the supplier is active. |
| Default | This check box indicates (if selected) that the supplier is the default supplier for this item. Select this check box to mark the supplier that is the main supplier of the item. When you create a purchase order to purchase an item, the default supplier is selected for this purchase. |
| Supplier ID | The ID of the supplier. The list of suppliers is maintained using the Suppliers (AP303000) window. |
| Supplier name | The name of the supplier from which the item is purchased. |
| Location | The supplier’s location from which the item is purchased, which by default is the supplier’s default location. These locations are defined for the supplier in the Supplier locations (AP303010) window. |
| Warehouse | The warehouse to receive the item. |
| Purchase unit | The unit of measure in which the item is purchased. This UoM is specified on the General settings tab of this window. |
| Supplier item ID | The Item ID used by supplier for this item. |
| Lead time (days) | Read only. This column shows the lead time for the selected supplier location. This lead time is defined in the Shipping instructions section on the General information tab of the Supplier locations (AP303010) window. |
| Override | This check box indicates (if selected) that the values in the following columns should be overridden. You can change the values in these columns only if this check box is selected. |
| Shipment lead time (days) | The additional lead time for the selected item, which represents the additional time required by the supplier to produce, assemble, and dispatch the item. This value is added to the supplier Lead time value, defined in the Supplier locations (AP303010) window, to calculate the resulting lead time required to deliver the purchased item from the supplier’s location to your company’s warehouse. |
| Min. order freq. (days) | The minimum purchase frequency for the item when purchased from this supplier. |
| Min. order qty. | The minimum order quantity for the item when purchased from this supplier. The system uses this value when you prepare replenishment requests in the Prepare replenishment (IN508000) window. |
| Max. order qty. | The maximum order quantity for the item when purchased from this supplier. The system uses this value when you prepare replenishment requests in the Prepare replenishment (IN508000) window. |
| Lot size | The lot size for the item when purchased from this supplier. |
| EOQ | The economic order quantity when the item is purchased from this supplier. This value represents the quantity on the order that minimises the total inventory holding costs and ordering costs. |
| Currency ID | The currency used by the supplier to charge for the item you purchase. |
| Last supplier price | Read only. This column shows the last supplier price defined for the stock item. |
| Column | Description |
|---|---|
| Attribute | The attribute available for this stock item. The list of attributes is defined for the item class. |
| Required | This check box indicates (if selected) that the attribute value is required for a non-stock item of the class. |
| Value | The value of the attribute specific to the item. |
| Column | Description |
|---|---|
| Category ID | The sales category identifier. |
| Column | Description |
|---|---|
| Weight | The weight of the base unit of the stock item, expressed in the weight unit of measure. |
| Weight UoM | The unit of measure used to measure weight. |
| Volume | The volume of the base unit of the stock item, measured in the volume UOM. |
| Volume UoM | The unit of measure used to measure volume. |
| Column | Description |
|---|---|
| Packaging option | The option that the system uses to automatically determine the optimal set of boxes for this item on each sales order. You can select one of the following options:
|
| Pack separately | A check box that indicates (if selected) that this item should be packed separately from other items. This check box is automatically selected (and not available for editing) if By quantity is selected as the packaging option. |
| Column | Description |
|---|---|
| Alt. item ID type | The type of alternative codification used for the item, if applicable. You can select one of the following options:
|
| Supplier/customer | The supplier or customer (by its ID) that uses the alternative identification for this stock item. |
| Alt. item ID | The alternative ID of the stock item (under the specified item ID) as used by the supplier or customer. |
| UoM | The unit of measure used for this alternative item ID. |
| Description | Any comments applicable to the specified cross-reference. |
| Default | A check box you select to set the current alternative item ID as the default alternative item ID. |
| Column | Description |
|---|---|
| Repl. class | The replenishment class to be used to replenish the stock of this item. To define the replenishment class or view its details, use the Replenishment classes (IN208800) window. |
| Seasonality | The set of seasonality settings to be used with the replenishment class. |
| Source | The replenishment source to be used for the stock item. By default, it is the replenishment source associated with the replenishment class. You can select another source, if necessary, from the following options:
|
| Method | The replenishment method to be used for the stock item with the selected replenishment source. This can be one of the following options:
|
| Replenishment warehouse | The warehouse used as a source of replenishment if the source is Purchase to order, Drop-shipment, or Transfer. |
| Max. shelf life (days) | The maximum number of days the stock item can be stored in a warehouse. |
| Launch date | The date starting the time period when the specified replenishment settings will be in effect for this stock item. |
| Termination date | The date ending the time period when the selected replenishment settings will apply to this stock item. |
| Service level (%) | The service level assigned to the item. For details, see: About replenishment parameters based on demand forecast |
| Safety stock | The safety stock (in base units) of the stock item to be used to calculate the quantity required for replenishment; these extra quantities of the item are kept at a warehouse to prevent possible stock-outs. |
| Reorder point | The stock level that, when reached, prompts the system to initiate stock replenishment for the stock item. This quantity should be set equal to the anticipated demand during the lead time plus the safety stock. |
| Max. qty. | The maximum stock level for the replenishment. When the quantity of the item falls below the Reorder point value, the system generates a replenishment request with the quantity required to replenish the stock up to the Max. qty. value. |
| Transfer ERQ | The economic reorder quantity defined for transfers that involves this stock item. This value represents the level of inventory that minimises the total transfer costs. |
| Demand forecast model | The demand forecast model to be used to calculate replenishment parameters for this item. |
| Forecast period type | The type of period to be used for selecting historical data for the model, which can be one of the following:
|
| Periods to analyse | The number of periods to be used for selecting historical data for the model. |
| Element | Description |
|---|---|
| Deferral code | The deferral code assigned to the stock item. |
| Default term | The standard amount of years a term consists of. |
| Use component subaccounts | This check box indicates (if selected) that the component subaccounts will be used in the component-associated deferrals. |
| Total percentage | The total percentage of the item price, as split among components. This value is calculated automatically as you add components and specify percentages for them. If the item is not a package, the total percentage is set to 100. |
| Column | Description |
|---|---|
| Item ID | The item ID of the component. |
| Sales account | The income account used to record sales for this component. |
| Sales sub. | The subaccount to be used to record sales for this component. |
| UoM | The unit of measure used for this component. |
| Quantity | The quantity of the specified units for the component. |
| Deferral code | The deferral code assigned to this component. |
| Default term | The standard term of the specified units for the component. |
| Default term UoM | The standard UoM used for the component. |
| Allocation method | An option indicating whether you will specify the component’s price as a percentage of the item’s price or a fixed amount in the columns that follow. Select Percentage or Fixed amount. |
| Fixed amount | The fixed amount of the item price assigned to the component if the Fixed amount option is selected in the Amount option column. |
| Percentage | This component’s percentage of the item’s price if the Percentage option is selected in the Amount option column. |
| Element | Description |
|---|---|
| Inventory account | The asset account to be used for posting inventory transactions related to this stock item. This account is used if the option Item is selected in the Use inventory/accrual account from field in the posting class (the Posting classes (IN206000) window) for this item. |
| Inventory sub. | Depending on the rule in the Combine inventory/accrual sub. from field in the posting class (the Posting classes (IN206000) window) for this item, this subaccount can be used as the source for one or more of the segment values of the inventory subaccount to be used with the inventory account. |
| Reason code sub. | The subaccount to be used for this stock item when the transaction has a reason code specified. |
| Sales account | The income account to be used for this stock item to record sales. |
| Sales sub. | The subaccount to be used for this item to record sales. |
| Sales - non-taxable account | The income account to be used for this stock item to record non-taxable sales. |
| Sales - EU account | The income account to be used for this stock item to record EU sales. |
| Sales - export account | The income account to be used for this stock item to record export sales. |
| COGS account | The expense account to be used for this stock item to record the cost of goods sold (COGS) once the sales order is released. |
| COGS sub. | The subaccount to be used for this item with the COGS account. |
| Expense acct, non-taxable | The income account to be used for this stock item to record non-taxable expenses. |
| Expense EU account | The income account to be used for this stock item to record EU expenses. |
| Expense account, import | The income account to be used for this stock item to record import expenses. |
| Standard cost variance account | The expense account to be used for this stock item to record any differences between the currently effective standard cost and the cost on the inventory receipt for the specified quantities of the stock item. This account will be used only if this item is assigned the standard cost valuation method. |
| Standard cost variance sub | The subaccount to be used for this stock item with the standard cost variance account. |
| Standard cost revaluation account | The expense account to be used for this stock item to record the differences in inventory value estimated by using the pending standard cost and the currently effective standard cost for the quantities on hand of the stock item. Revaluation is performed at the moment of updating standard costs or when the currently effective standard cost becomes the last standard cost, and the pending cost becomes the effective standard cost. This account will be used only if this item is assigned the standard cost valuation method. |
| Standard cost revaluation sub. | The subaccount to be used for this stock item with the standard cost revaluation account. |
| Purchase accrual account | The liability account to be used for this stock item to accrue purchase order item amounts for this item, if the option Item is selected in the Use purchase accrual account from field in the posting class (the Posting classes (IN206000) window) for this item. Whenever receipts linked to purchase orders are released, the system generates transactions between the purchase accrual account and the inventory account. |
| Purchase accrual sub. | Depending on the rule in the Combine purchase accrual sub. from field in the posting class (the Posting classes (IN206000) window) for this item, this subaccount can be used as the source for one or more of the segment values of the purchase accrual subaccount to be used with the purchase accrual account. |
| Purchase price variance account | The expense account to be used for this stock item to record any differences between the extended price on the purchase receipt and the extended price on the purchase invoice. This account is used if this item is assigned any of the valuation methods except for the standard cost valuation method. |
| Purchase price variance sub. | The subaccount to be used for this item with the purchase price variance account. |
| Landed cost variance account | The expense account to be used for this stock item to record any differences in landed costs that occurred between the landed costs amounts specified on purchase receipts and the amounts on inventory receipts. |
| Landed cost variance sub. | The subaccount to be used with the landed cost variance account for this item. |
| Deferral account | The account to be used to hold the deferral amount until it is fully recognised. The account type should be specified as follows:
|
| Deferral sub. | The subaccount to be used with the deferral account. |
| Element | Description |
|---|---|
| Sales account | The income account that is connected to the VAT payable account (it has a set VAT category). The excise duty amounts are recorded in credit. |
| Sales sub | The subaccount to be used with the sales account. |
| Sales offset account | The income account that is not connected to the VAT payable account (it does not have a set VAT category), used to balance the sales account. The excise duty amounts are recorded in debit. |
| Sales offset sub | The subaccount to be used with the sales offset account. |
| Payable account | The liability account that accumulates the excise duty amounts to be paid to a tax agency for the excise duty reporting period. The excise duty amounts are recorded in credit. |
| Payable sub | The corresponding payable subaccount. |
| Element | Description |
|---|---|
| Use Expense accounts | If this check box is selected and when a purchase invoice is released, the following transactions will be added to journal transactions. |
| Purchase P&L (debit) | Select an account here for a domestic supplier in P/L account. |
| Purchase P&L sub. | Select a subaccount here for a domestic supplier in P/L account. |
| Inventory changes P&L (credit) | Select an account for changes in inventories for goods and supplies in P/L account. |
| Inventory changes P&L sub. | Select a subaccount for changes in inventories for goods and supplies in P/L account. |
| Purchase EU | Select an account here for an EU supplier in P/L account. |
| Purchase EU sub. | Select a subaccount here for an EU supplier in P/L account. |
| Purchase import | Select an account for a non-EU supplier. |
| Purchase import sub. | Select a subaccount for a non-EU supplier. |
| Custom action | Description |
|---|---|
| Group details | Navigates to the Restriction groups (SM201030) window, where you can view details of the restriction group. |
| Column | Description |
|---|---|
| Group name | The name of the sub item restriction group or restriction group. |
| Specific type | The functional type of the group. |
| Description | A brief description of the group. |
| Active | A check box that indicates (if selected) that the group is active. |
| Group type | A read-only column that shows the type of the restriction group:
|
| Column | Description |
|---|---|
| Duty type | The duty type ID. |
| Duty group | The duty group ID. |
| From duty UoM | The duty rate unit for the duty type and group, as set in the Duty rates (EF207000) window. |
| Multiply/divide | The operation to be performed for conversion from the duty UoM to the UoM specified as the base unit. Only Multiply is supported. |
| Conversion factor | The factor to be used for the unit conversion, along with the conversion operation Multiply. When the duty UoM and item’s base unit are the same, the conversion factor is automatically set to 1. |
| To item base UoM | The UoM selected as the base unit for the item. |
| Column | Description |
|---|---|
| Cycle ID | The ID of the stocktaking cycle. An alphanumeric string of up to 6 characters can be used. |
| Description | A brief description of the stocktaking cycle. |
| Counts per year | The number of counts per year for the stocktaking cycle. |
| Element | Description |
|---|---|
| Ref. no. | The reference number of the stocktaking document, which the system automatically assigned when a user generated this document by using the Prepare stocktaking (IN504000) window. |
| Warehouse | The warehouse where the stocktaking counting is performed.
Note
This field is only displayed if the Multiple warehouses functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Location | The warehouse location. Select a location to display only the lines related to it, or make no selection to display lines related to all locations.
Note
This field is only displayed if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Item ID | A stock item. Select a particular stock item to display only the lines with this item. Make no selection to display lines related to all stock items. |
| Lot/serial no. | The lot or serial number of the item.
Note
This field is only displayed if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Description | The description of the stocktaking document. |
| Freeze date | The date when all operations with the items involved in physical counting were frozen. |
| Number of lines | The number of lines the document contains. |
| From line no. | The start number of the range of lines to be displayed. |
| Last line no. | The end number of the range of lines to be displayed. |
| Button | Description |
|---|---|
| Add | Opens the Add line dialog box, which you use to enter an item. This dialog box can be used to efficiently enter information about items using a bar code scanner. |
| Column | Description |
|---|---|
| Status | The status of the current line in the stocktaking document, which indicates whether count data was entered for it. Lines with no count data have the Not entered status. |
| Line no. | The number of the line in the stocktaking document. A line number is assigned to one or more items that have the same item ID, are located in the same storage location, and, if applicable, have a specific subitem code or lot or serial number. |
| Tag no. | The tag number for the line item.
Note
This column is only available if the Use tags option in the Inventory preferences (IN101000) window was selected at the time the document was created. |
| Item ID | The item ID of the line item. |
| Description | The description that was provided for the item. |
| Location | The warehouse location of the item.
Note
This column is only displayed if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Lot/serial number | The lot or serial number of the item.
Note
This column is only displayed if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Book quantity | The quantity of the item available on hand at the specified warehouse location. |
| Physical quantity | The physical quantity of the item; this value is entered manually for the item. |
| Variance quantity | The difference between the book quantity and the physical quantity for the item, as calculated automatically by the system. |
| Element | Description |
|---|---|
| Barcode | An optional element that contains the barcode of the item. |
| Item ID | The item ID of the item. |
| UoM | The read-only element that displays the unit of measure for the items. |
| Location | The warehouse location of the item.
Note
This column is only displayed if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Qty. | The physical quantity of the item as entered manually. |
| Lot/serial no. | The lot or serial number of the item.
Note
This column is only displayed if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Expiration date | The expiration date of the item with this specific lot or serial number.
Note
This column is only displayed if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Add one unit per barcode | If you select this check box, the system increases the item quantity by one unit each time the item bar code is scanned or entered manually. |
| Auto add line | If you select this check box, the system automatically adds a new line to the review for each bar code scanned for the first time. If the bar code has been scanned before, the item quantity will be increased by one unit. |
| Button | Description |
|---|---|
| Add | Adds the selected items. |
| Add and close | Adds the selected items and closes the dialog box. |
| Cancel | Cancels the changes and closes the dialog box. |
| Button | Description |
|---|---|
| Finish counting | Changes the status of the stocktaking document to Counting in progress, which makes the document available for data entry. If the Freeze the inventory when the stocktaking is in data entry state check box was not selected for this warehouse, this action also reverses the freezing of the warehouse or item involved. |
| Complete stocktaking | Completes the stocktaking review process. As a result, the status of the stocktaking document changes to Completed. |
| Cancel stocktaking | Cancels the stocktaking review process and changes the status of the current stocktaking document to Cancelled. Usually, the user cancels the document if it is not correct or it contains unmatched data. Cancelled documents do not generate inventory adjustment transactions. |
| Element | Description |
|---|---|
| Reference no. | The reference number of the stocktaking document to be reviewed. |
| Warehouse | An info field that shows the warehouse where the stocktaking count is performed.
Note
This field only is displayed if the Multiple warehouses functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Status | An info field that shows the current status of this stocktaking document. The following options are available:
|
| Freeze date | An info field that shows the date when the stocktaking document was created. On this date, all stock items selected for the stocktaking were “frozen,” meaning that no operations for these items are allowed until the document is cancelled or the counting process is completed. |
| Description | The description of the stocktaking. |
| Total physical qty. | An info field showing the total actual quantity of all stock items listed in the document. The system automatically calculates this value as the sum of all physical quantities of all items listed. |
| Total variance qty. | An info field showing the total variance quantity for the document. The system automatically calculates this value as the sum of differences between the book quantity and the physical quantity for each item in the list. |
| Total variance cost | An info field showing the total variance cost for all stock items listed in the document. The system automatically calculates this cost as the sum of differences between the item’s book quantity and the physical quantity for all items in the document. |
| Button | Description |
|---|---|
| Add | Opens the Add line dialog box, which you use to enter a new line for the item. This dialog box can be used to efficiently enter information about items using a bar code scanner. |
| Update actual cost | Updates the cost of the stock items using quantities resulting from the stocktaking. The average cost is used for all items, no matter what cost valuation method is assigned. |
| Set not entered to zero | Sets zero as the physical quantity for each line with the Not entered status and changes the status of the line to Entered. |
| Set not entered to skipped | For each line with the Not entered status, changes the status to Skipped. The lines with the Skipped status are not processed by the system. |
| Column | Description |
|---|---|
| Status | The status of the line of the stocktaking document, which indicates whether the actual physical quantity has been specified for the line. Lines with no data have the Not entered status. When you enter the count data in the line, its status changes to Entered. You can also change the status of the lines from Not entered to Skipped. The system does not process the lines with the Skipped status. |
| Line no. | The number of the line in the stocktaking document. |
| Tag no. | The tag number for the line item, which is the stock item with the properties specified in the line, such as location, subitem, and lot or serial number. |
| Item ID | The item ID of the item. |
| Description | The description provided for the item. |
| Subitem | The subitem code of the item.
Note
This column is displayed only if the Stock subitems functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Location | The warehouse location of the item.
Note
This column is displayed only if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Lot/serial number | The lot or serial number of the item.
Note
This column is displayed only if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Expiration date | The expiration date of the item with this specific lot or serial number.
Note
This column is displayed only if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Book quantity | The quantity of the item available on hand at the specified warehouse location. |
| Physical quantity | The physical quantity of the item as entered manually. |
| Variance quantity | The difference between the book quantity and the physical quantity for the line item. This value is calculated automatically by the system. |
| Unit cost | The last cost of the item’s base unit as approximation of its unit cost during the count. (The last cost is shown here for all items, no matter which cost valuation method is assigned to the item.) When the stocktaking is completed, the actual unit cost will be recalculated in accordance with the valuation method, count results, and other settings. |
| Ext. variance cost | The difference between the extended cost calculated based on the book quantity and the extended cost calculated based on the physical quantity for the item. |
| Reason code | The reason code for the item. To define the reason codes, use the Reason codes (CS211000) window. |
| Element | Description |
|---|---|
| Barcode | An optional field that contains the barcode of the item. |
| Item ID | The item ID of the item. |
| Subitem | The subitem code of the item.
Note
This field is displayed only if the Stock subitems functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| UoM | Read only. This field displays the unit of measure for the items. |
| Location | The warehouse location of the item.
Note
This column is displayed only if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Qty. | The physical quantity of the item as entered manually. |
| Lot/serial number | The lot or serial number of the item.
Note
This column is displayed only if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Expiration date | The expiration date of the item with this specific lot or serial number.
Note
This column is displayed only if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Add one unit per bar code | If you select this check box, the system increases the item quantity by one unit each time the item barcode is scanned or entered manually. |
| Auto add line | If you select this check box, the system automatically adds a new line to the review for each bar code scanned for the first time. If the bar code has been scanned before, the item quantity will be increased by one unit. |
| Add | Adds the entered data as a line to the review if the Add line automatically option was not selected. |
| Add and close | Adds the entered data as a line to the review and closes the dialog box. |
| Close | Closes the dialog box without adding the data to the review. |
| Element | Description |
|---|---|
| Adjustment ref. no. | The reference number of the adjustment document generated for the stocktaking document. Click the number to view the adjustment. |
| Element | Description |
|---|---|
| Type ID | The unique ID of the type of the stocktaking. |
| Description | A description of the type. |
| Generation method | The method to be used to generate stocktaking sheets for the type. Select one of the following options:
|
| Element | Description |
|---|---|
| Warehouse | The particular warehouse where stocktaking of this type will take place. You can leave the field blank to apply this type at any warehouse. |
| Button | Description |
|---|---|
| Add | Opens the dialog box that you can use to enter a scope of locations. Select the start location in the Start location field, select the end location in the End location field, and then click Add to add the selected scope of locations to the Locations table. |
| Column | Description |
|---|---|
| Location | The location where counting of the type will take place. |
| Description | The description of the location. |
| Pick priority | The pick priority specified for the location. |
| Element | Description |
|---|---|
| 1 | An option to group list items for the stocktaking’s first-level groups. You can select one of the following options:
|
| 2 | An option defining the order of items in each first-level group. You can select one of the following options:
|
| 3 | An option defining the order of items in each of the second-level groups. You can select one of the following options:
|
| 4 | An option defining the order of items in each third-level group. You can select one of the following options:
+
|
| Element | Description |
|---|---|
| Blank lines to add | The number of blank lines (if any) to be added at the end of the stocktaking sheets, for use by employees if any unregistered items are detected and counted. |
| Element | Description |
|---|---|
| Selection method | The option to be used for selecting stock items for stocktaking of the type:
|
| Button | Description |
|---|---|
| Add | Opens the dialog box that enables you to add multiple items to the Items table. |
| Column | Description |
|---|---|
| Item ID | The ID of the stock item. |
| Description | The description provided for the stock item. |
| Item status | The status of the stock item. |
| Item class | The item class associated with the item. |
| Element | Description |
|---|---|
| Movement class | The movement class whose items will be included in the count of the type. |
| By frequency | This check box indicates (if selected) that the items will be selected for counting from those that are due by frequencies associated with all movement classes. |
| Element | Description |
|---|---|
| ABC code | The ABC code whose items will be included in the count of the type. |
| By frequency | This check box indicates (if selected) that the items will be selected for counting from those that are due by frequencies associated with all ABC codes. |
| Element | Description |
|---|---|
| Cycle ID | The stocktaking cycle whose items will be included in the stocktaking of the type. Select the cycle and clear the By frequency check box. |
| By frequency | This check box indicates (if selected) that the items will be selected for counting from those that are due by frequencies associated with all stocktaking cycles. Selecting the check box disables the Cycle ID box. |
| Element | Description |
|---|---|
| Item class ID | The item class. |
| Description | The description of the item class |
| Element | Description |
|---|---|
| Item ID | Select which item ID you want to be shown from the Select - Item ID dialog box. |
| Item class | Select which item class you want to be shown from the Select - Item class dialog box. |
| Item type | Select the item type you want to be shown. You have three options:
|
| From period | Select from which period you want the items to be shown from the Select - From period dialog box. |
| To period | Select to which period you want the items to be shown from the Select - To period dialog box. |
| Include incomplete document lines | If this check box is selected, the incomplete document lines will also be listed. Incomplete lines are the transactions for sold or purchased items which have not been shipped or received yet. |
| Group by financial period | If this check box is selected, you see the items grouped by the period in which they were sold and purchased. |
| Element | Description |
|---|---|
| Item | The ID of the item. |
| Type | The type of the item. |
| Item description | The description of the item. |
| Quantity sold | The quantity of the item that is sold. |
| Qty. on shipments | The quantity of the item that is shipped. |
| Quantity purchased | The quantity of the item that is purchased. |
| Qty. on receipt | The quantity of the item that has been received. |
| Item class | The item class of the item. |
| Item class description | The description of the item class. |
| Period | The period in which the item was sold or purchased. |
| Element | Description |
|---|---|
| Shipment no. | The shipment number; select one of the open shipments to prepare the pro forma invoice for it. |
| Button | Description |
|---|---|
| Release | Initiates the document release process, which changes the status of the transfer document to Released. |
| Reports | Provides direct access to the following inventory reports related to inventory transfer: |
| Element | Description |
|---|---|
| Ref. no. | The unique reference number of the transfer document, which the system automatically assigns according to the sequence assigned to transfers in the Inventory preferences (IN101000) window. |
| Status | The status of the transfer. The following options are available:
|
| Hold | A check box that, if selected, indicates that the transfer document has the status On hold status. Clear the check box to save the transfer with the status Balanced. |
| Transfer type | The type of transfer. The following options are available:
|
| Date | The date when the transfer document was created. All transactions included in this document will have this transaction date. |
| Post period | The financial period to which the transactions from the transfer document should be posted. |
| From warehouse | The warehouse from which the goods are transferred. |
| To warehouse | The warehouse to which the goods are transferred. |
| External ref. | Any external reference number of the inventory transfer document. |
| Description | A brief description of the document or the transactions entered. |
| Control qty. | The manually entered quantity of goods transferred; available only if the Validate document totals on entry check box is selected in the Inventory preferences (IN101000) window. When you’re creating a transfer, you enter this value manually to confirm the total quantity of stock items transferred, compared to the automatically calculated quantity of stock items included in this document. If the Control qty. and Total qty. values do not match, the system generates a warning message and the document cannot be saved. |
| Total qty. | The total quantity of goods transferred. |
| Button | Description |
|---|---|
| Allocations | Opens the Allocations dialog box so that you can specify how the quantity of the item is split among different locations, lot or serial numbers, and expiration dates. |
| Add item | Opens the Item lookup dialog box so that you can add an item to the document. |
| Inventory summary | Opens the Inventory summary (IN401000) window as a pop-up so that you can view item availability data. |
| Column | Description |
|---|---|
| Item ID | The ID of the goods to be transferred. |
| Location | The warehouse location from which the goods are transferred.
Note
This column is only displayed if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| To location ID | The warehouse location to which the goods are transferred.
Note
This column is only displayed if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| UoM | The unit of measure (UoM) used for the goods to be transferred. |
| Quantity | The quantity of the transferred goods (in the units indicated below). |
| Lot/serial no. | The lot or serial number of the transferred goods.
Note
This column is only displayed if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Expiration date | The expiration date of the transferred goods.
Note
This column is only displayed if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Reason code | The reason code associated with the transferred goods. |
| Description | A brief description of the goods transfer transaction. |
| Element | Description |
|---|---|
| Unassigned qty. | The quantity of the stock item that has no lot or serial numbers assigned. |
| Quantity to generate | The quantity of the stock item for which lot or serial numbers should be generated. |
| Lot/serial number from | The lot or serial number to be used as a start number.
Note
This element is only displayed if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Generate (button) | A button that you click to initiate the generation of lot or serial numbers.
Note
This button is only displayed if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Column | Description |
|---|---|
| Location | The location in the warehouse.
Note
This column is only displayed if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Lot/serial no. | The serial number of the unit of stock item or the lot number of the quantity of stock item received.
Note
This column is only displayed if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Quantity | The quantity of the stock item with the same sub item code and the same lot number. It is 1 for items with a serial number. |
| UoM | The unit of measure (UoM) for the specified quantity of the stock item. |
| Expiration date | The expiration date of the specified quantity of the stock item.
Note
This column is only displayed if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Button | Description |
|---|---|
| OK | Saves the records generated. |
| Element | Description |
|---|---|
| Item | The ID of a particular item whose information you want to view. Leave the field blank to filter information by other criteria or type a string from the item ID to find the item. |
| Barcode | The bar code of the item to be listed. Leave the field blank to filter information by other criteria. |
| Location | The location in the warehouse. Leave the field blank to view items in all locations.
Note
This field is only displayed if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Item class ID | The item class of the items whose information you want to view. Leave the field blank to view information on items of all classes. |
| Receipt no. | The reference number of a particular receipt. Select a receipt by its reference number to view availability information for the items that were listed on the selected receipt. Deselect the Show available items only check box to view the information on the listed items that are not currently available. |
| Show available items only | If you select this check box, the system will list only items whose available quantities are greater than zero in the table. |
| Button | Description |
|---|---|
| Add | Adds the selected items to the document. |
| Add and close | Adds the selected items and closes the dialog box. |
| Cancel | Cancels the changes and closes the dialog box. |
| Element | Description |
|---|---|
| Batch no. | The reference number of the batch generated for the transfer. Click the number to open the Journal transactions (GL301000) window and view the transaction details. |
| Branch | The branch that initiated the transfer. |
| Button | Description |
|---|---|
| Process | Updates the ABC code assignments for the stock items listed in the details table, using your ABC code definitions from the ABC codes (IN208500) window. Fixed codes are not reassigned during processing. |
| Element | Description |
|---|---|
| Warehouse | The warehouse where the ABC code assignment will be performed.
Note
This field is only displayed if the Multiple warehouses functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Period | The financial period the ABC code assignment will be based on. |
| Column | Description |
|---|---|
| Item ID | The stock item at the warehouse whose ABC code can be updated. |
| Description | The description of the stock item. |
| Current ABC code | The ABC code currently assigned to the stock item. |
| Fixed | This check box indicates (if selected) that the ABC code is fixed for this stock item. Fixed ABC codes are not updated. You can assign fixed ABC codes to a stock item by using the Stock items (IN202500) window. |
| Criteria value | The criterion value for the item. |
| Ratio (%) | The ratio (expressed as a percent) calculated for the item as the criterion value (item stock value) divided by the criterion total value (for all items). |
| Cumulative ratio (%) | The sum of ratios from the top of the list, including the current item. |
| Projected ABC code | The ABC code to be assigned to the stock item. This assignment is based on the code definition and on the stock value of the item for the selected period. |
| Button | Description |
|---|---|
| Process | Updates the movement class assignments for the stock items listed in the table. |
| Element | Description |
|---|---|
| Warehouse | The warehouse where the movement class assignments will be updated.
Note
This field is only displayed if the Multiple warehouses functionality in the Enable/disable functionalities (CS100000) window is enabled.
Note
If not, the MAIN warehouse is used by default. |
| Year | The year of the turnover period for which the movement class assignments will be updated. |
| Period number | Read-only. This field shows the number (within the year) of the turnover period for which the movement class assignments will be updated. This value is calculated automatically based on the current business date and the number of turnover periods per year specified in the Inventory preferences (IN101000) window. |
| Start date | Read-only. This field displays the start date of the period for which the movement class assignments will be updated. This value is calculated automatically based on the current business date and the number of turnover periods per year specified in the Inventory preferences (IN101000) window. |
| End date | Read-only. This field displays the end date of the period for which the movement class assignments will be updated. This value is calculated automatically based on the current business date and the number of turnover periods per year specified in the Inventory preferences (IN101000) window. |
| Column | Description |
|---|---|
| Item ID | The stock item for which the movement class assignment can be updated. |
| Description | The description of this stock item. |
| Current movement class | The movement class currently assigned to this stock item. |
| Fixed | This check box indicates (if selected) that the movement class is fixed for this stock item, which means that its movement class assignments are not updated. A fixed movement class can be assigned to a stock item using the Stock items (IN202500) window. |
| Projected movement class | The movement class to be assigned to the stock item base on the turnover rate and movement class definitions. |
| Button | Description |
|---|---|
| Process | Updates the standard costs for the stock items you have selected by using the unlabelled check boxes in the Details area. |
| Process all | Updates the standard costs for all stock items listed in the Details area. |
| Element | Description |
|---|---|
| Warehouse | Select the warehouse or leave this box empty to view the stock items for all warehouses.
Note
This field is only displayed if the Multiple warehouses functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Max. pending cost date | The latest effective pending cost date. |
| Revalue inventory | A check box that you select if inventory revaluation should be performed during processing. |
| Column | Description |
|---|---|
| Item ID | The stock item whose pending standard cost can be updated. |
| Warehouse | The warehouse where the stock item is stocked.
Note
This column is only displayed if the Multiple warehouses functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Inventory account | The asset account to be used for the adjustment generated in the process of updating the standard cost of the item. |
| Inventory sub. | The corresponding subaccount to be used with the inventory account. |
| Pending cost | The value set as a pending cost for the item. |
| Pending cost date | The date selected for the stock item as the effective date for the pending cost. |
| Current cost | The currently effective standard cost assigned to the stock item. |
| Standard cost override | An informational check box that indicates (if selected) that the standard cost of the item may be overridden at the selected warehouse. |
| Button | Description |
|---|---|
| Process | Starts the validation process for the chosen stock items or those for which you’ve selected the check box in the table. |
| Process all | Starts the validation process for all stock items listed in the table. |
| Element | Description |
|---|---|
| Warehouse | The warehouse for which the validation will be performed.
Note
This field is only displayed if the Multiple warehouses functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Period | The financial period for the validation. |
| Rebuild item history | If you select this check box, the system builds the history of items selected for processing based on the available open and released documents. |
| Reschedule back orders | If you select this check box, the system opens the sales orders with back orders if there are positive changes during the validation. |
| Column | Description |
|---|---|
| Item ID | The stock item available at the warehouse. |
| Qty. on hand | The quantity of the base units of the stock item on hand at the selected warehouse. |
| Qty. available | The total quantity of base units of the stock item available at the selected warehouse. |
| Qty. not available | The quantity (in base units) of stock items on locations with the Include in qty. available check box not selected. The option can be found in the Warehouses (IN204000) window. |
| Last validation date | The date when the stock item was last validated. |
| Button | Description |
|---|---|
| Actions | Provides the following actions:
|
| Reports | Provides quick navigation to the following report: Location labels (IN619000). |
| Element | Description |
|---|---|
| Warehouse | The unique ID of the warehouse. |
| Branch | The branch to which this warehouse belongs. |
| Replenishment class | The replenishment class associated with this warehouse. Replenishment classes are created using the Replenishment classes (IN208800) window. |
| Active | This check box indicates (if selected) that the warehouse is active. |
| Freeze the inventory when the stocktaking is in data entry state | This check box indicates (if selected) that the inventory in the warehouse will be frozen during the stocktaking and data entry stages of stocktaking. If it is cleared, the inventory will be frozen only during the stocktaking stage. |
| Description | A brief description of the warehouse. |
| Location entry | An option indicating whether warehouse locations can be added directly on any inventory document or only by using this window. Select one of the following options:
|
| Avg. default cost (Default unit cost for average method) | For items with the Average valuation method, the option that defines which of the costs should be used as the unit cost on sales, returns and receipts. You can select one of the following options:
|
| FIFO default cost (Default unit cost for FIFO method) | For items with the FIFO valuation method, the option that defines which of the costs should be used as the unit cost on sales, returns and receipts. You can select one of the following options:
|
| Element | Description |
|---|---|
| Receiving location | The warehouse location to be used to receive goods. |
| Shipping location | The warehouse location to be used to ship goods. |
| RMA location | The RMA warehouse location. The location you select will be used for all goods return operations. The returned goods will be delivered to the specified location, regardless of the warehouse location selected by default for the receipt of these goods. |
| Drop-ship location | The warehouse location used to account for drop shipments. The goods will actually be delivered to the customer’s location; by specifying this location, you can maintain data about the item quantities on drop shipments.
Note
This field is only displayed if the Multiple warehouses functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Column | Description |
|---|---|
| Location ID | The unique ID of the warehouse location. |
| Description | A brief description of the warehouse location. |
| Active | This check box indicates whether this location is active. |
| Include in qty. available | You select this check box if the quantities of goods available at this location will be included in the quantities of available goods and used in inventory transactions, such as issues and transfers. |
| Cost separately | You select this check box if the costs for goods available at this location will be calculated separately from costs calculated at the system-level; that is, for FIFO and specific valuation methods, separate cost layers will be created for this location. You cannot select this check box if this is the only location at the warehouse. CAUTION: We recommend that you not change this option once it has been set. |
| Sales allowed | You select this check box if sales are allowed from this location. |
| Receipts allowed | You select this check box if receipts are allowed at this location. |
| Transfers allowed | You select this check box if transfers are allowed for this location. |
| Assembly allowed | You select this check box if assembly operations are allowed at this location. |
| Pick priority | A value that indicates the priority of this location when items are chosen. The value 1 indicates the highest priority, 2 the next highest, and so forth; 0 means that the pick priority is not defined. |
| Primary item validation | An option indicating whether the operations with the primary item should be validated for this location and how. Select one of the following options:
Note
Primary item validation is enforced only for received goods. |
| Primary item | The primary item for this location, which is the item that is received the most often or stored here in the highest volumes. Select the appropriate item from the list of available stock items. |
| Primary item class | The primary item class for this location; items of this class are received the most often or stored here in the highest volumes. Select the appropriate item class from the list of available item classes. |
| Project | The project to associate with this location by default. |
| Project task | The project task to associate with this location by default. |
| Element | Description |
|---|---|
| Override inventory account/sub. | A check box you select to specify the inventory account and subaccount to be used for inventory transactions related to this warehouse. When this check box is selected, for each item belonging to this warehouse, the settings in the Use inventory/accrual account from and the Combine inventory/accrual sub. from fields in the Posting classes (IN206000) window, will be overruled. |
| Inventory account | The asset account to be used for posting inventory transactions related to this warehouse. This account is used if the option Warehouse is selected in the Use inventory/accrual account from field in the posting class(es) (the Posting classes (IN206000) window) for the items belonging to this warehouse, or if the check box Override inventory account/sub. is selected in this tab. |
| Inventory sub. | Depending on the rule in the Combine inventory/accrual sub. from field in the posting class(es) (the Posting classes (IN206000) window) for the items belonging to this warehouse, this subaccount can be used as the source for one or more of the segment values of the inventory subaccount to be used with the inventory account. If the check box Override inventory account/sub. is selected in this tab, this is the subaccount that will be used with the inventory account. |
| Reason code sub. | The subaccount to be used with any reason code for transactions originated in this warehouse. |
| Sales account | The income account to be used to record sales made from this warehouse. |
| Sales sub. | The subaccount to be used for sales made from this warehouse. |
| Sales - non-taxable account | The income account to be used for this warehouse to record non-taxable sales. |
| Sales - EU account | The income account to be used for this warehouse to record EU sales. |
| Sales - export account | The income account to be used for this warehouse to record export sales. |
| COGS/expense account | The expense account to be used to record the cost of goods sold (COGS) when sales are made from this warehouse. |
| COGS/expense sub. | The subaccount to be used with the COGS account for this warehouse. |
| Standard cost variance account | The expense account to be used to record differences between the extended standard costs of the stock items received at this warehouse and their extended prices. This account is used only for transactions associated with stock items for which the standard cost valuation method is assigned. |
| Standard cost variance sub. | The subaccount to be used with the standard cost variance account. |
| Standard cost revaluation account | The expense account to be used to record differences between the values of the items at this warehouse when standard costs are updated. This account is used only for standard-valued stock items. |
| Standard cost revaluation sub. | The subaccount to be used for this warehouse with the standard cost revaluation account. |
| Purchase accrual account | The liability account to be used to accrue purchase order item amounts for items received to this warehouse, if the option Warehouse is selected in the Use purchase accrual account from field in the posting class(es) (the Posting classes (IN206000) window) for the items. Whenever receipts based on purchase orders are released, the system generates a transaction between the purchase accrual account and the inventory account. |
| Purchase accrual sub. | Depending on the rule in the Combine purchase accrual sub. from field in the posting class(es) (the Posting classes (IN206000) window) for the purchase order items received to this warehouse, this subaccount can be used as the source for one or more of the segment values of the purchase accrual subaccount to be used with the purchase accrual account. |
| Purchase price variance account | The expense account to be used to record any differences between the extended purchase prices of items received at this warehouse on purchase receipts and the extended costs of the items on related supplier invoices. This account is used for stock items with non-standard cost valuation methods assigned. |
| Purchase price variance sub. | The subaccount to be used with the purchase price variance account for this warehouse. |
| Landed cost variance account | The expense account to be used to record any differences between the amounts of landed costs on purchase receipts and the amounts of landed costs on purchase invoices for stock items received at this warehouse. |
| Landed cost variance sub. | The subaccount to be used with landed cost variance account for inventory transactions related to this warehouse. |
| Element | Description |
|---|---|
| Company name | The legal business name of the warehouse to appear on the documents. |
| Attention | The department or person to be noted on the attention line, if this line is used by your company. |
| The email address of the contact person assigned to this warehouse. | |
| Web | The URL of the web page where information about the warehouse is published. |
| Phone 1 | The primary phone number of the contact person assigned to this warehouse. |
| Phone 2 | A secondary phone number of the contact person assigned to this warehouse. |
| Fax | The fax number of the contact person assigned to this warehouse. |
| Element | Description |
|---|---|
| Address 1 | The first line in the address of the warehouse. |
| Address 2 | The second line in the warehouse address. |
| City | The city of the warehouse address. |
| Country | The country where the warehouse is located. |
| County | The county where the warehouse is located. |
| Postcode | The postcode relevant for the warehouse address. |
| View on map | A button that you can use to navigate to an interactive map on the web and view the warehouse location. |