January 31, 2010 at 11:32 pm
Hi friends,
I am under development Inventory project of the firm. It has separate opening and closing balances for each year. How can I solve this problem using a single database for the tow different fincial years.
Kindly help me in this regard.
Thanking you
regards,
SUNDARA MURTHY S
February 1, 2010 at 3:04 am
More inputs needed.
February 1, 2010 at 6:52 am
Easiest way would be a calendar table holding each day in one column and the fiscal year information and other stuff you might need (e.g. work day yes/no, holidays) in separate columns.
For details please search this site for calendar table or have a look at the Tally table link in my signature.
February 1, 2010 at 7:07 am
Normally the best the way to handle date issues like this is with a calendar table. Something like:
Date, Calendar Year, Fiscal Year
You can always add things like Quarter and Period as well.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 5, 2010 at 3:56 am
I need to maintain opening balance and closing balance of inventory for each year and simillary opened Customer purchase Order and Job order should be posted to new year.
Inventory
For the year 2009-2010
Item 1
Date In_Qty Out_Qty Balance
O/B 100 100
01/04/2009 250 350
01/05/2009 050 400
01/06/2009 300 100
After Reconcile data Balance is reset to 50
For the year 2010-2011
Item 1
Date In_Qty Out_Qty Balance
O/B 50 050
01/05/2010 50 100
01/06/2010 50 150
Kindly help me in this regard.
Thanking you
regards,
SUNDARA MURTHY S
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply