Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
  1. First thing that will need to be done is to create a CSV spread sheet with the required data.
  2. The headings need to be as followed in order as per below. 
    Product ID - This is the Product ID 
    Price Type - The way that contract prices are calculated for this product. I.E SpecificRetailInc
    Value - The effect of the value depends on the contract price type selected.

    Expand
    titleShow me

    For Price Types description please refer to below.

    Price TypeRequired Description on CSV
    Discount From Sell (Percentage)DiscountFromSellPercent
    Markup From CostMarkupFromCost
    Price LevelPriceLevel
    Specific Retail (Inc)SpecificRetailInc
    Discount From Sell (Value)DiscountFromSellValue
    Quantity MinimumQuantityMinimum
    Product DisabledProductDisabled
    GP From CostGrossProfitFromCost
    ReplaceReplace
    Specific Retail (Ex)SpecificRetailEx



    Info
    titleReplace Price Type

    When using replace price type the below example is how the layout is meant to look

    Expand
    titleShow me

     
  3. In the navigation panel, go to Relationships then Contracts.
  4. Click New (to create new contract). The Contract window displays. 


    Expand
    titleShow me

  5. Enter a name and a short description of the contract. The type and version number are filled in automatically by the system and cannot be changed.
  6. Enter the contract start and end dates.
  7. Click on "Import Products" on the top panel.

  8. Select the required CSV file and click open.

    Expand
    titleShow me

  9. On the Cards tab specify the contract to a customer or suppliers, or use the All Customers and/or All Suppliers checkboxes.
  10. Select a site.
  11. The Settings tab lets you specify quantity and value restrictions on the contract.

  12. When you have finished entering information, set the Workflow Status field in the header to Active.
  13. Click Save and Close to save and close the contract.

    Note

    Please test by performing a sale order or sale shipment to ensure the Values are working accordingly.