| Button | Description |
|---|---|
| Process | Initiates the application process for the customer accounts that belong to the statement cycles you have selected by using the unlabeled check boxes in the table. |
| Process all | Initiates the application process for customer accounts that belong to all statement cycles displayed in the table. |
| Element | Description |
|---|---|
| Date | The date when an application is performed. By default, the current business date is displayed. The system records this date for each payment document or credit notes (if credit notes were included in the auto-application process) in the Date field on the top part of the Customer payments (AR302000) window. |
| Financial period | The financial period when the application is performed. The field is filled in automatically, based on the selected date. |
| Apply credit notes | This check box indicates (if selected) that the system includes credit notes in the application process. The balances of the open credit notes increase the balance that can be applied to outstanding documents. |
| Release batch when finished | This check box indicates (if selected) that the system releases batches with the application records when the process is complete. If you leave the check box cleared, when the process is complete, you need to release the application records manually for each payment document in the Customer payments (AR302000) window or by using the Release customer documents (AR501000) mass processing window. |
| Include child documents | An indicator of the types of documents that belong to any child customer accounts that should be processed, along with the documents of these customer accounts. The following options are available:
The option you select is used by the system for parent accounts that have child accounts with the Consolidate balance check box selected on the Invoicing information tab of the Customers (AR303000) window. This box is available if the Parent-child customer relationship functionality is enabled in the Enable/disable functionalities (CS100000) window. For details, see: Manage parent-child relationships - overview. |
| Column | Description |
|---|---|
| Cycle ID | The unique ID of the statement cycle. |
| Last statement date | The date when the statement was last prepared. |
| Description | The description of the statement cycle. |
| Next statement date | The date of the next statement, according to the cycle parameters. |
| Element | Description |
|---|---|
| Availability calculation rule | The unique ID of the availability calculation rule. You can use up to 10 characters, both numbers and letters. |
| Description | The description of the availability calculation rule. |
| Deduct qty. on open issues | If you select this check box, the system deducts (for items of the class) the quantities of issued items from the available quantities of these items. The documents in the On hold and Balanced statuses are used for availability calculation. |
| Deduct qty. on sales on hold | If you select this check box, the system will deduct the quantities of the item on sales orders (of the SO, IN, and CS types) with the On hold, Credit hold, Pending approval, and Rejected statuses from the available quantity. The quantity of each item on sales orders with these statuses is shown in the Sales order prepared field in the Inventory allocation details (IN402000) window. |
| Deduct qty. on sales orders | If you select this check box, the system will deduct (for items of the class) the quantities of items on sales orders with the Open status from the available quantities of these items. The item’s quantity on these sales orders is shown in the Sales orders booked field in the Inventory allocation details (IN402000) window. |
| Deduct qty. on shipments | If you select this check box, the system will deduct (for items of the class) the quantities of shipped items from the available quantities of these items. The item’s quantity on these sales orders is shown in the Sales orders shipped field in the Inventory allocation details (IN402000) window. |
| Deduct qty. allocated | If you select this check box, the system will deduct (for items of the class) the quantities of items being prepared for shipping (on unconfirmed shipments) and the quantities that were specifically allocated for sales orders (of the SA and SO types) from the available quantities of these stock items. The orders with the On hold, Credit hold, Rejected, Pending approval, and Open statuses are used for this calculation. The item’s quantity on these sales orders is shown in the Sales orders allocated field in the Inventory allocation details (IN402000) window. |
| Deduct qty. of kit assembly demand | If you select this check box, the system will deduct (for items of the class) the quantities of items allocated for kit assembly from the available quantities of these items. The documents with the On hold and Balanced statuses are used for availability calculation.
Note
This check box is available only if the Kit assembly functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Deduct qty. on back orders | If you select this check box, the system will deduct (for items of the class) the quantities of items allocated to sales orders with the Back order status from the available quantity of these items. The quantities on these sales orders are shown in the Back orders field in the Inventory allocation details (IN402000) window. |
| Include qty. on receipts | If you select this check box, the system will include (for items of the class) the quantities of items on inventory receipts (with On hold and Balanced statuses) in the available quantities of these items. |
| Include qty. in transit | If you select this check box, the system will include (for items of the class) the quantities of items in transit in the available quantities of these stock items. The documents with the On hold and Balanced statuses are used for availability calculation. |
| Include qty. on purchase order receipts | If you select this check box, the system will include (for items of the class) the quantities of items on unreleased purchase receipts in the available quantities of these items. |
| Include qty. on purchase on hold | If you select this check box, the system will include (for items of the class) the quantities of items on purchase orders (with the statuses of On hold and Pending approval ) in the available quantities of these items. The item quantity in the purchase orders with the On hold and Pending approval statuses is shown in the Purchase prepared field in the Inventory allocation details (IN402000) window. |
| Include qty. on purchase orders | If you select this check box, the system will include (for items of the class) the quantities of items on open purchase orders in the available quantities of these items. The item quantity in the purchase orders with the Open status is shown in the Purchase orders field in the Inventory allocation details (IN402000) window. |
| Include qty. of kit assembly supply | If you select this check box, the system will include (for items of the class) the quantities of items that are kits and listed in the kit assembly documents in the available quantities of these items.
Note
This check box is available only if the Kit assembly functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Include qty. on returns | If you select this check box, the system will include (for items of the class) the quantities of items on return orders and on shipments with the Receipt operation selected (in the Shipments (SO302000) window) in the available quantities of these items. In particular, quantities are affected as follows:
Thus, the quantities on shipments with the Receipt operation decrease the Total deduction quantities in the Inventory allocation details (IN402000) window. |
| Button | Description |
|---|---|
| Process all | Initiates commission processing for the period. |
| Review commission period | Navigates to Close commission period (AR506500) window so that you can close the period for which commissions have been prepared. |
| Element | Description |
|---|---|
| Commission period | The period for which commissions should be collected. Commission periods are set in the Customer ledger preferences (AR101000) window. |
| Status | The status of the commission period. You can prepare commissions only for an open period. |
| From | The start date of the commission period. |
| To | The end date of the commission period. |
| Column | Description |
|---|---|
| Salesperson ID | The identifier of the salesperson whose commission is shown in the line. |
| Name | The name of the salesperson as it was specified in the Salespersons (AR205000) window. |
| Documents | The number of documents involved. |
| Commissionable amount | The total amount of the documents that commission calculation was based on. |
| Commission amount | The total amount of commissions for the salesperson during the specified period. |
| Average commission % | The average commission percent on the documents during the specified period. |
| Minimum commission (%) | The minimum commission percent during the specified period. |
| Maximum commission (%) | The maximum commission percent during the specified period. |
| Element | Description |
|---|---|
| Calculate | Finds the overdue documents that meet the selection criteria and calculates the amounts of overdue charges for the documents in accordance with the overdue charge code settings in the Overdue charges (AR204500) window. |
| Process | Processes the overdue charges for the documents you have selected, creating new customer ledger documents of the Overdue charge type with the Balanced or On hold status depending on the value of the Hold documents on entry check box in the Customer ledger preferences (AR101000) window. |
| Process all | Processes the overdue charges for all the listed documents, creating new customer ledger documents of the Overdue charge type with the Balanced or On hold status depending on the value of the Hold documents on entry check box in the Customer ledger preferences (AR101000) window. |
| View last charge | Navigates to the Sales invoices (AR301000) window and displays the details of the unreleased overdue charge document that had been generated for the selected overdue document. |
| Element | Description |
|---|---|
| Overdue charge date | The date when overdue charges are calculated and appropriate documents are created. |
| Period | The financial period to which the document’s transactions should be posted. |
| Statement cycle | The statement cycle for which you want to display data. Leave the field blank if you want to calculate charges for all cycles. If the Set default overdue charges by statement cycle check box is selected in the Customer ledger preferences (AR101000) window, you must specify the statement cycle. |
| Customer class | The customer class for which you want to display data. The field is available if the Set default overdue charges by statement cycle check box is cleared in the Customer ledger preferences (AR101000) window. |
| Customer | The customer account for which you want to display data. The field is available if the Set default overdue charges by statement cycle check box is cleared in the Customer ledger preferences (AR101000) window. |
| Element | Description |
|---|---|
| Included | An unlabelled check box that you select to include the document for processing. |
| Type | The type of customer ledger document for which overdue charges were calculated: Invoice, Debit note, or Overdue charge. |
| Reference no. | The reference number of the document, which was assigned by a number series. By clicking the number, you can navigate to the Sales invoices (AR301000) window, where you can view document details. |
| Date | The date of the document. |
| Due date | The date when payment for the document is due, in accordance with the payment terms. |
| Customer | The customer for whom this document is intended, by its ID. |
| Customer name | The customer’s complete name as it appears in the system. |
| Currency | The currency of the original document. |
| Amount | The amount of the original document. |
| Open balance | The amount of the original document to which payments were not applied. |
| Last payment date | The date of the last applied payment. |
| Last charge date | The date of the last overdue charge document generated for this document. |
| Overdue days | The number of days this document is past due since its due date or, if overdue charges were previously calculated, since the last charge date. |
| Charge currency | The currency used for the overdue charges. |
| Charge amount | The amount of the charge. |
| Branch | The branch as retrieved from the Branch field on the Financial details tab in the Sales invoices (AR301000) window. This column is available only if the Multi-branch support functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Button | Description |
|---|---|
| Release | Releases balanced cash sale documents. |
| Reverse | Generates a cash return document with transactions reversed with respect to the original document. If a processing centre confirms voiding or refunding, the system marks the cash return document as Closed. |
| Actions | Provides the following menu commands, which you can click to invoke actions:
|
| Inquiries | Provides the Customer details menu command, which you can click to quickly navigate to the Customer details (AR402000) inquiry window. |
| Reports | Provides the following menu commands, which you can click for quick access to reports:
|
| Element | Description |
|---|---|
| Type | The document type. The following types are available:
|
| Ref.no | The reference number of the document, as automatically generated by the system in accordance with the number series assigned to cash sales in the Customer ledger preferences (AR101000) window. |
| Status | The status of the document, which is one of the following:
|
| Hold | A check box that indicates (if selected) that the document is a draft and has the On hold status. Such a document may be edited and cannot be released. |
| Date | The date when the customer ledger document was created. By default, for a new document, it is the current business date, but the date may be changed. |
| Post period | The period to which the document should be posted. By default, it is the current period, but the period can be changed. The ability to post to closed periods is controlled by the Allow posting to closed periods check box in the General ledger preferences (GL102000) window. |
| Payment ref. | The reference number of the customer payment. |
| Invoice text | Any user-provided description of the cash sale document. |
| Customer | The customer associated with the document. |
| Location | The relevant customer location. |
| Payment method | The payment method used by the customer to pay for the invoice. |
| Description | The description of the payment method. |
| Cash account | The cash account debited as a result of the cash sale transaction. |
| Currency | The currency of the document. Initially, it is the customer’s default currency, but you can change it if the Allow currency override check box is selected in the Customers (AR303000) window for this customer. To view or change the exchange rate, click the second field, which contains the exchange rate, to invoke the Rate selection dialog box. |
| Project | The project with which this document is associated, or the code indicating that this document is not associated with any project; the non-project code is specified in the Project accounting preferences (PM101000) window. This field appears only if the Customer ledger workspace has been integrated with the Projects module in the Project accounting preferences (PM101000) window. |
| Detail total | The document total, as calculated for all items on the Document details tab. |
| VAT taxable total | The document total that is a subject to value-added tax (VAT). This field is available only if the VAT reporting functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| VAT exempt total | The total VAT amount that is exempted from charging. This field is available only if the VAT reporting functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| VAT total | The document VAT amount; the details are shown on the VAT details tab. |
| Balance | For an open customer ledger document, the balance after any cash discount was taken. |
| Rounding diff. | The difference between the original document amount and the rounded amount. The field appears only if the Invoice rounding functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Payment amount | The amount of the customer payment. |
| Cash discount taken | The cash discount amount that has been or will be taken on the document, which the system calculates based on the specified payment terms. If a document has the On holdor Balanced status, you can change the amount of the calculated cash discount. If you change the cash discount amount, the system recalculates the taxable and VAT amounts of the document if the applied taxes have Calculate on set to Calc. on item amount or Calc. on document amount and Cash discount set to Reduces taxable amount in the VAT (TX205000) window. Changes you make to the cash discount amount do not affect the taxable and VAT amounts of the document if the applied taxes have Calculate on set to Extract from item amount and Cash discount set to Reduces taxable amount in the VAT window. |
| Finance charges | The total on all finance charges applied to this document. |
| Deducted charges | The total amount of the bank charges that were deducted by the bank from the payment amount on the cash account. Even if the charges were actually deducted by the bank, the original payment amount is shown in the top part. |
| Button | Description |
|---|---|
| View schedule | Navigates to the Deferral schedule (DR201500) window and displays the details of the schedule for the selected line of the document (if any different deferral codes were assigned to different lines of the document in the Deferral code column). |
| Column | Description |
|---|---|
| Branch | The branch that sells the line item or provides theservice. |
| Item ID | The item ID of the line item, if applicable. Only anon-stock item can be selected. |
| Transaction descr. | Any brief comment relevant to the transaction. The alphanumeric string may contain up to 30 characters. |
| Quantity | The quantity of items (goods or services) of a particular type sold to the customer. |
| UoM | The unit of measure (UoM) for the item. |
| Unit price | The price set for the item with respect to the specified unit. |
| Manual amount | A check box that indicates (if selected) that the discount has been applied manually. With this check box selected, you can enter either the discount percent or the discount amount. This column is available only if the Customer and supplier discounts feature is enabled in the Enable/disable functionalities (CS100000) window. |
| Discount percent | The percent of the discount that has been applied manually. If the Manual discount check box is selected, you can enter the percent manually and the discount amount will be calculated automatically. |
| Discount amount | The amount of the line-level discount that has been applied manually to this line. If the Manual discount check box is selected, you can enter the discount amount manually and the discount percent will be calculated automatically. |
| Amount | The amount after the discount has been applied. |
| Manual discount | A check box that indicates (if selected) that the discount has been applied manually. With this check box selected, you can enter either the discount percent or the discount amount. This column is available only if the Customer and supplier discounts functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Account | The sales account used for the transaction. See also: About suggested sales accounts. |
| Subaccount | The corresponding subaccount used for this transaction. |
| Project task | The particular task of the project with which this document line is associated. This column appears if the Projects module has been activated and integrated with this workspace. |
| Salesperson ID | The salesperson responsible for the sale. |
| Original deferral schedule | A read-only column filled in by the system in the Cash return documents created by the reversing process. It shows the identifier of the deferral schedule associated with the original Cash sale document.
Note
If a Cash return document is created manually, then you can select a deferral schedule to be reversed. In the original documents, this column remains empty. |
| Deferral code | The deferral code assigned to the line item, if any.
Note
Only active deferral codes are shown in the lookup. If you manually enter an inactive code, you will get an error message that the code is inactive. |
| Term start date | The start date of the term. |
| Term end date | The end date of the term. |
| VAT category | The VAT category (if applied) for the transaction. The category represents the type of goods or services. See also: About suggested VAT categories. |
| Commissionable | A check box that indicates (if selected) that commission is paid on the line item amount. The column is available if the Commissions functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Element | Description |
|---|---|
| Batch no. | The ID of the batch that updates the appropriate account balances with the amounts of the document transactions on posting. |
| Branch | The branch with which this document is associated. |
| Customer ledger account | The asset account specified as the default account for the customer. |
| Customer ledger sub. | The corresponding subaccount used for the customer. |
| Original document | The original document in general ledger. |
| Element | Description |
|---|---|
| Terms | The payment terms used in relations with the customer. |
| Cleared | A check box that indicates (if selected) that the cash sale has been cleared with the bank. |
| Clear date | The date when the cash sale document has been cleared with the bank. |
| Batch deposit | A check box that indicates (if selected) that the cash sale should be deposited. You can change this option if the status of cash account has been changed. Deposits can be performed only from a clearing account. |
| Deposited | A check box that indicates (if selected) that the cash sale has been deposited. |
| Batch deposit date | The date when the cash sale was deposited. |
| Batch deposit no. | The reference number of the batch deposit that includes this cash sale. |
| Element | Description |
|---|---|
| Customer VAT zone | By default, the VAT zone associated with the customer location, as specified in the Customer locations (CR303010) window. If this VAT zone is not specified, it is the VAT zone assigned to the selling branch. |
| Element | Description |
|---|---|
| Work group ID | The work group associated with the document, if any. |
| Owner ID | The employee who owns (is responsible for) the document. |
| Element | Description |
|---|---|
| Override address | A check box that indicates (if selected) that the invoicing address is not the default invoicing address of the customer. |
| Address 1 | The first line of the invoicing address. |
| Address 2 | The second line of the invoicing address. |
| Postcode | The postal code for the invoicing address. An input mask for postal codes be set in the Countries/counties/postcodes (CS20400S) window. |
| City | The city of the customer’s invoicing address. |
| Country | The customer’s country. |
| County | The state or province of the customer. |
| Element | Description |
|---|---|
| Override contact | A check box that you select to override the default contact information and type new information in the following elements. |
| Business name | The name of the business. |
| Attention | The department or person to be noted on the attention line, if this line is used by your company. |
| Phone 1 | The phone number of the contact person. |
| The email address of the contact person. |
| Element | Description |
|---|---|
| Printed | A check box that indicates (if selected) that the document was printed. |
| Emailed | A check box that indicates (if selected) that the document was emailed. |
| Do not print | A check box that indicates (if selected) that this document should not be sent to the customer as a printed document. |
| Do not email | A check box that indicates (if selected) that this document should not be sent to the customer by email. |
| Column | Description |
|---|---|
| VAT ID | The identifier of a VAT applied to the document. |
| VAT rate | The VAT rate of the VAT. |
| Taxable amount | The taxable amount for the VAT, calculated at the document level. |
| VAT amount | The VAT amount for the specific VAT, calculated at the document level. |
| Element | Description |
|---|---|
| Default salesperson | The identifier of a salesperson to be used by default for each invoice line. |
| Total commissionable | The total amount used to calculate commissions for all salespersons involved. |
| Commission amt. | The total amount of commissions on the document. |
| Column | Description |
|---|---|
| Entry type | The charge, selected by its entry type ID. You can select the entry type from the list of entry types associated with the cash account. |
| Description | A detailed description of the entry type to be used as finance charge. |
| Offset account | The account that is used for this finance charge. |
| Offset subaccount | The corresponding subaccount for this finance charge. |
| Amount | The amount of the finance charge. |
| Button | Description |
|---|---|
| Process | Click this to change the column information of the customer(s) you have selected in the table. |
| Process all | Click this to change the column information of all customers that are displayed in the table, according to the filter you have set in the top part of the window. |
| Element | Description |
|---|---|
| Customer class | The customers included in the customer class selected here will be displayed in the table. |
| Status | The customers whose status is accordant with the status you select here will be displayed in the table. |
| VAT zone ID | The customers whose VAT zone is accordant with the VAT zone you select here will be displayed in the table. |
| Element | Description |
|---|---|
| Change column information | Select the column you want to change. The options are:
|
| New customer class | When you select Customer class as the column you want to change, here you can select the new customer class to which you want to change. |
| Update the customer’s settings with the customer class defaults | When you select Customer class as the column you want to change, you can select this check box if you want to update the customer’s settings with the default settings of the new customer class. |
| New VAT zone ID | When you select VAT zone as the column you want to change, here you can select the new VAT zone ID to which you want to change. |
| Column | Description |
|---|---|
| Customer no. | The ID of the customer. |
| Customer name | The name of the customer. |
| VAT zone | The current VAT zone of the customer. |
| Location ID | The location ID of the customer. |
| Address | The address of the customer. |
| Postcode | The postcode of the customer. |
| City | The city of the customer. |
| Country | The country of the customer. |
| Corporate ID | The corporate ID of the customer. |
| Attention | The attention line as it is used in your company’s business letters, which would be used to direct the letter to the proper person if the letter is not addressed to any specific person. Inherited from the customer details in the Customers (AR303000) window. |
| Phone 1 | The phone number of the customer. |
| The email of the customer. | |
| Last sale | The date when the last sale was made to the customer. |
| Status | The status of the customer. |
| Customer class | The customer class to which the customer belongs. |
| Exclude EC sales list | When this check box is selected, the customer on the row and their transactions will not be included in the EC sales list. |
| Button | Description |
|---|---|
| Actions |
|
| Element | Description |
|---|---|
| Commission period | The period for which commissions should be calculated. Commission periods are defined in the Customer ledger preferences (AR101000) window. |
| Status | A read-only box that displays the status of the commission period. The following values are used:
|
| From | A read-only field that shows the start date of the commission period. |
| To | A read-only field that shows the end date of the commission period. |
| Column | Description |
|---|---|
| View details | Navigates to the Commission details (AR403000) window so you can view the details of the commission for the selected period. |
| Salesperson ID | The unique ID of the salesperson whose commission is shown in the row. |
| Type | The type of the salesperson, which can be one of the following options: Supplier or Employee. This column is available only if the Payroll functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Name | The name of the salesperson as it was specified in the Salespersons (AR205000) window. |
| Commissionable amount | The total amount of the documents that was used as the base for commission calculation. |
| Commission amount | The total amount of commissions for the salesperson during the specified period. |
| Payroll processed date | The date when the commission was processed in the Payroll module. Available only if the Payroll functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Button | Description |
|---|---|
| Close periods | Initiates the process of closing the selected financial periods.
Note
The green OK icon appears if the closing operation was completed successfully. The red icon indicates that the operation was cancelled because some necessary conditions were not met. |
| Unreleased documents | Opens the Unreleased customer ledger document report so you can view documents that are not released in the selected period (documents that have On hold, Balanced, Pending print, or Pending email status). |
| Column | Description |
|---|---|
| Period | The identifier of the financial period. |
| Description | The description of the financial period. |
| Active | A check box that indicates (if selected) that the financial period is active. |
| Element | Description |
|---|---|
| Salesperson ID | The salesperson whose commission details you want to view. Leave this field blank to view the commissions for all salespersons. |
| Commission period | The commission period for which you want to display data. Periods are configured in the Customer ledger preferences (AR101000) window. |
| Customer | A customer associated with the salesperson. You can select a customer from the list or leave the field blank to view documents for all customers. |
| Location | The customer location related to the sales, if a customer has been specified. |
| Column | Description |
|---|---|
| Doc. type | The type of document. If the commission is calculated on open invoices, it is a type of invoice document ( invoice or note ). If the commission is calculated on payments, it is one of the payment document types. |
| Ref. no. | The identification number of the document for which the commission is calculated. Click the link to view the details of the document. |
| Original doc. type | If the commission is calculated on payments, this is the type of the invoice document on which the specified payment is based. If the commission is calculated on open invoices, this column is empty. |
| Original ref. no. | The identification number of the invoice document on which the specified payment is based. Click the link to view the details of the document. |
| Doc. amount | The document amount. |
| Commissionable amount | The amount that was used as a base for commission calculation. |
| Commission (%) | The commission percent used for the document. |
| Commission amount | The commission amount earned by the salesperson on the document. |
| Customer no. | The customer to whom the goods or services were sold. |
| Customer name | The name of the customer as it is stored in the system. |
| Location | The customer location related to the sales. |
| Location name | The name of the customer location. |
| Element | Description |
|---|---|
| Contract item | The unique identifier of a contract item specified in accordance with the CONTRACTITEM segmented key. |
| Description | A description of the contract item, with any relevant comments. |
| Element | Description |
|---|---|
| Maximum allowed quantity | This is the maximum quantity of the contract item that a customer may buy under the contract. |
| Minimum allowed quantity | This is the minimum quantity of the contract item that a customer may buy under the contract. |
| Default quantity | This is the contract item quantity included by default. It can be overridden within the allowed limits for the item in a contract template and a contract based on this template. |
| Currency ID | The currency of the item price. You should use contract items priced in the same currency in one template. |
| Setup price | A read-only field that displays contract item price for setup, calculated based on settings configured under the Setup and renewal section. |
| Recurring price | A read-only field that displays contract item recurring price, calculated based on settings configured under the Recurring invoicing section. |
| Extra usage price | A read-only field that displays contract item price for extra usage, calculated based on settings configured under the Recurring invoicing section. |
| Renewal price | A read-only field that displays contract item price for renewal, calculated based on settings configured under the Setup and renewal section. |
| Element | Description |
|---|---|
| Setup item | The unique alphanumeric identifier of a non-stock item to be provided on a contract setup. |
| Setup pricing | The setup item pricing policy. The following options are available:
|
| Item price/percent | The setup item price or percent to be applied to the non-stock item price. |
| Retain rate | A percent of deposit original amount. The system displays a warning on a contract screen when deposit balance gets to the percentage point. |
| Deposit | A check box that, if selected, indicates that the contract item is treated as a deposit. |
| Refundable | A check box that, if selected, indicates that the setup price of the contract item is refundable. |
| Prorate setup | A check box that, if selected, indicates that the setup price of the contract item is invoiced in proportion to unused services in case of contract terms change. |
| Renewal item | The unique alphanumeric identifier of a non-stock item to be provided on a contract renewal. |
| Collect renewal fee on activation | A check box that, if selected, indicates that a customer is invoiced for item renewal in the first invoicing period. |
| Renewal pricing | The renew item pricing policy. The following options are available:
|
| Item price/percent | The renew item price or percent to be applied to the non-stock item price. |
| Element | Description |
|---|---|
| Invoice type | The recurring invoicing policy. The following options are available:
|
| Recurring item | The unique identifier of a non-stock item customer is invoiced for recurrently. |
| Reset usage on invoicing | A check box that, if selected, indicates that contract item usage is reset after the invoicing for a previous invoicing period has been performed. |
| Recurring pricing | The recurring item pricing policy. The following options are available:
|
| Item price/percent | The recurring item price or percent to be applied to the non-stock item price. |
| Extra usage pricing | The recurring item pricing policy. It is applied to service price if customer exceeded service included quantity. The following options are available:
|
| Item price/percent | The price for recurring item extra usage or percent to be applied to the non-stock item price. |
| Deposit item | The unique identifier of a deposit assigned to the non-stock item customer is invoiced for recurrently. |
| Column | Description |
|---|---|
| Contract template | The unique alphanumeric identifier of a contract template. |
| Description | The contract template description. |
| Column | Description |
|---|---|
| Contract ID | The unique alphanumeric identifier of a contract. |
| Customer | The customer associated with the contract. |
| Status | The contract status. For details, see: Customer contracts (CT301000). |
| Setup date | The date of the contract setup. |
| Expiration date | The date when contract expires. |
| Description | The contract description, which includes any related comments. |
| Element | Description |
|---|---|
| Contract template | The unique identifier of the contract template, which is specified in accordance with the TMCONTRACT segmented key. |
| Description | A description of the contract template, with any relevant comments. > [!NOTE] > This field supports the multi-language functionality, where you can translate the entered text to multiple languages. For more information, see: About multi-language support |
| Active | A check box that indicates (if selected) that the template is available for selection. |
| Element | Description |
|---|---|
| Contract type | The type of contract to be based on this template, which can be one of the following options:
|
| Duration | The duration of the contract, in the specified units. Select the number of units, and select one of the following units in the adjacent field: Year, Quarter, Month, or Custom (days). |
| Refundable | A check box that indicates (if selected) that recurring charges are to be refunded in proportion to unused services, but the setup and renewal fee is to be refunded according to the settings defined for each involved contract item in the Contract items (CT201000) window. |
| Refund period | The number of days after the contract setup date the customer may claim a refund. |
| Mass renewal | A check box that indicates (if selected) that the contract is available for mass processing and is to be displayed in the Renew contracts (CT502000) window starting on the date that is the number of days before expiration specified in the Renewal point field. The check box provides a default value for the contracts to be based on the template. |
| Renewal point | The number of days before the contract expiration date when the system starts to display the contract in the Renew contracts (CT502000) window if the Mass renewal check box is selected for the contract. The fields provides a default value for the contracts to be based on the template. |
| Grace period | The period of time (in days) after the contract expiration date when services under a contract are provided and the contract can be renewed according to its type. After the end of the grace period, you cannot renew the contract. If you invoke the Renew contract action in the Customer contracts (CT301000) window after the grace period, the system creates a copy of the contract with the Draft status. The field provides a default value for the contracts to be based on the template. |
| Currency | The currency to be used for invoicing the customer. |
| Enable template item override | A check box that indicates (if selected) that the list of contract items included in the template can be changed for each contract based on this template. |
| Automatically release customer documents | A check box that indicates (if specified) that the customer documents generated in the process of contract invoicing will be released automatically; otherwise, they will have the Balanced status. |
| Effective from | The date when the template starts to be available for new contracts that you want to base on it. |
| Discontinue after | The date after which the template becomes unavailable for selection when you create a new contract. |
| Element | Description |
|---|---|
| Invoicing period | The invoicing period for the contracts based on the template. The following options are available: Week, Month, Quarter, Half a year, Year, Statement-based, and On demand. The On demand option means that invoicing is not scheduled and you can invoice a contract on any date; this option cannot be used with contract items that have recurring pricing configured, except for items that are tied up with a deposit item or have a default quantity of zero. For details on deposit contract items, see: About retainer contracts. |
| Invoice to | The customer account to be billed for a contract. The following options are available: Parent account, Customer account, and Specific account. |
| Invoicing schedule starts on | The starting point of the invoicing schedule: Setup date or Activation date. The contract expiration date is calculated based on this setting. |
| Invoicing format | The format of an invoice that is issued as a result of contract invoicing. The following options are available:
|
| Invoice description | In this field, you can specify the formulas for invoice descriptions by using the standard formula editor. For more information about formulas, see: About formulas. |
| Line description | In this field, you can specify the formulas for line descriptions by using the standard formula editor. For more information about formulas, see: About formulas. |
| Element | Description |
|---|---|
| Case count item | The non-stock item used for counting cases associated with the contract based on this template. For details, see: Set up invoicing by the number of cases. |
| Column | Description |
|---|---|
| Item code | The unique alphanumeric identifier of the contract item. |
| Description | A read-only field that shows the description of the contract item. |
| Quantity | The quantity of the contract item that is included by default in a contract based on this template. You can modify this quantity within the allowed limits set for the contract item in the Contract items (CT201000) window. If you plan to use the template for creating retainer contracts or contracts that are invoiced on demand and add to the template some recurring contract items, we recommend that you specify a quantity of zero. |
| Setup price | A read-only box that shows the fee of the item to be invoiced on contract setup. |
| Recurring price | A read-only field that shows the fee for the included quantity of the item to be invoiced recurrently. |
| Extra usage price | A read-only field that shows the fee of the item to be invoiced as extra usage of the item. |
| Renewal price | A read-only field that shows the fee of the item to be invoiced on contract renewal. |
| Column | Description |
|---|---|
| Contract ID | The unique alphanumeric identifier of the contract based on this template. |
| Customer | The customer associated with the contract. |
| Status | The contract status, which can be Draft, Pending activation, Active, Expired, Cancelled, or Pending upgrade. |
| Setup date | The date of the contract setup. |
| Expiration date | The date when the contract expires. |
| Description | The description provided for the contract. |
| Column | Description |
|---|---|
| Attribute ID | The attribute name. |
| Description | The description of the attribute. |
| Sort order | A number representing the position of the attribute in the resulting list of attributes. |
| Required | A check box that indicates (if selected) that the user must provide a value for the attribute. |
| Internal | A check box that indicates (if selected) that the attribute is not available on the Self-service portal. |
| Control type | The type of control (element) used for the attribute. This can be one of the following options: Text, Check box, Combo box, Multi select combo, or Date/time. |
| Default value | The default value for the attribute. |
| Element | Description |
|---|---|
| Contract ID | The contract for which you want to view usage information. |
| Column | Description |
|---|---|
| Branch | The appropriate branch. |
| Item ID | The non-stock item to be invoiced. |
| Description | A description of the non-stock item. |
| UoM | The unit of measure used for the item. |
| Quantity | A number of units used for the item. |
| Date | The date of the activity, case, applied labour, or other usage (for the item). |
| Case ID | The link to the case whose invoicing resulted in this transaction. This column is displayed only if the Customer management functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Element | Description |
|---|---|
| Post period | The post period for which you want to view invoicing information. |
| Column | Description |
|---|---|
| Branch | The appropriate branch. |
| Item ID | The non-stock item. |
| Description | A description of the non-stock item. |
| UoM | The unit of measure used for the item. |
| Quantity | The used quantity of the item (in the units of measure). |
| Date | The date of the activity, case, applied labour, or other usage (for the item). |
| Type | The type of the customer ledger document. |
| Reference no. | The reference number of the invoice. You can click the link to navigate to the Sales invoices (AR301000) window so you can view invoice details. |
| Invoicing date | The date when the invoice was issued. |
| Case ID | The ID of the case whose invoicing resulted in this transaction. |
| Element | Description |
|---|---|
| Terms ID | The unique identifier for these payment terms. The alphanumeric string may contain up to 10 characters. |
| Description | A detailed description of the payment terms. This alphanumeric string may contain up to 30 characters. |
| Visible to | The target audience for which the terms are visible, which can be one of the following:
|
| Element | Description |
|---|---|
| Due date type | The method of due date calculation. The following options are available:
|
| Move due date if on the weekend | If the due date on the invoice falls onto a weekend (Saturday or Sunday), use the options in the drop-down to calculate it to the Friday before the due date or the Monday after it. With the option Keep the exact date the due date remains unchanged. |
| Due day 1 | The first due day, which is used with certain Due date type options. Specify the number of days if the Fixed number of days option is selected, the day of the month if the Day of next month or Day of the month option is selected, and the first due day if the Custom option is selected. |
| Day from 1 | The start day of the date range for documents due on the first due day; this element is used with the Custom option only. |
| Day to 1 | The end day of the date range for documents due on the first due day; this element is used with the Custom option only. |
| Due day 2 | The second due day; this element is used with the Custom option only. |
| Day from 2 | The start day of the date range for documents due on the second due day; this element is used with the Custom option only. |
| Day to 2 | The end day of the date range for documents due on the second due day; this element is used with the Custom option only. |
| Element | Description |
|---|---|
| Discount type | The method of calculating the cash discount period, which can be one of the following options:
|
| Discount day | The number of days or the particular day of the month, depending on the Discount type; this field is unavailable for some options. |
| Discount (%) | The percent of the discount. |
| Delay days | With the amount of days defined here, the cash discount will be considered when registering the payment on the invoice. For example, the cash discount date is set to the 1st of the month, the Delay days field has value 2. You register the payment on the 3rd of the month, and cash discount amount will be used. |
| Element | Description |
|---|---|
| Instalment type | The type of instalment, which can be one of the following options:
|
| Number of instalments | The specific number of instalments; this field is unavailable if the Split by percent in table option is selected as the Instalment method. |
| Instalment frequency | The frequency of instalments; this field is unavailable if the Split by percent in table option is selected as the Instalment method. The following options are available:
|
| Instalment method | The method by which the amounts of instalments are calculated. Select one of the following options:
|
| Column | Description |
|---|---|
| Days | The number of days from the due date on which a particular instalment is due. You must use an integer between 0 (due date) and 31. |
| Percent | The percent of a document total. As you add a new instalment, the percent is automatically adjusted to make all instalments total 100 percent. |
| Button | Description |
|---|---|
| Apply restriction settings to all customers | Updates the security settings for all customers of the class. If you have changed the default restriction group for the selected customer class (on the General settings tab of this window, Default general settings section), clicking this action will include all customers of the class in the specified group and exclude them from the group previously specified as the default one. |
| Element | Description |
|---|---|
| Class ID | The unique identifier of the class. You can use an alphanumeric string of up to 10 characters. |
| Description | A detailed description of the customer class. > [!NOTE] > This field supports the multi-language functionality, where you can translate the entered text to multiple languages. For more information, see: About multi-language support |
| Element | Description |
|---|---|
| Country | The country of customers of the class. |
| VAT zone ID | The default VAT zone for customers of the class. |
| Require VAT zone | A check box that means (if selected) that the VAT zone value is required for customers of the class. If the check box is cleared, the VAT zone is optional for these customers. |
| Default location ID from branch | A check box that indicates (if selected) that the identifier of the branch the user is currently signed in to is used by default as the identifier of the customer’s main location instead of theMAIN (default). This field is available only when the Business account locations functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Default restriction group | The restriction group to which newly created customers of the class are assigned by default. To assign existing customers of the class to the default group, click Apply restriction settings to all suppliers in the toolbar. |
| Salesperson ID | The salesperson to make sales to customers of the class. |
| Export type | The export type defined for the customer class. See also: About export types. |
| Document language | The language of the documents to be printed to the customers of the class. |
| Currency ID | The default currency, by its ID, that is used in operations with customers of this class. |
| Enable currency override | A check box that indicates (if selected) that the currency may be overridden in operations with customers of the class; that is, you can select a currency other than the default currency for individual documents. |
| Currency rate type | The default currency rate type used in operations with customers of this class. |
| Enable rate override | A check box that means (if selected) that users may override the currency rate type in operations with customers of the class, selecting a currency rate type other than the default one for individual documents |
| Group/document discount limit (%) | The maximum percentage of group-level and document-level discounts allowed per document for customers of this class. This value will be used for validation of discounts in sales orders and invoices. If for an order or invoice, the percentage of the total discount exceeds the specified limit, the system will display a warning on the Discount detailstab of the appropriate window. The percentage of the total discount for a document is calculated as follows: the total of the Discount amt. column (on theDiscount details tab) divided by the value of the Detail total field in the top part of the appropriate window. |
| Price class ID | The identifier of the price class. |
| Element | Description |
|---|---|
| Ship via | The carrier whose service will be used by default for customers of the class. |
| Shipping terms | The shipping terms to be assigned by default to customers of the class. |
| Shipping rule | The way shipments for orders should be created by default for a customer of this class. Select one of the following options:
|
| Warning when missing VAT registration ID | When this check box is selected, the system displays a warning when VAT registration ID is missing on the item. |
| Warning when missing corporate ID | When this check box is selected, the system displays a warning when corporate ID is missing on the order. |
| Element | Description |
|---|---|
| Credit verification | The credit verification rule for customers of the class. The following options are available:
|
| Credit limit | The credit limit amount for customers of the class if the Credit limit or Limit and days past due option is selected in the Credit verification field. |
| Amount over limit | The maximum amount allowed over the credit limit for customers of the class. |
| Credit days past due | The duration of the credit period. This value is used if the Days past due or Limit and days past due option is selected in the Credit verification field. |
| Element | Description |
|---|---|
| Terms | The default payment terms of the customer class; terms are defined in the Payment terms (CS206500) window. |
| Statement cycle ID | The default statement cycle to be used for customers of this class. |
| Payment method | The payment method used by default in relations with these customers. |
| Apply payments automatically | A check box that indicates (if selected) that payment application may be performed automatically for customers of the class. |
| Apply overdue charges | A check box that indicates (if selected) that overdue charges can be applied to these customers. This check box is available if the Overdue charges functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Overdue charge ID | The overdue charge to be applied for customers of this class. The option is available if the Overdue charges functionality has been enabled in the Enable/disable functionalities (CS100000) window. |
| Enable write-offs | A check box that indicates (if selected) that balance and credit write-offs are allowed for customers of this class. |
| Write-off limit | The maximum value that may be written off for customers of the class. All balances and credits that are less than this value may be written off. This field is available only if the Enable write-offs check box is selected. |
| Exclude debt collection | A check box that, if selected, will exclude the customer invoices connected to this customer class to be sent to debt collection. You can reverse this setting on the Customer classes (AR201000) window, tab General information, by de-selecting the check box Exclude debt collection. |
| Element | Description |
|---|---|
| Webhook notification | The check box you select to enable Webhook notifications for the customer class. |
| Element | Description |
|---|---|
| Print invoices | A check box that indicates (if selected) that invoices can be printed in the Send invoices (AR508000) window. |
| Send invoices by email | A check box that indicates (if selected) that invoices can be sent by email to customers of the class by using the Send invoices (AR508000) window. |
| Print dunning letters | A check box that indicates (if selected) that dunning letters can be printed for sending to customers of the class by using the Print/release dunning letters (AR522000) window. This field is available only if the Dunning letter management functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Send dunning letters by email | A check box that indicates (if selected) that dunning letters canbe sent by email to customers of the class by using the Print/release dunning letters (AR522000) window. This field is available only if the Dunning letter management functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Print statements | A check box that indicates (if selected) that statements can be printed for sending to customers of the class in the Print statements (AR503500) window. |
| Send statements by email | A check box that indicates (if selected) that statements can be sent by email to customers of the class by using the Print statements (AR503500) window. |
| Multi-currency statements | A check box that indicates (if selected) that statements will be printed or sent by email in multi-currency format for customers of the class. |
| Statement type | The statement type used by default in relations with customers of the class:
|
| Element | Description |
|---|---|
| Send invoices to AutoInvoice | Select this check box if you are using AutoInvoice and want to send invoices directly to this service. |
| Send invoices to AutoInvoice as banking e-Invoice (Norway) | A check box that, if selected, indicates that you can send invoices to AutoInvoice as banking e-invoices. This applies to Norway only. |
When this check box is selected, a new element is added into the outgoing invoice called MediaType that will be populated with the Print value. The customer language is also retrieved from the Customers (AR303000) window from the Document language field. This is used in Sweden when the printing service is activated. This check box is only visible when you have not enabled PEPPOL invoice in the Customer ledger preferences (AR101000). You can only select this check box if you select the Send invoices to AutoInvoice check box. |
|
| Exclude invoice PDF | When selected, this enables the possibility to not generate and imbed invoice PDF while sending electronic invoices via the PEPPOL BIS invoice format. This check box is only visible when you have enabled PEPPOL invoice in the in the Customer ledger preferences (AR101000). You can only select this check box if you select the Send invoices to AutoInvoice or Send invoices to AutoInvoice as banking e-Invoice (Norway) check box. |
| Use the first AutoInvoice attachment to view invoice | When this check box is selected, the first attachment marked to be sent to AutoInvoice will be the visible invoice for the receiver. This only applies if an attachment exists on the invoice, else the pure XML will be used to generate a readable version of the invoice for the receiver. This check box is only visible when you have enabled PEPPOL invoice in the in the Customer ledger preferences (AR101000). You can only select this check box if you select the Send invoices to AutoInvoice or Send invoices to AutoInvoice as banking e-Invoice (Norway) check box and the Exclude invoice PDF check box. |
| Element | Description |
|---|---|
| Customer ledger account | The asset account that stores the balance of the customers of this class. |
| Customer ledger sub. | The subaccount for the asset account that stores the balance of the transactions related to customers of this class. |
| Cash discount account | The expense account used to record cash discount amounts received by customers of this class. |
| Cash discount sub. | The subaccount used with the expense account to record the discount amounts received by customers of this class. |
| Sales account | The income account used to record sales made to the customers of this class. |
| Sales - non-taxable account | The non-taxable sales account used to record sales made to the customers of this class. |
| Sales - EU account | The EU sales account used to record sales made to the customers of this class. |
| Sales - export account | The export sales account used to record sales made to the customers of this class. |
| Sales sub. | The subaccount used to record sales made to customers of the class. |
| Discount account | The expense account used to record trade discount amounts received by customers of this class. This field is available only if the Customer and supplier discounts functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Discount sub. | The subaccount used with the expense account to record the discount amounts received by customers of this class. This field is available only if the Customer and supplier discounts functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Prepayment account | The account to record prepayments received from customers of the class. |
| Prepayment sub. | The corresponding subaccount. |
| Freight account | The income account used to record the freight charges for shipping the goods to customers of this class. |
| Freight sub. | The subaccount used with the income account to record the freight charges for shipping the goods to customers of this class. |
| Unrealised gain account | The account to record unrealised gains calculated on transactions with customers of this class. If no account is selected in this column, the account specified in the Currencies (CM202000) window will be used. |
| Unrealised gain sub. | The corresponding subaccount to record unrealised gains on transactions with customers of this class. If no subaccount is selected in this column, a subaccount will be generated according to the rule specified in the Combine gain/loss sub. from field in the Currency management preferences (CM101000) window. |
| Unrealised loss account | The account to record unrealised losses calculated on transactions with customers of this class. If no account is selected in this column, the account specified in the Currencies (CM202000) window will be used. |
| Unrealised loss sub. | The corresponding subaccount to record unrealised losses on transactions with customers of this class. If no subaccount is selected in this column, the subaccount will be generated according to the rule specified in the Combine gain/loss sub. from field in the Currency management preferences (CM101000) window. |
| Element | Description |
|---|---|
| Attribute ID | The name of the attribute, which serves as its identifier. An alphanumeric string of up to 10 characters may be used. |
| Description | A detailed description of the attribute. Use an alphanumeric string of up to 50 characters. |
| Sort order | A number that represents the order of the attribute for sorting in reports. |
| Required | A check box that indicates (if selected) that the attribute value is required for all customers of the class. |
| Internal | A check box that indicates (if selected) that the attribute is not available for portal users. |
| Control type | The type of control for the attribute: Text, Combo, Multi select combo, Lookup, Check field, or Date/time. |
| Default value | The default value of the attribute. |
| Element | Description |
|---|---|
| Mailing ID | The unique identifier of this mailing. |
| Branch | The branch for which this mailing is defined. |
| Email account | The system email account to be used by default for sending emails for this mailing to customers of the class. If no account is specified, the default system account will be used. |
| Report | The customer ledger report to be used by default as the email body for the mailing, if this mailing uses a report rather than a mailing template. |
| Notification template | The email template to be used for generating personalised emails for this mailing, if a template is used. For each mailing, you can specify either a report or an email template. By default, a notification template specified in the Notification template column on the Mailing settings tab of the Customer ledger preferences (AR101000) window is inserted in this column (if any). |
| Format | The format in which the report, if a report is used, will be sent by default if a recipient has no preferences. Select one of the following options: HTML, Excel, or PDF. |
| Active | A check box that indicates (if selected) that this mailing is active. Emails will be sent for only active mailings. |
| Element | Description |
|---|---|
| Contact type | The type of contact to receive the mailing:
|
| Contact ID | The particular recipient of the selected type. A recipient can be specified only if Employee has been specified in the Contact type column. This employee will by default receive emails with documents of all customers of the class. |
| Format | The format in which the document (formatted according to the selected report if applicable) will be sent for recipients of this type by default. Select one of the following options: HTML, Excel, or PDF. |
| Active | A check box that indicates (if selected) that this contact or contact type is active. Only active recipients will receive emails for the mailing. |
| Bcc | A check box that indicates (if selected) that the contacts of this type will by default receive blind carbon copies (Bcc) of the emails for this mailing. |
| Button | Description |
|---|---|
| Actions | Provides the following menu commands, which you can click to invoke actions:
|
| Inquiries | Provides the following menu command, which you can click for quick access to an inquiry window:
|
| Element | Description |
|---|---|
| Setup date | The date of contract setup. By default, this box contains the date specified in the Setup date field on the Summary tab of the contract. |
| OK (button) | Initiates the selected operation. |
| Cancel (button) | Closes the dialog box without performing the selected operation. |
| Element | Description |
|---|---|
| Activation date | The date of contract activation. By default, this box contains the date specified in the Activation date field on the Summary tab of the contract. |
| OK (button) | Initiates the selected operation. |
| Cancel (button) | Closes the dialog box without performing the selected operation. |
| Element | Description |
|---|---|
| Contract ID | The new contract identifier. |
| OK (button) | Changes the contract identifier to the new one. |
| Element | Description |
|---|---|
| Contract ID | The unique identifier of a contract, which is specified in accordance with the configuration of the CONTRACT segmented key. The CONTRACT segmented key inherits its structure from the PROJECT segmented key. |
| Contract template | The contract template that is used as a base for the contract. |
| Status | The status of the contract, which is one of the following:
|
| Customer | The customer associated with the contract. |
| Location | The customer location associated with the contract. |
| Description | The description of the contract, which includes any related comments. > [!NOTE] > This field supports the multi-language functionality, where you can translate the entered text to multiple languages. For more information, see: About multi-language support |
| Balance | A read-only field that displays the sum of the balances of open invoices associated with the contract. |
| Element | Description |
|---|---|
| Setup date | The contract setup date. For contracts with the Draft status, in this field, you select the setup date, which will be displayed by default and can be changed in the Set up contract dialog box (which opens when you click the Set up contract action). This field is read-only after the contract has been set up. |
| Activation date | The contract activation date. For contracts with the Draft or Pending activation status, you use this field to select the date, which will be displayed by default and can be changed in the Activate contract dialog box (which opens when you click the Activate contract action). This field is read-only after the contract has been activated. |
| Expiration date | A read-only field that displays the date when the contract will expire. The date is calculated automatically according to the contract invoicing schedule. |
| Termination date | A read-only field that displays the date when the contract was cancelled, if applicable. |
| Grace period (in days) | The period of time after the expiration date when the renewable contract can be renewed. After the end of the grace period, only a copy of this contract with the Draft status can be created when you click the Renew contract action (that is, you cannot renew the same contract). |
| Mass renewal | A check box that, if selected, indicates that this contract is available for mass processing and is to be displayed in the Renew contracts (CT502000) window. |
| Renewal point x Days before expiration | The number of days before the contract expiration date when the system starts to display the contract in the Renew contracts (CT502000) window if the Mass renewal check box is selected for the contract. The accepted maximum value in the field is 3650 days (10 years). |
| Currency | A read-only field that displays the currency to be used for contract invoicing. |
| Element | Description |
|---|---|
| Invoicing schedule starts on | A read-only field that displays the start date of the first invoicing period. The date, which is calculated automatically according to the contract invoicing schedule, is displayed after contract activation. |
| Invoicing period | The type of invoicing schedule, which can be one of the following options: Week, Month, Quarter, Half a year, Year, Statement-based, or On demand. The invoice date is calculated based on the selected option and the date when the invoicing schedule is started. The On demand option means that invoicing is not scheduled and you can invoice the contract on any date. The option cannot be used with contract items that have recurring pricing configured, except for items that are tied up with a deposit item or have a default quantity of zero. For details on deposit contract items, see: About retainer contracts. |
| Last invoicing date | A read-only field that shows the date when the invoicing was performed most recently. |
| Next invoicing date | The date of the next invoicing invoice, according to the invoicing schedule. |
| Element | Description |
|---|---|
| Invoice to | The setting that defines the customer account to be invoiced for a contract. The following options are available:
|
| Account | The specific account that is to be invoiced for contract services. This field is available only if the Specific account option is selected in the Invoice to field. |
| Location | The customer location associated with the account the contract is invoiced to. |
| Invoice description | In this field, you can specify the formulas for invoice descriptions by using the standard formula editor. The field is available for editing only when the Enable overriding formulas in contracts check box is selected in the Contract templates (CT202000) window. For more information about formulas, see: About formulas. |
| Line description | In this field, you can specify the formulas for line descriptions by using the standard formula editor. The field is available for editing only when the Enable overriding formulas in contracts check box is selected in the Contract templates (CT202000) window. For more information about formulas, see: About formulas. |
| Element | Description |
|---|---|
| Owner | The owner of the contract. |
| Salesperson | The salesperson associated with the contract. |
| Case count item | A non-stock item used for counting cases associated with the contract. For details, see: Set up invoicing by the number of cases. |
| Element | Description |
|---|---|
| Effective from | The date when the contract was set up or upgraded. This field is available for editing when the contract has the Pending upgrade status. You may select a date here that is to be displayed by default and can be changed in the Activate contract dialog box, which opens when you click the Activate upgrade action. |
| Promo code | The code of the discount to be applied. |
| Pending setup | A read-only field that displays information as follows:
|
| Pending recurring | A read-only field that displays information as follows:
|
| Pending renewal | A read-only field that displays the total of renewal prices (item renewal price multiplied by included quantity). This field is displayed for contracts that have the Draft or Pending upgrade status. |
| Total pending | A read-only field that displays the total pending amount. This field is displayed for contracts that have the Draft or Pending Upgrade status. |
| Current setup | A read-only field that displays the total of setup fees (item setup price multiplied by included quantity). This field is populated with this sum on contract activation or upgrade. |
| Current recurring | A read-only field that displays the total of recurring fees (item recurring price multiplied by included quantity). This field is populated with this sum on contract activation or upgrade. |
| Current renewal | A read-only field that displays the total of renewal prices (item renewal price multiplied by included quantity). This field is populated with the sum on contract activation or upgrade. |
| Column | Description |
|---|---|
| Item code | The identifier of the contract item. |
| Description | A description of the item, with any relevant comments. |
| Included | The contract item quantity included by default. It can be overridden within the allowed limits. For recurring contract items, if any are added to retainer contracts or contracts that are invoiced on demand, we recommend that you specify an included quantity of zero. |
| Difference | The quantity difference if the contract status is Pending upgrade. |
| Setup price | The contract item price for setup. |
| Setup discount (%) | The discount percent applied to the setup price. |
| Recurring price | The contract item recurring price. |
| Extra usage price | The contract item price for extra usage. |
| Recurring discount (%) | The discount percent applied to the recurring price. |
| Renewal price | The contract item price for renewal. |
| Renewal discount (%) | The discount percent applied to the renewal price. |
| Element | Description |
|---|---|
| Recurring total | A read-only field that displays the total sum to be invoiced for the current invoicing period. |
| Extra usage total | A read-only field that displays the total sum to be invoiced for extra usage for the current invoicing period. |
| Total due | A read-only field that displays the total amount to be invoiced for the current invoicing period. |
| Column | Description |
|---|---|
| Item code | The identifier of the contract item. |
| Description | A description of the item, with any relevant comments. |
| Item ID | The identifier of the non-stock item the customer is invoiced for recurrently. |
| UoM | The unit of measure used for invoicing. The UoM is the contract currency for deposit contract items. |
| Invoice type | The item invoicing policy defined in the contract item. The invoicing type is Deposit for deposit contract items. |
| Included | The item quantity the customer is invoiced for at the recurring price. |
| Recurring price | The recurring price of the item. |
| Recurring discount (%) | The discount percent applied to the recurring price. |
| Extra usage price | The price of extra usage of the item. |
| Not yet invoiced | The item quantity for which the customer is to be invoiced for the current invoicing period. |
| Used total | The item quantity used from contract activation until the current business date. |
| Column | Description |
|---|---|
| Type of hour | The identifier of the type of hour. |
| Description | The description of the type of hour. |
| Labour item | The identifier of the non-stock item (of the Labour type) used as a source of the price and sales account to record the contract usage. |
| Employee | The identifier of the employee. If the employee is not selected, the value is All employees. |
| Employee name | The name of the employee. |
| Button | Description |
|---|---|
| View contract | Opens a new window with the Customer contracts (CT301000) window so you can view the related contract details. |
| Column | Description |
|---|---|
| Action | The action performed for the contract. |
| Date | The date when the action was performed. |
| User | The user who performed the action. |
| Related contract | The ID of any related contract. The related contract is either derived from the current contract or served as a derivation for the current contract. The field is populated by the system during the renewal process. For details, see: Renew a contract. |
| Column | Description |
|---|---|
| Type | The type of customer ledger document. |
| Invoice no. | The invoice number of the document. By clicking the number, you can navigate to the Sales invoices (AR301000) window, where you can view the details of the document. |
| Post period | The financial period to which the invoice transactions are posted. |
| Date | The date of the invoice. |
| Due date | The due date of the invoice. |
| Status | The status of the invoice. |
| Amount | The amount of the invoice. |
| Balance | The balance of the invoice if it was paid partially. |
| Payment method | The customer default payment method. |
| Column | Description |
|---|---|
| Attribute | The attribute name. |
| Required | A check box that indicates (if selected) that the user must provide a value for the attribute. |
| Value | The value for the attribute. |
| Button | Description |
|---|---|
| Actions | Provides the following menu commands, which you can click to invoke actions:
|
| Reports | Provides the following menu commands, which you can click for fast access to reports:
|
| Element | Description |
|---|---|
| Company | The company for which you want to view data. By default, it is the company you have access to. |
| Branch | The branch for which you want to view data. By default, it is the branch you have access to. |
| Customer | The customer whose open documents you want to view. Obligatory. |
| Period | The financial period for which you want to view the data. If you make no selection, information related to all open periods will be displayed. |
| Currency | The currency used with the specified customer. |
| Customer ledger account | The customer ledger account used for the customer. |
| Customer ledger sub | The corresponding subaccount. |
| Show all documents | A check box that indicates (if selected) that closed documents (with the Closed status) are included in the list. The check box is not displayed if a financial period is selected in the Period field. |
| Include unreleased documents | A check box that indicates (if selected) that unreleased documents (with the On hold and Balanced statuses) are included in the list. |
| Balance by documents | A read-only field that displays the total balance recalculated for all customer’s documents matching the selected criteria. The balance will not change based on whether the Open documents only option is selected because Closed documents do not affect the balance. |
| Current balance | A read-only field that displays the customer balance retrieved from the account history records in the database. |
| Prepayments balance | The balance of customer prepayments calculated for the selected criteria. |
| Balance discrepancy | A read-only field that displays the difference between the Balance by documents value and the sum of Current balance and Prepayment balance values. If unreleased documents are not included, the value should be equal to zero; if it’s not zero, there are errors in the database. |
| Include child accounts | A check box that you select to view documents of both the parent account and its child accounts. The Balance by documents, Current balance, Prepayment balance, and Balance discrepancy fields (in the top part of the window) will display the consolidated balance for parent accounts that have child accounts for which the Consolidate balance check box is selected on the Invoicing settings tab of the Customers (AR303000) window. The field is available if the Parent-child customer relationship functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Column | Description |
|---|---|
| Customer | The customer number. |
| Branch | The branch ID. |
| Type | The type of customer ledger document: Invoice, Credit note, Debit note, Payment, Overdue charge, or Prepayment. |
| Reference no. | The identifier of the document as it was assigned by the number series. |
| Post period | The period to which the document transactions should be posted. |
| Date | The date when the document was created. |
| Due date | The due date of the document. |
| Status | The status of the document. |
| Currency | The currency of the document. |
| Original amount (currency) | The amount in the currency of the document (before discount). |
| Balance (currency) | The balance of the document in the specified currency. |
| Cash discount taken (currency) | The cash discount taken in the specified currency. |
| Orig. amount | The original amount of the document, before payment application, in the base currency. |
| Balance | The balance of the document, if a payment was applied, in the base currency. |
| Cash discount taken | The amount of cash discount received by the customer on the document. |
| RGOL amount | The total amount of realised gain or loss (RGOL) incurred as the result of currency rate fluctuation. |
| Payment method | The payment method used by the customer for the document. |
| Sales invoice no./payment no. | The reference number of the original customer document. |
| Invoice text | A detailed description of the document. |
| Period beg. balance | The balance of the account at the beginning of the selected financial period. |
| Period beg. balance in currency | The account balance in the specified currency at the start of the selected financial period. |
| Element | Description |
|---|---|
| General ledger batch number series | The number series used for batches originating in the Customer ledger workspace. |
| Invoice number series | The number series used for customer ledger invoices. A customer ledger invoice is created for each original customer document, invoice, note, or financial charge. |
| Payment number series | The number series used for customer payments. |
| Debit note number series | The number series used for debit adjustments. |
| Credit note number series | The number series used for credit adjustments. |
| Write-off number series | The number series used for write-off documents. |
| Overdue charge number series | The number series used for overdue charges. The option is available if the Overdue charges functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Price worksheet number series | The number series used for price worksheets. |
| Dunning fee number series | The number series used for dunning fees. |
| Element | Description |
|---|---|
| Automatically post on release | A check box that indicates (if selected) that transactions will be automatically posted to the General ledger workspace once they are released in the Customer ledger workspace. |
| Post summary when updating the general ledger | A check box that indicates (if selected) that customer ledger documents will be posted to the General ledger workspace with summarised row amounts if particular criteria are met. That is, if multiple rows in a customer ledger document specify the same account (and subaccount, if any) and branch (if the Multi-branch support functionality is enabled in the Enable/disable functionalities (CS100000) window), then in the general ledger batch, these rows will be combined into one row with the summarised amount. Note: The summarised transaction amounts can be posted to an account (and subaccount, if any) only if both the Post summary when updating the general ledger check box is selected in this window and the Summary option is specified for an account in the Post option column in the Chart of accounts (GL202500) window.
Note
The general ledger batch can contain multiple documents if the Consolidated posting to general ledger functionality is enabled in the Enable/disable functionalities (CS100000) window. For details, see Overview of the functionalities. |
| Activate migration mode | A check box that indicates (if selected) that the user can release documents in Customer ledger and Supplier ledger (both invoices and payments) without creating a General ledger batch in the General ledger.The balance will still be added to the customer or supplier. Stock items can also be selected. The Sales and Purchases workspaces cannot be used. |
| Element | Description |
|---|---|
| Default customer class ID | The customer class to be used as the default class. When you create a new class by using the Customer classes (AR201000) window, the settings defined for the class specified here will be inserted. (You can change any of these settings.) |
| Combine sales sub. from | The subaccount mask that defines the rule of selecting segment values for the sales subaccount to be used in data entry windows in the Customer ledger workspace. To set up the rule, select a segment, press F3, and select the source of the segment value, which is one of the following options:
For a segment, the characters designating each option are repeated as many times there are characters in the segment. See: About combined subaccounts for more information. |
| Rounding rule for invoices | The rule to be used for invoice total amount rounding, which is one of the following:
This field is available only if the Invoice rounding functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Rounding precision | The smallest unit for invoice amount rounding; this list is not available if the Use currency precision option is selected in the Rounding rule field. Select one of the following options:
This field is available only if the Invoice roundingfunctionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Hold documents on entry | A check box that means (if selected) that documents will get the On hold status by default when they are saved. |
| Validate document totals on entry | A check box that means (if selected) that totals of new documents will be validated on entry. |
| Require payment reference on entry | A check box that means (if selected) that users must fill in the Payment ref. field in data entry windows in the Customer ledger, Cash management, and Sales workspaces. |
| Hold document on failed credit check | A check box that indicates (if selected) that new invoices and notes are placed on hold and cannot be released for customers that failed the credit check. If the check box is not selected, new documents can be saved and processed regardless of the credit check result, although the system warns users about customers that failed their credit check. |
| Element | Description |
|---|---|
| Automatic payment method | This value will automatically be set when you open the Process customer refunds (AR50300S) window. |
| Manual payment method | This value will automatically be set when you open the Manual payments (AR30200S) window. |
| Direct debit payment method | This value will automatically be set when you open the Send direct debit invoices (AR50850S) window. |
| Element | Description |
|---|---|
| Age credits | A check box that means (if selected) that credit notes and open payments will be aged on customer statements and reports along with invoices and debit notes according to the ageing periods defined in the Statement cycles (AR202800) window. If the check box is cleared, credit notes and open payments will appear as the current documents. |
| Set default overdue charges by statement cycle | A check box that means (if selected) that overdue charges specified for the statement cycle are applied to an overdue document. If the check box is not selected, overdue charges specified for the customer class are applied. The option is available if the Overdue charges functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Calculate on overdue charge documents | A check box that means (if selected) that overdue charges will be calculated on overdue charge documents as well as on invoices; thus, the amount of overdue charges compounds. The option is available if the Overdue charges functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Apply payments to overdue charges first | A check box that indicates (if selected) that payments will be applied to overdue charges first and only after that to outstanding invoices, starting with those having the earliest dates, if the Apply payments automatically check box is selected for a customer in the Customers (AR303000) window. The option is available if the Overdue charges functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Element | Description |
|---|---|
| Salesperson commission by | The way commissions for all salespersons are calculated:
|
| Commission period type | The way commission is paid: Monthly, Quarterly, Yearly, or By financial period. |
| Element | Description |
|---|---|
| Consolidate statements for all branches | A check box that indicates (if selected) that statements from different branches should be consolidated. |
| Statement from branch | The branch to appear on the consolidated statements. |
| Consolidate dunning letters for all branches | A check box that indicates (if selected) that dunning letters from different branches should be consolidated. |
| Dunning letter from branch | The branch to appear on the consolidated dunning letters. |
| Element | Description |
|---|---|
| Reason code balance write-off | The reason code that is used by default when you perform a balance write-off operation. |
| Reason code credit write-off | The reason code that is used by default when you perform a credit write-off operation. |
| Element | Description |
|---|---|
| Automatically release credit notes | A check box that indicates (if selected) that VAT credit notes generated for the invoices that are fully paid within the cash discount period will be released automatically when you process them in the Generate VAT on cash discount (AR504500) window. |
| Credit note description | The description to be used for the credit note, which is generated for a document that was paid early and that adjusts the VAT and taxable amounts. > [!NOTE] > This field supports the multi-language functionality, where you can translate the entered text to multiple languages. For more information, see: About multi-language support |
| Element | Description |
|---|---|
| Payment message prefix | The prefix that will be used in outgoing payment messages. |
| Element | Description |
|---|---|
| Default rate type | The default rate type to be used for calculation of prices in foreign currencies. The field provides a rate type to be used by default when you work with sales prices. |
| Always calculate the price from the base currency | A check box that indicates (if selected) that if a document uses a non-base currency, then the item price (sales or default) is converted to a price in the currency of the document, based on the item price expressed in the base currency. Thus, when you add an item to a document (an order or invoice) that uses a non-base currency, the system suggests the price of the item based the value of this check box:
|
| Load sales prices by alternative item ID | A check box that (if selected) makes it possible to specify prices in sales price worksheets by the alternative IDs of items, so that the system will find and populate the corresponding item IDs automatically. |
| Element | Description |
|---|---|
| Retention type | The way the history of prices, which is defined by using the Sales price worksheets (AR202010) window, will be retained. Select one of the following options:
Note
By default, Retention type is set to Fixed number of months and Number of months is set to 0, which means that the history of prices will be kept forever. |
| Number of months | The number of months the history of price changes should be kept. This field is available if the Fixed number of months option is selected in the Retention type field. |
| Element | Description |
|---|---|
| Line discount basis | The way the line discount will be applied. Select one of the following options:
|
| Apply quantity discounts to | The way the system applies the discounts defined by quantity. Select one of the following options:
|
| Apply line discounts specific to | A check box that indicates (if selected) that any line-level discounts should be skipped if there is a special price for the line item that is defined for this particular customer. |
| Element | Description |
|---|---|
| Dunning process | The way the system groups overdue documents when prepares dunning letters. Select one of the following options:
Note
We recommend that you select the way of setting a level from the very beginning and keep that setting. You can switch from By customer to By document, but switching from By document to By customer is not recommended. |
| Automatically release dunning letters | A check box that indicates, if selected, that dunning letters are automatically released after preparation is completed. The field is available for editing if the By document option was selected in the Dunning process field. |
| Include other unpaid documents | A check box that indicates (if selected) that the system includes in dunning letters the unpaid documents that are not due yet. This is the default value for the Include other unpaid documents check box in the Prepare dunning letters (AR521000) that you can change any time you prepare dunning letters. |
| Include credit note documents | A check box that indicates, if selected, that the dunning letter will contain credit notes. This is the default value for the Include credit note documents check box in the Prepare dunning letters (AR521000) window that you can change any time you prepare dunning letters. |
| Element | Description |
|---|---|
| Dunning fee item | The non-stock item that provides an account and a subaccount (if applicable) to register the collected fee, and a VAT category. |
| Automatically release dunning fee documents | A check box that indicates (if selected) that an invoice for the dunning fee is automatically released when the corresponding dunning letter is released. Otherwise, you need to release it manually by using the Sales invoices (AR301000) window. |
| Element | Description |
|---|---|
| Dunning letter level | An integer that indicates the order in which a letter of this level should be sent. |
| Days past due | The number of days that should pass after the due date for at least one customer document before the system may generate a dunning letter of this level. |
| Days to settle | The number of days that are added to the letter date to calculate the deadline for the payment. |
| Description | Any comment that is relevant to a dunning letter of this level. |
| Dunning fee | The amount of the dunning letter fee, if your company charges one, for this level. |
| Days to due | The number of days to the due date. |
| Report text code | The code of the report text that will be included in the dunning letter. |
| Column | Description |
|---|---|
| Mailing ID | The unique ID of the mailing. The mailings available in the Customer ledger workspace are listed below:
|
| Default email account | The system email account to be used by default for sending emails for this mailing. If no account is specified, the default system account will be used. |
| Report | The customer ledger report that, by default, will be used to structure the information available in the document. The document will be sent as an attachment. A notification template, if selected next, is used to window an email body, otherwise an email body is taken from the report settings. |
| Notification template | The email template to be used by default to generate personalised emails for this mailing, if a template is selected for this mailing.
Note
You need to specify either a notification template or a report for a mailing at least. If a notification template is not specified, text for email body is taken from the report settings. The system inserts this template by default in the Notification template column on the Mailing settings tab in the Customer classes (AR201000) window when you add a mailing in the Mailings table. |
| Format | The format in which the document (if a report is used) will be sent by default if no other preferences are specified in the Customers (AR303000) window for the particular customer contacts. Select one of the following options: HTML, Excel, or PDF. |
| Active | A check box that indicates (if selected) that this mailing is active. Emails will be generated only for active mailings. |
| Element | Description |
|---|---|
| Contact type | The type of contact to receive mailings. You select one of the following options:
|
| Contact ID | The ID of the mailing recipient. A particular recipient can be selected only if you have selected Employee as the contact type. This employee, if one is selected, will receive emails about changes in the documents of all customers. |
| Format | The format in which the report (if applicable) will be sent by default. Select one of the following options: HTML, Excel, or PDF. |
| Active | A check box that indicates (if selected) that the contact or contact type is active. Only active recipients receive the emails for the mailing. |
| Bcc | A check box that indicates (if selected) that the contact (or contact of this type) will receive a blind carbon copy (Bcc) of the emails for this mailing. |
| Element | Description |
|---|---|
| Select configuration | Click |
| Status | The status of the configuration. To hide/view CID code on outgoing invoices, set the status to Inactive/Active accordingly. The Editing status allows you to edit the predefined format of the CID. |
| Branch | The branch in which the configuration is applied. If you have multiple branches, you can add different settings for each branch. |
| Payment method | The payment method to which you want your configuration to apply. |
| Digit counter | The number of digits to be used in the payment references with this configuration. |
| Description | The name for the new configuration. |
| Display mask | The display mask to be used to control the format of dates and numeric values. |
| Reference modulus | The modulus for the new configuration. |
| Reference weight | The weight or relevance of the modulus. |
| Amount check digit | The digit that is used for checking of amount. |
| Amount weight | The weight or relevance of the amount. |
| Element | Description |
|---|---|
| Element | Choose the elements that will make up the new configuration. |
| Fixed value | A fixed value in the element, if any. |
| Number of positions | The number of digits the element should have. |
| Leading/trailing zeros | The value that shows if leading/trailing zeros will be used in the elements or now. |
| Button | Description |
|---|---|
| View customer | Opens the Customers (AR303000) window so that you can view the selected customer account. |
| Element | Description |
|---|---|
| Customer class | The customer class for which you want to display the customer accounts. |
| Status | The status of the customer accounts you want to display. You can select one of the following options:
|
| Country | The customer’s country. |
| AutoInvoice validation (B2B) | When this check box is selected, the AutoInvoice validation is used on the displayed customers. |
| AutoInvoice validation (B2C) | When this check box is selected, the AutoInvoice validation is used on the displayed customers. |
| Column | Description |
|---|---|
| Customer no. | The ID of the customer account. |
| Customer name | The name of the customer as it is displayed in the system. |
| Address 1 | The first line of the customer’s address. |
| Postcode | The customer’s postcode. |
| City | The customer’s city. |
| Country | The customer’s country. |
| Corporate ID | The customer’s company ID, associated with the location. |
| Attention | The customer’s main contact attention line. |
| Phone 1 | The default phone number of the customer. |
| The email address of the customer as a business entity. | |
| Last sale | The date when the last sale has been made to the customer. |
| Status | The status of the customer. Accordant with the status selected in the top part of the window. |
| Customer class | The class to which the customer is assigned. Accordant with the customer class selected in the top part of the window. |
| Address 2 | The second line of the customer’s address. |
| Address 3 | The third line of the customer’s address. |
| County | The customer’s county or province. |
| Finvoice contract ID | The ID of the customer’s Finvoice contract, if applicable. |
| Finvoice intermediator ID | The ID of the customer’s Finvoice intermediator, if applicable. |
| Phone 2 | An additional phone number of the customer. |
| Print dunning letters | A check box that, if selected, indicates that dunning letters for the customer can be printed in the Print/release dunning letters (AR522000) window. |
| Print invoices | A check box that, if selected, indicates that invoices for the customer can be printed in the Send invoices (AR508000) window. |
| Send dunning letters by email | A check box that, if selected, indicates that you can send dunning letters for the customer by email in the Print/release dunning letters (AR522000) window. |
| Fax | The fax number of the customer. |
| Send invoices to AutoInvoice | When this check box is selected, invoices for the customer are sent to AutoInvoice. |
| Send invoices to AutoInvoice as banking e-Invoice (Norway) | When this check box is selected, invoices for the customer are sent to AutoInvoice as a banking e-invoice. This applies to Norway only. |
| Send statements by email | A check box that, if selected, indicates that statements for the customer can be sent by email to the customer in the Print statements (AR503500) window. |
| Terms | The ID of the payment terms used in operations with the customer. |
| Send invoices by email | A check box that, if selected, indicates that you can send invoices for the customer by email in the Send invoices (AR508000) window. |
| VAT registration ID | The customer’s taxpayer ID associated with the location. |
| VAT zone | The VAT zone of the customer’s default location. |
| Element | Description |
|---|---|
| Business connection | The customer this location is associated with. |
| Location ID | The identifier of the location; an alphanumeric string of up to six characters may be used. The system automatically assigns the identifier (MAIN) to the first location associated with the customer. For each additional location, you can specify the identifier. |
| Active | A check box that you select if the location is active. For auditing purposes, locations cannot be removed. If the location is not used, mark it as inactive by clearing the check box. |
| Location name | A descriptive name to help users recognise the location. You can enter an alphanumeric string of up to 30 characters. |
| Element | Description |
|---|---|
| Same as main | A check box that you select if the contact information is the same as the company’s main information. If this check box is selected, the elements below it are populated with this information. |
| Company name | This location’s legal business name. |
| Attention | Information about the contact person. |
| The location’s default email address. | |
| Web | The website address (if any) related to the location. |
| Phone 1 | The primary phone number of the location. |
| Phone 2 | An additional phone number of the location. |
| Fax | The default fax number of the location. |
| Element | Description |
|---|---|
| Same as main | A check box that you select if the location address is the same as the customer’s main address. The system then populates the elements below with this address. |
| Address 1 | The first line of the address of this location. |
| Address 2 | The second line of the address. |
| Postcode | The location’s postal code. |
| City | The city of the location. |
| Country | The country of the location. |
| County | The county or province of the location. |
| View on map | A button you can click to view the location on a map. |
| VAT registration ID | The optional VAT registration ID associated with the location. An input mask or regular expression can be set to validate this value. |
| Corporate ID | The organisation number to be used for the customer location. |
| VAT zone | The VAT zone associated with the location. |
| Export type | The export type defined for the customer location. See also: About export types. |
| VAT exemption number | If this location is VAT exempt, the exemption number. |
| EDI code | The EDI code to be used for the customer location. |
| GLN | The GLN to be used for the customer location. |
| Shipping branch | The location of your company that will be used to ship the goods to the customer location. |
| Price class | The price class that is associated with the customer location. A price class, defined in the Customer price classes (AR208000) window, indicates the price level offered to the location. |
| Default project | The project associated with this location by default, or a non-project code indicating that no projects are associated by default. |
| Element | Description |
|---|---|
| Warehouse | The warehouse to issue the goods to the location. This field appears only if the Warehouses functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Ship via | The carrier used for shipping the goods to the customer location. |
| Shipping terms | The shipping terms used in relations with the location. |
| Shipping zone | The shipping zone used to calculate the freight charge when your company ships goods to the location. |
| FOB point | The location at which title for the shipment passes from your company to the customer location. |
| Residential delivery | A check box that indicates (if selected) that the shipment will be delivered to a residential area. |
| Saturday delivery | A check box that indicates (if selected) that the shipment may be delivered on Saturday. |
| Insurance | A check box that indicates (if selected) that insurance is required for the order. |
| Shipping rule | The option that defines how the orders should be fulfilled for this customer location. You can use one of the following options:
|
| Order priority | The priority of sales orders of this location. (This setting has no business logic tied to it in the current version and can be used for informational purposes only.) |
| Lead time (days) | The number of days required for shipped goods to reach the location. |
| Calendar | The calendar associated with the location. Calendar settings are defined in the Work calendar (CS209000) window. |
| Check box | Description |
|---|---|
| Exclude from duty calculation | A check box that you select if you want the location to be excluded from excise duty calculations. Orders and invoices with items connected to excise duties will display excise duty amounts and totals, but these will always be 0. Released invoices with excise duty items are traceable in the Sales/returns excluding excise duty (EF402000) window. |
| Element | Description |
|---|---|
| Same as default location | A check box that indicates (if selected) that the accounts to be used for this location are those specified for the default customer location. |
| Customer ledger account | The asset account used to record the account balance for this location. |
| Customer ledger sub. | The corresponding subaccount. |
| Sales account | The account used to record sales to this location; you must specify this account. |
| Sales - non-taxable account | The account used to record non-taxable sales to this location. |
| Sales - EU account | The account used to record the EU sales to this location. |
| Sales - export account | The account used to record the export sales to this location. |
| Sales sub. | The corresponding subaccount; you must specify a subaccount. |
| Discount account | The expense account to record the discount received by the customer location. |
| Discount sub. | The corresponding subaccount. |
| Freight account | The account to record freight charges for sales orders. |
| Freight sub. | The corresponding subaccount. |
| Element | Description |
|---|---|
| Endpoint | Seller electronic address identification scheme identifier. The identification scheme identifier of the seller electronic address. Example value: 0088 |
| Party identification | Buyer identifier identification scheme identifier. The identification scheme identifier of the Buyer identifier. Example value: 0088 |
| Party legal | Seller legal registration identifier identification scheme identifier. The identification scheme identifier of the Seller legal registration identifier. Example value: 0007 |
| Element | Description |
|---|---|
| Accounting cost ref. | Invoice line buyer accounting reference. A textual value that specifies where to book the relevant data into the buyer’s financial accounts. Example value: 4217:2323:2323 |
| Originator document ref. | Tender or lot reference. The identification of the call for tender or lot the invoice relates to. Example value: PPID-123 |
| Contract document ref. | Contract reference. The identification of a contract. Example value: 123Contractref |
| Element | Description |
|---|---|
| Customer | The customer whose payment method you want to view or add; select a customer from the list of customers defined in the system. |
| Payment method | The payment method used as a template for a customer payment method you are currently viewing; select a payment method to use its settings for creating a new customer payment method. |
| Active | A check box that indicates (if selected) that the selected customer payment method is active (that is, available for recording payments). |
| Cash account | The cash account to accrue customer payments made by this payment method, if it differs from the default cash account specified for the payment method selected. You can select an account from the list of cash accounts allowed for the payment method. If the field is empty, the system will use the default cash account of the selected payment method. |
| Description | The description of the selected payment method. |
| Column | Description |
|---|---|
| Description | A description of the column. Depending on the selected payment method you will see different descriptions here. |
| Value | Enter the value, for example a bank account number. |
| Button | Description |
|---|---|
| Release | Releases the payment, automatically creating a batch of appropriate transactions. |
| Void | The system creates the document of the Voided refund type with a negative amount. For the voided refund, you can specify the application date, period, and description, and then release the voided refund. |
| Inquiries | Provides the Customer details and Customer documents menu command, which you can click for quick access to the respective windows. |
| Reports | Provides the following menu commands, which you can click for quick access to reports:
|
| Element | Description |
|---|---|
| Type | The type of a document. The following types are available:
|
| Ref. no | The unique identifier for the payment. This number is automatically generated by the system for a new payment document, based on the number series in the Customer ledger preferences (AR101000) window.
Note
If the Manual numbering check box is selected for the specified numbering sequence in the Number series (CS201010), the system validates each new reference number you enter in order to prevent the creation of payments and prepayments with the same reference number. |
| Status | The status of the customer payment, which for a new document is either Balanced or On hold. (The default status of a new document is controlled by the Hold documents on entry option in the Customer ledger preferences (AR101000) window.) The status of an existing document can be one of following:
|
| Hold | A check box that indicates (if selected) that the document is a draft with the On hold status. This check box is unavailable for debit adjustments. |
| Date | The date when a payment is applied to a document (invoice or note). The field displays the current business date for unapplied or partially applied payments and the latest application date for the closed payment. You can apply a payment to a number of documents on different application dates. Also, you can use the Balance by customer (AR632500) report to view application dates of the documents. |
| Financial period | The financial period to which the payment should be applied, which the system fills in based on the date. |
| Payment ref. | A secondary payment reference identifier, which can be:
The system requires a payment reference number if the Require payment reference on entry check box is selected in the Customer ledger preferences (AR101000) window. This field is not available for credit notes. |
| Customer | The customer who issued the payment. |
| Location | The customer location associated with the sale. Once the customer is selected, this field displays the customer’s default location ID, which can be changed. This element appears only if the Business account locations functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Payment method | The customer’s default payment method; this field is not available for credit notes. |
| Description | The identifier or description of the customer’s default payment method. |
| Cash account | The default cash account associated with the payment method; this field is not available for credit notes. If this is a clearing cash account, the payment will be included in a batch deposit. |
| Currency | The currency of the payment document. Once the customer is selected, the system inserts the customer’s default currency, but it may be changed if the customer’s settings allow currency overriding. |
| Invoice text | A user-defined description of the payment. The description may contain up to 50 alphanumeric characters. |
| Payment amount | The total of the payment that is entered manually. |
| Applied to documents | The total of the documents to which payment is to be applied. The total is displayed until payment release. |
| Applied to orders | The total of the orders for which payment is reserved, minus the amount transferred to invoice. |
| Available balance | The amount that has not been applied. This value is non-zero if the payment amount is greater than the document amount. |
| Write-off amount | The amount that has been written off. |
| Finance charges | The total on all finance charges applied to this document. |
| Deducted charges | The total amount of bank charges deducted by bank from the payment amount on your cash account (bank account). Even if the charges were actually deducted by bank, the original payment amount is shown in the top part. |
| ROT or RUT payment (check box) (check box) | A check box that you select to indicate that this is a payment from Skatteverket for ROT and RUT.
Note
By selecting this check box, you can filter on ROT/RUT payments in a generic inquiry. |
| Button | Description |
|---|---|
| Load documents | Opens the Load options dialog box, where you can specify criteria for loading the customer’s open invoices or debit notes. |
| Column | Description |
|---|---|
| Branch | The branch for which the payment has been created. |
| Doc. type | The type of document to which the payment is applied. The selection depends on the type of the payment document selected in the top part of the window:
Note
The Overdue charge option is available if the Overdue charges functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Ref. no | The reference number of the invoice or note to which the payment is applied. If you click this number, the Sales invoices (AR301000) window opens, on which you can view the details of the selected document. |
| Customer | The identifier of the customer. |
| Amount paid | The amount to be paid which is displayed in the currency of the document that is selected in the window. |
| Cash discount taken | The cash discount to be taken. |
| Balance write-off | The amount to be written off. |
| Write-off reason code | A reason code that defines an account and subaccount to be used for writing off credits or balances. You must select a reason code if the balance write-off amount is non-zero. |
| Date | The creation date of the customer ledger document. |
| Due date | The due date of the customer ledger document. |
| Cash discount date | The date through which the customer can take a cash discount. |
| Balance | The balance of the document after the cash discount is taken and the amount is paid. |
| Cash discount balance | The unused amount of the cash discount, in case of partial payment. |
| Description | A description of the document. |
| Currency | The currency of the customer ledger document. |
| Post period | The period to which the payment transactions are to be posted. |
| Customer order | A reference to a document of the customer, such as a purchase order number. |
| Cross rate | A cross rate that you can optionally specify between the currency of the payment and currency of the original document. |
| Element | Description |
|---|---|
| From date | The earliest date for the documents to be displayed. |
| To date | The latest date for the documents to be displayed. |
| From ref. no. | The document reference number to start with. |
| End ref. no. | The document reference number to end with. |
| Max. number of documents | The maximum number of documents to be selected from the database. The default value is 999. That is, the system selects 999 records from the database that comply specified criteria, applies additional filters, if needed, and displays the resulted list of records. |
| Include child documents | A field where you can select an option to indicate to the system the types of documents that belong to the child customer accounts of the selected parent account that should be loaded along with the documents of the currently selected customer account. The following options are available:
The field is available if both of the following conditions are met:
|
| Order by | An option you can select to order the listed documents, which can be one of the following:
|
| Load (button) | Loads the documents matching the specified criteria to the table and closes the dialog box. |
| Cancel (button) | Closes the dialog box. |
| Button | Description |
|---|---|
| Reverse application | Cancels the payment application. The button is not available for a document of the Balance write-off type. To reverse an application for this document type, void the document (Balance write-off) and release the voiding. The system sets the Voided status to the document ( Balance write-off ) and opens the invoice it has been applied to. |
| Column | Description |
|---|---|
| Branch | The branch to which the document belongs. |
| Batch number | The ID of the batch that contains appropriate transactions. If you click this number, the Journal transactions (GL301000) window opens, where you can view the details of the batch. |
| Type | The type of document to which the payment was applied. |
| Ref. no | The reference number of the customer ledger document to which the payment was applied. If you click this number, the Sales invoices (AR301000) window opens, where you can view the details of the customer ledger document. |
| Customer | The customer who issued the payment. |
| Amount paid | The amount that was actually paid which is displayed in the currency of the document that is selected in the window. |
| Cash discount taken | The cash discount taken during the application. |
| Balance write-off | The amount that has been written off. |
| Financial period | The financial period of the payment application. |
| Date | The date of the document (invoice or debit memo). |
| Due date | The due date of the customer ledger document. |
| Cash discount date | The last date when the cash discount for the customer was available. |
| Balance | The remaining amount after the cash discount was taken and certain amount was paid. |
| Cash discount balance | The unused amount of a cash discount, in case of partial payment. |
| Description | A description of the document. |
| Currency | The currency of the payment document. |
| Post period | The period to which payment transactions were posted. |
| Customer order | A reference to the customer document, such as a purchase order number. |
| VAT adjustment | A check box automatically selected by the system if the customer ledger document specified in this row is subject to VAT adjustment. |
| VAT Credit note | The reference number of the VAT credit note generated in the Generate VAT on cash discount (AR504500) window for the customer ledger document specified in this row. This reference number is specified by the system automatically once the VAT credit note is generated. |
| VAT doc. no. | The number of the VAT document. |
| Button | Description |
|---|---|
| Load orders | Opens the Load options dialog box so that you can add the customer’s orders to the list. |
| Column | Description |
|---|---|
| Order type | The order type for which the payment is to be reserved. A customer ledger payment may be reserved for the order types that generate customer ledger documents of the Invoice or Debit note type. |
| Order no. | The reference number of the order for which the payment is reserved. By clicking this number, the Sales orders (SO301000) window opens, in which you can view the order details |
| Status | The status of the document, which is assigned automatically and can be one of the following options: On hold, Credit hold, Open, Back order, Shipping, Cancelled, Invoiced, or Completed. For details on statuses, see: About sales order processing options. |
| Applied to order | The total amount reserved for the order. |
| Transferred to invoice | The amount that has been applied to invoice. |
| Date | The creation date of the order. |
| Due date | The due date of the order. |
| Cash discount date | The date through which the customer can take a cash discount. |
| Balance | The balance of the order after the cash discount is taken and the amount is paid. |
| Description | A description of the order. |
| Order total | The total amount of the document. |
| Currency | The currency of the document. |
| Invoice no. | The reference number of the invoice generated for the order. |
| Invoice date | The date of the invoice. |
| Element | Description |
|---|---|
| Branch | The branch in the company to which the order belongs. |
| To date | The latest date for the documents to be displayed. |
| From date | The earliest date for the documents to be displayed. |
| End order no. | The order number to end with. |
| Start order no. | The order number to start with. |
| Max. number of documents | The maximum number of documents to be selected from the database. The default value is 999. That is, the system selects 999 records from the database that comply specified criteria and applies additional filters, if needed. |
| Order by | An option you can select to order the documents on the list, which can be one of the following:
|
| Load (button) | Displays the documents matching the specified criteria and closes the dialog box. |
| Cancel (button) | Closes the dialog box. |
| Element | Description |
|---|---|
| Batch no. | The batch that contains appropriate transactions. You can click the batch number to view the batch. |
| Branch | The branch that had applied this payment. |
| Customer ledger account | The asset account specified as the default customer ledger account for the customer. |
| Customer ledger sub. | The corresponding default subaccount for the customer. |
| Project | The project with which this document is associated, or the code indicating that this document is not associated with any project; the non-project code is specified in the Project accounting preferences (PM101000) window. This field appears only if the Customer ledger workspace has been integrated with the Projects module in the Project accounting preferences (PM101000) window. |
| Project task | The particular task of the project with which this document is associated. This field appears only if the Customer ledger workspace has been integrated with the Projects module in the Project accounting preferences (PM101000) window. |
| Element | Description |
|---|---|
| Payment date | The date of the payment release. |
| Payment period | The period associated with the payment date. |
| Cleared | A check box that indicates (if selected) that the payment has been cleared with the bank. |
| Clear date | The date when the payment has been cleared with the bank. |
| Batch deposit | A check box that indicates (if selected) that payment should be deposited. You can change this option if the status of the cash account has been changed. Payments can be deposited only from a clearing cash account. |
| Deposited | A check box that indicates (if selected) that payment was deposited. |
| Batch deposit date | The date of the deposit. |
| Batch deposit no. | The number of the deposit that includes the payment. |
| Payment message | A free-form message connected with the payment, max. 140 characters. |
| Column | Description |
|---|---|
| Entry type | The charge, selected by its entry type ID. You can select the entry type from the list of entry types associated with the cash account.
Note
A finance charge will be posted as a cash transaction and will not affect the customer ledger. |
| Description | A detailed description of the entry type. |
| Offset account | The account that is used for this charge. |
| Offset subaccount | The corresponding subaccount for this charge. |
| Amount | The amount of the charge. |
| Column | Description |
|---|---|
| Price class ID | The unique identifier for the price class. An alphanumeric string of up to 10 characters may be used. |
| Description | A detailed description of the class. An alphanumeric string of up to 50 characters may be used. > [!NOTE] > This field supports the multi-language functionality, where you can translate the entered text to multiple languages. For more information, see: About multi-language support |
| Sort order | An integer indicating the order in which this class will be displayed on reports. The price class with the lowest value will be displayed as the leftmost column in all price classes. |
| Button | Description |
|---|---|
| Print statement | Navigates to the Customer statement report generated for the selected customer. |
| Element | Description |
|---|---|
| Customer | The customer by its ID. |
| Column | Description |
|---|---|
| Statement cycle | The statement cycle by ID. |
| Statement date | The date of the statement. |
| Statement balance | The customer balance (in the base currency) as shown on the statement. |
| Overdue balance | The overdue balance (in the base currency) as shown on the statement. |
| Currency | The currency used by the customer. |
| FC statement balance | The customer balance in the specified currency. |
| FC overdue balance | The overdue amount in the specified currency. |
| Do not print | A check box that indicates (if selected) that the statement should not be printed. |
| Printed | A check box that indicates (if selected) that the statement was printed. |
| Do not email | A check box that indicates (if selected) that the statement should not be sent by email. |
| Emailed | A check box that indicates (if selected) that the statement was sent by email. |
| On-demand statement | When this check box is selected, you can generate statements on demand. |
| Prepared on | The date when the statement was prepared. |
| Button | Description |
|---|---|
| Reports | Provides the following menu commands, which you can click for quick access to reports:
|
| Element | Description |
|---|---|
| Company | The company for which you want to display data. By default, it is the company you have access to. |
| Branch | The branch for which you want to display data. By default, it is the branch you have access to. |
| Period | The financial period for inquiry. If you leave the field blank, information related to all open periods will be displayed. |
| Customer class | The customer class selected for inquiry. You can leave the field blank to list customers of all classes. |
| Customer ledger account | The customer ledger account used for customers to be listed. |
| Customer ledger sub. | The corresponding subaccount. |
| Currency ID | The currency for which you want to display data. You can leave the field blank to view the balances in the all currencies used by the customers if you select the Split by currency check box or in the base currency if you clear the Split by currency check box. |
| Split by currency | A check box that you select to view the customer balances by currency. This check box is visible only if the Currency field is blank. |
| Only customers with balance | A check box that you select to display information on only customers that carry non-zero balances. Clear the check box to display all customers. |
| By financial period | A check box that you select to display balances calculated by financial period rather than by document date. Clear the check box to view the balances calculated by document date. |
| Consolidate by parent | A check box that you select to indicate to the system to display the consolidated balance for parent accounts that have child accounts for which the Consolidated balance check box is selected on the Invoicing info tab of the Customers (AR303000) window. The child accounts are excluded from the list if the check box is selected. The field is available if the Parent-child customer relationship functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Total balance | A read-only field that shows the total balance for the customers of the selected class or all classes calculated using the specified criteria. |
| Total prepayments | The total amount of customer prepayments calculated for the selected criteria. |
| Total unrealised gain/loss | The total amount of unrealised gains and losses calculated for transactions matching the selected criteria. |
| Column | Description |
|---|---|
| Customer no. | The unique ID of the customer, which is also a link. Click the link to navigate to the Customer details (AR402000) window with the details of this customer. |
| Customer name | The customer name as it appears in the documents. |
| Last activity period | The last period when any transactions related to the customer were released. |
| Currency ID | The currency used by the customer. |
| Beginning balance (currency) | The beginning balance on documents in the specified currency. |
| Ending balance (currency) | The ending balance on documents in the specified currency. |
| Prepayment balance (currency) | The balance of prepayments made in the specified currency. |
| Sales PTD (currency) | Period-to-date sales made in the specified currency. |
| Payments PTD (currency) | Period-to-date payments made in the specified currency. |
| Cash Discount Taken PTD (currency) | The cash discount total on cash discounts takes in the specified currency. |
| Overdue charges PTD (currency) | Period-to-date overdue charges in the specified currency. |
| Credit notes currency PTD | The total on credit notes made in the specified currency. |
| Debit notes currency PTD | The total on debit notes made in the specified currency. |
| Prepayments PTD (currency) | The total on prepayments made in the specified currency. |
| Beginning balance | The customer’s outstanding balance in the base currency at the start of the specified period. If no period is specified, the column shows the balance at the start of the last activity period. |
| Ending balance | The customer’s outstanding balance in the base currency at the end of the specified period. If no period is specified, the column shows the balance at the end of the last activity period. |
| Prepayment balance | The unapplied amount of the customer prepayments. |
| Sales PTD | The total amount (in the base currency) of the period-to-date (PTD) sales for the specified period. If no period is specified, the column displays the total sales amount during the last activity period. |
| Payments PTD | The total amount of the period-to-date payments (in the base currency) received from the customer for the specified period. If no period is specified, the column displays the total payment amount during the last activity period. |
| Cash discount taken PTD | The total period-to-date amount of cash discounts received by the customer for the specified period. If no period is specified, the column displays the total on all the cash discounts taken by the customer during the last activity period. |
| Realised gain/loss PTD | The total PTD amount of realised gains and losses received as the result of operations with the customer. If no period is specified, the column displays the total realised gain or loss (RGOL) amount for the customer during the last activity period. |
| Credit notes PTD | The total PTD amount of credit notes received from the customer. If no period is specified, the column displays the total credit note amount for the customer during the last activity period. |
| Debit notes PTD | The total PTD amount of debit notes received from the customer. If no period is specified, the column displays the total of the debit notes for the customer during the last activity period. |
| Unrealised gain/loss | The amount of unrealised gain or loss calculated for open documents. |
| Prepayments PTD | The amount of prepayments received during this period until the current date. |
| Button | Description |
|---|---|
| View batch | If you select a line in the table, you can click View batch to see the journal transactions for this line. You can also click the link in the Batch no. column to open the Journal transactions (GL301000) window. |
| View document | If you select a line in the table, you can click View document to see the supplier document for this line. You can also click the link in the Reference no. column to open the Sales invoices (AR301000) window. |
| View customer | Opens the Customers (AR303000) window so that you can view the customer account. |
| Element | Description |
|---|---|
| From period | The period from when you want to list customers with VAT zone deviations. |
| To period | The period to when you want to list customers with VAT zone deviations. |
| Document type | Use this field if you want to filter the list on specific document types:
|
| Ref. no. | Use this field if you want to see customer VAT deviation for a specific reference number. |
| Column | Description |
|---|---|
| Batch no. | The batch number that the customer document belongs to. |
| Invoice no. | The reference number of the document. You can click the link to view document details. |
| Type | The type of customer ledger document: Invoice, Credit note, Debit note, Payment, Overdue charge, or Prepayment. |
| Customer | The customer’s ID. |
| Customer name | The name of the customer. |
| Customer ledger account | The customer ledger account of the customer. |
| Customer ledger sub. | The customer ledger subaccount of the customer. |
| Invoice text | A detailed description of the document. |
| Currency | The currency of the document. |
| Total amount | The total document amount. |
| Document VAT zone | The VAT zone selected for the document. |
| Customer VAT zone | The VAT zone selected for the customer. |
| VAT total | The total VAT amount on the document. |
| Date | The date of the customer document. |
| Post period | The post period of the customer document. |
| Button | Description |
|---|---|
| View on map | A button you can click to view the customer’s location on a map. |
| Actions | Provides the following menu commands, which you can click to invoke actions:
|
| Inquiries | Provides the following menu commands, which you can click for quick access to inquiry windows:
|
| Reports | Provides the following menu commands, which you can click for quick access to reports:
|
| Element | Description |
|---|---|
| Customer no. | The number of the customer account, which is defined by the BIZACCT segmented key or by the CUSTOMER segmented key (which inherits its structure from the BIZACCT key). When you are creating a new customer, you must specify an ID.
Note
You can later change the customer number by selecting Change ID from the Actions menu in the toolbar. |
| Customer name | The name of the customer to appear in the system, which may be a trade name or a doing-business-as (DBA) name. |
| Status | The status of the customer account. You can select one of the following options:
|
| Balance | The total balance of all open documents of the customer including the total balance of prepayments. This read-only field appears only if you select an existing customer. |
| Prepayment balance | The total amount of unapplied prepayments calculated for the customer. This read-only field appears only if you select an existing customer. |
| Consolidated balance | The total balance of the parent customer account, including balances of its child accounts for which the Consolidate balance check box is selected in the Invoicing settings tab of this window. The amount includes the balances of all open documents and prepayments. The field is available if the Parent-child customer relationship functionality is enabled in the Enable/disable functionalities (CS100000) window, and is only visible in the top part of the parent customer account. |
| Retained balance | This field is not in use for the customer ledger. |
| Element | Description |
|---|---|
| Address 1 | The first line of the customer’s address. |
| Address 2 | The second line of the address. |
| Address 3 | The third line of the address. |
| Postcode | The customer’s postcode. You can set up an input validation rule for the country’s postcodes in the Countries/counties/postcodes (CS20400S) window. |
| City | The customer’s city. |
| Country | The customer’s country. |
| County | The customer’s county or province. |
| View on map | A button you can click to view the customer’s location on a map. |
| Element | Description |
|---|---|
| Company name | The legal business name of the customer to appear on the documents. |
| Attention | The attention line as it is used in your company’s business letters. This line will be used to direct the letter to the proper person or department. |
| The email address of the customer as a business entity. | |
| Web | The customer’s website address. |
| Phone 1 | The default phone number of the customer. |
| Phone 2 | An additional phone number of the customer. |
| Fax | The fax number of the customer. |
| Account ref. | Your company’s account number in the customer’s system. |
| Element | Description |
|---|---|
| Customer class | The class to which the customer is assigned. Once you select the customer class (which is required), the system fills in various elements in this window automatically with the values specified for the specified class; you can, however, change these values. |
| Terms | The type of payment terms used in operations with the customer. You define payment terms in the Payment terms (CS206500) window. |
| Statement cycle ID | The default statement cycle to be used for the customer. |
| Document language | The language in which the documents of the customer will be created. This field is also used when using the multi-language functionality. For more information, see: About multi-language support. |
| Apply payments automatically | A check box that indicates (if selected) that payments should be applied automatically to the customer’s documents. |
| Apply overdue charges | A check box that indicates (if selected) that you may apply overdue charges to this customer.
Note
The overdue charges will be applied to the documents created after you have selected this check box. That is, the system will calculate the overdue charges for the newly created invoices only. The overdue charges will not be calculated for the invoices created earlier than you have selected this check box. To set up the system to calculate the overdue charges for a document created earlier than you have selected this check box, you can select the Apply overdue charge check box for the document on the Financial details tab of the Sales invoices (AR301000) window. The option is available if the Overdue charges functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Enable write-offs | A check box that indicates (if selected) that balance and credit write-offs are allowed. |
| Exclude EC sales list | Select this check box if you want this customer to be excluded from the EC sales list (AR40501S). |
| Write-off limit | The maximum value that may be written off during each application line. Balances and credits that are less than this value may be written off. |
| Currency ID | The currency used in operations with the customer, which you can select from the list of currencies defined in the system. |
| Enable currency override | A check box that indicates (if selected) that users may override the currency specified as the default for the customer. |
| Currency rate type | The currency rate type used for the customer. |
| Enable rate override | A check box that indicates (if selected) that users may override the currency rate specified as the default for the customer. |
| Auto load documents | Select how documents for this customer will be automatically loaded in the Process bank transactions (CA306000) window for matching. The following options are available:
|
| Exclude debt collection | A check box that, if selected, will exclude the customer invoices connected to this customer class to be sent to debt collection. You can reverse this setting on the Customers (AR303000) window, tab General information, by de-selecting the check box Exclude debt collection. |
| Element | Description |
|---|---|
| Webhook notification | When this check box is selected and saved for a customer, you will be notified regarding changes. The Webhook notifications tab appears when you select the specific customer. More information about webhooks, see: About Webhooks. |
| Element | Description |
|---|---|
| Credit verification | The credit rule applied to this customer. The following options are available:
|
| Credit limit | The amount, if applicable, that serves as a credit limit for the customer. If the selected customer account is involved in the parent-child relationship, the field displays the credit limit of the group (parent account and its child accounts). |
| Credit days past due | The maximum number of days by which the customer payment may exceed the invoice date. This value is used if the Days past due or Limit and days past due option is selected in the Credit verification field. |
| Unreleased balance | The balance of unreleased documents. If the selected customer account is a parent account, the field displays the total balance of unreleased documents of the parent account and of its child accounts. For the child accounts the field displays individual balance. |
| Balance of open orders | The total balance of customer’s open orders, which is the sum of uninvoiced amounts of all orders to the customer except the orders that are assigned the On hold status. If the selected customer account is a parent account, the field displays the total balance of open orders of the parent account and of its child accounts. For a child account the field displays individual balance. |
| Remaining credit limit | The credit limit that is not used regarding the current balance. If the selected customer account is in a parent-child relationship, the field displays the remaining credit limit that applies to new sales orders and invoices of the parent account and its child accounts. |
| First due date | The due date of the earliest open invoice, if either Days past due or Limit and days past due option is selected in the Credit verification field, otherwise the value is not displayed. If the selected customer account is a parent account, the field displays the due date of the earliest open invoice among all the open invoices associated with a parent account of its child accounts. For a child account the field displays the due date of the earliest open invoice associated with this account. |
| Element | Description |
|---|---|
| Same as main | A check box that indicates (if selected) that the invoicing address is the same as the main address. If you select this check box, the elements below are populated with the main contact information. If the check box is cleared, you can enter different information. |
| Address 1 | The first line of the invoicing address. |
| Address 2 | The second line of the invoicing address. |
| Address 3 | The third line of the invoicing address. |
| Postcode | The postcode. An input mask for the postcode can be set in the Countries/counties/postcodes (CS20400S) window. |
| City | The customer’s city. |
| Country | The customer’s country. |
| County | The county or province of the customer. |
| View on map | A button you can click to view the location on a map. |
| Element | Description |
|---|---|
| Same as main | A check box that indicates (if selected) that the invoicing contact information is the same as the main information, and the elements below will be populated by the main address information specified on the General settings tab. |
| Company name | The name of the customer’s department as it should appear on the invoicing documents, if it is different from the customer name. |
| Attention | The attention line as it is used in your company’s business letters. This line will be used to direct the letter to the proper person or department. |
| Phone 1 | The remittance contact person’s phone number. |
| Phone 2 | An additional phone number for the contact person, in case there are invoicing questions. |
| Fax | The fax number of the contact person. |
| The contact person’s email address. | |
| Web | The customer’s invoicing-related web page. |
| Element | Description |
|---|---|
| Parent account | The parent account of the currently selected customer account. The availability of this field and the list of accounts that can be selected here depend on whether the Consolidate balance and Consolidate statements check boxes are selected for the selected customer account. If both check boxes are cleared, the field is always available and a business account of any type can be specified as the parent account. If at least one of the check boxes is selected, a business account of the Customer or Customer and supplier type should be specified as the parent account of the selected customer account. This field is disabled if the displayed customer account has child accounts (because an account cannot be both a child and a parent). For details, see: About setting up parent-child relationships. |
| Consolidate balance | A check box that indicates, if selected for a child account, that the balances of child accounts are included in the parent balance; in this case, the consolidated balance is shown in the Consolidated balance field in the top part of the corresponding parent account. You can apply the payments and credit notes of the parent account to the documents of this child account. In addition, you can select the Share credit policy check box to apply the credit policy configured for the parent account to the new sales orders and invoices of its child accounts. The check box value set for a parent account provides the default value of the check box for its child accounts. If you change the value for a parent account, the system will prompt you to change the value for all child accounts. For details, see: About balance consolidation. |
| Consolidate statements | A check box that indicates, if selected for a child account, that documents of the child accounts are included in the statements generated for the parent account. The check box value set for a parent account provides the default value of the check box for its child accounts. If you change the value for a parent account, the system will prompt you to change the value for all child accounts. For details, see: About credit policy application. |
| Shared credit policy | A check box that indicates, if selected for a child account, that the credit policy (a combination of the credit verification rules and credit limit) defined for its parent account will be applied to the new sales orders and invoices of the child account. The check box becomes available for selection, if the Consolidate balance check box has been selected for this account. The check box value set for a parent account provides the default value of the check box for its child accounts. If you change the value for a parent account, the system will prompt you to change the value for all child accounts. For details, see: About credit policy application. |
| Element | Description |
|---|---|
| Print invoices | A check box that, if selected, indicates that invoices can be printed in the Send invoices (AR508000) window. The default value of the setting is provided by the customer class. |
| Send invoices by email | A check box that, if selected, indicates that you can send invoices by email by using the Send invoices (AR508000) window. The default value of the setting is provided by the customer class. |
| Send dunning letters by email | A check box that, if selected, indicates that you can send dunning letters by email by using the Print/release dunning letters (AR522000) window. The default value of the setting is provided by the customer class. This field is available only if the Dunning letter management functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Print dunning letters | A check box that, if selected, indicates that dunning letters can be printed in the Print/release dunning letters (AR522000) window. The default value of the setting is provided by the customer class. This field is available only if the Dunning letter management functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Send statements by email | A check box that, if selected, indicates that statements can be sent by email to the customer in the Print statements (AR503500) window. The default value of the setting is provided by the customer class. |
| Multi-currency statements | A check box that indicates (if selected) that this customer’s statements must be printed in multi-currency format. If the check box is cleared, the system will print statements for the customer in the base-currency format. The check box is displayed if the Multi-currency accounting functionality is enabled in your system. |
| Print statements | A check box that, if selected, indicates that statements can be printed in the Print statements (AR503500) window. The default value of the setting is provided by the customer class. |
| Statement type | The statement type used by default in relations with the customer, which can be one of the following:
|
| Element | Description |
|---|---|
| Send invoices to AutoInvoice | Select this check box if you are using AutoInvoice and want to send invoices directly to this service. |
| Send invoices to AutoInvoice as banking e-Invoice (Norway) | A check box that, if selected, indicates that you can send invoices to AutoInvoice as banking e-invoices. This applies to Norway only. |
When this check box is selected, a new element is added into the outgoing invoice called MediaType that will be populated with the Print value. The customer language is also retrieved from the Document language field in the General information tab. This is used in Sweden when the printing service is activated. This check box is only visible when you have not enabled PEPPOL invoice in the Customer ledger preferences (AR101000). You can only select this check box if you select the Send invoices to AutoInvoice check box. |
|
| Exclude invoice PDF | When selected, this enables the possibility to not generate and imbed invoice PDF while sending electronic invoices via the PEPPOL BIS invoice format. This setting is only visible when you have enabled PEPPOL invoice in the Customer ledger preferences (AR101000). You can only select this check box if you select the Send invoices to AutoInvoice or Send invoices to AutoInvoice as banking e-Invoice (Norway) check box. |
| Use the first AutoInvoice attachment to view invoice | When selected, the system opens the first document attached to AutoInvoice. This way, you save time by not having to check the attachments manually. This check box is only visible when you have enabled PEPPOL invoice in the in the Customer ledger preferences (AR101000). You can only select this check box if you select the Send invoices to AutoInvoice or Send invoices to AutoInvoice as banking e-Invoice (Norway) check box and the Exclude invoice PDF check box. |
| Element | Description |
|---|---|
| Default payment method | The default payment method used for the customer. |
| Cash account | The cash account to be used for the default payment method. |
| Description | The identifier or description of the customer’s default payment method. |
| Account used for payment | The type of the account used for payments, such as Domestic payment. |
| Element | Description |
|---|---|
| Description | The name of a user-defined column configured to contain a detail of the payment method. |
| Value | The value of this payment method detail. |
| Element | Description |
|---|---|
| Same as main | A check box that indicates (if selected) that the delivery address is the same as the customer’s main address. If you select this check box, the elements below are populated with the main contact information specified on the General settings tab. If the check box is not selected, you can change the delivery address. |
| Address 1 | The first line of the delivery address. |
| Address 2 | The second line of the delivery address. |
| Address 3 | The third line of the delivery address. |
| Postcode | The customer’s postal code. If an input mask is set for the country postal codes, provide a valid code that matches the input mask. |
| City | The customer’s delivery location city. |
| Country | The customer’s country. By default, it is the country of your company. |
| County | The customer’s county or province. |
| View on map | A button you can click to view the customer location on the map. |
| Element | Description |
|---|---|
| Same as main | A check box that indicates (if selected) that the customer’s main information is used as its shipping info, and the elements below display the main company information. |
| Company name | The business name of the customer’s shipping location, if it’s different from the customer name. |
| Attention | The attention line as it is used in your company’s business letters, which would be used to direct the letter to the proper person if the letter is not addressed to any specific person. |
| The email address of the customer’s department to be used in case of delivery problems. | |
| Web | The customer’s website address. |
| Phone 1 | The default phone number of the customer’s receiving department. |
| Phone 2 | An additional phone number of the customer’s receiving department. |
| Fax | The fax number of the customer’s receiving department. |
| Element | Description |
|---|---|
| Location name | A description of the customer location. |
| VAT zone | The VAT zone of the customer’s default location. If a customer has been converted from a prospect account or extended from a supplier account, the customer’s VAT zone is by default set to the VAT zone (if any) specified for the original account. You can override the default value. |
| Corporate ID | The customer’s company ID, associated with the location. |
| VAT registration ID | The customer’s taxpayer ID associated with the location. |
| GLN | The global location number. This is an internationally standardised location ID used in electronic data interchange, used by AutoInvoice. |
| EDI code | An ID for the entire electronic data exchange used by AutoInvoice |
| Invoice to default location | A check box that you select to indicate that sales invoices and sales order for this customer automatically have the default invoice address and invoice contact. The invoice address and invoice contact can be overridden manually for each sales invoice in the Sales invoices (AR301000) window, the Invoice address tab, and each sales order in the Sales orders (SO301000) window, the Financial settings tab. |
| Shipping branch | The branch of your company that will be used to ship the goods to the customer. |
| Price class ID | The price class assigned to the customer. A price class, defined in the Customer price classes (AR208000) window, indicates the price level offered to the customer and can be used as a condition to be met for a discount application. |
| Element | Description |
|---|---|
| Warehouse | The warehouse to issue the goods to the customer. This field appears only if the Warehouses functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Ship via | The carrier used to ship the goods. |
| Shipping terms | The shipping terms used for the customer. |
| Shipping zone ID | The identification of the shipping zone of the customer to be used to calculate freight. |
| FOB point | The location at which the title for the shipment passes from your company to the customer. |
| Residential delivery | A check box that you select to indicate that delivery will not be performed to a business. |
| Saturday delivery | A check box that you select to indicate that this customer allows delivery on Saturdays. |
| Insurance | A check box that informs a user (if selected) that insurance is required for the order. |
| Shipping rule | The way the orders should be fulfilled for this customer. You can use one of the following options:
|
| Order priority | The priority of sales orders of this customer. (This setting has no business logic tied to it in the current version and can be used for informational purposes only.) |
| Lead time (days) | The number of days preceding the due date for the shipping title to reach the customer. |
| Element | Description |
|---|---|
| Mode of transportation | Intrastat is the system for collecting information and producing statistics on the trade in goods between countries of the European Union (EU). The mode of transportation denotes how the goods is transported. Available values are: 0 - Unknown 1 - Transport by sea 2 - Transport by rail 3 - Transport by road 4 - Transport by aeroplane 5 - Consignments by post 7 - Fixed transport installations 8 - Transport by inland waterway |
| Button | Description |
|---|---|
| Add location | Opens the Customer locations (CR303010) window, so you can enter a new customer location. |
| Set as default | Selects the Is default check box for the selected location. Only one location can be selected as the default one. |
| Column | Description |
|---|---|
| Active | A check box that indicates (if selected) that the location is active. If the check box is cleared, the location will not be available for selection when users create customer documents. |
| Is default | A check box that indicates (if selected) that the location has been set as the default customer location. You cannot directly select or clear this check box; to make a location the default location, you select the location and click Set as default in the toolbar. |
| Location ID | The unique ID of the location. |
| Location name | A descriptive name of the customer’s location. |
| City | The city of the customer’s location. |
| Country | The country of the customer’s location. |
| County | The county or province of the customer’s location. |
| VAT zone | A VAT zone associated with the county. |
| Price class ID | The price class to be used by default for this customer location. |
| Sales account | The account selected in the Sales account field in the Customer locations (CR303010) window. |
| Sales sub. | The corresponding subaccount. |
| EDI code | An ID for the entire electronic data exchange used by AutoInvoice. |
| GLN | The global location number. This is an internationally standardised location ID used in electronic data interchange, used by AutoInvoice. |
| Button | Description |
|---|---|
| Add payment method | Navigates to the Customer payment methods (AR303010) window, so that you can define a new payment method for the customer. |
| View payment method | Navigates to the Customer payment methods (AR303010) window, so that you can view the details of the customer payment method. Customer payment methods have the Override check box selected. |
| Column | Description |
|---|---|
| Is default | A check box that indicates (if selected) that the payment method is the default one for the customer. You select this check box to mark the payment method as the default one for this customer. |
| Payment method | The payment method ID. |
| Description | The description of the payment method. |
| Cash account | The cash account associated with the payment method. |
| Active | A check box that indicates (if selected) that the payment method is used in the system. |
| Override | A check box that indicates (if selected) that the payment method is specific to the customer (that is, it was created by using the Customer payment methods (AR303010) window). |
| Button | Description |
|---|---|
| Add contact | Opens the Contacts (CR302000) window in a pop-up window so that you can enter a new contact. |
| Set as default | Selects the Is default check box for the selected contact person. Only one contact can be selected as the default one. |
| Column | Description |
|---|---|
| Active | A check box that indicates (if selected) that the contact is active. |
| Is default | A check box that indicates (if selected) that the contact person is the default one for the customer. |
| Position | The position the contact person has in his or her company. |
| Name | The contact person’s name. You can click the link in this column to open the Contacts (CR302000) window in a pop-up window. |
| City | The contact person’s city. |
| The contact person’s email address. | |
| Phone 1 | The contact person’s phone number. |
| Column | Description |
|---|---|
| Salesperson ID | The ID of the salesperson who is assigned to the customer. |
| Name | The salesperson’s name. |
| Location ID | The customer location associated with the salesperson. |
| Location name | A descriptive name of the customer location. |
| Commission % | The commission percent used for the salesperson. The column is available if the Commissions functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Default | A check box that indicates (if selected) that this salesperson is the default salesperson for this customer. |
| Column | Description |
|---|---|
| Customer no | The number of the customer account, which is defined by the BIZACCT segmented key or by the CUSTOMER segmented key (which inherits its structure from the BIZACCT key). When you are creating a new customer, you must specify an ID.
Note
You can later change the customer number by selecting Change ID from the Actions menu in the toolbar. |
| Customer name | . The name of the customer to appear in the system, which may be a trade name or a doing-business-as (DBA) name. |
| Balance | The total balance of all open documents of the customer including the total balance of prepayments. This read-only field appears only if you select an existing customer. |
| Prepayment balance | The total amount of unapplied prepayments calculated for the customer. This read-only field appears only if you select an existing customer. |
| Unreleased balance | The balance of unreleased documents. If the selected customer account is a parent account, the field displays the total balance of unreleased documents of the parent account and of its child accounts. For the child accounts the field displays individual balance. |
| Balance of open orders | The total balance of customer’s open orders, which is the sum of uninvoiced amounts of all orders to the customer except the orders that are assigned the On hold status. If the selected customer account is a parent account, the field displays the total balance of open orders of the parent account and of its child accounts. For a child account the field displays individual balance. |
| First due date | The due date of the earliest open invoice, if either Days past due or Limit and days past due option is selected in the Credit verification field, otherwise the value is not displayed. If the selected customer account is a parent account, the field displays the due date of the earliest open invoice among all the open invoices associated with a parent account of its child accounts. For a child account the field displays the due date of the earliest open invoice associated with this account. |
| Consolidate balance | The total balance of the parent customer account, including balances of its child accounts for which the Consolidate balance check box is selected in the Invoicing settings tab of this window. The amount includes the balances of all open documents and prepayments. The field is available if the Parent-child customer relationship functionality is enabled in the Enable/disable functionalities (CS100000) window, and is only visible in the top part of the parent customer account. |
| Consolidate statement | A check box that indicates, if selected for a child account, that documents of the child accounts are included in the statements generated for the parent account. The check box value set for a parent account provides the default value of the check box for its child accounts. If you change the value for a parent account, the system will prompt you to change the value for all child accounts. For details, see: About credit policy application. |
| Share credit policy | A check box that indicated, if selected that the credit policy configured for the parent account applies to the new sales orders and invoices of its child accounts. |
| Statement cycle | The default statement cycle to be used for the customer. |
| Column | Description |
|---|---|
| Attribute | The description of the attribute. |
| Required | A check box that indicates (if selected) that specifying the attribute value is required. |
| Value | The value of the attribute. |
| Button | Description |
|---|---|
| Add task | Opens the Task (CR306020) window so you can create a new task. |
| Add event | Opens the Event (CR306030) window so you can create a new event. |
| Add email | Opens the Send (CR306015) window so you can send an email to the customer. |
| Add activity | Contains a menu with options that correspond to the list of available activity types. By clicking on a menu option, you open the Activity (CR306010) window, which you use to create an activity of the corresponding type. |
| Column | Description |
|---|---|
| Type | The type of the activity. |
| Summary | The description provided for the activity. |
| Status | The status of the activity. |
| Start date | The start date and time of the activity. |
| Created at | The date and time when the activity was created. |
| Time spent | The total time spent on the activity. |
| Work group | The work group the activity is assigned to (if any). |
| Owner | The username of the user to whom the activity is assigned. |
| Related entity description | The entity that this activity is associated with. |
| Created by | The user who has created the activity. |
| Project | The project with which the activity is associated, or the code indicating that this activity is not associated with any project; the non-project code is specified in the Project accounting preferences (PM101000) window. This field appears if the Customer ledger workspace has been integrated with the Projects module in the Project accounting preferences (PM101000) window. |
| Project task | The task in the project with which the activity is associated. This field appears if the Customer ledger workspace has been integrated with the Projects module in the Project accounting preferences (PM101000) window. |
| Released | A check box that indicates whether or not the activity is released. |
| Element | Description |
|---|---|
| Customer ledger account | The asset account that stores the balance of the transactions related to the customer. |
| Customer ledger sub. | The subaccount used for the customer. |
| Sales account | The income account used to record sales made to the customer. By default, it is the account specified for the customer class. You must specify this account. |
| Sales non-taxable account | The account for non-taxable sales. |
| Sales - EU account | The account for sales within the European Union. |
| Sales - export account | The account for export sales. |
| Sales sub. | The subaccount used to record the sales made to the customer. You must specify the subaccount. |
| Discount account | The expense account used to record discount amounts received by the customer. You must specify the account if you plan to use configurable discounts. This field is available only if the Customer and supplier discounts functionality is enabled in the Enable/disable functionalities (CS100000) window. For details, see: Manage discounts. |
| Discount sub. | The subaccount (if any) used with the expense account to record the discount amounts received by the customer. You must specify this subaccount if you plan to use configurable discounts. This field is available only if the Customer and supplier discounts functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Freight account | The income account used to record the freight charges for delivering goods to the customer. |
| Freight sub. | The corresponding subaccount used to record freight charges applied for delivering the goods to the customer. |
| Cash discount account | The expense account used to record cash discount amounts received by the customer due to its payment terms. You must specify the account. |
| Cash discount sub. | The subaccount used with the expense account to record the discount amounts received by the customer due to its payment terms. You must specify this subaccount. |
| Prepayment account | The asset account to accumulate prepayments to the customer. |
| Prepayment sub. | The subaccount used with the prepayment account to record the prepayment amounts sent to the customer. |
| Column | Description |
|---|---|
| Mailing ID | The unique ID of the mailing. |
| Branch | The branch of the organisation on behalf of which this mailing will be set up. |
| Email account | The system email account to be used by default for sending emails to the customer for this mailing. If no account is specified, the system account specified for the customer class will be used. |
| Report | The Customer ledger report to be used to structure the information from the document, if a report is selected for the mailing rather than an email template (notification template). |
| Notification template | The notification template to be used to generate personalised emails for the mailing. For each mailing, either a report or a notification template can be specified. |
| Format | The format in which the report-based document, if applicable, will be sent by default if the recipient has no other preferences. Select one of the following options: HTML, Excel, or PDF. |
| Active | A check box that indicates (if selected) that this mailing is active. Only active mailings are used to generate emails. |
| Overridden | A check box that indicates (if selected) that the default mailing for the customer class has been changed. |
| Column | Description |
|---|---|
| Contact type | The type of contact to receive emails. Specify one of the following options:
|
| Contact ID | The particular recipient of the selected type. |
| The email address of this recipient. | |
| Format | The format in which the report (if applicable) will be sent to this recipient. Select one of the following options: HTML, Excel, or PDF. |
| Active | A check box that indicates (if selected) that this contact is active. Only active recipients receive the emails for the mailing. |
| To | A check box that indicates (if selected) that this contact will be the main recipient for this mailing. |
| Bcc | A check box that indicates (if selected) that this contact will receive a blind carbon copy (bcc) of the email for this mailing. |
| Column | Description |
|---|---|
| Finvoice contract ID | The ID of the customer’s Finvoice contract. |
| Finvoice intermediator ID | The ID of the customer’s Finvoice intermediator. |
| Column | Description |
|---|---|
| Mandate ID | The unique ID for the direct debit mandate. |
| Mandate description | The description of the direct debit mandate. |
| Date of signature | The date the customer signed the direct debit mandate. |
| Is default | If you select this check box, you indicate which mandate is used as default value in a sales invoice if more than one mandate is linked to the customer. |
| One time | If you select this check box, you indicate that this is a one-time mandate. |
| BIC (SWIFT) | The BIC code of the customer’s bank account. |
| IBAN | The IBAN of the customer’s bank account. |
| Last collection date | The date of the last direct debit transaction for this mandate. |
| Max. amount | The maximum amount that can be collected for this mandate in a single transaction. |
| Expiration date | The date when the mandate expires. |
| Branch | The ID of the branch being used. |
| Column | Description |
|---|---|
| Discount code | The unique code for the discount. You can use up to 10 characters, both letters and numbers. |
| Description | A brief description of the discount. Use an alphanumeric string of up to 50 characters. |
| Discount type | The type of the discount, which can be one of the following options:
|
| Applicable to | The entity to which the discount may be applied. For a Line or Group discount, you can select one of the following options:
For a document discount, the following options are available:
|
| Applied to deferred revenue | A check box that (if selected) indicates that a discount should be applied to a component price while computing a deferred revenue for the component. This option is applied to the Line discounts only. This check box is only available if the Deferred revenue management functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Manual | A check box that (if selected) indicates that this discount is excluded from automatic searches for the best available discount. A user can, however, add manual discounts to a document line or to a document. |
| Exclude from discountable amount | A check box that (if selected) indicates that the line amount is excluded from the amount that is the base for any applicable Group or Document discount. This option is available for only line-level discounts. |
| Skip document discounts | A check box that indicates (if selected) that after this discount has been applied, no other applicable discounts should be applied. This option is available to only Group discounts. |
| Auto-numbering | A check box that you select to use auto-numbering for generating IDs for series based on this discount code. By default, the discount code will be used as a prefix for generating series IDs, but you can instead specify in the Last number column a series of characters to be used as a template for auto-numbering. |
| Last number | The last ID used for the series if series IDs are auto-numbered. If you enter a series of characters here before any series is created, the character series will be used as a template for auto-numbering. The character series may contain up to 10 characters with digits at the end. The last letter used divides the character series into a prefix and the integer to be auto-incremented. If no value is specified, the discount code will be used as a prefix. |
| Button | Description |
|---|---|
| Update discounts | Opens the Update discounts dialog box, which you can use to select pending discount series by their start date (pending date) for updating. As a result of updating, the current discount amounts (or per cents) become the last discount amounts (or per cents), and the pending discount amounts (or per cents) become the current discounts. |
| Element | Description |
|---|---|
| Filter date | The latest pending date to select discount series for updating. |
| OK (button) | Updates the discounts that are selected based on the specified date. |
| Cancel (button) | Cancels your selection and closes the dialog box. |
| Element | Description |
|---|---|
| Discount code | The code of the discount for which you want to create a new series or view an existing one. |
| Series | The ID of the series defined for the discount. An alphanumeric string of up to 10 characters can be used. An ID will be generated by the system if auto-numbering is selected for the discount in the Discount codes (AR209000) window. |
| Active | A check box that indicates (if selected) that the series is active. Active series for the same discount should not have overlapping time intervals, or if they do, the series should apply to different entities. |
| Promotional | A check box that indicates (if selected) that the series is a promotional discount. For promotional discount series, you must specify the effective date and the expiration date ( End date ). |
| Description | A brief description of the series. An alphanumeric string of up to 30 characters can be used. |
| Discount by | The way the discount for the series is specified. The following options are available:
|
| Break by | The way the breakpoints for this discount series are specified. Select one of the following options:
|
| Prorate discount | A check box that indicates (if selected) that the discount can be prorated. With prorated discounts, the amount of the discount (or the number of free items) is calculated as if the order is split into multiple orders, so that the customer can get the largest possible discount. To determine the amount of the discount (or the number of free items) for a discountable quantity larger than one break point but less than the next break point, the system treats the discountable quantity as a combination of break point quantities, by using the largest possible break point quantities. It then calculates the discount amount (or the number of free items) according to the breakpoints used. |
| Effective date | The date when the series becomes effective. This field appears for the series if the Promotional check box is selected. |
| Expiration date | The date when the promotional discount expires. This field appears for the series if the Promotional check box is selected. |
| Last update date | A read-only field that shows the date when the discount series was last updated. This field appears only for a non-promotional discount series; the system inserts a value if the series has been updated at least once. |
| Column | Description |
|---|---|
| Break quantity | The quantity of items (break quantity) that starts the new range for a discount level for the currently effective series. Any break quantity should be specified in the base units. |
| Discount percent | The discount percent to be currently used for the quantities that exceed this break quantity if the Percent option is selected as Discount by. |
| Discount amount | The discount amount to be used for the quantities that exceed this break quantity if the Amount option is selected as Discount by. |
| Pending break quantity | The quantity of items (break point) that starts the new range for the pending (not yet effective) series. |
| Pending discount percent | The discount percent to be used with the pending break point for the pending series if the Percent option is selected as Discount by. |
| Pending discount amount | The amount to be used as the discount for the pending series if the Amount option is selected as Discount by. |
| Pending date | The start date for the pending series. |
| Last break quantity | The quantity of item (break point) that started the range for the discount series used before the effective date. |
| Last discount percent | The discount percent used for the break point for the discount series that was in effect before the effective date. |
| Last discount amount | The amount used as the discount for the discount series that was in effect before the effective date. |
| Last date | The date when the current series became effective. |
| Column | Description |
|---|---|
| Break amount | The line or document amount (break point) that starts the new range for the currently effective series. |
| Discount percent | The discount percent to be used for the amounts that exceed this break amount for the currently effective series. |
| Effective date | The date when the current series has became effective. |
| Pending break amount | The amount (break point) that starts the new range for the pending series (one that is not yet in effect). |
| Pending discount percent | The discount percent to be used for the break point in the pending series. |
| Pending date | The start date for the pending series. |
| Last break amount | The amount (break point) that started the new range for the previously effective series (the one that was used before the effective date). |
| Last discount percent | The percentage used for the break point in the previously effective series. |
| Column | Description |
|---|---|
| Break amount | The line amount (break point) that starts the new range for the currently effective series. |
| Free item qty. | The quantity of the free item to be added as the discount to orders for this discount series. |
| Pending date | The start date for the pending series. |
| Pending break amount | The amount (break point) that starts the new range for the pending series (the one that is not yet in effect). |
| Pending free item qty. | The quantity of the free item to be added as the discount to orders for the pending discount series. |
| Effective date | The date when the current series has became effective. |
| Last break amount | The amount (break point) that started the new range for the previously effective series (the one that was used before the effective date). |
| Last free item qty. | The quantity of the free item that was used as the discount for the previously effective series. |
| Column | Description |
|---|---|
| Break amount | The line amount (break point) that starts the new range for the promotional series. |
| Discount amount | The amount of the discount for this range for the promotional series. |
| Element | Description |
|---|---|
| Free item | The free item (by its item ID) that is added to orders as the discount for this series. |
| Pending free item | The free item (by its item ID) that will be added to orders as the discount for this series, starting on the date specified in the Pending date column on the Discount breakpoints tab. |
| Last free item | The free item (by its item ID) that had been added to orders as the discount for this series before the date shown in the Last date column on the Discount breakpoints tab. |
| Last update date | A read-only field that shows the date when this discount series has been updated last. |
| Column | Description |
|---|---|
| Item ID | The stock or non-stock item, by its item ID, to which the series can be applied. |
| Description | The description of the item. |
| Column | Description |
|---|---|
| Price class ID | The item price class to which the series is applicable. |
| Description | The description of the item price class. |
| Column | Description |
|---|---|
| Customer | The customer to which the series is applicable. |
| Description | The business name of the customer. |
| Column | Description |
|---|---|
| Customer price class ID | The customer price class to which the series is applicable. |
| Description | The description of the customer price class. |
| Column | Description |
|---|---|
| Warehouse ID | The warehouse to which the series can be applied. |
| Description | The description of the warehouse. |
| Column | Description |
|---|---|
| Branch | The branch to which the series can be applied. |
| Description | The description of the branch. |
| Element | Description |
|---|---|
| Customer | The customer account, by its ID. |
| Start date | The start date in the date range for which you want to display the history of dunning letters. |
| End date | The end date in the date range for which to display the history of dunning letters. |
| Button | Description |
|---|---|
| View dunning letter | Opens the Dunning letters (AR306000) window, where you can view the list of documents included in the letter. |
| Column | Description |
|---|---|
| Branch | The branch for which you want to display data. Only displayed if you are using multiple branches. |
| Customer | The customer account associated with the dunning letter, by its ID. |
| Customer name | The customer name. |
| Dunning letter level | The level of the dunning letter. |
| Status | The status of the dunning letter, which can be one of the following:
|
| Overdue balance | The total overdue amount owed by the customer. |
| Dunning letter date | The creation date of the dunning letter. |
| Number of documents | The number of documents listed in the letter. |
| Element | Description |
|---|---|
| Customer | The customer account, by its identifier. |
| Start date | The start date in the date range for which you want to display the history of the documents. |
| End date | The end date in the date range for which you want to display the history of the documents. |
| Element | Description |
|---|---|
| From | The starting level in the range of dunning letter levels for which you want to display the history of documents. |
| To | The ending level in the range of dunning letter levels for which you want to display the history of documents. |
| Button | Description |
|---|---|
| View dunning letter | Opens the Dunning letters (AR306000), where you can view the list of documents included in the letter. |
| Column | Description |
|---|---|
| Customer | The customer account, by its identifier. |
| Type | The type of the document. |
| Invoice no. | The reference number of the document. You can click the link to view document details. |
| Document balance | The balance of the document. |
| Due date | The due date of the document. |
| Dunning level | The dunning level of the document. |
| Dunning letter status | The status of the dunning letter, which can be one of the following:
|
| Dunning letter date | The creation date of the dunning letter. |
| Button | Description |
|---|---|
| Release | Releases the selected dunning letter. |
| Void | Voids the selected dunning letter. |
| Prints the selected dunning letter. |
| Element | Description |
|---|---|
| Status | The status of the dunning letter, which can be one of the following:
|
| Dunning letter level | The level of this dunning letter. The system uses the value of this box to define for which dunning fee amount the invoice should be generated. If there are documents with different dunning level are included in the letter, the system uses the highest level (among document levels) to set as the dunning level of the letter. You can delete documents with the highest level to decrease the level of the letter. |
| Customer | The customer associated with the dunning letter, by its ID. |
| Dunning letter date | The creation date of this dunning letter. |
| Fee ref. no. | The reference number of the invoice that was created for the dunning fee amount specified for this level of the dunning letter. The invoice is created when you release the dunning letter. You can click the link to view document details. |
| Button | Description |
|---|---|
| Revoke | Excludes the selected document from the dunning process. The action is available for dunning letters with the Draft status. After you have excluded a document, you can again include the document in the dunning process by clearing the Revoked check box on the Financial details tab of the Sales invoices (AR301000) window. |
| Column | Description |
|---|---|
| Type | The type of the document. |
| Ref. no. | The reference number of the document. You can click the link to view document details. |
| Due date | The due date of the document. |
| Original document amount | The original document amount. |
| Overdue balance | The overdue amount of the document. |
| Dunning letter date | The creation date of the dunning letter. |
| Dunning level | The dunning level of the document. |
| Element | Description |
|---|---|
| Start date | The start date of the date range for which you want to display contracts. |
| Duration | The number of days included in the date range. The system will display contracts with expiration dates in this date range. |
| Show contracts available for mass renewal | A check box that you select to include the auto-renewable contracts that will expire during the specified date range. |
| Customer class | The class of the customers with similar settings. Leave the field blank to show information on all classes. |
| Contract template | A contract template used for contracts with similar settings. Leave the field blank to show information on all templates. |
| Column | Description |
|---|---|
| Contract ID | The contract’s ID. Click the ID to navigate to the Customer contracts (CT301000) window to see the details of the selected contract. |
| Description | A description of the contract. |
| Contract template | The template used for the contract. |
| Contract type | The type of contract. |
| Customer | The customer associated with the contract, by ID. |
| Customer name | The name of the customer. |
| Status | The status of the contract. |
| Setup date | The date of the contract setup. |
| Expiration date | The date when the contract expires. |
| Mass renewal | A check box that, if selected, indicates that the contract is available for mass processing and is to be displayed in the Renew contracts (CT502000) window. |
| Last invoicing date | The date of the most recent invoicing for the contract. |
| Next invoicing date | The date of the next invoicing for the contract. |
| Element | Description |
|---|---|
| Contact | The user whose details are registered. |
| Column | Description |
|---|---|
| Display name | The name of the user that is used in the different windows of the system. |
| Address 1 | The first address line of the user’s address. |
| Address 2 | The second address line of the user’s address. |
| Address 3 | The third address line of the user’s address. |
| Postcode | The postcode of the user’s address. |
| City | The city of the user’s address. |
| County | The county of the user’s address. |
| Country | The country of the user’s address. |
| The email address of the user. | |
| Phone 1 | The telephone number 1 of the user. |
| Phone 2 | The telephone number 2 of the user. |
| Phone 3 | The telephone number 3 of the user. |
| Fax | The user’s fax number. |
| Date of birth | The user’s date of birth. |
| Created by | The user who has registered the user details. |
| Created on | The date when the user details have been created. |
| Last modified by | The user who has last modified the details of the user. |
| Last modified | The date when the details of the user have been last modified. |
| Button | Description |
|---|---|
| Run | Runs the schedules you have selected (by using the unlabelled check boxes in the table) and generates documents with an Open status. |
| Run all | Runs all schedules in the table. |
| New schedule | Navigates to the Recurring transactions (AR203500) window, from which you can create a new schedule. |
| Element | Description |
|---|---|
| Execution date | The date that the system uses to filter the schedules to be loaded to the table. Those schedules whose Next execution date is earlier than or equal to the date specified in this field are loaded. Clear the field to display all schedules. By default, the current business date is displayed. |
| Stop on execution date | An option button that indicates that the date you specify in the Execution date field will be used as the date when the system stops running the schedules. |
| Stop after number of executions | An option button that indicates that the system stops running schedules when the specified number of schedule executions have been performed. You specify the number of schedule executions in the field located near this option button. |
| Column | Description |
|---|---|
| Included | An unlabeled check box that you can use to select this schedule for processing. |
| Schedule ID | The schedule’s unique ID. By clicking the number, the system opens the Recurring transactions (AR203500) window as a dialog window; in this window, you can view the details of the selected schedule. |
| Description | The user-defined description of the schedule. |
| Start date | The start date for the schedule. |
| Expiration date | The expiration date for the schedule. |
| Executed (times) | The number of times the documents attached to the schedule were generated. |
| Execution limit (times) | The maximum number of times the schedule may be executed. |
| Next execution | The date when the documents should be generated next. |
| Last executed | The date when the documents were last generated, according to the schedule. |
| Button | Description |
|---|---|
| Process | Initiates the process of generating credit notes for the documents you have selected in the table. |
| Process all | Initiates the process of generating credit notes for all listed documents. |
| Element | Description |
|---|---|
| Date | The date, which you select to view unprocessed documents with payment dates earlier than or the same as the selected date. By default, the current business date is selected. |
| Branch | The branch for which you want to view documents. By default, the company branch is specified. |
| Customer | The customer whose documents you want to view. You can leave this field empty to view the documents of all customers.
Note
If the parent-child relationships are established between customer accounts (that is, if the Parent-child customer relationship functionality is enabled in your system in the Enable/disable functionalities (CS100000) window), and if the parent company has paid the invoice of the child company, you can create the credit note for the child company by selecting the customer that represents the parent company in this field (or by leaving this field empty). |
| Consolidate credit notes by customer | A check box that indicates (if selected) that one credit note will be generated for multiple documents grouped by the branch, customer, customer location, currency, customer ledger account (and customer ledger subaccount, if any), and VAT zone. The check box is selected by default. If you clear this check box, a separate credit note will be generated for each document. |
| Credit note date | The date to be used as the date of the credit note. This option is required if the Consolidate credit notes by customer check box is selected in this window. By default, the current business date is selected. |
| Period | The financial period, which you select to post credit notes. This option is required if the Consolidate credit notes by customer check box is selected in this window. By default, it is the period of the current business date. |
| Column | Description |
|---|---|
| Branch | The branch to which the document in the row relates. |
| Customer | The customer specified in the document of this row. |
| Doc. type | The type of the document in this row. |
| Ref. no. | The number that identifies the document in the system. |
| Doc. date | The document date. |
| Currency | The currency of the document. |
| Amount | The total document amount. |
| Cash discount | The amount of the cash discount applied to the document. |
| Payment terms | The payment terms specified for the document. |
| Payment ref. no. | The number that identifies the related payment in the system. |
| Element | Description |
|---|---|
| Cash account | In the table will be displayed the incoming payments with the cash account that you select here. |
| Ref. no. | Select the reference number of the document you want to process or create a new one. |
| Import date | The date when the payment was imported. |
| Buttons | Description |
|---|---|
| Unhide transaction | Click this to unhide a selected transaction. This will clear the Processed and Hidden check boxes for the transaction. The transaction becomes available for processing in the Process incoming payments (AR305000) window. |
| Unmatch | Click this to unmatch a matched transaction. |
| View matched document | Click this to view the details of the matched document. |
| Column | Description |
|---|---|
| Matched | This check box is selected by default, it the transaction has been matched. |
| Processed | This check box is selected by default, it the transaction has been processed. |
| Hidden | This check box is selected by default, it the transaction has been hidden. |
| Trans. ID | The ID of the transaction. |
| Ext. ref. no. | The reference number of the transaction. |
| Trans. date | The original date of the transaction. |
| Trans. descr. | The description of the transaction. |
| Receipt | The amount of the receipt. |
| Disbursement | The amount of the disbursement. |
| Invoice no. | The internal reference number for the invoice/credit note that has been paid. |
| Orig. receipt | The original amount of the receipt. |
| Orig. disbursement | The original amount of the disbursement. |
| Applied rule | The rule that was applied when matching the payment. |
| Account from bank | The bank account or IBAN from which the payment was paid for the customer transactions. In some formats, it contains the IBAN or bank account from which you have paid to the supplier. |
| Archive code | The code of the document in the archive. |
| Business account | The supplier or customer associated with the document, by its account ID. |
| Business account name | The name of the supplier or customer associated with the document. |
| Entry type ID | The ID of an entry type that is used as a template for a new cash transaction to be created to match the selected bank transaction. |
| Invoice number list | When a line refers to more than one invoice number, the invoice numbers are listed here. |
| Location | The location of the supplier or customer. |
| Module | The module from which the transaction originates. |
| Name from bank | The name of the bank that processed the document. |
| Payee name | The payee name, if any, specified for a transaction. |
| Payment method | The payment method that was used for the transaction. |
| Payment number list | When a line refers to more than one payment reference, the payment reference numbers are listed here. |
| Payment ref. no. | The reference number of the payment. |
| Trans. code | The code of the transaction. |
| Workspace | The involved workspace in the system. |
| Element | Description |
|---|---|
| Cash account | In the table will be displayed the incoming payments with the cash account that you select here. |
| From date | The date from which the transactions will be displayed in the table. |
| To date | The date until which the transactions will be displayed in the table. |
| Statement no. | The number of the statement whose transactions you want to view. |
| Element | Description |
|---|---|
| Statement no. | The number of the statement from which the transaction comes. |
| Ext. ref. no. | The reference number of the payment. |
| Match type | The available match types are:
|
| Trans. date | The original date of the transaction. |
| Trans. descr. | The description of the transaction. |
| Receipt | The amount of the disbursement. |
| Disbursement | The amount of the receipt. |
| Invoice no. | The internal reference number for the invoice/credit note that has been paid. |
| Entry type ID | The ID of an entry type that is used as a template for a new cash transaction to be created to match the selected bank transaction. |
| Applied rule | The rule that was applied when matching the payment. |
| Workspace | The workspace from which the transaction originates. |
| Type | The type of the original transaction. |
| Ref. no. | The reference number of the invoice to which the transaction belongs. |
| Business account | The supplier or customer associated with the document, by its account ID. |
| Business account name | The name of the supplier or customer associated with the document. |
| Location | The location of the supplier or customer. |
| Payee name | The payee name, if any, specified for a transaction. |
| Payment method | The payment method that was used for the transaction. |
| Trans. ID | The ID of the transaction. |
| Trans. code | The code of the transaction. |
| Element | Description |
|---|---|
| Item ID | Select the item you want to view the invoice history for. |
| Item class | The item class of the items to be included in the report. Leave the field blank to include requests for items of multiple classes. |
| Subaccount | The subaccount for which you want to view information for the item. |
| Customer | The customer that has ordered the goods or services. |
| Customer class | The class of the customers to be included in the report. |
| Salesperson | The salesperson for whom you want to view information. Leave the field blank to view information on all salespersons. |
| Group by salesperson | Groups the lines of the table per salesperson. |
| From period | The first financial period for the date range the inquiry will cover. |
| To period | The last period for the date range the inquiry will cover. |
| Start date | The starting date in the date range for which you want to display the history of sales. |
| End date | The ending date in the date range for which you want to display the history of sales. |
| Column | Description |
|---|---|
| Salesperson | The salesperson associated with the sale. |
| Item ID | The sold stock or non-stock item, by its item ID. You can click the link to view the details of the item in the Stock items (IN202500) or Non-stock items (IN202000) window. |
| Item description | The description provided for the item. |
| Quantity | The total ordered quantity of the item. |
| Cost of goods sold | The accumulated COGS balance from the sales order lines for the item. |
| Sales | The accumulated sales balance from the sales order lines for the item. |
| Profit | The profit for the sold item (calculated: Sales - COGS). |
| Margin | The margin for the sold item (calculated: profit as percentage of Sales). |
| Button | Description |
|---|---|
| Process | Initiates the processing, based on the selected action, of the customer accounts you have selected. |
| Process all | Initiates the processing of all customer accounts listed in the table. |
| Element | Description |
|---|---|
| Action | The operation the system performs if you click Process or Process all. The following options are available:
If you select this option, the table will include only the customers eligible for applying the credit hold. In other words, the table will include the customers for which the final dunning letters were generated and the credit hold was not applied. This rule applies only when the Show all check box is not selected.
If you select this option, the table will include only the customers eligible for releasing the credit hold. In other words, the table will include the customers for which the final dunning letters were generated and the credit hold was applied. This rule applies only when the Show all check box is not selected. |
| Show all | A check box that you select to have the table include all the customers for which the final dunning letters were generated in the specified date range. If you do not select this check box, the table will display the customers as specified in the description of the Action field. |
| Start date | The starting date of the date range within which the final dunning letters were generated. Date selection is available only if the Apply credit hold action is selected. |
| End date | The ending date of the date range within which the final dunning letters were generated. Date selection is available only if the Apply credit hold action is selected. |
| Column | Description |
|---|---|
| Customer no. | An ID of the customer account. |
| Customer name | The name of the customer. |
| Dunning letter date | The date when the final letter was generated. The column is available if the Dunning letter management functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Overdue balance | The overdue amount owed by the customer. |
| Customer balance | The total amount of the open customer documents. |
| Status | The status of the customer account. |
| Button | Description |
|---|---|
| Process | Click the check boxes to select the documents for which you want to create payments and click Process. The selected documents are processed and the system creates a Reference number from Payments for each payment.
|
| Element | Description |
|---|---|
| Due date less than or equal to | The due date of the documents to be displayed in the table is less than or equal to the date you select here. |
| Payment method | The payment methods of the documents to be displayed in the table. If you do not select anything here, in the table are displayed documents with all payment methods. |
| Button | Description |
|---|---|
| View document | View the sales invoice connected with the document selected in the table. |
| View payment | View the payment invoice connected with the document selected in the table. |
| Column | Description |
|---|---|
| Document type | The type of the document. The options are:
|
| Invoice ref. no. | The invoice number. Sort and drill down to see the invoice. |
| Customer | The customer’s ID. |
| Customer name | The customer’s name. |
| Amount | The document amount. |
| Balance | The balance of the document. |
| Amount paid | The actual amount paid. |
| Payment date | The date of the payment release. You can edit the pay date, so that overdue charges will be calculated correctly. |
| Payment period | The period associated with the payment date. |
| Ref. no. from Payments | Shows the reference number after you have processed the payments. |
| KID-number | The customer identification number from the payment. |
| Date | The date on the invoice. |
| Currency | The currency used on the invoice. |
| Due date | The due date of the document. |
| Cash account | The cash account connected with the invoice. |
| Payment method | The description of the payment method used on the invoice. |
| Element | Description |
|---|---|
| Overdue charge ID | The unique ID for the overdue charge code. You can use up to 10 characters, both numbers and letters. |
| Description | A description of the overdue charge code. You can use up to 30 characters, both numbers and letters |
| Calculation method | The way the system calculates charges for overdue documents. The following options are available:
|
| Terms | The payment terms that apply to generated documents of the Overdue charge type. You create payment terms by using the Payment terms (CS206500) window to provide a schedule for paying this overdue charge. |
| Base currency | A check box that indicates (if selected) that the system will calculate the overdue charge by using the base currency. If the check box is cleared, the system will calculate the overdue charge by using the currency of an overdue document. |
| Overdue charge account | The account to which collected overdue charges are recorded. |
| Overdue charge subaccount | The corresponding subaccount. |
| VAT category | The VAT category, if applicable to this overdue charge and overdue fee (if any). |
| Element | Description |
|---|---|
| Fee amount | The amount of the fee for an overdue charge document (if your company charges any). If the Base currency check box is selected, the fee is charged in the base currency. If the check box is cleared, the fee is charged in the currency of the overdue document. |
| Fee account | The account to which the overdue fee is recorded. |
| Fee subaccount | The corresponding subaccount. |
| Description | A description of the overdue fee. > [!NOTE] > This field supports the multi-language functionality, where you can translate the entered text to multiple languages. For more information, see: About multi-language support |
| Element | Description |
|---|---|
| Total threshold | The minimum amount of overdue charges that should initiate the generation of a document of the Overdue charge type. |
| Charging method | The way the system charges an overdue document. An overdue charge can be defined either as a fixed amount or as a percentage (annual rate) on a document’s open balance for the number of days late. The following options are available:
|
| Amount | The amount that the system uses as the fixed charge amount for overdue documents when the Fixed amount charging method is applied. This field is available if the Fixed amount option is selected in the Charging method field. |
| Threshold | The threshold amount of overdue charges, which defines whether to charge an overdue document when the Percent with threshold charging method is applied. This field is available if the Percent with threshold option is selected in the Charging method field. |
| Min. amount | The minimum amount that the system uses to charge an overdue document when the Percent with min. amount charging method is applied. This field is available if the Percent with min. amount option is selected in the Charging method field. |
| Element | Description |
|---|---|
| Start date | The date when the rate in this row becomes effective. |
| Percent rate | The annual percentage rate to be used to calculate an overdue charge. |
| Column | Description |
|---|---|
| Box ID | The ID of the type of packages. An alphanumeric string of up to 15 characters may be used. |
| Description | A description of the content of the package. |
| Tare weight | The weight of an empty package of this type, may include the weight of any packaging material used to pack items inside the package. |
| Max. weight | The maximum weight a package of that type can hold. |
| Weight UoM | The unit of measure used for the weight as specified in the Inventory preferences (IN101000) window. |
| Max. volume | The maximum volume of items that can fit into a package of the type. |
| Volume UoM | The unit of measure used for the volume as specified in the Inventory preferences (IN101000) window. |
| Length | The length of the package.
Note
For information purposes only; the value is not used in any calculation. |
| Width | The width of the package.
Note
For information purposes only; the value is not used in any calculation. |
| Height | The height of the package.
Note
For information purposes only; the value is not used in any calculation. |
| Active by default | If you select this check box, the package will be added by default to the list of packages on the Packages tab of the Ship via codes (CS207500) window for each new ship via code. |
| Button | Description |
|---|---|
| Process | Initiates the process of generating dunning letters for the selected records or those for which you have selected the unlabeled check boxes in the table. |
| Process all | Initiates the process of generating dunning letters for all the records in the table. |
| Element | Description |
|---|---|
| Customer class | The customer class for which you want to display data. You can select a particular customer class to view only customers of the class that have overdue balances, or leave the field blank to view all customers with overdue balances. |
| Customer | The name of the customer. |
| Dunning letter date | The date to be specified on the generated letters. |
| Include other unpaid documents | A check box that you select to include unpaid documents that are not yet due in the preparation of dunning letters. |
| Include credit note documents | A check box that indicates, if selected, that the dunning letter will contain credit notes. |
| Split by documents reference number | A check box that indicates, if selected, that the table below will contain information split by the documents reference number. If not selected, the table will contain documents grouped by customer. |
| Element | Description |
|---|---|
| All overdue documents | The option button that you select to include all the overdue documents of a customer into the dunning letters preparation process. |
| Dunning letter level | The option button that you select to include into the dunning letters preparation process those overdue documents whose level is in the range specified in the From and To fields. |
| From | The starting level of the range. The field is available if the Dunning letter level option is selected. |
| To | The ending level of the range. The field is available if the Dunning letter level option is selected. |
| Column | Description |
|---|---|
| Customer class | The customer class of the customer. |
| Customer | The identifier of the customer. |
| Customer name | The name of the customer. |
| Earliest due date | The due date of the oldest overdue invoice of the customer. |
| Branch | The branch on behalf of which the letter will be sent. If one consolidated letter is generated for all branches, the branch selected as the letter sender on the General settings tab of the Customer ledger preferences (AR101000) window is shown. |
| Overdue balance | The overdue amount that is due from the customer (sum of open invoices, overdue charges and debit notes). |
| Number of overdue documents | The number of overdue documents of the customer for which a dunning letter of the current level (by customer or by document) has not been prepared yet. |
| Customer balance | The total balance of all open documents of the customer including the total balance of prepayments. |
| Number of documents | The number of overdue and other unpaid documents of the customer for which a dunning letters of the current level (by customer or by document) has not been prepared yet. |
| Dunning letter level | The level of the dunning letter to be generated for the customer. |
| Last dunning letter date | The date of the previous dunning letter, if any has been generated. |
| Button | Description |
|---|---|
| Process | Initiates processing of the statements for the cycles you have selected in the table. |
| Process all | Initiates processing of statements for all cycles listed in the window. |
| Column | Description |
|---|---|
| Prepare for | The date for which you want to prepare statements. |
| Cycle ID | The unique ID of the cycle. |
| Description | The description of the statement cycle. |
| Last statement date | The date when the statements for the cycle were last generated. |
| Last finance charge date | The date when overdue charges were last calculated for the customers. |
| Schedule type | The selected statement cycle processing option. The following values are available: The end of the month, A fixed day of the month, and Custom. |
| Next statement date | The date when the statements should be generated next, according to the cycle settings. |
| Button | Description |
|---|---|
| Process | Initiates processing, based on the selected action, of the documents you have selected in the table. |
| Process all | Initiates processing of all documents, with the specific type of processing dependent on the action selected, listed in the table. |
| View document | Displays the selected document in the window in which it was originally created. |
| Element | Description |
|---|---|
| Action | The processing action to be taken. The following options are available:
If applicable, it also updates the Business level status found in the Sales invoices (AR301000) window.
|
| Show all | A check box that indicates to the system (if selected) to display all the documents with a status other than Closed, regardless of specified selection criteria. |
| Show closed invoices/credit notes | (This check box appears when you select the Poll invoice status or the Send to AutoInvoice action.) When this check box is selected, the system will display all documents with the Closed status. |
| Start date | The starting date of the date range within which documents were created. |
| End date | The ending date of the date range within which documents were created. |
| Column | Description |
|---|---|
| Type | The type of the document: Invoice, Debit note, Credit note, Overdue charge, or Credit write-off. |
| Invoice no. | The unique ID of the document. You can click the link to view the details of the selected document in the Sales invoices (AR301000) window. |
| Date | The date of the document. |
| Post period | The financial period of the document. |
| Customer | The customer associated with the document. |
| Customer name | The name of the customer as it appears on the documents. |
| Due date | The due date of the document in accordance with the payment terms assigned to the customer. |
| Amount | The amount of the document. |
| Cash discount | The cash discount amount available for the document. |
| Currency | The currency of the document. |
| Customer order | The document reference number used by the customer. |
| Printed | A check box that indicates (if selected) that the document was printed. |
| Do not print | A check box that indicates (if selected) that printing of this document is not mandatory for further processing. |
| Emailed | A check box that indicates (if selected) that the document was emailed. |
| Do not email | A check box that indicates (if selected) that emailing of this document is not mandatory for further processing. |
| Send to AutoInvoice | A check box that indicates (if selected) that the document will be sent to AutoInvoice. |
| Sent to AutoInvoice | A check box that indicates (if selected) that the document was sent to AutoInvoice. |
| AutoInvoice status | The status of the invoice in AutoInvoice. |
| Sending method | Here you can select the sending method: Standard or Consumer. |
| AutoInvoice sent by | Here you can filter the invoices on the manner it was sent to AutoInvoice. The options are: Home network, Email, Print, Print PRIORITY, e-invoice, Bank network, N/A. |
| AutoInvoice error message | If the invoice has an error in AutoInvoice, the error message from AutoInvoice is displayed here. |
| Button | Description |
|---|---|
| Create customer refunds | Click this to create customer refunds and to open a window, where you can view the status of your refunds and send them to AutoPay. |
| Element | Description |
|---|---|
| Payment method | Select the payment method you want to filter on. |
| Cash account | Select the cash account you want to filter on. |
| Date before | Select the date before you want to filter on. |
| Customer | Select the customer you want to filter on. |
| Element | Description |
|---|---|
| Payment method | Select the preferred payment method. You can only select from payment methods that have the Create batch payment (customer and supplier ledgers) check box selected in the Payment methods (CA204000) window. |
| Cash account | The Cash account is automatically displayed, but you can select another one if you want to. |
| Payment date | In the Payment date field, select the date you want the refund to take place. |
| Currency | The currency of the refund. If you have a cash account that uses foreign currency, you can use the View base button to view the amount(s) in the base currency instead of the foreign currency. |
| Customer | The customer to whom the refund will be paid. |
| Post period | The post period of the refund. |
| Element | Description |
|---|---|
| GL balance | General ledger balance |
| Available balance | Available balance |
| Selection total | The total of the selected documents |
| Bank balance | Bank balance |
| Documents to pay | The number of documents to pay. |
| Column | Description |
|---|---|
| Doc. type | The document type of the payment to be refunded. |
| Ref. no. | The reference number of the document. |
| Customer | The number of the customer to whom the refund will be paid. |
| Customer name | The name of the customer to whom the refund will be paid. |
| Customer account | The account of the customer to which the refund will be paid. |
| Payment ref. no. | The reference number of the payment refund. |
| Pay separately | Select this if you want to pay the refund separately. |
| Payment date | In the Payment date field, select the date you want the refund to take place. The suggested date is today’s date. |
| Amount paid | In the Amount paid column, verify the suggested amount or change the amount you want to refund. |
| Balance | The remaining balance of the payment that can be refunded. |
| Currency | The currency of the balance. |
| Balance (original currency) | The balance of the payment in the original currency. |
| Button | Description |
|---|---|
| Process | Initiates reprinting of the documents you have selected in the table. |
| Process all | Initiates reprinting of all documents listed in the table. |
| View document | Shows the document connected with the invoice/note selected in the table. |
| Element | Description |
|---|---|
| Action | The processing action to be taken. The following option is available:
|
| Start date | The starting date of the date range within which documents were created. |
| End date | The ending date of the date range within which documents were created. |
| Column | Description |
|---|---|
| Type | The type of the document: Invoice, Debit note, Credit note, Overdue charge, or Credit write-off. |
| Invoice no. | The unique ID of the document. You can click the link to view the details of the selected document in the Sales invoices (AR301000) window. |
| Date | The date of the document. |
| Post period | The financial period of the document. |
| Customer | The customer associated with the document. |
| Customer name | The name of the customer as it appears on the documents. |
| Due date | The due date of the document in accordance with the payment terms assigned to the customer. |
| Amount | The amount of the document. |
| Cash discount | The cash discount amount available for the document. |
| Currency | The currency of the document. |
| Customer order | The document reference number used by the customer. |
| Button | Description |
|---|---|
| Process | Initiates processing, based on the selected action, of the letters you have selected in the table. |
| Process all | Initiates processing, based on the selected action, of all letters listed in the table. |
| Element | Description |
|---|---|
| Action | The processing action to be taken if you click Process or Process all. Select one of the following options:
|
| Show all | A check box that you select to indicate to the system that all letters should be displayed, no matter dates specified and what kind of processing they require, printing, emailing, or other. |
| Start date | The date that starts the date range during which the dunning letters were generated. |
| End date | The date that ends the date range during which the dunning letters were generated. |
| Button | Description |
|---|---|
| View dunning letter | Opens the Dunning letters (AR306000) window, where you can view the list of documents included into the letter. |
| Column | Description |
|---|---|
| Branch | The branch for which you want to display data. |
| Customer | The customer associated with the dunning letter, by its ID. |
| Customer name | The name of the customer. |
| Dunning letter date | The creation date of the dunning letter. |
| Dunning letter level | The level of the dunning letter. |
| Overdue balance | The total overdue amount owed by the customer. |
| Final reminder | A check box that indicates (if selected) that this dunning letter is a final reminder. In this case, the customer account for which such letter was prepared can be selected in the Manage credit holds (AR523000) window, so you can put this account on credit hold. |
| Do not print | A check box that indicates (if selected) that this dunning letter should not be printed. |
| Printed | A check box that indicates (if selected) that this dunning letter has been printed. |
| Do not email | A check box that indicates (if selected) that this dunning letter should not be emailed. |
| Emailed | A check box that indicates (if selected) that this dunning letter has been emailed. |
| Button | Description |
|---|---|
| Process | Initiates processing of the statements you have included (by selecting the unlabelled check boxes in the table) for the selected cycle. |
| Process all | Initiates processing of all statements (listed in the window) of the selected cycle. |
| Inquiries | List of inquiries you can navigate to from this window:
|
| Element | Description |
|---|---|
| Actions | The action to be applied to the statements selected for processing:
|
| Statement cycle | A statement cycle whose statements will be processed. |
| Statement date | The date of the statements. |
| Branch | The branch for which you want to view statements. |
| Foreign currency statements | A check box that indicates (if selected) that foreign currency statements should be included in processing. |
| Show all | A check box that indicates (if selected) that all statements (processed or not) will be displayed in the table. |
| Message | In this field, you can write a free-form message connected with the statement. |
| Column | Description |
|---|---|
| Customer | The unique identifier of the customer. |
| Customer name | The name of the customer. |
| Statement balance | The balance of the customer’s statement in the base currency. |
| Overdue balance | The overdue balance of customer’s statement in the base currency. |
| Currency | The currency of the statement. |
| FC statement balance | The balance of the statement in the foreign currency. |
| FC overdue balance | The overdue balance of customer’s statement in the foreign currency. |
| FC statement balance | A check box that indicates (if selected) that the statement is in the foreign currency. |
| Do not print | A check box that indicates (if selected) that it is not required to print the statement in accordance with the customer settings in the Customers (AR303000) window. |
| Printed | A check box that indicates (if selected) that the statement has been printed in accordance with the customer settings in the Customers (AR303000) window. |
| Do not email | A check box that indicates (if selected) that it is not required to email the statement to the customer in accordance with the customer settings in the Customers (AR303000) window. |
| Emailed | A check box that indicates (if selected) that the statement has been emailed in accordance with the customer settings in the Customers (AR303000) window. |
| Button | Description |
|---|---|
| Status description | Click this to open a dialogue box that shows you the statuses of the active document, such as “Remaining balance available”. |
| Match automatically | When you click this, the system tries to match the imported incoming payments with the customer ledger invoices in the system. The matching is based on payment reference and/or invoice numbers. For payments that the system has matched automatically, you see that the Ready to process check box is selected. These are now ready for processing. |
| Process | Initiates the processing of transactions with the Ready to process check box selected. The processing takes place on all lines that are ready for processing, regardless of any filters set on the table. After processing, in the first column, a |
| Setting for matching | In the Settings for matching dialog box, you can temporarily change the settings for matching, for example date settings or the weight settings for the relevance calculation. The settings you make here disappear when you leave the window. |
| Element | Description |
|---|---|
| Days before bank transaction date | The maximum number of days allowed between the date of a cash management transaction (disbursement) and the date of the selected transaction on the bank statement. The system considers the disbursement a matching one if the difference falls within the specified date range. |
| Days after bank transaction date | The maximum number of days allowed between the date of the selected transaction on the bank statement and the date of a receipt. The system considers the disbursement a matching one if the difference falls within the specified date range. |
| Allow matching to credit note | A check box that (if selected) indicates that the system will automatically match the receipt bank transactions to credit notes by the reference number prior to matching them to the purchase invoices. If the check box is cleared (the default value), the receipt bank transactions are always matched to the purchase invoices. |
| Element | Description |
|---|---|
| Days before bank transaction date | The maximum number of days allowed between the date of cash management transaction (receipt) and the date of the selected transaction on the bank statement. The system considers the receipt a matching one if the difference falls within the specified date range. |
| Days after bank transaction date | The maximum number of days allowed between the date of the selected transaction on the bank statement and the date of a receipt. The system considers the receipt a matching one if the difference falls within the specified date range. |
| Ref. no. weight | The relative weight of the evaluated difference between the reference numbers of the bank transaction and the cash management transaction. |
| Consider empty ref. no. as matching | A check box that (if selected) specifies that a bank transaction with an empty reference number is considered as matching to a cash transaction with an empty reference number. If this check box is cleared (the default value), transactions with empty reference numbers are not considered as matching. |
| Doc. date weight | The relative weight of the evaluated difference between the dates of the bank transaction and the cash management transaction. |
| Doc. payee weight | The relative weight of the evaluated difference between the names of the customer (or supplier) on the bank transaction and the cash management transaction. |
| Element | Description |
|---|---|
| Average delay payment clearing | The average number of days for a payment to be cleared with the bank. |
| Estimated deviation (days) | The number of days before and after the average delay date during which 50% of payments are generally cleared. |
| Skip voided transactions during matching | A check box that you select to make the system skip voided transactions during the reconciliation process. |
| Save and close (button) | By clicking this button it saves the settings during your working session and closes the dialog box. |
| Element | Description |
|---|---|
| Cash account | If you do not use a default account or want to match payments from a different account, select the account in the Cash account field. The system displays all imported payments for that account in the table. |
| Display only relevant matches | Invoices matching the criteria set up in the Settings for matching dialog box are automatically displayed and matched on the relevance factor. If you do not want to display invoices with 0 match relevance, select the Display only relevant matches check box. |
| Button | Description |
|---|---|
| Unmatch | Click this to unmatch the selected match. |
| Unmatch all | Click this to unmatch all matches that have been done this time. |
| Hide selected | Click this to hide the transactions that are selected in the Hide column from the table. This undoes all changes to the selected transactions and marks them as processed. To be able to view and process a hidden transaction again, select the transaction in the Import incoming payments (AR305500) window and click Unhide transaction. |
| Undo split | Click this to undo the splitting of the selected split line. If you have processed one or more of the split lines, you will not be able to undo the split on the not processed lines. |
| Column | Description |
|---|---|
| Ready to process | A check box that, if selected, indicates to the system that this transaction is ready to be processed. Namely, the transaction has been matched to the transaction in the system or details of a new document (to match this transaction) were specified. |
| Trans. date | The original date of the transaction. |
| Trans. descr. | The description of the transaction. |
| Disbursement | The amount of the disbursement. |
| Receipt | The amount of the incoming payment. |
| Orig. receipt | The original amount of the receipt. |
| Orig. disbursement | The original amount of the disbursement. |
| Trans. code | The code of the transaction. |
| Hide | A check box which you can select for each transaction you want to hide. After you have made your selection, click the Hide selected button. |
| Account from bank | The bank account or IBAN from which the payment was paid for the customer transactions. In some formats, it contains the IBAN or bank account from which you have paid to the supplier. |
| Archive code | The code of the document in the archive. |
| Customer/Supplier no | The supplier or customer associated with the document, by its account ID. |
| Customer/Supplier name | The name of the supplier or customer associated with the document. |
| Entry type ID | The identifier of the entry type that was used to create a document to match the transaction. |
| Invoice no. | The internal reference number for the invoice/credit note that has been paid. The system uses this column to make a lookup against the reference number on the purchase invoice if it is a disbursement and on the sales invoice if it is a receipt. |
| Invoice number list | When a line refers to more than one invoice number, the invoice numbers are listed here. |
| Location | The location of the supplier or customer. |
| Match type | The available match types are:
|
| Workspace | The workspace from which the transaction originates. This field is displayed if the Supplier ledger or Customer ledger option is selected in the Workspace field. |
| Name from bank | The name of the bank that processed the document. |
| Payee name | The payee name, if any, specified for a transaction. |
| Payment method | The payment method that was used for the transaction. |
| Payment number list | When a line refers to more than one payment reference, the payment reference numbers are listed here. |
| Payment ref. no. | The reference number of the payment. |
| Ext. ref. no. | The reference number of the invoice. |
| Trans. ID | The ID of the transaction. |
| Trans. entry date | The entry date of the transaction. |
| Column | Description |
|---|---|
| Matched | A check box that you select to match the document in this row to the transaction selected in the left pane. |
| Match relevance | The coefficient of the match relevance, which is less than or equal to 1 and is calculated automatically for the selected transaction in the left pane and this document. |
| Workspace | The workspace in which the document was entered. |
| Trans. type | The document type to which the selected payment from the left part can be applied. |
| Orig. doc. number | The ID of the document, as assigned by the corresponding numbering series. |
| Document ref. | The number of the corresponding external document, if one exists. |
| Description | A detailed description of the document. |
| Doc. date | The date of the transaction or document. |
| Post period | The post period of the payment. |
| Incoming payment | The document amount or transaction amount if it is a receipt. |
| Disbursement | The document amount or transaction amount if it is a disbursement. |
| Element | Description |
|---|---|
| Customer/Supplier no. | The number of the customer or the supplier account. |
| Location | The business account location associated with the document. |
| Payment method | The payment method associated with the document. |
| Account no. | The account to which the payment has been made. |
| Update bank account | You can update the IBAN/BBAN from the imported bank payment line. In the Cash management preferences (CA101000) window under Bank statement settings, select the check box Update bank account on customer/supplier from Process bank transactions. When the payment line contains a bank account from the bank and you select a customer/supplier, a lookup against the default IBAN/BBAN will be done. If the customer’s/supplier’s bank account is empty or different, the button Update bank account will appear. If you click the button the customer/supplier is updated with the account from the bank. |
| Column | Description |
|---|---|
| Matched | A check box that you select to match the document in this row to the transaction selected in the left pane. |
| Match relevance | The coefficient of the match relevance, which is less than or equal to 1 and is calculated automatically for the selected transaction in the left pane and this document. |
| Released | A check box that indicates (if selected) that the invoice has been released. |
| Workspace | The workspace in which the document was entered. |
| Type | The document type to which the selected payment from the left part can be applied. |
| Ref. no. | The reference number of the document. Click the link to view the details of the document. |
| Ext. ref. no | The supplier’s reference number. |
| Doc. date | The date of the document. |
| Amount | The document amount. |
| Customer/Supplier no. | The number of the customer or the supplier account. |
| Customer/Supplier name | The name of the customer or the supplier, associated with the document. |
| Description | The invoice text provided for the document. |
| Branch | The branch on which the document is created. This column is only available if the Multi-Branch support check box is selected and enabled in the Enable/disable functionalities (CS100000) window. |
| Element | Description |
|---|---|
| Create | Select this check box to initiate creating a new document for the selected transaction. Clear the check box to delete any information you have specified for the new document. |
| Clear rule | A button that clears the applied rule and the settings the system has configured by using the applied rule. |
| Create rule | Click this button to navigate to the Bank transaction rules (CA204500) window where you can create a new rule, view and modify the details of the rule and save it for future use.
Note
You can define rules to create documents originating in the Cash management workspace only. |
| Cash account details/ Customer details/ Supplier details | Click this button to open the cash account, supplier ledger or customer ledger window as a pop-up to see the details of the selected document. The name of the button changes depending on the selected workspace. In the Cash management preferences (CA101000) window, the Bank statement settings tab, you can define which window will be opened for the different workspaces. If no window has been selected, the following windows will be opened:
|
| Workspace | The workspace where the document originated. Select one of the following workspaces:
|
| Entry type ID | The ID of an entry type that is used as a template for a new cash transaction to be created to match the selected transaction. The field is displayed if the Cash management option is selected in the Workspace field. |
| VAT zone | Change or specify the VAT zone or VAT category that applies to the transaction if necessary. The VAT calculation mode is set to Gross by the system, and the VAT category field is updated with the default value when the VAT zone is selected. The field is displayed if the Cash management option is selected in the Workspace field. |
| VAT calculation mode | This field has a read-only value that always shows Gross. |
| Trans. descr. | The description of the selected transaction that can be modified. These changes affect the description in the new document only; the description of the imported bank transaction or incoming payment remains unchanged (the table in the left pane). |
| Customer/Supplier no. | The ID and name of the customer or the supplier, associated with the document. This field is visible if the Supplier ledger or Customer ledger option is selected in the Workspace field. |
| Location | The location of the supplier or customer. This field is visible if the Supplier ledger or Customer ledger option is selected in the Workspace field. |
| Payment method | The payment method used by the customer or supplier for the document. This field is visible if the Supplier ledger or Customer ledger option is selected in the Workspace field. |
| Invoice no. | The internal reference number for the invoice/credit note that has been paid. The system uses this column to make a lookup against the reference number on the purchase invoice if it is a disbursement and on the sales invoice if it is a receipt. This field is displayed if the Supplier ledger or Customer ledger option is selected in the Workspace field. |
| Total amount | The total amount of the document. |
| Amount used | The amount of the transaction for which the documents This field is displayed if the Cash management option is selected in the Workspace field. |
| Remaining balance | The balance of the transaction for which you can add the documents. This field is displayed if the Cash management option is selected in the Workspace field. |
| Application amount | The amount of the application for this payment. This field is displayed if the Supplier ledger or Customer ledger option is selected in the Workspace field. |
| Unapplied balance | The unapplied balance of the document. This field is displayed if the Supplier ledger or Customer ledger option is selected in the Workspace field. |
| Write-off amount | The total amount of write-offs specified for documents to be applied. This field is displayed if the Customer ledger option is selected in the Workspace field. |
Split (button) |
Click this button to split the selected line in the left table into different lines. The button only appears when there is a remaining amount to match. To read more about this functionality, go to Match a bank transaction or incoming payment line to different documents. If the Automatic split of batch payment from customers into payments per customer check box is selected on the Incoming payments settings tab in the Cash management preferences (CA101000) window, payments will be automatically split on incoming payments import. |
| Allow unapplied balance | Select this check box to process payments in situations where you need to overrule the setting Do not create payment when bank payment amount is not fully applied. This check box is available only if the setting Do not create payment when bank payment amount is not fully applied is selected in the Bank statement settings tab in the Cash management preferences (CA101000) window and the unapplied balance is different from 0. |
| Column | Description |
|---|---|
| Branch | The branch that created the document. This column is only available if the Multi-Branch support check box is selected and enabled in the Enable/disable functionalities (CS100000) window. |
| Description | The description of the document. By default, this is the description in the Trans. descr. field in the top part of this tab, and you can edit it. |
| Quantity | The quantity of the item. |
| Price | The price for the item. |
| Amount | The total amount for all items. |
| Offset cash account | The cash account to be updated by the document. By default, it is an offset cash account defined with the entry type selected in the Entry type ID field, but you can change this account. The field is displayed if the selected entry type is used for payments reclassification. |
| Offset account | The account to be updated by the document. By default, it is an offset account defined with the entry type selected in the Entry type ID field, but you can change this account. |
| Description | A description of the account. |
| Offset subaccount | The corresponding subaccount to be used for the document. |
| Item ID | The ID of the non-stock item used as a transaction subject. |
| VAT category | The default value is based upon what you selected in the VAT zone field. |
| Non-invoiceable | A check box that indicates (if selected) that this document line is non-invoiceable in the project. This column appears only if the Projects module has been enabled and integrated with this workspace |
| Project | The project with which this document is associated, or the non-project code indicating that this document is not associated with any project. The Non-project code is specified in the Project accounting preferences (PM101000) window. The Project accounting check box is enabled in the Enable/disable functionalities (CS100000) window. That is, the Cash management check box must be selected in the Visibility settings section on the General information tab in the Project accounting preferences (PM101000) window. The column is hidden by default. |
| Project task | The particular task of the project with which this document is associated. The column is available if the Project accounting check box is enabled in the Enable/disable functionalities (CS100000) window. That is, the Cash management check box must be selected in the Visibility settings section on the General information tab in the Project accounting preferences (PM101000) window. The column is hidden by default. |
| Button | Description |
|---|---|
| Select documents | By clicking the button, the Select documents pop-up window appears. Here you can select multiple documents using the date and branch filters on the top and the Select all documents option. You need to select a Customer/Supplier no. in the top part of this tab for documents to be displayed in this pop-up window. If you click the button and there is no conversion rate between the cash account’s currency and none of the documents’ currencies of the selected Customer/Supplier no., a message appears. It notifies that you need to define the exchange rate for the currency of this cash account in the Currency rates (CM301000) window. |
| Load documents | By clicking the button, the customer or the supplier documents will load in the table, until the sum of their amounts reach the Total amount in the top part, starting with the oldest documents. If you click the button and there is no conversion rate between the cash account’s currency and none of the documents’ currencies of the selected Customer/Supplier no., a message appears. It notifies that you need to define the exchange rate for the currency of this cash account in the Currency rates (CM301000) window. |
| Element | Description |
|---|---|
| Up to due date | The last due date up to which you want to filter the documents. |
| Branch | The branch on which you want to select the documents. By default the cash account’s branch is selected. |
| Currency | The cash account’s currency. |
| Total amount | The total amount of the transaction selected in the main window. |
| Application amount | The total value of the selected documents. This amount is always less than or equal to the Total amount. |
| Unapplied balance | The difference between Total amount and Application amount. |
| Trans. descr. | The transaction description of the transaction selected in the main window. |
| Button | Description |
|---|---|
| Select all documents | Click this to select all documents until the sum of their amounts reach the Total amount in the top part. |
| Column | Description |
|---|---|
| Select document | Check box for selecting the documents. |
| Branch | The branch on which you want to select the documents. By default the cash account’s branch is selected. |
| Document type | The type of the document to which the payment selected in the left table can be applied to. |
| Ref. no. | The reference number of the Supplier ledger or Customer ledger document to which the payment selected in the left table can be applied to. |
| Date | The date when the Supplier ledger or Customer ledger document was created. |
| Post period | The financial period in which the document is posted. |
| Due date | The date when the Supplier ledger or Customer ledger document is due to be paid. |
| Amount in cash account currency | The document amount converted in the cash account’s currency. |
| Balance in cash account currency | The document balance converted in the cash account’s currency. |
| Customer/supplier | The customer or supplier number from the customer/supplier document. |
| Description | The description from the supplier or customer documents. |
| Amount | The document amount paid in the original currency. |
| Balance | The document balance amount in the original currency. |
| Currency | The currency of the document. |
| Customer order/supplier ref. | The document’s original customer order/supplier reference as assigned by the customer/supplier (for informational purposes). |
| External reference/buyer’s order no. | The external reference number/buyer’s order number of the transaction. |
| Customer name/supplier name | The customer name/supplier name associated with the document. |
| Location | The customer or supplier location. |
| Column | Description |
|---|---|
| Document type | The type of the document to which the payment selected in the left table can be applied. |
| Ref. no. | The reference number of the Supplier ledger or Customer ledger document to which the payment selected in the left table can be applied. |
| Customer order | The original reference number or ID assigned by the customer to the customer document (for informational purposes). |
| Customer name | The customer name associated with the document. |
| Customer | The parent or child customer associated with the document, by its customer number. The Parent-child customer relationship can be enabled in the Enable/disable functionalities (CS100000) window For more information about parent-child relationship, see: Manage parent-child relationships - overview |
| Invoice text | The text from the customer documents. |
| External ref. | The external reference number of the transaction. |
| Amount paid | The amount paid for this document. |
| Balance | The amount of the document after the specified amount was paid. |
| Date | The date when the Supplier ledger or Customer ledger document was created. |
| Currency | The currency of the document. |
| Balance write-off | The amount to be written off. |
| Branch | The branch on which the document is created. This column is only available if the Multi-Branch support check box is selected and enabled in the Enable/disable functionalities (CS100000) window. |
| Cash discount balance | The unused amount of the available discount, if any. |
| Cash discount taken | The amount of cash discount taken due to prompt payment. |
| Cross rate | A cross rate that you can optionally modify between the currency of the payment and currency of the original document. The column is hidden by default and available if the Multi-currency accounting check box is selected and enabled in the Enable/disable functionalities (CS100000) window. |
| Post period | The financial period in which the document is posted. |
| With. tax | The amount of tax withheld (if withholding taxes are applicable). |
| With. tax balance | The difference between the amount of the tax to be withheld and the actual withheld amount (if any withholding taxes are applicable). |
| Write-off reason code | A reason code that defines an account and subaccount to be used for writing off balances. You must select a reason code if the balance write-off amount is non-zero. |
| Description | The description from the supplier documents. |
| Supplier ref. | The document’s original reference number as assigned by the supplier (for informational purposes). |
| Button | Description |
|---|---|
| Run now | Initiates the process of running a schedule and generating documents according to the schedule. |
| Element | Description |
|---|---|
| Schedule ID | The ID of the schedule. A new schedule gets its unique identifier in accordance with the number series assigned to schedules in the Customer ledger preferences (AR101000) window. |
| Active | A check box that indicates (if selected) that the schedule is active. When the check box is cleared, the schedule cannot be used. |
| Start date | The start date for the schedule. |
| Expiration date | A date that, if set, indicates when the schedule expires. This field is unavailable if the Never expire check box is selected. |
| Never expires | A check box that indicates (if selected) that no expiration date is set. |
| Execution limit (times) | The maximum number of times the schedule can be executed. This field is unavailable when the No limit option is selected. |
| No limit | A check box that indicates (if selected) that the schedule should be continued into future financial periods indefinitely; when you select this check box, the Execution limit field becomes unavailable. |
| Description | A description for the schedule. |
| Last executed | A read-only field that displays the date when the documents were last generated. If no documents have been generated according to the schedule, the box is unavailable. |
| Next execution | A read-only field that displays the date when the schedule should be executed next, based on the schedule parameters. |
| Executed (times) | A read-only field whose value shows how many times the schedule was executed or how many times the documents were generated. A 0 here indicates that the schedule has not been executed yet and no documents have been generated. |
| Schedule type | The frequency at which documents should be generated. Click one of the following option buttons, which are described in detail in the next sections:
Select the schedule type, and enter the settings specific to the type in the corresponding section (described below). |
| Element | Description |
|---|---|
| Every | An integer that specifies the time period (in days) when the document is generated. For example: 1 means every day and 2 means every other day, starting on the Start date |
| Element | Description |
|---|---|
| Every | An integer that specifies the time period (in weeks) when the document is generated. You can also select the day of the week when the document is generated. |
| Element | Description |
|---|---|
| Every | An integer that specifies the time period (in months) for document generation. For example: A 3 here would generate documents every three months. For this schedule type, you should enter an integer and select one of the option buttons below this field. |
| On day | An option button that you select if you want to select a particular day of the month. If you select this button, you should select the day of the month for the invoice in the adjacent field. |
| On the | An option button that you can select if you want to select a particular day of the week within the month. If you select this button, you should also select the ordinal number in the left field that specifies the week in the month, and the day of the week in the right field. For example: 2nd Thursday. |
| Element | Description |
|---|---|
| Every | An integer that specifies the interval for document generation, measured in financial periods. In addition to selecting this integer, you should select one of the following option buttons, which determine when documents should be generated. |
| Start of the financial period | An option button that sets the start date of the financial period as the day when documents should be generated. |
| End of period | An option button that sets the end date of the financial period as the day when documents should be generated. |
| Fixed day of the period | An option button that you use if documents should be generated on a particular day of the financial period. If you select this button, select the particular day in the field. |
| Column | Description |
|---|---|
| Type | The type of the customer ledger document. Documents of the following types may be scheduled: Invoice, Debit note, and Credit note. |
| Ref. no | The ID number of the original document, which is used as a template to generate documents. Other columns in the row are read-only and display the details of the original document. |
| Customer | The ID of the customer whose document is being scheduled. |
| Customer name | The customer’s name. |
| Date | The date of the transactions. |
| Post period | The financial period to which the document transactions should be posted. |
| Amount | The amount of the original document. |
| Currency | The currency used for the document. |
| Invoice text | The user-defined description of the document. |
| Column | Description |
|---|---|
| Type | The document type, which can be one of the following: Invoice, Debit note, and Credit note. |
| Ref. no | The reference number of the generated document. |
| Customer | The customer whose document was scheduled. |
| Customer name | The customer’s name, as it appears on the documents. |
| Status | The status of the generated document. |
| Date | The date of the transactions. |
| Post period | The financial period to which the generated transactions should be posted. |
| Amount | The amount of the generated document. |
| Currency | The currency used for the document. |
| Invoice text | The description of the document. |
| Button | Description |
|---|---|
| Release | Releases the customer ledger documents you have selected in the table, changes their status to Open, and creates unposted batches or posts batches directly to the General ledger, depending on whether the Automatically post on release check box is selected in the Customer ledger preferences (AR101000) window. |
| Release all | Releases all the customer ledger documents on the list at once and changes their status to Open. Whether transactions are directly posted on release is defined by the Automatically post on release check box in the Customer ledger preferences (AR101000) window. |
| Column | Description |
|---|---|
| Type | The type of customer ledger document. The following types can be released:
|
| Ref. no. | The identifier of the document. Clicking the link navigates to the Sales invoices (AR301000), Customer payments (AR302000), or Cash sales (AR304000) window, depending on the type of the selected document, and displays the details of the selected customer ledger document. |
| Customer | The customer (by ID) referred to on this document. |
| Customer name | The customer’s complete name as it should appear on the documents. |
| Customer order | The document reference number used by the customer. |
| Status | The status of the document. Only Balanced documents can be released. |
| Date | The date when the document was created. |
| Post period | The period to which the transactions of the document should be posted. |
| Amount | The amount of the document. |
| Currency | The currency used for the document. |
| Invoice text | The user-provided description for the document. |
| Branch | The ID of the branch. |
| Branch name | The name of the branch. |
| Element | Description |
|---|---|
| Process | Initiates the renewal of the contracts you have selected in the Contract column. |
| Process all | Initiates the renewal of all the listed contracts at once. |
| Element | Description |
|---|---|
| Renewal date | The start date of the date range in which the contracts will expire. |
| Element | Description |
|---|---|
| Customer class | The customer class for which contracts will be listed. Leave the field blank to view information on all classes. |
| Contract template | The contract template used for contracts with similar settings. Leave the field blank to view information on all templates. |
| Column | Description |
|---|---|
| Contract | The contract ID. |
| Description | A description of the contract. |
| Contract template | The template used for the contract. |
| Contract type | The type of contract. Use one of the following options: Renewable or Expiring. |
| Customer no. | The customer associated with the contract. |
| Customer name | The name of the customer. |
| Status | The status of the contract. |
| Setup date | The setup date of the contract. |
| Expiration date | The date when the contract expires. |
| Last invoicing date | The most recent invoicing date for the contract. |
| Next invoicing date | The next invoicing date for the contract. |
| Element | Description |
|---|---|
| Report text code | The code of the report text, max. 30 characters. The field is alphanumeric. Example: RE1. |
| Name | The name of the report text code. Example: Reminder 1. |
| Text fields | In the topmost text field, enter the desired text of your reminder or dunning letter. In the second text field, you can for en example add a message to the customer. You can use maximum 255 characters in these fields. |
| Element | Description |
|---|---|
| Process | Initiates invoicing processing for the contracts that you have included by selecting the unlabelled check boxes in the table. |
| Process all | Initiates invoicing processing for all the contracts listed in the table. |
| Element | Description |
|---|---|
| Invoicing date | The date that determines the contracts to be shown; contracts with a next invoicing date that is before or on the date you have selected here are to be displayed. The selected date serves as the invoice date for contracts with the invoicing period set to On demand. |
| Contract template | The contract template that the contracts to be listed were based on. Leave the field blank to view contracts based on all templates. |
| Customer class | The customer class of the contracts to be listed. Leave the field blank to view the contracts of customers of all classes. |
| Customer | The customer whose contracts you want to invoice. Leave the field blank to see the contracts of all customers of the class (or all customers of all classes). |
| Column | Description |
|---|---|
| Contract ID | The contract identifier. |
| Description | A description of the contract. |
| Customer | The customer associated with the contract. |
| Customer name | The name of the customer. |
| Last invoicing date | The date when the contract was last invoiced. |
| Next invoicing date | The date when the contract is to be invoiced next time. |
| Expiration date | The date when the contract expires. |
| Contract template | The contract template that the contract is based on. |
| Button | Description |
|---|---|
| Release | Releases the document. |
| Actions | Provides the following menu commands, which you can click to invoke actions:
+ Generate e-Invoice XML draft: Generates a draft version of the PEPPOL BIS 3.0 XML, so that you have the possibility to check the content and validate that all settings are correct, before you start using the PEPPOL BIS 3.0 format for electronic invoicing. It is also possible to use this action after you have sent the invoice to AutoInvoice. The action can be used on all statuses except On hold , and becomes available if PEPPOL BIS 3.0 is activated and you have enabled the setting Send to AutoInvoice on the Invoice address tab.
Note
** The generated file is a draft and may not be used as a legal document.
|
| Inquiries | Provides the following menu commands, which you can click for quick access to inquiry forms:
|
| Reports | Provides the following menu commands, which you click for fast access to the following reports:
|
| Column | Description |
|---|---|
| Recalculate | The way prices and discounts are calculated. You can select one of the following options:
|
| Set current unit prices | A check box that indicates (if selected) that the system must update the item prices with the current prices. |
| Override manual prices | A check box that indicates (if selected) that the system must update the prices that have been modified manually (in the Unit price or Manual amount columns) with the current prices. The check box is available for selection if the Set current unit prices check box is selected. After the manual prices are overridden in the document, the system clears the Manual price check boxes in the appropriate document lines. |
| Recalculate discounts | A check box that indicates (if selected) that the system must recalculate the discounts for the current line or for the selected lines. This check box is available only if the Customer and supplier discounts functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Override manual line discounts | A check box that indicates (if selected) that the system should cancel the manual discounts for the current line or all lines (depending on the option selected in the Recalculate field) and search for applicable automatic discounts. This check box is only available if the Customer and supplier discounts functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| OK (button) | Closes the dialog box and applies the selected options. |
| Element | Description |
|---|---|
| Type | The document type. The following types are available:
|
| Invoice no. | The invoice number of the customer ledger document in the system; for a new document, the <NEW> string is displayed, indicating that a new number will be generated. |
| Status | The status of the document, which can be one of the following:
|
| Hold | A check box that indicates (if selected) that the document is a draft. A document with the On hold status may be edited and cannot be released. |
| Date | The date when the customer ledger document was created. By default, for a new document, it is the current business date, but you can change the date. |
| Post period | The period to which the document should be posted. By default, it is the current period, but you can change the period. The ability to post to closed periods is controlled by the Allow posting to closed periods check box in the General ledger preferences (GL102000) window. |
| Customer order | The original reference number or ID assigned by the customer to the customer document (for informational purposes). |
| External ref. | The external reference used in AutoInvoice. |
| Project | The project with which this document is associated, or the code indicating that this document is not associated with any project; the non-project code is specified in the Project accounting preferences (PM101000) window. This field appears if the Customer ledger workspace has been integrated with the Projects module. |
| Invoice text | Any user-provided description of the customer ledger document. |
| Customer | The customer associated with the document. When the Parent-child customer relationship functionality is enabled in Enable/disable functionalities (CS100000) and a child customer is selected in the child field first, the corresponding parent account is automatically populated in this field. |
| Child | This field is only displayed when the functionality Paren-child customer relationship is enabled in Enable/disable functionalities (CS100000) |
| Consolidate Invoices | When this check box is selected, invoices for the current child customer will be sent to the parent account. This overrides the information and settings in the Invoice address and Invoice contact sections. The following invoice information is retrieved from the parent when this check box is selected:
This element is disabled if the displayed account is a parent account. |
| Location | The location of the customer related to the document. By default, it is the default location of the selected customer. |
| Contact | The contact associated with the customer. |
| Currency | The currency of the document. By default, it is the customer’s default currency, but it can be changed if the Enable currency override check box is selected in the Customers (AR303000) window. |
| Exchange rate | The amount corresponding to the Currency field, and the name of the field is only visible if you hover over the field. By clicking the field, the Rate selection dialog box opens. See description below. |
| View base (button) | When you click View base the following happens:
Click View currency again to return to the original view. |
| Terms | The payment terms used in relations with the customer. |
| Due date | The date when payment for the document is due, in accordance with the payment terms. |
| Cash discount date | The end date of the cash discount period, which the system calculates by using the payment terms. |
| Detail total | The document total, which the system calculates for all line items in the Document details tab. |
| Discount total | The discount total calculated for the document. This total includes discounts of the Group and Document levels. The discounts of the Group and Document levels are listed on the Discount details tab; the Line discounts are shown on the Document details tab. This field is only available if the Customer and supplier discounts functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| VAT taxable total | The document total that is subjected to VAT. The VAT taxable amount is displayed in this field only if the Include in VAT taxable total check box is selected for the applicable VAT in the VAT (TX205000) window. If the check box is cleared, this field is empty. This field is only available if the VAT reporting functionality is enabled in the Enable/disable functionalities (CS100000) window.
Note
If the document contains multiple transactions with different taxes applied and each of the applied taxes has this check box selected, the taxable amount calculated for each line of the document will be added to the VAT taxable total field of the document. |
| VAT exempt total | The document total that is exempt from VAT. This total is calculated as the taxable amount for the VAT with the Include in VAT exempt total check box selected in the VAT (TX205000) window. This field is only available if the VAT reporting functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| VAT total | The VAT amount of the document, as defined on the VAT details tab. |
| Balance | For an open customer ledger document, the balance after any cash discount was taken. For a document used in the application process, this is the balance after the payments were applied. |
| Rounding diff. | The difference between the original amount and the rounded amount. The field only appears if the Invoice rounding functionality is activated. For details, see: Set up document amount rounding. |
| Amount | The amount paid by the document. The field appears for new documents if the Validate document totals on entry check box is selected in the Customer ledger preferences (AR101000) window. If the check box is cleared, then the field appears when the document status is Open. |
| Cash discount | The cash discount amount that has been or will be taken on the document, which the system calculates based on the specified payment terms. If a document has the On hold or Balanced status, you can change the amount of the calculated cash discount. If you change the cash discount amount, the system recalculates the taxable and tax amounts of the document if the applied taxes have Calculate on set to Calc. on item amount or Calc. on document amount and Cash discount set to Reduces taxable amount in the VAT (TX205000) window. Changes you make to the cash discount amount do not affect the taxable and VAT amounts of the document if the applied taxes have Calculate on set to Extract from item amount and Cash discount set to Reduces taxable amount in the VAT (TX205000) window. |
| ROT or RUT deductible document | Select this check box if the amount on this document is applicable for ROT or RUT deduction. The ROT and RUT details tab will appear and the columns RUT or ROT deductible, Item type, Type of work and Deductible amount will be displayed in the Document details tab table. |
| Element | Description |
|---|---|
| Currency rate type ID | The currency rate type specified for the selected currency pair. By default, it is the customer’s default currency rate type, but it can be changed if the Enable rate override check box is selected in the Customers (AR303000) window. |
| Effective date | The date on which the currency rate in this row becomes effective. |
| Currency unit equivalents | View the currency conversion.
Note
It’s possible to change the currency rate for an individual invoice here without changing the currency rate type, but the currency rate will restore back to original if this invoice is corrected. Therefore, it’s recommended to create a new currency rate instead, which can then be applied to the individual invoice ( See also: Add a currency rate ). |
| OK (button) | Closes the dialog box. |
| Button | Description |
|---|---|
| View schedule | Navigates to the Deferral schedule (DR201500) window and displays the details of the schedule for the selected line of the document (if any different deferral codes were assigned to different lines of the document in the Deferral code column). |
| Element | Description |
|---|---|
| Branch | The branch that sells the item or provides the service. |
| Item ID | The item ID of the line item, if applicable. |
| Transaction descr. | Any comments relevant to the transaction. The alphanumeric string may contain up to 30 characters. |
| Quantity | The quantity of this item sold to the customer, expressed in the unit of measure specified in the UoM column. |
| UoM | The unit of measure (UoM) for the item. |
| Unit price | The unit price set for the item or service. If you want to update the unit price automatically to the current value (that is, the applicable sales or default price), you can use the Recalculate prices action. If you have modified the unit price and saved the document, the value will not be updated by the system if you change the document date. |
| Manual amount | The manual amount, which is either the unit price multiplied by the quantity or a manually entered amount that may not be equal to the product of the unit price and the quantity. If you want to update the manual amount automatically to the current value (that is, the applicable sales or default price multiplied by the item quantity), you can use the Recalculate prices action. If you have modified the manual amount once and saved the document, the value will not be updated by the system if you change the document date. |
| Discount percent | The percent of the line-level discount that has been applied manually or automatically. The system selects the Manual discount check box and calculates the discount amount after you have entered the percent manually and saved your changes or added a new line. |
| Discount amount | The amount of the line-level discount that has been applied manually or automatically to this line. The system selects the Manual discount check box and calculates the line amount after you have entered the discount amount manually and save your changes or added a new line. |
| Amount | The amount after the discount has been applied. The value of this read-only field is calculated automatically by deducting the discount amount from the manual amount. |
| Manual discount | A check box that indicates (if selected) that the discount has been applied manually. If you clear the check box, the system clears entered discount percent, or discount amount, or selected discount code. This column is only available if the Customer and supplier discounts functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Discount code | The code of the line discount that has been applied to this line automatically or manually. This column is only available if the Customer and supplier discounts functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Account | The sales account used for the transaction. See also:About suggested sales accounts. |
| Description | The description of the account. |
| Subaccount | The corresponding subaccount used to record this sale transaction. |
| Project task | The particular task of the project with which this document line is associated. This column appears if the integration of the Projects module with Customer ledger has been enabled. That is, the Customer ledger check box must be selected in the Visibility settings section in the Project accounting preferences (PM101000) window. |
| Salesperson ID | The ID of the applicable salesperson. |
| Original deferral schedule | A read-only column filled in by the system in the document created as a result of reversing an invoice, credit note, or debit note. The column shows the ID of the deferral schedule associated with the reversed document.
Note
If a credit note document is created manually, then you can select a deferral schedule to be reversed. In the reversed documents, this column remains empty. |
| Deferral code | The deferral code assigned to the stock item or non-stock item specified in this document line. Upon release of the document, the system generates a deferral schedule (or schedules) based on the settings defined in this deferral code. You can change the deferral code in this field manually if needed.
Note
If you change an MDA deferral code (the deferral code that indicates that an item is a package) to any non-MDA deferral code, the system will consider the item to not be a package and will ignore its components while generating a deferral schedule. That is, the system will generate the deferral schedule for the item based on the settings of the specified non-MDA deferral code.
Note
Only active deferral codes are shown in the lookup. If you manually enter an inactive code, you will get an error message that the code is inactive. |
| Term start date | The date when the process of deferred revenue recognition should start for the selected item; this date can be specified manually if the deferral code assigned to the item is based on the Flexible by periods, prorate by days or Flexible by days in period recognition method. This column only appears if the Deferred revenue management functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Term end date | The date when the process of the deferred revenue recognition should finish for the selected item; this date can be specified manually if the deferral code assigned to the item is based on the Flexible by periods, prorate by days or Flexible by days in period recognition method. This column only appears if the Deferred revenue management functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| VAT category | The VAT category (if applied) for the transaction. See also:About suggested VAT categories. By default, it is the VAT category defined for the non-stock or stock item specified in the line; otherwise, the VAT category is the default VAT category of the VAT zone associated with the selected location of the customer. |
| Commissionable | A check box that indicates (if selected) that commission is paid on the line item amount. The column is available if the Commissions functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| RUT or ROT deductible | A check box that indicates (if selected) that the line item is ROT or RUT deductible, according to its settings in the Non-stock items (IN202000) window. This only applies to non-stock items. |
| Item type | The Item type applies to a ROT or RUT deductible document. You can edit this column. The type of the item, as selected in the Stock items (IN202500) or Non-stock items (IN202000) window, the ROT and RUT settings (Sweden) section, the Type field. For a stock item, this can be one of the following:
For a non-stock item, this can be one of the following:
When there is no Type selected in the Stock items (IN202500) or Non-stock items (IN202000) window, Other cost is the default type. |
| Type of work | The type of work the line item is related to, according to the item’s settings in the Non-stock items (IN202000) or Stock items (IN202500) window. You can edit this column. |
| Deductible amount | Read-only column. The amount your client can deduct for the line item, if the item is ROT or RUT deductible. |
| Start date | Sets the start date for the invoice period that the item is invoiced for. You can manually set this value for invoices created in the Customer ledger workspace. You can set it per invoice line and/or it can be retrieved from the corresponding field in the Invoice period settings section on the Financial details tab. The Start date field is set in the e-invoice if the invoice is sent in the PEPPOL format. |
| End date | Sets the end date for the invoice period that the item is invoiced for. You can manually set this value for invoices created in the Customer ledger workspace. You can set it per invoice line and/or it can be retrieved from the corresponding field in the Invoice period settings section on the Financial details tab. The End date field is set in the e-invoice if the invoice is sent in the PEPPOL format. |
| Order no. | The order number retrieved from the accordant order, if applicable. |
| Shipment no. | The shipment number retrieved from the accordant confirmed shipment, if applicable. |
| Order type | The order type retrieved from the accordant order, if applicable. |
| Base qty | The quantity of the item sold to the customer, expressed in the base unit of measure. This quantity is used for calculating discounts if The base UoM is selected in the Apply quantity discounts to field on the Price/discount settings tab of the Customer ledger preferences (AR101000) window. |
| Disc. unit price | The unit price after the discount percent has been applied. |
| Discount series | The ID of the discount series that has been applied to this line. The column is hidden by default and only available if the Customer and supplier discounts functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Expense date | The date of the corresponding expense claim. |
| External link | A read-only column displaying the external link for the line, collected from the corresponding sales order. |
| Line no. | The number of the item line on the invoice. |
| Manual price | A check box that indicates (if selected) that the unit price in this line has been corrected or specified manually. The system automatically selects this check box for the line when you change the price in the Unit price column. If the check box is selected, when you change the unit of measure or quantity in the line, the unit price is not automatically refreshed with the price from the price list. If you clear this check box, the system updates the unit price in the document line with the current price (if one is specified). |
| Order line no. | The number of the item line on the corresponding order. |
| Element | Description |
|---|---|
| Batch no. | The ID of the batch that updates the appropriate account balances with the amounts of the document transactions when the batch is posted. |
| Branch | The branch with which this invoice or note is associated. |
| Customer ledger account | The liability account specified as the customer ledger account for the selected location of the customer. |
| Customer ledger sub. | The corresponding subaccount used for the customer. |
| Original document | If a credit note is currently selected in the top part of this window, this is the identifier of the document that was reversed with the credit note. If you click the link in this box, the current window opens with the details of the reversed document. |
| Element | Description |
|---|---|
| Payment method | The payment method that the customer will use to pay the document. |
| Description | The identifier or description of the customer’s payment method. |
| Cash account | The cash account associated with the payment method. |
| Payment ref. no | The reference number of the payment. |
| Apply overdue charges | A check box that indicates (if selected) that the system will calculate overdue charges for this document. Clear the check box to exclude the document from the process of overdue charges being applied. The check box is displayed after the document is released if the Apply overdue charges check box is selected for the selected customer in the Customers (AR303000) window. |
| Payment message | Here you can enter a short message of alphanumeric characters. |
| Element | Description |
|---|---|
| Customer VAT zone | The Customer VAT zone is by default set to the VAT zone associated with the selected location of the customer. If no VAT zone is specified for the customer location, the customer VAT zone is the VAT zone assigned to the selling branch. You can override the default value. |
| Element | Description |
|---|---|
| Work group ID | The work group associated with the document, if any. |
| Owner | The employee who owns (is responsible for) the document. |
| Element | Description |
|---|---|
| Start date | The start date of the invoice period |
| End date | The end date of the invoice period |
| Element | Description |
|---|---|
| Accounting cost ref. | A textual value that specifies where to book the relevant data into the Buyer’s financial accounts. |
| Originator document ref. | The identification of the call for tender or lot the invoice relates to. |
| Contract document ref. | The identification of a contract. |
| Customer project | The project number requested by the customer. When a project number is entered in this field, it will replace the internal project number when sending to AutoInvoice for VismaXML and PEPPOL BIS. When nothing is filled in, the internal project number will be sent to AutoInvoice. |
| Element | Description |
|---|---|
| Dunning letter date | The date of the last released dunning letter in which the document was listed. |
| Dunning level | The dunning level of the document. |
| Revoked | A check box that indicates (if selected) that the document is excluded from the dunning process. Clear the check box if you want the system to process the document when you prepare dunning letters. The field is displayed if the By document option is selected in the Dunning process field on the Dunning settings tab of the Customer ledger preferences (AR101000) window. |
| Element | Description |
|---|---|
| Case number | The case number from debt collection for the invoice. |
| Case type | The case type from debt collection for the invoice. Collection notification
|
| Case status | The case status from debt collection for the invoice.
|
| Exclude from debt collection | A check box that, if selected, will exclude the invoice from being sent to debt collection. This check box is inherited from the window Customers (AR303000). The check box will not be visible if the invoice has been sent to dept collection. This section will display information when you receive the case number from the debt collection. |
| Element | Description |
|---|---|
| Discounted doc. total | The document total, which has been discounted due to the cash discount being applied; this occurs when the document has been paid within the cash discount period. |
| Discounted taxable total | The taxable amount, which has been discounted due to the cash discount being applied to the document. |
| VAT on discounted price | The VAT amount, which is calculated based on the price to which the cash discount has been applied. |
| Element | Description |
|---|---|
| Override address | A check box you select to specify an invoice address other than the default invoice address of the customer. When this check box is cleared, the invoice address to be used for this customer is the same as the default invoice address of the customer. |
| Address 1 | The first line of the invoice address. |
| Address 2 | The second line of the invoice address. |
| Address 3 | The third line of the invoice address. |
| Postcode | The postcode for the invoicing address. An input mask for the postcode can be set in the Countries/counties/postcodes (CS20400S) window. |
| City | The city of the customer’s invoice address. |
| Country | The customer’s country. |
| County | The state or province of the customer. |
| Element | Description |
|---|---|
| Override contact | A check box you select to specify contact info other than the default contact information of the customer. When this check box is cleared, the contact info to be used for this customer is the same as the default contact information of the customer. |
| Business name | The name of the business. |
| Attention | The department or person to be noted on the attention line, if this line is used by your company. |
| The email address of the contact person. | |
| Phone 1 | The phone number of the contact person. |
| Element | Description |
|---|---|
| Printed | A check box that indicates (if selected) that the document was printed. |
| Emailed | A check box that indicates (if selected) that the document was emailed. |
| Do not print | A check box that indicates (if selected) that printing of this document is not mandatory for further processing and the document is not included in the list of documents available for mass-printing in the Send invoices (AR508000) window. The default value of this setting depends on the value of the Print invoices check box in the Customers (AR303000) window. |
| Do not email | A check box that indicates (if selected) that emailing of this document is not mandatory for further processing and the document is not included into the list of documents available for mass-emailing in the Send invoices (AR508000) window. The default value of this setting depends on the value of the Send invoices by email check box in the Customers (AR303000) window. |
| Element | Description |
|---|---|
| Show description on order confirmation and invoice | Select this check box to show the text in the Invoice text field on the invoice, and, if applicable, the sales order confirmation. |
| Print note on external sales documents | Select this check box to print a note on external sales documents. |
| Print note on internal sales documents | Select this check box to print a note on internal sales documents. |
| Element | Description |
|---|---|
| Sent to AutoInvoice | A check box that indicates (if selected) that the document was sent to AutoInvoice. |
| Send to AutoInvoice | A check box that indicates (if selected) that the document will be sent to AutoInvoice. |
| Sending method | Indicates which path the AutoInvoice was sent by: Standard or Consumer. |
| AutoInvoice status | Shows the status of processing. Available statuses are:
|
| AutoInvoice sent by | Shows how the invoice was sent. Possible values are:
|
| Business level status | The status of the invoice as sent by the customer. It can be one of the following:
To get the current status, click the Actions button and select Poll invoice status. |
| Reason code | The reason given by the customer to clarify the business level status. This text is predefined, see this status clarification reason list for all possible reason codes. |
| Reason | Text entered manually by the customer. |
| Action code | The action the customer wants you to take for this invoice. This text is predefined, see this status clarification action list for all possible action codes. |
| Action | Text entered manually by the customer. |
| Element | Description |
|---|---|
| Mandate ID | Shows the direct debit information from the Direct debit tab of the Customers (AR303000) window. The selected mandate is the default one for the branch selected on the Financial details tab of the invoice. The list will display only mandates linked to current branch or mandates without a branch set. |
| Sent to AutoPay | A check box that indicates (if selected) that the document was sent to AutoPay. |
| Send to AutoPay | A check box that indicates (if selected) that the document will be send to AutoPay. |
| Column | Description |
|---|---|
| VAT ID | The ID of the VAT applied to the document. |
| Description | The description of the VAT ID in clear language. |
| VAT rate | The rate of the VAT. |
| Taxable amount | The taxable amount for the VAT, which is calculated at the document level. |
| VAT amount | The VAT amount for the specific VAT, which is calculated at the document level. |
| Reverse VAT | A check box that indicates (if selected) that this is a reverse VAT. |
| Statistical VAT | A check box that indicates (if selected) that this VAT will be calculated only for statistical purposes. Or, will be reported only, but not actually paid. |
| Pending VAT | A check box that indicates (if selected) that this VAT is pending and will be recognised after completing the VAT recognition process. |
| Include in VAT exempt total | A check box that indicates (if selected) that this VAT has a zero rate and is used to calculate a document subtotal that is actually exempt from VAT. |
| VAT type | The type of the VAT, which can be one of the following:
|
| Element | Description |
|---|---|
| Default salesperson | The ID of a salesperson to be used by default for each invoice line. By default, it is a salesperson associated with the selected location of the customer. |
| Total commissionable | The total amount used to calculate commissions for all salespersons involved. |
| Commission amt. | The total amount of commissions on the document. |
| Column | Description |
|---|---|
| Skip discount | A check box that you select to cancel a Group - or Document -level discount for the document. Selecting the check box updates the total and the line amounts of the document but does not remove the record of the cancelled discount from the table. |
| Discount code | The ID (code) of the discount applied to the document automatically or manually. |
| Series ID | The ID of the discount series applied to the document. |
| Type | The type of discount whose series was applied to the document. |
| Manual discount | A check box that indicates (if selected) that the discount shown in this row has been applied manually. The discount was selected from the Group- or Document- level discounts for which the Manual check box is selected in the Discount codes (AR209000) window. |
| Discountable amt. | The amount used as a base for discount calculation if the discount is defined as based on the amount. |
| Discountable qty. | The quantity used as a base for discount calculation if the discount is defined as based on the item quantity. |
| Discount amt. | The amount of the discount. |
| Discount percent | The discount percent if by definition the discount is calculated as a percentage. |
| Free item | The item ID of the free item if one is specified by the discount applied to the document. |
| Free item qty. | The quantity of the free item to be added as the discount. |
| Order type | The type of order. |
| Order no. | The order number. |
| Button | Description |
|---|---|
| View payment | Opens the Customer payments (AR302000) window in a pop-up window so that you can view the document details or application, depending on the document type. |
| Apply automatically | Automatically applies the available payments to the document. The button is displayed if the Invoice type is selected in the top part. |
| Column | Description |
|---|---|
| Doc. type | The type of payment document that was applied. |
| Reference no. | The reference number of the document. When you click this number, the Sales invoices (AR301000) or Customer payments (AR302000) window opens in a pop-up window, depending on the document type, so that you can view the document details. |
| Customer | The ID of the customer account. |
| Amount paid | The amount that was actually paid which is displayed in the currency of the document that is selected in the window. |
| Cash discount taken | The amount of the cash discount that was deducted from the invoice amount in case the invoice was paid during the cash discount period. |
| Payment date | The date of the payment application. |
| Balance | The balance of the document after the payment was applied. |
| Invoice text | The description of the payment document. |
| Currency | The currency of the payment document. |
| Payment period | The period to which the payment transactions are posted. |
| Payment ref. | The reference number used by the customer on its payment document. |
| Status | The status of the payment document. |
| VAT adjustment | A check box automatically selected by the system if the customer ledger document specified in this row is subject to VAT adjustment. |
| VAT credit note | The reference number of the VAT credit note generated in the Generate VAT on cash discount (AR504500) window for the customer ledger document specified in this row. This reference number is specified by the system automatically once the VAT credit note is generated. |
| Column | Description |
|---|---|
| Document type | The type of the document that was applied. |
| Reference no. | The reference number of the applied document. By clicking this number, the document details window opens. |
| Customer | The ID of the customer account. |
| Amount paid | The amount that was actually paid which is displayed in the currency of the document that is selected in the window. |
| Date | The date of the document. |
| Balance | The balance of the document after the credit note was applied. |
| Invoice text | The description of the document. |
| Currency | The currency of the document. |
| Post period | The period to which the document transactions are posted. |
| Customer order | A reference to a document of the customer, such as a purchase order number (for informational purposes). |
| Status | The status of the document. |
| Element | Description |
|---|---|
| Distribute automatically (check box) (check box) | When this check box is selected, the amount will be distributed equally among the specified personal IDs. |
| RUT (check box) (check box) | Select this option if the work is related to RUT (cleaning, maintenance, laundry) deduction. |
| ROT (check box) (check box) | Select this check box if the work is related to ROT (repairs, conversion, extension) deduction. When you select this, you need to fill in either the Property field, or the Apartment and Corporate ID fields. |
| Apartment | The apartment number. |
| Property | The property number. |
| Corporate ID | The housing cooperative’s ID. |
| Column | Description |
|---|---|
| Personal ID (YYYYMMDDNNNN) | The personal ID in the format YYYYMMDDNNNN. |
| Amount | The amount distributed to this person. If the Distribute automatically check box is not selected, you can edit this field and manually distribute the amount among the personal IDs. |
| Over 65 | A check box that you select to indicate that this person is over 65 years old. This is not done automatically. |
| Elemant | Description |
|---|---|
| Total deductible amount | The total amount that is tax deductible. |
| Other cost | The total amount for items of the Other cost type, including VAT. |
| Material cost | The total amount for items of the Material cost type, including VAT. |
| Work price | The total price of labour hours (items of the Service type), including VAT. This is the amount eligible for tax deduction. |
| Distributed amount or Undistributed amount | When the Distribute automatically check box is selected, this will display the total amount distributed among the specified personal IDs. When the Distribute automatically check box is not selected, this will display the amount still to be distributed manually among the specified personal IDs. |
| Element | Description |
|---|---|
| Balancing credit note ref. no. | The automatically created balancing credit note to the customer, with the deductible amount. You can click the link to view the document. |
| Balancing debit note ref. no. | The automatically created balancing debit note to Skatteverket (The Swedish Tax Agency), with the deductible amount. You can click the link to view the document. |
| Button | Description |
|---|---|
| View file | Opens the File maintenance (SM202510) window. |
| Column | Description |
|---|---|
| Send the file to AutoInvoice | The selected files will be attached to the invoice. |
| Name | The name of the attachment. |
| Created by | The person who added the attachment. |
| Creation time | The date and time the attachment was created. |
| Comment | Shows the comment that you can enter in the File maintenance (SM202510) window. |
| File size | The size of the attached file. |
| Button | Description |
|---|---|
| Create price worksheet | Navigates to the Sales price worksheets (AR202010) window, where you proceed working with a price worksheet containing all price records matching the criteria that you have selected in the current window. By default, the new worksheet is created with the On hold status and the current business date.
Note
If the selection of records contains multiple records defined for the same item, but effective on different dates, the system forces you to specify particular date in the Effective as of field to eliminate duplicates (all records in the worksheet are to be effective on the same date.) |
| Element | Description |
|---|---|
| Price type | The type of prices you want to view. Select one of the following options:
|
| Price code/Customer | The customer or a customer price class for which you want to create or edit a price list. This field is available if the Customer or the Customer price class option is selected in the Price type field. |
| Effective as of | A date that you select to view or edit prices effective on this exact date. |
| Item class ID | The class of stock or non-stock items, by its ID, for which you want to review sales price information. Leave the field blank to view information on items of all item classes. |
| Item ID | The item for which you want to view or edit prices. |
| Warehouse | The warehouse in which the price applies. |
| Price class | The item price class of the items for which you want to review sales price information. You can leave the field blank to view information on items in all item price classes. |
| Price manager | A field and the Me check box, which you can use as follows to select the price manager whose items you want to view:
|
| Price work group | A field and the My check box, which you use as follows to select the price work group of the price manager of the items you want to view:
|
| Column | Description |
|---|---|
| Price type | The price type of the item: Base, Customer, or Customer price class. |
| Price code/Customer | Depending on the price type, the price code is the identifier of the customer or customer price class. If the price type is Base, Price code is empty. |
| Price code description | Depending on the price type, the price code description is the customer name or customer price class description. |
| Item ID | The ID of the stock or non-stock item for which price information is listed. |
| Description | The description of the item. |
| UoM | The unit of measure (UoM) used for the item. You can select any of the units defined for this item and set a separate price for it. |
| Warehouse | The warehouse in which the price applies. |
| Promotion | A check box that indicates (if selected) that the price for this item is promotional. Promotional prices, which may overlap with regular prices, should have expiration dates after which they are not used. |
| Break qty. | The quantity to define a lower bound for a quantity tier with the specific price. This column appears if the Volume pricing functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Price | The price for the item, which becomes effective immediately after you save your changes in this window. You can set any price as long as minimum markup validation is not configured for the Inventory workspace, which is the case when the No validation option is selected in the Validate min. markup field in the Sales order preferences (SO101000) window. If minimal mark up validation is configured (that is, if the Warning or Set to minimum option is selected in the Validate min. markup field) and you enter a pending price lower than that allowed by the Min. markup % value for the item, you will get a warning or the pending price will be set to the minimum allowed. The Min. markup % for the item is specified on the Price/cost information tab in the Stock items (IN202500) window or the similarly named tab in the Non-stock items (IN202000) window. |
| Currency | The currency in which this price is specified. |
| VAT | The VAT amount that is included in the sales price. (This functionality can be used in countries where value-added or similar VATs are enforced.) This VAT will be used to correct the list of VATs that apply to a sales order line: If the list of VATs that apply to the sales order doesn’t include this VAT, the VAT amount will be deducted from the price. For details, see: Sales price calculation. |
| Effective date | The date when the price became effective. |
| Expiration date | The date when the price expires. |
| Alt. item ID | The alternative ID of the item. You can upload prices in worksheets with alternative item IDs instead of item identifiers defined in the system, and to create alternative item IDs for stock items on release of worksheets. To enable alternative item IDs, select the Load sales prices by alternative item ID check box on the Price/discount settings tab of the Customer ledger preferences (AR101000) window. |
| Button | Description |
|---|---|
| Release | Updates sales price records. The release process validates records, ensuring that the following criteria are met:
Note
Promotional and regular prices for the same combination of a price type, price code, item ID, unit of measure, and currency may overlap each other in time. |
| Element | Description |
|---|---|
| Ref. no. | The reference number of the worksheet in the system; for a new document, the NEW string is displayed, indicating that a new number will be generated when you save the document. The number series used is defined in the Customer ledger preferences (AR101000) window. |
| Status | The status of the worksheet, which is one of the following:
|
| Hold | A check box that indicates (if selected) that the worksheet is a draft. Clear the check box to change the status of a worksheet from On hold to Open. |
| Description | A brief description of the worksheet. |
| Effective date | The date when the prices defined in the worksheet become effective. |
| Promotional | A check box that indicates (if selected) that the prices defined in the worksheet are promotional and an expiration date must be specified. With the check box selected, the Overwrite overlapping prices check box is selected automatically and not available for editing. |
| Expiration date | The date when promotional prices expire. This field becomes available if the Promotional check box is selected. |
| Overwrite overlapping prices | A check box that indicates (if selected) that the prices whose effective dates overlap with the effective dates of the worksheet will be overwritten by the prices defined in the worksheet. Make the check box available by enabling retention of prices:
Overwrite overlapping prices check box is selected automatically and not available for editing if:
|
| Button | Description |
|---|---|
| Add item | Opens the Add item to worksheet dialog box so that you can load the list of items from the Inventory workspace. |
| Copy prices | Opens the Copy prices dialog box so that you can copy prices from the selection you specify to a new price worksheet for another customer or customer price class. |
| Calculate pending prices | Opens the Calculate pending prices dialog box so that you can calculate new pending prices or recalculate (update) pending prices by using the selected price basis. |
| Column | Description |
|---|---|
| Price type | The price type of the item: Base, Customer, or Customer price class. |
| Price code | Depending on the price type, the price code is the identifier of the customer or customer price class. If the price type is Base, Price code is empty. |
| Item ID | The ID of the stock or non-stock item for which price information is listed. |
| Description | The description of the item. |
| UoM | The unit of measure (UoM) used for the item. You can select any of the units defined for this item and set a separate price for it. |
| Warehouse | The warehouse for which the price is defined. If this field is empty, the price applies to all warehouses. This column appears if the Multiple warehouses feature is enabled in the Enable/disable functionalities (CS100000) window. |
| Break qty. | The quantity to define a lower bound for a quantity tier with a specific price. This column appears if the Volume pricing functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Source price | The price that serves as a source for calculating pending price of an item. When you add a new record, the value corresponds to the default price of the item, for which you add the record to the worksheet. However, when you are adding records by using the Copy prices dialog box, the value depends on the selection of a source. |
| Pending price | The pending price for the item. You can set any price here and it becomes effective immediately after you release the worksheet. |
| Currency | The currency in which this price is specified. |
| VAT | The VAT whose amount is included in the sales price. (This functionality can be used in countries where value-added or similar taxes are enforced.) This VAT will be used to correct the list of VATs that apply to a sales order line: If the list of taxes that apply to the sales order doesn’t include this VAT, the VAT amount will be deducted from the price. For details, see: About sales price calculation. |
| Alt. item ID | The alternative ID of the stock or non-stock item for which you want to define the price. The system will search for the stock or non-stock item by the alternative item ID you specify in this column and populate the Item ID, Description, and UoM columns of the row with the settings of the item it finds. If the system does not find the specified alternative ID, when the price worksheet is released, the system will create a global alternative item ID and assign it to the item with the item ID that is specified in this row of the worksheet. This column is hidden by default and appears if the Load sales prices by alternative item ID check box is selected on the Price/discount settings tab in the Customer ledger preferences (AR101000) window. For more information, see About item cross-references. |
| Element | Description |
|---|---|
| Item | The item or items. Start typing in the field, and the system displays the list of items that contain the string you have typed in their identifier or description. |
| Item class ID | The identifier of the class of stock or non-stock items that you want to add to a worksheet. Leave the field blank to add items of all item classes. |
| Price class ID | The ID of the item price class of the items that you want to add to a worksheet. You can leave the field blank to add items in all item price classes. |
| Product manager | A field and the Me check box, which you can use as follows to select the product manager whose items you want to add:
|
| Work group | A field and the My check box, which you use as follows to select the price work group of the price manager of the items you want to add:
|
| Element | Description |
|---|---|
| Price type | The type of price you want to assign to newly added items. Select one the following options:
|
| Price code | The price code is the identifier of the customer or customer price class (depending on the option selected in the Price type field) for which you want to create a price worksheet. |
| Currency | The currency to be assigned to the prices of newly added items. |
| Warehouse | The warehouse for which the price is defined. If this field is empty, the price applies to all warehouses. This column appears if the Multiple warehouses feature is enabled in the Enable/disable functionalities (CS100000) window. |
| Element | Description |
|---|---|
| Item ID | The identifier of the stock or non-stock item. |
| Item class ID | The identifier of the class of stock or non-stock items. |
| Description | The description of the stock or non-stock item. |
| Price class ID | The identifier of the item price class. |
| Price work group | The identifier of the price work group. |
| Price manager | The price manager responsible for the pricing policy. |
| Add (button) | Adds the selected items to the currently selected worksheet. The dialog box stays open so that you can change selection criteria and add more items. The Pending price column is blank for all added items. |
| Add and close (button) | Adds the selected items to the currently selected worksheet and closes the dialog box. The Pending price column is blank for all added items. |
| Cancel (button) | Closes the dialog box without adding items to the worksheet. |
| Element | Description |
|---|---|
| Price type | The price type of items you want to copy. Select one of the following options:
|
| Price code | The price code is the identifier of the customer or customer price class (depending on the option selected in the Price type field) whose items you want to copy. |
| Source currency | The currency of the items you want to copy. |
| Warehouse | The warehouse whose prices should be copied. If this box is empty, the system will copy only the prices that have no warehouse specified. This field appears if the Multiple warehouses feature is enabled in the Enable/disable functionalities (CS100000) window. |
| Effective as of | The date that the effective date of the item prices should match. |
| Promotional price | A check box that you select to copy items that have promotional prices. |
| Element | Description |
|---|---|
| Price type | The price type you want to assign to copies of items. Select one the following options:
|
| Price code | The price code is the identifier of the customer or a customer price class (depending on the option selected in the Price type field) you want to assign to copies of items. |
| Destination currency | The currency to which you want to copy prices. If the source and destination currencies are different, you should specify conversion details in the Currency conversion section. |
| Warehouse | The warehouse to which the copied prices will be assigned. This field appears if the Multiple warehouses feature is enabled in the Enable/disable functionalities (CS100000) window. |
| Element | Description |
|---|---|
| Rate type | The rate type to be used for currency conversion. |
| Currency effective date | The date when the exchange rate for the destination currency becomes effective. |
| Copy (button) | Copies the selected items, adds the copied items to the currently selected worksheet, and closes the dialog box. The Pending price column is blank for all items added. |
| Cancel (button) | Closes the dialog box without adding items to the worksheet. |
| Element | Description |
|---|---|
| % of original price | The percentage at which the new pending prices will be calculated by using the selected price basis. By default, this is 100%, which reflects no change. If you specified 98%, the new prices would be 98% of the price selected as basis. |
| Decimal places | The number of places after the decimal point to be shown for prices. |
| Update with zero price when basis is zero | The check box the indicates, if selected, that the pending price parameter of the price record will be updated with the zero value if the selected price basis for this record is zero. |
| Element | Description |
|---|---|
| Last cost + markup % | An option that you select to calculate prices based on the stock items’ last costs increased by the mark up percentage specified for the items.
Note
The option is not applicable for non-stock items. |
| Average/standard cost + markup % | An option that you select to calculate prices based on the items’ average/standard costs increased by the markup percentage specified for the stock items. In case of non-stock items, the system uses the current cost, instead of the average or standard cost. |
| Source price | An option that you select to calculate prices based on the values specified in the Source price column. |
| List price | An option that you select to calculate prices based on the manufacturer’s suggested retail price. |
| Pending price | An option that you select to calculate pending prices based on currently pending prices. |
| Replacement cost | An option that you select to calculate pending prices based on the item’s replacement cost. |
| Update (button) | Updates all pending prices in the currently selected worksheet with the new values. |
| Cancel (button) | Closes the dialog box without updating prices. |
| Element | Description |
|---|---|
| Salesperson ID | The unique identifier of the salesperson. Requirements for the ID are set by the SALESPER segmented key. For more information, see: About ID segmentation. |
| Is active | A check box that indicates (if selected) that the salesperson account is active. |
| Name | The salesperson’s name as it should appear on documents. |
| Default commission % | The default percent of commission to be used for the salesperson. The field is available if the Commissions functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Sales sub. | The subaccount associated with the salesperson. |
| Column | Description |
|---|---|
| Customer no. | The customer’s unique identifier. You can select a customer from the list of available customers. |
| Customer name | A read-only column showing the customer’s name as it should appear on the documents. |
| Location | A read-only column with the default location of the customer with whom the salesperson works. |
| Location name | A read-only column that displays the name of the location. |
| Commission % | The commission percent on sales for the particular customer. The field is available if the Commissions functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Default | When this check box is selected, this salesperson is the default salesperson of the customer. |
| Button | Description |
|---|---|
| View details | Navigates to the Commission details (AR403000) window and displays the details of the selected document. |
| Column | Description |
|---|---|
| Commission period | The commission period in which the commission was incurred. The commission periods are set in the Customer ledger preferences (AR101000) window. |
| Commissionable amount | The amount used for commission calculation during the period. The commission is calculated on an invoice amount before VAT. |
| Commission amount | The amount of commissions earned during the period. |
| Payroll processed date | The date when the commission was processed in the Payroll module. This column is available only if the Payroll functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Element | Description |
|---|---|
| Branch | The branch for which you want to view the list of transactions. |
| Date from | The starting date in the date range for which you want to view the list of transactions. |
| Date to | The ending date in the date range for which you want to view the list of transactions. |
| Completed transactions only | A check box that indicates (if selected) that only completed transactions will be displayed. A transaction is considered completed if the inventory issue for the stock item sold in this transaction is released. |
| Salesperson | The identifier and name of the salesperson that was involved in sales for the transactions to be listed. Leave the field blank to view broader range of results. |
| Item class | The item class for which you want to view information. Leave the field blank to view the sales profitability information for all item classes. |
| Item | The item for which you want to view information. Leave the field blank to view the sales profitability information for all items. |
| Customer class | The customer class for which you want to view information. Leave the field blank to view the sales profitability information for all customer classes. |
| Customer | The customer for which you want to view information. Leave the field blank to view the sales profitability information for all customers. |
| Column | Description |
|---|---|
| Branch | The branch for which the transaction belongs. |
| Date | The date of the invoice to which the transaction belongs. |
| Net sale | The net sale amount of the sold item. |
| Cost | A value that is one of the following:
|
| Margin | The difference between the net sale value and the cost. |
| Margin % | A percentage of margin to net sale ratio. |
| Completed | A check box that indicates (if selected) that the transaction is completed. That is, the inventory issue for a stock item sold with this transaction is released. If a non-stock item is sold, the transaction could not be completed. |
| Sales order no. | The reference number of the sales order involved. Click the link to view the details of the sales order. |
| Sales order type | The type of the sales order involved. |
| Type | The type of the document whose release triggered the transaction generation (invoice or cash sale). |
| Item ID | The identifier of the sold item. |
| Item description | The description of the sold item. |
| Customer class | The description of the customer class of the customer who purchased the item. |
| Customer | The name of the customer who purchased the item. |
| Salesperson | The name of the salesperson associated with the sale of the item. |
| Branch ID | The identifier of the branch. |
| Customer no. | The identifier of the customer who purchased the item. |
| Customer class ID | The identifier of the customer class. |
| Released | A check box that indicates (if selected) that the transaction is released. |
| Item class | The item class description to which the sold item is assigned. |
| Row number | The line number in this list. |
| Item class ID | The identifier of the item class. |
| Salesperson ID | The identifier of the salesperson associated with the sale of the item. |
| Button | Description |
|---|---|
| Regenerate last statement | Initiates the process of again generating the most recent statement with an updated date. |
| Element | Description |
|---|---|
| Cycle ID | The unique identifier of the cycle. An alphanumeric string of up to 10 characters can be used. |
| Description | A detailed description of the statement cycle. An alphanumeric string of up to 30 characters can be used. |
| Schedule type | The day when the statement should be generated. The following options are available:
|
| Day of month 1 | The day of each month when the statement should be generated. The field is available if either Fixed day of the month or Twice a month is selected in the Schedule type field. |
| Day of month 2 | The day of each month when the statement should be generated for the second time. This field is available only if the Twice a month option is selected. |
| Day of the week | The day of each week when the statement should be generated. This field is available only if Weekly is selected in the Schedule type field. The default value is Sunday. |
| Last statement date | A read-only field that displays the date when the statement was generated most recently. |
| Require payment application before statement | A check box that indicates (if selected) that the payments should be applied to invoices before each statement is processed. |
| Print empty statements | If you do not want the statements with no details to be printed, unselect this check box for statement cycles. After the process of preparing the statement, you can view these statements with the Do not print and Do not email check boxes selected in the Statement history details (AR404300), Customer statement history (AR404600), and Print statements (AR503500) window. |
| Element | Description |
|---|---|
| Use financial periods for ageing | A check box that indicates (if selected) that the system uses the financial periods as ageing periods in customer statements and customer ledger ageing reports. If this check box is selected, the system uses the financial period to which the statement date or the ageing date belongs as the first ageing period. |
| Ageing period (days) | In the fields you can select the current period or the number of days the documents to be included overdue.
|
| Description | You can write and edit the descriptions of the defined ageing periods. The descriptions will be printed to the customer statement reports. |
| Age based on | Select whether the age of the documents is based on their due date or document date. |
| Element | Description |
|---|---|
| Apply overdue charges | A check box that indicates (if selected) that calculation of overdue charges is required for all customers assigned to the statement cycle. |
| Require overdue charge calculation before statement | A check box that indicates (if selected) that the system should calculate overdue charges before processing a statement. |
| Overdue charge ID | The overdue charges to be used for customers assigned to the statement cycle. The overdue charges that are actually applied depend on whether the Set default overdue charges by statement cycle check box in the Customer ledger preferences (AR101000) window is selected; if not, the charges from the customer class will be applied. |
| Button | Description |
|---|---|
| Customer statement history | Navigates to the Customer statement history (AR404600) window. |
| Print statement | Navigates to the Customer statement report generated for the selected customer. |
| Element | Description |
|---|---|
| Statement cycle | The statement cycle by its ID. |
| Statement date | The date when the statement was printed. |
| Column | Description |
|---|---|
| Customer | The unique identifier of the customer account in the system. |
| Customer name | The name of the customer as it is stored in the system. |
| Statement balance | The customer’s balance (in the base currency) on the statement. |
| Overdue balance | The total amount that is overdue. |
| Currency | One of currencies used by the customer. |
| FC statement balance | The customer balance in the specified currency. |
| FC overdue balance | The overdue amount in the specified currency. |
| FC statement | A check box that indicates (if selected) that the multi-currency format of statement should be used. |
| Do not print | A check box that indicates (if selected) that the statement should not be printed in accordance with the customer settings in the Customers (AR303000) window. |
| Printed | A check box that indicates (if selected) that the statement was printed. |
| Do not email | A check box that indicates (if selected) that the statement should not be sent by email. |
| Emailed | A check box that indicates (if selected) that the statement was sent by email. |
| On-demand statement | When this check box is selected, you can generate statements on demand. |
| Prepared on | The date when the statement was prepared. |
| Button | Description |
|---|---|
| Statement history details | Navigates to the Statement history details (AR404300) window. |
| Print statements | Navigates to the Print statements (AR503500) report. |
| Element | Description |
|---|---|
| Statement cycle | The statement cycle for which data will be displayed. If you leave the field blank, information for all statement cycles will be displayed. |
| Include on-demand statements | When this is selected, on-demand statements will also be displayed in the summary. |
| Start date | The start date of the date range. By default, it is the start day of the current financial year. |
| End date | The end date of the date range. By default, it is the current business date. |
| Column | Description |
|---|---|
| Statement cycle ID | The ID of the statement cycle. |
| Statement date | The date of the statement. |
| Description | The description of the statement cycle. |
| Number of documents | The number of documents included into the statement. |
| To print | The number of statements requiring printing in accordance with the settings in the Customers (AR303000) window. |
| Printed | The number of statements printed in accordance with the settings in the Customers (AR303000) window. |
| To email | The number of statements requiring emailing in accordance with the settings in the Customers (AR303000) window. |
| Emailed | The number of statements emailed in accordance with the settings in the Customers (AR303000) window. |
| No action | The number of statements requiring no action in accordance with the settings in the Customers (AR303000) window. |
| Email completion (%) | The percentage of statements that have been emailed (among all statements to be emailed). |
| Print completion (%) | The percentage of statements that have been printed (among all statements to be printed). |
| Button | Description |
|---|---|
| Complete | Changes the status of the task to Completed. This action is available only to the task owner. |
| Complete and follow-up | Changes the task status to Completed and creates an task that has the same details as the current one but the Not started status. This action is available only to the task owner. |
| Cancel | Cancels the task, changing its status to Cancelled. This action is available only to the user who created the task. |
| Element | Description |
|---|---|
| Summary | The task summary description, which can be used as its ID. |
| Start date | The start date and time of the task. |
| Internal | A check box that, if selected, indicates that the task is hidden from external users. |
| Due date | The date and time when the task should be completed. |
| Completion (%) | The estimation of the task completion, expressed as a percent. |
| Work group | The workgroup the task is assigned to. |
| Owner | The user the task is assigned to. By default, it shows the employee ID of the task creator. |
| Reminder | This check box is not in use. |
| Remind at (date) | This field is not in use. |
| Related entity description | The entity that this activity is associated with. For example: If you are creating an activity that is associated with a lead, this lead will be specified in the field by default. To adjust the value, click the magnifier icon; as a result, the Select entity dialog box opens. |
| Parent | A read-only field displaying the parent task this task is related to via the Related tasks tab of the parent task, if applicable. |
| Project | The project associated with this task (or the non-project code indicating that this task is not associated with any project defined to the system); appears if the Projects module is activated. |
| Project task | The particular project task with which this task is associated; appears if the Projects module has been activated. You can select only a project task of the selected project. |
| Priority | The priority level of the task: Low, Normal, or High. These levels are used for informational purposes only; no specific functionality is associated with them. |
| Status | The status of the task. Select one of the following options:
|
| Category | The category of the task. |
| Completed at | The date and time of task completion. |
| Time spent | The time in days, hours, and minutes from task creation to completion. |
| Overtime | The number of hours outside of work hours from task creation to completion. |
| Invoiceable time | The number of invoiceable hours from task creation to completion. |
| Invoiceable overtime | The number of billable overtime hours spent on the task. |
| Element | Description |
|---|---|
| Type | The type of the related entity. |
| Entity | The related entity of the type. |
| OK | A button that causes your changes to be accepted and closes the dialog box. |
| Cancel | A button that closes the dialog box and cancels the selection. |
| Button | Description |
|---|---|
| Add email | Opens the Send (CR306015) window, from which you can send an email. |
| Add activity | Contains a menu with options that correspond to the activity types. By clicking on a menu option, you open the Activity (CR306010) window, which you use to create an activity of the corresponding type. |
| Column | Description |
|---|---|
| Type | The type of the activity. |
| Summary | The description provided for the activity. With an email, it matches the content of the email subject field. |
| Status | The status of the activity. |
| Start date | The start date of the activity. |
| Created at | The date and time when the activity was created. |
| Category | The category of the task. |
| Invoiceable | A check box that indicates (if selected) that the time spent on the activity can be invoiced. |
| Time spent | The number of hours spent to complete the activity. |
| Overtime | The number of hours outside of work hours spent to complete the activity. |
| Invoiceable time | The number of hours spent to complete the activity that can be invoiced. |
| Invoiceable overtime | The number of overtime hours spent to complete the activity that can be invoiced. |
| Work group | The work group that the activity is assigned to (if any). |
| Owner | The name of the user to whom the activity is assigned. |
| Created by | The user who has created the activity. |
| Released | A check box that indicates (if selected) that the activity has been released. |
| Button | Description |
|---|---|
| Add related task | Opens the Task (CR306020) window in a pop-up window. |
| Column | Description |
|---|---|
| Subject | The description of the task and a link to it. |
| Status | The status of the task. |
| Start date | The start date of the task. |
| Due date | The due date of the task. |
| Completed at | The date and time when the task was actually completed. |
| Element | Description |
|---|---|
| Update | Updates the contracts you have selected by using the unlabelled check boxes in the table. |
| Update all | Updates all the contracts listed in the table. |
| Element | Description |
|---|---|
| Item code | The unique identifier of a contract item. |
| Setup pricing | A read-only field that displays the pricing policy defined for the setup item, which can be one of the following options:
|
| Item price/percent | A read-only field that displays the setup item price or percent to be applied to the non-stock item price. |
| Setup price | A read-only field that displays the contract item price for setup, which is calculated based on the settings specified in the Setup pricing and Item price/percent fields. |
| Renewal pricing | A read-only field that displays the pricing policy defined for the renewal item, which can be the one of the following options:
|
| Item price/percent | A read-only field that displays the renewal item price or percent to be applied to the non-stock item price. |
| Renewal price | A read-only field that displays the contract item price for renewal, which is calculated based on the settings specified in the Renewal pricing and Item price/percent fields. |
| Recurring pricing | A read-only field that displays the pricing policy defined for the recurring item, which can be the one of the following options:
|
| Item price/percent | A read-only field that displays the recurring item price or percent to be applied to the non-stock item price. |
| Recurring price | A read-only field that displays the contract item recurring price, which is calculated based on the settings specified in the Recurring pricing and Item price/percent fields. |
| Extra usage pricing | A read-only field that displays the pricing policy defined for the recurring item, which is applied to the price if the customer has exceeded the included quantity of the service. It can be one of the following options:
|
| Item price/percent | A read-only field that displays the recurring item price for extra usage or percent to be applied to the non-stock item price. |
| Extra usage price | A read-only field that displays the contract item price for extra usage, which is calculated based on the settings specified in the Extra usage pricing and Item price/percent fields. |
| Column | Description |
|---|---|
| Identifier | A read-only field that displays the contract identifier. |
| Status | A read-only field that displays the status of a contract. |
| Setup pricing | A read-only field that displays the pricing policy currently used in the contract for the setup item, which can be the one of the following options:
|
| Price/percent | A read-only field that displays the setup item price or percent to be applied to the non-stock item price (currently used in the contract). |
| Setup price | A read-only field that displays the contract item price for setup (currently used in the contract), which is calculated based on the settings specified in the Setup pricing and Price/percent fields. |
| Renewal pricing | A read-only field that displays the pricing policy currently used in the contract for the renewal item, which can be the one of the following options:
|
| Price/percent | A read-only field that displays the renewal item price or percent to be applied to the non-stock item price (currently used in the contract). |
| Renewal price | A read-only field that displays the contract item price for renewal (currently used in the contract), which is calculated based on the settings specified in the Renewal pricing and Price/percent fields. |
| Fixed recurring | The recurring invoicing policy. The following options are available:
|
| Price/percent | A read-only field that displays the recurring item price or percent to be applied to the non-stock item price (currently used in the contract). |
| Recurring price | A read-only field that displays the contract item recurring price (currently used in the contract), which is calculated based on the settings specified in the Recurring pricing and Price/percent fields. |
| Usage price | A read-only field that displays the pricing policy currently used in the contract for the recurring item, which is applied to the price if the customer has exceeded the included quantity of the service. It can be one of the following options:
|
| Price/percent | A read-only field that displays the recurring item price for extra usage or percent to be applied to the non-stock item price (currently used in the contract). |
| Extra usage price | A read-only field that displays the contract item price for extra usage (currently used in the contract), which is calculated based on the settings specified in the Extra usage pricing and Price/percent fields. |
| Button | Description |
|---|---|
| Process | Processes the discounts you have selected in the table, replacing the currently effective series with pending series whose start dates have reached the date specified in the Max. pending discount date field. |
| Process all | Processes all the listed discounts, replacing the currently effective series with pending series whose start dates have reached the Max. pending discount date. |
| Element | Description |
|---|---|
| Max. pending discount date | The date used to select pending series for updating; only pending series with later start dates than this date will be updated. |
| Column | Description |
|---|---|
| Discount code | The code of the discount whose series can be processed. |
| Series | The identifier of the pending series of the discount. |
| Description | The description provided for the series. |
| Discount by | The way the discount is expressed: by percentage or by amount. |
| Break by | The way the discount breakdown series is specified, which is one of the following options:
|
| Effective date | The date when the discount series becomes effective and can be applied to sales orders and invoices. |
| Last update date | The date when the discount was last updated. |
| Button | Description |
|---|---|
| Process | Recalculates the balances for the customers you have selected in the table. |
| Process all | Recalculates the balances for all the customers listed in the table. |
| Element | Description |
|---|---|
| Period | The financial period starting which you want to validate customer balances. By default, the system selects the earliest financial period that is open in Customer ledger. |
| Customer class | The customer class for which you want to validate customer balances. If you make no selection, customers of all classes will be displayed. |
| Button | Description |
|---|---|
| View Customer | Navigates to the Customers (AR303000) window and displays the selected customer’s account details. |
| Column | Description |
|---|---|
| Customer no. | The customer who has balance to be validated. Click the ID to navigate to the Customers (AR303000) window to see the selected customer’s account details. |
| Customer class | The class to which the customer belongs. |
| Customer name | The name of the customer. |
| Button | Description |
|---|---|
| Process | Processes the write-offs for the documents you have selected in the table. |
| Process all | Processes the write-offs for all the listed documents. |
| Element | Description |
|---|---|
| Type | The type of operation. The following types are available: Credit write-off and Balance write-off. |
| Doc. date | The date when the write-offs are performed. |
| Post period | The period to which the write-off transactions should be posted. |
| Branch | The branch for which you want to display data. By default, it is the branch a user is currently logged in. If a user clears the box value, the system displays the documents from all the branches to which the user has access to. |
| Customer | The customer whose balances or credits will be written off. You can select a customer from the list or leave the field blank to view the documents of all the customers. |
| Reason code | A reason code that defines an account and subaccount to be used for writing off credits or balances. By default, the system uses reason codes you specified in the Customer ledger preferences (AR101000) window. |
| Limit | The maximum balance of a document that may be a subject to the selected write-off operation. By default, it is the value specified for the customer (if selected) in the Write-off limit field in the Customers (AR303000) window. You can enter the specific limit manually, if needed. |
| Selection total | A read-only box that shows the total amount on the selected documents. |
| Column | Description |
|---|---|
| Branch | The branch of the document. |
| Type | The type of customer ledger document. The following types can be processed, if the type of operation is set to Balance write-off:
The following types can be processed, if the type of operation is set to Credit write-off:
|
| Ref. no. | The identifier of the document. If you click the link, the system opens the Sales invoices (AR301000) or Customer payments (AR302000) window, depending on the type of the selected document, and displays the details of the selected customer ledger document. |
| Customer | The customer for whom this document is intended. |
| Customer name | The customer’s name. |
| Date | The date of the document. |
| Post period | The post period of the document. |
| Currency | The currency of the document. This column is available only if the Multi-currency accounting functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Foreign currency balance | The open balance of the document in the foreign currency to which payment was not applied. This column is available only if the Multi-currency accounting functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Foreign currency amount | The amount in foreign currency. |
| Amount | The amount in base currency. |
| Balance | The open balance of the document in the base currency to which payment was not applied. |
| Balance % | Percentage of balance from the amount |
| Invoice text | A detailed description for the document in which the amount will be written off. |
| Reason code | A reason code used. |