ALT ACCT NO TO T24 ACCOUNT NO

  • Nash21979
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
7 years 7 months ago - 7 years 7 months ago #19846 by Nash21979
ALT ACCT NO TO T24 ACCOUNT NO was created by Nash21979
Hi Guys,
How is it possible to check/convert alt account number to T24 account number?
planning to use it DE.I.MTxxx routine.
many thanks
Last edit: 7 years 7 months ago by Nash21979.

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Globus|G09-G13 TAFC|R05-R23 TAFJ|R19,R23-test
More
7 years 7 months ago #19847 by VK
Replied by VK on topic ALT ACCT NO TO T24 ACCOUNT NO
Hi
Read the file Fccc.ALTERNATE.ACCOUNT (where ccc is the mnemonic of the current COMPANY).
ID = alternate_account_id,
record contains T24 account number in field 1.

Cheers
VK
The following user(s) said Thank You: Nash21979

Please Log in or Create an account to join the conversation.

  • Nash21979
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
7 years 7 months ago #19848 by Nash21979
Replied by Nash21979 on topic ALT ACCT NO TO T24 ACCOUNT NO
Thanks a lot!

Please Log in or Create an account to join the conversation.

  • Nash21979
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
7 years 7 months ago #19903 by Nash21979
Replied by Nash21979 on topic ALT ACCT NO TO T24 ACCOUNT NO
Hi again,
I made a wrapper routine that takes as a parameter the account number (might be alternate or T24 internal number).
it then fetches in the ALT table if it finds it it returns the T24 number, if it doesnt it checks in account table, if it finds it it returns the T24 number else it returns null.
is there any already avaiable funciton to achieve this? BTW the subroutine is working fine, just checking for a more elegant way to achieve this.
Take care

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Globus|G09-G13 TAFC|R05-R23 TAFJ|R19,R23-test
More
7 years 7 months ago - 7 years 7 months ago #19905 by VK
Replied by VK on topic ALT ACCT NO TO T24 ACCOUNT NO
Hi
Looks OK as you described it.

Cheers
VK
Last edit: 7 years 7 months ago by VK.

Please Log in or Create an account to join the conversation.

More
7 years 7 months ago #19906 by T24P
Replied by T24P on topic ALT ACCT NO TO T24 ACCOUNT NO
Can you please suggest how to create/convert T24 ACCOUNT NUMBER to ALTERNATIVE.NUMBER

Thanks...

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Globus|G09-G13 TAFC|R05-R23 TAFJ|R19,R23-test
More
7 years 7 months ago #19908 by VK
Replied by VK on topic ALT ACCT NO TO T24 ACCOUNT NO
Hi
Not sure what you want to achieve... Get alternate number from T24 number?
Or to choose the scheme of mapping one to another?

Cheers
VK

Please Log in or Create an account to join the conversation.

  • Nash21979
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
7 years 7 months ago #19910 by Nash21979
Replied by Nash21979 on topic ALT ACCT NO TO T24 ACCOUNT NO
www.t24all.com/index.php/forum/t24-payme...50k-mt103.html#18102

Please see if this approach works for you

Please Log in or Create an account to join the conversation.

More
7 years 7 months ago #19918 by T24P
Replied by T24P on topic ALT ACCT NO TO T24 ACCOUNT NO
Hi Nash,

Thanks a lot, I got my answer..

Please Log in or Create an account to join the conversation.

  • Nash21979
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
7 years 7 months ago #19921 by Nash21979
Replied by Nash21979 on topic ALT ACCT NO TO T24 ACCOUNT NO
Glad to hear that :)

Please Log in or Create an account to join the conversation.

Time to create page: 0.130 seconds