On clicking CHECK INBOX
Submitted by Ben_Charlton on Thu, 25/09/2014 - 10:32
When I click Check inbox I get an Error
ESCIA-0108: Invalid Order: 12929 referenced by InvoiceLine: 1
Which I am guessing means we have a document that is not consistent in the inbox, Openvpms gives me no way to resolve the error or work around it by default.
I am guessing i could attempt to use inbox testing programs to remove that document but thats not going to work for endusers routinely?
Ben
Re: On clicking CHECK INBOX
It means that the invoice received from the supplier contains a reference to an order which doesn't exist in your system. This shouldn't occur as once an order is posted, it cannot be deleted.
There are two ways to resolve it:
1. Have your supplier remove the invoice from their system
2. use the ESCI inbox tool to acknowledge the message.
Re: On clicking CHECK INBOX
For future reference to resolve this I redownloaded the ESCI toolbox
Onto the server running Tomcat I extracted it into a directory
then I edited the setenv.bat, found in <ESCI DIR>\bin to remove references to example keystores and use the java keystore on the machine...ie comment out
to
rem set JAVA_OPTS=%JAVA_OPTS% -Djavax.net.ssl.trustStore=../conf/tomcat.jks -Djavax.net.ssl.keyStore=../conf/tomcat.jks -Djavax.net.ssl.trustStorePassword=changeit -Djavax.net.ssl.keyStorePassword=changeit
then from the bin directory run inbox.bat in <ESCI DIR>\bin
inbox -l -r <SERVICEURI> -u username - password
review the list then download the earliest document
inbox -g -i <id> -t Invoice -r <SERVICEURI> -u username - password
and review it for the line giving the error in this case a order ref.
if its the correct document acknowledge it
inbox -a -i <id> -t Invoice -r <SERVICEURI> -u username - password
Now try checking the inbox from within openvpms to see if the error resolves.