Orders and Deliveries

Submitted by Guest on Fri, 25/01/2013 - 13:47

General User's Discussion

So wierdly after months of setup issues I discovered our inbox was finally working with our supplier ie we were recieving delivery notices.

My question

When I recieve a delivery say for lets say 9 products

5 of them are linked to products on our system

1 is a flyer that our supplier has sent listed with a 0 cost line item

1 is frieght

1 is a in hospital use item I never charge out

1 is a new product

The new product I currently have to go into the product workspace and create and new product then go to deliveries and link it.

IF I try and finalize and some items are not linked I get

	 Failed to validate property Product: Product is required

the In hospital use item I need to go and create an item for as well I guess

what do I do with the flyer and freight (which has a charge)

And why when I finalize the delivery does it ask me if I want to "INVOICE the supplier"

Cheers all

Thanks

Re: Orders and Deliveries

Submitted by Cath Colton (not verified) on Mon, 04/02/2013 - 08:36.

Hi Ben

All items in a Delivery need to be linked to a product (via the supplier stock code). I would add freight as a product as you will have this on each delivery and this also allows you to see the invoice total on your paper invoice matches your delivery invoice.

Regarding the Invoice Supplier option, just cancel. Im not 100% sure but I think this was set up originally so you could pay your supplier for that delivery but dont know any practices who do this.

Cath

Re: Orders and Deliveries

Submitted by Cath Colton (not verified) on Mon, 04/02/2013 - 08:37.

Sorry forgot this bit, with items such as a flyer you can just edit the delivery and delete this line.

Cath

Re: Orders and Deliveries

Submitted by bencharlton (not verified) on Tue, 12/02/2013 - 10:24.

How annyoying is it when the supplier doesnt use a reorder code for things like FRIEGHT...hence u need to edit the order EVERY time to product match it...!!!

Other than that

THANKS CATH!

Re: Orders and Deliveries

Submitted by tanderson on Fri, 15/02/2013 - 16:24.

The freight issue is actually a limitation of OpenVPMS, not ESCI. OpenVPMS doesn't support charges that aren't product related, so they need to be mapped to dummy products.

There is a JIRA to enhance this: https://openvpms.atlassian.net/browse/OVPMS-1252

This would allow both discounts and freight to be supported.

-Tim

Re: Orders and Deliveries

Submitted by bencharlton (not verified) on Fri, 15/02/2013 - 17:22.

This Esci stuff is seriously like the bugbear of my year...so after having setup issues...our system magically started just working...the deliveries downloaded and we could use the internal ordering section.

Then 3 days ago...it just stopped again

 15 Feb 2013 15:32:24,293 ERROR ErrorHelper,http-bio-8080-exec-10:129 - ESCIA-0005: Failed to connect to web service https://vethub.provet.com.au/openvpms/registryservice.svc?wsdl for supplier Provet Qld (5725)

15 Feb 2013 15:34:22,447 ERROR ErrorHelper,http-bio-8080-exec-9:129 - ESCIA-0004: Failed to connect to web service https://vethub.provet.com.au/openvpms/registryservice.svc?wsdl

15 Feb 2013 15:34:27,212 ERROR ErrorHelper,http-bio-8080-exec-9:129 - ESCIA-0004: Failed to connect to web service http://vethub.provet.com.au/openvpms/registryservice.svc?wsdl

15 Feb 2013 15:34:33,603 ERROR ErrorHelper,http-bio-8080-exec-9:129 - ESCIA-0004: Failed to connect to web service https://vethub.provet.com.au/openvpms/registryservice.svc?wsdl

15 Feb 2013 15:34:41,477 ERROR ErrorHelper,http-bio-8080-exec-8:129 - ESCIA-0004: Failed to connect to web service http://vethub.provet.com.au/openvpms/registryservice.svc?wsdl

15 Feb 2013 15:34:45,540 ERROR ErrorHelper,http-bio-8080-exec-8:129 - ESCIA-0004: Failed to connect to web service https://vethub.provet.com.au/openvpms/registryservice.svc?wsdl

However the ESCI testing tools connect to the inbox fine with the password etc, does anyone know how to enable

httptransport dump in openvpms...

I tried adding -Dcom.sun.xml.ws.transport.http.client.HttpTransportPipe.dump=true to my tomcat startup options but dont seem to get any output

my inbox request is producing so I know there are invoices(deliveries) awaiting download its just that the OPENVPMS jvm isnt able to access them...I need to see the transpor pipe to undestand the failure point.

 ---[HTTP request - https://vethub.provet.com.au/openvpms/RegistryService.svc]---

Content-type: text/xml;charset="utf-8"

Soapaction: "http://openvpms.org/esci/RegistryService/getInboxServiceRequest"

Accept: text/xml, multipart/related, text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2

<?xml version='1.0' encoding='UTF-8'?><S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/"><S:Body><ns2:getIn

boxService xmlns:ns2="http://openvpms.org/esci"/></S:Body></S:Envelope>--------------------

---[HTTP response - https://vethub.provet.com.au/openvpms/RegistryService.svc - 200]---

null: HTTP/1.1 200 OK

Content-type: text/xml; charset=utf-8

Content-length: 309

X-powered-by: ASP.NET

Server: Microsoft-IIS/7.0

X-frame-options: SAMEORIGIN

Date: Fri, 15 Feb 2013 06:26:09 GMT

<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/"><s:Body><getInboxServiceResponse xmlns="http://openvpms.

org/esci" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"><url xmlns="">https://vethub.provet.com.au/OpenVpms/inboxs

ervice.svc?wsdl</url></getInboxServiceResponse></s:Body></s:Envelope>--------------------

---[HTTP request - https://vethub.provet.com.au/openvpms/InboxService.svc]---

Content-type: text/xml;charset="utf-8"

Soapaction: "http://openvpms.org/esci/InboxService/getDocumentsRequest"

Accept: text/xml, multipart/related, text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2

<?xml version='1.0' encoding='UTF-8'?><S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/"><S:Body><ns8:getDo

cuments xmlns:ns2="urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComponents-2" xmlns:ns3="urn:oasis:names:spec

ification:ubl:schema:xsd:CommonExtensionComponents-2" xmlns:ns4="urn:oasis:names:specification:ubl:schema:xsd:CommonAggr

egateComponents-2" xmlns:ns5="urn:oasis:names:specification:ubl:schema:xsd:Order-2" xmlns:ns6="urn:oasis:names:specifica

tion:ubl:schema:xsd:Invoice-2" xmlns:ns7="urn:oasis:names:specification:ubl:schema:xsd:OrderResponseSimple-2" xmlns:ns8=

"http://openvpms.org/esci"/></S:Body></S:Envelope>--------------------

---[HTTP response - https://vethub.provet.com.au/openvpms/InboxService.svc - 200]---

null: HTTP/1.1 200 OK

Content-type: text/xml; charset=utf-8

Content-length: 1143

X-powered-by: ASP.NET

Server: Microsoft-IIS/7.0

X-frame-options: SAMEORIGIN

Date: Fri, 15 Feb 2013 06:26:17 GMT

<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/"><s:Body xmlns:xsi="http://www.w3.org/2001/XMLSchema-inst

ance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><getDocumentsResponse xmlns="http://openvpms.org/esci"><DocumentRefer

ence xmlns="urn:oasis:names:specification:ubl:schema:xsd:CommonAggregateComponents-2"><ID xmlns="urn:oasis:names:specifi

cation:ubl:schema:xsd:CommonBasicComponents-2">1167936</ID><IssueDate xmlns="urn:oasis:names:specification:ubl:schema:xs

d:CommonBasicComponents-2">2013-02-15</IssueDate><DocumentType xmlns="urn:oasis:names:specification:ubl:schema:xsd:Commo

nBasicComponents-2">Invoice</DocumentType></DocumentReference><DocumentReference xmlns="urn:oasis:names:specification:ub

l:schema:xsd:CommonAggregateComponents-2"><ID xmlns="urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComponents-

2">1167924</ID><IssueDate xmlns="urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComponents-2">2013-02-15</Issue

Date><DocumentType xmlns="urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComponents-2">Invoice</DocumentType></

DocumentReference></getDocumentsResponse></s:Body></s:Envelope>--------------------

Available documents: 2


<ns3:DocumentReference xmlns="urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComponents-2" xmlns:ns2="urn:oasis

:names:specification:ubl:schema:xsd:CommonExtensionComponents-2" xmlns:ns3="urn:oasis:names:specification:ubl:schema:xsd

:CommonAggregateComponents-2" xmlns:ns4="urn:oasis:names:specification:ubl:schema:xsd:Order-2" xmlns:ns5="urn:oasis:name

s:specification:ubl:schema:xsd:Invoice-2" xmlns:ns6="urn:oasis:names:specification:ubl:schema:xsd:OrderResponseSimple-2"

>

    <ID>1167936</ID>

    <IssueDate>2013-02-15</IssueDate>

    <DocumentType>Invoice</DocumentType>

</ns3:DocumentReference>


<ns3:DocumentReference xmlns="urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComponents-2" xmlns:ns2="urn:oasis

:names:specification:ubl:schema:xsd:CommonExtensionComponents-2" xmlns:ns3="urn:oasis:names:specification:ubl:schema:xsd

:CommonAggregateComponents-2" xmlns:ns4="urn:oasis:names:specification:ubl:schema:xsd:Order-2" xmlns:ns5="urn:oasis:name

s:specification:ubl:schema:xsd:Invoice-2" xmlns:ns6="urn:oasis:names:specification:ubl:schema:xsd:OrderResponseSimple-2"

>

    <ID>1167924</ID>

    <IssueDate>2013-02-15</IssueDate>

    <DocumentType>Invoice</DocumentType>

</ns3:DocumentReference>

Re: Orders and Deliveries

Submitted by tanderson on Sat, 16/02/2013 - 00:11.

Are you hosting two instances of OpenVPMS within the one Tomcat server - perhaps a test and production instance?

If so, and both are configured for ESCI, then you can get a conflict between which instance is called to submit passwords to ESCI.

This is because all HTTP authentication in Java is handled through a single point; whichever app registers its authentication handler last is responsible for submitting passwords to the server requiring credentials.

If the last to register app doesn't know how to submit the right credentials, then access will be rejected.

(Its a bizarre limitation, and a PITA).

How are you specifying -Dcom.sun.xml.ws.transport.http.client.HttpTransportPipe.dump=true ?

You should be able to do:

 set JAVA_OPTS=-Dcom.sun.xml.ws.transport.http.client.HttpTransportPipe.dump=true

catalina.bat run

-Tim

Re: Orders and Deliveries

Submitted by bencharlton (not verified) on Sat, 16/02/2013 - 09:46.

Well bugger me....that is a royal PITA

I was using the production server to host a training server.....I have just undeployed it. Mind you it wasnt configured to have ESCI...
but the problems did start concurrently with its deployment. (and I deployed it by copying my existing

webapp and then renaming as per the guide.) I specified a different mysql database though, that didnt have ESCI...

As far as specifying httptransport dump (win32) starting as a service. so I had added it to the startup options under the tomcat7w monitor.

So they ended up looking like:

 -Dcatalina.home=C:\Program Files\Apache Software Foundation\Tomcat 7.0
-Dcatalina.base=C:\Program Files\Apache Software Foundation\Tomcat 7.0
-Djava.endorsed.dirs=C:\Program Files\Apache Software Foundation\Tomcat 7.0\endorsed
-Djava.io.tmpdir=C:\Program Files\Apache Software Foundation\Tomcat 7.0\temp
-Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
-Djava.util.logging.config.file=C:\Program Files\Apache Software Foundation\Tomcat 7.0\conf\logging.properties
-Dcom.sun.xml.ws.transport.http.client.HttpTransportPipe.dump=true
-XX:PermSize=128m
-Xincgc

I thought the set command could only be used in scripts...I'll investigate further.

Thanks again TimA

Re: Orders and Deliveries

Submitted by bencharlton (not verified) on Sat, 16/02/2013 - 10:52.

Removed the training deployment...and restarted tomcat --- no dice still errors inside the application

Restarted the PC -- no dice still errors inside the application..

Still not getting a transport dump...working on that

Re: Orders and Deliveries

Submitted by tanderson on Sat, 16/02/2013 - 11:37.

According to this post, the property could be either:

-Dcom.sun.xml.internal.ws.transport.http.client.HttpTransportPipe.dump=true

 -Dcom.sun.xml.ws.transport.http.client.HttpTransportPipe.dump=true

Any output will go to the console (and captured by the catalina logs rather than the openvpms logs).

Re: Orders and Deliveries

Submitted by bencharlton (not verified) on Thu, 21/02/2013 - 16:52.

I swear some sort of connection caching is occuring...2 days after a reboot and it all started working with no further tweaking...its like a naughty dog you just reprimanded...eventually it pops its head out of the kennel and starts to play nice!!....

Re: Orders and Deliveries

Submitted by tanderson on Sun, 24/02/2013 - 15:41.

Ben, were there any stack traces in openvpms-full.log for the ESCIA-0004 and ESCIA-0005 error messages?

Orders and Deliveries

Comment viewing options