# Automatic add the stock and update the supplier account

**URL:** <https://forum.sambapos.com/t/automatic-add-the-stock-and-update-the-supplier-account/15404>\
**Category:** V5 Question\
**Created:** [July 19, 2017, 12:24pm UTC](https://forum.sambapos.com/t/automatic-add-the-stock-and-update-the-supplier-account/15404 "2017-07-19T12:24:29Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![yohan](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/y/e99b99/32.png) [@yohan](https://forum.sambapos.com/u/yohan)\
**Post date:** [July 19, 2017, 12:24pm UTC](https://forum.sambapos.com/t/automatic-add-the-stock-and-update-the-supplier-account/15404/1 "2017-07-19T12:24:29Z")

</div>

> Blockquote

Expenses and Payouts Method K: Supplier & Utility Payouts

> Blockquote

Can We add payment when purchase to track how much pay and how much we want to debit?

> Blockquote

Adding suppliers list when do purchase transaction

I have read through various tutorials on sambapos forum,i have not been able to find a tutorial clearly indicating how i am supposed to link up my suppliers,accounts ,warehouse,entity and inventory.  
I want a situation whereby if i purchase from from customer X goods valued Y ,the system will automatically update my inventory the purchase transaction while as also update the accounts that i owe customer x goods worth value Y on his accounts.  
I don’t know how this is achieved by sambapos i am unable to relate how its supposed to workout.  
I will appreciate your help

---

<div class="post-metadata">

**Author:** ![Juan\_David\_Mesa\_Vela](https://forum.sambapos.com/user_avatar/forum.sambapos.com/juan_david_mesa_vela/32/37230_2.png) [@Juan\_David\_Mesa\_Vela](https://forum.sambapos.com/u/Juan_David_Mesa_Vela)\
**Post date:** [July 21, 2017, 10:58pm UTC](https://forum.sambapos.com/t/automatic-add-the-stock-and-update-the-supplier-account/15404/2 "2017-07-21T22:58:21Z")

</div>

> [@yohan](#):
>
> Blockquote

im also having that problem ☹

---

<div class="post-metadata">

**Author:** ![QMcKay](https://forum.sambapos.com/user_avatar/forum.sambapos.com/qmckay/32/27925_2.png) [@QMcKay](https://forum.sambapos.com/u/QMcKay)\
**Post date:** [July 22, 2017, 12:15pm UTC](https://forum.sambapos.com/t/automatic-add-the-stock-and-update-the-supplier-account/15404/3 "2017-07-22T12:15:07Z")

</div>

> [@yohan](#):
>
> Can We add payment when purchase to track how much pay and how much we want to debit?

Not currently. The Warehouses Screen does not allow for Partial Payment of an Invoice. You must pay the Entire Invoice.

> [@yohan](#):
>
> i have not been able to find a tutorial clearly indicating how i am supposed to link up my suppliers,accounts ,warehouse,entity and inventory.

Odd, there should be a few, or at least one that shows this. I will try to locate one or show in my next post a clear method for doing this.

> [@yohan](#):
>
> if i purchase from from customer X goods valued Y ,the system will automatically update my inventory the purchase transaction while as also update the accounts that i owe customer x goods worth value Y on his accounts.

This is done automatically when you have things set up properly. But again, there is no means of doing partial payment, with the rest of the Invoice to be paid later, when you use the Warehouses Screen.

The [PHP Inventory](https://forum.sambapos.com/t/inv-1-5-inventory-purchase-and-control-via-php/2686) System that I built can probably handle this though, because it “reverses” the flow, and does not force you to Pay at all, and you can do partial payments from different source accounts, even with different currencies.

---

<div class="post-metadata">

**Author:** ![mukopaje](https://forum.sambapos.com/user_avatar/forum.sambapos.com/mukopaje/32/34315_2.png) [@mukopaje](https://forum.sambapos.com/u/mukopaje)\
**Post date:** [July 22, 2017, 4:42pm UTC](https://forum.sambapos.com/t/automatic-add-the-stock-and-update-the-supplier-account/15404/4 "2017-07-22T16:42:41Z")

</div>

Not sure exactly what you looking for here, Does my flow make any sense to what you are looking for? So i have Entity for suppliers which are linked to their specific accounts under supplier account type, Supplier account has 2 transaction one debits supplier account when i receive stock from supplier and the other does the opposite when i make a payment on a suppliers account.

My supplier accounts screen before Sprite is purchase

 ![](https://forum.sambapos.com/uploads/default/original/3X/6/e/6e9fd722e683c43341bab63c6d988875c1bc306e.png)

Then lets go to the warehouse and purchase some items from a supplier

 ![](https://forum.sambapos.com/uploads/default/original/3X/8/b/8bd51e39f68620764c587a2c26e2e6b591126a21.png)  
Here i just got 50 bottles of sprite and 20 bottles of fanta from a supplier called ELSE ENTERPRISE at 3.5 each bottle, and we expect 175 + 70 to be debited from supplier ELSE ENTERPRISE account  
 ![](https://forum.sambapos.com/uploads/default/original/3X/5/2/52dc6dfe7f922b9134888a5234b8ec3e2b7be8ec.png)

Back in accounts there is our transaction with ELSE ENTERPRISE. Here we can make a part payment if we wanted to this supplier  
 ![](https://forum.sambapos.com/uploads/default/original/3X/e/f/efec3d73a43f84f8e871fcddb33e1d675f0fb0ec.png)  
And ELSE ENTERPRISE account will end up like this

 ![](https://forum.sambapos.com/uploads/default/original/3X/5/2/52fe84930e29ce4eb10ee26a318a0ac86dbb9a78.png)

As i said i am not sure if you looking for something in these lines or its something different all together

---

<div class="post-metadata">

**Author:** ![QMcKay](https://forum.sambapos.com/user_avatar/forum.sambapos.com/qmckay/32/27925_2.png) [@QMcKay](https://forum.sambapos.com/u/QMcKay)\
**Post date:** [July 22, 2017, 6:22pm UTC](https://forum.sambapos.com/t/automatic-add-the-stock-and-update-the-supplier-account/15404/5 "2017-07-22T18:22:39Z")

</div>

Good method. And yes in that flow you can make partial payments to a Supplier Account.

I guess what I was really referring to when I said we could not make partial payments, was in the Warehouse Screen.

Your method of Supplier Account payments is perfect.

---

<div class="post-metadata">

**Author:** ![mukopaje](https://forum.sambapos.com/user_avatar/forum.sambapos.com/mukopaje/32/34315_2.png) [@mukopaje](https://forum.sambapos.com/u/mukopaje)\
**Post date:** [July 22, 2017, 7:14pm UTC](https://forum.sambapos.com/t/automatic-add-the-stock-and-update-the-supplier-account/15404/6 "2017-07-22T19:14:12Z")

</div>

Credit goes to you @QMcKay for you great tutorials, if any one is wondering how to setup those supplier accounts, they are from this man @QMcKay [SambaPOS Accounting](https://forum.sambapos.com/t/sambapos-accounting/8360/11), This software has no limits and its because of the great people in this community. Thanks Emre QMcKay Kendash and everyone out there contributing to this forum, if you dint know you are empowering most of us the entrepreneurs who intern are creating employment for many others.

---

<div class="post-metadata">

**Author:** ![Juan\_David\_Mesa\_Vela](https://forum.sambapos.com/user_avatar/forum.sambapos.com/juan_david_mesa_vela/32/37230_2.png) [@Juan\_David\_Mesa\_Vela](https://forum.sambapos.com/u/Juan_David_Mesa_Vela)\
**Post date:** [July 31, 2017, 2:54pm UTC](https://forum.sambapos.com/t/automatic-add-the-stock-and-update-the-supplier-account/15404/7 "2017-07-31T14:54:46Z")

</div>

[https://forum.sambapos.com/uploads/default/original/3X/5/2/52dc6dfe7f922b9134888a5234b8ec3e2b7be8ec.png](https://forum.sambapos.com/uploads/default/original/3X/5/2/52dc6dfe7f922b9134888a5234b8ec3e2b7be8ec.png)  
i cant make this to happen, when i purchase items from a supplier i cant make that transaction to be reflected in accounts, please explain me how to.

---

<div class="post-metadata">

**Author:** ![mukopaje](https://forum.sambapos.com/user_avatar/forum.sambapos.com/mukopaje/32/34315_2.png) [@mukopaje](https://forum.sambapos.com/u/mukopaje)\
**Post date:** [July 31, 2017, 7:51pm UTC](https://forum.sambapos.com/t/automatic-add-the-stock-and-update-the-supplier-account/15404/8 "2017-07-31T19:51:32Z")

</div>

Hi after you setup your accounts as in QMcKay tutorial here [SambaPOS Accounting](https://forum.sambapos.com/t/sambapos-accounting/8360/112) you can then follow how i connected the inventory to accounts

Firstly create supplier entities, as entities can be anything,  
My Entity Type  
 ![](https://forum.sambapos.com/uploads/default/original/3X/e/a/ea5398a4c44c5f6973c98d94d3f1af497cfe7d1f.png)

For custom fields add as you would like, i added Phone filed and Address field, under Accounting select Account type as the supplier account type you in @QMcKay’s tutorial i referred you too.  
 ![](https://forum.sambapos.com/uploads/default/original/3X/e/8/e8b8430c3836ed9395b2e30176edbd0afa2320e4.png)

Under Entities add you entities, these will be your suppliers, add as many suppliers as you like, and these will be tied to corresponding actual accounts that you created under other tutorial  
 ![](https://forum.sambapos.com/uploads/default/original/3X/2/6/26f62aab40327371657875b8b60df2e3f2e0b8c7.png)

If we go back a notch under accounts in QMcKay tutorial you can create these supplier accounts that will align as options under account drop down above, You can see my accounts under Accounts

 ![](https://forum.sambapos.com/uploads/default/original/3X/4/7/47042089d7a868392d324c76b894e12c01c35217.png) 

Create a transaction type that triggers when you purchase stock in inventory with the equivalent of the purchase transaction. This transaction type must debit the supplier account and credit which ever account you deem fit according to you business setup. in my case

![](https://forum.sambapos.com/uploads/default/original/3X/9/e/9e2e2bf5bc83e8c9510bd401b4337e2fa526374b.png)

Then i edit my purchase transaction document type under inventory to link it to the right entity type and account transaction type, this will also mean every time i use my purchase transaction in inventory i will have the suppliers entities to my disposal which are linked to there respective accounts.

![](https://forum.sambapos.com/uploads/default/original/3X/8/4/847e090de9a12d521a3e4f668323ee3bcb4569c4.png)

At this moment your purchase under inventory must force you to select supplier otherwise they will not save

 ![](https://forum.sambapos.com/uploads/default/original/3X/4/b/4be8f76bc8a32053671495235eb161cada14b565.png)

Let me know where you are not clear i will be glad to help further.

---

<div class="post-metadata">

**Author:** ![muthoga](https://forum.sambapos.com/user_avatar/forum.sambapos.com/muthoga/32/18954_2.png) [@muthoga](https://forum.sambapos.com/u/muthoga)\
**Post date:** [August 1, 2017, 3:30pm UTC](https://forum.sambapos.com/t/automatic-add-the-stock-and-update-the-supplier-account/15404/9 "2017-08-01T15:30:13Z")

</div>

Thankyou all,this is a great tutorial,i will set up my inventory the same and if i will have isues you will kindly assist

---

<div class="post-metadata">

**Author:** ![Waqar\_azeem](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/w/e8c25b/32.png) [@Waqar\_azeem](https://forum.sambapos.com/u/Waqar_azeem)\
**Post date:** [October 10, 2019, 12:59pm UTC](https://forum.sambapos.com/t/automatic-add-the-stock-and-update-the-supplier-account/15404/10 "2019-10-10T12:59:24Z")

</div>

hello i cant seem to be able to link suppliers account and accounts payable can u giuide me on how to do that  
whenever i make a transaction im not able to complete it for some reason its un clickable

---

<div class="post-metadata">

**Author:** ![Posflow](https://forum.sambapos.com/user_avatar/forum.sambapos.com/posflow/32/63001_2.png) [@Posflow](https://forum.sambapos.com/u/Posflow)\
**Post date:** [October 11, 2019, 4:54am UTC](https://forum.sambapos.com/t/automatic-add-the-stock-and-update-the-supplier-account/15404/11 "2019-10-11T04:54:10Z")

</div>

Show us what you made so far

---

<div class="post-metadata">

**Author:** ![sangeethrayaroth](https://forum.sambapos.com/user_avatar/forum.sambapos.com/sangeethrayaroth/32/40422_2.png) [@sangeethrayaroth](https://forum.sambapos.com/u/sangeethrayaroth)\
**Post date:** [January 4, 2020, 11:39am UTC](https://forum.sambapos.com/t/automatic-add-the-stock-and-update-the-supplier-account/15404/12 "2020-01-04T11:39:50Z")

</div>

Hi Brother,  
When i tried to make partial payment, it is reflecting on the credit side.

 ![Screenshot (141)](https://forum.sambapos.com/uploads/default/original/3X/a/5/a52b92ad8bb087b170beeeb7bd9a1542474d177d.png)

---

<div class="post-metadata">

**Author:** ![mukopaje](https://forum.sambapos.com/user_avatar/forum.sambapos.com/mukopaje/32/34315_2.png) [@mukopaje](https://forum.sambapos.com/u/mukopaje)\
**Post date:** [January 4, 2020, 2:36pm UTC](https://forum.sambapos.com/t/automatic-add-the-stock-and-update-the-supplier-account/15404/13 "2020-01-04T14:36:26Z")

</div>

I just went through the tutorial and it debited the right column, Please show us you transaction type under accounts responsible for that

 ![image](https://forum.sambapos.com/uploads/default/original/3X/d/b/db76e3959e3e0bbf9516fdc41b4e777d4d57f402.png)

---

<div class="post-metadata">

**Author:** ![sangeethrayaroth](https://forum.sambapos.com/user_avatar/forum.sambapos.com/sangeethrayaroth/32/40422_2.png) [@sangeethrayaroth](https://forum.sambapos.com/u/sangeethrayaroth)\
**Post date:** [January 8, 2020, 3:58pm UTC](https://forum.sambapos.com/t/automatic-add-the-stock-and-update-the-supplier-account/15404/14 "2020-01-08T15:58:04Z")

</div>

Sorry for the late reply brother. Was out of state for 3 days.  
Let me check it one more time.
