Max Documents for OutGoing Payment

[Former Member]

Hi

Can any one know what is max document select while posting OutGoing Payments

I want to post Cust Outgoing Payment (against 10,000 Credit Note) , does system allow?

Nilesh Shah

[Former Member · Accepted solution]

Hi Nilesh Shah,

10,000 records would be way too much for DTW to control.

It is not just for OutGoing Payment, almost any kinds of documents will have the same problem.

Based on others' experience, 2,000 records might already close to maximum. You may test it to see.

Thanks,

Gordon

[Former Member]

I have check with Latest verson of SAP B1 8.81 PL07 and have same problem

System is not supported 10,000lines in single document and as this is abnormal requirement, we have change our business transaction as system allow

[Former Member]

Gordon,

Normally, i was doing 2500line items in Incoming & Outgoing Payments

and that are works fine

but now have a requirement to post 10,000 line items in single payment?

I checked in max num in document setting, i update it to 999,999

but still have same error

Let me know if you have any other solution

Nilesh Shah

[Former Member]

If 2500 line items is fine, try 5000 line items. If that work, split the job in two.

[Former Member]

I tried to upload thru DTW in my TEST DB

initially, i tried with less no of documents and was uploaded

but when i select all my 10,000 documents, system takes time almost 1 hr

and finally, gives error#

Reason: 65172

do you have any idea for this reason?

Nilesh Shah

[jitin_chawla]

Hi,

The error seems to be related to DTW.

Check the forum thread for similar message. Other threads appearing are DTW only.

My recommendation would be to perform the outgoing payment for a few batches or documents at a time.

You can wait for other experts comments on this who have handled such scenario in their business process.

Kind Regards,

Jitin

SAP Business One Forum Team

[Former Member]

Thanks Jatin,

I am using SAP B1 8.8 PL15,

do you have any idea if any one face problem while posting big num of doc in Outgoing Payment?

Nilesh Shah

[jitin_chawla]

Hi,

Not that I have heard of, but always when trying to perform something which is exceptional from the routine business process like this where there are 10,000 documents involved, always better to check on the COPY of the database before performing on Live to be sure that everthing goes well.

If unsure, please check Notes available on SMP if any issue regarding such kind of payment is there.

Kind Regards,

Jitin

SAP Business One Forum Team

[jitin_chawla]

Hi,

You can define the number of documents to appear in the Payment window or you can have all the documents appearing in the outgoing payment for a specific BP.

I dont think there would be any problem in creating a Payment document for large number of documents but it would take time to complete the process.

But be sure that correct documents are included as you cannot have one or two document removed from the Payment or reconciliation which will happen on creation of payment. You have to cancel the complete payment.

Prepare a COPY of the database in Test Enviornment and give a try.

Kind Regards,

Jitin

SAP Business One Forum Team