Hi James,
If this view doesn't exist, try to run this script in the SQL Query
Analyzer:
---
setuser N'sa'
GO
CREATE VIEW LEDGERBALANCESDIM AS SELECT SUM(A.DEBITMST) AS
DEBITMST,SUM(A.CREDITMST) AS CREDITMST,SUM(A.DEBITOPRMST) AS
DEBITOPRMST,SUM(A.CREDITOPRMST) AS CREDITOPRMST,SUM(A.DEBITTAXMST) AS
DEBITTAXMST,SUM(A.CREDITTAXMST) AS CREDITTAXMST,SUM(A.DEBITMSTSECOND) AS
DEBITMSTSECOND,SUM(A.CREDITMSTSECOND) AS
CREDITMSTSECOND,SUM(A.DEBITOPRMSTSECOND) AS
DEBITOPRMSTSECOND,SUM(A.CREDITOPRMSTSECOND) AS
CREDITOPRMSTSECOND,SUM(A.DEBITTAXMSTSECOND) AS
DEBITTAXMSTSECOND,SUM(A.CREDITTAXMSTSECOND) AS
CREDITTAXMSTSECOND,SUM(A.QTY) AS QTY,A.ACCOUNTNUM AS ACCOUNTNUM,A.DIMENSION
AS DIMENSION,A.DIMENSION2_ AS DIMENSION2_,A.DIMENSION3_ AS
DIMENSION3_,A.TRANSDATE AS TRANSDATE,A.PERIODCODE AS
PERIODCODE,A.SYSTEMGENERATEDULTIMO AS SYSTEMGENERATEDULTIMO,A.DATAAREAID AS
DATAAREAID,1010 AS RECID FROM LEDGERBALANCESDIMTRANS A(NOLOCK) GROUP BY
A.ACCOUNTNUM,A.DIMENSION,A.DIMENSION2_,A.DIMENSION3_,A.TRANSDATE,A.PERIODCODE,A.SYSTEMGENERATEDULTIMO,A.DATAAREAID
GO
setuser
GO
---
Good luck.
Regards,
Pascal
"James Flavell"
<[EMAIL PROTECTED]
.com> To
<[EMAIL PROTECTED]
17-06-2004 09:55 >
cc
Please respond to Subject
development-axapt [development-axapta] SQL VIEWS
[EMAIL PROTECTED] missing and cannot be synced
Has anyone had the problem that views such as LEDBALANCESDIM does not exist
in SQL server and when sync in AOT nothing is created?
I have checked and find that some of the views can sync but others
cannot!!!
I have checked the MASTER db and the views in that have INFORMATION_SCHEMA
as the owner...I dont know what or where else to try....
Thanks
James
[Non-text portions of this message have been removed]
Yahoo! Groups Links
Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.