Hello to all.
i am a beginner axapta user. i was trying to add a field to the
LedgerTable, some error ocurred with 'table synchronization'. Later i
browse the table, it was empty for all companies.
The first time I browse the table, i receive this message:
Cannot select a record in Ledger chart of accounts (LedgerTable).
PUC-Cuenta Contable: , .
The SQL database has issued an error.
SQL error description: [Microsoft][ODBC SQL Server Driver][SQL
Server]El nombre de objeto 'LEDGERTABLE' no es v�lido.
SQL statement: SELECT
A.ACCOUNTNUM,A.ACCOUNTNAME,A.ACCOUNTPLTYPE,A.OFFSETACCOUNT,A.LEDGERCLOSING,=
A.TAXGROUP,A.BLOCKEDINJOURNAL,A.DEBCREDPROPOSAL,A.DIMENSION,A.DIMENSION2_,A.=
DIMENSION3_,A.OPENINGACCOUNT,A.COMPANYGROUPACCOUNT,A.DIMSPEC,A.CURRENCYCODE,=
A.MANDATORYCURRENCY,A.AUTOALLOCATE,A.POSTING,A.MANDATORYPOSTING,A.USER_,A.MA=
NDATORYUSER,A.DEBCREDCHECK,A.REVERSESIGN,A.MANDATORYDIMENSION,A.MANDATORYDIM=
ENSION2_,A.MANDATORYDIMENSION3_,A.COLUMN_,A.TAXDIRECTION,A.LINESUB,A.LINEEXC=
EED,A.UNDERLINENUMERALS,A.UNDERLINETXT,A.ITALIC,A.BOLDTYPEFACE,A.EXCHADJUSTE=
D,A.ACCOUNTNAMEALIAS,A.CLOSED,A.DEBCREDBALANCEDEMAND,A.DEL_LEDGERJOURNALDELL=
INE,A.TAXFREE,A.TAXITEMGROUP,A.MONETARY,A.LEDGERSETTLEMENT,A.ACCOUNTNUMMIRRO=
RDEBIT,A.ACCOUNTNUMMIRRORCREDIT,A.FISCALACCOUNTNUM,A.FISCALACCOUNTNAME,A.REC=
ID
FROM LEDGERTABLE A(NOLOCK) WHERE (DATAAREAID=?) OPTION(FAST 63)
Someone can help me?
Thanks
| 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.
