Trying to create Stock Transfer from one Bin Location to another Using DTW SAP B1 9.0 PL05

[mark_skinner87]

Hello Everyone

I have already booked stock into Warehouse 91, say, (Goods Innwards) and into the default Bin Location  91-SYSTEM-BIN-LOCATION using Goods Receipt PO I am trying to use DTW to transfer stock from one bin location to another, say the default above to 0101A02.  I have prepared 4 templates, namely, OWTR (stock Transfer Header), WTR1 (Stock Transfer Item), OBTN (Batch Numbers) and WRT19 (Stock Transfer Lines Bin Allocations)...

I am getting error '1470000383 - Invalid 'SerialAndBatchNumbersBaseLine', specify a valid ....  To be quite honest I am very unsure of what needs to be populated in the Stock Transfers Lines Bin allocation Template so no surprise to me I am getting an error.  Can anyone help.  Has anyone tried to do what I am trying to do.  Any help will be gratefully received.

Regards

Keith

[former_member662620 · Accepted solution]

Hi,

Please specify SerialAndBatchNumbersBaseLine in WTR19 as the line num in SRNT file

[mark_skinner87 · Accepted solution]

Hello there whoever you are.  This was very helpful, although in my case I was using Batch Numbers and therefore rather than the DTW Template being SRNT it was BTNT.   The key was understanding that SerialAndBatchNumbersBaseLine was the same and therefore linked to the BTNT Template Line Number populated rather than from a SQL file in SAP B1.  What confused me was the BinAbs comes from the OBIN Master File SysNum.

Many thanks and regards

Keith

[mark_skinner87 · Accepted solution]

Thanks again

Taylor Shao

Regards

Keith

[former_member662620 · Accepted solution]

Hi,

BinAbs is from AbsEntry column in OBIN table

[former_member30660 · Accepted solution]

Hi Taylor,

I still have problem on this. I tried to import my DTW templates, still got the same error.  Could you please give a hand on this ?

StockTransfer

StockTransferLine

SerialNumber

StockTransferLinesBinAllocations

Please advise. Thanks

[former_member662620 · Accepted solution]

Hi,

If item is managed by batch, you should use BTNT template. From snapshot it seems you are using SRNT tempalte, which is used for serial

[former_member30660 · Accepted solution]

Hi Taylor,

Yes. I was trying Stock Transfer of Bin location with serial number in SAP B1 9.0 PL05.  Could you please help me with the templates? It is pretty straightforward. 

I got the same error message "'1470000383 - Invalid 'SerialAndBatchNumbersBaseLine', specify a valid .... "

Thanks.

[former_member662620 · Accepted solution]

Hi,

I attached the files I used for testing

OWTR - StockTransfer1.txt.zip

WTR19 - StockTransferLinesBinAllocations1.txt.zip

WTR1 - StockTransfer_Lines2.txt.zip

[former_member662620 · Accepted solution]

Last file

Please change txt to csv

SRNT - SerialNumbers1.txt.zip

[former_member30660 · Accepted solution]

Thanks for the samples.

I suceeded with 1 line in Stock Transfer.  When there are more than 1 lines in ST document, the error comes up. Sorry I didn't give you this detail.

Cheers,

[former_member662620 · Accepted solution]

Hi,

As I know, there are some bug fixing related to this issue, please upgrade to latest patch and have a try

[former_member30660 · Accepted solution]

Hi Taylor,

PL 05 is not the latest version?  I just checked download centre, there is no higher version available to download yet. 

Thanks.

Cheers,

Christina

[kothandaraman_nagarajan · Accepted solution]

Hi,

PL06 is latest patch for 9.0 version.

Thanks & Regards,

Nagarajan

[former_member186095 · Accepted solution]

Hi,

In the patch delivery schedule, in this week, sap should release SAP B1 9.0 PL07 but after I checked, the SAP B1 9.0 PL06 is the current latest patch of SAP B1 9.0.

So, you can wait for SAP B1 9.0 PL07 or you can download SAP B1 9.0 PL06 if it is very important to use it.

JM

[former_member30660 · Accepted solution]

Thanks for the reply. I have checked PL07 notes, it looks still not fixed yet.

[former_member30660 · Accepted solution]

Thanks for the reply, Naga.

[kothandaraman_nagarajan · Accepted solution]

Hi,

PL07 is latest for 9.0 version.

Thanks & Regards,

Nagarajan

[Former Member]

Hello,

the same problem here.

With only 2 line the migration is ok.

With more than 2 lines, the error message comes up.

I am on PL07.

Did you managed to solve this error?

Kind regards,

Otto

[Former Member]

Hi

I am having the same problem with PL08. Does anyone know of any hot fixes for this?

Best Regards  Martin

[Former Member]

Hi Keith,

Post sample DTW files to get help.

Thanks,

Gordon