Home › Forums › implementation › Implementation discussion ›

esci

Submitted by Matt Young on Wed, 06/05/2015 - 22:39
in

I'm trying to setup ESCI with Lyppard and have successfully connected. When I check the inbox I get the following error message:

The following errors were encountered checking Inboxes:

ESCIA-0700: Failed to process Invoice 0001944081 for supplier Lyppard Australia Ltd. (1508) and stock location On The Shelf (56): ESCIA-0100: Required element: Invoice/OrderReference missing in Invoice: 0001944081

This was a phone order so there was no order matching in OpenVPMS. Should the Invoice/OrderReference be required here? 

Matt Y.

‹ Jaspersoft Studio setup Statements and hidden transactions ›

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Re: esci

Submitted by tanderson on Thu, 07/05/2015 - 09:33.

If the invoice doesn't reference an existing order submitted via OpenVPMS, there must be no OrderReference. If there is an OrderReference, the nested ID element must be present.

I'd say you've received an Invoice with an OrderReference but no ID, which is incorrect as per section 7.3 of the ESCI specification.

For the non-existing order, you should get an invoice like:

<Invoice>
    <UBLVersionID>2.0</UBLVersionID>
    <ID>1</ID>
    <IssueDate>2011-02-19</IssueDate>
    <AccountingSupplierParty>
    ...

If an order exists, it should look like:

<Invoice>
    <UBLVersionID>2.0</UBLVersionID>
    <ID>1<.ID>
    <IssueDate>2011-02-19</IssueDate>
    <OrderReference>
        <ID>277</ID>
    <OrderReference>
    <AccountingSupplierParty>

(namespaces removed for brevity)

 

You've probably received this:

<Invoice>
    <UBLVersionID>2.0<UBLVersionID>
    <ID>1<ID>
    <IssueDate>2011-02-19</IssueDate>
    <OrderReference>
        <ID></ID>
    <OrderReference>
    <AccountingSupplierParty>

in which case your supplier will need to fix the invoice.

Re: esci

Submitted by Ben_Charlton on Thu, 07/05/2015 - 09:49.

Matt you can use the ESCI tools to retrieve the faulty invoice and post its actual content here to confirm if you wish

The esci tools are available as part of the ESCI download here

The pdf outlining the format for the invoices and orders is here

There is a inbox.bat which can be used to download without acknowledging the invoice...thise means its still in the inbox...and will still cause the error you can then review it ..check it 

Out of interest is this a new ESCI setup OR an existing setup that just started causing issues and which version of OpenVPMS are you running.

Regards
 
Ben 
OpenVPMS Installer and Helper 
Ph: +61423044823 
Email: info[at]charltonit.com[dot]au

Re: esci

Submitted by Matt Young on Thu, 07/05/2015 - 22:54.

Thanks Tim and Ben,

I will use the tool to check the invoice and then report to Lyppard. It will take me a bit to setup the environment to be able to do so as I don't use windows so can't run bat files. I do have 1 windows laptop at work that I can use to do it though. 

This is a new ESCI setup using OpenVPMS Version: 1.8-beta-2-SNAPSHOT (6525).

Thanks,

Matt.

Re: esci

Submitted by Matt Young on Fri, 08/05/2015 - 16:23.

you were correct Tim:

<ns6:Invoice xmlns="urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComp
onents-2" xmlns:ns2="urn:oasis:names:specification:ubl:schema:xsd:CommonExtensio
nComponents-2" xmlns:ns3="urn:oasis:names:specification:ubl:schema:xsd:CommonAgg
regateComponents-2" xmlns:ns4="urn:oasis:names:specification:ubl:schema:xsd:Orde
rResponseSimple-2" xmlns:ns5="urn:oasis:names:specification:ubl:schema:xsd:Order
-2" xmlns:ns6="urn:oasis:names:specification:ubl:schema:xsd:Invoice-2">
    <UBLVersionID>2.0</UBLVersionID>
    <ID>0001944081</ID>
    <IssueDate>2015-05-06</IssueDate>
    <Note>Invoice</Note>
    <ns3:OrderReference>
        <ID></ID>
    </ns3:OrderReference>
    <ns3:AccountingSupplierParty>
        <AdditionalAccountID>xxxxx</AdditionalAccountID>
    </ns3:AccountingSupplierParty>
    <ns3:AccountingCustomerParty>
        <SupplierAssignedAccountID>xxxxx</SupplierAssignedAccountID>
    </ns3:AccountingCustomerParty>
    <ns3:AllowanceCharge>
        <ChargeIndicator>true</ChargeIndicator>
        <AllowanceChargeReason>Freight</AllowanceChargeReason>
        <Amount currencyID="AUD">10.00</Amount>
        <ns3:TaxCategory>
            <ID>S</ID>
            <Percent>10.00</Percent>
            <ns3:TaxScheme>
                <TaxTypeCode>GST</TaxTypeCode>
            </ns3:TaxScheme>
        </ns3:TaxCategory>
        <ns3:TaxTotal>
            <TaxAmount currencyID="AUD">1</TaxAmount>
        </ns3:TaxTotal>
    </ns3:AllowanceCharge>
    <ns3:TaxTotal>
        <TaxAmount currencyID="AUD">8.23</TaxAmount>
    </ns3:TaxTotal>
    <ns3:LegalMonetaryTotal>
        <LineExtensionAmount currencyID="AUD">72.34</LineExtensionAmount>
        <TaxExclusiveAmount currencyID="AUD">82.34</TaxExclusiveAmount>
        <ChargeTotalAmount currencyID="AUD">10.00</ChargeTotalAmount>
        <PayableAmount currencyID="AUD">90.57</PayableAmount>
    </ns3:LegalMonetaryTotal>
    <ns3:InvoiceLine>
        <ID>DISF101</ID>
        <InvoicedQuantity unitCode="EA">1</InvoicedQuantity>
        <LineExtensionAmount currencyID="AUD">72.34</LineExtensionAmount>
        <ns3:PricingReference>
            <ns3:AlternativeConditionPrice>
                <PriceAmount currencyID="AUD">82.20</PriceAmount>
                <PriceTypeCode>WH</PriceTypeCode>
            </ns3:AlternativeConditionPrice>
        </ns3:PricingReference>
        <ns3:TaxTotal>
            <TaxAmount currencyID="AUD">7.23</TaxAmount>
            <ns3:TaxSubtotal>
                <TaxAmount currencyID="AUD">7.23</TaxAmount>
                <ns3:TaxCategory>
                    <ID>S</ID>
                    <Percent>10.00</Percent>
                    <ns3:TaxScheme>
                        <TaxTypeCode>GST</TaxTypeCode>
                    </ns3:TaxScheme>
                </ns3:TaxCategory>
            </ns3:TaxSubtotal>
        </ns3:TaxTotal>
        <ns3:Item>
            <Name>F10 SC DISINFECTANT 1LT</Name>
            <ns3:SellersItemIdentification>
                <ID>DISF101</ID>
            </ns3:SellersItemIdentification>
        </ns3:Item>
        <ns3:Price>
            <PriceAmount currencyID="AUD">72.34</PriceAmount>
        </ns3:Price>
    </ns3:InvoiceLine>
</ns6:Invoice>
Syndicate content