Adds a sales-tax group item, which is an item used for calculating two or more sales taxes grouped together and applied to the same sale. For example, local and state taxes could be tracked separately but applied to a sale as one tax. (Compare with the ItemSalesTaxAdd message.) Taxes can be reflected in transaction line items The following information refers to invoices specifically, but it also applies to sales receipts. Generally its best to assign a tax item or tax group item to an invoice and allow QuickBooks to apply the same tax to all taxable items on the invoice. However in some situations multiple tax combinations are required, so this method doesn’t work. In this case one must use techniques to apply the taxes in the invoice itself as line items. Using lines to apply taxes isn’t always straight forward. When applying taxes as line items, only single tax items can be used, tax groups can only be used for the entire invoice. If you have multiple taxes which apply to all taxable items, and one or more other taxes that only apply to some of the items on an invoice its better to use a tax group which applies to the entire invoice for the taxes which applies to all taxable items and then apply the other taxes in the invoice itself. One applies a tax or tax group to an entire invoice by using the ItemSalesTaxRef aggregate. One can use subtotals to apply a single tax line to multiple items in an invoice, but the tax is only applied automatically for the first tax line after the subtotal line. Any other tax lines which need to be applied to the subtotal line must supply their own amount. If you don’t supply an amount the amount comes out as zero and the tax line is useless. When one does supply an amount, the amount of tax on the subtotal also shows up in the rate column for that tax line. There isn’t any way for the rate to show up as anything other than the amount of the tax. If you have a complicated tax situation where no single tax applies to all taxable items on the invoice, you must choose a zero percent tax to apply for the entire invoice. It is recommended to name such a tax item “Tax Calculated On Invoice” so that it’s clear that the tax is not being applied by QuickBooks on the entire invoice.
Request
Response
XMLOps
VB.NET
C#
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 | <?xml version="1.0" encoding="utf-8"?> <?qbxml version="17.0"?> <QBXML> <QBXMLMsgsRq onError="stopOnError"> <ItemSalesTaxGroupAddRq> <ItemSalesTaxGroupAdd> <!-- required --> <Name >STRTYPE</Name> <!-- required --> <BarCode> <!-- optional --> <BarCodeValue >STRTYPE</BarCodeValue> <!-- optional --> <AssignEvenIfUsed >BOOLTYPE</AssignEvenIfUsed> <!-- optional --> <AllowOverride >BOOLTYPE</AllowOverride> <!-- optional --> </BarCode> <IsActive >BOOLTYPE</IsActive> <!-- optional --> <ItemDesc >STRTYPE</ItemDesc> <!-- optional --> <ExternalGUID >GUIDTYPE</ExternalGUID> <!-- optional --> <ItemSalesTaxRef> <!-- required, may repeat --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </ItemSalesTaxRef> </ItemSalesTaxGroupAdd> <IncludeRetElement >STRTYPE</IncludeRetElement> <!-- optional, may repeat --> </ItemSalesTaxGroupAddRq> <ItemSalesTaxGroupAddRs statusCode="INTTYPE" statusSeverity="STRTYPE" statusMessage="STRTYPE"> <ItemSalesTaxGroupRet> <!-- optional --> <ListID >IDTYPE</ListID> <!-- required --> <TimeCreated >DATETIMETYPE</TimeCreated> <!-- required --> <TimeModified >DATETIMETYPE</TimeModified> <!-- required --> <EditSequence >STRTYPE</EditSequence> <!-- required --> <Name >STRTYPE</Name> <!-- required --> <BarCodeValue >STRTYPE</BarCodeValue> <!-- optional --> <IsActive >BOOLTYPE</IsActive> <!-- optional --> <ItemDesc >STRTYPE</ItemDesc> <!-- optional --> <ExternalGUID >GUIDTYPE</ExternalGUID> <!-- optional --> <ItemSalesTaxRef> <!-- optional, may repeat --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </ItemSalesTaxRef> <DataExtRet> <!-- optional, may repeat --> <OwnerID >GUIDTYPE</OwnerID> <!-- optional --> <DataExtName >STRTYPE</DataExtName> <!-- required --> <!-- DataExtType may have one of the following values: AMTTYPE, DATETIMETYPE, INTTYPE, PERCENTTYPE, PRICETYPE, QUANTYPE, STR1024TYPE, STR255TYPE --> <DataExtType >ENUMTYPE</DataExtType> <!-- required --> <DataExtValue >STRTYPE</DataExtValue> <!-- required --> </DataExtRet> </ItemSalesTaxGroupRet> <ErrorRecovery> <!-- optional --> <!-- BEGIN OR --> <ListID >IDTYPE</ListID> <!-- optional --> <!-- OR --> <OwnerID >GUIDTYPE</OwnerID> <!-- optional --> <!-- OR --> <TxnID >IDTYPE</TxnID> <!-- optional --> <!-- END OR --> <TxnNumber >INTTYPE</TxnNumber> <!-- optional --> <EditSequence >STRTYPE</EditSequence> <!-- optional --> <ExternalGUID >GUIDTYPE</ExternalGUID> <!-- optional --> </ErrorRecovery> </ItemSalesTaxGroupAddRs> </QBXMLMsgsRq> </QBXML> |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 | 'The following sample code is generated as an illustration of
'Creating requests and parsing responses ONLY
'This code is NOT intended to show best practices or ideal code
'Use at your most careful discretion
imports System
imports System.Net
imports System.Drawing
imports System.Collections
imports System.ComponentModel
imports System.Windows.Forms
imports System.Data
imports System.IO
imports Interop.QBFC16
Module com.intuit.idn.samples
Public Class Sample
Public Sub DoItemSalesTaxGroupAdd()
Dim sessionBegun as Boolean
sessionBegun = False
Dim connectionOpen as Boolean
connectionOpen = False
Dim sessionManager as QBSessionManager
sessionManager = nothing
Try
'Create the session Manager object
sessionManager = new QBSessionManager
'Create the message set request object to hold our request
Dim requestMsgSet as IMsgSetRequest
requestMsgSet = sessionManager.CreateMsgSetRequest("US",16,0)
requestMsgSet.Attributes.OnError = ENRqOnError.roeContinue
BuildItemSalesTaxGroupAddRq(requestMsgSet)
'Connect to QuickBooks and begin a session
sessionManager.OpenConnection("","Sample Code from OSR")
connectionOpen = True
sessionManager.BeginSession("", ENOpenMode.omDontCare)
sessionBegun = True
'Send the request and get the response from QuickBooks
Dim responseMsgSet as IMsgSetResponse
responseMsgSet = sessionManager.DoRequests(requestMsgSet)
'End the session and close the connection to QuickBooks
sessionManager.EndSession()
sessionBegun = False
sessionManager.CloseConnection()
connectionOpen = False
WalkItemSalesTaxGroupAddRs(responseMsgSet)
Catch e as Exception
MessageBox.Show(e.Message, "Error")
if (sessionBegun) then
sessionManager.EndSession()
End If
if (connectionOpen) then
sessionManager.CloseConnection()
End If
End Try
End Sub
Public Sub BuildItemSalesTaxGroupAddRq(requestMsgSet as IMsgSetRequest)
Dim ItemSalesTaxGroupAddRq as IItemSalesTaxGroupAdd
ItemSalesTaxGroupAddRq= requestMsgSet.AppendItemSalesTaxGroupAddRq()
'Set field value for Name
ItemSalesTaxGroupAddRq.Name.SetValue("ab")
'Set field value for BarCodeValue
ItemSalesTaxGroupAddRq.BarCode.BarCodeValue.SetValue("ab")
'Set field value for AssignEvenIfUsed
ItemSalesTaxGroupAddRq.BarCode.AssignEvenIfUsed.SetValue(True)
'Set field value for AllowOverride
ItemSalesTaxGroupAddRq.BarCode.AllowOverride.SetValue(True)
'Set field value for IsActive
ItemSalesTaxGroupAddRq.IsActive.SetValue(True)
'Set field value for ItemDesc
ItemSalesTaxGroupAddRq.ItemDesc.SetValue("ab")
'Set field value for ExternalGUID
ItemSalesTaxGroupAddRq.ExternalGUID.SetValue(System.Guid.NewGuid().ToString())
Dim ItemSalesTaxRef15711 as IQBBaseRef
ItemSalesTaxRef15711=ItemSalesTaxGroupAddRq.ItemSalesTaxRefList.Append()
'Set field value for ListID
ItemSalesTaxRef15711.ListID.SetValue("200000-1011023419")
'Set field value for FullName
ItemSalesTaxRef15711.FullName.SetValue("ab")
'Set field value for IncludeRetElementList
'May create more than one of these if needed
ItemSalesTaxGroupAddRq.IncludeRetElementList.Add("ab")
End Sub
Public Sub WalkItemSalesTaxGroupAddRs( responseMsgSet as IMsgSetResponse)
if (responseMsgSet is nothing) then
Exit Sub
End If
Dim responseList as IResponseList
responseList = responseMsgSet.ResponseList
if (responseList is nothing) then
Exit Sub
End If
'if we sent only one request, there is only one response, we'll walk the list for this sample
for j=0 to responseList.Count-1
Dim response as IResponse
response = responseList.GetAt(j)
'check the status code of the response, 0=ok, >0 is warning
if (response.StatusCode >= 0) then
'the request-specific response is in the details, make sure we have some
if (not response.Detail is nothing) then
'make sure the response is the type we're expecting
Dim responseType as ENResponseType
responseType = CType(response.Type.GetValue(),ENResponseType)
if (responseType == ENResponseType.rtItemSalesTaxGroupAddRs) then
'upcast to more specific type here, this is safe because we checked with response.Type check above
Dim ItemSalesTaxGroupRet as IItemSalesTaxGroupRet
ItemSalesTaxGroupRet = CType(response.Detail,IItemSalesTaxGroupRet)
WalkItemSalesTaxGroupRet(ItemSalesTaxGroupRet)
End If
End If
End If
Next j
End Sub
Public Sub WalkItemSalesTaxGroupRet(ItemSalesTaxGroupRet as IItemSalesTaxGroupRet)
if (ItemSalesTaxGroupRet is nothing) then
Exit Sub
End If
'Go through all the elements of IItemSalesTaxGroupRet
'Get value of ListID
Dim ListID15712 as String
ListID15712 = ItemSalesTaxGroupRet.ListID.GetValue()
'Get value of TimeCreated
Dim TimeCreated15713 as DateTime
TimeCreated15713 = ItemSalesTaxGroupRet.TimeCreated.GetValue()
'Get value of TimeModified
Dim TimeModified15714 as DateTime
TimeModified15714 = ItemSalesTaxGroupRet.TimeModified.GetValue()
'Get value of EditSequence
Dim EditSequence15715 as String
EditSequence15715 = ItemSalesTaxGroupRet.EditSequence.GetValue()
'Get value of Name
Dim Name15716 as String
Name15716 = ItemSalesTaxGroupRet.Name.GetValue()
'Get value of BarCodeValue
if ( not ItemSalesTaxGroupRet.BarCodeValue is nothing) then
Dim BarCodeValue15717 as String
BarCodeValue15717 = ItemSalesTaxGroupRet.BarCodeValue.GetValue()
End If
'Get value of IsActive
if ( not ItemSalesTaxGroupRet.IsActive is nothing) then
Dim IsActive15718 as Boolean
IsActive15718 = ItemSalesTaxGroupRet.IsActive.GetValue()
End If
'Get value of ItemDesc
if ( not ItemSalesTaxGroupRet.ItemDesc is nothing) then
Dim ItemDesc15719 as String
ItemDesc15719 = ItemSalesTaxGroupRet.ItemDesc.GetValue()
End If
'Get value of ExternalGUID
if ( not ItemSalesTaxGroupRet.ExternalGUID is nothing) then
Dim ExternalGUID15720 as String
ExternalGUID15720 = ItemSalesTaxGroupRet.ExternalGUID.GetValue()
End If
if (not ItemSalesTaxGroupRet.ItemSalesTaxRefList is nothing)
Dim i15721 as Integer
for i15721 = 0 to ItemSalesTaxGroupRet.ItemSalesTaxRefList.Count - 1
Dim QBBaseRef as IQBBaseRef
QBBaseRef = ItemSalesTaxGroupRet.ItemSalesTaxRefList.GetAt(i15721)
'Get value of ListID
if ( not QBBaseRefListID is nothing) then
Dim ListID15722 as String
ListID15722 = QBBaseRefListID.GetValue()
End If
'Get value of FullName
if ( not QBBaseRefFullName is nothing) then
Dim FullName15723 as String
FullName15723 = QBBaseRefFullName.GetValue()
End If
Next i15721
End If
if (not ItemSalesTaxGroupRet.DataExtRetList is nothing)
Dim i15724 as Integer
for i15724 = 0 to ItemSalesTaxGroupRet.DataExtRetList.Count - 1
Dim DataExtRet as IDataExtRet
DataExtRet = ItemSalesTaxGroupRet.DataExtRetList.GetAt(i15724)
'Get value of OwnerID
if ( not DataExtRetOwnerID is nothing) then
Dim OwnerID15725 as String
OwnerID15725 = DataExtRetOwnerID.GetValue()
End If
'Get value of DataExtName
Dim DataExtName15726 as String
DataExtName15726 = DataExtRetDataExtName.GetValue()
'Get value of DataExtType
Dim DataExtType15727 as ENDataExtType
DataExtType15727 = DataExtRetDataExtType.GetValue()
'Get value of DataExtValue
Dim DataExtValue15728 as String
DataExtValue15728 = DataExtRetDataExtValue.GetValue()
Next i15724
End If
End Sub
End Class
End Module
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 | //The following sample code is generated as an illustration of //Creating requests and parsing responses ONLY //This code is NOT intended to show best practices or ideal code //Use at your most careful discretion using System; using System.Net; using System.Drawing; using System.Collections; using System.ComponentModel; using System.Windows.Forms; using System.Data; using System.IO; using Interop.QBFC16; namespace com.intuit.idn.samples { public class Sample { public void DoItemSalesTaxGroupAdd() { bool sessionBegun = false; bool connectionOpen = false; QBSessionManager sessionManager = null; try { //Create the session Manager object sessionManager = new QBSessionManager(); //Create the message set request object to hold our request IMsgSetRequest requestMsgSet = sessionManager.CreateMsgSetRequest("US",16,0); requestMsgSet.Attributes.OnError = ENRqOnError.roeContinue; BuildItemSalesTaxGroupAddRq(requestMsgSet); //Connect to QuickBooks and begin a session sessionManager.OpenConnection("","Sample Code from OSR"); connectionOpen = true; sessionManager.BeginSession("", ENOpenMode.omDontCare); sessionBegun = true; //Send the request and get the response from QuickBooks IMsgSetResponse responseMsgSet = sessionManager.DoRequests(requestMsgSet); //End the session and close the connection to QuickBooks sessionManager.EndSession(); sessionBegun = false; sessionManager.CloseConnection(); connectionOpen = false; WalkItemSalesTaxGroupAddRs(responseMsgSet); } catch (Exception e) { MessageBox.Show(e.Message, "Error"); if (sessionBegun) { sessionManager.EndSession(); } if (connectionOpen) { sessionManager.CloseConnection(); } } } void BuildItemSalesTaxGroupAddRq(IMsgSetRequest requestMsgSet) { IItemSalesTaxGroupAdd ItemSalesTaxGroupAddRq= requestMsgSet.AppendItemSalesTaxGroupAddRq(); //Set field value for Name ItemSalesTaxGroupAddRq.Name.SetValue("ab"); //Set field value for BarCodeValue ItemSalesTaxGroupAddRq.BarCode.BarCodeValue.SetValue("ab"); //Set field value for AssignEvenIfUsed ItemSalesTaxGroupAddRq.BarCode.AssignEvenIfUsed.SetValue(true); //Set field value for AllowOverride ItemSalesTaxGroupAddRq.BarCode.AllowOverride.SetValue(true); //Set field value for IsActive ItemSalesTaxGroupAddRq.IsActive.SetValue(true); //Set field value for ItemDesc ItemSalesTaxGroupAddRq.ItemDesc.SetValue("ab"); //Set field value for ExternalGUID ItemSalesTaxGroupAddRq.ExternalGUID.SetValue(Guid.NewGuid().ToString()); IQBBaseRef ItemSalesTaxRef15693=ItemSalesTaxGroupAddRq.ItemSalesTaxRefList.Append(); //Set field value for ListID ItemSalesTaxRef15693.ListID.SetValue("200000-1011023419"); //Set field value for FullName ItemSalesTaxRef15693.FullName.SetValue("ab"); //Set field value for IncludeRetElementList //May create more than one of these if needed ItemSalesTaxGroupAddRq.IncludeRetElementList.Add("ab"); } void WalkItemSalesTaxGroupAddRs(IMsgSetResponse responseMsgSet) { if (responseMsgSet == null) return; IResponseList responseList = responseMsgSet.ResponseList; if (responseList == null) return; //if we sent only one request, there is only one response, we'll walk the list for this sample for(int i=0; i < responseList.Count; i++) { IResponse response = responseList.GetAt(i); //check the status code of the response, 0=ok, >0 is warning if (response.StatusCode >= 0) { //the request-specific response is in the details, make sure we have some if (response.Detail != null) { //make sure the response is the type we're expecting ENResponseType responseType = (ENResponseType)response.Type.GetValue(); if (responseType == ENResponseType.rtItemSalesTaxGroupAddRs) { //upcast to more specific type here, this is safe because we checked with response.Type check above IItemSalesTaxGroupRet ItemSalesTaxGroupRet = (IItemSalesTaxGroupRet)response.Detail; WalkItemSalesTaxGroupRet(ItemSalesTaxGroupRet); } } } } } void WalkItemSalesTaxGroupRet(IItemSalesTaxGroupRet ItemSalesTaxGroupRet) { if (ItemSalesTaxGroupRet == null) return; //Go through all the elements of IItemSalesTaxGroupRet //Get value of ListID string ListID15694 = (string)ItemSalesTaxGroupRet.ListID.GetValue(); //Get value of TimeCreated DateTime TimeCreated15695 = (DateTime)ItemSalesTaxGroupRet.TimeCreated.GetValue(); //Get value of TimeModified DateTime TimeModified15696 = (DateTime)ItemSalesTaxGroupRet.TimeModified.GetValue(); //Get value of EditSequence string EditSequence15697 = (string)ItemSalesTaxGroupRet.EditSequence.GetValue(); //Get value of Name string Name15698 = (string)ItemSalesTaxGroupRet.Name.GetValue(); //Get value of BarCodeValue if (ItemSalesTaxGroupRet.BarCodeValue != null) { string BarCodeValue15699 = (string)ItemSalesTaxGroupRet.BarCodeValue.GetValue(); } //Get value of IsActive if (ItemSalesTaxGroupRet.IsActive != null) { bool IsActive16.00 = (bool)ItemSalesTaxGroupRet.IsActive.GetValue(); } //Get value of ItemDesc if (ItemSalesTaxGroupRet.ItemDesc != null) { string ItemDesc16.01 = (string)ItemSalesTaxGroupRet.ItemDesc.GetValue(); } //Get value of ExternalGUID if (ItemSalesTaxGroupRet.ExternalGUID != null) { string ExternalGUID16.02 = (string)ItemSalesTaxGroupRet.ExternalGUID.GetValue(); } if (ItemSalesTaxGroupRet.ItemSalesTaxRefList != null) { for (int i16.03 = 0; i16.03 < ItemSalesTaxGroupRet.ItemSalesTaxRefList.Count; i16.03++) { IQBBaseRef QBBaseRef = ItemSalesTaxGroupRet.ItemSalesTaxRefList.GetAt(i16.03); //Get value of ListID if (QBBaseRef.ListID != null) { string ListID16.04 = (string)QBBaseRef.ListID.GetValue(); } //Get value of FullName if (QBBaseRef.FullName != null) { string FullName16.05 = (string)QBBaseRef.FullName.GetValue(); } } } if (ItemSalesTaxGroupRet.DataExtRetList != null) { for (int i16.06 = 0; i16.06 < ItemSalesTaxGroupRet.DataExtRetList.Count; i16.06++) { IDataExtRet DataExtRet = ItemSalesTaxGroupRet.DataExtRetList.GetAt(i16.06); //Get value of OwnerID if (DataExtRet.OwnerID != null) { string OwnerID16.07 = (string)DataExtRet.OwnerID.GetValue(); } //Get value of DataExtName string DataExtName16.08 = (string)DataExtRet.DataExtName.GetValue(); //Get value of DataExtType ENDataExtType DataExtType16.09 = (ENDataExtType)DataExtRet.DataExtType.GetValue(); //Get value of DataExtValue string DataExtValue15710 = (string)DataExtRet.DataExtValue.GetValue(); } } } } } |