Considerations for Creating Sandboxes With Accounting Seed

Body

Overview

Sandbox Type	Data Copied	Can Be Refreshed Every	Storage
Full	Yes	29 days	Same as production
Partial	Some	5 days	5 GB
Developer Pro	None	1 day	1 GB
Developer	None	1 day	200 MB

If you are creating a Partial Sandbox (see highlighted text above) and you would like your basic Financial Suite data to populate, make sure to select the following objects to copy over:

Accounting Period
Accounting Variables
GL Accounts
Ledger
PDF Formats

If you have the Orders & Inventory package installed, make sure to select the following objects:

Warehouse
Location
Inventory Balance
Products
Product Parts (if you use Kitted products or Manufacturing)

Considerations

If you are creating a Developer Pro or a Developer sandbox you need to manually create the necessary Accounting Seed data listed below. The best way to do it is in the following order:

Create 3 PDF Format Types:
1. Billing Activity Statement
  - Type: Activity Statement
  - Visualforce PDF Page: BillingActivityStmtModernPDF
  - Default Email Template: Activity_Statement_Email_Template
2. Billing Outstanding Statement
  - Type: Outstanding Statement
  - Visualforce PDF Page: BillingOutstandingStmtModernPDF
  - Default Email Template: Outstanding_Statement_Email_Template
3. Default Billing Product
  - Type: Billing
  - Visualforce PDF Page: BillingProductModernPDF
  - Default Email Template: Billing_Email_Template
Create GL Accounts with the below details. The best way to do this is to import using our Chart of Accounts import template available in the Import Templates article, which is already populated with the below GL Accounts:

Name	Type	Sub Type 1	Sub Type 2	Other
1000-Cash	Balance Sheet	Assets	Cash	Bank (checkbox): true
1200-Accounts Receivable	Balance Sheet	Assets	Current Assets
1205-Unapplied A/R	Balance Sheet	Assets	Current Assets
1400-Prepaid Expenses	Balance Sheet	Assets	Current Assets
1500-Inventory	Balance Sheet	Assets	Current Assets
1600-Work in Process	Balance Sheet	Assets	Current Assets
1700-Accumulated Depreciation	Balance Sheet	Assets	Fixed Assets
2000-Accounts Payable	Balance Sheet	Liabilities	Current Liabilities
2005-Unapplied Accounts Payable	Balance Sheet	Liabilities	Current Liabilities
2010-Vouchers Payable	Balance Sheet	Liabilities	Current Liabilities
2020-Accrued Expenses	Balance Sheet	Liabilities	Current Liabilities
2500-Deferred Revenue	Balance Sheet	Liabilities	Current Liabilities
3000-Owners Equity	Balance Sheet	Owners Equity	Equity
3060-Current Year Earnings	Balance Sheet	Owners Equity	Equity
3050-Retained Earnings	Balance Sheet	Owners Equity	Equity
4000-Product Revenue	Revenue	Product Revenue	Product Family1
4010-Services Revenue	Revenue	Services Revenue	Service Family 1
4900-Customer Payment Discounts	Revenue	Product Revenue	Product Family 1
5000-Cost of Goods Sold	Expense	Cost of Goods Sold	[blank]
5040-Vendor Payment Discounts	Expense	Cost of Goods Sold	Materials
5050-Labor	Expense	Cost of Goods Sold	Salaries & Wages
5010-Inventory Cost Variance	Expense	Cost of Goods Sold	Materials

Create a Ledger
1. Name: Actual
2. Type: Transactional
3. Default Bank Account: 1000-Cash
4. Default Billing Format: Default Billing Product
5. Billing Activity Statement Format: Billing Activity Statement
6. Billing Outstanding Statement Format: Billing Outstanding Statement
PDF Format Types, GL Accounts and Ledger records
- Populate all the required fields using the above PDF Format Types, GL Accounts and Ledger records that you created.
  
  Note: GL Defaults will be created automatically for Developer and Developer PRO after Ledger creation. When copying the Ledger objects after creation, in the event that none were created, access the Default GL Accounts screen, and click Create GL Defaults. You can create GL Defaults manually using the Create GL Defaults button on the Default GL Accounts screen.

Create the Accounting Settings record
1. Click the Gear icon and select Setup.
2. From the Quick Find textbox, enter Tabs.
3. Click New.
4. From the Object drop-down list select Accounting Settings.
5. Click the Tab Style, and select any style.
6. Click Next twice.
7. De-select the Include Tab checkbox.
8. Scroll down, and de-select the Append tab to users' existing personal customizations checkbox on the left.
9. Click Save. The Accounting Settings tab has been created.
10. Go to the App Launcher and enter Accounting Settings. Then, select it. The Accounting Settings list view displays.
  
  Note: Click here to view the above image in full screen.
  
  Best Practice: Open the Accounting Settings screen on your Production org and use the same information to set up the new one on the Sandbox org.
11. Click New. The New Accounting Settings dialog box displays.
12. Complete all of the required fields and any desired optional fields.
  Note: Required fields display with a red (*) asterisk. Additionally, if you have the Orders & Inventory package installed, while the Vouchers Payable GL Account, Inventory Variance GL Account, Work in Process GL Account, and the Default Purchase Order Format fields do not display as required fields, they will need to be completed.
13. Click Save.
Access the Default GL Accounts screen
1. Access the Default GL Accounts screen.
2. From the Ledger drop-down list, select the Ledger that you created.
3. click the Pencil icon to edit the page.
4. Complete any missing GL Account fields, as necessary.
5. Click Save.
  
  Note: After saving the Default GL Accounts page, you can go back to Setup | Tabs, and delete the Accounting Settings tab as this tab will no longer be needed.
Access the Default Ledger screen
1. Access the Default Ledger screen.
2. If you desired Default Ledger does not display, click the Pencil icon to edit the page.
3. Select your Default Ledger from the drop-down list.
4. Click Save.
Run the below query
1. Click the Gear icon and select Developer Console.
2. Select the Query Editor tab.
3. Copy/Paste the following query:
  
  Select ID, name, AcctSeed__Default_Ledger__c, AcctSeed__Legacy_Default_Ledger__c From AcctSeed__Accounting_Settings__c
4. Click Execute.
5. Double-click in the AcctSeed_Default_Ledger_c field. Then, copy/paste the value into the AcctSeed_Legacy_Default_Ledger_c field so that both display the same value.
6. Click Save Rows.
7. After saving the row, click Refresh. Verify that both values are the same. Otherwise, the org will not function correctly.
Populate the Bank Settings.
1. Access the Bank Direct Connect - Bank Settings screen.
2. If the Bank Settings information has not been populated for at least one Aggregation Provider, this information will need to be completed. Follow the steps in the Bank Direct Connect - Bank Settings article.

You will need to manually create trial data for the following:

Complete the required master data

Accounting Periods
At least one Account

Complete the following, as needed:

Accounting Variables
Contacts
Products
Opportunities
Projects
Billing Rates
Recurring Billings
Billings
Cash Receipts
Account Payables
Cash Disbursement Batches
Journal Entries

Note: If you need assistance, please contact our Customer Support.

Multi-Ledger Considerations

If the Accounting Seed multi-ledger feature has been enabled in production, then you may wish to copy each ledger to your sandbox. To copy more than one transaction ledger from production to a sandbox, the following conditions apply:

Settings and Ledger objects are selected for copying.
It is a Partial or Full sandbox (the sandbox can NOT be a Developer Pro or Developer sandbox).

Return to top

Title

Considerations for Creating Sandboxes With Accounting Seed

URL Name

240670494