Hello, is it possible to exclude kit and kit comp...
# arm
p
Hello, is it possible to exclude kit and kit components from a fair value price allocation? I am not seeing a way when auto expansion for revenue management is checked for a kit.
c
What's your goal here? Typically you use auto-expansion because you want components to be included in allocation. Do you want the kit to allocate to components but not with anything outside of the kit?
p
thats correct
I am looking to allocate the sales price just to the kit components
c
I don't believe that is possible if you have a kit and other things on the same arrangement. The choice to allocate or not is binary, you can't have two different allocation pools on the same arrangement.
p
ok. could I do this allocation among 3 non-inventory items? where the former kit parent gets $0 of allocated revenue
c
If you have 'auto-expand for revenue' checked, the kit parent ought to get $0 anyway.
You can control whether non-kit-component items participate in allocation by setting their Allocation Type to Exclude
p
unfortunately netsuite won't allow mixing and matching of exclude and normal on kit and kit components
c
I mean the other items sold alongside the kit
p
got it. do you think there would be a way to automate the allocation without manually intervening?
c
I'm not sure what you mean. You can either set up FV prices so it allocates the way you want automatically, or you can manually override calculated FV, but either way it's still allocating.
Honestly I think I'd need more detail to think out a possible solution, and there might not be one.
It depends a lot on what the behavior of the other items on the same SO as the kit should be, and if any items are both sold separately and used as kit components, etc
p
one of the items is sold separately but we need to allocate a portion to pay back to a partner
we need one of the components/items to be excluded from being allocated because its an expense item but we do not want the item billable to the customer since it is sold as a package
c
For the item sold separately, I don't think the allocation can handle that scenario. FV and allocation behavior is configured per item and doesn't allow the same item to be treated differently in different situations.
For the expense item...would it solve your problem if that item were always allocated $0 revenue? You can give that item a FV of 0 so it will never take any revenue.
p
possibly. so say the item is sold at $2,000. we need $1,600 to go to the cogs expense account. the remaining $400 would go through the normal revenue allocation process
c
I don't see a good way to do that.
p
Catherine, I have one more question. Is it possible to have an item sold to increase the expense account and decrease deferred revenue?
s
try revenue allocation groups. They can be defined on the item itself but if your item will not be part of 1 single group all the time then i suggest pulling that field onto the sales order line. That way all items within a group will only allocate with each other, disregarding any other allocation group which might be on the same transaction. So you can have a sales order with 10 lines First 5 lines are Allocation Group A Next 5 lines are Allocation Group B Group A lines will allocate amongst themselves and so will Group B without allocating between the 2 groups ( make sure to use a group sum formula in FVP)