SAP Knowledge Base Article - Public

2807190 - Point-of-Sale Transactions is Inconsistent with the Error Tax Region is missing and/or Tax Group is missing

Symptom

You created a Point-of-Sale Transaction but the Sales Transaction is Inconsistent with the following error:

Sales Item ABC-X: Tax group is missing
Tax Item ABC-X: Tax region is missing

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Customer Invoicing work center.
  2. Go to the Point-of-Sale Transactions view.
  3. Select the Sales Transaction sub view.
  4. Open Sales Transaction ABC (ABC represents the Internal ID of the Sales Transaction).
  5. The following errors are displayed: 
    Sales Item ABC-X: Tax group is missing (X represents the Item number)
    Tax Item ABC-X: Tax region is missing

Cause

The Tax Country used in the payload is a simplified Tax Country. For Simplified Tax Countries you have to pass

  • the Tax Group ID on both the sales and tax items since sales items, in the case of simplified tax codes, do not have other tax attributes as tax type or tax rate.
  • the Tax Region in the sales item.

Tax Group ID: Groups the items that incur tax as the resulting tax items. This is merely for the system to identify the grouping of sales and tax items regardless of what value you enter. It is preferable to have values entered here in a sequence, rather than random ones. Important is to pass the same Tax Group ID on the sales and tax items for the same item.

Tax Region: A region code specifying the region in which the tax is incurred. For example if the tax incures according to the Ship-From Party then the reagon of the Ship-From location should be used as the Tax Region. You can find the respective values for the Region in the Fine Tuning Activity Regions in your Business Configuration.

We currently have 4 Simplified Tax Countries:

  • Canada
  • Spain
  • India
  • Mexico

Resolution

Please find below a sample payload for the Point-of-Sale Transaction for the Tax Country Spain:

<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:glob="http://sap.com/xi/SAPGlobal20/Global">
   <soap:Header/>
   <soap:Body>
      <glob:PointOfSaleTransactionBundleNotification>
         <MessageHeader>
            <CreationDateTime>2019-06-01T15:16:17.039+02:00</CreationDateTime>
            <SenderParty>
               <InternalID schemeID="CommunicationSystemID" schemeAgencyID="310">JAVAPOS</InternalID>
            </SenderParty>
            <BusinessScope>
               <TypeCode>3</TypeCode>
               <ID>301</ID>
            </BusinessScope>
            <BusinessScope>
               <TypeCode>2</TypeCode>
               <ID>300</ID>
            </BusinessScope>
         </MessageHeader>
         <PointOfSaleTransactionBundleNotification>
            <ExternalID>POS01</ExternalID>
            <TypeCode>1</TypeCode>
            <BusinessTransactionDate>2019-06-07</BusinessTransactionDate>
            <CompanyID>6000</CompanyID>
            <EndDateTime>2019-06-07T15:16:16.210+02:00</EndDateTime>
            <RetailTransaction>
               <BatchID>3000000001004</BatchID>
               <TotalGrossAmount currencyCode="EUR">55.00</TotalGrossAmount>
               <TotalNetAmount currencyCode="EUR">50.00</TotalNetAmount>
               <TotalTaxAmount currencyCode="EUR">5.00</TotalTaxAmount>
               <DistributionChannelCode>01</DistributionChannelCode>
               <SalesUnitID>6002</SalesUnitID>
               <BuyerBusinessPartnerInternalID>10000198</BuyerBusinessPartnerInternalID>
               <SiteID>6001</SiteID>
               <RetailTransactionSalesItem>
                  <ExternalID>TP-BLACK</ExternalID>
                  <TypeCode>1</TypeCode>
                  <GrossAmount currencyCode="EUR">55.00</GrossAmount>
                  <NetAmount currencyCode="EUR">50.00</NetAmount>
                  <TaxAmount currencyCode="EUR">5.00</TaxAmount>
                  <Quantity unitCode="EA">4.00</Quantity>
                  <QuantityTypeCode>EA</QuantityTypeCode>
                  <TaxCountryCode>ES</TaxCountryCode>
                  <TaxationCharacteristicsCode listID="ES">316</TaxationCharacteristicsCode>
                  <TaxItemGroupID>1</TaxItemGroupID>
                  <CashDiscountDeductibleIndicator>false</CashDiscountDeductibleIndicator>
                  <InventoryLocation>
                     <LogisticsAreaID>6002</LogisticsAreaID>
                  </InventoryLocation>
                  <InventoryItemChange>
                     <MaterialInternalID>TP-BLACK</MaterialInternalID>
                  </InventoryItemChange>
               </RetailTransactionSalesItem>
               <RetailTransactionProductTaxItem>
                  <ExternalID>1</ExternalID>
                  <TaxCountryCode>ES</TaxCountryCode>
                  <ProductTaxationCharacteristicsCode listID="ES">316</ProductTaxationCharacteristicsCode>
                  <TaxRegionCode listID="ES">08</TaxRegionCode>
                  <GroupID>1</GroupID>
                  <DeferredIndicator>false</DeferredIndicator>
                  <BusinessTransactionCurrencyAmount currencyCode="EUR">5.00</BusinessTransactionCurrencyAmount>
               </RetailTransactionProductTaxItem>
               <RetailTransactionCashItem>
                  <ExternalID>1</ExternalID>
                  <CashPayment>
                     <CashStorageID>CASHDESKES</CashStorageID>
                     <CashStorageCurrencyAmount currencyCode="EUR">55.00</CashStorageCurrencyAmount>
                  </CashPayment>
                  <ExternalPayment/>
                  <BusinessTransactionCurrencyAmount currencyCode="EUR">55.00</BusinessTransactionCurrencyAmount>
               </RetailTransactionCashItem>
            </RetailTransaction>
         </PointOfSaleTransactionBundleNotification>
      </glob:PointOfSaleTransactionBundleNotification>
   </soap:Body>
</soap:Envelope>

Keywords

POS; Point of Sale; Tax Group; Tax Region; missing; error; Inconsistent; Simplified Tax Country; , KBA , AP-POS , Point-of-Sale Transaction Processing , Problem

Product

SAP Business ByDesign 1905 ; SAP Business ByDesign 1908 ; SAP Business ByDesign 1911