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

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

(0) Share

Report

Posted on by Pablo Rocha

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

All responses (3)

Answers (0)

Suggested answer

MahGah 15,428 on at

Like (0)

Report

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 15 on at

Like (0)

Report

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 15,428 on at

Like (0)

Report

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/.../