GL/CM Rapid Deployment
1. Setup Functional Currency
Go to System Manager > Activities > Company Configuration
Add Functional Currency
Add Reporting Currency
2. Setup Account Structure
Go to General Ledger > Setup > Account Structure
Change Location Length to 1
Add Department
Add Company
3. Setup Segment Account > Primary Accounts
Go to General Ledger > Setup > Segment Accounts
Select Primary Account > Click Import Primary button
In Imports Primary Accounts screen > Select a Company type > Click Select All button > Add Selected button > OK
4. Setup Other Segments
Still in Segment Accounts screen
Select Location > Enter Code, Description and Chart Desc.
Create 2 Location Code
0 for Adim
1 for Location 1
Select Department > Enter Code, Description and Chart Desc.
Select Company > Enter Code, Description and Chart Desc.
5. Build Accounts
Still in Segment Accounts screen > Click Build button
Should open Build Accounts screen
Enter Currency
Filter for Account Type equals Assets and Liability
Click Select All button
Select Segment Codes for Assets and Liability - Code: 0
Click Build button > Should open Commit Chart of Accounts screen
Click Commit button > OK
Click Select None button
Filter for Account Type not equals Assets and Liability
Click Select All button
Select Segment Codes - Code: 1
Click Build button > Should open Commit Chart of Accounts screen
Click Commit button > OK
6. Setup Bank
Go to Cash Management > Maintenance > Banks > Click New button
Enter Routing No./National Bank Identifier No = 122105155
7. Bank Account
Go to Cash Management > Maintenance > Bank Accounts > Click New button
Enter the following:
Bank Name <Created Bank>
Bank Account
GL Accounts
Ending Check
8. Setup Company Location
Go to Common Info > Activities > Company Locations
Select Location Name > Click Open Selected button
Setup Tab
Use Location Address = Yes
GL Accounts tab
Enter the following:
Location
Company
Bank Account
Specific GL Accounts
9. Enable Override Retained Earnings
Go to System Manager > Activities > Company Configuration
Select General Ledger > Override Retained Earnings
10. Setup Fiscal Year
Go to General Ledger > Maintenance > Fiscal Year > Click New button
Enter the following:
Fiscal Year
Retained Earnings
Income Summary
Click Generate button > Should open Generate Period screen > Click OK
Click Set Current Button > Save
11. Setup Company Config > Intra Company Settings
Due To / Due From (Skip this for the mean time)
12. Create GJ
Go to General Ledger > Activities > General Journals > Click New button
Enter the following
Post Date = <today>
Grid
Account Id | Debit | Credit |
|---|---|---|
11600-0001-1-1 | 100 |
|
50010-0001-1-1 |
| 100 |
13. FRD
Go to Financial Report > Maintenance > Financial Report Builder > Click Recalc
Maintenance > Report Templates > Select Balance Sheet
Click Generate button
Should open Report Viewer
14. Import Bank
Cash Management > Maintenance > Banks
Click New button > Should open Bank screen
Click Import button > Should open CSV Import screen
Click Browse > Select File > Click Import button
15. Import Vendors
Purchasing > Maintenance > Vendors
Click Import button
In Import Entities from CSV, click Browse > select import file > Click Import
File: import_Vendors.csv
*Payment Method field not part of import process
16. Import bank from Vendor > EFT Screen
Purchasing > Maintenance > Vendors
Open existing vendor or create new vendor > Click Additional button > EFT Information
In Import ACH/EFT Information from CSV, click Browse > select import file > Click Import
If Bank used in Import file is not existing, error detail is thrown and log is opened.
File: import_eft_information_NewBank.csv
If Bank used in import file is existing, import successful message is shown. User needs to manually close Import ACH/EFT Information from CSV screen.
File: import_eft_information_Vendor001.csv
*File matches entity number from #15 and banks from #14
Bank is populated on the grid.
17. Import Vouchers
Purchasing > Activities > Vouchers
Click Import button > Set Template to Standard > Click Browse button and select import file>Click Import button
Import Log will load > will show list of vouchers imported
File: ImportVouchers.csv