I think i worked fine, thanks for your advice.
:-)
--- Girish Bhatkal <[EMAIL PROTECTED]>
escribió:
> there should not be any problem. but i would advice
> to
> take a database backup before doing any changes.
> good luck,
>
> --- Roberto Pineda &
.
Thanks in advance.
Roberto Pineda
__
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis!
Regístrate ya - http://correo.espanol.yahoo.com/
Yahoo! Groups Sponsor ~-->
Put m
Hello to all...
We just applied MS win2000 server service pack 4 in
our server & started to experiment a lot of problems
related to Axapta's response time and the system hangs
up with some options (for example when trying to
eliminate transactions from a consolidation entity).
Has someone applie
Hello to All...
We will be moving our SQL Axapta database to a new
server.
Is there a Best Practices list we can follow?
Any advice or suggestions.
Thanks a lot.
Roberto
__
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡grat
tle
> bit another way,
>
> While select legdertable
> While select ledgertrans where ...
>
> But it will issue a bunch of select statements,
> which is not ok for SQL server performance.
>
> -Original Message-
> From: Axapta-Knowledge-Village@yahoogroups.com
&
{
> lTrans = qr.getNo(2);
> /*
> while (lTrans.AccountNum)
> {
> info(lTrans.AccountNum);
> //for example
> next lTrans;
> }
> */
> }
> }
>
> -Original Message-
> From: Axapta-Kn
Hi guys.
I have a report with two data source joined by a
relation (LedgerTable and LedgerTrans) and I need to
do
something in the fetch method like:
public boolean fetch()
{
QueryRun qr;
LedgerTrans lTrans;
qr = new QueryRun(this.query());
while (qr.next())
{
lTran
Hello to All.
We need to be able to have an 'eliminations or
corporate' adjustments for consolidating purposes.
Yet need to do adjustments at country level not in the
consolidation entity.
This entries need NOT to appear at country level.
Could Posting layer in transactions be used for this?
I am setting up multiple country consolidation into
one entity. Each country has a different currency with
USD as secondary currency. Does anyone know how Axapta
handles the exchange rate? . Does it consider the
transactions exchange rate when showing the USD
amounts?
Are Local currency transact
Hello to All.
We have different companies, each one has a user group
definition, in order to limit the access to the
menues.
Also we have domains, because some user groups can
jump throught companies.
The point is that when we add a new MenuItem to any
Menu it is visible to all user groups. We ha
ery of a single company
> within Axapta, as you have only one database for
> your entire system. Microsoft has published a
> technical white paper on this issue; you will find
> the document on the Axapta 2.5 Installation CD in
> the documentation folder.
>
> This is of course my h
Hello to All.
My company has implemented Axapta Financials in some
countries.
The main server is located in Miami and the local
office in each country access Axapta
using Citrix (a kind of remote desktop).
We want to put a local axapta installation in each
country. If we do that, is there a w
ectionField(fieldNum(SalesLine,
> QtyOrdered), SelectionField::Sum);
> queryRunA = new QueryRun(queryA);
> queryRunA.setRecord(salesL);
> queryRunA.next();
>
> SumAmount += salesL.QtyOrdered;
>
>
> Steeve...
>
>
> -Message d'origine-
>
Hello to All
Is there a way to make a query that gives the same
result of doing:
select sum(FieldX) from TableX where FieldY ==
Something;
The way i found goes like this, but I am sure that
there should be a nicer way.
Amount SumAmount;
Query queryX;
QueryRun queryrunX;
TableX tableM;
queryX
ompared the class with my
> test environment..
>
> Anyway, best of luck.
>
> Thanks,
> Subbu
>
>
> roberto pineda <[EMAIL PROTECTED]> wrote:
> BTW, what does it follow next?
>
> Thanks.
>
> --- roberto pineda <[EMAIL PROTECTED]>
> escr
Hello
We have a company that has been using Axapta financial
series since July 2004. We found that the first months
are all wrong and want to cut them out. Leave the
transactions starting october 1st. Is there a way to
wipe out from the tables the previous data?
In other words, eliminate data fr
BTW, what does it follow next?
Thanks.
--- roberto pineda <[EMAIL PROTECTED]>
escribió:
> Thanks for your help!!!
>
> This is a Ax3.0 SP1, no hotfixes have been applied.
>
> I followed the steps one and two, but they din't fix
> anything.
>
> The comp
let me know...
>
> Hello, if anyone has similar exp, please share with
> us.
>
> Thanks,
>
> Subbu
>
> SDBC
>
>
>
>
> roberto pineda <[EMAIL PROTECTED]> wrote:
> I am getting an error when trying to void a check
> that
> had been posted.
>
>
I am getting an error when trying to void a check that
had been posted.
I get the following error message:
Error:
Error executing code: Division by zero.
Stack trace:
(s) \Classes\CustVendReversePosting\reversePennyDiff
line4
(s)
\Classes\CustVendReversePosting\restoreCustVendTrnas
line 28
(s
Hi to All.
I run the trial balance report for a specific account
in two ways, but the debits and credits doesn't match,
of course using the same date range.
The first way is using the summary option and the
second the details option. In the first one doesn't
include a kind of voucher used to can
Hello.
I need to register a tax code with value 0.00125, but
the system rounds it to 0.001. How can i avoid this?
It is possible to setup the round-off for tax values.
thanks in advance.
Roberto
__
Renovamos el Corr
Hello.
I have a question and hope someone can help me.
I need to register a tax code with value 0.00125, but
the system rounds it to 0.001. How can i avoid this?
It is possible to setup the round-off for tax values.
thanks in advance.
Roberto
_
TED]> escribió:
>
> Roberto,
> I haven't been able to pinpoint any other info for
> you at this
> point. What is the exchange rate you are using?
> Have you tried to
> run a consistency check (Basic > Periodic >
> Consistency check)?
>
>
> --- In [EMAIL
to USD?
> And what is the other currency? Also, what is the
> Maximum penny-
> rounding in secondary currency parameter set to
> (navigate General
> ledger > Setup > Parameters)?
>
> Thanks,
> Jacqy
>
>
> --- In [EMAIL PROTECTED],
> roberto pineda
Hello.
I need to post a journal, but i receive this message:
Message (11:34:21)
Amount is specified too detailed in relation to the
rounding of the currency.
Error in unit of amount in currency 'USD'. Must be
rounded to '0.00'.
Unit of 35,572.19 35,572.19 being posted to account
'1271-002' is to
I need to be able to post transactions from the same
vendor in different G/L accounts by concepts.
Is there a form I can leave the posting profile for
vendors 'open' and select the G/L on a transactional
basis by adding a field in the journal for this
purpose.
Is this possible?
Or: Is t
report in XXX
country, and they look at it
in YYY country, they said: "This report does not have
alignments in the titles
with the data".
Thanks a lot, for any help.
=
Roberto Pineda
__
Renovamos el Correo Yahoo!: ¡1
I am using Axapta 3.0 SP1. I am planning to upgrade to
SP3. What is best, to upgrade to SP2 first and then
SP3 or to upgrade to SP3 directly?
After upgrading, what key areas can I check to verify
that everything is ok
. ?
Thanks a lot.
___
he posting is
> done the system updates multiple tables with data
> and
> if we now try to change the posted data then we
> might
> end up not updating the data throughout all the
> affected tables.
>
>
>
> --- roberto pineda <[EMAIL PROTECTED]>
> wrote:
invoice and be able to use the invoice
number again while maintaining the Reject Duplicate
setup.
Is it possible to do?
Thanks a lot.
Roberto Pineda.
__
Renovamos el Correo Yahoo!: ¡100 MB GRATIS!
Nuevos servicios, más seguridad
http
journal in the secondary
> currency for the amount that you required and then
> in the entry (General tab) changed the default rate
> so that it equaled 100 of your local?
>
> An off the cuff suggestion.
>
> ____
>
> From: Roberto Pineda
&
I have this problem.
I need to post a journal in local currency (exchange rate field for
this journal will show 100), I need that the secondary currency
posting be converted at a different exchange rate from the one I have
in the exchange rate table for the day.
If done manually I can go to t
Hello to all... i need your help to resolve this.
I have a journal composed by transactions in local and secondary
currency, it seems to be balanced, but the validation shows this
error:
Warning Message (16:07:19) The transactions on voucher 'Gj3561' do
not balance as per '10/18/2004'.
Hello
How can I change the size of paper in a report.
My layout needs a Landscape 11x14in paper size.
how can i do this?
Thanks!
__
Renovamos el Correo Yahoo!: ¡100 MB GRATIS!
Nuevos servicios, más seguridad
http://correo.yahoo.es
the
> case you can correct the date of settlement.
>
> Hope that helps
> Michelle
>
> Roberto Pineda <[EMAIL PROTECTED]> wrote:
> Hi to All.
>
> I issue an Aging Analysis Report for a prior month
> for accounts
> payable or accounts receivable but the total
Hi to All.
I issue an Aging Analysis Report for a prior month for accounts
payable or accounts receivable but the total shown for the report does
not agree the total for this account in the G/L for the same date.
I've checked and both have the same transactions posted.
Anyone knows why?
Thanks
Hello,
I need to register a vendor invoice, but axapta validates that the
vendor address and phone number are not defined.
I want to set this off, how can I do it?
Thanks.
Yahoo! Groups Sponsor ~-->
Make a clean sweep of pop-up ads. Yahoo! Compan
37 matches
Mail list logo
