[Feature] Customer and Supplier as one Party [Bounty]

[ai-erp]

In the real world of retail/wholesale business, most likely, some customers are also our suppliers. In this case, we are making invoices and bills for the same party… That is why is better to have just so called Party with the option to make it customer and supplier.

In this case, for reconciliation purposes, supplier and customer Statement will be merged for the purpose of getting net of the actual payable or receivable for reconciliation as same in Odoo… But for reporting purposes, if invoices and bills are not yet paid, it still should be shown as separate accounts in the financial statements as payable(in liabilities section) and receivables (in asset section)…

In getting the statement showing both balances of receivables and payables, there should be a button which can be used to offset amount with invoices and bill in case the party would want to pay only for the net outstanding balance for all invoices and bills. When clicking the button, it should automatically go to a journal entry wherein invoices and bills can be allocated to each other in order to allocate amounts which should take effect the offsetting of amounts to apply the receivables to payables and vice versa...

[vishwajeet]

I have added bounty https://www.bountysource.com/issues/41121617-feature-suggestion-customer-and-supplier-as-one-party

[vishwajeet]

We have business model where we raise bills to our supplier and in some cases they raise bills to us.
I don't want to create two entries one for customer and other for supplier as in that case reconciliation would be pain.

Say I raise a vendor a bill of 10k and he raise me a bill 10k so ideally net outstanding should be zero but if we have two entries than it will not be the case and would require manual reconciliation and creation of the statement.

Just for your information Odoo does this already, may be a food for thought for ERPNext team to introduce concept of party and allow a party to have customer as well supplier types.

Refer the forum discussion here https://discuss.erpnext.com/t/ability-to-use-supplier-as-customer/19336

[me2ne]

I pay already 100$ in bounty , from attached picture may be developer can get more idea .

[me2ne]

Thanks @ai-erp and @vishwajeet . if some one have any suggestion or experience what need it for this feature .please share here ,

[yashodhank]

Place Bounty here >

[vishwajeet]

@rmehta As per you what should be the target of the bounty ?

[rmehta]

Lets finalize the design first. Anyone want to make a UI mockup?

[me2ne]

I'm Not technical , is it help if i make some thing is paint of excel how should show statement ?

[vladucoju]

This could be some example.

1. Create new Subject (customer, supplier, warehouse...)
2. Populate general fields.
3. On the left menu check what are you opening
4. You could select both (supplier and customer)
5. Option to open warehouse is to check warehouse and when you click on the name on the right side will be mask for warehouse settings.

That is some short explanation.
This is much easier for user because he will have small scope of viewing.