Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nkpriya
Starting Member
34 Posts |
 Posted - 2009-11-16 : 12:57:07
|
| Hi,I am planning to design a database and am not sure how to start.I have a requirement like below:1)Every month, I will have MTD values for GL Accounts.2)Next Month, sometimes MTD values change for the previous months too, however, I need to show the previous MTD values in the previous month report and current MTD for previous month in the current month report.Ex: In the month of January, I will have some MTD values for GL Accounts and that has to reflect on January report.And In the month of February, there will be some changes for January values. But, I need to show original values in January month report and February YTD report has to show current values for February and changed ones for the month of January.Please help me in designing table.ThanksKrishna |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
nkpriya
Starting Member
34 Posts |
Posted - 2009-11-16 : 13:14:57
|
| No, I cannot. What I need to do is download data from SAP Business Objects each month to Excel and upload to SQL Server and then tweak it to produce the desired reports.ThanksKrishna |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
nkpriya
Starting Member
34 Posts |
Posted - 2009-11-16 : 13:48:35
|
| Here is the example of data:January data:GL Account Desc| CC No.|CCname|Division Name|Month|Transaction Desc.|Credit Amt|Debit Amt|Total AmtIn the final report again in excel(pivot report) - I should have filtered by Month:GL Account Desc|Total AmtThanksKrishna |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
|
|
Design table