Hi @Enyinnaya Gift,
I have still a doubt: how SMA manages the secomnd part of transfer? If the transfer is added to the purchease using the field “sma_whareuse_to” has receiver, how the inventory for sender (“sma_warehouse_from”) is trated? Where can I find the decrease?
Regards, Vittorio
- EGAnswered
Hi @Vittorio
See the
sma_purchase_itemstable as the main inventory table for the SMA system. It has aquantitycolumn, aquantity_balancecolumn, and reference ID columns for Purchases and Transfers columns, among other columns. All completed stock-In [purchases, positive-adjustment (addition), transfer IN/TO warehouse (product quantity-add-up)] get added up to the product quantity in here; the same goes for all your stock-Out (sales, transfer OUT/FROM (deduction), negative-adjustment (subtraction), they get deducted from the product quantity in here. Thequantitycolumn reflects the quantity of stock-in, while thequantity_balancecolumn reflects what is remaining.My name is @Enyinnaya Gift . I am an
Independent software developerwith in-depth knowledge of SMA system. I have done a lot of customization for many happy clients across the globe.You can check out highlights and a demo of my latest customization by Clicking HERE - Highlights
You can also reach me via any of the following mediums for a real-time discussion on your customization request:
-Skype ID:
enyinnayag-Wechat ID:genyinnaya-Email:[email protected]-WhatsApp:+2348068355192 - MSAnswered
Hello,
As @Enyinnaya Gift explained. The quantity is tracked using purcahse items table. The quantity file on products table is symbolic repersentation that get update from purcahse items’s quantity balance value.
Thank you
- Login to Reply