I just did this exact same thing a couple of weeks ago, though only
after 4 or 5 years of running 6.1 without having run the Capture.
What I did when I ran it was to use a keyboard-macro program (I think it
was called "Journal Macro") to change every date to the current date and
move to the next entry. Actually, what I think I really did was put the
date I wanted into the Windows clipboard, then used the macro to paste
the value and move to the next entry. I ran the macro in batches of
about 500 to 1000.
Before I ran the procedure, I printed the report to get a listing of the
dollar-values in each account, then ran the procedure, then printed the
same report again and verified that the values hadn't changed (which
they should not have - we weren't/aren't GL integrated). Oh, and of
course, I did this whole operation in a test system before attempting it
on the production system.
--Ari
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of wendorff1
Sent: Friday, November 14, 2008 11:24 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Capture/Post Question
We are on vantage 6.1, average costing and we do not use the GL
Interface or any of the real time inventory functionality. We are
investigating turning on the GL interface starting Jan1-2009.
Our biggest hurdle is the fact that we have never run the Capture/Post
process. (yes, i said never). We have data going back to 1997.
Where do we start? Currently, I cannot even run the report as a print
preview because we "need a larger 'n' parameter". That we can work
around but I still have no idea how we are going to handle 10+ years
of data.
Any suggestions?
Thanks
Kelly
[Non-text portions of this message have been removed]
after 4 or 5 years of running 6.1 without having run the Capture.
What I did when I ran it was to use a keyboard-macro program (I think it
was called "Journal Macro") to change every date to the current date and
move to the next entry. Actually, what I think I really did was put the
date I wanted into the Windows clipboard, then used the macro to paste
the value and move to the next entry. I ran the macro in batches of
about 500 to 1000.
Before I ran the procedure, I printed the report to get a listing of the
dollar-values in each account, then ran the procedure, then printed the
same report again and verified that the values hadn't changed (which
they should not have - we weren't/aren't GL integrated). Oh, and of
course, I did this whole operation in a test system before attempting it
on the production system.
--Ari
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of wendorff1
Sent: Friday, November 14, 2008 11:24 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Capture/Post Question
We are on vantage 6.1, average costing and we do not use the GL
Interface or any of the real time inventory functionality. We are
investigating turning on the GL interface starting Jan1-2009.
Our biggest hurdle is the fact that we have never run the Capture/Post
process. (yes, i said never). We have data going back to 1997.
Where do we start? Currently, I cannot even run the report as a print
preview because we "need a larger 'n' parameter". That we can work
around but I still have no idea how we are going to handle 10+ years
of data.
Any suggestions?
Thanks
Kelly
[Non-text portions of this message have been removed]