ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Sales >> Changing an invoice
http://www.istechforum.com/YaBB.pl?num=1162485630

Message started by fstickel on 11/02/06 at 08:40:30

Title: Changing an invoice
Post by fstickel on 11/02/06 at 08:40:30

An invoice had to be changed so it was voided to allow access to SO-A to change the Sales Order. A new invoice (new invoice #) was printed and posted.

Now another change needs to be made to the Sales Order. SO-A says the new invoice has been printed but not posted so it will not allow additional changes to the SalesOrder. The message says to go into SO-F, print the unposted invoice, then answer "No" when asked to mark the invoice as printed. When I go into SO-F to print the unposted invoice, it shows me the graphical form name (BKSOF4.RTM), asks where I want it printed, then returns me to the menu as though I had cancelled out.

Does anyone know how to deal with this?

Title: Re: Changing an invoice
Post by JNAPIER on 11/02/06 at 10:30:12

Are you hitting the REPRINT invoices button? You need to hit the NEW invoice button and say no to print all SO. Than select the one you want to reprint.

John

Title: Re: Changing an invoice
Post by fstickel on 11/06/06 at 09:56:41

Thank you John. Your answer worked in the main company. Just to be sure I had it, I tried to replicate the procedure in my Test company.

DBA tells me it "can't void invoice #2414 because there is an unposted invoice #2415 pending against that SO". When I try to post #2415, it says "there are no printed , unposted invoices". When I go back a step and try to print the supposed unposted invoice, it says "there are no sales orders for the chosen criteria". I've tried all the Y/N combinations of Ship Date as Post Date, Print all released SO's, etc. and nothing works.

I seem to have a phantom invoice that DBA won't let go of. Any ideas on how to clear it?

Title: Re: Changing an invoice
Post by JNAPIER on 11/06/06 at 11:42:41

You could try and re release the SO. Maybe it somehow got un released. You could print the SO-O-I report, print released SO's. Is it there?

John

Title: Re: Changing an invoice
Post by fstickel on 11/06/06 at 13:46:32

I tried to re release the SO and rec'd the msg "SO was closed. Do you want to reopen it?" I said Y. Went back to SO-A and opened and saved the SO. Then SO-E to release the SO. Then SO-F to print the unposted invoice. DBA says "No SOs for the chosen criteria". Checked SO-O-I , the "SO Released / Not Posted" report and it was empty.

Title: Re: Changing an invoice
Post by CCKEITH on 08/21/08 at 15:29:54

Today I am in the same loop that was described on this 2006 forum thread. Any solutions to this problem?

Title: Re: Changing an invoice
Post by CCKEITH on 08/21/08 at 15:32:29

In addition to my earlier post I just wanted to point out that we started out with the exact same problem, voided invoice, reprinted and posted a new one then we went back in to make another change to the 2nd generation invoice and got stuck in this loop.

Title: Re: Changing an invoice
Post by GasGiant on 08/21/08 at 17:00:07

Check in Maintain Database to make sure that that SO in BKARINV has the same invoice number associated with it as it does in the invoice table, BKARHINV. We have occasional problems with these being out of sync and I have to change the SO record in BKARINV to match what is listed in BKARHINV.

Title: Re: Changing an invoice
Post by CCKEITH on 08/21/08 at 22:12:38

I was excited to hear you had a suggestion to fix this. I tried to do what you said but am still having the problem. I am afraid that I tried too many things in Maintain Database before and after I read your response. Do you know what files contain records relating to invoices that were generated from a particular SO? Can I go to those files and delete the associated record in the files and get back to the starting point where I just have the SO in the system?

I realize this might just be wishful thinking!

Title: Re: Changing an invoice
Post by GasGiant on 08/22/08 at 04:09:23

No, you don't want to delete posted invoices. If you can get the numbers to line up correctly then you can back out transactions, but don't change or remove anything in the invoice tables (BKARHINV, BKARHIVL). Usually, if you get the SO header (BKARINV) to match the invoice number and mark the SO as closed (again in BKARINV), then the problem is over, if the invoice had posted in the first place. Only if the invoice never posted would you want to consider mucking around any further. So, if you still have things messed up it may be time to bring in the Big Guns (aka Lynn).