ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Sales >> posted invs in AR-E but not in SO-F or SO-O
http://www.istechforum.com/YaBB.pl?num=1121277756

Message started by Laura Oliver on 07/13/05 at 10:02:36

Title: posted invs in AR-E but not in SO-F or SO-O
Post by Laura Oliver on 07/13/05 at 10:02:36

3 invoices were printed & posted , but now when I go to print them they are not there. I searched by posted inv#, and SO# with no avail. But when I go to SO-A all Sales Orders are closed and show the invoice #

Posted Invoices are NOT found:
in SO-F.
nor on SO-O-H

BUT...found in:
GL-D Sales Journal
AR-E Statements

How can they be on some things but not on others?

One of the guys said he saw a "key set up error" during this time. I know that because of this the workstations were shutdown and the server was reset. ? ?

Title: Re: posted invs in AR-E but not in SO-F or SO-O
Post by Laura Oliver on 07/28/05 at 05:58:12

Should I go into maintain database and DELETE the files associated with GL-D and AR-E ?
.... or
Should I go into maintain data base and CREATE the files associated with SO-F and SO-O-H ?

I need to get this straight by months end. Any and all help will be greatly appreciated.

Title: Re: posted invs in AR-E but not in SO-F or SO-O
Post by JNAPIER on 07/28/05 at 08:14:40

We have a very strict rule of not posting invoices until right after a complete BU of the *.b Invoice posting makes all kinds of posts to 8 or 10 different files. Trying to figure out which ones got hosed is very dificult. I know this doesn't help your current situation but maybee in the future?

John

Title: Re: posted invs in AR-E but not in SO-F or SO-O
Post by Laura Oliver on 07/28/05 at 08:33:08

John,
I dont understand what you mean by
. " complete BU of the *.b Invoice posting makes all kinds of posts to 8 or 10 different files"

Please ....If I understood it might help me.
I have posted over 25000 invoices in the last 8 years on DBA. This is the first time the posting only partly took....it posted to files GL and AR, but not in the SO files. I am thinking that setup key error produced a burp in the posting.

Laura

Title: Re: posted invs in AR-E but not in SO-F or SO-O
Post by JNAPIER on 07/28/05 at 09:08:56

Laura Oliver wrote:

What I am saying is that a full Backup of all your Data files prior to posting allows you to restore to your previous state if a problem has occured during posting. Posting of invoices involves many different data files. Many different Inventory, Sales, GL, SO, Commissions. Lynn would know the exact ones but my GUESS is 8 or 10 different files. With only 3 invoices your damage could be minimal. We often post 30 to 50 a Day. It would be a DISASTER if we had an issue posting.

John

Title: Re: posted invs in AR-E but not in SO-F or SO-O
Post by aricon on 07/29/05 at 11:27:08

Laura,

If you HAVE to you could probably go into BARHINV and BKARHIVL and manually enter the data into the appropriate fields in maintain DB.

Title: Re: posted invs in AR-E but not in SO-F or SO-O
Post by Laura Oliver on 07/30/05 at 06:22:54

recreated (3) invoices in BKARHINV
progessing but still a few problems:

1. SO-F, while I can now F2 the (3) recreated invoices, I can NOT list them to the screen or print them (HELP!!! HELP!!!) (but at least they are now in SO-O-H)

2. What are BKAR INV NL & BKAR INV SSCOGS for? (found in BKARHINV-B) I left them blank. :-/

3. Is it possible that BKARHINV-B was the only file messed up? I did nothing to BKARHIVL-B? All data appeared to already be there.

The BIG problem--- I need to print these, so I can mail them to the customer.

Lorne, I don't think I had any other choice. Thanks for getting me this far.

Title: Re: posted invs in AR-E but not in SO-F or SO-O
Post by aricon on 07/30/05 at 10:21:07

Cannot remember what SSCOGS is but the NL field is Number of lines. Count the line numbers in BKARHIVL and enter it there.

Title: Re: posted invs in AR-E but not in SO-F or SO-O
Post by Laura Oliver on 08/01/05 at 09:32:23

What could be keeping these 3 posted invoices from printing?

Posted invoices show up in SO-O-H
You can F2 them in SO-F , But when you go to list/print them they are not there.

HELP!!! I need to mail them to my customer.

Any and all ideas appreciated.
Thanks

Title: Re: posted invs in AR-E but not in SO-F or SO-O
Post by JNAPIER on 08/01/05 at 10:02:00

Laura Oliver wrote:

Can you Void the 3 Invoices? If so just void them and re-Invoice them. Have you tried to print them saying Print Unposted Invoices?

John

Title: Re: posted invs in AR-E but not in SO-F or SO-O
Post by Laura Oliver on 08/01/05 at 10:45:08

Yes I could void them, but I would rather not. Y E T .

It has to be something SIMPLE keeping them from printing. It appears all their data is in maintain database.

Title: Re: posted invs in AR-E but not in SO-F or SO-O
Post by aricon on 08/01/05 at 16:00:59

Laura,

Extract the data for these invoices from the BKAR* tables and populate an Excel file and email that to me. I will take a look for you.

Title: Re: posted invs in AR-E but not in SO-F or SO-O
Post by Laura Oliver on 08/03/05 at 10:30:44

SUCCESS! (would have fixed it quicker if I had read LORNE'S Jul 30th, 2005, 1:21pm post closer)

for the ARCHIVES : BKAR INV NL (found in BKARHINV-B) has to have the # of lines or the invoice will not list or print. (i had left it blank)

I had originally asked:
What missing or corrupted file would cause a message in SO-H that says

"this invoice has no line items"

Title: Re: posted invs in AR-E but not in SO-F or SO-O
Post by aricon on 08/04/05 at 04:25:50