Record to Report Prompts

The Record to Report prompt samples include common tasks and workflows such as:

Journal entries with structured fields
Intercompany journal entries with structured fields
Monitoring and approving journal entries

Prompt Name	Suggested Roles	Prompt Sample
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.`

Prompt Name

Suggested Roles

Prompt Sample

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.

General Notices