Creating invoice from backend

[njoyotm]

Hi ,

When I create an invoice by writting an insert statement to the invoice table, an invoice gets created successfully and the same could be viewed from the front end of otm.

But When I edit it and click the finished button, I get the following error.

java.lang.NullPointerException
java.lang.NullPointerException
at glog.server.workflow.status.invoice.FindIssuableBi lls.canPerform(FindIssuableBills.java:12
at glog.server.status.StatusPerformer.canPerform(Stat usPerformer.java:81)
at glog.server.status.Status.canPerform(Status.java:7 3)
at glog.ejb.invoice.db.InvoiceBeanDB.canPerform(Invoi ceBeanDB.java:1540)
at glog.ejb.invoice.InvoiceServerSideEJBWrapper.canPe rform(InvoiceServerSideEJBWrapper.java:4953)
at sun.reflect.GeneratedMethodAccessor124.invoke(Unkn own Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.evermind.server.ejb.interceptor.joinpoint.EJBJ oinPointImpl.invoke(EJBJoinPointImpl.java:35)
at com.evermind.server.ejb.interceptor.InvocationCont extImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.DMSInte rceptor.invoke(DMSInterceptor.java:52)
at com.evermind.server.ejb.interceptor.InvocationCont extImpl.proceed(InvocationContextImpl.java:119)
at Invoice_EntityBeanWrapper502.canPerform(Invoice_En tityBeanWrapper502.java:2667)
at glog.server.query.invoice.AbstractInvoiceHandler.p ostModify(AbstractInvoiceHandler.java:194)
at glog.webserver.update.GenericContainerXMLUpdate.pr ocess(GenericContainerXMLUpdate.java:171)
at glog.server.xmlupdate.XMLUpdateSessionBean.updateA ndTrack(XMLUpdateSessionBean.java:244)
at glog.server.xmlupdate.XMLUpdateSessionServerSideEJ BWrapper.updateAndTrack(XMLUpdateSessionServerSide EJBWrapper.java:29
at sun.reflect.GeneratedMethodAccessor101.invoke(Unkn own Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.evermind.server.ejb.interceptor.joinpoint.EJBJ oinPointImpl.invoke(EJBJoinPointImpl.java:35)
at com.evermind.server.ejb.interceptor.InvocationCont extImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.DMSInte rceptor.invoke(DMSInterceptor.java:52)
at com.evermind.server.ejb.interceptor.InvocationCont extImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.TxRequi redInterceptor.invoke(TxRequiredInterceptor.java:5 0)
at com.evermind.server.ejb.interceptor.InvocationCont extImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.Securit yRoleInterceptor.invoke(SecurityRoleInterceptor.ja va:47)
at com.evermind.server.ejb.interceptor.InvocationCont extImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.DMSInte rceptor.invoke(DMSInterceptor.java:52)
at com.evermind.server.ejb.interceptor.InvocationCont extImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.InvocationContextPool.invo ke(InvocationContextPool.java:55)
at com.evermind.server.ejb.StatelessSessionEJBObject. OC4J_invokeMethod(StatelessSessionEJBObject.java:8 7)
at XMLUpdateSessionHome_RemoteProxy_6658h1d.updateAnd Track(Unknown Source)
at sun.reflect.GeneratedMethodAccessor137.invoke(Unkn own Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.evermind.server.rmi.RmiMethodCall.run(RmiMetho dCall.java:53)
at com.evermind.util.ReleasableResourcePooledExecutor $MyWorker.run(ReleasableResourcePooledExecutor.jav a:303)
at java.lang.Thread.run(Thread.java:534)


Can any one advise on this?

Regards,
njoyotm

[njoyotm]

Re: Creating invoice from backend

Hi,
In the process of trying I found the way to insert data into invoice from backend without any issues.

We need to insert data into the following tables

1)Invoice
2)Invoice_Status
3)Invoice_summary

When the data is entered only in Invoice table and when you open the invoice in front end then the error appears.You'll not be able to restrict the error even if u make an entry in Invoice_Status and Invoice_Summary unless you restart the server.
If you insert data into Invoice,Invoice_Status,Invoice_summary in one go and then edit the invoice screen and finish it ,the invoice gets finished without any error.

Thus this is more of a cache related issue in the application layer.
Thats the reason it works after restart.

Regards,
njoyotm

[navya_otm]

Re: Creating invoice from backend

Hi njoyotm,

Do you have an xml for invoice which contains invoice status in it.
please provide an invoice xml which contains invoice status.

i could not generate either an invoice xml or billing or allocation base xml with invoice status included.
I basically want to upload invoice status to invoice using xml.