ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Sales >> SO# duplicated INV not posting
http://www.istechforum.com/YaBB.pl?num=1399479014

Message started by fdiala on 05/07/14 at 09:10:13

Title: SO# duplicated INV not posting
Post by fdiala on 05/07/14 at 09:10:13

SO was entered and lines were released. When the employee came to print the invoice, he noticed SO# was duplicated. He says he only released once. When I checked, SO 14912 was listed twice, one had an IVN 4907 and the other INV 4908. The invoices were identical exp for the Inv number. I changed the release qty so the INV are of zero value. Printed them, and posted.
INV 4908 posted no issues, while inv 4907 didnt post. now we are skipping an invoice!
SO 14912 shows on my list one as closed and the other not closed. If I enter the not closed SO, once I go to the next screen, it says SO closed do u want to re-open. I am not sure what happened. Its obvious something duplicated the SO, and then the indexing got mixed up between the 2.

We created and totally new SO and posted from there, but I stil have INV 4907 missing in my system! I cant seem to re-print it, SO is closed, although I choose not the closed SO from the list. and it does not exist to post!

Please help! its driving me crazy

Title: Re: SO# duplicated INV not posting
Post by fdiala on 05/08/14 at 07:17:30

anyone?

Title: Re: SO# duplicated INV not posting
Post by Kelloggs on 05/09/14 at 07:09:44

fdiala wrote:

....but I stil have INV 4907 missing in my system! I cant seem to re-print it, SO is closed, although I choose not the closed SO from the list. and it does not exist to post!

"Invoices" are not actual records on your system.
Invoice numbers are assign to Sales Orders.

You will not be able to recover that number because you have already post Invoice 4908.

:)

Kelloggs

Title: Re: SO# duplicated INV not posting
Post by fdiala on 05/15/14 at 06:07:04

but it still pull out when I post.
"An error has occured. SO#14912 appears to have been changed by another user so that it is not postable at this time. The posting of this SO will be skipped, please try to re-post it later.

Its a zero invoice anyway! but the message pops out every time I post.

Is there a place where I can flag it as posted so it does not pull out everytime?

Title: Re: SO# duplicated INV not posting
Post by Kelloggs on 05/15/14 at 07:56:58

I would query my database and find the sales order and then delete. But it meas that you need to know a little bit of SQL language.

Have you contact ISTECH Support?

On your Pervasive Control Panel

select * from "BKARHINV" where bkar_inv_sonum = 14912;
This could return up to 3 records.

:'(

Kelloggs

Title: Re: SO# duplicated INV not posting
Post by fdiala on 05/15/14 at 11:44:59

thanks,
I just need the table name.

Title: Re: SO# duplicated INV not posting
Post by Kelloggs on 05/15/14 at 15:52:54

There is two tables: BKARINV and BKARHINV
have fun...

8-)

Kelloggs

Title: Re: SO# duplicated INV not posting
Post by Lynn_Pantic on 05/15/14 at 17:19:46

You only need BKARINV for what you are looking for.