Here you can see how to import your data to ERPLY Books.

 

 

Default CSV file alignment for invoice import

NB! You can find Tax Rate Name if you go to Settings > Tax Rates. If Tax Rate doesn’t exist in the Tax Rate List you need to add it, otherwise import won’t happen. Also you need to add the same Tax Rate Name as in the list to your import file.

Please notice that if you have different Tax Rates on the invoice, you need to import this invoice with two rows, meaning you need to add every tax rate as a separate row in your import file with same invoice number.

Additional options for invoice import 

You have the following options: 

  • If you don’t want to separate projects with project names and instead want to use projects separated by project groups then you can add project group columns
    • If you want to use project groups then add them into separate columns after currencyRate – leave one empty column after currency rate and then every project group into separate column
    • Into the header of the project, the group column adds project group id. Id values you can get from the report generator
  • You can change the format of the columns
    • If you want to use your own alignment not the default one then add global GLOBAL_USE_INVOICE_IMPORT_ORDERING
    • With that global in invoice import, you have an ordering field where you can add your own ordering alignment. It should have previously described column names separated by “|”, “,” or “;”. 
  • You can add custom fields. 
    • If column alignment is not overridden then additional fields start from column U (the same as project groups). 
    • For example, if you want to add customer registration code into column U then make sure U1=registrationCode. 
    • All the additional customer columns are described here: 
      • bankAccountNumber
      • bankIban
      • bankIdentifier
      • bankName
      • bankSwift
      • code
      • contactPersonEmail
      • contactPersonName
      • contactPersonPhone
      • email
      • entityTypeCode
      • fax
      • info
      • invoiceSendingAddress
      • invoiceSendingIdentifier
      • legalAddress
      • legalCity
      • legalCountryCode
      • legalPostcode
      • phone1
      • phone2
      • referenceNumber
      • registrationCode
      • supplierReferenceNumber
      • vatNumber
      • Website
    • All other additional columns: 
      • paymentDate
      • paymentSum
      • paymentAccountNumber
      • paymentAccountId
      • paymentArchivingId
      • parentDocumentNumber – requires GLOBAL_INVOICE_IMPORT_PARENT_TYPE