- Transaction Documents Line Items Help
- Marketing Campaigns
- Upload Library
- Mail Shots
- Using HubSpot with Workbooks
- Introduction to Reporting
- Displaying Reports
- Creating Reports
- Reporting Explained
- Emailing Scheduled Reports
- Sharing Reports
- Using Formulae
- Introduction to Reporting
- Introduction to Transaction Documents
- Credit Notes
- Customer Orders
- Supplier Orders
- Contract Management
- Introduction to System Administration
- Users & Security
- Email & Integration
- PDF Configuration
If you cannot activate columns relating to tax (such as Tax Rate or Tax Amount), you need to make sure that a VAT number (ie, a sales tax number) has been entered on your Own Organisation record.
Your System Administrator can check and amend this for you.
- Invoicing for shipping charges
- Recommended practice for dealing with accidentally POSTED invoices
- Default Recipients in Email Templates
- What rules govern the ability to delete a DRAFT invoice?
- Related Items (ORD and INV)
- Pricing Scheme
- Creating a Report to show the revenue per Order for specific Products
- Importing Products
- How do I add to Products / list of Line items?
- Bringing your quotations alive with product pictures
- Applying discounts to a quotation
- Supplier Orders
- Creating Contracts
When creating a Transaction Document from scratch, you need to complete the top half of the record and click the Create button. You'll then see the Add Line Item button, which enables you to add as many Line Items as required.
Once you've added at least one Line Item, you can open the Analysis Reveal to see details on the sales and cost values, along with the gross margin. Each time you save the document (in DRAFT) these figures will be recalculated. NOTE: If the document has been created in a foreign currency, the reveal will show that currency as well as the Home Currency equivalent, based on the exchange rate for the period relating to the document date.
The columns available in the grids on Transaction Documents are listed below. Remember that these columns can be displayed or hidden as required and that the grid view can be saved so that the preferred layout is available to you each time you create or view a Transaction Document of the same type. If any custom fields have been created on Line Items for that Transaction Document type, they too will be available to view and populate.
A date field where you can record the delivery date for the Line Item.
Read-only calculated field showing the discount as a currency amount (ie, the net amount before discount minus the net amount).
When entering more than one Line Item you can control the order in which the lines are displayed. By default, they are displayed in the order in which they've been entered. To change this you can enter numbers in the Display Order column - the lowest number will appear first. You can use negative numbers to make a line appear before any that are shown with a Display Order number of 0. The changes will take effect when you click Save as Draft. The order you stipulate also controls the order in which the Line Items appear on any PDF output documents.
A read-only field, based on the difference in days between the Start Date and End Date allocated to the Line Item.
A date field that can be used to record the end date of a service or contract.
A read-only calculated field showing the gross value of the Line Item (ie, net amount plus the tax amount).
A description of or additional information about the product/service. If a product/service was chosen from the Product Book, the Line Description will show the description used in the Product Book, although this can be overwritten if required. If no product/service was chosen from the Product Book, you can manually enter a description.
A read-only calculated field showing the net price after any discount of the line item (ie, quantity multiplied by the unit price after discount).
Net Amount (Before Discount)
A read-only calculated field showing the net price before any discount of the line item (ie, quantity multiplied by the unit price).
Price Discount %
An optional discount percentage can be applied (which will alter any auto-calculated figures based on the (price). Because monetary values are affected by the rounding of decimal figures, discount can be applied to Line Items in one of two ways. By default the discount is applied to the unit price and the reduced price is multiplied by the quantity. If you'd prefer to apply the discount after the unit price has been multiplied by the quantity, you can change the settings within the Configuration area. Click here for information on this. This field is not currently available on Supplier Order documents.
(Not applicable to Supplier Orders.) If required a Pricing Scheme can be selected from the Pricing Schemes for the chosen product/service. If the scheme chosen is in a different currency from the document currency and there is an Exchange Rate set between the two currencies (ie, between the document currency and the pricing scheme currency) Workbooks will automatically convert the price for you. If a strict conversion is not appropriate you should consider setting up separate pricing schemes in each currency in which you sell the product/service.
A read-only field that shows the Product Category allotted to a Product. This is only populated when using a Product from your Product Book.
This is used to enter the number of units of the product/service on the line item being sold/ purchased/quoted/credited.
A date field that can be used to record the start date of a service or contract.
A picklist field that can be used to set the Line Item's state. A Line Item can be locked in by changing the state to Closed, enabling some Line Items to remain editable and others locked.
Supplier Ref Code
A read-only field displaying the supplier's reference code for the Line Item.
A Supply Scheme, on which you intend to base the Line Item can be selected so that gross margin calculations can be performed. You will immediately have visibility of the margins on a line by line basis. For Supplier Orders, you must choose a Supply Scheme that is based in the same currency as the order. If the document date is outside the scheme's validity period, the scheme will be listed in brackets.
A field to allow the slight adjustment (up or down) of the amount of tax applied to the transaction document. Only those users who have been given the appropriate Capability (ie, Edit Tax Adjustments) can make these amendments.
A read-only calculated field showing the Line Item tax amount as currency amount (ie, the net amount multiplied by the tax rate).
Read-only display field showing the percentage rate at which tax will be calculated on the line item net amount. The rate will be determined from the tax regime, tax code and tax point date.
A read-only calculated field showing the cost of the Line Item (ie, quantity multiplied by the unit cost).
A read-only field displaying the units in which the product is sold/purchased/quoted/credited.
Unit Price After Discount
A read-only field displaying the reduced unit price after any discount has been applied.