Welcome, Guest. Please Login.
05/19/25 at 08:28:14
News:
Home Help Search Login


Pages: 1
Send Topic Print
posted invs in AR-E but not in SO-F or SO-O (Read 1410 times)
Laura  D. Oliver
Active Member
*****




Posts: 985
Gender: female
posted invs in AR-E but not in SO-F or SO-O
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. ? ?  
 
 
Back to top
 
 

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com



Email WWW   IP Logged
Laura  D. Oliver
Active Member
*****




Posts: 985
Gender: female
Re: posted invs in AR-E but not in SO-F or SO-O
Reply #1 - 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.
Back to top
 
 

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com



Email WWW   IP Logged
JNAPIER
Active Member
*****


Evil-Evo Bad Dog!

Posts: 533
Gender: male
Re: posted invs in AR-E but not in SO-F or SO-O
Reply #2 - 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
Back to top
 
 

EVO-ERP, ISTS 3.27.08 , 2000I 10 user
Email WWW   IP Logged
Laura  D. Oliver
Active Member
*****




Posts: 985
Gender: female
Re: posted invs in AR-E but not in SO-F or SO-O
Reply #3 - 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
 
 
Back to top
 
 

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com



Email WWW   IP Logged
JNAPIER
Active Member
*****


Evil-Evo Bad Dog!

Posts: 533
Gender: male
Re: posted invs in AR-E but not in SO-F or SO-O
Reply #4 - 07/28/05 at 09:08:56
 
Quote from 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



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
Back to top
 
 

EVO-ERP, ISTS 3.27.08 , 2000I 10 user
Email WWW   IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: posted invs in AR-E but not in SO-F or SO-O
Reply #5 - 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.
Back to top
 
 

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net
Email WWW   IP Logged
Laura  D. Oliver
Active Member
*****




Posts: 985
Gender: female
Re: posted invs in AR-E but not in SO-F or SO-O
Reply #6 - 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. undecided
 
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.
Back to top
 
 

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com



Email WWW   IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: posted invs in AR-E but not in SO-F or SO-O
Reply #7 - 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.
Back to top
 
 

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net
Email WWW   IP Logged
Laura  D. Oliver
Active Member
*****




Posts: 985
Gender: female
Re: posted invs in AR-E but not in SO-F or SO-O
Reply #8 - 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
 
 
Back to top
 
 

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com



Email WWW   IP Logged
JNAPIER
Active Member
*****


Evil-Evo Bad Dog!

Posts: 533
Gender: male
Re: posted invs in AR-E but not in SO-F or SO-O
Reply #9 - 08/01/05 at 10:02:00
 
Quote from 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



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
Back to top
 
 

EVO-ERP, ISTS 3.27.08 , 2000I 10 user
Email WWW   IP Logged
Laura  D. Oliver
Active Member
*****




Posts: 985
Gender: female
Re: posted invs in AR-E but not in SO-F or SO-O
Reply #10 - 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.
Back to top
 
 

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com



Email WWW   IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: posted invs in AR-E but not in SO-F or SO-O
Reply #11 - 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.
Back to top
 
 

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net
Email WWW   IP Logged
Laura  D. Oliver
Active Member
*****




Posts: 985
Gender: female
Re: posted invs in AR-E but not in SO-F or SO-O
Reply #12 - 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"    
 
 
Back to top
 
 

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com



Email WWW   IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: posted invs in AR-E but not in SO-F or SO-O
Reply #13 - 08/04/05 at 04:25:50
 
Grin
Back to top
 
 

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net
Email WWW   IP Logged
Pages: 1
Send Topic Print