Language:


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 TemplatePrints (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 DateStart Date of the Period from the specification window, printed in the format MMDDYY
SupplierNo. 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 AddressDelivery Address from the Contact record for the Supplier. This information will be printed as a long string on a single line
Supplier NameName from the Contact record for the Supplier
Supplier Registration No. 1Reg. No. 1 from the Contact record for the Supplier
Supplier Registration No. 2Reg. No .2 from the Contact record for the Supplier
Supplier VAT Reg. NumberVAT Reg. No. from the Contact record for the Supplier
Total AmountSum 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 MonthSum of the values in the "Base in 1st Month" row field
Total Base in 2nd MonthSum of the values in the "Base in 2nd Month" row field
Total Base in 3rdMonthSum 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 MonthSum 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 FormulaCalc. Formulae
Calculation Formula NameName from the Withholding Calculation Formula
Row BaseSum 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: