Considerations for Creating Sandboxes With Accounting Seed

Overview 

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 ERP 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:

• 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 ERP 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 

1. Accounting Periods
2. At least one Account

Complete the following, as needed: 

1. Accounting Variables
2. Contacts
3. Products
4. Opportunities
5. Projects
6. Billing Rates
7. Recurring Billings
8. Billings
9. Cash Receipts
10. Account Payables
11. Cash Disbursement Batches
12. 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