Lockbox error - No data error

[Former Member]

I am trying to create a test file for lockbox and upload it. I get list contains no data error.

Do you experts see any issues with the below lockbox file?

10000IDESTEST00IDESTEST1309031236

200IDESTEST00IDESTEST

5001001123456713090300IDESTEST00IDESTEST

600100100001000000830001080123456789000100000

40010016019180000000000000000001000000000000000000

700100112345671309030010000100000

80010011234567130903000100001000001

900007

Appreciate your help.

Thanks

[former_member221128 · Accepted solution]

Hi,

I observe your lock box file, in that fourth record invoice no and amount position value is zero.

Check your file all fields’ position and length with attached BAI2 format.

Sagar

[Former Member · Accepted solution]

Hi Sagar,

I tried the below lockbox file upload in reference to the format you sent. Still get the No data error. I am trying to test this in the IDES system. Do you see anything issues with the file below? Any suggestions are welcome.

10000IDESTEST00IDESTEST1409181259

20000000000000000000000

5111001123456714091800IDESTEST00IDESTEST

61110020000100000083000108012345678910000055

4111003601900000018000000040000100000

711100412345671409180010000100000

8111005123456714091800010000100000

900007

Reagrds

PBK

[Former Member · Accepted solution]

Hi PBK,

Please provide me the below details :

Destination:

Orignin:

Lockbox Number:

Customer Invoice Number:

Amount :

Customer Master Bank Details:

Check No:

I will create a lockbox file for you

Regards,

Prakash

[former_member221128 · Accepted solution]

Hi,

Lock box file is perfect, no issue in that file. check config only,if still have a issue then share error message exact what you are getting.

Based on your file i observe the below fields, check with your system?

Destination:  00IDESTEST

Orignin:  00IDESTEST

Lockbox Number: 1234567

Customer Invoice Number: 0000001800

Amount : 1000.00

Customer Master Bank Details:

Check No:  10000055  it should be 9 digit s

Sagar

[Former Member · Accepted solution]

Thank you Prakash. Can't appreciate your help enough.

Here you go

Destination:IDESTEST

Orignin:IDESTEST

Lockbox Number:1234567

Customer Invoice Number:1800000004

Amount :USD 1000

Customer Master Bank Details: Bank Key : 083000108 Bank A/c : 123456789

Check No: 10000055

Regards

[Former Member · Accepted solution]

Please read Check Number as 100000155

Regards

[Former Member · Accepted solution]

Hi Sagar,

I will re- evaluate the configs once again.

All fields  are correct except the Customer invoice number which is :180000000 and not 1800. Can you advice what should the record type 4 be?

Regards

[former_member221128 · Accepted solution]

Hi PBK,

In only BAI2 file have the record type 4; this will be not in BAI file.

Record type 4 more help to identify the customer invoice.

In record type 4 only contains the fields Customer invoice number, amount for that invoice and if that invoice has a deduction amount (Payment Differences) and deduction reason codes. 

Sagar

[Former Member · Accepted solution]

Hi PBK,

Please try this file :

100IDESTESTIDESTEST140922

21GNOREDBYSAP0000000000

58660011234567140922IDESTESTIDESTEST

68660020000050000083000108123456789100000155

486600360191000003050        00050000000000000000

786600412345591409220010000050000

8866005123455914092200010000050000

9000000

Amount is 500

Invoice No. 1000003050

Please try now and let me know if you any queries.

Regards,

Prakash Kumar

[Former Member · Accepted solution]

Thank you Prakash. It works!

Can you enlighten me on what is the functionality of the Batch Number (866 in your case?)

It seems that this made a lot of difference...

Thanks once again.

[Former Member · Accepted solution]

Hi PBK,

Please check BAI2 Record details through SE11.

Kindly refer this link : http://wiki.scn.sap.com/wiki/display/ERPFI/BAI2+Format+for+Lockbox

Hope this helps !!

Regards,

Prakash

[Former Member]

Hi PBK,

Please check this link which contains BAI2 format :

http://scn.sap.com/docs/DOC-46723

In case of any query please let me know.

Regards,

Prakash Kumar

[Former Member]

Hi Prakash,

Thank you for the reply. I have made changes to my lockbox in reference to your link. The file is as below.

10000IDESTEST00IDESTEST130903124102

20000000000000000000000

5111001123456713090300IDESTEST00IDESTEST

611100200001000000830001080123456789100000002

411100360191800000001   00000000600000000000

711100411241021309030010000100000

8111005112410213090300010000100000

900000

I still get the "List Contains No data" Error. Do you have any further suggestions on this?

Once again Thank you for your help.

Regards

[Former Member]

Hi PBK,

Please see the below details and arrange the above Lockbox file :

1st Row : 100DestinationOriginDate (100STERDESTIN1234567140918)

2nd Row : 21GNOREDBYSAP0000000000

3rd Row : 58660011TimeDateDestinationOrigin (58660011000000140918STERDESTIN1234567)

4th Row : 686600200000Amount000Cutomer Master Record Bank DetailsCheck Number

               (686600200000500000110003900345205865100000126)

5th Row : 48660036019FI Customer Invoice Number(8Blank Space)000Amount00000000000000

               (486600360191000003040        00050000000000000000)

6th Row : 78660041TimeDate00100000Amount00 (786600410000001409180010000050000)

7th Row : 88660051TimeDate000100000Amount00 (8866005100000050000)

8th Row : 9000000

Please arrange in this format.

Hope this helps !!

Kindly let me know if you face any issue.

Regards,

Prakash

[Former Member]

Hi Prakash,

I tried to replicate as per the file sent by you as below. I still get the No data error.

10000IDESTEST00IDESTEST1409181024

20000000000000000000000

5111001123456714091800IDESTEST00IDESTEST

611100200001000000830001080123456789100000155

411100360191800000004        00001000000000000000

711100412345671409180010000100000

8111005123456714091800010000100000

900000

I am uploading the file on the IDES system and it would take 10 digits for Destination and Origin. Hence had to prefix Zeros. Otherwise the upload fails.

Other than that the file is identical to what you sent. Am i missing something here???

Let me know if you have any ideas/suggestions. Appreciate it!

Regards

Pooja (PBK)