NAV 2017 Bank Statement CSV import - Statement Amount - Decimal always null

CiroYUP
CiroYUP Member Posts: 2
in NAV Three Tier
Hi everyone,
I'm trying to import bank statement from CSV file into Bank Reconciliation panel.

A typical line is the following:

Stat.Date;Value Date;Amount;..
3.04.2018;13.04.2018;10.000,00;....

It correcly import date and text but nothing todo with the decimal so I see all the statement lines imported with correct fields but all statement amounts fields are zero.

I solved on NAV2018 where the flag "Overwrite Value" seems solving the problem in Data Exchange Definition/Field Mapping.

This flag is not available on NAV2017.

Any suggestion is appreciated

Ciro






Answers

  • CiroYUP
    CiroYUP Member Posts: 2
    Hello BT, thank for your support!

    Decimal format displayed in NAV is #.###,## and is the same in the file and in the system settings.
    I checked the decimal format of the system (it was already ok) and copied the settings to the Current User/Welcome Screen/New User Accounts.
    Restarted NAV but didn't solve.

    Gone deeper on the flag "Overwrite Value" in NAV2018..is not that one changing the result.

    I also changed manually the CSV content putting different formats but no one is imported.

    If you have in mind other places where to check the format let me know.

    Ideas?

    Ciro
  • kriki
    kriki Member, Moderator Posts: 9,121
    [Topic moved from 'Navision Financials' forum to 'NAV Three Tier' forum]

    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories