Inventory Ledger Interface

Field	Description
File
Start At	Select this to navigate to a specific entry in the listview. If you indicated that the product class must be included in the inventory interface entries, then you can optionally indicate the product class from which you want to start viewing inventory ledger interface records.
List	Select this to use the List of Inventory Interface Entries program to generate a report of inventory interfaces currently defined.
Exit	Select this to exit the program.
Options
Confirm Deletions	Select this if you want the system to prompt you to confirm the deletion of an interface entry when you select to delete it. If you do not select this option, then the entry is deleted without warning.
Functions
Maintain	Select this to assign ledger entries to your inventory interface records.
Integration level	Select this to indicate the level of integration you require for your Inventory Ledger interface entries.
Validate	Select this to ensure the integrity of your interface records based on the level of integration defined. This function notifies you of missing entries encountered, and enables you to delete any invalid entries encountered.
View	This option enables you to select the type of entries you want to display in the listview.
Existing Entries	This option is selected by default. The entries displayed in the listview are the existing interface entries defined.
Missing Entries	Select this to view the missing integration entries. This option is only enabled after you select to Validate the interface entries and the system has detected missing entries.

Listview

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	Indicates the interface account to which the transaction type are posted.
Purchase price variance	Indicates the interface account to which variances between the Purchase price and the GRN price are posted.

Inventory Ledger Interface Maintenance

This screen is displayed when you select the Maintain option from the Functions menu.

Field

Description

Warehouse selection

Indicate the warehouse(s) for which you want to maintain inventory interface entries.

Product class selection

Indicate the product class(es) for which you want to maintain inventory interface entries.


	You can only access this field if you enabled it within the Define Integration Level function. When setting up interface records for product classes, the following product classes are ignored as they can only be defined at Branch level (using the G/L Codes function of the Browse on AR Branches program), irrespective of the Integration Level you selected: _DEP _FED _FIN _FRT _GST _RND _TAX Attempting to create these product classes results in the addition of zero records.

Transaction type

Issues

Select this to define the interface account to which is posted the value of an internal stock issue.

Receipts

Select this to define the interface account to which is posted the value of a stock receipt that is not linked to a purchase order or job.

If you are not using the GRN system (Purchase Orders Setup - GRN tab) then you need to enter an interface account for receipts processed using the Purchase Order Receipts and Shipment Receipt programs. If you are using the GRN system, but the option: GRN matching required is set to No 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 define the interface account to which is posted 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 define the interface account to which is posted the value of adjusting the stock count of an item using the Physical function of the Inventory Movements program.

Cost changes

Select this to define the interface account to which is posted the value of adjusting the entire on hand balance of an item.

Cost modifications

Select this to define the interface account to which is posted 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 define the interface account for posting 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.

General ledger accounts

Ledger account

Indicate the ledger account code to use for the transaction type(s) selected.

This ledger code is used if you did not select the option: Request ledger codes for inventory transactions (Inventory Setup - Options tab). If this option is selected, then 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 for warehouses using Standard Costing and if you selected Receipts at the Transaction type option.

Apply changes

Select this to apply the changes according to your selection criteria.

Delete Entries

Select this to delete the interface entries matching your selection criteria.

For example, if you selected a single warehouse and Transaction type - Adjustments, then all Adjustment type interface entries for that warehouse are deleted.

Close

Select this to return to the previous screen.

Integration Level

This screen is displayed when you select theIntegration Level option from the Functions menu.

Field	Description
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.
OK	Select this to accept your selections.
Cancel	Select this to ignore any changes you made and to return to the previous screen.

Validate Interface Entries

This screen is displayed when you select theValidate option from the Function 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
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.
OK	Select this to proceed with the validation.
Cancel	Select this to return to the previous screen.

Notes and warnings

Program access

The Inventory Ledger Interface program can be accessed by selecting the Maintain Inventory Interfaces function from the Inventory tab of the General Ledger Integration program.

Restrictions and limits

You can only generate a report of Inventory interfaces if you have access to the List of Inventory Interface Entries program.