You use this program to define the interface ledger accounts required when processing non sales-related inventory transactions.
- Toolbar and menu
- Inventory Ledger Interface Details
- Inventory Ledger Interface Maintenance
- Integration Level
- Validate Interface Entries
- Notes and warnings
| Field | Description | ||||||
|---|---|---|---|---|---|---|---|
| Functions | |||||||
| Maintain | Enable the Inventory Ledger Interface Maintenance options to indicate the ledger entries you want to maintain. | ||||||
| Integration level | Indicate the level of integration you require for your Inventory Ledger interface entries. | ||||||
| Validate | Select this to check the integrity of your interface records based on the level of integration defined. You are notified of missing entries encountered, and can delete any invalid entries encountered. | ||||||
| View | Indicate the type of entries to display in the
listview.
|
You use this editable grid to add and maintain individual interface entries.
| Column | Description |
|---|---|
| Warehouse | Indicates the warehouse for the interface entry. |
| Product class | Indicates the product class for the interface entry. |
| Transaction type | Indicates the transaction type for the interface entry. |
| Ledger account | Indicate the interface account to which the transaction type are posted. |
| Purchase price variance | Indicate the interface account to which variances between the Purchase price and the GRN price are posted. |
This screen is enabled when you select the Maintain option from the Functions menu or the Change icon from the Inventory Ledger Interface Details toolbar.
| Field | Description | ||||
|---|---|---|---|---|---|
| Apply changes | Select this to apply the changes according to your selection criteria. | ||||
| Cancel | Select this to return to ignore any changes made. | ||||
| Warehouse selection | Indicate the warehouse(s) for which to maintain inventory interface entries. | ||||
| Product class selection |
Indicate the product class(es) for which to maintain inventory interface entries.
|
||||
| General ledger accounts | |||||
| Ledger account |
Indicate the ledger account code to use for the transaction type(s). This ledger code is used if you did not enable the option: Request ledger codes at transactions (Inventory Setup). When this option is enabled, the account you enter here is displayed as the default, but can be changed by the operator when processing inventory transactions. |
||||
| Purchase price variance | Indicate the account to which postings must be made
when processing a purchase order receipt (where standard
costing is in use) and the receipt cost differs from the
standard cost. This field is only enabled when the Transaction type is set to Receipts. |
||||
| Transaction type | |||||
| Issues | Select this to indicate the interface account to which to post the value of an internal stock issue. | ||||
| Receipts |
Select this to indicate the interface account to which to post the value of a stock receipt that is not linked to a purchase order or job. You need to enter an interface account for receipts processed using the Purchase Order Receiptsand Shipment Receipt programs if you are not using the GRN suspense system (Purchase Orders Setup). If you are using the GRN system, but the GRN matching required option is not enabled against a supplier for whom you are processing a receipt using the Purchase Order Receipts or Shipment Receipt programs, then you need to specify the interface account for the receipt in this field. |
||||
| Adjustments |
Select this to indicate the interface account to which to post the value of adjusting the on hand quantity of an item. Typically, this is used in cases of inventory damage or loss. This account is also used by the Stock Take System to post the value of stock take variances (see Stock Take Variance). |
||||
| Physical counts | Select this to indicate the interface account to which to post the value of adjusting the stock count of an item using the Physical function of the Inventory Movements program. | ||||
| Cost changes | Select this to indicate the interface account to which to post the value of adjusting the entire on hand balance of an item. | ||||
| Cost modifications |
Select this to indicate the interface account to which to post the value of adjusting a portion of the on hand balance of an item. Typically, this is used to adjust a receipt that was entered at the wrong cost. |
||||
| Warehouse transfers | Select this to indicate the interface account to which
to post the value of transferring an item between
warehouses. This should be a warehouse transfers clearing account and should not be same account as the warehouse control account. |
||||
![[Note]](images/note.png)
This screen is displayed when you select the Integration Level option from the Functions menu.
| Field | Description |
|---|---|
| OK | Accept your selections. |
| Cancel | Ignore any changes you made and to return to the previous screen. |
| Integration Level | |
| Product class | Select this to include the product class in the inventory interface entries. |
| Transaction type | Select this to include the transaction type in the inventory interface entries. |
This screen is displayed when you select the Validate option from the Functions menu to ensure the integrity of your interface records based on the level of integration defined. This function notifies you of missing entries encountered, and also deletes any invalid entries encountered.
| Field | Description |
|---|---|
| OK | Proceed with the validation. |
| Cancel | Return to the previous screen. |
| Delete entries no longer valid | Select this if you want the system to delete entries that are no longer valid. |
| Check for missing entries | Select this if you want the system to indicate all missing entries. |
-
The Inventory Ledger Interface program can be accessed by selecting the Maintain option at the Inventory interfaces field of the General Ledger Integration program.