When processing a customer return, specifically a credit memo, NetSuite traditionally posts a debit entry to the income account assigned on the item record being returned. You may want to modify this behavior and have NetSuite post this debit to a different account. While this is not possible out of the box, NetSuite has developed the Sales Returning Accounting SuiteApp, which allows you to modify how the system posts these transactions to the general ledger. Let’s take a look at the SuiteApp, which is free, and walk through the setup process.
Required Features
The SuiteApp requires the following features to be enabled:
- Item Options
- Custom Records
- Custom GL Lines
Once these features are enabled, the SuiteApp can be installed by navigating to Customization > SuiteBundler > Search & Install Bundles. Search for Sales Return Accounting (ID 318158) and click install. The best practice here is to install it and test it in a Sandbox instance first, if one is available.
Role Permissions
Out of the box, the SuiteApp comes with an SRA Accountant role which has all the required permissions to use the SuiteApp. Specifically, the SRA Accountant role has the following permissions unique to the SuiteApp:
- Sales Returns Account Mapping (Found under the Custom Records tab)
This permission can be added to existing roles, or the role can be assigned to an employee.
Configure the Plug-in
The SuiteApp comes with a plug-in which must be enabled. This can be enabled by an Administrator by navigating to Customization > Plug-ins > Plug-in Implementations.
- Look for the Sales Return Accounting Custom GL Plugin and click View.
- Click Configure and select the transaction types and subsidiaries you want to enable the plugin for.
- Note: The SuiteApp currently supports Credit Memo and Cash Refund. Other transactions may or may not work as of when this blog is posted.
- Click Save.
Creating Return Account Mappings
To create return mappings, navigate to Lists > Custom > Sales Returns Account Mapping.
- Click New Sales Returns Account Mapping.
- Select the Subsidiary.
- Select the Sales Account you would like to modify GL impact for.
- Select the Sales Return Account you want to use.
- Click Save.
The mapping is ready to use at this point, and it is recommended to create test transactions in a Sandbox environment to verify the expected outcome before deploying the changes to Production. Keep in mind the SuiteApp will not modify the GL impact of transactions already created; it will only modify the GL impact of new transactions created going forward. That being said, have fun and we hope you found this overview helpful!
About Us
Concentrus is a leading provider of innovative cloud-based enterprise resource planning (ERP) solutions, including NetSuite. Our team of NetSuite experts offers a range of services, including NetSuite price analysis, NetSuite training, and NetSuite integration services.
Our goal is to help businesses of all sizes maximize their investment in NetSuite by providing expert NetSuite cost optimization and implementation strategies. With years of experience as a NetSuite partner, our NetSuite administrators and NetSuite consultants are well equipped to help businesses of all sizes with their NetSuite consulting needs.
Whether you're looking for a NetSuite consultant to help with your NetSuite implementation or you need ongoing NetSuite support, Concentrus is here to help.
Read About Our Implementation Methodology
Want more NetSuite Tips and Tricks? Check out our Short & 'Suite videos
