Returns a GST report for New Zealand AccountRight files.

Table Specific Information

Select

MYOB allows a subset of columns to be used in the WHERE clause of a SELECT query. These columns may be used with the following operators: =, !=, >, <, >=, <=. In addition, queries with multiple criteria can be executed by combining the criteria with AND and OR operators. These columns support the above comparison types for server side filtering: EndDate, ReportingPeriod, ReportingBasis, YearEndAdjust. All the other columns and operators are processed client side. The default behavior is EndDate as today's date, ReportingPeriod as 6m, ReportingBasis as Cash, and YearEndAdjust as false; if the EndDate, ReportingPeriod, ReportingBasis, and YearEndAdjust filters are left unset.

SELECT * FROM NZGSTReport

To override this behavior, the values can be set directly in the query. For example:

SELECT * FROM NZGSTReport WHERE EndDate = "01/04/2019" AND ReportingBasis = "Cash"  AND ReportingPeriod = "6m" AND YearEndAdjust = false

Columns

Name	Type	References	Description
Address	String		The Address of the Company.
CompanyName	String		The name of the Business.
CreditAdjustments	Decimal		The Credit Adjustments amount for the given date range.
DebitAdjustments	Decimal		The Debit Adjustments amount for the given date range.
IrdNumber	String		The IRD number of the Company, format xxx-xxx-xxx.
NetGSTSales	Decimal		The Net GST Sales amount for the given date range.
PaymentAmount	Decimal		Total Payment Amount for the given date range.
PhoneNumber	String		The Phone number for the Company.
TotalGSTCollected	Decimal		Total GST Collected for the given date range.
TotalGSTCollectedOnPurchases	Decimal		Total GST Collected on Purchases for the given date range.
TotalGSTCollectedOnSales	Decimal		Total GST Collected on Sales for the given date range.
TotalGSTCredit	Decimal		Total GST Credit for the given date range.
TotalPurchases	Decimal		Total Amount of Purchases for the given date range.
TotalSales	Decimal		Total Amount of Sales for the given date range.
URI	String		Uniform resource identifier encompasses all types of names and addresses that refer to objects on the web.
ZeroRatedSupplies	Decimal		Total Zero Rated Supplies for the given date range.
EndDate	Date		Starting date of the period.
ReportingPeriod	String		Reporting Period for the report. This will either be 1m, 2m or 6m.
ReportingBasis	String		Reporting basis for the period, will either be Cash or Accural.
YearEndAdjust	Boolean		If you are including Year end Adjustments. This is a true or False value.
CompanyFileId	String		The ID of the company file.