Skip to main content
Question

External File Assistant - Bank Recon Template

  • August 29, 2023
  • 1 reply
  • 59 views

Forum|alt.badge.img+2

I am trying to create a template for automatic matching for the bank reconciliation.  I receive an error that I do not have enough columns and/or wrong decimal sign.   What is the difference between the “Destination Column” and the “Column No.”  I am wondering if that is my issue. 

 

1 reply

BEKEDE
Sidekick (Employee)
Forum|alt.badge.img+6
  • Sidekick (Employee)
  • 21 replies
  • August 29, 2023

@gcraig22 

Can you please provide a screenshot of your external file template details? 

There you apply your Decimal Symbol and your text separator. This would be the first check if the decimal symbol in your external file template details matches the ones in your file.

 

The difference between Column No. and Destination Column is the following.

The Column No. determines the order in which your columns should be arranged in your file.

The Destination Column is the data base column in the underlying table. 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings