AR reporting

Yahoo Archive
1
Alex,

Thanks!!! That is exactly the report I was looking for!!!

Paul

I uploaded a report a couple of months ago that has that information. You
just need to add a filter to only include the over 60 days. I think it
also has memos in it, so I would delete that join if you don't use memos
(to speed up the process). We use the memo category to list any notes
associated with the invoice. It works great except the report takes about
20 minutes to run. It's a good on-line history of what happened with the
invoice.

Alex Neutgens
Controller
Circuit Check, Inc.
763-694-4110
2
Our AP person just tried to post a group and got a couple of
errors that would not let him continue.

The first error is
VendorRec not on File

The second error says:

Index VendorNum in APInvHead for recid 14912588 could not be
deleted (1422).

Anyone have any ideas? Is there something wrong with the DB?
Any help is greatly appreciated.


Tim Care
Electro Chemical Finishing
3
Yipee! Someone Else got it too!! We're not crazy! (Sorry for the morbid response, but we've been pulling our hair out on this one thinking we were doing something terribly wrong.)

We just went through a slew of these over the last few weeks. There's a couple of theories as to WHY we're getting these errors.
1. Server Hard Drive going bad.
2. There is a blank vendor in Vendor Maint.
3. We were entering a blank invoice in the group (by the machine getting kicked off Vantage during a group entry).
4. Vantage Bug. Now that you've gotten the same error, it seems more likely that this may be a possibility. Please call support with it.

Solutions:
1. We don't think our hard drive is going. 2. We deleted the blank Vendor. No change. 3. The blank invoice seems like the most likely option. Our invoice person noticed that her machine sometimes locks up and there may be a correlation with the bad recID.

Perhaps yours is happening for a similar reason.

REMEDY:
1. For temporary relieve, we found we could copy each item from the APInv Group to a new group, thus leaving the 'unpostable' group empty. In every case, we could at least post the new Group and get on with Invoicing.
2. Doing a Idxbuild from the DOS prompt on the server usually found an error or two and we were then able to post the empty groups - but this requires shutting down Vantage.
3. The best fix (you do #1 above), is to do the following from the DOS prompt on the server. You don't have to shut down Vantage, just don't have anyone trying to post the now-empty group. (Oh, and back up your database in case you don't like the results - same with #2 above).

get to the prompt where your database is located. For us this is f:\epic50\vantage\db
now type: f:\epic50\progress\bin\_proutil vantage -C idxfix <ENTER>
When the menu comes up, press 6
Enter the faulty RecID number (in your case this is 14912588)
For the DAta type press: d
IN response to 'are you sure?' press: y

If you then go back into Invoice Entry, you should be able to post the empty group.

All of the above is what we gleaned from about three weeks of talking to Epicor Tech Support on a
similar issue. I would love to hear if you discover what caused the error to happen.

Thanks.
Troy Funte
Liberty Electronics


----- Original Message -----
From: Tim Care
To: 'vantage@yahoogroups.com'
Sent: Monday, August 27, 2001 3:53 PM
Subject: [Vantage] AP Posting Error


Our AP person just tried to post a group and got a couple of
errors that would not let him continue.

The first error is
VendorRec not on File

The second error says:

Index VendorNum in APInvHead for recid 14912588 could not be
deleted (1422).

Anyone have any ideas? Is there something wrong with the DB?
Any help is greatly appreciated.


Tim Care
Electro Chemical Finishing


Yahoo! Groups Sponsor



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
4
Does anyone have a report that shows customers that are past due for 60 days
or any number you want to put in it. We have the aged receivables report,
but sometimes we just need to know who is 60 days out or greater. The
report Vantage gives us is usually 150+ pages and has the info, but you have
to wade through it all.

I'm getting ready to tackle this with the blunt little report builder tool,
but didn't want to re-invent the wheel.

Any input will be appreciated.

Have a good labor day!

Paul Lipham
I.S. Manager
Alabama Specialty Products, Inc.
paull@...
5
Paul:

I see several AR reports on the yahoogroups vantage files report builder
reports page. If none of those is what you're looking for, let me know and
I'll post mine.

Terry L. Williams I.S. Manager Chipsco, Inc. 9936 Liberty St. Ext.
Meadville, PA 16335 p.8143336331 x236 f.8143372548 tlw@...
<mailto:tlw@...> www.chipsco.com <http://www.chipsco.com/>

-----Original Message-----
From: Paul Lipham [mailto:paull@...]
Sent: Friday, August 31, 2001 2:16 PM
To: vantage@yahoogroups.com
Subject: [Vantage] AR reporting

Does anyone have a report that shows customers that are past due for 60 days
or any number you want to put in it. We have the aged receivables report,
but sometimes we just need to know who is 60 days out or greater. The
report Vantage gives us is usually 150+ pages and has the info, but you have
to wade through it all.

I'm getting ready to tackle this with the blunt little report builder tool,
but didn't want to re-invent the wheel.

Any input will be appreciated.

Have a good labor day!

Paul Lipham
I.S. Manager
Alabama Specialty Products, Inc.
paull@...




Yahoo! Groups Sponsor




Start here...

Height:
3 4 5 6 7 8 ft 0 1 2 3 4 5 6 7 8 9 10 11 in

Weight:
lbs. kg.








Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .


[Non-text portions of this message have been removed]
6
I uploaded a report a couple of months ago that has that information. You
just need to add a filter to only include the over 60 days. I think it
also has memos in it, so I would delete that join if you don't use memos
(to speed up the process). We use the memo category to list any notes
associated with the invoice. It works great except the report takes about
20 minutes to run. It's a good on-line history of what happened with the
invoice.

Alex Neutgens
Controller
Circuit Check, Inc.
763-694-4110

-----Original Message-----
From: Paul Lipham [SMTP:paull@...]
Sent: Friday, August 31, 2001 1:16 PM
To: vantage@yahoogroups.com
Subject: [Vantage] AR reporting

<< File: ATT00079.htm >>
7
THANKS Terry,

I'll check out the downloads

Paul

-----Original Message-----
From: Terry Williams [mailto:tlw@...]
Sent: Friday, August 31, 2001 2:29 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] AR reporting


Paul:

I see several AR reports on the yahoogroups vantage files report builder
reports page. If none of those is what you're looking for, let me know and
I'll post mine.

Terry L. Williams I.S. Manager Chipsco, Inc. 9936 Liberty St. Ext.
Meadville, PA 16335 p.8143336331 x236 f.8143372548 tlw@...
<mailto:tlw@...> www.chipsco.com <http://www.chipsco.com/>

-----Original Message-----
From: Paul Lipham [mailto:paull@...]
Sent: Friday, August 31, 2001 2:16 PM
To: vantage@yahoogroups.com
Subject: [Vantage] AR reporting

Does anyone have a report that shows customers that are past due for 60 days
or any number you want to put in it. We have the aged receivables report,
but sometimes we just need to know who is 60 days out or greater. The
report Vantage gives us is usually 150+ pages and has the info, but you have
to wade through it all.

I'm getting ready to tackle this with the blunt little report builder tool,
but didn't want to re-invent the wheel.

Any input will be appreciated.

Have a good labor day!

Paul Lipham
I.S. Manager
Alabama Specialty Products, Inc.
paull@...




Yahoo! Groups Sponsor




Start here...

Height:
3 4 5 6 7 8 ft 0 1 2 3 4 5 6 7 8 9 10 11 in

Weight:
lbs. kg.








Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .


[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/