Hi Joel,
There is another alternative, after finding the table:
userinfo. you can let it blank the field password (on
table userinfo). Then you can log in again with that
username (which is the password has been blank)
without password. After you in the system, you can
manage again your
Hi,
This will work for 250 units and multiples, but for 251 units, the time
should be 30 min. Where axapta will calculate it as (15/250)* 251 = 15.06
minutes.
thanks
Ustun Uctum
AXIS Information Technologies
+90 216 360 06 53
www.axis-it.com
-Original Message-
From: vaibhav pednekar
Hi,
My opinion: impossible without extra programming: the route has fewer
possibilities than the Bom (who has roundings and mutiple parameters).
Gunther
-Original Message-
From: Üstün Uçtum [mailto:[EMAIL PROTECTED]
Sent: dinsdag 9 november 2004 9:27
To: [EMAIL PROTECTED]
Subject:
Morris,
So sorry that I am currently unable to give you detailed examples of my own since I am debugginga critical error to solve soon.
But you can try to learn controlling grid on the fly from form 'SysTableBrowser' and also its class 'SysTableBrowser' (examine method run). This form is
Additionally, to access temporary table through static method, you must pass the temporary table as an object parameter. So from my previous example:
TmpTableNew::buildTempData();
should have been
TmpTableNew::buildTempData(tmpTableNew);
-Aji Sarosa-
Aji Sarosa [EMAIL PROTECTED] wrote:
Hi Subbu, vaibhav,
Good morning.
i understand the reason why subbu is looking for and
MS has advised to maintain multiple databases. But
there would be a few restrictions (which again could
be solved using modifications) like
1. supposed in future one company needs to understand
the
THE BEST OFFER EVER
Message-ID: [EMAIL PROTECTED]
User-Agent: eGroups-EW/0.82
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Length: 304
X-Mailer: Yahoo Groups Message Poster
X-Originating-IP: 202.54.51.5
X-Yahoo-Newman-Property: groups-compose
X-Yahoo-GPoster:
Andrew,
One can select a number of invoices to be printed at the same time
using Accounts Receivable, expand the Periodic, expand Sales Update,
click Invoice. Now make your selection using the select button.
regards
--- In [EMAIL PROTECTED], Andrew Vranjes
[EMAIL PROTECTED] wrote:
Hello,
Hi Joel,
There are a lot of examples in the help-file
called AxDvgCOMUs.chm (located in your bin folder).
Regards,
Karsten
Wollesen Clausen
Thy Data Center
Development A/S
From: Joel WU
[mailto:[EMAIL PROTECTED]
Sent: 9. november 2004 11:14
To: [EMAIL PROTECTED]
Hi Joel,
Try this: (VB NET)
Dim Axapta As
AxaptaCOMConnector.Axapta
Axapta.Logon(..)
Axapta.CallStaticClassMethod(NameOfClass,
NameOfMethod, Parm1 of method, Parm2 of method,)
Axapta.Logoff()
Regards,
Alfonso
De: Joel WU
[mailto:[EMAIL PROTECTED]
Enviado el: martes,
Thanks Aji,BobBob BrinkerOakdene Group, Inc.2625 Butterfield Rd. (Suite 212E)Oak Brook, IL 60523-1261(630)368-1046 x/230(630)368-1050 (Fax)[EMAIL PROTECTED]Aji Sarosa [EMAIL PROTECTED]11/08/2004 08:26 PM PSTPlease respond to Axapta-Knowledge-Village To: [EMAIL PROTECTED] cc: bcc: Subject:
Thanks Subbu,BobBob BrinkerOakdene Group, Inc.2625 Butterfield Rd. (Suite 212E)Oak Brook, IL 60523-1261(630)368-1046 x/230(630)368-1050 (Fax)[EMAIL PROTECTED]Subrahmanyam Mamidi [EMAIL PROTECTED]11/08/2004 05:15 PM PSTPlease respond to Axapta-Knowledge-Village To: [EMAIL PROTECTED] cc: bcc:
Hi Vaibhav,
Thanks for the info. I tried it and it works great when the transaction I am
posting is in US dollars (to convert to local currency). But when the
transaction is in local currency the exchange rate shown is 100=100.
I need to overide the exchange rate, for local currency
Hi Joel,
Just want to give you some additional info about the UserInfo table. It is a system table and you can browse it from the AOT and modify its content without going directly to your database. You however do not locate this table as you would do for the ordinary application tables. Go to
Hi
My code is as follow in C#
DateString = 2004-11-10
AxCustTable
= Axapta.CreateRecord(MyTable);
AxCustTable.ExecuteStmt(select
* From %1 where %1.ScanDate = '+ DateString + ');
What is the problem with this
statement?
I get no exception, but it
just give me all the
I think that this is like an issue raised before. Because they also report in
other currencies, the entry is going in using the Local currency but they
require it to convert at a different rate than the standard exchange table.
I don't think that this can be done without changing the tables,
Aha!, Hey guys hold on for a momentI think VilmaQ isthe same boat.
well, I can explain his requirement ( as mine ). As I explained before, I have European environment with 9 companies. 8 out of 9 companies follow EUROs as the Local currency. but the UK ( troubler) still uses Pounds as the
Hello guys,
Isnt the traingulation usefull in this case.
Sorry but still havent got any chance to deal with
such requirement so cannot comment on this.
The Traingulation is feature is created specially for
the European countries to handle EURO transactions.
It will be kind of you people if
Hello,
I am working through my first A/P invoice posting. I entered them in
Invoice Register, approved, posted and transfered them. No problem.
Now I retrieved/fetched them into Invoice Approval Journal. All of a
sudden, the vouchers are out of balance: I have two credit lines and
only one
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
RAL/James,
Thanks for the responses. That is just the information I was
looking for.
Bruce
Yahoo! Groups Sponsor ~--
$9.95 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/kGEolB/TM
hi VilmaQ,
Sorry, but i still cant understand your requirement.
Please give an example of transactions for two
different countries and show what you want.
As per my understanding, each company follows some
bank or an financial institution for the exchange
rate.
Either they may go for the daily
We are struggling with two issues related to credit memos and are
wondering how others have approached these issues.
1. We want to generate monthly reports of credit memos summarized by
return action code. But the only place we can find the return
action code is on the sales line table.
Hi All, 11-9/04
After a week of testing sales order modificatioins today I started getting
an error when ever I try to post a sales order , enter or modify a sales
order etc.
The error I am getting is: ?Inventory dimension 'Size' is an item dimension
and must
Hey Bob,
Your item on your sales order has inventory dimension that is set as
required. Go to the main table on the item, look at your dimension group, go to
main table, you should see the dimension is set to
active and primary stocking meaning that you have to specify it. You should
Vaibhav you are a life saver. Thanks for replying to my problem. What do you mean by the main table?Thanks,BobBob BrinkerOakdene Group, Inc.2625 Butterfield Rd. (Suite 212E)Oak Brook, IL 60523-1261(630)368-1046 x/230(630)368-1050 (Fax)[EMAIL PROTECTED]vaibhav pednekar [EMAIL
Don, You made my day. Thanks for responding to my problem but what is the name of the main table? thanks again,BobBob BrinkerOakdene Group, Inc.2625 Butterfield Rd. (Suite 212E)Oak Brook, IL 60523-1261(630)368-1046 x/230(630)368-1050 (Fax)[EMAIL PROTECTED]Don Price [EMAIL PROTECTED]11/09/2004
Main Table is - ItemMaster (InventTable).
Dimensions is on General Tab .. Groups !
Go to main table - Dimensions Group.
Then on the grid in the middle check your size dimension check box is active or not ( This is item dimensions!.)
Cheers
Jim
Subrahmanyam Mamidi [EMAIL PROTECTED]
Hello:
I have this line of C# Code
In Axapta, we have Date2Str function use in query,
however, How do we do this in COM Connector
DateString =2004-11-15;
AxCustTable.ExecuteStmt(select
* From %1 where %1.ScanDate == \+ DateString +
\);
Regards,
Joel
Sharing the
Hi All,
I am having a problem printing the detail Misc Charges (from the
MarkupTrans table) on the SalesInvoiceUS report. No descriptions or charges
print on my report. I get no description and .00 for the charge.
I have assumed that it is sufficient to go after the MarkupTrans table
using
Hey Bob,
If you right-click on an item # you will get a context menu this
menu will in have a go to the main table item in it. If you pick
that, it will load the inventory item master screen for that item. Many thing
like this are in the system, like customers, vendors,items,sales
Title: Error Message: Number Sequence for Network is not initialized when creating Employee
Hi Tom,
Thanks for the answer. But, I also find another alternative
solution, that is, setting up the reference on Basic/Setup/Number
Sequences/References and set number sequence for module 'Virtual
How can i select a table and return a specific field and place it in
a combobox?
For example:
I want to select the AccountNum field in the LEDGERTABLE and exclude
records with HEADER,PAGE HEADER,EMPTYHEADER and TOTAL in their
AccountType field. Then i want to put all these records in a
Jim,I cannot tell you how much I appreciate the help you and several others you gave me today.Thanks so much to you and to everyone else who responded, BobBob BrinkerOakdene Group, Inc.2625 Butterfield Rd. (Suite 212E)Oak Brook, IL 60523-1261(630)368-1046 x/230(630)368-1050 (Fax)[EMAIL
You need to use table id and recid
Look at the relationship on MarkupTrans CustInvoiceTrans
MarkupTrans.transTableId
== custInvoiceTrans.TableId
MarkupTrans.TransRecid == CustInvoiceTrans.RecId
Don
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL
hi ferry,
if u read the getting started and user guides of the
Axapta which are on the installation CD, most of your
basic queries will be answered.
so go through the getting started and user guides
once, always recomended for beginners.
with best regards
vaibhav pednekar
--- Ferry Widjaja
Hi Morris,
You can put a combobox, set its lookup property to always, set its
extended data type property to the same extended data type with the
field you want to display.
Then you should override its lookup method. There are various
examples of 'creating your own lookup form' in the
hi Morris,
You ahve to do it on the form init method of the form if you want to add the field values to a combo box dynamically. There are methds on the combo to add the values to the combo. Not compulsarily on the init itself, or else you need to redraw the element.
Hope this will help. I
Hey Jim,
I want to populate it dynamically. So your right, i have to do it in
the init method of the form. However, how can i store the result of a
specific SQL statement then afterwards put the records on the
combobox?
Morris
--- In [EMAIL PROTECTED], Jim Jo
[EMAIL PROTECTED] wrote:
Hey Jim,
I know already how to add values to a combobox. My problem is how to
get the values that i will place in them. Any ideas? Thanks!
Morris
--- In [EMAIL PROTECTED], Jim Jo
[EMAIL PROTECTED] wrote:
buddy,
do it in a while loop and add the values to the combo. I think
that
how did you add the the value to the combo box ?
if you want to add a set if vaues do something like this ... am not a full time programmer :).
while select table {
combo.add(table.fieldname) /* use the correct method here */
}
...got some clue ?? :-)
Jim
Morris Mendoza
Thanks Jim! Got it!
New question though, How do use dates in AXAPTA. Like given to dates,
how do you compute for their difference.
e.g.
1/1/2004 - 1/2/2004 = 2 DAYS!!!
Do you use ordinary subtraction or you need a special kind of
function to accomplish this? thanks!
Morris
--- In [EMAIL
Dear all,
1) I would like to know why whether Axapta considers also the current
or open Production Order (with remaining Qty to be produced) in its
Net Requirement. I have tried to make a simulation like this:
Item 01 with Sales Order 111 pcs delivery date 1 Dec 04. Current On
Hand is 0.
Try your thoughts first !!!
lemme know if you are not successful !!
JimMorris Mendoza [EMAIL PROTECTED] wrote:
Thanks Jim! Got it!New question though, How do use dates in AXAPTA. Like given to dates, how do you compute for their difference.e.g.1/1/2004 - 1/2/2004 = 2 DAYS!!!Do you use
Dear Benny,
1) I believe Ax consider the open Production order, just check the
coverage group attached to this item.
2) splitting can be done in Ax, you can split the Planned production
Order, or the production order itself but it has to be with the status
of started.
Go to Production Order
45 matches
Mail list logo