PV
Asked
Hello support,
I have faced a problem, while before I might not noticed.
I have transfer banch of items from my WH2 (warehouse Block) to WH1(showroom) -->> we can see list of items in the transfer module but when we go to item >> Detail page >> transfer ( we did not see any record there).
I have just seen this because I tried to correct my stock many times but not correct then I tried to look for each individual module then I saw this error it gives me a blind spot.
so please see my attached screenshot for reference.
Please help.
I have faced a problem, while before I might not noticed.
I have transfer banch of items from my WH2 (warehouse Block) to WH1(showroom) -->> we can see list of items in the transfer module but when we go to item >> Detail page >> transfer ( we did not see any record there).
I have just seen this because I tried to correct my stock many times but not correct then I tried to look for each individual module then I saw this error it gives me a blind spot.
so please see my attached screenshot for reference.
Please help.
- MSAnsweredHello,
I checked it locally, it is displying the transfer. It might be due to volumn or some relational data. May I know your version number?
Please let me know the site link with owner account details in private reply.
Thank you - MSAnsweredHello,
Please edit `app/controllers/admin/Reports.php` and change the line no 2533 & 2534 from
```
->from('transfer_items')
->join('transfers', 'transfer_items.transfer_id=transfers.id', 'left')
```
to
```php
->from('transfers')
->join('transfer_items', 'transfer_items.transfer_id=transfers.id', 'left')
```
This should resolve the listing issue.
Thank you - PVAnsweredGreat,
Thank you very much - SKAnsweredI got exactly the same problem on version 3.4.53. I redownload the project source code from codecanyon and I do a fresh install (both database and code) but it still have problem.
- SKAnswered**[Prom Vongchann](/u/prom.vongchann)** Please share your solutions
- MSAnswered**[Seng Kruy](/u/seng.kruy)** Please try the solution in [this reply](/support/question/transfer-report-in-product-detail-page?page=1#answer_11143). Thank
- PVAnswered**[Seng Kruy](/u/seng.kruy)** Hello bong,
I got it work by modify the query in
app/controllers/admin/Reports.php
you can follow the guide above. - PVAnswered**[Mian Saleem](/u/saleem)** it seems to me like the data loading is quite slower than before after I update the query on the Transfer in product detail.
would you have any suggestion?
Thank you - MSAnsweredHello,
I am not sure. Please let me know your server details in private reply, I will check.
Thank you - PVAnswered**[Mian Saleem](/u/saleem)** I used Hostinger SSD cloud and it was working OK before I update the query. but seems like the query changed the website perfomance.
- Login to Reply