Can we use "batch automatic selection" on DTW for A/R Invoices integration?

[Former Member]

We use DTW to import Sell invoices from another vending software into SAP B1. We use

OINV - Documents.xlt and INV1 - Document_Lines.xlt files. However we have created at SAP a new item managged by batch number.

The vending software doesn't manage this item by batch.

Is it possible to make an automatic batch selection during Invoice DTW integration? We simple don't mind wich batch will be selected.

I've looked into the file BTNT - BatchNumbers.xlt, but there isn't any column for "automatic selection".

[Former Member]

Hello Izeddin.

I've been informed by our SAP partner that automatic batch selection is native to SAP B1. It's not available through DTW.

I managed to overcome this issue by integrating the document on DTW as a Sales Order instead of A/R Invoice. Then on SAP I can add batchs automatically (around 100 per day!!!) when copying it to A/R Invoice.

Hope that fits your issue.

[Former Member]

I have the same question, Is it possible to create an automatic batch selection in the DTW, when uploading A/R invoices?