Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 12-16-2015, 11:35 AM   #1
hassanlabban
Newly Registered User
 
Join Date: Oct 2014
Posts: 23
Thanks: 0
Thanked 0 Times in 0 Posts
hassanlabban is on a distinguished road
shareholders distribution

Hi All
i have a database which i can track sales and purchases, and ultimately i can track expenses and revenues. i am trying to create something in the DB to have it give me the dividends which should be given to the shareholders in every quarter. i am a bit out of ideas on how to extract the data from the expenses part and the revenues part to create a link between them and be able to find the net profits.
here is the setup of my DB:
1- one table having expenses with dates and items purchased with unit cost and quantity and i can get the total expenses
2- another table having sold items with quantities and unit price and i can get from it the total revenue
3- i have a third table which has all the items lists of the things which are bought and sold as lists only, without cost and price

any body would be able to guide or suggest a way to get an accurate dividends data from the above or anything additional is required?

thanks all

hassanlabban is offline   Reply With Quote
Old 12-16-2015, 01:05 PM   #2
plog
AWF VIP
 
Join Date: May 2011
Posts: 9,347
Thanks: 10
Thanked 2,270 Times in 2,222 Posts
plog is a jewel in the rough plog is a jewel in the rough plog is a jewel in the rough
Re: shareholders distribution

Expenses and revenue should go in the same table. Think of it as a checkbook--you write checks, you go to the ATM, you have automatic bills paid (all expenses/debits) and you also log deposits and interests (revenue/credits) all in the same register--you don't keep 1 for debits and 1 for credits. That way you add the credits and subtract the debits and you have your balance.

Same principle applies to revenues/expenses--they should be in the same table.
plog is offline   Reply With Quote
Old 12-16-2015, 11:19 PM   #3
hassanlabban
Newly Registered User
 
Join Date: Oct 2014
Posts: 23
Thanks: 0
Thanked 0 Times in 0 Posts
hassanlabban is on a distinguished road
Re: shareholders distribution

Hi plog
thanks for your reply.
so with what you are saying i need to redo my revenues and expenses to be in the same table which will cause some major work to my DB keeping in mind that i have a WMS and purchasing and CRM modules in it and this might affect of these modules in a way or another. isnt there a way to keep it in the current setup and create some kind of a link?
moreover, i think with the new setup i will need to have the purchase orders table to the same table of the expenses and the revenues to have a consistent setup of a DB. is that correct or am missing anything somewhere?

thanks
Hassan

hassanlabban is offline   Reply With Quote
Old 12-17-2015, 03:56 AM   #4
gemma-the-husky
Super Moderator
 
gemma-the-husky's Avatar
 
Join Date: Sep 2006
Location: UK
Posts: 13,769
Thanks: 55
Thanked 1,022 Times in 988 Posts
gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all
Re: shareholders distribution

you are actually reinventing a "general ledger" or "nominal ledger", as part of a double entry bookkeeping system.

you just need suitable accounts for the dividends.

profit/expense account for "dividends" and balance sheet account for "dividends payable"

you need to have a reasonable understanding of double entry, though.
__________________
Dave (Male!)
Gemma was my dog

if a poster helps you, please click the scales at the bottom left of this posting, or use the thanks button alongside.
gemma-the-husky is offline   Reply With Quote
Old 12-17-2015, 05:39 AM   #5
plog
AWF VIP
 
Join Date: May 2011
Posts: 9,347
Thanks: 10
Thanked 2,270 Times in 2,222 Posts
plog is a jewel in the rough plog is a jewel in the rough plog is a jewel in the rough
Re: shareholders distribution

Quote:
keeping in mind that i have a WMS and purchasing and CRM modules
I have no idea what you are talking about, so I can't even get it into my mind to keep.

If you can post your table structure I can pose suggestions as to how to structure your data.

plog is offline   Reply With Quote
Reply

Tags
queries , reports

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Distribution Process Learn2010 Forms 8 05-21-2012 11:05 AM
Distribution claddagh General 0 07-13-2005 04:02 AM
Distribution Database.. doran_doran Forms 0 01-04-2005 10:28 AM
Distribution of the database StefanSch General 0 02-20-2003 12:04 AM
[SOLVED] Distribution turtle General 1 09-24-2002 01:37 PM




All times are GMT -8. The time now is 07:58 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World