Skip to main content
Solved

How to add supplier bank account no in same format based on the supplier master--> Payment instruction


Forum|alt.badge.img

Hi,

 

I’ve added supplier bank details in the supplier master GI, but bank account number is not displaying in the same format as per the supplier master payment instruction. so how we can solve this.

I would really appreciate, if someone can help me on this. 

 

 

 

 

 

 

 

 

Best answer by psoni1585

Hi,

Sorry, just made small changes in the formula and this is the correct formula to display account no in same format.

IIF(LEN([Bankaccountnumber.DetailValue])=16,Concat(LEFT([Bankaccountnumber.DetailValue],2),'-',SUBSTRING([Bankaccountnumber.DetailValue],3,4),'-',SUBSTRING([Bankaccountnumber.DetailValue],7,7),'-',RIGHT([Bankaccountnumber.DetailValue],3)),[Bankaccountnumber.DetailValue])

 

 

 

 

 

View original

Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13

Hi @psoni1585 

Could you please share XML once?

 


Forum|alt.badge.img

Hi @manikantad18 

Please find attached XML file of GI.

Thanks 

Pankaj Soni


Forum|alt.badge.img
  • Jr Varsity I
  • May 30, 2023

I think that is under the payment method, one of the setting tab.

 

Please check here:

 


Forum|alt.badge.img

Hi,

 

It’s been solved after changing bank account formula in the GI.

=IIF(LEN([Bankaccountnumber.DetailValue])=16,Concat(LEFT([Bankaccountnumber.DetailValue],2),'-',SUBSTRING([Bankaccountnumber.DetailValue],2,4),'-',SUBSTRING([Bankaccountnumber.DetailValue],6,7),'-',RIGHT([Bankaccountnumber.DetailValue],3)),[Bankaccountnumber.DetailValue])

 

Thanks.

Pankaj Soni


Forum|alt.badge.img

Hi,

Sorry, just made small changes in the formula and this is the correct formula to display account no in same format.

IIF(LEN([Bankaccountnumber.DetailValue])=16,Concat(LEFT([Bankaccountnumber.DetailValue],2),'-',SUBSTRING([Bankaccountnumber.DetailValue],3,4),'-',SUBSTRING([Bankaccountnumber.DetailValue],7,7),'-',RIGHT([Bankaccountnumber.DetailValue],3)),[Bankaccountnumber.DetailValue])

 

 

 

 

 


Chris Hackett
Community Manager
Forum|alt.badge.img

Thank you for sharing your solution with the community @psoni1585 !


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