Creation of cost units individually
Import details
Importing data into Purchase Invoices register
Exporting data from Purchase Invoices
Cost units -view is used to establish the cost units used in Purchase Invoices. Cost units can also be imported as a csv file (Reg. maintenance function)
Settings related to the cost unit are also available in the general settings, on the Accounting Assignments tab (Settings - General - Accounting Assignments). Check the general settings if necessary.
Creating cost units individually
- Go to the Registry – Cost Units view
- Click the New button
- Fill in the details in the opening window and save them finally with the Save button.
Cost unit number/name
Write the number for the cost unit being created and name it. The program will check at the saving stage that the given number is not already in use.
Additional Information
This field can store additional and contact information related to the cost unit, for example. The additional information provided for the cost unit will not be visible on the invoice.
Import Information
The file to be imported into Purchase Invoices must have the column names (headers) on the first row. The order of the columns is flexible. The mandatory columns are cost unit number and name. Other columns are optional. The data must be saved in a semicolon-separated csv file format (csv list separator). After the file is imported, you will receive a listing of new and erroneous cost unit.
Importing Data into Cost Units Register
- Go to Registers – cost units view
- Click the Register upkeep button in the opened view
- Define the details for importing cost units
Select csv file
Click the Browse button and select the csv file to be imported from the storage directory.
Character Set
Select the character set to be used during the import by choosing from the dropdown list of the field. The selected character set must be the same as the one used to create your file – default is ISO-8859-1.
If cost unit data already exists in the system
Select whether to update the existing cost units in or leave the existing cost units unchanged.
Refresh: updates the cost units already in the register and also creates new cost units
Skip: does not update existing cost units but only creates new cost units
Load
When you click the Load button, the selected csv file is retrieved into the register.
An import report is generated, showing the import settings, successful imports, and detailed information on failed imports with error messages explaining why they failed.
Exporting Data from Cost Units Register
If necessary, the data from the cost units register can be transferred to another core system.
- Go to Registers – cost units view
- Click the Register upkeep button at the top of the opened view
- Define whether to add quotation marks to the cells in the file
- Download cost units to an Excel file by clicking the Load button
- Save the file to your desired target directory and transfer it to the core system in use.
Download the cost units data as a csv file to your own computer.
When you click the Load button for that field, the suppliers saved will open in Excel as a csv file.
Should quotation marks be added to the beginning and end of the data in the cell?
You can choose whether you want the data in the file being transferred from Accounts Payable to the core system to be marked with quotation marks. The quotation mark preserves any leading zeros in the cell data.
You can download an example file from the bottom of the registry upkeep - maintenance
cost centre page