Hello NetSuite Community,
My group is in the process of installing NSPB and is working with NetSuite Partner for this project.
Our partner pointed out that some of our Cost of Goods items are mapping to the Operating Expense section. They advised us to submit a help desk ticket to learn our options for fixing this without interrupting our regular reports.
Some background information:
Most of the current NetSuite users have been with the company for two years or less and were not involved in the setup.
My company has 3 sets of Costs of Services GL accounts. 1 set was configured correctly, with the Type = Cost of Sales. 2 sets were configured incorrectly, with Type = Expense, and they currently do not align in our NetSuite platform or NSPB:
1. Cost of Sales: GL # 501100 - Leave as is Classified as "Cost of Sales" under Type. Parent number assigned: 500000, Subaccount not assigned
2. Cost of Goods Sold - GL# 500000 - This is the Main Parent - Update Needed Classified as "Expense" under Type; it needs to be changed to "Cost of Sales".No Parent number and no Subaccount assigned.
3. Cost of Merchandise Sold: Parent GL # 560000 - Update Needed Classified as "Expense" under Type; it needs to be changed to "Cost of Sales".Subaccount of 500000 Cost of Good Sold and no Parent number assigned.
In our Income Statement reports, we have a custom rule that groups all those items together to show the true Cost of Sales total, followed by a custom calculation for Gross Profit. In NSPB, we prefer to fix issues at the root rather than writing a rule every time we create a custom report. How can we fix the incorrectly set up groups and have them all Classified as "Cost of Sales" under Type?
Ideally, we want to configure NetSuite correctly and put a solution in place that will not have a major impact on reports or other items in the system except for what is intended. Could you please recommend the best approach to translate to the NSPB setup so that all our COS/COG/COM are aligned in both systems? Thanks!