Welcome, Guest. Please Login.
11/18/24 at 19:39:01
News:
Home Help Search Login


Pages: 1
Send Topic Print
Changing an invoice (Read 1175 times)
fstickel
Browser
*


I love YaBB 1G -
SP1!

Posts: 38
Changing an invoice
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?
Back to top
 
 
  IP Logged
JNAPIER
Active Member
*****


Evil-Evo Bad Dog!

Posts: 533
Gender: male
Re: Changing an invoice
Reply #1 - 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
Back to top
 
 

EVO-ERP, ISTS 3.27.08 , 2000I 10 user
Email WWW   IP Logged
fstickel
Browser
*


I love YaBB 1G -
SP1!

Posts: 38
Re: Changing an invoice
Reply #2 - 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?
 
Back to top
 
 
  IP Logged
JNAPIER
Active Member
*****


Evil-Evo Bad Dog!

Posts: 533
Gender: male
Re: Changing an invoice
Reply #3 - 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
Back to top
 
 

EVO-ERP, ISTS 3.27.08 , 2000I 10 user
Email WWW   IP Logged
fstickel
Browser
*


I love YaBB 1G -
SP1!

Posts: 38
Re: Changing an invoice
Reply #4 - 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.
Back to top
 
 
  IP Logged
CCKEITH
Full Member
***


Thanks, Lynn and
Allen and Lori!

Posts: 151
Gender: female
Re: Changing an invoice
Reply #5 - 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?
Back to top
 
 

Charlene Keith
Hillco Technologies, Inc.
Evo-ERP 2015.1
(30 users)
WWW   IP Logged
CCKEITH
Full Member
***


Thanks, Lynn and
Allen and Lori!

Posts: 151
Gender: female
Re: Changing an invoice
Reply #6 - 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.
Back to top
 
 

Charlene Keith
Hillco Technologies, Inc.
Evo-ERP 2015.1
(30 users)
WWW   IP Logged
GasGiant
Administrator
*****


How can I help?

Posts: 1523
Gender: male
Re: Changing an invoice
Reply #7 - 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.
Back to top
 
 


Email WWW GasGiant GasGiant 31012781 swordworlder swordworlder   IP Logged
CCKEITH
Full Member
***


Thanks, Lynn and
Allen and Lori!

Posts: 151
Gender: female
Re: Changing an invoice
Reply #8 - 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!
Back to top
 
 

Charlene Keith
Hillco Technologies, Inc.
Evo-ERP 2015.1
(30 users)
WWW   IP Logged
GasGiant
Administrator
*****


How can I help?

Posts: 1523
Gender: male
Re: Changing an invoice
Reply #9 - 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).
Back to top
 
 


Email WWW GasGiant GasGiant 31012781 swordworlder swordworlder   IP Logged
Pages: 1
Send Topic Print