Q1283034- Error: Tax Details Are Missing for the GL Account Xxxxxx (Account Type Tax Account)

Q1283034- Error: Tax details are missing for the GL account xxxxxx (account type Tax Account)

QAD EAM-006

Summary

We have this error message in QXtend Outbound when processing a tax GL Transaction coming from purchase order receipt in QAD EAM and sent to QAD ERP.

We setup taxes in QAD EAM in coherence with the QAD ERP tax setup.

The tax is correctly managed and GL transactions properly generated in QAD EAM.

But the posting of tax GL transactions to QAD ERP generates an error.

Setup

Ship To No / Taxable? / Tax Code / Tax Class / Tax Usage
PGK2 / VRAI / FR / 2

Duplication steps

Purchase order receipt

Reference / GL Date / Description / Dept / Cost Center / Acct No / SubAcct No / GL Amount / In ERP? / PO No / Date Stamp / Part No / Vendor Name
MI170307000201 / 07/03/2017 / TAX-PO-10029-REQ-41 / 1091 / 205000 / -22 / FAUX / 10029 / 170307000201 / AC-TEST1
MI170307000201 / 07/03/2017 / TAX-PO-10029-REQ-41 / 211900 / 22 / FAUX / 10029 / 170307000201 / AC-TEST1
MI170307000200 / 07/03/2017 / RECV-PO-10029-REQ-41 / 1091 / 205000 / -110 / VRAI / 10029 / 170307000200 / AC-TEST1 / SAMATEC
MI170307000200 / 07/03/2017 / RECV-PO-10029-REQ-41 / 1091 / 621000 / ZZ / 110 / VRAI / 10029 / 170307000200 / AC-TEST1 / SAMATEC

Only the MI170307000200 transaction is correctly interfaced in QAD ERP.

The tax transaction MI170307000201 transaction generates the following error in QXtend:

“Tax details are missing for the GL account 211900 (account type Tax Account)”

Request details:

<?xml version="1.0" ?>

-qdoc:BJournalEntryxmlns:qdoc="urn:schemas-qad-com:xml-services"xmlns:xsi="">

-qdoc:tContextInfo

qdoc:tcAction/>

qdoc:tcActivityCodeCreate</qdoc:tcActivityCode

qdoc:tcCBFVersion/>

qdoc:tcComment/>

qdoc:tcCompanyCode/>

qdoc:tcComponentVersion/>

qdoc:tcCorrelationId/>

qdoc:tcInvolvedCompanyCodes/>

qdoc:tcObjectIdentifier/>

qdoc:tcOriginator/>

qdoc:tiPriority0</qdoc:tiPriority

qdoc:tiRequestStartTime0</qdoc:tiRequestStartTime

qdoc:ttRequestStartDatexsi:nil="true" />

</qdoc:tContextInfo

-qdoc:tPosting

qdoc:CustomCombo0/>

qdoc:CustomCombo1/>

qdoc:CustomCombo2/>

qdoc:CustomCombo3/>

qdoc:CustomCombo4/>

qdoc:CustomCombo5/>

qdoc:CustomCombo6/>

qdoc:CustomCombo7/>

qdoc:CustomCombo8/>

qdoc:CustomCombo9/>

qdoc:CustomDate0xsi:nil="true" />

qdoc:CustomDate1xsi:nil="true" />

qdoc:CustomDate2xsi:nil="true" />

qdoc:CustomDate3xsi:nil="true" />

qdoc:CustomDate4xsi:nil="true" />

qdoc:CustomDecimal00.0</qdoc:CustomDecimal0

qdoc:CustomDecimal10.0</qdoc:CustomDecimal1

qdoc:CustomDecimal20.0</qdoc:CustomDecimal2

qdoc:CustomDecimal30.0</qdoc:CustomDecimal3

qdoc:CustomDecimal40.0</qdoc:CustomDecimal4

qdoc:CustomInteger00</qdoc:CustomInteger0

qdoc:CustomInteger10</qdoc:CustomInteger1

qdoc:CustomInteger20</qdoc:CustomInteger2

qdoc:CustomInteger30</qdoc:CustomInteger3

qdoc:CustomInteger40</qdoc:CustomInteger4

qdoc:CustomLong0/>

qdoc:CustomLong1/>

qdoc:CustomNote/>

qdoc:CustomShort0/>

qdoc:CustomShort1/>

qdoc:CustomShort2/>

qdoc:CustomShort3/>

qdoc:CustomShort4/>

qdoc:CustomShort5/>

qdoc:CustomShort6/>

qdoc:CustomShort7/>

qdoc:CustomShort8/>

qdoc:CustomShort9/>

qdoc:LastModifiedDatexsi:nil="true" />

qdoc:LastModifiedTime0</qdoc:LastModifiedTime

qdoc:LastModifiedUser/>

qdoc:PostingAddGLNbr0</qdoc:PostingAddGLNbr

qdoc:PostingApproveComments/>

qdoc:PostingApprovedDatexsi:nil="true" />

qdoc:PostingApprovedTime0</qdoc:PostingApprovedTime

qdoc:PostingApproveStatus/>

qdoc:PostingAutoReversalDatexsi:nil="true" />

qdoc:PostingAutoReversalType/>

qdoc:PostingBusinessRelationTxt/>

qdoc:PostingDate2017-03-07</qdoc:PostingDate

qdoc:PostingInvoiceReferenceTxt/>

qdoc:PostingIsAutoReversalfalse</qdoc:PostingIsAutoReversal

qdoc:PostingIsCorrectionfalse</qdoc:PostingIsCorrection

qdoc:PostingIsReplacementfalse</qdoc:PostingIsReplacement

qdoc:PostingIsReversingfalse</qdoc:PostingIsReversing

qdoc:PostingIsReversingBySignfalse</qdoc:PostingIsReversingBySign

qdoc:PostingIsSkipAutoAssignLCfalse</qdoc:PostingIsSkipAutoAssignLC

qdoc:PostingIsZeroValueAllowedfalse</qdoc:PostingIsZeroValueAllowed

qdoc:PostingMirrorRef/>

qdoc:PostingOriginAddressCode/>

qdoc:PostingOriginatorReference/>

qdoc:PostingOriginDaybookCode/>

qdoc:PostingOriginDaybookNumber1CDG01</qdoc:PostingOriginDaybookNumber

qdoc:PostingOriginDocumentMI</qdoc:PostingOriginDocument

qdoc:PostingOriginDocumentTypeMI</qdoc:PostingOriginDocumentType

qdoc:PostingOriginIsExternaltrue</qdoc:PostingOriginIsExternal

qdoc:PostingOriginReferenceMI170307000201</qdoc:PostingOriginReference

qdoc:PostingOriginTransTypeMI</qdoc:PostingOriginTransType

qdoc:PostingParentText/>

qdoc:PostingPeriod3</qdoc:PostingPeriod

qdoc:PostingSystemDate2017-03-07</qdoc:PostingSystemDate

qdoc:PostingTextTAX-PO-10029-REQ-41</qdoc:PostingText

qdoc:PostingValueDatexsi:nil="true" />

qdoc:PostingVerifiedDatexsi:nil="true" />

qdoc:PostingVerifiedTime0</qdoc:PostingVerifiedTime

qdoc:PostingVerifyComments/>

qdoc:PostingVerifyStatus/>

qdoc:PostingVoucher0</qdoc:PostingVoucher

qdoc:PostingYear2017</qdoc:PostingYear

qdoc:PostingYearPeriod0</qdoc:PostingYearPeriod

qdoc:tc_ParentRowid/>

qdoc:tc_RowidMI170307000201</qdoc:tc_Rowid

qdoc:tc_StatusN</qdoc:tc_Status

qdoc:tcJournalCode1CDG01</qdoc:tcJournalCode

qdoc:tcJournalTypeCode/>

qdoc:tcLayerTypeCode/>

qdoc:tcLocalCurrency/>

qdoc:tcReportingJournalCode1CDG01</qdoc:tcReportingJournalCode

qdoc:tcTemplateCode/>

qdoc:tcUsrLogin/>

qdoc:tiLayer_ID0</qdoc:tiLayer_ID

qdoc:tiOriginPostingId0</qdoc:tiOriginPostingId

qdoc:tiOriginVoucher0</qdoc:tiOriginVoucher

qdoc:tiSharedCompanyId0</qdoc:tiSharedCompanyId

qdoc:tiYearForNbr0</qdoc:tiYearForNbr

qdoc:tlIsAddGLNbrfalse</qdoc:tlIsAddGLNbr

qdoc:tlSaveAsTemplatefalse</qdoc:tlSaveAsTemplate

-qdoc:tPostingLine

qdoc:CustomCombo0/>

qdoc:CustomCombo1/>

qdoc:CustomCombo2/>

qdoc:CustomCombo3/>

qdoc:CustomCombo4/>

qdoc:CustomCombo5/>

qdoc:CustomCombo6/>

qdoc:CustomCombo7/>

qdoc:CustomCombo8/>

qdoc:CustomCombo9/>

qdoc:CustomDate0xsi:nil="true" />

qdoc:CustomDate1xsi:nil="true" />

qdoc:CustomDate2xsi:nil="true" />

qdoc:CustomDate3xsi:nil="true" />

qdoc:CustomDate4xsi:nil="true" />

qdoc:CustomDecimal00.0</qdoc:CustomDecimal0

qdoc:CustomDecimal10.0</qdoc:CustomDecimal1

qdoc:CustomDecimal20.0</qdoc:CustomDecimal2

qdoc:CustomDecimal30.0</qdoc:CustomDecimal3

qdoc:CustomDecimal40.0</qdoc:CustomDecimal4

qdoc:CustomInteger00</qdoc:CustomInteger0

qdoc:CustomInteger10</qdoc:CustomInteger1

qdoc:CustomInteger20</qdoc:CustomInteger2

qdoc:CustomInteger30</qdoc:CustomInteger3

qdoc:CustomInteger40</qdoc:CustomInteger4

qdoc:CustomLong0/>

qdoc:CustomLong1/>

qdoc:CustomNote/>

qdoc:CustomShort0/>

qdoc:CustomShort1/>

qdoc:CustomShort2/>

qdoc:CustomShort3/>

qdoc:CustomShort4/>

qdoc:CustomShort5/>

qdoc:CustomShort6/>

qdoc:CustomShort7/>

qdoc:CustomShort8/>

qdoc:CustomShort9/>

qdoc:LastModifiedDatexsi:nil="true" />

qdoc:LastModifiedTime0</qdoc:LastModifiedTime

qdoc:LastModifiedUser/>

qdoc:PostingLineCostCentreText/>

qdoc:PostingLineCreditCC0.0</qdoc:PostingLineCreditCC

qdoc:PostingLineCreditLC0.0</qdoc:PostingLineCreditLC

qdoc:PostingLineCreditPC0.0</qdoc:PostingLineCreditPC

qdoc:PostingLineCreditTC0.0</qdoc:PostingLineCreditTC

qdoc:PostingLineCrossExternRef/>

qdoc:PostingLineDebitCC0.0</qdoc:PostingLineDebitCC

qdoc:PostingLineDebitLC0.0</qdoc:PostingLineDebitLC

qdoc:PostingLineDebitPC0.0</qdoc:PostingLineDebitPC

qdoc:PostingLineDebitTC22.0</qdoc:PostingLineDebitTC

qdoc:PostingLineExchangeRate1.0</qdoc:PostingLineExchangeRate

qdoc:PostingLineIsProjPostingfalse</qdoc:PostingLineIsProjPosting

qdoc:PostingLineMirrorRef/>

qdoc:PostingLineMirrorType/>

qdoc:PostingLineOriginLineNbr0</qdoc:PostingLineOriginLineNbr

qdoc:PostingLineProjectText/>

qdoc:PostingLineQTY0.0</qdoc:PostingLineQTY

qdoc:PostingLineRateScale1.0</qdoc:PostingLineRateScale

qdoc:PostingLineSafText/>

qdoc:PostingLineSequence1</qdoc:PostingLineSequence

qdoc:PostingLineTextTAX-PO-10029-REQ-41</qdoc:PostingLineText

qdoc:PostingYearPeriod0</qdoc:PostingYearPeriod

qdoc:tc_ParentRowidMI170307000201</qdoc:tc_ParentRowid

qdoc:tc_RowidMI170307000201-001</qdoc:tc_Rowid

qdoc:tc_StatusN</qdoc:tc_Status

qdoc:tcAllocationKey/>

qdoc:tcAllocationPostingLine/>

qdoc:tcAllocationType/>

qdoc:tcCostCentreCode/>

qdoc:tcCrossCompanyCode/>

qdoc:tcCrossCompanyCurrencyCode/>

qdoc:tcCrossCompanyGLCode/>

qdoc:tcCrossCompanyIntercoCode/>

qdoc:tcCurrencyCode/>

qdoc:tcDivisionCode/>

qdoc:tcGLCode211900</qdoc:tcGLCode

qdoc:tcGLDescription/>

qdoc:tcGLTypeCode/>

qdoc:tcIntercoBusinessRelationCode/>

qdoc:tcProjectCode/>

qdoc:tcProjectDescription/>

qdoc:tcUnitCode/>

qdoc:tiVatPostID0</qdoc:tiVatPostID

qdoc:tlGLIsAutomaticAccountfalse</qdoc:tlGLIsAutomaticAccount

qdoc:tlGLIsDebitAccountfalse</qdoc:tlGLIsDebitAccount

qdoc:tlPostingLineIsLocalCurrencyfalse</qdoc:tlPostingLineIsLocalCurrency

</qdoc:tPostingLine

-qdoc:tPostingLine

qdoc:CustomCombo0/>

qdoc:CustomCombo1/>

qdoc:CustomCombo2/>

qdoc:CustomCombo3/>

qdoc:CustomCombo4/>

qdoc:CustomCombo5/>

qdoc:CustomCombo6/>

qdoc:CustomCombo7/>

qdoc:CustomCombo8/>

qdoc:CustomCombo9/>

qdoc:CustomDate0xsi:nil="true" />

qdoc:CustomDate1xsi:nil="true" />

qdoc:CustomDate2xsi:nil="true" />

qdoc:CustomDate3xsi:nil="true" />

qdoc:CustomDate4xsi:nil="true" />

qdoc:CustomDecimal00.0</qdoc:CustomDecimal0

qdoc:CustomDecimal10.0</qdoc:CustomDecimal1

qdoc:CustomDecimal20.0</qdoc:CustomDecimal2

qdoc:CustomDecimal30.0</qdoc:CustomDecimal3

qdoc:CustomDecimal40.0</qdoc:CustomDecimal4

qdoc:CustomInteger00</qdoc:CustomInteger0

qdoc:CustomInteger10</qdoc:CustomInteger1

qdoc:CustomInteger20</qdoc:CustomInteger2

qdoc:CustomInteger30</qdoc:CustomInteger3

qdoc:CustomInteger40</qdoc:CustomInteger4

qdoc:CustomLong0/>

qdoc:CustomLong1/>

qdoc:CustomNote/>

qdoc:CustomShort0/>

qdoc:CustomShort1/>

qdoc:CustomShort2/>

qdoc:CustomShort3/>

qdoc:CustomShort4/>

qdoc:CustomShort5/>

qdoc:CustomShort6/>

qdoc:CustomShort7/>

qdoc:CustomShort8/>

qdoc:CustomShort9/>

qdoc:LastModifiedDatexsi:nil="true" />

qdoc:LastModifiedTime0</qdoc:LastModifiedTime

qdoc:LastModifiedUser/>

qdoc:PostingLineCostCentreText/>

qdoc:PostingLineCreditCC0.0</qdoc:PostingLineCreditCC

qdoc:PostingLineCreditLC0.0</qdoc:PostingLineCreditLC

qdoc:PostingLineCreditPC0.0</qdoc:PostingLineCreditPC

qdoc:PostingLineCreditTC22.0</qdoc:PostingLineCreditTC

qdoc:PostingLineCrossExternRef/>

qdoc:PostingLineDebitCC0.0</qdoc:PostingLineDebitCC

qdoc:PostingLineDebitLC0.0</qdoc:PostingLineDebitLC

qdoc:PostingLineDebitPC0.0</qdoc:PostingLineDebitPC

qdoc:PostingLineDebitTC0.0</qdoc:PostingLineDebitTC

qdoc:PostingLineExchangeRate1.0</qdoc:PostingLineExchangeRate

qdoc:PostingLineIsProjPostingfalse</qdoc:PostingLineIsProjPosting

qdoc:PostingLineMirrorRef/>

qdoc:PostingLineMirrorType/>

qdoc:PostingLineOriginLineNbr0</qdoc:PostingLineOriginLineNbr

qdoc:PostingLineProjectText/>

qdoc:PostingLineQTY0.0</qdoc:PostingLineQTY

qdoc:PostingLineRateScale1.0</qdoc:PostingLineRateScale

qdoc:PostingLineSafText/>

qdoc:PostingLineSequence2</qdoc:PostingLineSequence

qdoc:PostingLineTextTAX-PO-10029-REQ-41</qdoc:PostingLineText

qdoc:PostingYearPeriod0</qdoc:PostingYearPeriod

qdoc:tc_ParentRowidMI170307000201</qdoc:tc_ParentRowid

qdoc:tc_RowidMI170307000201-002</qdoc:tc_Rowid

qdoc:tc_StatusN</qdoc:tc_Status

qdoc:tcAllocationKey/>

qdoc:tcAllocationPostingLine/>

qdoc:tcAllocationType/>

qdoc:tcCostCentreCode1091</qdoc:tcCostCentreCode

qdoc:tcCrossCompanyCode/>

qdoc:tcCrossCompanyCurrencyCode/>

qdoc:tcCrossCompanyGLCode/>

qdoc:tcCrossCompanyIntercoCode/>

qdoc:tcCurrencyCode/>

qdoc:tcDivisionCode/>

qdoc:tcGLCode205000</qdoc:tcGLCode

qdoc:tcGLDescription/>

qdoc:tcGLTypeCode/>

qdoc:tcIntercoBusinessRelationCode/>

qdoc:tcProjectCode/>

qdoc:tcProjectDescription/>

qdoc:tcUnitCode/>

qdoc:tiVatPostID0</qdoc:tiVatPostID

qdoc:tlGLIsAutomaticAccountfalse</qdoc:tlGLIsAutomaticAccount

qdoc:tlGLIsDebitAccountfalse</qdoc:tlGLIsDebitAccount

qdoc:tlPostingLineIsLocalCurrencyfalse</qdoc:tlPostingLineIsLocalCurrency

</qdoc:tPostingLine

</qdoc:tPosting

</qdoc:BJournalEntry

Response details :

<?xml version="1.0" encoding="UTF-8" ?>

-soapenv:Envelopexmlns:soapenv="">

-soapenv:Header

wsa:Tosoapenv:actor=""soapenv:mustUnderstand="0" xmlns:wsa="</wsa:To

wsa:Actionsoapenv:actor=""soapenv:mustUnderstand="0"xmlns:wsa="" />

wsa:MessageIDsoapenv:actor=""soapenv:mustUnderstand="0" xmlns:wsa="</wsa:MessageID

wsa:RelatesTosoapenv:actor=""soapenv:mustUnderstand="0" xmlns:wsa=" 08:57:30.522+01:00:urn:services-qad-com:QADERPBestest</wsa:RelatesTo

</soapenv:Header

-soapenv:Body

-ns1:bjournalentryResponsexmlns="urn:schemas-qad-com:xml-services" xmlns:ns1="urn:schemas-qad-com:xml-services">

ns1:resulterror</ns1:result

-ns2:dsSessionContext xmlns:ns2="urn:schemas-qad-com:xml-services:common">

-ns2:ttContext

ns2:propertyQualifierQAD</ns2:propertyQualifier

ns2:propertyNameaction</ns2:propertyName

ns2:propertyValueSave</ns2:propertyValue

</ns2:ttContext

-ns2:ttContext

ns2:propertyQualifierQAD</ns2:propertyQualifier

ns2:propertyNameapiName</ns2:propertyName

ns2:propertyValuebjournalentry</ns2:propertyValue

</ns2:ttContext

-ns2:ttContext

ns2:propertyQualifierQAD</ns2:propertyQualifier

ns2:propertyNameBLFSessionId</ns2:propertyName

ns2:propertyValue96508863</ns2:propertyValue

</ns2:ttContext

-ns2:ttContext

ns2:propertyQualifierQAD</ns2:propertyQualifier

ns2:propertyNamebusinessEvent</ns2:propertyName

ns2:propertyValueGLOut</ns2:propertyValue

</ns2:ttContext

-ns2:ttContext

ns2:propertyQualifierQAD</ns2:propertyQualifier

ns2:propertyNamedomain</ns2:propertyName

ns2:propertyValueSDMOFR</ns2:propertyValue

</ns2:ttContext

-ns2:ttContext

ns2:propertyQualifierQAD</ns2:propertyQualifier

ns2:propertyNameentity</ns2:propertyName

ns2:propertyValueSDFR</ns2:propertyValue

</ns2:ttContext

-ns2:ttContext

ns2:propertyQualifierQAD</ns2:propertyQualifier

ns2:propertyNamemethodName</ns2:propertyName

ns2:propertyValue/>

</ns2:ttContext

-ns2:ttContext

ns2:propertyQualifierQAD</ns2:propertyQualifier

ns2:propertyNamemnemonicsRaw</ns2:propertyName

ns2:propertyValuetrue</ns2:propertyValue

</ns2:ttContext

-ns2:ttContext

ns2:propertyQualifierQAD</ns2:propertyQualifier

ns2:propertyNamepassword</ns2:propertyName

ns2:propertyValuecbnseul</ns2:propertyValue

</ns2:ttContext

-ns2:ttContext

ns2:propertyQualifierQAD</ns2:propertyQualifier

ns2:propertyNameprogramName</ns2:propertyName

ns2:propertyValueBJournalEntry</ns2:propertyValue

</ns2:ttContext

-ns2:ttContext

ns2:propertyQualifierQAD</ns2:propertyQualifier

ns2:propertyNamescopeTransaction</ns2:propertyName

ns2:propertyValuefalse</ns2:propertyValue

</ns2:ttContext

-ns2:ttContext

ns2:propertyQualifierQAD</ns2:propertyQualifier

ns2:propertyNameusername</ns2:propertyName

ns2:propertyValuemfg</ns2:propertyValue

</ns2:ttContext

-ns2:ttContext

ns2:propertyQualifierQAD</ns2:propertyQualifier

ns2:propertyNameversion</ns2:propertyName

ns2:propertyValueERP3_1</ns2:propertyValue

</ns2:ttContext

</ns2:dsSessionContext

-ns3:dsExceptions xmlns:ns3="urn:schemas-qad-com:xml-services:common">

-ns3:temp_err_msg

ns3:tt_level0</ns3:tt_level

ns3:tt_msg_context(bposting.ValidateComponentPostPostingLine1)</ns3:tt_msg_context

ns3:tt_msg_data211900</ns3:tt_msg_data

ns3:tt_msg_datetime2017-03-07T15:20:11+0100</ns3:tt_msg_datetime

ns3:tt_msg_descTax details are missing for the GL account 211900 (account type Tax Account). Internal message type (E) - severity(3)</ns3:tt_msg_desc

ns3:tt_msg_fieldGL Account (tPostingLine.tcGLCode)/ns3:tt_msg_field

ns3:tt_msg_index1</ns3:tt_msg_index

ns3:tt_msg_keys/>

ns3:tt_msg_keys/>

ns3:tt_msg_keys/>

ns3:tt_msg_keys/>

ns3:tt_msg_keys/>

ns3:tt_msg_keys/>

ns3:tt_msg_nbrQadFin-7362</ns3:tt_msg_nbr

ns3:tt_msg_processedfalse</ns3:tt_msg_processed

ns3:tt_msg_sev3</ns3:tt_msg_sev

</ns3:temp_err_msg

</ns3:dsExceptions

</ns1:bjournalentryResponse

</soapenv:Body

</soapenv:Envelope

GL Transaction created in QAD ERP:

GL Account / Daybook Code / OriginRef / Posting Description / Voucher / BC Debit / BC Credit / Sub-Account Code / Cost Center Code / Curr / Description / Batch Number / Origin Trans Type / Functionnal Area / Posting Date
621000 / 1CDG01 / MI170307000200 / RECV-PO-10029-REQ-41 / 000000043 / 110.00 / 0.00 / ZZ / 1091 / EUR / RECV-PO-10029-REQ-41 / MI / X / 07/03/2017
205000 / 1CDG01 / MI170307000200 / RECV-PO-10029-REQ-41 / 000000043 / 0.00 / 110.00 / 1091 / EUR / RECV-PO-10029-REQ-41 / MI / X / 07/03/2017