4 weeks ago - last edited 4 weeks ago
Dear community,
I am trying to import an inventory posting in SAP B1 (HANA on-premise version 9.3) through the DTW (Data Transfer Workbench). So I am using 3 templates: inventory posting header, inventory posting lines, and inventory posting batches. But it's always a failure.
I'm receiving the following error: "1 Created Failed 1 Cannot add row without complete selection of batch/serial numbers65171 "
Note that when the initial quantities of item batches in the specified warehouse are all zero, the import is a success. But when there is a certain quantity for a batch, I receive the error. I also tried adding rows in the template for the batches with zero quantities in the warehouse; also same error.
Does anyone know how should I write my data?
I attached sample photos. Note that when I first manually set the item quantity in warehouse WH0002 to zero in SAP, the first example worked and it posted qty 10 for the batch '2027-12-31'. But if there is an existing qty, it's unsuccessful (with and without rows 2 and 3)
Hello!
If you do this manually in the UI and you have for example 10 quantity of a batch managed item and then you count it to zero you have to select all of the batches at a negative quantity to write out. In my example you would need -10 quantity of batches.
I see in your batch sheet that you have zero quantities for certain rows. Likely you would need to set those rows to the negative quantity (or perhaps positive?) in order for it to be complete. I always look at the UI for examples of how the data should look.
(I tried an example here where I counted out 185 quantity down to zero)
(SAP required me to select all of the batches it thought it had on hand even if I said zero were left because it doesn't know what was taken out or added even if we're removing everything)
You seem to have no problem for the positives because you have say +10 quantity and then +10 explained batch quantity so this makes sense.
If you have zero and then zero batch quantity I think you need to count zero and then account for the -10 batch values the same way you would doing it manually.
Let me know, I can do more testing but this is what came to me as I was looking at this question,
Mike
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Thank you for the reply. It was so helpful and solved my problem.
It seems the inventory posting doesn't accept the actual quantity of the item batch, but its variance (+ or -). So if I have an initial quantity of 10 for batch 1, I will have to input it as -2 if the counted quantity is 8. However the inventory count takes the actual quantity per batch as input.
Thank you so much 🙂
Hi Manal-SH,
Check SAP KBA 3415562.
It should give you a clue.
Kind regards,
ANKIT CHAUHAN
SAP Business One Support
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Thank you for your support.
I checked the note, and the inventory counting works fine in import. But what I need to import is an inventory posting directly (with the offset decrease and increase accounts). However, it is not working. Is there any solution?
Thanks again.
Regards,
Manal
In this example, let's say there is already an initial quantity of 20 in the warehouse WH0002, and I am posting these 3 templates where the total quantity after count is now 10 (and the 10 are for the batch '2027-12-31'), I will receive an error "Cannot add row without complete selection of batch/serial numbers65171"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
9 | |
7 | |
5 | |
4 | |
3 | |
2 | |
2 | |
2 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.