Microsoft Dynamics NAV
Introduction
The Microsoft Dynamics NAV implementation of the TimeLog generic financial integration supports the full set of features for a complete integration with TimeLog. The NAV integration supports the following features of the generic financial integration:
Invoicing version:
- Two-way synchronization of customers
- Import of product numbers from NAV to TimeLog
- Transfer of booked invoices from TimeLog to NAV
- Automatic tracking of NAV invoice number and status from TimeLog
- TimeLog Audit interface matching the individual invoice totals from NAV and TimeLog
- Import expenses from NAV to TimeLog
- Export of TimeLog project number to NAV
Quick intro
Install and configuration
Features
This section includes a list of features and limitations to each transfer area of the integration.
Dimensions
TimeLog support transfer of dimensions of the invoice to Global Dimension 1 and 2 in NAV.
Dimensions can be specified for both invoice header and invoice lines. If nothing is specified for the lines they will inherit from the header.
Following dimension can be transferred to NAV:
- - Project number
- - Invoice Department Number
- - Invoice Department Name
- - Employee Department Number (only transferred on invoice line level)
Currencies
TimeLog does not create the currency in NAV if it does not exist. Therefore, make sure that all the currencies used in TimeLog are created in NAV.
Customers
In the integration setup is it possible to control which system that is the master for new customers and how they are synchronized between TimeLog and NAV
Contact
In the integration settings inside NAV, you find the checkbox for turning on/off extended contact handling ("Brug udvidet kontakt mgr").
- If it is turned on, the integration uses the NAV contact relationship ("kontakt relationsstyring"). One-to-many relation.
- If it is turned off, the integration uses the field "kontakt" on the debtor view. One-to-one relation.
Without contact relationship
When a contact is created or updated in TimeLog and transferred to NAV, is the field "kontakt" on the debtor updated with the latest transfer. Any previous transfers are overwritten. When updating the field "kontakt" in NAV, will this NOT create a new contact in TimeLog.
Product numbers
Product numbers in NAV cannot be added/modified/deleted from TimeLog. TimeLog can import NAV product numbers.
Employees
If employees are pushed from TimeLog to NAV, then an employee template is used to map fields that does not exist in TimeLog. The template can be chosen in the NAV-TimeLog settings dialog. Employees cannot be transferred from NAV to TimeLog.
If automatic transfer of employees is turned off, they have to be created manually in "Personale" > "Medarbejdere" using the exact same initials in the "Nummer"-field.
Invoices
Only booked invoices can be transferred from TimeLog to NAV. Invoices are transferred as drafts. Changes in invoice drafts inside NAV will not be reflected in TimeLog.
Invoice lines
The TimeLog field "Unit of meassure" is NOT transferred to NAV on invoice lines. In NAV, the field "Enhedskoden" defaults to the one specified in the item setup ("Vareopsætningen").
Expenses
Expenses can only be transferred from NAV to TimeLog. TimeLog notifies NAV if an expense is taken or deleted from the import pool.
Projects
Optional transfer of project number to either NAV global dimension 1 or 2 is possible
Tasks
Tasks can only be transferred from NAV to TimeLog. If tasks are deleted or moved in NAV then this will not be reflected in TimeLog.
Allocations
Allocations can only be transferred from NAV to TimeLog.
Registrations
Time tracking in TimeLog is not transferred to NAV
Mapping
This section contains the explicit mapping of fields between TimeLog and NAV.
Customers
| Field name | Technical name | |||
|---|---|---|---|---|
| TimeLog | NAV | TimeLog | NAV | Remarks |
| Company name | Name | Name | Name | |
| Customer No. | Customer No. | CustomerNo | No | |
| Phone | Phone | Phone | PhoneNumber | |
| Fax | Fax | Fax | Fax | |
| VAT no | VAT no. | VatNo | VATNo | |
| Organisation no. | Registration no. | OrganizationNo | RegistrationNo | Only available on Swedish NAV at the moment |
| EAN no. | EAN no. | EAN | EAN | |
| Address | Address | Address.Address | Address | |
| Address 2 | Address 2 | Address.Address2 | Address2 | |
| Address 3 | - | Address.Address3 | Is not transferred | |
| City | City | Address.City | City | |
| State | Territory | Address.State | Territory | |
| Country | Country | Address.CountryISO | Country | |
| Postal code | Postcode | Address.ZipCode | Postcode | |
| Website | Homepage | Website | Homepage | |
| Currency | Currency | Currency | CurrencyCode | |
| Owner | SalesPerson | KeyAccountManagerInitials | SalesPerson | Is not transferred on customer |
Contact persons
Contact persons at the TimeLog customer is only transferred together with the invoice
Product numbers
| Field name | Technical name | |||
|---|---|---|---|---|
| TimeLog | NAV | TimeLog | NAV | Remarks |
| No. | No. | ProductNo | No | |
| Name | Description | Name | Description | |
| Description | Description 2 | Description | Description2 | |
Employees
TimeLog employees is only transferred together with the invoice if listed as internal reference on the invoice
Invoices
| Field name | Technical name | |||
|---|---|---|---|---|
| TimeLog | NAV | TimeLog | NAV | Remarks |
| Customer No. | Sell-to Customer No. | CustomerKey | Sell-to Customer No. | |
| Contact No. | Bill-to/Sell-to Contact | ContactKey | Bill-to/Sell-to Contact | |
| Currency | CurrencyCode | CurrencyISO | CurrencyCode | Abbreviation of the currency from the invoice in TimeLog |
| Invoice Date | Document Date | InvoiceDate | DocumentDate | |
| Customers Reference / Invoice Address:(AttContactFullName) | Your Reference | CustomersReference / FixedAttContactFullName | YourReference | If customer Reference is null or empty FixedAttContactFullName is used and is truncated to 30 characters in NAV. |
| Default discount %: | Invoice Disc. Code | DefaultDiscount | InvoiceDiscCode | |
| Prices Including VAT | PricesIncludingVAT | Is always set to false | ||
| Due Date | DueDate | Due Date | DueDate | |
| EAN | EAN | EAN | EAN | A specified EAN no. can be put in "Requisition no." on invoice. The number must start with "EAN" to be taken in consideration. If none in "Requisition no." invoice EAN will be used. Both are truncated to 13 characters. |
| Requisition No | External Document Number | RequisitionNo | ExternalDocumentNumber | Id truncated to 35 characters |
| Invoice No | No | InvoiceNo | No | |
| Invoice address: (Customer name) | Sell-To Customer Name | FixedCustomerName | SellToCustomerName | |
| Invoice address: (Att Contact Fullname) | Bill-to/Sell-to Contact | FixedAttContactFullName | Bill-to/Sell-to Contact | |
| Invoice Date | PostingDate | InvoiceDate | PostingDate | |
| Invoice Date | OrderDate | InvoiceDate | OrderDate | |
| Heading | Posting Description | Header | PostingDescription | Is truncated to 50 characters in NAV. Setup a warning in TimeLog |
| Message | In not transferred | |||
| P.O. No | Quote No | RequisitionNo | QuoteNo | Is truncated to 20 characters |
| VAT % | Is not transferred. Is a default setup in the integration page | |||
| Internal Reference Initials | Sales Person Code | InternalReferenceInitials | SalesPersonCode | |
| Invoice address: (Country Code(ISO)) | Bill-to/Sell-to Country Code | FixedCountryISO | Bill-to/Sell-to CountryCode | |
| Invoice address: (address 1) | Bill-to/Sell-to address | FixedAddress1 | Bill-to/Sell-to address | Is truncated to 50 characters |
| Invoice address: (address 2) | Bill-to/Sell-to address 2 | FixedAddress2 | Bill-to/Sell-to address 2 | Is truncated to 50 characters in NAV |
| Invoice address: (Zip code) | Bill-to/Sell-to PostCode | FixedZipCode | Bill-to/Sell-to PostCode | |
Invoice lines
| Field name | Technical name | |||
|---|---|---|---|---|
| TimeLog | NAV | TimeLog | NAV | Remarks |
| Product no. | Product no. | ProductNo | Product | |
| Description | Description | Description | ||
| Quantity | Quantity | Quantity | Quantity | |
| Unit | Unit | - | InvoiceUnitType | If not set, is pieces used as default. |
| Rate | Price | Rate | UnitPrice | |
| % | Discount (%) | Discount | - | |
Expenses
| Field name | Technical name | |||
|---|---|---|---|---|
| TimeLog | NAV | TimeLog | NAV | Remarks |
| Currency | Currency | CurrencyISO | CurrencyCode | The currencyISO in TimeLog is fetched from the TimeLog currency, based on the currency abbreviation on the purchase from NAV |
| - | - | CurrencyRate | CurrencyRate | The CurrencyRate in TimeLog is fetched from the TimeLog currency, based on the currency abbreviation on the purchase from NAV |
| DisbursementNo | - | |||
| InvoiceNo | ||||
| Payment method | PaymentMethod | - | Default payment method for import is setup in TimeLog | |
| Date | Date | PurchaseDate | DocumentDate | |
| Amount incl. VAT | Amount (Curr) | CostCurrencyIncludingVAT | Amount | |
| Comment | Comment | entry.Account.AccountNumber | ||