We have vendors who sell bundles of items, and als...
# general
s
We have vendors who sell bundles of items, and also the items individually. They sell us the bundles at a discount and insist that the POs we send them have the bundles on separate lines from any individual component orders. But when they send us the products, they just send them as components all together. Meeting these requirements is driving me insane. If we have the bundles as kits, then they are not itemised as bundles on the PO. If we have them as Inventory Items, they are not split into their components on the PO to be receipted. Assembly Items and Groups don't work. Has anyone solved a similar issue?
s
Just a thought but could you use an item group in combination with a column sublist flag that controls what prints on the PO pdf? Add a flag as a column field on the item sublist and choose to display the item group component items on transactions. When the component lines are added mark off the new flag field. In the PO output (you would have to be using an advanced pdf form) then you filter the items printed by the flag (where flag = No). That way you only print the item group header but can receive the component parts. You could probably take it one step further and script the flag to be automatically marked when the item group is added (or maybe source it some other way) I suggest this because I assume that the real issue is what outputs to the vendor vs. what can be received in NetSuite. I have no idea if this would work but conceptually something similar might.
s
Thanks Simon, I think the flag/hide-on-template will be the core of a solution if I can get the other things to stack up.