Contract Account number

[Former Member]

For the contract account number, because of the check digit mechanism, we cannot random input a number for a contract account number. Does anyone knows the formula/method to derive the check digit?

Many Thanks!!

[Former Member · Accepted solution]

Hi,

Logic for check digit mechanism

Account Number verification (d1d2d3d4d5d6d7)

d7 = 10 u2013 ((d1 + 2d2 + d3 + 2d4 + d5 + 2*d6) MOD 10)

Where d1d2d3d4d5d6 (digits will be generated internally) and d7 based on logic given above.

For Example say first 6 digits are 999999 so 7th digit will be

d7= 10 u2013 ((92*992*99+2*9)MOD 10)

d7= 10 u2013 (81 MOD 10) (MOD will give the remainder after dividing by the divisor)

d7= 10 u2013 (81/10 so remainder is 1)

d7= 10 u2013 1 = 9

So contract account number is 9999999.

You can write your code in FQEVENT. Create a Z FM like in event 1019 and attach the FM there.

Hope this resolves your query.

Regards,

Manish

Edited by: Manish Bisht on Jun 25, 2009 8:57 AM

[Former Member · Accepted solution]

One of the sample in my system is 073658994053, any idea on the check digit logic?

Thanks!

[Former Member · Accepted solution]

Hi

you can pass this number to the provided FM and you will get the check digit calculated

it is a standard FM developed specially for CA checkdigit

even for the logic you can check code inside it.

It will resolve your query!

Regards,

Prajakta

Edited by: Prajakta Shringarpure on Jun 25, 2009 1:45 PM

[Former Member · Accepted solution]

For the account number 073658994053

When I pass the number "0736589940" to the FM FKK_SAMPLE_1019_2_CHECKDIGITS, the return is "73658994070" which doesn't match the expected result. Did I use it the FM incorrectly?

[Former Member · Accepted solution]

Hi Wing,

Do you want to add the check digit in the number?

You can do that by the formula

d12 = 10 - ((7+ 2362582992402*5+3)MOD 10)

Or you want to know the check digit of the number.(means is this number that you provided contains the check digit?). Please elaborate your requirement.

Regards,

Manish

[Former Member · Accepted solution]

Hi Manish,

The account 073658994053 is the result with the check digit and I would like to know the check digit and how to derive the check digit. As I need to develop external application in create a correct contract account number. Thanks!!

[Former Member · Accepted solution]

Hi Anthony,

Check digit is determined based on customer specific logic. If its the final number that you are getting, then you check the FM attached to the FQEVENT 1019.

There you will find a 'Z' FM attached. That FM must be containing the logic for getting Check Digit. Otherwise it would be difficult to tell the logic as it can be Customer specific.

I have already given you the logic used in my project.

Hope this helps.

Regards,

Manish

[Former Member · Accepted solution]

Hi Manish

How can I open the "FQEVENT 1019"? Would you mind to give me the details? I am not familiar with this. Many Thanks!

[Former Member · Accepted solution]

Hi Wing,

Go to transaction FQEVENTS. Search for "Check Digits". Click on " 1019 Contract Account: Add Check Digits". Copy Sample FM "FKK_SAMPLE_1019" and create a Z Fm and attach it in the below space given.

Hope it resolves your query.

Regards,

Manish

[Former Member]

Please check this thread.

Please let me know if any issues are there.

Regards,

Siva

[Former Member]

Hi

Try with this FM "FKK_SAMPLE_1019_2_CHECKDIGITS"

Regards,

Prajakta