Skip to main content

We are looking into using Package Part with service contracts. When I try to add a package part as a billable invoice plan item, I do not get any hits in list of value for the parts. Is this a limitation, meaning package parts cannot be used with service contract?

 

 

@Pebano I have debugged this and noticed that the view that is used to fetch the possible values of the sales part for New Service Line assistant is sales_part_service_lov

SELECT 'SalesPart' luname,
                       'CATALOG_NO=' || catalog_no || '^' || 'CONTRACT=' ||
                       contract || '^' keyref,
                       contract contract,
                       catalog_no catalog_no,
                       catalog_desc catalog_desc,
                       list_price list_price,
                       list_price_incl_tax list_price_incl_tax,
                       rental_list_price rental_list_price,
                       price_unit_meas price_unit_meas,
                       gtin_no gtin_no
FROM sales_part_service_lov

Looking inside the sales_part_service_lov I could notice that it’s only selecting Non-Inventory Sales Parts (NON). Package parts are catalog_type = ‘PKG’, hence they’re not allowed.

SELECT contract                                                      contract,
       catalog_no                                                    catalog_no,
       Sales_Part_API.Get_Catalog_Desc(contract, catalog_no)         catalog_desc,
       list_price                                                    list_price,
       list_price_incl_tax                                           list_price_incl_tax,
       rental_list_price                                             rental_list_price,
       price_unit_meas                                               price_unit_meas,
       Part_Gtin_API.Get_Default_Gtin_No(catalog_no)                 gtin_no,
       rowkey                                                        objkey
FROM   sales_part_tab
WHERE  activeind = 'Y'
AND    catalog_type = 'NON'
AND    sales_type IN ('SALES', 'SALES RENTAL')

I hope this helps. Please mark this as solution if this is the explanation you were looking for.

Thanks for quick investigation. Then I guess using package parts for service contracts is not supported.

Reply


Terms & ConditionsCookie settings