ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> AP-C ONLY one sided transaction in GL-O
http://www.istechforum.com/YaBB.pl?num=1173885662

Message started by LeAnn Cucchiara on 03/14/07 at 07:21:02

Title: AP-C ONLY one sided transaction in GL-O
Post by LeAnn Cucchiara on 03/14/07 at 07:21:02

Have an issue with a PO receipt - actually the PO receipt seems okay but when entering the invoice it got corrupted. Some how we wound up with a one-sided GL entry which throws everything off.

PO was received - hit GL correctly: $311.05 Db & $311.05 Cr ; printed the receiving report it showed $311.05 Rec'd; $311.05 RNI & $0 Invoiced.

Then in AP-C entered invoice; picked the receivers that went with that invoice & everything appeared okay. At this point we thought we were golden.

But then we went to GL-O to post & there was some long meassage about a transaction being out of balance - there was a $10.61 Db against sales tax & a $311.05 Db against RNI reference #SHA249 (invoice #) but no off-setting CREDIT transactions for the A/P account. Sooooooooooo we manually entered the credit side in GL-P against the A/P account #, probably the wrong thing to do. (I think I need to get rid of that GL-P option - it has never helped me, only caused me more problems) Anyway, the invoice does not show up in the A/P module as open or in the vendor's aging file at all.

Now when you print the receiving report it shows: $311.05 Rec'd; $0 RNI & $311.05 Invoiced

So then we tried to enter the invoice through AP-C again & we did not get a message saying that that invoice # had already been entered for this vendor but there were NO receivers to enter it against. So we got out of that without entering it.

One good thing, I think, none of these transactions have been posted through GL-O. Can I (should I) delete that manual CR transaction that was done in GL-P and then enter the invoice through AP-B? The PO side of things seem to be okay - it's closed out. If I need to delete the GL-P xaction, how would I do that?

Title: Re: AP-C ONLY one sided transaction in GL-O
Post by lmk223a on 03/14/07 at 10:25:36

LeAnn Cucchiara wrote:

But then we went to GL-O to post & there was some long meassage about a transaction being out of balance - there was a $10.61 Db against sales tax & a $311.05 Db against RNI reference #SHA249 (invoice #) but no off-setting CREDIT transactions for the A/P account. Sooooooooooo we manually entered the credit side in GL-P against the A/P account #, probably the wrong thing to do. (I think I need to get rid of that GL-P option - it has never helped me, only caused me more problems) Anyway, the invoice does not show up in the A/P module as open or in the vendor's aging file at all.

When this happens, and the first attempt at processing the invoice in AP-C cleared the receipt from RNI report, I enter the invoice manually via AP-B, with a debit of $311.05 to the RNI GL account and in your case, a debit of $10.61 to the sales tax account. This WILL ADD the invoice to the vendor's account in Accounts Payable history.

Next, edit the partially posted GL Batch in GL-P so that the amounts offset each other. I.E., add a credit entry of $10.61 to the sales tax account, and add a credt entry of $311.05 to the original GL account shown in the partial post transaction for your invoice # SHA249. These accounts will now offset each other in the General Ledger when you post the batch, net effect will be $0.