how to make sure that is what is showing on the report is summed

See more:

SQL-Server-2005

SQL-Server

, +

hi house, pls i need help with this problem. thank in advance


Question about sql database and crystal report summation

Database showing credit sale of 7,000 goes to account receivable (Dr) and sales (Cr)

GLCODE PURCODE RCTAMT PMTAMT
811001 632004 7000 0
632004 811001 0 7000

The report as it appear on crystal report

ACCOUNT DEBIT CREDIT
Account receivable 7000
Sales 7000

Database showing credit sale of 7,000 goes to account receivable (Dr) and sales (Cr)
Database showing credit purchase of 9,900 goes to account payable (Cr) and purchase (Dr)

GLCODE PURCODE RCTAMT PMTAMT
811001 632004 7000 0
632004 811001 0 7000
711005 711001 9900 0
711001 711005 0 9900
Total 16,900 16,900

The report as it appear on crystal report with summation still correct (Grand total)

ACCOUNT DEBIT CREDIT
Account receivable 7000
Account payable 9900
Purchase 9900
Sales 7000
Total 16,900 16,900

Database showing credit sale of 7,000 goes to account receivable (Dr) and sales (Cr)
Database showing credit purchase of 9,900 goes to account payable (Cr) and purchase (Dr)
Database receipt for sales of 7.000
GLCODE PURCODE RCTAMT PMTAMT
811001 632004 7000 0
632004 811001 0 7000
711005 711001 9900 0
711001 711005 0 9900
632004 631001 7000 0
631001 632004 0 7000
Total 23,900 123,900


The report as it appear on crystal report with receipt going into cash account
Now the total is not reflecting what is in the report which is 16,900

ACCOUNT DEBIT CREDIT
Account receivable 0
Account payable 9900
Cash account 7000 0
Purchase 9900
Sales 7000
total 23,900 23,900


Database showing credit sale of 7,000 goes to account receivable (Dr) and sales (Cr)
Database showing credit purchase of 9,900 goes to account payable (Cr) and purchase (Dr)
Database showing receipt for sales of 7.000
Database showing payment of 9,900
GLCODE PURCODE RCTAMT PMTAMT
811001 632004 7000 0
632004 811001 0 7000
711005 711001 9900 0
711001 711005 0 9900
632004 631001 7000 0
631001 632004 0 7000
711005 711001 0 9900
711001 711005 9900 0
Total 33,800 33,800


The report as it appear on crystal report with payment taken from cash account now giving debit of 2,900
Now the total is not reflecting what is in the report which is 9,900 instead it is showing 33,000

ACCOUNT DEBIT CREDIT
Account receivable 0
Account payable 0
Cash account 0 2.900
Purchase 9900
Sales 7000

Total 33,800 33,800


Now my problem is how to make sure that is what is showing on the report is summed

PLS NOTE
632004 = ACCOUNT RECIEVABLE
711005 = ACCOUNT PAYABLE
631001 = CASH ACCOUNT
711001 = PURCHASES
811001 = SALES