Sales Ledger Transfer

This is a server-side process, which can be run straight away or scheduled to be run at a later time.

Use the S/L Transfer command to post invoices, credit notes, receipts, refunds and adjustments to the Nominal Ledger from the Sales Ledger transfer file. This command is used only if the Nominal Ledger is updated in batches with Sales Ledger, Invoicing or SOP transactions. To run this command the application's date must be in the current Nominal Ledger period. If necessary, use the Date & Company command on the toolbar or on the Opera 3 button to change the date.

If you use the Open Period Accounting feature, the application checks for transactions with posting dates that fall:

before the current Nominal Ledger period
in the current Nominal Ledger period
after the current Nominal Ledger period.

The transactions are then transferred to the relevant period in the Nominal Ledger if the respective periods' status in the Financial Calendar are set to 'Open'.

If the transactions can be transferred because the periods' status is set to 'Open', a separate journal is posted for each of the periods that the transactions fall into. For example, if the current period in the Nominal Ledger is October and there are transactions that are transferred to September , October and November, three separate journals are posted.
If a Nominal Ledger account's Summary Transfer box is ticked, the application will consolidate transactions that fall in the same Nominal Ledger period. Transactions that fall in different periods are not consolidated.
If the periods' status are set to 'Blocked' or 'Closed', the transactions are not transferred and an audit report is displayed with the details. You then need to make sure that the status of the affected periods are set to 'Open' and run the transfer command again.

If you do not use the Open Period Accounting feature in Opera 3, only transactions with posting dates that fall in the current Nominal Ledger period or fall before the current period will be transferred.

Running Multiple Transfers

You can run the command as many times as you want; even in the same accounting period. The application will ensure that postings are not duplicated.

The integration between the Sales Ledger and the Nominal Ledger is controlled by the Sales Ledger to Nominal box on the Company Profiles form in the System module. Once the option is ticked, you have a choice to update the Nominal Ledger in real-time as they are posted, or in batches using the S/L Transfer command.

To update the Nominal Ledger in real-time, tick both the Sales Ledger to Nominal box and the Real Time Update to Nominal box on the Company Profiles form in the System module. If you use this method, you will not need to use the S/L Transfer command unless you have posted transactions in the Sales Ledger that could not be posted to the Nominal Ledger in real time. For more information, see the Company Profiles Help topic.
To update the Nominal Ledger in batches, the Sales Ledger to Nominal box must be ticked. The Nominal Ledger is then updated when you use the S/L Transfer command in the Nominal Ledger. You can run the command as many times as you want; even in the same accounting period. The application will ensure that postings are not duplicated.

Box	Description
Ignore Advanced Transactions?	Tick this box to exclude advanced transactions from the transfer. If the date of an advanced posting falls in the current accounting period in the nominal ledger, the transaction is transferred unless you tick this box. The box is enabled if the Allow Advance Postings box is selected on the Set Options form in the Sales Ledger.
Report Only	Tick this box to print a report of the transactions that will be posted without updating the Nominal Ledger. You can use the report to check for any misdirected postings or those that are designated for suspense accounts giving you the opportunity to make corrections before the transfer takes place.
Transfer Only	Tick this box to update the Nominal Ledger without printing a report. This is the quickest method to transfer transactions because no time is needed to generate a report. After transferring the transactions you can use the Nominal Ledger - Reports - Audit trail to see the transfer details.
Transfer and Report	Tick this box to update the Nominal Ledger and print a report. If the transaction date of an item to be transferred is older than the first day of the current accounting period, it will be posted to the current period in the nominal ledger and a warning will be displayed on the report. The transaction date is set to the date when the transfer takes place. The Nominal account that is updated depends on the type of transaction and the way you have set up the Sales Ledger. For more details, click here. Invoices and credit notes are posted to the nominal account linked to the Sales Code used on the invoice or credit note. VAT is posted to the nominal account linked to the VAT code used on the invoice or credit note. The debtors control account that is updated is either: the control account linked to the Customer Profile for the customer the control account linked to the customer's Options form the control account on the Set Options form in the Nominal Ledger that is linked to the Sales Ledger. Receipts and refunds are posted to the bank account chosen when the transaction was posted. Discounts are posted to the nominal account in the Discount Given box on the Set Options form in the Sales Ledger. Adjustments are posted to the nominal account linked to the Adjustment Name which was selected in the Reference 2 list box on the adjustment. If the Summary Transfer box is ticked on the nominal account's record on the Accounts form in the Nominal Ledger, only a summary total is posted to that nominal account. If the box is cleared, each transaction's details are posted to the nominal account.
Sales Analysis Company	When you carry out the transfer, you must nominate the Sales Ledger's company from which the postings will be transferred. If you have more than one company with a Sales Ledger, you must run the process for each company. You must carry out the transfers for each company before you use the Period End command in the Nominal module.

Box

Description

Ignore Advanced Transactions?

Tick this box to exclude advanced transactions from the transfer. If the date of an advanced posting falls in the current accounting period in the nominal ledger, the transaction is transferred unless you tick this box. The box is enabled if the Allow Advance Postings box is selected on the Set Options form in the Sales Ledger.

Report Only

Tick this box to print a report of the transactions that will be posted without updating the Nominal Ledger. You can use the report to check for any misdirected postings or those that are designated for suspense accounts giving you the opportunity to make corrections before the transfer takes place.

Transfer Only

Tick this box to update the Nominal Ledger without printing a report. This is the quickest method to transfer transactions because no time is needed to generate a report.

After transferring the transactions you can use the Nominal Ledger - Reports - Audit trail to see the transfer details.

Transfer and Report

Tick this box to update the Nominal Ledger and print a report. If the transaction date of an item to be transferred is older than the first day of the current accounting period, it will be posted to the current period in the nominal ledger and a warning will be displayed on the report. The transaction date is set to the date when the transfer takes place.

The Nominal account that is updated depends on the type of transaction and the way you have set up the Sales Ledger. For more details, click here.

If the Summary Transfer box is ticked on the nominal account's record on the Accounts form in the Nominal Ledger, only a summary total is posted to that nominal account. If the box is cleared, each transaction's details are posted to the nominal account.

Sales Analysis Company

When you carry out the transfer, you must nominate the Sales Ledger's company from which the postings will be transferred. If you have more than one company with a Sales Ledger, you must run the process for each company. You must carry out the transfers for each company before you use the Period End command in the Nominal module.