ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> AR invoice and GL Posting done on different dates
http://www.istechforum.com/YaBB.pl?num=1186691324

Message started by markoptics on 08/09/07 at 13:28:44

Title: AR invoice and GL Posting done on different dates
Post by markoptics on 08/09/07 at 13:28:44

We accidentally posted an invoice (SO) to AR for 8/7/08. Then we thought we could fix it by changing the date in GL-O to the correct date of 8/7/08. Of course, this didn't work. Now we have it in AR as 8/08 and posted on the GL as 8/07. How can I fix this?

Title: Re: AR invoice and GL Posting done on different da
Post by JNAPIER on 08/09/07 at 15:49:16

You need to edit the changed date (the one done in GL-P) back to 08 with Maintain database. I think the file is BKARHINV. After that, void the invoice using the 08 date. re invoice as usual.

John

Title: Re: AR invoice and GL Posting done on different da
Post by markoptics on 08/13/07 at 16:38:23

HI, I changed the BKARHINV but the invoice is still showing up in 2008 instead of 2007. What other files do I need to change the date?

Title: Re: AR invoice and GL Posting done on different da
Post by Lynn_Pantic on 08/14/07 at 07:31:29

There are a BUNCH of them. You are better off to follow John's advice and put what you have edited back to 2008, void the 2008 invoice and then repost with the correct date.

Title: Re: AR invoice and GL Posting done on different da
Post by kkmfg on 08/14/07 at 12:23:28

Lynn_Pantic wrote:

There are a BUNCH of them. You are better off to follow John's advice and put what you have edited back to 2008, void the 2008 invoice and then repost with the correct date.

Don't you just wish you had access to triggers and rules within the database? ;-)

Title: Re: AR invoice and GL Posting done on different da
Post by markoptics on 08/15/07 at 09:43:00

I'm still lost. (no laughing)

I went in to BKHINV.B and changed 2008 date to match to GL date of 2007. I can reverse this but how do I change the GL date 2007 to match the AR date 2008? then I will apply a credit and start over.

Title: Re: AR invoice and GL Posting done on different da
Post by markoptics on 08/16/07 at 07:53:28

Ok, maybe I'm hormonal and can't focus clearly but I'm not getting this.

I voided invoice in 2008 (the wrong one)
I left the AR portion in 2008 (as I did when I posted it the first time)
I changed the date to 2007 in GL-P before posting (as I did on the first time)

My GL account for sales is high by the amount of the invoice if I compare 2007 gl to 2007 ar aging. If I compare 2007gl to 2008 ar aging, I am fine.

When I look in AR-F, the only dates left on the customer account are 2007 (the 2008 have been voided). So why am I not balancing 2007 gl sales to 2007 ar aging?

Thanks,
J