Message Boards

Anybody successfully loaded a Supplier Invoice into QAD2011EE using QXtend?

Edwin Espe, modified 3 Years ago.

Anybody successfully loaded a Supplier Invoice into QAD2011EE using QXtend?

Post Date: 11/7/16 (Bronze, 1 Post) Recent Posts

In our current QXtend version I don't see BCInvoice API so end up using BCInvoiceJournalEntry API. Does anybody able to load an Invoice using BCInvoiceJournalEntry? Because, I'm not able to and need some help. I have produced the BCInvoiceJournalEntry Qdoc(see below) with required elements and actually returned a "success" response, but I don't see any record created in QAD, am I missing something?

<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope xmlns="urn:schemas-qad-com:xml-services" xmlns:qcom="urn:schemas-qad-com:xml-services:common" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wsa="http://www.w3.org/2005/08/addressing">
    <soapenv:Header>
        <wsa:Action/>
        <wsa:To>urn:services-qad-com:dev</wsa:To>
        <wsa:MessageID>urn:services-qad-com::dev</wsa:MessageID>
        <wsa:ReferenceParameters>
            <qcom:suppressResponseDetail>true</qcom:suppressResponseDetail>
        </wsa:ReferenceParameters>
        <wsa:ReplyTo>
            <wsa:Address>urn:services-qad-com:</wsa:Address>
        </wsa:ReplyTo>
    </soapenv:Header>
    <soapenv:Body>
        <bcinvoicejournalentry>
            <qcom:dsSessionContext>
                <qcom:ttContext>
                    <qcom:propertyQualifier>QAD</qcom:propertyQualifier>
                    <qcom:propertyName>domain</qcom:propertyName>
                    <qcom:propertyValue>USD01</qcom:propertyValue>
                </qcom:ttContext>
                <qcom:ttContext>
                    <qcom:propertyQualifier>QAD</qcom:propertyQualifier>
                    <qcom:propertyName>scopeTransaction</qcom:propertyName>
                    <qcom:propertyValue>true</qcom:propertyValue>
                </qcom:ttContext>
                <qcom:ttContext>
                    <qcom:propertyQualifier>QAD</qcom:propertyQualifier>
                    <qcom:propertyName>version</qcom:propertyName>
                    <qcom:propertyValue>ERP3_1</qcom:propertyValue>
                </qcom:ttContext>
                <qcom:ttContext>
                    <qcom:propertyQualifier>QAD</qcom:propertyQualifier>
                    <qcom:propertyName>entity</qcom:propertyName>
                    <qcom:propertyValue>100</qcom:propertyValue>
                </qcom:ttContext>
            </qcom:dsSessionContext>
            <BCInvoiceJournalEntry>
                <tContextInfo>
                    <tcCompanyCode>100</tcCompanyCode>
                    <tcInvolvedCompanyCodes>100</tcInvolvedCompanyCodes>
                    <tcAction>Save</tcAction>
                    <tcActivityCode>Create</tcActivityCode>
                    <tlPartialUpdate>true</tlPartialUpdate>
                </tContextInfo>
            </BCInvoiceJournalEntry>
<tApiCInvoiceCIJE>
<CInvoiceReference>testinv22</CInvoiceReference>
<CInvoiceOriginalCreditTC>10.0000</CInvoiceOriginalCreditTC>
<tcCreditorCode>10020</tcCreditorCode>
<tcCurrencyCode>USD</tcCurrencyCode>
<tc_rowid>CI-1-SOAP</tc_rowid>
        <tcReasonCode>NPO-OK</tcReasonCode>
<tApiCInvoiceBankCIJE>
    <tc_parentrowid>CI-1-SOAP</tc_parentrowid>
    <tc_rowid>CIB-SOAP</tc_rowid>
<tcOwnBankNumber>4828785279</tcOwnBankNumber>
<tcBankNumber>NA</tcBankNumber>
</tApiCInvoiceBankCIJE>
  <tApiCInvoicePostingCIJE>
                  <urn1:CInvoicePostingType>INIT</urn1:CInvoicePostingType>
                  <urn1:tc_Rowid>CI-1-POST-INIT</urn1:tc_Rowid>
                  <urn1:tc_ParentRowid>CI-1-SOAP</urn1:tc_ParentRowid>
               </tApiCInvoicePostingCIJE>
  <tApiCInvoicePostingCIJE>
                  <urn1:CInvoicePostingType>ALLOC</urn1:CInvoicePostingType>
                  <urn1:tc_Rowid>CI-1-POST-ALLOC</urn1:tc_Rowid>
                  <urn1:tc_ParentRowid>CI-1-SOAP</urn1:tc_ParentRowid>
               </tApiCInvoicePostingCIJE>
</tApiCInvoiceCIJE>
<tApiPostingCIJE>
    <tc_Rowid>CI-1-POST-INIT</tc_Rowid>
<tApiPostingLineCIJE>
    <PostingLineSequence>1</PostingLineSequence>
    <tc_ParentRowid>CI-1-POST-INIT</tc_ParentRowid>
    <tc_Rowid>PLINE-CI-1-POST-INIT-1</tc_Rowid>
<PostingLineCreditTC>10.0000</PostingLineCreditTC>
</tApiPostingLineCIJE>
<tApiPostingLineCIJE>
    <tc_ParentRowid>CI-1-POST-INIT</tc_ParentRowid>
    <tc_Rowid>PLINE-CI-1-POST-INIT-2</tc_Rowid>
<PostingLineSequence>2</PostingLineSequence>
<PostingLineDebitTC>10.0000</PostingLineDebitTC>
<tcGLCode>200030</tcGLCode>
</tApiPostingLineCIJE>
</tApiPostingCIJE>
<tApiPostingCIJE>
    <tc_Rowid>CI-1-POST-ALLOC</tc_Rowid>
<tApiPostingLineCIJE>
    <tc_ParentRowid>CI-1-POST-ALLOC</tc_ParentRowid>
    <tc_Rowid>PLINE-CI-1-POST-ALLOC-1</tc_Rowid>
<PostingLineSequence>1</PostingLineSequence>
<PostingLineCreditTC>10.0000</PostingLineCreditTC>
<tcGLCode>200030</tcGLCode>
</tApiPostingLineCIJE>
<tApiPostingLineCIJE>
    <tc_ParentRowid>CI-1-POST-ALLOC</tc_ParentRowid>
    <tc_Rowid>PLINE-CI-1-POST-ALLOC-2</tc_Rowid>
<PostingLineSequence>2</PostingLineSequence>
<PostingLineDebitTC>10.0000</PostingLineDebitTC>
<tcGLCode>650070</tcGLCode>
<tcCostCentreCode>400</tcCostCentreCode>
<tcProjectCode/>
</tApiPostingLineCIJE>
</tApiPostingCIJE>
        </bcinvoicejournalentry>
    </soapenv:Body>
</soapenv:Envelope>

 

 

Message place holder