Hello
I am connect the SQL Server.
I managed to create the Double Entry on the BO.General_Ledger
Now, I have done this query on the SQL Server:
SELECT dbo.BASTESTDOMAINADMIN_GENERAL_LEDGER.MyHeaderID, dbo.BASTESTDOMAINADMIN_GENERAL_LEDGER.Date,
dbo.BASTESTDOMAINADMIN_GENERAL_LEDGER.Type, dbo.BASTESTDOMAINADMIN_GENERAL_LEDGER.DocumentNo,
dbo.BASTESTDOMAINADMIN_ACCOUNT.AccountCode, dbo.BASTESTDOMAINADMIN_ACCOUNT.AccountName,
dbo.BASTESTDOMAINADMIN_PARTY.Code AS PartyCode, dbo.BASTESTDOMAINADMIN_PARTY.Name AS PartyName,
dbo.BASTESTDOMAINADMIN_CURRENCY.CurrencyCode, dbo.BASTESTDOMAINADMIN_CURRENCY.CurrencyDescription,
dbo.BASTESTDOMAINADMIN_GENERAL_LEDGER.CurrencyRate, SUM(dbo.BASTESTDOMAINADMIN_GENERAL_LEDGER.TrxAmount) AS TrxAmount,
SUM(dbo.BASTESTDOMAINADMIN_GENERAL_LEDGER.TrxDebitAmount) AS TrxDebitAmount, SUM(dbo.BASTESTDOMAINADMIN_GENERAL_LEDGER.TrxCreditAmount)
AS TrxCreditAmount, SUM(dbo.BASTESTDOMAINADMIN_GENERAL_LEDGER.BaseAmount) AS BaseAmount,
SUM(dbo.BASTESTDOMAINADMIN_GENERAL_LEDGER.BaseDebitAmount) AS BaseDebitAmount,
SUM(dbo.BASTESTDOMAINADMIN_GENERAL_LEDGER.BaseCreditAmount) AS BaseCreditAmount
FROM dbo.BASTESTDOMAINADMIN_GENERAL_LEDGER INNER JOIN
dbo.BASTESTDOMAINADMIN_CURRENCY ON
dbo.BASTESTDOMAINADMIN_GENERAL_LEDGER.MyCurrencyID_RID = dbo.BASTESTDOMAINADMIN_CURRENCY.ID INNER JOIN
dbo.BASTESTDOMAINADMIN_PARTY ON dbo.BASTESTDOMAINADMIN_GENERAL_LEDGER.MyPartyID_RID = dbo.BASTESTDOMAINADMIN_PARTY.ID INNER JOIN
dbo.BASTESTDOMAINADMIN_ACCOUNT ON dbo.BASTESTDOMAINADMIN_GENERAL_LEDGER.MyAccountID_RID = dbo.BASTESTDOMAINADMIN_ACCOUNT.ID
GROUP BY dbo.BASTESTDOMAINADMIN_GENERAL_LEDGER.MyHeaderID, dbo.BASTESTDOMAINADMIN_GENERAL_LEDGER.Date,
dbo.BASTESTDOMAINADMIN_GENERAL_LEDGER.Type, dbo.BASTESTDOMAINADMIN_GENERAL_LEDGER.DocumentNo,
dbo.BASTESTDOMAINADMIN_ACCOUNT.AccountCode, dbo.BASTESTDOMAINADMIN_ACCOUNT.AccountName, dbo.BASTESTDOMAINADMIN_PARTY.Code,
dbo.BASTESTDOMAINADMIN_PARTY.Name, dbo.BASTESTDOMAINADMIN_CURRENCY.CurrencyCode, dbo.BASTESTDOMAINADMIN_CURRENCY.CurrencyDescription,
dbo.BASTESTDOMAINADMIN_GENERAL_LEDGER.CurrencyRate
The result is the want i want from the SQL View. It has 4 Rows of records.
Now I create a BO called .. View_Ledger and Selefct Database: existing External and managed to call the View_Ledger from the SQL View.
After that AwareIM prompt me to select the Primary Key. I did not select anyone as I dnt need to edit the Table at all.
Now I create a Queries.. and view. It showed only 1 Row of the Record only.... but the page show 1 - 1 of 4. The Next button also disable.
Why?
Please help...
