Skip to main content

When using the bank statement template/upload function for bank reconciliation, how can I upload a Cust/Supp ID on the bank statement for automatic matching?

hi @SMcLees,

Hope you are using “external file assistant” to upload bank statement. If you are using external file template ‘STDBNKSTAT’ there is column ID called ‘CUST_SUPP_ID’ which you can use to upload customer supplier ID. Refer below screen preview for easier reference.

 

Best Regards

Narmada


Hi,

Can I please know if automatic matching can perform with customer/Supplier ID ?


Hi ​@Awije,

 

Yes. Its possible to use ‘Customer/Supplier ID’ as an Automatic Matching Attribute in the Bank Reconciliation Process.

 

You can navigate to Payment Institute Page > select the relevant Payment Institute and use the command option ‘’Payment type Grouping per institute’’ and use the command option “Automatic Matching Attributes”. You can enable the Customer/Supplier ID attribute for the relevant Payment Group.

 

Regards,

Lihini.


Thanks a lot Lihini


Reply