Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Business Central forum / Importación de estado ...
Business Central forum
Suggested answer

Importación de estado de cuenta bancaria desde archi .CSV con dos columnas de importe

Posted on by 15

Hola a todos,

Sabe que configuracion realizar en BC para poder importar un estado de cuenta bancario con dos columnas de importe. Ejemplo Depositos y Retiros, esto utilizando la funcionalidad de Configurar formato de importación de archivo de estado de cuenta de banco.

Espero me puedan apoyar.

Saludos

Categories:
  • Suggested answer
    MahGah Profile Picture
    MahGah 15,419 on at
    RE: Importación de estado de cuenta bancaria desde archi .CSV con dos columnas de importe

    Hi

    Maybe Dallefeld  can provide more info. But I think (and I could be very wrong) you need one setup for positive and one for negative. Then break the file between these two setup. But please wait for other provide more info.  

  • Pablo Rocha Profile Picture
    Pablo Rocha 15 on at
    RE: Importación de estado de cuenta bancaria desde archi .CSV con dos columnas de importe

    Hi,

    Tanks for your answer. I already applied the configuration. But the error is when importing the file, it loads the values ​​​​of column X and then when applying the values ​​​​of the column Y the system replaces those of column X.

    For example:

    I need to import the file that has two columns of Amount, one for income and one for expenses, but when importing the file the system first loads the records of the income column and later when applying the values ​​of the expenses column it replaces the data in the income column.

    Is there any transformation rule that allows me to enter concatenate values ​​of column X and Y?

    Best Wishes.

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,419 on at
    RE: Importación de estado de cuenta bancaria desde archi .CSV con dos columnas de importe

    Hola

    espero esta ayuda. Lo siento, usé Google Translate.

    www-loganconsulting-com.translate.goog/.../

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,645 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans