Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

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

(0) ShareShare
ReportReport
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

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,428 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,428 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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans