Database Field For Transfer Products

0

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

Question Resolved For: Stock Manager Advance with All Modules 0 Votes 2 Answers 476 Views
Asked by Vittorio 11 months ago

0

Answered by Enyinnaya Gift 11 months ago

Hi @Vittorio

See the sma_purchase_items table as the main inventory table for the SMA system. It has a quantity column, a quantity_balance column, 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.
The quantity column reflects the quantity of stock-in, while the quantity_balance column reflects what is remaining.

My name is @Enyinnaya Gift . I am an Independent software developer with 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

0

Answered by Mian Saleem 11 months ago

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

We use Cookies

We use cookies to ensure that we give you the best experience on our website. By continuing to browse the site you are agreeing to our use of cookies.