[Axapta-Knowledge-Village] Re: Ratio Analysis
Hi viveck, I am just starting with axapta and was wondering about the same thing. Can't we use the financial statement rows functionality to do ratio / budget analysis. I think using that we can define formulae to do the ratio analysis. regards, ramya --- In Axapta-Knowledge-Village@yahoogroups.com, viveck2002 [EMAIL PROTECTED] wrote: Hi Every one , Is there any inbuilt facility available in AXAPTA by which we can do the ratio analysis like if we want to see ratio of sundary creditors vs sundary debitors.How it can be done ? Similarly for other kind od ratio's can also be find out by financial staements. Waiting for the responses . Thanks Vivek Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Changing ID's Extended Data Types
Dear all, I have a situation where extended data types are created in the user layer and need to transferred to the var layer. I have done some tests and those show a change will not influence the data in the database. However just to be sure, will a change of id have an influence on axapta. I am replacing the user defined extended data type with one defined in the var layer. regards, Danny Yahoo! Groups Sponsor ~-- What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [Axapta-Knowledge-Village] Re: Subquery
Hi Anton,
The way you may get around this problem is byusing Microsoft SQL statements directly in X++. Try this example in a job. Connection con = new Connection();Statement sqlStmt = Con.createStatement();ResultSet SQLcustTrans;Notes sqlStr;sqlStr =strFmt("select * from custTable where LTRIM(Accountnum) = '%1' AND " + "Name like '%a%'", "11");SQLcustTrans = sqlStmt.executeQuery(sqlSTR);
while (SQLcustTrans.next()){ print SQLcustTrans.getString(1); pause;}
VardenMorris
J. Wray Nephew Ltd. - Group I.S.
234 Spanish Town Road
Kingston 11, Jamaica, W.I.
Phone: (876) - 923 - 6141 Ext. 2226Fax: (876) - 923 -5372
Cell: (876) - 3833566Email: [EMAIL PROTECTED]
[EMAIL PROTECTED]
anton_tjiptadi [EMAIL PROTECTED] wrote:
well, not the way I'm expected, but thanks though :))I guess there's a limitation in X++ querythanks,--- In Axapta-Knowledge-Village@yahoogroups.com, "akin" [EMAIL PROTECTED] wrote: anton_tjiptadi how about this code: custtable _table1,_table2; date _date; select max(createddate) from _table1; _date = _table.createdate ; select _table2 where _table2.createdate == _date; ===
2005-01-25 10:30:06 ÄúÔÚÀ´ÐÅÖÐдµÀ£º=== thanks, but isn't your query will only produce one line / record ? for my case, there might be many record which has the same date. thanks, --- In Axapta-Knowledge-Village@yahoogroups.com, "henrik3.rm" [EMAIL PROTECTED] wrote:Hi, try this; Custtable Custtable; ; select firstonly Custtable order by createdDate desc;regards, Henrik Østergård computercamp DK--- In Axapta-Knowledge-[EMAIL PROTECTED], "anton_tjiptadi" [EMAIL PROTECTED] wrote: Hi,
How to write a subquery in X++ Select statement for ex in SQL Server : -- select * from CustTable where createddate = (select max (createddate) from Custtable) thanks, Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links
= = = = = = = = = = = = = = = = = = = = Ö Àñ£¡ akin [EMAIL PROTECTED] 2005-01-25Sharing the knowledge on Axapta.
Do you Yahoo!?
Yahoo! Mail - 250MB free storage. Do more. Manage less.
Sharing the knowledge on Axapta.
Yahoo! Groups Links
To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/
To unsubscribe from this group, send an email to:[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Changing ID's Extended Data Types
If you add a field to a table in the USR layer, using a an EDT that was defined in the USR layer, the filed will exist on the table in the USR layer, it gets a fieldId in the range of USR layer IDs, if you come back later and change the EDT on that field to an EDT defined in that VAR layer, the field on the table will STILL exist in the USR layer and with the same FieldID it had before, EDT used will not affect the layer of a field. If you want this field in another layer you will have to delete the field from the table, and re-add it in the appropriate layer. Keep in mind Axapta makes use of fieldIDs in classes, forms and report definitions even though its not readably visible , and doing a change like this will most likely mean touching every other object in Axapta that is currently using that field, also if the field contains data you will have to come up with a plan to preserve it. It may be wiser to create a new field in the desired layer, create a job to copy data from the old to the new, and then edit each of the AOT objects that make use of the old field to point at the new; you can then safely delete the old field. -Preston From: Danny Gaethofs [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 25, 2005 6:32 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Changing ID's Extended Data Types Dear all, I have a situation where extended data types are created in the user layer and need to transferred to the var layer. I have done some tests and those show a change will not influence the data in the database. However just to be sure, will a change of id have an influence on axapta. I am replacing the user defined extended data type with one defined in the var layer. regards, Danny Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Re: Changing ID's Extended Data Types
Thanks Preston, I am aware of the id's fields on tables get. I had this problemn and have already solved it. (transferred the definition to the var layer and handle the data). I only need to do it for the extended data types now. regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, Preston A. Larimer [EMAIL PROTECTED] wrote: If you add a field to a table in the USR layer, using a an EDT that was defined in the USR layer, the filed will exist on the table in the USR layer, it gets a fieldId in the range of USR layer ID's, if you come back later and change the EDT on that field to an EDT defined in that VAR layer, the field on the table will STILL exist in the USR layer and with the same FieldID it had before, EDT used will not affect the layer of a field. If you want this field in another layer you will have to delete the field from the table, and re-add it in the appropriate layer. Keep in mind Axapta makes use of fieldID's in classes, forms and report definitions even though it's not readably visible , and doing a change like this will most likely mean touching every other object in Axapta that is currently using that field, also if the field contains data you will have to come up with a plan to preserve it. It may be wiser to create a new field in the desired layer, create a job to copy data from the old to the new, and then edit each of the AOT objects that make use of the old field to point at the new; you can then safely delete the old field. -Preston _ From: Danny Gaethofs [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 25, 2005 6:32 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Changing ID's Extended Data Types Dear all, I have a situation where extended data types are created in the user layer and need to transferred to the var layer. I have done some tests and those show a change will not influence the data in the database. However just to be sure, will a change of id have an influence on axapta. I am replacing the user defined extended data type with one defined in the var layer. regards, Danny Sharing the knowledge on Axapta. _ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] subject=Unsubsc ribe * Your use of Yahoo! Groups is subject to the Yahoo! http://docs.yahoo.com/info/terms/ Terms of Service. Yahoo! Groups Sponsor ~-- What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [Axapta-Knowledge-Village] Re: Changing ID's Extended Data Types
Then youre good to go, EDT layer has no affect on anything else in the AOT, and changing the EDT shouldnt be noticed if the new EDT has the same properties as the original. -Preston From: Danny Gaethofs [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 25, 2005 6:57 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Changing ID's Extended Data Types Thanks Preston, I am aware of the id's fields on tables get. I had this problemn and have already solved it. (transferred the definition to the var layer and handle the data). I only need to do it for the extended data types now. regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, Preston A. Larimer [EMAIL PROTECTED] wrote: If you add a field to a table in the USR layer, using a an EDT that was defined in the USR layer, the filed will exist on the table in the USR layer, it gets a fieldId in the range of USR layer ID's, if you come back later and change the EDT on that field to an EDT defined in that VAR layer, the field on the table will STILL exist in the USR layer and with the same FieldID it had before, EDT used will not affect the layer of a field. If you want this field in another layer you will have to delete the field from the table, and re-add it in the appropriate layer. Keep in mind Axapta makes use of fieldID's in classes, forms and report definitions even though it's not readably visible , and doing a change like this will most likely mean touching every other object in Axapta that is currently using that field, also if the field contains data you will have to come up with a plan to preserve it. It may be wiser to create a new field in the desired layer, create a job to copy data from the old to the new, and then edit each of the AOT objects that make use of the old field to point at the new; you can then safely delete the old field. -Preston _ From: Danny Gaethofs [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 25, 2005 6:32 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Changing ID's Extended Data Types Dear all, I have a situation where extended data types are created in the user layer and need to transferred to the var layer. I have done some tests and those show a change will not influence the data in the database. However just to be sure, will a change of id have an influence on axapta. I am replacing the user defined extended data type with one defined in the var layer. regards, Danny Sharing the knowledge on Axapta. _ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] subject=Unsubsc ribe * Your use of Yahoo! Groups is subject to the Yahoo! http://docs.yahoo.com/info/terms/ Terms of Service. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: Re: [Axapta-Knowledge-Village] Com Connector
hi as I know we can use C++ or VB or delphi write a Com+ proxy to connect to another com connector of axapter server,it work like virtual server. sowe can deploy two connector in one computer. or Win2003 Enterprise you have something called COM partisioning. You canrun several COM objects in their own memory space. And I heardsomeone has done this by made a Com wrapper that works like COMpartisioning Hope it will help you. 2005-01-2519:44:17 Hi Rocco, As far as I know you will have to register both of them on separate computers if you want to use both at the same time. Only one COM connector canbe registered and use on a compter at a time. VardenMorris J. Wray Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I. Phone: (876) - 923 - 6141 Ext. 2226Fax: (876) - 923 -5372 Cell: (876) - 3833566Email: [EMAIL PROTECTED] [EMAIL PROTECTED] Rocco Giumelli [EMAIL PROTECTED] wrote: I am having trouble establishing two seperate Com Connections one for my Live and one for Play System for Enterprise Portal Web Access. When I register the Play Config File and go into my Live system the test on the buisness connector says it is the Play system and vica versa. I am missing the trick. Under Licences it has registered 2 Com Clients. Rocco Giumelli Sharing the knowledge on Axapta. Do you Yahoo!?Yahoo! Search presents - Jib Jab's 'Second Term' Sharing the knowledge on Axapta. = = = = = = = = = = = = = = = = = = = = = = regards akin [EMAIL PROTECTED] 2005-01-25 Sharing the knowledge on Axapta. Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Re: Removing blank line from street field
Hi!
Enter is num2char(10). I would create a job that reads trough the
table using while select.
So if you first give some kind variable like
str enter = num2char(10)
tableName table;
then compare it to address field characters (read one by one using
system functions). I would do this in a loop:
while select table
{
streetstr = table.street;
for ( i=1; i=strlen(streetstr);i=i+1)
{
character = substr(streetstr,i,1);
if (character == enter)
streetstr = strdel(streetstr,i,1) // removes the character
}
table.street = streetstr;
table.update;
}
Of course you need to also determine which extra enters you have to
remove etc..
I hope this helps!
Regards
Nitta
--- In Axapta-Knowledge-Village@yahoogroups.com, Danny Gaethofs
[EMAIL PROTECTED] wrote:
Dear all,
I need to remove blank lines from hundreds of vendors and
customers.
Has someone done this before and want to share the approach.
I need to find the enter character or blank line in the street
field and get rid of it. How can I do this.
regards,
Danny
Yahoo! Groups Sponsor ~--
Has someone you know been affected by illness or disease?
Network for Good is THE place to support health awareness efforts!
http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM
~-
Sharing the knowledge on Axapta.
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
* Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
RE : [Axapta-Knowledge-Village] Re: Subquery
And don't forget to add
the dataAreaId field in your where clause.
Steeve...
-Message d'origine-
De: Varden Morris
[mailto:[EMAIL PROTECTED]
Envoyé: 25 janvier 2005
06:35
À:
Axapta-Knowledge-Village@yahoogroups.com
Objet: Re:
[Axapta-Knowledge-Village] Re: Subquery
Hi Anton,
The way you may get around this problem is
byusing Microsoft SQL statements directly in X++. Try this example in a
job.
Connection con = new Connection();
Statement sqlStmt = Con.createStatement();
ResultSet SQLcustTrans;
Notes sqlStr
;
sqlStr =strFmt(select * from custTable where LTRIM(Accountnum) = '%1' AND
+ Name like '%a%', 11);
SQLcustTrans = sqlStmt.executeQuery(sqlSTR);
while (SQLcustTrans.next())
{
print SQLcustTrans.getString(1);
pause;
}
VardenMorris
J. Wray Nephew Ltd. - Group I.S.
234 Spanish Town Road
Kingston
11, Jamaica,
W.I.
Phone: (876) - 923 - 6141 Ext. 2226
Fax: (876)
- 923 -5372
Cell: (876) - 3833566
Email: [EMAIL PROTECTED]
[EMAIL PROTECTED]
anton_tjiptadi
[EMAIL PROTECTED] wrote:
well, not the way I'm expected, but thanks
though :))
I guess there's a limitation in X++ query
thanks,
--- In Axapta-Knowledge-Village@yahoogroups.com,
akin
[EMAIL PROTECTED] wrote:
anton_tjiptadi
how about this code:
custtable _table1,_table2;
date _date;
select max(createddate) from _table1;
_date = _table.createdate ;
select _table2 where _table2.createdate == _date;
=== 2005-01-25 10:30:06
ÄúÔÚÀ´ÐÅÖÐдµÀ£º===
thanks, but isn't your query will only
produce one line / record ?
for my case, there might be many record
which has the same date.
thanks,
--- In
Axapta-Knowledge-Village@yahoogroups.com, henrik3.rm
[EMAIL PROTECTED] wrote:
Hi,
try this;
Custtable Custtable;
;
select firstonly Custtable order by
createdDate desc;
regards,
Henrik Østergård
computercamp DK
--- In Axapta-Knowledge-
[EMAIL PROTECTED],
anton_tjiptadi
[EMAIL PROTECTED] wrote:
Hi,
How to write a subquery in X++
Select statement
for ex in SQL Server :
-- select * from CustTable
where createddate = (select max
(createddate) from Custtable)
thanks,
Yahoo! Groups
Sponsor ---
-~--
Has someone you know been affected by
illness or disease?
Network for Good is THE place to support
health awareness efforts!
http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM
--
--~-
Sharing the knowledge on Axapta.
Yahoo! Groups Links
= = = = = = = = = = = = = = = = = = = =
ÖÂ
Àñ£¡
akin
[EMAIL PROTECTED]
2005-01-25
Sharing the
knowledge on Axapta.
Do you Yahoo!?
Yahoo! Mail - 250MB free storage. Do
more. Manage less.
Sharing
the knowledge on Axapta.
Sharing the knowledge on Axapta.
Yahoo! Groups Links
To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/
To unsubscribe from this group, send an email to:[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Urgent - COM Connector Error on Ax. EP Portal...
Hi all, We set up and configured axapta portal server 2 months ago. since 1 weeks it started to give the message below very often(3-4 times a day) and com connecter becomes down. ---The message is : Axapta COM Connector Session 17. Security package/Domain Authentication failed SSO failure. InitializeSecurityContext failed with return code 2148074240. Error code 80090300 %4 Yahoo! Groups Sponsor ~-- What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [Axapta-Knowledge-Village] Re: Removing blank line from street field
Hi,
I had the same problem earlier as the some of the customer addresses were entered with more than 3 lines with a newline in between. The complete address were not getting printed on the cheques
I wrote a job to remove the new lines if any. The code is almost similar , but used strNfind,strdel functions. in stead of capturing Enter character, I used '\n'. charater... It did my job...
Subbu
nttrehn [EMAIL PROTECTED] wrote:
Hi!Enter is num2char(10). I would create a job that reads trough the table using while select.So if you first give some kind variable likestr enter = num2char(10)tableName table;then compare it to address field characters (read one by one using system functions). I would do this in a loop: while select table{streetstr = table.street;for ( i=1; i=strlen(streetstr);i=i+1){ character = substr(streetstr,i,1); if (character == enter) streetstr = strdel(streetstr,i,1) // removes the character }table.street = streetstr;table.update;}Of course you need to also determine which extra enters you have to remove etc..I hope this helps!
RegardsNitta--- In Axapta-Knowledge-Village@yahoogroups.com, "Danny Gaethofs" [EMAIL PROTECTED] wrote: Dear all, I need to remove blank lines from hundreds of vendors and customers. Has someone done this before and want to share the approach. I need to find the enter character or blank line in the street field and get rid of it. How can I do this. regards, DannySharing the knowledge on Axapta. __Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
Sharing the knowledge on Axapta.
Yahoo! Groups Links
To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/
To unsubscribe from this group, send an email to:[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] Re: Is Once Only a bug in Ax3.0 - SUpplementary Items
George, Thanks for your call . I think its urgent for us( pretty big impl with 3 localizations )and wait to see how much time MS takes for the fix or my team put me under gun for a rude customization. Thanking you. regards, Subbu SDBCjaxxnrhyno [EMAIL PROTECTED] wrote: Subbu,After researching this issue it does appear that they system is not functionig correctly. I am working with our teams to address this problem. As a workaround, you could either delete the line items after they are created, or mark your supplementary items as "Optional" and choose not to include them when calculating. If this is an urgent matter, please contact Support for additional help. Thanks,Jacqy George [MSFT][EMAIL PROTECTED]This posting is provided "AS IS" with no warranties, and confers no rights.Do not send e-mail directly to this alias. This alias is for newsgroup purposes only.--- In Axapta-Knowledge-Village@yahoogroups.com, "sunfen" [EMAIL PROTECTED] wrote: Hi Subbu, It is a bug allright. 'Once only' should only create one order line only. I have experienced this long time ago when using SP2. In SP3 seems not fixed yet. Regards, Sun Fen -Original Message- From: Subrahmanyam Mamidi [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Date: Mon, 24 Jan 2005 14:06:13 -0800 (PST) Subject: Re: [Axapta-Knowledge-Village] Re: Is "Once Only" a bug in Ax3.0 - SUpplementary Items Hi George, Thank you for the email. We are running SP3 AX3. I can see my supplementary item showup and when I hit ok, the corresponding sales lines are getting created to the particular Salesorder . But problem is, when I selected 'Only once'. it should add only one time to that particular sales order. Surprizingly, it keeps adding everytime you click (calculate/ok). In that case, Only Once doesn;t make any sense to me. It should add only one time...Or ami I doing wrong?. Can you please investigate the cause?. Otherwise everything is fine. Why is 'Only Once' not working?. or Is there any other purpose for that onlyonce check box?.Thanking you for your help. regards, Subbujaxxnrhyno [EMAIL PROTECTED] wrote:Subbu, Are you running any service packs? I was able to test your scenario on 3.0SP3 okay. What is your exact problem? Does your supplementary item not come thru on the sales order window after calculation or does it not even display on the Calculated supplementary items window? Thanks, Jacqy George [MSFT] [EMAIL PROTECTED] This posting is provided "AS IS" with no warranties, and confers no rights. Do not send e-mail directly to this alias. This alias is for newsgroup purposes only.--- In Axapta-Knowledge-Village@yahoogroups.com, Subrahmanyam Mamidi [EMAIL PROTECTED] wrote: Hi, While I am working on a customization for supplememenary Items , I am having a problem on the Supplementary Items 'Only Once' check box.. I am briefly explaining the situation. I went to AR-Customers. I picked up a customer, and clicked on TrageAgreemtn-Supplementary Sales Items. Now, I added a new items with the required paramters and checked the box 'Once Only' to make sure thats applicable for onetime only. So I created a sales Order for this, and matched the qty which triggers the supplementary Items. So I went to 'Calculation and then Supplemetary Items'. It seems not working per sales order. Does anyone has any experience with this?. or Am I doing anyting wrong??? Appreciate help. Thanks, Subbu, SDBC - Do you Yahoo!? The all-new My Yahoo! What will yours do?Sharing the knowledge on Axapta. - Yahoo! Groups LinksTo visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/To unsubscribe from this group, send an email to: [EMAIL PROTECTED]Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - Do you Yahoo!? Yahoo! Search presents - Jib Jab's 'Second Term'Sharing the knowledge on Axapta. __Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] RE: markuptrans with amount zero
Hi I had to make a modification to post miscellaneous charges on purchase packing slip (std axapta does not do this) and then keep the physical cost and financial cost same. I still do not have any clear reason as to why the client wanted this.*s* Regards harry From: Jesper Kehlet [mailto:[EMAIL PROTECTED] Sent: Wednesday, 26 January 2005 10:29 a.m. To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] RE: markuptrans with amount zero Harry, first of all, let me say that although it is accepted practice, I can not imagine why anybody would do it that way. You're right, they would have to dig up the old invoices, unless the misc. charges is recorded elsewhere in Axapta. The way I have seen it implemented in the past is like this: - MarkupTrans are calculated, but posted on a balance sheet account. - When the user decides to pay the invoice the payment amount is then recorded, the misc. charge portion they paid is now posted to PL, and any discrepancy is reversed and disappears. This way you actually allow the customer to choose way misc. charges to pay, and which ones not to pay. It's a crazy system, but some companies have agreed to this with their customers, an they must now live with it, or potentially lose their customer's business. Isn't it be that you, the customer, can decide whether you want pay SH etc. or not after you receive the goods? ;-) You have no idea what crazy practices I see, especially here in the US! Practices that would never be allowed to go on in European countries such as Denmark, Germany, France -- I do not have enough knowledge about New Zealand or Australia. -Original Message- From: Harry Deshpande [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 19, 2005 5:07 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] RE: markuptrans with amount zero hi out of academic interest! Does this affect payment recovery in any way? The invoice amount is going to be different than what you want to recover from customer. So every time one wants to followup one will have to dig up printed invoices( i assuming dummy misc charges are printed straight on the invoices). Plus every time a customer pays one has to dig up invoices matcht the excess amount with dummy misc charges and do appropriate postings, reconciliations etc. This will need hiring of one more staff so the advantage of deferring tax payments is practically nullified. would appreciate your comments regards harry -Original Message- From: Jesper Kehlet [mailto:[EMAIL PROTECTED] Sent: Thu 20/01/2005 10:53 a.m. To: Axapta-Knowledge-Village@yahoogroups.com Cc: Subject: RE: [Axapta-Knowledge-Village] RE: markuptrans with amount zero If you're a cash-based, GAAP-compliant operation, this is actually a acceptable procedure, although most companies would let it hit their books on the balance sheet, reversing it to PL when payment was record. For small businesses that has tight cash-flows this is a great way of deferring tax payments for inventory you sell as payments cross over into a new fiscal year. -Original Message- From: Harry Deshpande [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 19, 2005 3:35 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] RE: markuptrans with amount zero hi So if the customer pays the misc charges then they are recorded in the accounting system.hmm... interesting concept. regards harry -Original Message- From: Cenk Ince [mailto:[EMAIL PROTECTED] Sent: Wed 19/01/2005 8:20 p.m. To: Axapta-Knowledge-Village@yahoogroups.com Cc: Subject: YNT: [Axapta-Knowledge-Village] RE: markuptrans with amount zero Hi harry It will be easy to use it because i want my records to be linked to invoice and to be removed form salesorder after billing. So it will be easy to use markuptrans. One more reason they are real misc. charges which is not shown in my Accounting System but which is shown to customer. Thanks. _ Kimden: Harry Deshpande [mailto:[EMAIL PROTECTED] Gönderilmis: Sal 18.01.2005 22:04 Kime: Axapta-Knowledge-Village@yahoogroups.com Konu: [Axapta-Knowledge-Village] RE: markuptrans with amount zero Hi It should not create any problems for axapta (other than filling up the database). Why do u need to create these transactions? (just curious) Regards harry Harry Deshpande Senior Consultant CGNZ Middle Market Solutions Website: http://www.cgnz.com/middlemarketsolutions www.cgnz.com/middlemarketsolutions Ph +64 29 277 5133 Fax +64 9 358 1018 CGNZ Limited and its predecessor organisations (Cap Gemini Ernst Young, and Ernst Young Consulting) have a proud track record of market leadership and excellent service delivery in all areas of systems delivery both for New Zealand clients and in supporting regional and global projects. CGNZ is a licensed affiliate of Cap Gemini S.A. (one of the
Re: [Axapta-Knowledge-Village] Documentation needed
hello, try this link: www.axaptalink.com http://mbsonline.org http://www.axapta-links.com have a good day.martin_morsing [EMAIL PROTECTED] wrote: Hello group,While documenting an Axapta solution I need a whole lot of documentation / White Papers etc. on Axapta.Currently I look for * Batch job setup and management* ASP managementI've been browsing on PartnerSource and Partnerguide but with no luck.If you have links to any doc.'s please keep me posted.All the bestMartin Morsing Larsen[EMAIL PROTECTED]Sharing the knowledge on Axapta. Do you Yahoo!? Yahoo! Search presents - Jib Jab's 'Second Term' Sharing the knowledge on Axapta. Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: Re: [Axapta-Knowledge-Village] problem: COM - MSWORD
Joy More detail please. if you have to drive another application which developed by delphi in axapta,why you use COM? If you want to use axapta in delphi ,axapta provide a com connector. Hi all, I want to connect our inhouse program with Axapta. Does anyone know how to run Delphi from Axapta??? Is it just using the exe file or there is another way to do it? I hope anyone can help me cause i new in this project, and i don't have any documentation about it. Regards, JoySharing the knowledge on Axapta. = = = = = = = = = = = = = = = = = = = = = = akin [EMAIL PROTECTED] 2005-01-26 Sharing the knowledge on Axapta. Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: Re: [Axapta-Knowledge-Village] problem: COM - MSWORD
Hmm. Com Connector??? can you explain more about it, cause i want to use delphi in axapta (not axapta in delphi). The detail, let see... I want to make a form or menu in axapta that pointedthe delphi program. So the user can use delphi program by only login to axapta. Is it possible to do it? or is there another alternative? Thanks Joy - Original Message - From: akin To: [EMAIL PROTECTED] Sent: Wednesday, January 26, 2005 9:16 AM Subject: Re: Re: [Axapta-Knowledge-Village] problem: COM - MSWORD Joy More detail please. if you have to drive another application which developed by delphi in axapta,why you use COM? If you want to use axapta in delphi ,axapta provide a com connector. Hi all, I want to connect our inhouse program with Axapta. Does anyone know how to run Delphi from Axapta??? Is it just using the exe file or there is another way to do it? I hope anyone can help me cause i new in this project, and i don't have any documentation about it. Regards, JoySharing the knowledge on Axapta. = = = = = = = = = = = = = = = = = = = = = = akin [EMAIL PROTECTED] 2005-01-26 Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re[3]: [Axapta-Knowledge-Village] problem: COM - MSWORD
Hello Joy, , 26 2005 ., you wrote: J Hmm. J Com Connector??? J can you explain more about it, J cause i want to use delphi in axapta (not axapta in delphi). there are several ways to do it - create win32 DLL and see WINAPI class for examples - create COM class and use by COM class or ActiveX form control - create DDEServer - create WEBService - use standard windows IPC - create command line interface for Delphi functionality and run it using WinAPI::shellExecute -- Best regards, Max http://belugin.newmail.ru ICQ:9406811 Yahoo! Groups Sponsor ~-- What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Project Certification - Integration
I am studying to take the Axapta certification exam on projects. I know there is a section on integration with the rest of the system (ie transfering production costs, coverage) but have found no information on this is the standard project course. Does anyone have any suggestions on where to find this information? Thanks. Yahoo! Groups Sponsor ~-- What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: Re[3]: [Axapta-Knowledge-Village] problem: COM - MSWORD
Thanks for your answer. I have try the winAPI class and it is works. This is just for my knowledge, May you explain more about the other way that you have mentioned. Cause i am really blind about COM object :p. Thanks Joy - Original Message - From: Max Belugin [EMAIL PROTECTED] To: Joy Axapta-Knowledge-Village@yahoogroups.com Sent: Wednesday, January 26, 2005 2:06 PM Subject: Re[3]: [Axapta-Knowledge-Village] problem: COM - MSWORD Hello Joy, , 26 2005 ., you wrote: J Hmm. J Com Connector??? J can you explain more about it, J cause i want to use delphi in axapta (not axapta in delphi). there are several ways to do it - create win32 DLL and see WINAPI class for examples - create COM class and use by COM class or ActiveX form control - create DDEServer - create WEBService - use standard windows IPC - create command line interface for Delphi functionality and run it using WinAPI::shellExecute -- Best regards, Max http://belugin.newmail.ru ICQ:9406811 Sharing the knowledge on Axapta. Yahoo! Groups Links Yahoo! Groups Sponsor ~-- In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: Re: Re: [Axapta-Knowledge-Village] problem: COM - MSWORD
Joy you want to use delphi in axapta .so Com Connector is not useful to you. I adivce is you have to modified your delphi application so it can work as a com server like office do it. then you can use x++ code to use the com object . if you want to know how to use com in x++,please check the Class:sysexcel in AOT. 2005-01-2615:00:57 Hmm. Com Connector??? can you explain more about it, cause i want to use delphi in axapta (not axapta in delphi). The detail, let see... I want to make a form or menu in axapta that pointedthe delphi program. So the user can use delphi program by only login to axapta. Is it possible to do it? or is there another alternative? Thanks Joy - Original Message - From: akin To: [EMAIL PROTECTED] Sent: Wednesday, January 26, 2005 9:16 AM Subject: Re: Re: [Axapta-Knowledge-Village] problem: COM - MSWORD Joy More detail please. if you have to drive another application which developed by delphi in axapta,why you use COM? If you want to use axapta in delphi ,axapta provide a com connector. Hi all, I want to connect our inhouse program with Axapta. Does anyone know how to run Delphi from Axapta??? Is it just using the exe file or there is another way to do it? I hope anyone can help me cause i new in this project, and i don't have any documentation about it. Regards, JoySharing the knowledge on Axapta. = = = = = = = = = = = = = = = = = = = = = = akin [EMAIL PROTECTED] 2005-01-26 Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. = = = = = = = = = = = = = = = = = = = = = = akin [EMAIL PROTECTED] 2005-01-26 Sharing the knowledge on Axapta. Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: Re[3]: [Axapta-Knowledge-Village] problem: COM - MSWORD
Max Belugin, I think the best way is below : Hello Joy, , 26 2005 ., you wrote: J Hmm. J Com Connector??? J can you explain more about it, J cause i want to use delphi in axapta (not axapta in delphi). there are several ways to do it - create win32 DLL and see WINAPI class for examples - create COM class and use by COM class or ActiveX form control - create DDEServer - create WEBService - use standard windows IPC - create command line interface for Delphi functionality and run it using WinAPI::shellExecute -- Best regards, Max http://belugin.newmail.ru ICQ:9406811 Yahoo! Groups Sponsor ~-- What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links = = = = = = = = = = = = = = = = = = = = akin [EMAIL PROTECTED] 2005-01-26 Yahoo! Groups Sponsor ~-- What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
