In Business Central, you can create additional sheets based on VAT purchase ledgers and VAT sales ledgers.
Create entries for an additional sheet for a VAT purchase or sales ledger
Select the VAT purchase or sales line in the VAT Ledger List window with the required accounting period.
Choose the Create Additional Sheet action.
Fill in the batch job according to the guidelines at Create VAT Sales Led. Ad. Sh.
The parameters for creating a VAT purchase ledger additional sheet and VAT sales ledger additional sheet are the same as the parameters for creating the VAT Purchase Ledger and the VAT Sales Ledger.
Print additional sheets on a VAT Ledger
On the VAT Purchase Ledger Card or VAT Sales Ledger Card page, choose Export Add. Sheet.
In the Period Type field, select one of the following options:
- Day
- Month
- Quarter
Note
The selected ledger determines the ledger type and code for the export.
Choose OK to export the additional sheet to Excel. Print the exported workbook from Excel.
Set Purch. Add. Sheet Templ. Code or Sales Add. Sheet Templ. Code in Tax Register Setup before you export the corresponding sheet.
Create corrective documents to include in additional sheets
The information changed in the tax invoice after the invoice is registered in the previous purchase book must be reflected in the additional sheet of the previous book (corrected book). The additional sheet is part of the purchase book.
The first line contains the totals of the purchase book at the end of the period when the tax invoice is registered. The next lines are the annulled tax invoices. The annulled tax invoices have a negative sign if the corrected invoice amount is lesser than the initial amount, and a positive sign if the corrected invoice amount is greater than the initial amount. The last line is calculated as the sum of the amounts of the first total line and the annulled tax invoices.
The information changed in the tax invoice after the invoice is registered in the previous sales book must be reflected in the additional sheet of the previous book (corrected book). The additional sheet is part of the sales book.
The first line contains totals of the sales book at the end of the period when the tax invoice is registered. The next lines are the annulled tax invoices with a negative sign. The corrected invoices with positive amounts belong to the previous period. The last line is calculated as the sum of the amounts of the first total line, annulled tax invoices, and the corrected invoices.
Processing of corrective documents for sales book is similar to processing for purchases book with one difference. In additional sheets, the number and the date of initial facture must be reflected.
Create a correction entry for posted purchase credit memos
- Create a purchase credit memo.
- Select Additional VAT Ledger Sheet.
- Enter information in the following fields:
- Corrected Document Date
- Vendor VAT Invoice Date
- Vendor VAT Invoice Rcvd Date
- Vendor VAT Invoice No.
- Post the purchase credit memo.
Create a correction entry for a posted purchase invoice
Create a purchase invoice.
Fill in Corrected Document Date.
Enter information in the following fields:
- Vendor VAT Invoice Date
- Vendor VAT Invoice Rcvd. Date
- Vendor VAT Invoice No.
Post the purchase invoice.
Note
You can also create corrective documents in the general journal. General journal lines contain all the fields mentioned above.
Post additional VAT
In the Sales Invoice window or the Credit Memo window, choose the VAT tab.
Enter the Posting No. field.
Note
You can't post an invoice with the same number as the initial invoice. You must use an extra symbol in addition to the initial number.
Select the Additional VAT Ledger Sheet field.
Enter information in the Corrected Document Date field.
In the additional sheet, the Date of Facture field reflects the corrected document date.