ACH file - Vendor Bank Routing 00000000 & No Company Bank Acc # displayed.

[Former Member]

Hello ALL,

We are using Classing Payment Program for ACH and I am having the following issues and was unable to find a solution to correct it and I have the same problem with either CCD or CTX format (by selecting CCD/CTX in Vendor Master - Reference details field).

I appreciate your time and guidance with this issue -

1) Record file, field 3 in Record 5 having "00000000" instead of Vendor Bank Routing num.

2) Also the Chase bank that were are working with is expecting our Co Bank account # as COmpany ID while the file deriving "1" + TIN# in this field.

3) The file that is being generated doesn't display our Company Bank account # neither in Rec 5 or 6.

4) Bank interface upon submitting CCD/CTX file, displays error " Standard Entry class code are missing or invalid" because - 

   a)  there is no value in "From: Account Number" field

   b) Company Name/ID:  Displays "/1" + our Company TINnum

I have enclosed the screen shots of the errors and also the CCD/CTX files.

Thank you,

Devi

[former_member182098 · Accepted solution]

Please change to PMW structure, you do not need to much.

Just use ACH CTX PMW structure in your payment method.

Maintain variant / file path in OBPM4.

It should give you requisite file without need of changing the output of the file.

PPD and CCD support one addendum record, whereas CTX can accommodate upto 9999 records.

Please refer:

[Former Member · Accepted solution]

Hi Ravi,

Thank you for the quick response!

I have changed to PMW, and now I see our Bank # reflecting correctly the Ist 10 digits out of 11, but I still see error upon submitting to the bank interface "Company ID and /or Standard entry class code are missing or invalid.  And on that screen I see the our Co Bank Account # (from Company ID field) is displayed under Company Name/ID and under "From Account Number" field there are no values displayed, wondering if this is causing the issue.

Secondly, the Vendor routing # still is displayed at 0's.

I have screen shots of the variant config for OBPM4, output file and the error screens shots from the submission to the Bank interface.

Thank you,

Devi

[Former Member · Accepted solution]

Hi Ravi, 

Business user has just provided the correct # that we need to use for Company Id, which I am able to provide via Variant for OBPM4 so issue 1 above is resolved, however I still need make sure that the file fetches the Vendor's Bank routing # correctly (currently it is showing as 0's).

Thank you,

Devi

[former_member182098 · Accepted solution]

Hi Devi,

The company ID alternatively can be given in FI12 (House Bank Configuration)

There is no configuration required for fetching vendor routing number, except it should be maintained in the vendor master record. (all the beneficiary details including country code, routing number, bank account number and beneficiary name). Then it should fetch the vendor routing number into the file. Please check your vendor master record is complete.

Hope this helps.

Regards,

Ravi

[Former Member · Accepted solution]

Hi Ravi,

Thanks again for getting back so quick!

Though Co ID is being derived from OBPM4 variant, I would definitely like to know which field on House Bank can be configured as an alternative.  Does one field has higher priority over the other?

And with vendor master, as you in the screen shot all the fields are maintained and still the ACH file displays 0's and doesn't display the routing #

Thank you,

Devi

[former_member182098 · Accepted solution]

Hi Devi,

In the "data medium exchange", you would find "company number" in FI12. The field is

V_T012-DTFIN

In FBZP, payment methods in country, please ensure format is "ACH" and "format supplement" is entered as CTX.

Question: In line 101 - Posting 4-13 should be filled with Immediate Destination. However, in your file, I could see a blank space. Please refer to the guidelines manual from your bank, as this is a Mandatory field.

I believe in OBPM1, you must be using the following standard function modules for ACH.

00	FI_PAYMEDIUM_ACH_00
05	FI_PAYMEDIUM_ACH_05
20	FI_PAYMEDIUM_ACH_20
30	FI_PAYMEDIUM_ACH_30
40	FI_PAYMEDIUM_ACH_40

If possible, please enter the Swift Code in your bank details, FI02.

Other than this, I could not see anything else, it should pick up the vendor routing number.

Hope this helps.

Kind Regards,

Ravi

[Former Member · Accepted solution]

Hi Ravi,

Until I debugged with the help of ABAPer I did not realize that BNKA-BNKLZ (Bank Number) field should be filled with Routing# in order to be populated in the ACH output file.  After updating the Vendor Bank master data with value in Bank Number the value is populating.

Thank you Ravi, for your time and support!

Devi