Question: Transfers Not Recorded In Sma_Transfer_Items

Transfers Not Recorded In Sma_Transfer_Items

Hello, In product details, Transfers tab is empty. also sma_transfer_items table has no entries although there are many transfers done already and recorded in sma_transfers I also foun

AA

A Abdul Azim

Asked
Hello,

In product details, Transfers tab is empty. also sma_transfer_items table has no entries although there are many transfers done already and recorded in sma_transfers

I also found out that transfers are recorded in sma_purchase_items table

Any idea why? I usually record purchases to main warehouse first then transfer to the shop with status of the transfer set to "Completed" when created.

Thanks
  • AA

    A Abdul Azim

    Answered
    Found the fix

    in app\controllers\admin\reports.php around line 2573

    Change

    ->from('transfer_items')
    ->join('transfers', 'transfer_items.transfer_id=transfers.id', 'left')

    To

    ->from('transfers')
    ->join('transfer_items', 'transfer_items.transfer_id=transfers.id', 'left')


    Already fixed in version 3.50
  • MS

    Mian Saleem

    Answered
    I am glad that you have fixed it and thank you for updating
  • Login to Reply