Notifications
Clear all

2322230 - How to import Stock Counting

1 Posts
1 Users
0 Likes
22 Views
admin
Posts: 336
Admin
Topic starter
(@admin)
Prominent Member
Joined: 2 years ago

Symptom

How to import Stock Counting via DTW (Data Transfer Workbench).

Import Stock Counting with Serial/Batch Numbers into SAP Business One via Data Transfer Workbench and you receive error: 

"Object reference not set to an instance of an object"

"Invalid data entity65171"

Cause

Consulting

Solution

Below are the key points for successfully importing Stock Counting with Serial/Batch Numbers into SAP Business One via DTW :

* In the INC1 - InventoryCountingLines.csvLineNumber field should be filled according to the number of Items in the file. It start from 1 [Ex : 1,2,3,.......so on].

* In the INC3 - InventoryCountingBatchNumbers.csv and INC3 - InventoryCountingSerialNumbers.csv,  BaseLineNumber corresponds to the LineNumber in INC1 - InventoryCountingLines.csv.

* In the INC3 - InventoryCountingBatchNumbers.csv and INC3 - InventoryCountingSerialNumbers.csvLineNum should be an increment starting from 0 for every BaseLineNumber in INC3 - InventoryCountingBatchNumbers.csv and INC3 - InventoryCountingSerialNumbers.csv.

* In SAP 9.1 or above, There are some additional columns [CounterType, CounterID, MultipleCounterRole] which need to be filled in the templates INC1 - InventoryCountingLines.csv, INC2 - InventoryCountingLineUoMs, INC3 - InventoryCountingBatchNumbers.csv and INC3 - InventoryCountingSerialNumbers.csv.

Reply
Share:
x  Powerful Protection for WordPress, from Shield Security
This Site Is Protected By
Shield Security