Calc. and Post VAT Settlement Batch Job

With this batch job you can close open VAT entries and transfer purchase and sales VAT amounts to the VAT settlement account.

For every VAT posting group (that is, every combination of VAT business posting group and VAT product posting group in the VAT Posting Setup table), the batch job finds all the VAT entries in the VAT Entry table that are included in the filters in the definition window.

When the VAT entries are closed, the Closed field in the VAT Entry is marked. The entry number of the settlement entry that has closed the entry is inserted automatically in the Closed by Entry No. field. But this happens only when the amount must be transferred between G/L accounts.

When a VAT amount is transferred to the VAT settlement account, the account for purchase VAT is credited and the account for sales VAT is debited with the amount from the VAT statement period. The account numbers are found in the VAT Posting setup table. The account for VAT settlement is credited with the net amount (or, if the purchase VAT amount is larger, it is debited).

You can use the batch job either to start the posting process or to print out a test report.

The posted entries are assigned the dimensions from the G/L accounts they are posted to.

You can define what will be included in the batch job by setting filters. You can set additional fields on the tab by clicking the Field field, then clicking the AssistButton that appears to the right. You can also determine what is shown in the report by filling in the fields on the Options tab. Fill in the fields as follows:

VAT Bus. Posting Group: Select the VAT Bus. Posting Group to be included in the batch job. If you do not select any, all VAT Bus. Posting Groups will be included. To see the existing VAT business posting groups, click the Filter field and then click the AssistButton that appears to the right.

VAT Prod. Posting Group : Select the VAT Prod. Posting Group to be included in the batch job. If you do not select any, all VAT Prod. Posting Groups will be included. To see the existing VAT product posting groups, click the Filter field and then click the AssistButton that appears to the right.

Click the up-arrow at the lower left-hand corner of the window to see the result of the filters you have defined for the table.

Options

Starting Date: Enter the first date in the period from which VAT entries will be processed in the batch job.

Ending Date: Enter the last date in the period from which VAT entries will be processed in the batch job.

Posting Date: Enter the date on which the transfer to the VAT account will be posted. This field must be filled in.

Document No.: Enter a document number. This field must be filled in.

Settlement Account: Select the number of the VAT settlement account. Click the AssistButton arrow to the right of the field to see the chart of account. This field must be filled in.

Show VAT Entries: Place a check in the box if you want the report that is printed during the batch job to contain the individual VAT entries. If you do not choose to print the VAT entries, the settlement amount will be shown only for each VAT posting group.

Post: Place a check in the box if you want the program to post the transfer to the VAT settlement account automatically. If you do not choose to post the transfer, the batch job will only print a test report, and on the report will appear: Test Report (not Posted).

Show Amounts in Add. Reporting Currency: Enter a check mark in the box if you want report amounts to be shown in the additional reporting currency.

Click the Print button to print out the report. If you want to see the report on the screen before printing, click the Preview button. If you do not want to print the report now, click Cancel to close the window.