Labour Cost Allocation SuiteApp Customization

Overview

About the Client

Our client is a trusted provider of cloud-based solutions, specializing in leveraging NetSuite business technology to foster organizational growth and success. They expertly guide their customers through meaningful digital transformations, ensuring seamless integration of new solutions with minimal disruption to daily operations. With a seasoned team that collaborates closely with customers, they tailor solutions to align precisely with each unique set of objectives. Their comprehensive services include NetSuite implementation, transformation, optimization, and ongoing support.

The challenge       

• The client utilized a SuiteApp to process employee timesheets within an Allocation Period, resulting in the creation of a Labor Expense Allocation record that influences the General Ledger.
• When timesheets involve intercompany relations, it creates a complex situation. A scenario where employees work for different subsidiaries or branches of the same company. These intercompany transactions can affect multiple entities within the organization.
• However, the challenge arises because there is no established mechanism to properly account for impact in the general ledger.

Our Solution 

• To address the issue, we developed a plan to provide a user interface resembling the SuiteApp via a Suitelet script. This interface, which users are accustomed to, facilitates the processing of timesheets and impacts the general ledger through the generation of an Advanced Intercompany Journal Entry.
• Upon selecting the Process link for a given Allocation Period, a scheduler is initiated. This scheduler processes all timesheets for that period, creating detailed line data that is then saved in a custom record. Subsequently, the Suitelet script retrieves this data from the custom record to create the Advanced Intercompany Journal Entry record.

Technology & tools used

Oracle NetSuite-

• Saved Searches
• Suitelet Script
• Map/Reduce Script
• Custom record

Results

The Impact and outcome   

• The client successfully impacted the general ledger for intercompany transactions by creating an Advanced Intercompany Journal Entry.
• This entry reflects the financial movement between different entities within the organization.
• The client is now aware of the most recent processing time for the Allocation Period.
• They have access to the Advanced Intercompany Journal Entry generated for that specific period.
• If a Journal Entry already exists for a specific period, and the Allocation Period is processed again, a new Journal Entry will be generated. The previous record will be deleted and replaced with the updated entry on the user interface (UI).