Hi, the topic might be already discussed, but unfortunately, I could not find any answer on the questions I have.

prerequisite:

  • I have CRM with my customers setup
  • I have Business Central Setup, and the Customers and Products are synced 
  • Leasing company which sells cars, insurance, km-packages

Setup (planned):

  • Product hierarchy 
    • Vehicles 
      • Mercedes
        • SLK 
        • CLK
        • E-Klasse
      • Citroen
        • C3
        • C4
        • C5
      • Peugeot
        • 208
        • 308
        • 2008
    • Insurance
      • Kasko 1
      • Kasko 2
    • Kilometers
      • 1500km/month
      • 2000km/month
      • 3000km/month

Questions:

  • where should I store parameters like engine type, suspension, fuel type, power, gearbox, group, color, vin, platenumbers etc.
  • how can I have a final item on a stock in BC (with VIN and all parameters from the above list) and include it in the invoice for the customer
  • can I have all the invoices to be stored in BC and sent on monthly basis, so customer who choose Citroen C3 with Kasko 1 and 1500km packet, will receive monthly invoice like:
    • VIN KB222323LKJNK7726 500$
    • Insurance Kasko1 100$
    • 1500km package 100$
    • altogether 700$

Please help.