 |
Export Information
It's nice to have lots of great information in a
database. But not as great as getting that data OUT of the database!
Here's how you can do that in RecWizard.
Finding the place to export from is pretty easy.
Click on Application Setup, then
select the Company tab and the
Export button. The screen will
look like this:
After you click the Export button you will be
prompted for an As Of Date, and
whether you want to Include Column Headings.
We recommend you include the column headings so you know what the
actual information your are exporting is. When you are ready to go
click Run Export.
Now you will be prompted with normal Windows type
prompts to select a name for the file that will be created and the
place you want it to be saved.
Contents of the Export File
There are two parts of the file you have just
created. The TOP-LEFT... and the BOTTOM-RIGHT. The TOP-LEFT will
start at cell A1. The BOTTOM-RIGHT will start in column V and the
first row will be the next row after the end of the TOP-RIGHT
section. To find that first record go to cell V1 and press END-DOWN.
In the RecWizardTutorial Database the first cell of the BOTTOM-RIGHT
section is V26.
This information can be manipulated to create
Excel reports. If you prefer to use Access to create robust
customized reports this data can easily be extracted into an Access
database.
TOP-LEFT Details
Here are the Column Headings and explanations of
what they mean for the TOP-LEFT section of the export.
|
Column Heading |
Definition |
| ExtractDate |
Date this file
was created |
| AsOfDate |
Date you
selected for the As Of Date |
| AcctNum |
Account Number |
| AcctName |
Account Name |
| ActiveStat |
Whether the
account is active - Yes / No |
| KeyConStat |
Whether the
account is a Key Control account - Yes / No |
| AcctType |
Account Type:
A-Asset, C-Contra-asset, L-Liability, E-Equity, I-Income, X-eXpense |
| Curr |
Currency used
for this General Ledger |
| ERPNumber |
Code used to
consolidate accounts over multiple databases |
| PerEndBal |
Balance in the
account for this As Of Date |
| PerEndStat |
Status of the
reconciliation process for this As Of Date: Prepared /
Approved / Reviewed. A date indicates the last month the
reconciliation has been prepared for this account if it hasn't
been prepared for this As Of Date. |
|
RequiredAdjustment |
Total amount of
the Required Adjustments for this account on the As Of Date |
| Unresolved |
Total amount of
the Unresolved Items for this account on the As Of Date |
| PerUnidDiff |
Total amount of
the Unidentified Difference for this account on the As Of Date |
| PrepBy |
Who Prepared the
reconciliation |
| PrepDate |
Date it was
Prepared |
| ApprBy |
Who Approved the
reconciliation |
| ApprDate |
Date it was
Approved |
| RevBy |
Who Reviewed the
reconciliation |
| RevDate |
Date it was
Reviewed |
BOTTOM-RIGHT Details
Here are the Column Headings and explanations of
what they mean for the BOTTOM-RIGHT section of the export.
|
Column Heading |
Definition |
| ExtractDate |
Date this file
was created |
| GlAcctNbr |
Account Number |
| GlAcctName |
Account Name |
| OpenDate |
Date this item
became part of the reconciliation |
| CloseDate |
Date this item
no longer was part of the reconciliation |
| Comment |
Text entered to
explain the item |
| RecItemAmount |
Amount of the
item |
| ReqTimCode |
Reconciling Item
Type code: R-Required Adjustment, L-List Component, T-Timing
Item, U-Unresolved |
| RecTypeCode |
Indicates the
type of item: C-Outstanding Check, D-Deposit-in-transit,
B-Bank Fee, N-NSF Check, S-Subledger match, L-General List,
O-Amortizable Prepaid |
| Currency |
Currency used
for this General Ledger |
| ERPNumber |
Code used to
consolidate accounts over multiple databases |
| AccountTypeCode |
Account Type:
A-Asset, C-Contra-asset, L-Liability, E-Equity, I-Income, X-eXpense |
If you come up with some
interesting ways to review your data and manage the process, please
let us know so we can add that information to our knowledge base.
|
