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