This topic contains 10 replies, has 0 voices, and was last updated by Olivier Gagnon NC 10 years, 11 months ago.
-
Posts
-
DobesJLGood Afternoon User Group,
We are attempting to breakout revenue into additional levels โ Question is can the additional levels be added on to current step-up with an import (table mapping)? Thanks in advance for your assistance and input.
Item: FSA
Description: Monthly Administrative Fee-FSA
Current Mapping – Level 1 4401 – RA-Tx-ACCLAIM
Level 2 Acclaim
Level 3 PAPM/PPPM
Level 4 PAPM (CDH)/PPPM
Level 5 Non-HSA
Level 6 FSA
Item: PE
Description: Production Engineer
Current Mapping – Level 1 4401 – RA-Tx-ACCLAIM
Level 2 Acclaim
Level 3 FTE
Level 4 Onshore
Level 5 FTE
Item: Tuition
Description: Company XYZ Tuition
Current Mapping – Level 1 4401 – RA-Tx-ACCLAIM
Level 2 Acclaim
Level 3 ERP
Level 4 Non-CDH
Level 5 Tuition
Best Regards,
Jeremy
Jeremy Dobes, CMA
Senior Financial Analyst | Acclaris, Inc. | o 813.873.2020 x1360:|Jeremy.Dobes@acclaris.com
This is a cached copy. Click here to see the original post. -
Olivier Gagnon NCRE: Revenue Hierarchy
If you’re talking about child accounts, then those can be pretty easily added.
However, you may have in mind something more akin to Class and Departments, that is to say a layer of information attributed to GL hits which the need for physical accounts.
Since this is Income, I’m tempted to think the latter would be more suitable, since if you simply add new accounts, you would need to create new items which would be a pretty invasive process.
If you simply add these levels as metadata to the GL impacts, it’ll require much less retooling of other processes.
-
DobesJLThanks Olivier for getting back to me so quickly; it is greatly appreciated! Can this information be uploaded with an ort file (table mapping for the levels)? Or would have to manually map the new fields? I only ask since we have quite a bit of new breakouts for the New Year.
-
Olivier Gagnon NCRE: Revenue Hierarchy
I’m not sure what you mean by “table mapping” and “mapping the new fields”. It might be a concept that does not translate well into NetSuite paradigm. Can you expand on what you mean by this step?
-
DobesJLRE: Revenue Hierarchy
Thanks for all your assistance today: I’ve included an example below:
Thank you for all your assistance today. I’ve attached Internal Id Mapping Table below: The goal of the additional levels is to drill down further so letโs use an example of $100 in 4401 broken out into 4 separate areas at Level 6 listed below. My hope is to be able to tie the internal ids to the future mappings and upload the tables for revenue fields to be mapped to by excel or csv.
Level 1 = $100
Level 2 = $100
Level 3 = $100
Level 4 = $100
Level 5 = $50 Non-HSA, $25 HSA, $25 Combo
Level 6 = $25 FSA, $25 HSA, $25 HSA, $25 Combo
Product 1
Internal ID 116
Name FSA
Display Name Monthly Administrative Fee-FSA
Description Monthly Administrative Fee-FSA
Type Non-inventory Item
Current Revenue Mapping Level 1 4401 – RA-Tx-ACCLAIM $25.00
Level 2 Acclaim $25.00
Level 3 PAPM/PPPM $25.00
Level 4 PAPM (CDH)/PPPM $25.00
Level 5 Non-HSA $25.00
Level 6 FSA $25.00
Product 2
Internal ID 127
Name HSA
Display Name Monthly Administrative Fee-HSA
Description Monthly Administrative Fee-HSA
Type Non-inventory Item
Current Revenue Mapping Level 1 4401 – RA-Tx-ACCLAIM $25.00
Level 2 Acclaim $25.00
Level 3 PAPM/PPPM $25.00
Level 4 PAPM (CDH)/PPPM $25.00
Level 5 HSA $25.00
Level 6 HSA $25.00
Product 3
Internal ID 122
Name HRA
Display Name Monthly Administrative Fee-HRA
Description Monthly Administrative Fee-HRA
Type Non-inventory Item
Current Revenue Mapping Level 1 4401 – RA-Tx-ACCLAIM $25.00
Level 2 Acclaim $25.00
Level 3 PAPM/PPPM $25.00
Level 4 PAPM (CDH)/PPPM $25.00
Level 5 Non-HSA $25.00
Level 6 HRA $25.00
Product 4
Internal ID 132
Name FSA+HSA
Display Name Monthly Administrative Fee-FSA & HSA
Description Monthly Administrative Fee-FSA & HSA
Type Kit/Package
Current Revenue Mapping Level 1 4401 – RA-Tx-ACCLAIM $25.00
Level 2 Acclaim $25.00
Level 3 PAPM/PPPM $25.00
Level 4 PAPM (CDH)/PPPM $25.00
Level 5 Combo $25.00
Level 6 Combo $25.00
Best Regards,
Jeremy
Jeremy Dobes, CMA
Senior Financial Analyst | Acclaris, Inc. | o 813.873.2020 x1360:
-
Olivier Gagnon NCRE: Revenue Hierarchy
Oooh, I see.
Well, NetSuite does not support what you are trying to do here, unfortunately.
It could be done as a custom thing using Journal entries, but it would be SUPER messy and I really don’t recommend it. Maybe a month-end process where you run a batch process, which at that point, it reclassifies all your income based on a given allocation schedule. That might work better, but I’d still recommend you drop this idea unless it’s REALLY important to you.
-
DobesJLOlivier -Thank you for your insights. I’ll investigate some additional work around. In your experience how long do enhancements like this take to work through the system? I won’t hold you to a timeline.
Enhancement # – 171915
Summary: Item Record > Allow editing of item’s account without having to reopen closed periods.
Best Regards,
Jeremy
-
Olivier Gagnon NCRE: Revenue Hierarchy
Enhancements in general take years. That particular enhancement has been around for several years. I doubt it will ever be released due to its logical and programmatic complexity.
-
DobesJLThank you Olivier – I’ll work towards the work around then in that case. Due to the complexity of the business I donโt think we can book the entries at the deeper levels but I can understand the issues around attempting to build this into a system. Iโm thinking best bet might be to tie revenue levels to the “internal id”. Hopefully, I can build in the “internal id” on the invoice level to export the data into excel on all invoices and pivot the data monthly.
Best Regards,
Jeremy
-
DobesJLGood Morning Olivier,
Quick question – is there a way to build a report that will export internal Id and revenue for the month or a given period?
Example of Internal ID from Above:
Internal ID 116
Name FSA
Display Name Monthly Administrative Fee-FSA
Description Monthly Administrative Fee-FSA
Type Non-inventory Item
Goal is to build out the Revenue Hierarchy in excel but unsure how to export the Internal ID codes and revenue tied to each code – Is this possible?
Best Regards,
Jeremy
-
Olivier Gagnon NCRE: Revenue Hierarchy
In a report – no.
In a Saved Search – yeah, super easy. Literally pull these columns out.
You must be logged in to reply to this topic.