ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Sales >> Invoice number mismatch
http://www.istechforum.com/YaBB.pl?num=1170858173

Message started by GasGiant on 02/07/07 at 06:22:53

Title: Invoice number mismatch
Post by GasGiant on 02/07/07 at 06:22:53

We have been experiencing a strange problem when posting invoices recently. Our billing clerk will print and post one invoice, then another with everything working fine. Then one invoice will start to post and seem to get into a loop of some sort and never finish. When we end the task we find that we have a mess. The invoice has not been posted, but when we try to post it the system thinks it is not available, but if we try to print it the system thinks it has already been.

On looking at the tables (BKARINV & BKARHINV) I find that the two have different invoice numbers for the same order, the numbers being one digit apart. If I correct the mismatch in the tables then we can post the invoice.

Anyone else ever seen this?

FYI: SD-Q>Sales I>Set PackSlip same as Invoice = Y

Title: Re: Invoice number mismatch
Post by kkmfg on 02/07/07 at 06:29:50

Kind of makes you wish that EvoERP used BTrieve transactions doesn't it? ;-)

Title: Re: Invoice number mismatch
Post by GasGiant on 02/07/07 at 06:34:00

kkmfg wrote:

Kind of makes you wish that EvoERP used BTrieve transactions doesn't it? ;-)

Come over here and say that! >:(

Title: Re: Invoice number mismatch
Post by kkmfg on 02/07/07 at 06:46:54

Yeah, I know. It's really frusterating when a transaction goes south part way through. I do hope to try out BTrieve transactions for myself at some point. I'm sort of getting there... Even assuming it works we'll then have to abduct Alan and sit him in a dark room with a pot of coffee and a laptop until he fixes this up for us! ::)

Title: Re: Invoice number mismatch
Post by GasGiant on 02/07/07 at 07:11:14

I'll buy the donuts.

Alan, look, a Tim Horton's gift card!

{for all of you who saw me at the NH symposium, you gotta know that I will code for donuts!}

Title: Re: Invoice number mismatch
Post by NovaZyg on 02/07/07 at 08:19:50

LOL,

Programmer for hire, will work for food..