Page tree
Skip to end of metadata
Go to start of metadata

Introduction

Scope provides a function to create an Account Payable by importing a CSV-file. To properly map the data contained in the CSV-file a template needs to be defined beforehand.

Description

Actions

New

This action will create a new AP Import Template

General Tab

General
  • Type                    Determine whether the template is for CSV-files or UBL-files
  • Template name   Name of the template, in order to select it when processing the actual file
Vendor
  • Fix vendor / Determine Vendor Indicator    Whether the layout definition applies to a fixed vendor or if the vendor is determined on basis "creditor account number" listed in the csv file
  • Vendor Account number                              In case the previous radio is set to the creditor account number, insert the column letter which contains the account number

Note: the matching is done on creditor accounting number and not on partner code

Reference Columns
New

Opens a window to register a new AP Import Template

  • Column: The respective column in the CSV to read the reference from
  • Reference type: The type of reference. The type can be chosen from the list of available references.
Edit

Opens the marked entry for editing.

Delete

Deletes the marked entry

  • Additional parsing information
  • Skip Header: If active, the first line in the csv file will be interpreted as Header. To skip other lines see 'Lines to Parse'
  • Field Seperator: Identifies the character used as field separator 
  • Decimal point: Indicate which character is used as "decimal" 
  • Date Format: Indicate the format in which the date fields are populated
  • Lines to Parse: Indicate if lines should be skipped during processing (for instance header or file start/end lines)
    • All data lines : All data lines should be processed (all lines are equally formatted)
    • Identify lines by column value: Lines that should be processed are recognized by value (indentifier) in the indicated column
    • Skip lines by column value: Lines that should not be processed are recognized by value (indentifier) in the indicated column
Data
  • Invoice number: The invoice number of the supplier,
  • Internal number: The booking number assigned to the purchase invoice
  • Invoice type: Indication of type of Invoice (normal or credit invoice)
  • Credit Note id: If the previous column is used, this additional field is mapping to the column where the credit-invoice number is registered
  • Invoice date: Invoice issue date
  • Invoice due date: Due date of the invoice when it should be paid
  • Currency: The currency of the invoice
  • Total Amount Line: Total amount per Taxable type ( sum of VAT basis amount per VAT type (taxable / free)
  • Total Vat amount line: Total amount TAX per Taxable type ( sum of VAT basis amount per VAT type (taxable / free)
  • Total Invoice amount: Total invoice amount including VAT
  • Total invoice VAT: Amount Total Invoice VAT amount

Charges Tab

Charges
New

  • Charge type column: The respective column in the CSV to read the charge type from.
  • Amount column:        The respective column in the CSV to read the charge amount from
  • Tax amount column:  The respective column in the CSV to read the tax amount from if applicable
Edit

Opens the marked entry for editing.

Delete

Deletes the marked entry



Charge type mapping
New

  • Vendor code: The respective column in the CSV to read the charge reference from
  • Charge Type: The Scope charge type to map to
  • Radio button "Map to charge type": The provided reference is mapped to the Scope charge type provided
  • Radio button "Parse as tax amount": A line with the provided reference is treated as a tax amount
Edit

Opens the marked entry for editing.

Delete

Deletes the marked entry

Product Tab

New

  • Vendor code: The vendors code for the product involved in the billed service
  • Product: Scope code for the product involved in the billed service
Edit

Opens the marked entry for editing.

Delete

Deletes the marked entry

Cancel

Exits from the action without saving

Automation Tab


  • Create accounts payable: Tick this box if you want the accounts payable to be created automatically
  • Finalize accounts payable: Tick this box if you want to finalize the accounts payable automatically providing the following conditions are met.
  • Absolute amount: Maximum deviation of charge amounts between previously registred estimate amounts and amounts charged in the import
  • Percentage (%): Percentage deviation of charge amounts between previously registred estimate amounts and amounts charged in the import

Edit

Opens the highlighted AP Import Template for editing. Alternatively the AP Layouts can be opened and edited by double clicking it.

Refresh

Refreshes the index to ensure the latest AP Import Templates are visible.

Show removed

Check this box to include AP Import Templates that may have been removed.

Type to Search

This is a full text search field. Enter the AP Import Template code, name or part thereof to search for the desired AP Import Template





  • No labels