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 criterias 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	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. Takes precedence over the CompanyFileId connection property.