Receipt Stock via DTW

[Former Member]

Hi All

I need to receipt stock in SAP B1..and these items have Bin Locations and they Have Batch Numbers.

We tried the stock posting but got some errors.

The best way would be to do a Good Receipt?

Please advise the templates to be used apart from the OIGN and IGN1 and BTNT.

Has anyone done this and could you please guide me.

Regards,

Jerusha

[Former Member · Accepted solution]

I have test with 1 line and still getting that error

Please see the below screenshot of my import files..Am i missing anything:

[vicky_williams · Accepted solution]

Perhaps in BTNT file it needs LineNum to be completed to match the LineNum in IGN1

So for your example above the "Batch_ONELINE" file would have 0 in LineNum column

I am not sure if this will be correct, but we needed to do this when using BTNT DTW files for warehouse transfers

Hope it might help you

Thanks

Vicky

[Former Member · Accepted solution]

Thank you Vicky.

I tried that now..and it still comes with that error...so im sure its the lines that are not linking

[vicky_williams · Accepted solution]

Oh, sorry it did not work, which version of SAP B1 are you using now?

I also noticed in my templates that we put in Quantity column in BTNT (but bins and batch numbers were handled in the same sheet - I am using V9)

[Former Member · Accepted solution]

Hi,

You need to enter Base Line number on Bin allocation file.

Regards,

Chintan

[Former Member · Accepted solution]

Hi Jerusha,

Linenum field of batch template shoudl have a value, try '0', rest looks fine, and it shoudl work.

Thanks,

Joseph

[Former Member]

Thank you All

all your replies helped me to get it.

the SerialAndBatchNumbersBaseLine field had to be zero for each line.

each item's batch has its own qty, batch and bin as well as cost... using valuation method by serial\batch..and therefore SerialAndBatchNumbersBaseLine has to be zero for each line.

thanks again.

Jerusha

[former_member191075]

Hi Jerusha

Before Add , One window Pop UP , Where You have to select Items Batch Number for Goods issue.

For Goods Receipt , Before Add , You have to give Batch no. and its description for that.

So for this  error "cannot add row without complete selection of batch/serial number" , You have to select Batch no.

For That 2 option

1. Auto select :-  It will Select Items and quantity automatically

2. Manual select :- For That Select Item in Uper most window then select batch and add quantity     then click on   ">"  this type of button .

I think you will get solution from it.

Regards

Amol

[kothandaraman_nagarajan]

Hi,

Please check this thread

Thanks & Regards,

Nagarajan

[Former Member]

Hi there...I tried in the same format but still getting an error now

cannot add row without complete selection of batch/serial number