09-27-2019, 09:27 AM,
|
|
ALEXSHEN
Senior Member
|
Posts: 132
Threads: 34
Joined: Sep 2019
|
|
Bulk Inventory Transfer
Hi Tim,
When I bulk transfer the goods, there was a problem.
Of course, I want to ask a question at first, if I want to transfer all the goods in one warehouse to another, is it only this "BULK INVENTORY TRANSFER" or is there still another script that can move the whole goods.
If only this "Bulk inventory transfer", then I have to explain my operation and problems.
1- in Bulk inventory transfer-dispatch, I uploaded CSV file (this file included all stocks and quantities)
2- I got the error, "The part code entered of XXXXX is not set up in the database...."
3- But there is still right information at the bottom of the page that is displayed in the data frame.
4- Then I click on "create transfer shipment" and get another error again.
So if want to move goods, how to do?
Alex
|
|
09-28-2019, 01:48 AM,
(This post was last modified: 09-28-2019, 01:54 AM by TimSchofield.)
|
|
TimSchofield
Tim Schofield
|
Posts: 1,318
Threads: 22
Joined: Mar 2015
|
|
RE: Bulk Inventory Transfer
Hi Alex, thanks for sending me the file. This is indeed an interesting one :-)
I set up parts on my test system for BKT-120 and MD-B-03W-B22-ST. I then removed the other lines on your file, leaving these two. As happened with you, both lines were rejected. I noticed that the file was encoded as UTF-8 (with BOM), BOM in this sense meaning 'byte order mark' - was the file saved by Excel at some point?. This puts some unseen characters at the start of the file. Removing the BOM and trying again, the first line worked, but the second (MD-B-03W-B22-ST) was still rejected.
Then I copied and pasted the stock code from my system into the file, and hey, it now accepts both lines.
So the problem seems to be with the encoding. Cut a long story short, there appears to be an additional non visible character at the start of each line which is confusing the script (it thinks this is part of the stock code). The easiest thing to do at this stage is to go back to the way you generated the csv file, and look at the encoding at that point. Do you only use ASCII characters in your stock codes? If so, then specify this encoding.
Tim
===========
Perhaps an easier way is to force the script to chop off the first character of the stock code, so line 51 of StockLocTransfer.php becomes
$StockID = mb_substr($myrow[$i], 1);
This seems to work, but it is a bit of a fudge and you would have to remember to redo this change whenever you upgrade.
|
|
09-28-2019, 09:15 PM,
|
|
ALEXSHEN
Senior Member
|
Posts: 132
Threads: 34
Joined: Sep 2019
|
|
RE: Bulk Inventory Transfer
(09-28-2019, 07:32 AM)falkoner Wrote: I have just tried it here with a batch controlled item and it worked fine.
Silly question but those batches do exist in the despatching location don't they?
Tim
Hi Tim,
Yes, there are batches in first Warehouse, so it's mean that if we have batches in the first Warehouse, we can't move or have other solutions?
Alex
|
|
|