[Axapta-Knowledge-Village] Re: Section Printing in Report.

2004-12-06 Thread anton_tjiptadi
Hi, From what I've just learned, I think you should add some statement in Fetch Method in the report, such as : While (qr.next()) { (your data source) = qr.get(tablenum(your table)); . .. //the calculation if (YourAmount 0) element.send(your

Re: [Axapta-Knowledge-Village] Re: Section Printing in Report.

2004-12-06 Thread Ahmed Ibrahim
Hi Anton , thanks for your help. Ahmedanton_tjiptadi [EMAIL PROTECTED] wrote: Hi,From what I've just learned, I think you should add some statement in Fetch Method in the report, such as :While (qr.next()) { (your data source) = qr.get(tablenum(your table)); . .. //the calculation if

[Axapta-Knowledge-Village] Label file system

2004-12-06 Thread axaptagrp
Hi everyone, I am currently going through a hard time getting the label system to work when exporting some changes (in an xpo) to another Axapta system. Although during the import process, the labels are clearly being imported (label details tab on import dialog), only the references

YNT: [Axapta-Knowledge-Village] packing slip error

2004-12-06 Thread Cenk Ince
Thanks i solved it. Kimden: Sun Fen [mailto:[EMAIL PROTECTED] Gnderilmi: Pzt 06.12.2004 06:56 Kime: [EMAIL PROTECTED] Konu: Re: [Axapta-Knowledge-Village] packing slip error Hi, For under delivery message : Have you checked the Accept Under delivery setup in

RE: [Axapta-Knowledge-Village] DIFFERENCE BETWEEN FINANCIAL AND PHYSICAL INVENTORY VALUES

2004-12-06 Thread Des Patsourellis
Thank you Gulan I will investigate further to see if there are any other hidden costs which we may not have taken into account. I do agree with you though,that for standard costing if the quantities are equal one should get the same amount. Regards Des _ From: Van Den

RE: [Axapta-Knowledge-Village] Purpose of Axapta Tables

2004-12-06 Thread Ahmed Ibrahim
That would be great if you help me for thesame. I keen to know it. AhmedHennie Potgieter [EMAIL PROTECTED] wrote: If you find this, I would like to see it too.This would be a tremendous help.Hennie-Original Message-From: madtrs [mailto:[EMAIL PROTECTED] Sent: Friday, 03 December

[Axapta-Knowledge-Village] inventory journal

2004-12-06 Thread jeroen_vangheluwe
Dear, I made an inventory journal for a profit/loss (2 pieces for a certain item). I posted it. When I look at the net requirements for the article, I still see an a reference to my inventory journal (quantity = -1 ???). Normally it should be gone(because its posted) I need to get rid of this

RE: [Axapta-Knowledge-Village] Section Printing in Report.

2004-12-06 Thread Ahmed Ibrahim
Peng, I'm sorry, I could't understand what is meaning by YourSession and where can I write this code. I appreciate if you could give me more clarifications. Regards AhmedPeng Qing Hua [EMAIL PROTECTED] wrote: Hi, ahmed Can you do some like this? If (SomeFiledValue==0)

RE: [Axapta-Knowledge-Village] Section Printing in Report.

2004-12-06 Thread Varden Morris
Hi Ahmed All you need to do is make the call to super() in the executeSection method of the section conditional. That is, override the executeSection method of the section that you want to print conditionally and do something like this: if (FunctionValue() != 0) { super(); } This means

[Axapta-Knowledge-Village] QueryBuildRange question

2004-12-06 Thread Danny Gaethofs
Dear all, I added a QueryBuildRange to my query. I expected that when opening the Criteria column I would see all the unique values available in my table but I do not. I believe I understand the reason, but while I am not sure, I just want to have some input of you. I think it is because I

RE: [Axapta-Knowledge-Village] Section Printing in Report.

2004-12-06 Thread Ahmed Ibrahim
Varden, Thanks, it's working fine Regards AhmedVarden Morris [EMAIL PROTECTED] wrote: Hi Ahmed All you need to do is make the call to super() in the executeSection method of the section conditional. That is, override the executeSection method of the section that you want to print

RE: [Axapta-Knowledge-Village] Section Printing in Report.

2004-12-06 Thread Varden Morris
You are most welcome.Ahmed Ibrahim [EMAIL PROTECTED] wrote: Varden, Thanks, it's working fine Regards AhmedVarden Morris [EMAIL PROTECTED] wrote: Hi Ahmed All you need to do is make the call to super() in the executeSection method of the section conditional. That is, override the

RE : [Axapta-Knowledge-Village] QueryBuildRange question

2004-12-06 Thread Steeve Gilbert
There's not link between fields in indexes and range not being there. Try pressing Reset when you see the range columns. In what method did you add your range? Steeve... -Message d'origine- De : Danny Gaethofs [mailto:[EMAIL PROTECTED] Envoyé : 6 décembre 2004 06:23 À : [EMAIL

Re: RE : [Axapta-Knowledge-Village] QueryBuildRange question

2004-12-06 Thread Danny Gaethofs
it is just a job I am running --- In [EMAIL PROTECTED], Steeve Gilbert [EMAIL PROTECTED] wrote: There's not link between fields in indexes and range not being there. Try pressing Reset when you see the range columns. In what method did you add your range? Steeve... -Message

[Axapta-Knowledge-Village] constructor problem or ..

2004-12-06 Thread =?iso-8859-1?Q?G=F6khan_Mutlu?=
I am new to Axapta. Axapta supports overloading. This is what help says.. But I can not define constructors with diffrent parameters for a class.. Example;     void new(){...} void new(str _to,  str _from, str _subject, str _body ){...} Gökhan Mutlu

Re: [Axapta-Knowledge-Village] unbalanced x++ ttsbegin/ttscommit

2004-12-06 Thread Girish B
put the ttsbegin after if (qryRunAddress.prompt()) and then close the transaction by ttscommit accordingly. cheers, Girish --- Danny Gaethofs [EMAIL PROTECTED] wrote: - dear all, I am writing a job to update some values on a table based on input

Re: [Axapta-Knowledge-Village] unbalanced x++ ttsbegin/ttscommit

2004-12-06 Thread Girish B
here between the ttsbegin and ttscommit try to avoid entering the pause. you could use debugging to find the values or else you could put the pause after ttscommit. --- Danny Gaethofs [EMAIL PROTECTED] wrote: - dear all, I am writing a job to update some

RE: [Axapta-Knowledge-Village] unbalanced x++ ttsbegin/ttscommit

2004-12-06 Thread Don Price
You cant have UI between tts statements, move your ttsbegin down in the code some after the prompt (UI) Don -Original Message- From: Danny Gaethofs [mailto:[EMAIL PROTECTED] Sent: Monday, December 06, 2004 8:57 AM To: [EMAIL PROTECTED] Subject: [Axapta-Knowledge-Village]

[Axapta-Knowledge-Village] Re: unbalanced x++ ttsbegin/ttscommit

2004-12-06 Thread Danny Gaethofs
dear Girish, Thanks a lot! The problem is solved. I got rid of the unbalance by moving the ttsbegin down the prompt and closing it accordingly. regards, Danny --- In [EMAIL PROTECTED], Girish B [EMAIL PROTECTED] wrote: put the ttsbegin after if (qryRunAddress.prompt()) and then close

[Axapta-Knowledge-Village] Find RecId

2004-12-06 Thread Danny Gaethofs
Dear all, I have a small question. I have a table that contains a field of type string. This fields contains values that correspond to recid's in another table. Now I want to use the first table and find the records in the other table. I am looking for a way to search for recid's based on

AW: [Axapta-Knowledge-Village] Find RecId

2004-12-06 Thread Andrae, Tobias
num2str() ? -Ursprngliche Nachricht- Von: Danny Gaethofs [mailto:[EMAIL PROTECTED] Gesendet: Mo 06.12.2004 16:26 An: [EMAIL PROTECTED] Cc: Betreff: [Axapta-Knowledge-Village] Find RecId Dear all,

[Axapta-Knowledge-Village] Re: Find RecId

2004-12-06 Thread Danny Gaethofs
Andreas, No that is not working. You can check it when you print for example: print custTable.name + num2str(custTable.RecId) Now that is not what I am trying to do but it gives me the quickest result to check whether it is possible. regards and thanks anyway, Danny --- In [EMAIL

AW: [Axapta-Knowledge-Village] Re: Find RecId

2004-12-06 Thread Andrae, Tobias
of course jour job will not work, because I just hit the wrong method ;-// I meant int2str() which converts a int to a string, while num2str() needs some more params (just must have earned a syntax error while trying). br, Tobias -Ursprngliche Nachricht- Von: Danny

Re: RE : RE : [Axapta-Knowledge-Village] QueryBuildRange question

2004-12-06 Thread Danny Gaethofs
Dear Steeve, See my previous message on the unbalance ttsbegin/ttscommit. That is the job. Have a look at it. When I run it I am only see one record in the list that pops up when I open the field criteria. regards, Danny --- In [EMAIL PROTECTED], Steeve Gilbert [EMAIL PROTECTED] wrote:

[Axapta-Knowledge-Village] Re: Label file system

2004-12-06 Thread axaptagrp
No idea anyone? (no this is not an exam question) --- In [EMAIL PROTECTED], axaptagrp [EMAIL PROTECTED] wrote: Hi everyone, I am currently going through a hard time getting the label system to work when exporting some changes (in an xpo) to another Axapta system. Although during

RE : RE : RE : [Axapta-Knowledge-Village] QueryBuildRange question

2004-12-06 Thread Steeve Gilbert
Just tried the job and... I have no answer for you. I don't understand why it behave like that. Steeve... -Message d'origine- De : Danny Gaethofs [mailto:[EMAIL PROTECTED] Envoyé : 6 décembre 2004 11:39 À : [EMAIL PROTECTED] Objet : Re: RE : RE : [Axapta-Knowledge-Village]

[Axapta-Knowledge-Village] Add cost to inventory and recalculate issues on month closing

2004-12-06 Thread matiazo
Hello everybody, We've been working with Axapta for about one year and we're currently developing one little module do add some direct and indirect cost based on Ledger Accounts using a cost month closing journal and job (splitting direct cost for salary for example into the orders that

[Axapta-Knowledge-Village] Re: Purpose of Axapta Tables

2004-12-06 Thread Danny Gaethofs
Dear Ahmed, Hennie, Start by looking at the form SalesTable. You will see the data sources that are used, SalesLine, SalesTable, InventDim. These are the tables that are directly used in some way. For sure the salesline and salestable are used. When an invoice is created you clicked the

AW: [Axapta-Knowledge-Village] Syncronization error - Invalid object name 'INFORMATION_SCHEMA.VIEWS'

2004-12-06 Thread El Caramba
Hi Preston, you are right. The views in the master database has not the owner INFORMATION_SCHEMA. I used your sql script to fix the owner. Now everything works great (the syncronization). Thank you. Ursprngliche Nachricht-Von: Preston A. Larimer [mailto:[EMAIL

[Axapta-Knowledge-Village] Document Management

2004-12-06 Thread don
Hi all, Document management functionality allows us to add all sorts of documents to table records. Incoming, outgoing mail, word documents, outgoing faxes, and so on. Looking at these documents however I notice that you have to create entries in document management for a document or else

[Axapta-Knowledge-Village] String Manipulation

2004-12-06 Thread anton_tjiptadi
Hi, what is the syntax for string manipulation in X++, for ex (in VB): MyText -- left(string,2) -- My MyText -- right(string,4) -- Text MyText -- Substring(string,4,2) -- ex or format string like 0123456789 to be display like 01-234-567- 8.9 thanks, Yahoo!

RE: [Axapta-Knowledge-Village] String Manipulation

2004-12-06 Thread Hennie Potgieter
See AOT System Documentation Functions for all the string manipulation functions available in X++ viz: stralpha,strcmp,strcolseq, strdel,strfind,strins,strkeep,strlen,strline,strtrim,strlwr,substr etc. You can do pretty nifty stuff with combinations of these functions. Hennie -Original

Re[2]: [Axapta-Knowledge-Village] String Manipulation

2004-12-06 Thread Max Belugin
Hello Hennie Potgieter, , 7 2004 ., you wrote: See AOT System Documentation Functions for all the string HP manipulation functions available in X++ viz: HP stralpha,strcmp,strcolseq, HP strdel,strfind,strins,strkeep,strlen,strline,strtrim,strlwr,substr etc. HP You can do pretty nifty stuff