Order Generation and Order Delivery Status
I have noticed that our supplier or the system or whatever does not update orders to being delivered.
Effectively there is no relationship at all between orders and deliveries - our orders are not marked as delivered effectively they are marked as accepted and then turn up later that day.
Does order generation take into account accepted but pending orders and if so how to we work around this so that order generation works?
- Do we need to education suppliers or improve the ESCI interface so supplier can automatically mark an order as PART FULL etc
- Can we adjust the order generation to ignore these (not ideal because its an individual supplier thing)
Answers or more questions?
Re: Order Generation and Order Delivery Status
When an order is sent to the supplier, the supplier will respond with an accepted or rejected message sent to your ESCI Inbox.
When the message is received, the order status will be updated to Accepted or Rejected.
OpenVPMS will check for a response 30 seconds after submitting the order.
You can manually trigger a check by clicking the Check Inbox button.
In 1.7 you can also configure a regular poll of the inbox by configuring a "Job Configuration: ESCI Inbox Reader" job in Administration|Organisation.
Some time later, the supplier will invoice you. When this is received, OpenVPMS will create a Delivery, with In Progress status. When you Finalise this, it will go ahead and update the associated orders.
When you click Generate Orders, it takes into account:
-Tim
Re: Order Generation and Order Delivery Status
Tim
It seems that our ORDERS never get the status updated to PART or FULL. I know during manual delivery creation that you can link an ORDER however the ESCI obviously downloads these "deliveries" and creates them without linking an ORDER.....so they orders never get updated.
This must be configurable at the suppliers end or is it ours? If its the suppliers then we need to educate them
Ben
Re: Order Generation and Order Delivery Status
The invoice received from the supplier should include references to the original order lines. If you look in the database, each act.supplierOrderItem should have actRelationship.supplierDeliveryOrderItem relationships, indicating the corresponding deliveries.
Re: Order Generation and Order Delivery Status
In the mean time I think I need to to a manual SQL call to update all the existing orders to FULL
Re: Order Generation and Order Delivery Status
I'm not sure why you need to. The order generation takes existing order status into account so if there are orders in progress, additional orders for the same product won't be generated.
When you finalise your deliveries, then the corresponding order's delivery PART/FULL status should be updated.
Thats the theory at least. What's happening in practice?
Re: Order Generation and Order Delivery Status
No updates to the order delivery occur once the delivery arrives . The ORDER status NEVER updates to PART/FULL
there are no actRelationship.supplierDeliveryOrderItem in my database..
SELECT * FROM `openvpms`.act_relationships where arch_short_name = 'actRelationship.supplierDeliveryOrderItem'; produces 0 results
I am guessing our supplier hasnt implemented correctly.
Re: Order Generation and Order Delivery Status
There's also actRelationship.supplierDeliveryOrder, which links the delivery to the order.
If you are logging the ESCI SOAP calls, you should have a log of the invoice received from the supplier. If so, send it to me off list and I'll take a look.
Re: Order Generation and Order Delivery Status
Unfortunately ESCI events are not being logged.
I'll add
-Dcom.sun.xml.internal.ws.transport.http.client.HttpTransportPipe.dump=true
to the tomcat startup script and see what we get next week.
In the mean time how am I best to go about getting these orders marked as FULL so the automatic order picks up the items that need ordering.
Re: Order Generation and Order Delivery Status
actually will that even log https requests?
Re: Order Generation and Order Delivery Status
Should do, but also add:
-Dcom.sun.xml.ws.transport.http.client.HttpTransportPipe.dump=true
One of them should log.
Alternatively, grab the ESCI distribution. It has tools to view the contents of your inbox from the command line. Search the included doc/ESCI.pdf for instructions on the inbox.bat script. Note that the tools also provide the facility to acknowledge messages - only do this if there is a message in your inbox you want to remove rather than receive in OpenVPMS.
Re: Order Generation and Order Delivery Status
I think we are better off logging http -
its the "real" deliveries that are arriving from our supplier that is the issue ie not linked to a placed order. I want to see of those deliveries reference our orders at all....
Re: Order Generation and Order Delivery Status
The deliveries are generated from the UBL Invoice document placed in your inbox.
The advantage of using the tools is that you can inspect your inbox and retrieve the messages before they are processed by OpenVPMS.
Re: Order Generation and Order Delivery Status
You'll have to do it via SQL, athough without the link to the order its a bit hard to know which ones to update. Also the receivedQuantity and cancelledQuantity on the order items won't reflect reality.
Re: Order Generation and Order Delivery Status
I think I have worked out the issue upon reading the ESCI docs.
1. I have never recieved a 2nd message - I always get the ORDER ACCEPTED message but when I recieve the DELIVERY no 2nd Order Invoiced Message arrives
2. I think provet is sending all DELIVERIES AS
Re: Order Generation and Order Delivery Status
So this morning I logged the ESCI service for an order that was submitted to provet via the OPENVPMS order creation process...(not automatic but manual creation) Currently the autoorder is broken due to the problem with ORDERS not being marked as complete.
I issued the following commands to the supplier service.
inbox -l -r regservice.url - u user -p ourpass
reponse was
see document in dropbox - response,txtRe: Order Generation and Order Delivery Status
Should I contact Provet IT about this - or should this be something talked about Developer to Developer ie someone who developed and implemented the order system talks to someone at provet IT.
Re: Order Generation and Order Delivery Status
As you say, Provet hasn't provided any order information in the Invoice.
This means that OpenVPMS can't match the invoice items to the corresponding order items, so the order delivery status never gets updated.
Technically, this is allowed by section 6.5 of the ESCI specification, although it was intended for use only when there was no corresponding order submitted by OpenVPMS, e.g. for orders done over the phone.
Try contacting Provet IT, and see if its its a bug. If not, then we may need to implement an order matching feature to link deliveries to orders manually.
-Tim
Re: Order Generation and Order Delivery Status
I rang provet IT and started talking about the issue...the IT guy pulls me up and say...mate I only know about uploads and downloads and how to flick the switch that turns this stuff on for your account.
Awesome
He told me to draft an email that he can push up the chain to the developers. "Bill or someone?"
Re: Order Generation and Order Delivery Status
Copy of the email sent to provet IT
Here at Kalinga Park Vet Surgery, I help in debugging the latest beta versions of the OPENVPMS Practice management system. The latest version 1.7 is currently in beta and as part of that update the system will introduce automatic order generation as part of the management system. To do so the system must be able to track stock that has been ordered and compare it to the deliveries recorded, so as it can manage stock that has been ordered (backordered) and not yet delivered and avoid double ordering.
END COPY
Re: Order Generation and Order Delivery Status
developer just called me - he seems to think its an oversite - but it will affect OPENVPMS users nationwide.
He is discussing it with the IT team and will call me back with a timeframe and if it can be corrected
The aim is to implement the orderlinereference style delivery invoice...I hope.
Re: Order Generation and Order Delivery Status
The main thing is that the OrderReference is included. OpenVPMS will match on SellersItemIdentification (i.e. reorder code) if there are no OrderLineReferences.
Re: Order Generation and Order Delivery Status
I am adding a the SQL I used to update our database to remove the PENDING deliveries that affect our automatic ordering
In effect you may wish to update part of the procedure so it only finds specific supplies (in our case this was not necessary as we only used 1. you would add something like
add e.name LIKE `%PROVET%`
to the where clause
Goodluck
SQL is attached below
Re: Order Generation and Order Delivery Status
This is still an ongoing issue.
Additionally I have noted that the system is allowing items with no Reorder Codes to be added to an order...ie the Product has a supplier linkage but the reorder codes are either wrong or missing, it can still be added to the order.
When the order is sent the supplier still accepts it but the products with incorrect order codes are stripped out / removed. There is no notification that this has happened?
Re: Order Generation and Order Delivery Status
You can create an order with no reorder codes, but you have to set them before the order can be submitted to the supplier. The ESCI client (specifically OrderMapperImpl.getItem(...)) will reject orders where the act.supplierOrderItem has an empty reorderCode node.
If the order is valid from OpenVPMS' perspective, but cannot be processed by the supplier due to incorrect order codes, then the supplier should reject it as per section 6.2 Rejected Order of the ESCI specification:
In this scenario, OpenVPMS sends an Order to the supplier, who responds with an OrderResponseSimple, with AcceptedIndicator=false. The reason for the rejection is detailed in the RejectionNote.
OpenVPMS may change the order and resubmit it.
Re: Order Generation and Order Delivery Status
What error response should we expect when submitting an order with no reorder codes?
Re: Order Generation and Order Delivery Status
You should get an error dialog with a message like: ESCIA-0300 Supplier Cenvet (123456) has no order code for product Acepromazine (98765)
Re: Order Generation and Order Delivery Status
This was provets response to my request to look for old order codes that needed updating -- keeping in mind provets current action is to accept an order with invalid codes and silently remove that order item
Incident Details:
e-Order Integrated - Ordering - item failure generate
This is a query on our e-order system and its functionality. urgency is low as user has workarounds, and user advises they are able to get around it with some inconvenience, but would enjoy it should this be possible
Call inbound
contact: Ben Charlton
Issue: Orders made through OPEN VPMS still go through even if there is an invalid/redundant item code.
Occurrence: Generally this will occur when an item which has had its product code updated in our system is ordered through OPEN VPMS.
Note: this does not occur when orders are done through E-Order software as the software will not allow it or notifies that there is a new item code.
Query: Is there a way for our e-order system to reject orders from integrated VPMS systems that have invalid order codes?