Skip to main content
Solved

Package Parts and service contract

  • January 17, 2024
  • 2 replies
  • 127 views

Pebano
Sidekick (Partner)
Forum|alt.badge.img+4

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?

 

 

Best answer by Marcel.Ausan

@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.

2 replies

Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • Answer
  • January 17, 2024

@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.


Pebano
Sidekick (Partner)
Forum|alt.badge.img+4
  • Author
  • Sidekick (Partner)
  • January 17, 2024

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