Import template for agreement contracts

You can use framework agreements to keep track of quantity and price agreement contracts with your customers and suppliers in tracezilla.

All relevant orders with the trading partner automatically gets tracked by the contracts, so you can monitor the fulfillment of the framework agreement continuously.

A framework agreement is a contract between supplier and customer, which covers a given time period and sets the conditions of following agreements. Framework agreements are often made when establishing a collaboration.

A framework agreement often includes:

• A specification of the the time period.
• Agreements regarding special situations, e.g. whether the agreement can be terminated, and if so, how (on what grounds) or force majeure, ie. discharge if one cannot deliver due to war, pandemics, strike, etc.
• Agreements regarding regulation / change in the agreement, and whether it is possible to deviate from the agreement, e.g. place an order that is not covered by the agreement.

Framework agreements can then result in individual agreements (purchase and sale agreements). The framework agreement itself will often be stated as an appendix to the individual agreements.

In tracezilla you can enter all your agreement contracts. The individual agreements contain information about what is to be delivered, where it is to be delivered, at what price and within what period.

You can get an overview of the progress of the individual contracts, which are calculated on the basis of your orders in tracezilla.

When adding contracts, you set up rules for which orders are to be included in the calculation, by specifying a limitation method of Stock Keeping unit, Tag of Stock Keeping Unit (a group of SKUs) or Revenue. You can also set up rules, so only specific orders are included.

Enable Agreement Contracts

Agreement Contracts is an tracezilla extension, available for subscribers of the Trade, Manufacturing or Bundle plans.

The extension is enabled as follows:

1. Click the company name in the upper right corner, and select Company Settings.
2. Click Extensions in the Extensions & Integrations menu.
3. Enable Agreement Contracs
4. Refresh you browser window.

The extension Agreement Contracts is now enabled, and is accessible in the drop-down menu when clicking Sales and Purchase in the top menu of the application.

Add Contract

When adding a contract in tracezilla, it can be done by two different methods:

1. Create a single or a few contracts directly in the application. You can use the tutorial here
2. Create multiple contracts by using the import template, as described below.

Add contracts by import template

When the extension Agreement Contracs is enabled in the application, you can add multiple contracts by using the import template. The template is an XLSX file,

1. Click Sales (for customer contracts) or Purchase (for supplier contracts) in the top menu, and select Contracts.
2. Click Import in the upper right corner.
3. Click Get Import Template, and save the file on your computer.
4. It is important that you do not edit column A (ID) or change the column names in the first row of the sheet.
5. When the data has been entered, the file must be be uploaded to the application. Do this by clicking Upload File and selecting the file on your computer.
6. tracezilla will now let you know, if there is an error in the entered data. Correct the error and try uploading again.
7. If you experience any problems when uploading your data, you can contact tracezilla Support. Please send an email, with the data file attached.