Fusion Testing
Test Cases
Pass/Fail Images
Sign In
TC-08123 : Sweep Automation
View related Pass/Fail Images
Process Area : F&A
Prerequisites
TC27 Set up links to bank accounts in Financial Institutions. TC28 Set up links to credit card accounts in Financial Institutions. TC1476 BAI2 manual bank file import
Steps To Execute
Step 1: Record a deposit for a cash inflow and setup a new autocreate rule for a deposit (cash inflow) Navigate to Transactions ; Bank ; Match Bank Data Select the applicable Bank Account. In this example we are using 110501 MIDFIRSTAP Checks Click on the checkbox to select the following imported bank transfer Date = 9/6/2024 Type = Transfer Amount = 3464 2. 15 Scroll down to the bottom of the page. Click on the link to Add Deposit. Enter the Date Memo Amount and Account for the Deposit. Click the Add button. Note that the Account would likely need to be some form of clearing account for a ZBA deposit or sweep between accounts as this transaction will only book one side of the sweep (deposit portion). The subsequent charge (cash outflow) portion of the sweep would need to be setup in a similar manner under the related bank account when performing match bank data. Scroll back down to the bottom of the Match Bank Data page. Mark the checkbox to "Make AutoCreate Rule From The Selected Transactions" and click the Match button. You will see a message in the upper right corner stating the following: Rule Creation Successful. AutoCreate Rule AutoCreate Transaction Rule for Intercompany Clearing Account has been created. To edit this rule go to the Reconciliation Rules page. To run this rule on your remaining transactions click the Run Reconciliation Rules button. To view the rule created navigate to Transactions ; Bank ; Reconciliation Rules. The new rule is visible under the User Rules section. Click on the rule name to view the rule. Review the information in the Conditions and Actions tabs. Step 2: Run a subsequent import to test the autocreate rule for the deposit (cash inflow). In this example we will import a new bank file on a subsequent day which contains another sweep. We expect the autocreate rule to create the deposit automatically upon submitting the import. Navigate to Transactions ; Bank ; Bank Import History ; Upload File; Choose a BAI2 file to import from your PC Under Import Options select the following: Click the radio button to Select a Financial Institution; Select Financial Institution = MidFirst Bank; Select Format Profile = BAI2 Click Import In the upper right corner a green box will appear. Click the link to track import status which will route you to the Bank Import History page. Sort Bank Import History page by Internal ID to view the most recent import. Verify that the bank import status is in Completed status. Navigate to the Match Bank Data page Select the Account and click on the Review subtab. Note that the new deposit from the most recent import is visible as matched. Note that the Tran No indicates "to be generated". The transaction is not fully created until all matches are submitted on this page. Click the Submit button to submit matches. You will see a message at the top of the page indicating NetSuite is confirming and clearing transactions. Navigate to Transactions ; Bank ; Make Deposits ; List. Sort by recently created and view the deposit created.
Expected Results
System Entries are created automatically and correctly