Withholding Certificates Periodic Statement
The Withholding Certificates Periodic Statement is only available if the VAT Law in the
Company Info setting is set to "Singaporean". You can use this form when you need to print a summary of the Withholding Certificates connected to each Supplier. Separate pages will be printed for each Supplier. On each page, separate rows will be printed for each Calculation Formula, containing aggregate figures compiled from the Withholding Certificates in the Withholding Certificates setting.
- Period
- Paste Special
Reporting Periods setting, System module
- Specify a period: all Withholding Certificates whose Pay. Dates fall within that period will be included in the statement calculations.
- Payment No.
- Range Reporting
Numeric
- If you enter a Payment Number or range of Payment Numbers here, all Withholding Certificates connected to the specified Payments will be included in the statement calculations.
- Supplier
- Paste Special
Suppliers in Contact register
- Range Reporting Alpha
- Enter a Supplier to print a Withholding Certificates Periodic Statement for that Supplier.
- If you leave this field empty (or specify a range), statements will be printed for every Supplier (or every Supplier in the range). Blank statements will be printed for Suppliers with no Withholding Certificates entered during the report period.
When you design the Form Template to be used by the Withholding Certificate Periodic Statement, bear in mind that if you print statements for a range of Suppliers, separate statements will be printed for each Supplier. So, the fields that you can use fall into two broad categories:
- Fields that print information about each Supplier. These fields will be printed once for each Supplier.
- Row fields. A separate row will be printed for each Calculation Formula used in Withholding Certificates in a Supplier's name. For example, if there are two Withholding Certificates with Calculation Formula RIBB2 and one Withholding Certificates with Calculation Formula RGALQ, this will cause two rows to be printed in the statement. The first row will print total figures from the two RIBB2 Certificates, and the second row will print totals from the RGALQ Certificate.
Listed below are the fields you can use when you design the Form Template to be used by the Withholding Certificate Periodic Statement form:
| Field in Form Template | Prints (from Supplier) |
| |
| Header Fields (these print once per Supplier) |
| |
| Period End Date | End Date of the Period from the specification window, printed in the format MMDDYY |
| Period Start Date | Start Date of the Period from the specification window, printed in the format MMDDYY |
| Supplier | No. from the Contact record for the Supplier |
| Supplier Address | Invoice Address from the Contact record for the Supplier. This information will be printed as a long string on a single line |
| Supplier Delivery Address | Delivery Address from the Contact record for the Supplier. This information will be printed as a long string on a single line |
| Supplier Name | Name from the Contact record for the Supplier |
| Supplier Registration No. 1 | Reg. No. 1 from the Contact record for the Supplier |
| Supplier Registration No. 2 | Reg. No .2 from the Contact record for the Supplier |
| Supplier VAT Reg. Number | VAT Reg. No. from the Contact record for the Supplier |
| Total Amount | Sum of the values in the "Amount" row field |
| Total Base | "Total Base in 1st Month" + "Total Base in 2nd Month" + "Total Base in 3rdMonth" |
| Total Base in 1st Month | Sum of the values in the "Base in 1st Month" row field |
| Total Base in 2nd Month | Sum of the values in the "Base in 2nd Month" row field |
| Total Base in 3rdMonth | Sum of the values in the "Base in 3rd Month" row field |
| |
| Row Fields (these print once for each Withholding Calculation Formula used with a particular Supplier, so remember to specify a Line Height and to set the Format to "Matrix") |
| |
| Amount | Sum of the Amounts from each Withholding Certificate |
| Base in 1st Month, Base in 2nd Month, Base in 3rd Month | Sum of the Bases from each Withholding Certificate, divided into calendar quarters. If the Pay. Date in a Withholding Certificate is in January, April, July or October, its Base will be included in the Base in 1st Month figure. If the Pay. Date is in February, May, August or November, the Base will be included in the Base in 2nd Month figure. Otherwise, the Base will be included in the Base in 3rd Month figure. |
| Calculation Formula | Calc. Formulae |
| Calculation Formula Name | Name from the Withholding Calculation Formula |
| Row Base | Sum of the Bases from each Withholding Certificate |
Please refer
here for details of the standard fields that you can also include in the Form Template.
---
Forms in the Purchase Ledger:
Go back to:
Introduction to Forms in the Purchase Ledger
