Returns a GST report for New Zealand AccountRight files.
Table Specific Information
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 NZGSTReportTo 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
|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.|