magazinecrm / codered100

https://o7planning.org/en/10493/install-oracle-rest-data-services-ords-for-oracle-apex
1 stars 0 forks source link

agentcy subscription also needs to be checked #16

Open magazinecrm opened 6 years ago

magazinecrm commented 6 years ago

cash agency to sales according to abc

---+++------------

magazinecrm commented 6 years ago

another idea comission paid dr to cash cr

comission paid dr to bank account

when payment made comission paid account dr 500 to comission agent personal cr 500 or comissin payable account cr 500

magazinecrm commented 6 years ago

Thus, currently Accounting Entry from Sales Invoice would be normally be something like this:

Customer A/c Dr. 100 Sales A/c Cr. 100

Now you want to introduce Commission here but the Commission Amount should not change the Sales & Customer A/c postings. Insert two Condition Types in your Pricing Procedure as follows:

  1. Commission Payable (always Positive)
  2. Commission Expenses (always Negative)

Create required GL Accounts & maintain VKOA settings.

The rate of both the above Conditions would be Commission percentage say 10%.

Now your Invoice's Accounting Entry would be:

Customer A/c Dr. 100 Commission Expenses A/c Dr. 10 Sales A/c Cr. 100 Commission Payable A/c Cr. 10

Now, as Commission is an Sales Expense, it (Debit entry of Commission Expenses) would directly hit Profit & Loss A/c (like other Expenses of Rent, Interest etc...)

For the Credit Charge of Commission charge the End-User will have to manually pass an Accounting Entry which would be as such:

Commission Payable A/c Dr. 10 To Vendor A/c Cr. 10

The above entry would clear the Commission Payable A/c & create a liability of Rs. 10 in Vendor's account.

As Partner Function of Vendor is already present in Sales Order / Invoice, one can anytime create a Z-Report for Commission Payable to each Vendor over a period