You use this program to define the interface ledger accounts for sales and costs of sales entries.
These interface records determine the ledger accounts that are credited when you sell an item from a specific branch, product class and warehouse combination. The ledger accounts that are debited are the branch control accounts defined using the AR Branches program.
Field | Description |
---|---|
File | |
Start At | Select this to navigate to a specific entry in the
listview. If you indicated that the product class, geographic area and warehouse must be included in the payment interface entries, then you can optionally indicate the product class, geographic area and warehouse from which you want to start viewing sales ledger interface records. |
List | Select this to use the Sales Ledger Interface Entries program to generate a report of sales 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 sales interface records for a selected range of branches, product classes, geographic areas, and warehouses. |
Integration level | Select this to indicate the level of integration you require for your Sales 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. |
Column | Description |
---|---|
Customer branch | Indicates the Accounts Receivable branch for the interface entry. |
Product class | Indicates the product class for the interface entry. |
Geographic area | Indicates the geographic area for the interface entry. |
Warehouse | Indicates the warehouse for the interface entry. |
Sales | Indicates the interface account to which the sales amounts for stocked, non-stocked and miscellaneous charges are posted. |
Sales returns | Indicates the interface account to which the sales return amounts are posted. |
Trade discount | Indicates the interface account to which trade discount amounts are posted. |
Cost of sales | indicates the interface account to which the cost of sales amounts for stocked, non-stocked and miscellaneous charges are posted. |
IBT | Indicates the interface account to which the sales amounts arising from inter-branch transfers (Sales Orders) are posted. |
IBT cost of sales | Indicates the interface account to which the cost of sales amounts arising from inter-branch transfers (Sales Orders) are posted. |
This screen is displayed when you select the Maintain option from the Functions menu.
Field | Description | ||||
---|---|---|---|---|---|
Branch selection | Indicate the branch(es) for which you want to maintain sales interface entries. | ||||
Product class selection |
Indicate the product class(es) for which you want to maintain sales interface entries.
|
||||
Geographic area selection |
Indicate the geographic area(s) for which you want to maintain sales interface entries.
|
||||
Warehouse selection |
Indicate the warehouse(s) for which to maintain sales interface entries.
|
||||
Non-stocked | |||||
Miscellaneous charges | |||||
General ledger accounts | |||||
Sales |
This indicates the interface account to which the sales amounts for stocked, non-stocked and miscellaneous charges are posted. This is usually a revenue account. This is the account that links the Accounts Receivable module to the Sales Revenue accounts in the General Ledger. |
||||
Sales returns |
This indicates the interface account to which the sales return amounts are posted. This is usually a revenue account. If no entry is made here, then the entry defined at the Sales field is used as the default. |
||||
Trade discount |
This indicates the interface account to which trade discount amounts are posted. This is usually a revenue account. If no entry is made here, then the entry defined at the Sales field is used as the default. |
||||
Cost of sales |
This indicates the interface account to which the cost of sales amounts for stocked, non-stocked and miscellaneous charges are posted. This is usually an expense type account. |
||||
IBT sales |
This indicates the interface account to which the sales amounts arising from inter-branch transfers (Sales Orders) are posted. This is usually a revenue type account. |
||||
IBT cost of sales |
This indicates the interface account to which the cost of sales amounts arising from inter-branch transfers (Sales Orders) are posted. This is usually an expense type account. |
||||
Apply changes | Select this to apply the changes according to your selection criteria. | ||||
Delete Entries | Select this to delete the entries matching your selection criteria. | ||||
Close | Select this to return to the previous screen. |
This screen is displayed when you select the Integration Level option from the Functions menu.
Field | Description | ||||
---|---|---|---|---|---|
Integration Level |
Indicate the level of integration you require for your Sales Ledger interface entries. The following product classes can only be defined at Branch level (using the AR Branches program) irrespective of the Integration Level you select:
|
||||
Product class | Select this to include the product class in the sales interface entries. | ||||
Geographic area | Select this if you want to include the geographic area in the sales interface entries. | ||||
Warehouse | Select this to include the warehouse in the sales
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. |
This screen is displayed when you select the Validate 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 enables you to delete 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. |
The AR Sales Ledger Interface program can be accessed by selecting the Maintain Sales Interfaces function (General Ledger Integration).