Kit - Stock Items - Sales Order Quote
We have customers using Stock Items that are Kits.
On the Sales Order Quote we would like to see what in depth components the Kit have. The data exist in the Kit Specifikations window IN209500 but I can't find it in the report designer for SO.
Does anyone know if it's possible to show it there?
Please give me a call I have a Kit Processing solution that might help you in what you are looking to do.
firstname.lastname@example.org / 818-484-5004
The kit specs are found in table InKitSpecStkDet table.
I was able to list components on the SO using a subreport, attached.
We have a client using the Kit Processing solution from BizTech. It provides a lot of options and allows you to explode the kit on the sales order.
If you are just looking to show the items on a form you would need to join to the Kit Header DAC (INKitSpecHdr) on the InventoryID where the status is Active. Then you could join to the INKitSpecStkDet and/or INKitSpecNonStkDet DACs to pull in the stock and non-stock components, respectively. Finally, you will need to either setup new grouping on the report or create a sub-report to show the kit components so that you don't duplicate data on the form.
Another option might be to write a subreport. Which would use the schema tables from the Kits and then blindly dump the contents of the kit.
You can then what you want to include.
A variable could be passed or added to the main SO Report to Explode detail of kits or not.
Add the subreport into the Sales Oder either in a detail line 2 or in detail line 1. Make visible base on variable passed.
When creating a subprogram, if you add it to the site control, you can then select versions and edit directly. Otherwise, you have to enter it in the report designer.