Uniconta Update 87
Release date: March 21, 2021
Ledger
Now there are 3 new functions to change a posted transaction: “Add VAT”, “Remove VAT” and “Change customer/vendor”. In addition, we have added a function to copy a transaction to the journal, where you can change the date, text or sign. The function “Change customer/vendor” can be used, if you have posted a payment to a wrong customer, you can now easily change it to the right customer, and Uniconta then cancels the settlement on the wrong customer, deletes the record and create a new transaction on the right customer, as well as possibly closes the open transaction.
It may be that you start with Uniconta with only one dimension. Later you create dimension number two, and now you want both dimensions to be filled in on the existing items. Under General Ledger/Maintenance/Dimensions, you can run conversions here that convert any combination of dimensions to any other combination of dimensions.
Intrastat has been updated with the extended file format which will be mandatory from January 2022.
In future, it will be a requirement to state:
- Country of origin (country of manufacture)
- Recipient’s VAT number
The Multi Excel format is read out, which can then be uploaded to IDEP.web. A new field has been added to the item table to indicate a supplementary unit.
- You can switch between combo-box fields with the space bar. Ex. General Ledger/Customer/Vendor in the class journal.
- In balance sheets, if the “from date” is equal to the start of the financial year, then you can choose whether you want the opening balance to show or not
- The invoice journal now has dates for sent by e-mail and sent via OIOUBL
- The invoice journal now has a check mark for “Error when sending”
- The VAT statement now shows the VAT code from the chart of accounts, so you can easily see if there are any discrepancies
- Payment terms have been given current month on the cash discount
Fixed Assets
- Fixed Assets has been given “Reversed depreciation”, which is displayed in a separate field
- The first depreciation now takes into account the “skewed” purchase date
Customer/
Vendor
When you create a vendor, you can choose to fill in the field “customer”. Then the customer and vendor will split the transactions so that one can settle a vendor invoice with a customer invoice.
In the vendor overview, the vendor will have a balance of 0, as the balance now only appears on the customer. In the pop-up menu for this vendor, you can, however, select “entries” and “open entries”, where Uniconta then shows the entries from the customer.
In vendor reports, these items are not included.
In payment proposals, Uniconta will also show items from the customer whose balance is negative, and the customer owes money. If you have already created a vendor, it is not enough just to fill in the field “Customer”. Then, in Vendor/Maintenance, you must choose to merge vendor with customer. When the menu item is run, entries already made on the vendor will be moved to the customer.
We already have a total discount % on the customer/vendor, and now we have created a “Line discount %”, which is then inserted into the order line when a new line is inserted. The value can be rewritten.
- You can switch between combo-box fields with the space bar. Ex. General Ledger/Customer/Vendor in the class journal.
- On customer/vendor account statements, you can now select transactions “Due invoices only”
Customer/
Sales Order
It is now possible to simulate sales order and quick invoice using F7. It quickly shows the total amount.
Customer
In the pdf for account statements, interest and collection letter, there is now a link to view the invoice.
An invoice series can now be associated with the individual customer group, so that all invoices to customers in this customer group are assigned invoice numbers from this number series instead of the standard number series for invoices.
It is e.g. a requirement that if a Danish company is VAT-registered in England due to the new Brexit rules, then all invoices posted with English VAT must be invoiced with a consecutive invoice number series.
Because Brexit an EORI field is added to the Customer Directory and to the Company Information.
The field is used when Danish companies invoice companies in England, where it is a requirement that the recipient’s EORI number and the company’s own EORI number appear on the invoice.
All invoices sent by e-mails or OIOUBL will now be saved in a log. The log can be opened from the Invoice journal, Customer and the main menu. Two new fields in the invoice journal will show if an error has occurred in sending the e-mail. You can open the log to see the error.
Account statement now shows due balance in relation to “to date”
Vendor
- At the vendor, you can now select “None” in Method of payment, so no payments are included in the payment proposal
- GLN number has been added to the Vendor and can be used for receiving UBL.
- Vendor has been given the same CRM fields as Customer
- Payment reference in payment proposal has changed into a new number series that starts from 100.000
Sales Order
On order lines, you can now drag in a search field where you can enter the customer item number. Then Uniconta searches in the “item name group” to find this item number, as the customer’s item number. If Uniconta finds the number, the item number and variant are filled in. The new field is only a search field and is therefore not saved.
If you choose this option, the tax will only appear once on the order, even if several items have this duty.
- If you change the delivery date on the order header, the date on the lines automatically be changed
- Order has received the field “Delivery date confirmed?”
- Order has been given the field “Task”
- On order, quotation, purchasing and production lines, we have a “Product reference”. Here are 2 new menu items: Item Notes and Item Attachments.
Inventory
- Many new units in stock
- Volume, weight and volume on the storage card have now been given 6 decimals
Logistics
We now have a delivery date on the lists of reservations. This date is then used on the next 2 reports. In this picture you can now also jump with F6 to the orders.
On the re-order list, you can now delimit the delivery date, so that you e.g. does not get needs / deliveries that are far into the future.
We have developed a new requirement profile. The report is divided into periods of your choice and will then for each period show planned departures / approaches. You can switch between to show Movement / On-hand.
Under Company/Maintenance/Configure application functionality, you can select having a BOM per variant. In the inventory, select “Item variants” or “Variant details”. Here you will then see the BOM menu, where you can create a new BOM for the given variant.
On order lines, you can now drag in a search field where you can enter the customer item number. Then Uniconta searches in the “item name group” to find this item number, as the customer’s item number. If Uniconta finds the number, the item number and variant are filled in. The new field is only a search field and is therefore not saved.
If you choose this option, the tax will only appear once on the order, even if several items have this duty.
Inventory / Reports / Postings, has been given “Mark inventory transactions” just as we have within the order lines. This allows you to either unmark or unmount inventory transactions. So if you forgot to mark in the order lines and have updated the invoice, then you can later mark here.
Account statement now shows due balance in relation to “to date”
Project
Now you can associate individual employees with projects, so these employees only see the projects they are part of. The new menu item is called “My Projects” and must be turned on in Company/Maintenance/Configure application functionality. The list of “My projects” can be maintained both on the project and on the employee.
- For project invoices, we now transfer the project number to the financial transaction
- Project can now post an invoice with a specific task
- Time Planning now has the opportunity to retrieve last year’s realized numbers
- Work in progress has been given two new columns: Hours (posted hours) and Production (the hours worked excluding internal types such as holidays, illness, etc.). It will be possible to group on tasks.
- Timesheet approval in Time has been added a new column Production and current column Registered hours is now showing the registered houses for fulfilling the regular hours except lines with negative overtime and flextime.
- In date fields in “Time” we used today’s date by default. Now the system date is used.
General
Now this setup has got attachment and notes. The attachments are sent out by e-mail. It is especially useful in CRM, where one uses this setup to make email broadcasts.
When e-mail systems are set up to forward an e-mail, the field “to” will still contain the original recipient. When Uniconta receives an e-mail in the inbox, we look at what is in the field “to” and “cc”.
If we do not find the scan e-mail here, we cannot save the physical attachment. Now we have created a field in the company information: “E-mail, forwarded to the inbox”, where you can enter the e-mail that you originally sent to and forwarded from. When our server cannot find the “scan e-mail” in “to” or “cc”, it looks at whether “to” or “cc” matches this e-mail in the new field in the company information.
Many people choose to turn on everything in Company/Maintenance/Configure application functionality, and still not use these functions. Therefor every Sunday we will be looking at whether one e.g. uses “duty”, and if not, it will be turned off. The advantage of turning off functions when not in use is that the menus become smaller, and that Uniconta does not call the server to retrieve data.
These are: Units, fees, batch, storage locations and location, variants, item name groups and Project tasks.
Version 87 is the last version with Silverlight. In future, it should be noted that Uniconta is a Windows App that must be run on Windows.
Read more: https://www.uniconta.com/downloads/uniconta-on-mac/
- With a klick on the right mouse button you can now select “copy line” or “copy field”. Before, there was only a “copy line”
- Employee has two new fields. “Private mobile” and “Private email”
Microsoft Azure provides two factor authentication which is easy, convenient and secure. Read more: Azure Authentication in Uniconta