Record to Report Prompts

Create Journal Entry

• Accounting Analyst

                    Use the ns_createRecord tool to create a journal entry with the following details:

Subsidiary: [SUBSIDIARY_NAME]
Date: [DATE]
Currency: [CURRENCY_ABBREVIATION]
Memo:

Debit:
Account: [ACCOUNT_NUMBER]
Description:
Amount:
Department: [DEPT_NAME]
Class: [CLASS_NAME]
Location: [LOCATION_NAME]
Entity: [CUSTOMER/VENDOR/EMPLOYEE]

Credit:
Account: [ACCOUNT_NUMBER]
Description:
Amount:
Department: [DEPT_NAME]
Class: [CLASS_NAME]
Location: [LOCATION_NAME]
Entity: [CUSTOMER/VENDOR/EMPLOYEE] 

                  

Create Intercompany Journal Entry

• Accounting Analyst

                    Use the ns_createRecord tool to create an intercompany journal entry with the following details:

Subsidiary 1: [SUBSIDIARY_NAME]
Date: [DATE]
Currency: [CURRENCY_ABBREVIATION]
Memo:

Autobalance (Y/N): [Using autobalance allows you to book only the debit or credit in each respective subsidiary, where NetSuite will automatically balance the entry in each subsidiary with the corresponding Intercompany Payable or Intercompany Receivable GL account]

Subsidiary 1: [SUBSIDIARY_NAME]
Debit:
Account: [ACCOUNT_NUMBER]
Description:
Amount:
Department: [DEPT_NAME]
Class: [CLASS_NAME]
Location: [LOCATION_NAME]
Entity: [CUSTOMER/VENDOR/EMPLOYEE]

Credit:
Account: [ACCOUNT_NUMBER]
Description:
Amount:
Department: [DEPT_NAME]
Class: [CLASS_NAME]
Location: [LOCATION_NAME]
Entity: [CUSTOMER/VENDOR/EMPLOYEE]

Subsidiary 2: [SUBSIDIARY_NAME]
Debit:
Account: [ACCOUNT_NUMBER]
Description:
Amount:
Department: [DEPT_NAME]
Class: [CLASS_NAME]
Location: [LOCATION_NAME]
Entity: [CUSTOMER/VENDOR/EMPLOYEE]

Credit:
Account: [ACCOUNT_NUMBER]
Description:
Amount:
Department: [DEPT_NAME]
Class: [CLASS_NAME]
Location: [LOCATION_NAME]
Entity: [CUSTOMER/VENDOR/EMPLOYEE] 

                  

Monitor & Approve Journal Entries

• Controller

                    Use the ns_runCustomSuiteQL tool to find a list of Journal Entries with a status of Pending Approval. The results should be presented as a table where each row represents a journal. The table will include the Document Number as a hyperlink to the journal entry in NetSuite, Date, Subsidiary, Memo, Created By user. 

Use the ns_updateRecord tool to update the status of [Document_Number] to be approved.