Re: [Axapta-Knowledge-Village] Re: Delivery date mandatory before invoicing

2008-06-24 Thread Girish Bhatkal
if you want to make sure only the lines which has the delivery date should get 
invoiced, then put a validation in the salesFormLetter (check the methods 
chooseLine/ CreateParmLine).  here you can control which saleslines should be 
included while posting.

--- On Fri, 20/6/08, Axapta Material [EMAIL PROTECTED] wrote:

From: Axapta Material [EMAIL PROTECTED]
Subject: Re: [Axapta-Knowledge-Village] Re: Delivery date mandatory before 
invoicing
To: Axapta-Knowledge-Village@yahoogroups.com
Date: Friday, 20 June, 2008, 9:33 PM








Dates are not available when the sales order is created. 
Before invoicing sales must have the dates so that they should be able to do 
picking and packing without dates but not invoicing.
Thanks

- Original Message 
From: prasanna_koulgi prasanna_koulgi@ yahoo.co. in
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Sent: Friday, June 20, 2008 2:01:41 AM
Subject: [Axapta-Knowledge- Village] Re: Delivery date mandatory before 
invoicing



Hi

Simplest way is to make make the salesline field mandatory.

PRASANNA

--- In Axapta-Knowledge- [EMAIL PROTECTED] ups.com, Axapta Material
axapta_material@ ... wrote:

 Hi all,
 
 I am doing a customization where I have to make delivery field in
sales line mandatory.
 I have to do validation before invoicing ..If the delivery date is
empty then don't let the user invoice the sales order and give message
that the delivery date field is mandatory.
 
 I am trying the best way to do it.Where should i put the code since
if the date field is empty I have to send false for invoicing?
 Any suggestions or help?
 Thanks in advance



 














  __
Sent from Yahoo! Mail.
A Smarter Email http://uk.docs.yahoo.com/nowyoucan.html

Re: [Axapta-Knowledge-Village] Re: Registration Access rights

2008-06-23 Thread Girish Bhatkal
we should never modify the temporary property of standard AX tables, by doing 
so you will lose the functionality (unless you go and modify the classes 
appropriately). Since these tables are created for a specific purpose it would 
be a BAD idea to change the temporary property to No.
 
      I think you must be missing rights on some other table (even though you 
cannot individually set rights on temporary table they must be enabled for some 
other user group). If nothing works then the last thing you could try is to 
take off the security key from that temporary table.
 
regards
Girish

--- On Mon, 23/6/08, L Kalaiarasi [EMAIL PROTECTED] wrote:

From: L Kalaiarasi [EMAIL PROTECTED]
Subject: [Axapta-Knowledge-Village] Re: Registration Access rights
To: Axapta-Knowledge-Village@yahoogroups.com
Date: Monday, 23 June, 2008, 6:58 AM






Hi,

Anytable that starts with tmp is a temperary table that is mostly 
used in reports/processes to store the intermediate output. You can 
check the property of the table. Temperary is set to 'Yes' for all 
the tables start with 'tmp'. No temperary table is shown in the 
security map though the security key is set. 

Choice 1:
You can remove the security key of this table. So that it can be 
accessed freely in the reports/processes.

Choice 2:
Can set the temperary property to No and grant the security key. 
But it affects the way the table is handled in Ax. 

I think that the better choice is to remove the security key.

Regards
Kalaiarasi

--- In Axapta-Knowledge- [EMAIL PROTECTED] ups.com, kardo_ax 
[EMAIL PROTECTED] . wrote:

 Hi all,
 
 Whenever a user is trying to access the registration form from PO 
line -
 --- Inventory --- registration, the following message is showing:
 
 Not enough rights to use table: Registration/ Picking 
 (TmpInventTramsWMS) 
 
 This table doesnt appear under invent tables as its security key 
 property is set to.
 
 What is the way to solve this issue?
 
 Thanks


 














  __
Sent from Yahoo! Mail.
A Smarter Email http://uk.docs.yahoo.com/nowyoucan.html

Re: [Axapta-Knowledge-Village] Arabization of Axapta

2006-05-10 Thread Girish Bhatkal



you can contact your local microsoft office to provide
the label files ( i am not aware of labels in arabic
language). If you need to change it yourself an arabic
language license is available (especially for the
labels which you have changed) then you need to find
the each label while selecting the languages in the
advanced tab , go to each label and then write the
description against the label for the specific
language. 



--- Khurram Zaki [EMAIL PROTECTED] wrote:


-
Hello everyone...

I am interested in changing the labels, input text and
reports in
Axapta to Arabic language. Need a clue as to where to
start from. Is
there a way we can change all the labels to some other
language.
Similarly, I am looking for storing data in Arabic and
later
retreiving that via Crystal Reports.

I would appreciate if any one of you who have worked
on localization
to any other language can guide me through ... I need
some pointers to
start the thought process :)

Cheers!
Have a happy day.

Khurram


Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.

 

 SPONSORED LINKS 
 
Business finance course 
 Business to business finance 
 Small business finance 
 Business
finance consultant 
Business finance magazine 
 Business finance schools 
 
 
-
 YAHOO! GROUPS LINKS

 
 Visit your group Axapta-Knowledge-Village on the
web.
 
 To unsubscribe from this group, send an email to:
 [EMAIL PROTECTED]
 
 Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service.

 
-





  
___ 
NEW - Yahoo! 360 – Your one place to blog, create, publish and share! http://uk.360.yahoo.com






Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.








  
  
SPONSORED LINKS
  
  
  

Business finance course
  
  
Business to business finance
  
  
Small business finance
  
  


Business finance consultant
  
  
Business finance magazine
  
  
Business finance schools
  
  

   
  







  
  
  YAHOO! GROUPS LINKS



  Visit your group "Axapta-Knowledge-Village" on the web.
  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] posting through X++ code

2006-05-10 Thread Girish Bhatkal



There is nothing wrong in the code which sundar had
mentioned if you need to only post and print ones,but
if you want to go back and reprint the packing slip
(from say Purchase form / inquires) it would not be
possible as no entries were made in the purchParmline
table.
alternately you can try the below code
here you might have to change a few lines depending
upon your requirement: 

 purchFormLetter =
PurchFormLetter::construct(DocumentStatus::PackingSlip);
 purchFormLetter.createParmUpdate();
 purchFormLetter.createParmTable( purchParmTable,
purchTable);
 purchParmTable.Num = packingSlipId; 
 purchParmTable.insert();
 while select purchLine
 where purchLine.PurchId == purchTable.purchId
  (purchLine.RemainPurchPhysical  0)
 {
 purchParmLine.ParmId = purchParmTable.ParmId;
 purchParmLine.InitFromPurchLine(purchLine);
 purchParmLine.ReceiveNow =
purchLine.RemainPurchPhysical;
 
purchParmLine.setQty(DocumentStatus::PackingSlip,
false, true);
 purchParmLine.setLineAmount();
 purchParmLine.insert();
 }
 purchFormLetter.proforma (false);
 purchFormLetter.printFormLetter(true);
 purchFormLetter.specQty (PurchUpdate::All);
 purchFormLetter.transDate (today());
 purchFormLetter.run();


hope this helps.

cheers,
Girish
--- Sundararajan.T - Software Engineer (Enterprise
Solutions Practice) - SIS
[EMAIL PROTECTED] wrote:


-
Hi,
 you can Update the Receive now quantity in Purchline
 Can post the Purchase order with the following code

purchFormLetter =
PurchFormLetter::construct(DocumentStatus::packingslip);
 purchFormLetter.transDate(SystemDateGet());
 purchFormLetter.update(purchTable,abcd,
 purchFormLetter.transDate(SystemDateGet()),
 PurchUpDate::receivenow,AccountOrder::None,
 false,
 false);


Regards
Sundar

-Original Message-
From: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED]
Behalf Of gopala
krishna
Sent: Wednesday, May 10, 2006 10:01 AM
To: axapta-knowledge-village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] posting through
X++ code


hi,
 I want to post the purchase order thru x++.
 And i should be able to post only qty 50 even if
have qty 100 in my purchase line.
 
 which class can i use. and which method.
 
 thanks,
 Gopal.
 

 
-
Yahoo! India Answers: Share what you know. Learn
something new. Click here
Send instant messages to your online friends - NOW

[Non-text portions of this message have been removed]




Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends. 
Yahoo! Groups Links



 



Sundararajan.T - Software Engineer (Enterprise
Solutions Practice) - SIS
[EMAIL PROTECTED]

___

Visit us at www.sundaraminfotech.in
___

This E-mail may contain privileged information and is
intended solely for the addressee, and any disclosure
of this information is strictly prohibited, and may be
unlawful. If you have received this mail by mistake,
please inform us immediately and delete this mail. 
Any information expressed in this mail does not
necessarily reflect the views of SUNDARAM INFOTECH
SOLUTIONS. As per SUNDARAM INFOTECH SOLUTIONS's
policy, unencrypted mail via Internet is not
considered secure.
___


Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.

 

 SPONSORED LINKS 
 
Business finance course 
 Business to business finance 
 Small business finance 
 Business
finance consultant 
Business finance magazine 
 Business finance schools 
 
 
-
 YAHOO! GROUPS LINKS

 
 Visit your group Axapta-Knowledge-Village on the
web.
 
 To unsubscribe from this group, send an email to:
 [EMAIL PROTECTED]
 
 Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service.

 
-




Send instant messages to your online friends http://uk.messenger.yahoo.com 






Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.








  
  
SPONSORED LINKS
  
  
  

Business finance course
  
  
Business to business finance
  
  
Small business finance
  
  


Business finance consultant
  
  
Business finance magazine
  
  
Business finance schools
  
  

   
  







  
  
  YAHOO! GROUPS LINKS



  Visit your group "Axapta-Knowledge-Village" on the web.
  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] Problem on InventDimId

2006-04-13 Thread Girish Bhatkal
i am not sure if i understand your query completly,
but i think you want to know how to get the
inventDimId in the purchase line. if yes then
while creating the purchase line you need to include

inventDim.clear();
inventDim.InventLocationId = xxx; // warehouse
//. you can include for other elements too else
can leave without entering any dimensions.

purchLine.inventDimId =
InventDim::findOrCreate(inventDim).InventDimId;


have a great week end.
cheers,
Girish

--- janasomnath786 [EMAIL PROTECTED] wrote:


-
Hi Girish 

This is Somnath Jana from India, Kolkata ,Salt lake 

I have gone through the mail text (below text) which
is clear to me. 

   Girish Bhatkal [EMAIL PROTECTED] wrote:
   Priyank, are you sure you want to use Profit/loss
   journal to include the opening inventory in the
   system. I feel using Movement journal is a more
   appropriate one to include the opening inventory.
It would be better if other people also gives
   their opinions on which journal to be used.

   --- Subrahmanyam, Mamidi [EMAIL PROTECTED]
wrote:

Hi Priyanka,
 
You need to assign the inventdim programatically
if
you have to attach inventdim. I remeber Girish
posted  some sample code in the past..
 
the code looks like below...
 
Tablename yourTable;
InventDim inventDim;
   ..
 
But I faced a new problem regarding InventDimId.
Please try to 
help me.

Problem :

I am inserting data from a external tables, into
PurchTable and also 
to PurchLine. Inserting data into PurchTable is
working fine, but 
when inserting number of entries (items) to PurchLine
it throws 
error on InventDimId.

The error message as

Item identification cannot be changed when inventory
transactions 
have been generated. 
=
Now my question is how to find InventDimId from
InventDim Table.
I use the code as given below and few assignment also.
InventDim::findorcreate(inventDim).InventDimId;
but failed.

Please provide me the actual code instructions. I know
the insert 
method exist in both PurchTable and also PurchLine -
is this insert 
method creates the proble. 
Please try to solve as soon as possible.

Thanks and regards
Somnath Jana
India, Kolkata 






















Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.

  

  SPONSORED LINKS  
   
Business finance course   
Business to business finance  
 Small business finance   
Business
finance consultant   
Business finance magazine 
  Business finance schools


-
  YAHOO! GROUPS LINKS

  
Visit your group Axapta-Knowledge-Village on the
web.
   
To unsubscribe from this group, send an email to:
 [EMAIL PROTECTED]
   
Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service.

  
-






___ 
Yahoo! For Good - Sponsor a London Marathon runner - 
http://uk.promotions.yahoo.com/charity/london-marathon


Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends. 
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] How to convert Real value to String value

2006-04-10 Thread Girish Bhatkal
Hi Jana,
   Whenever you need to find any function look at
AOT/SystemDocumentation/Functions.  here you will find
the various functions available in axapta.
  If you select (double click) the function , these
functions are explained with an example.

cheers,
Girish

--- somnath jana [EMAIL PROTECTED] wrote:


-
Hi vk 
   
  use the function num2str();
   
  as
   
  Num2Str (real number,int characters,int decimals,int
separator1,int 
separator2)
   
  Num2Str(12345.6,10,2,2,1)
returns 12.345,60.
Num2Str(12345.6,1,0,1,0)
returns 12346.

  thanks
  Somnath Jana 
  (Ontrack Systems Ltd,  INDIA)
  
vk [EMAIL PROTECTED] wrote:
  Hi,
  How to convert the Real value as a String? for
example the real value as 0.00,i have converted into
empty string.how it is possible.please any one help
me.
   
  regards,
  vijay

Send instant messages to your online friends
http://uk.messenger.yahoo.com 

[Non-text portions of this message have been removed]



Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends. 



-
  YAHOO! GROUPS LINKS 


Visit your group Axapta-Knowledge-Village on the
web.

To unsubscribe from this group, send an email to:
 [EMAIL PROTECTED]

Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service. 


-
  




-
How low will we go? Check out Yahoo! Messenger’s low 
PC-to-Phone call rates.

[Non-text portions of this message have been removed]



Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.

  

-
  YAHOO! GROUPS LINKS

  
Visit your group Axapta-Knowledge-Village on the
web.
   
To unsubscribe from this group, send an email to:
 [EMAIL PROTECTED]
   
Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service.

  
-








___ 
Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail 
http://uk.messenger.yahoo.com


Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends. 
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] Sales Tax

2006-02-13 Thread Girish Bhatkal
while setting the Misc charges, in the general tab did
you select the Vat groups?

--- matt [EMAIL PROTECTED] wrote:


-
I'm trying to set-up sales tax.  I'm having trouble
getting the Misc 
Charges(Shipping  Handling) be included in the sales
tax.  Can anyone 
tell me how this is done?  Thanks

MAtt 









Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.

  

  SPONSORED LINKS  
   
Business finance course   
Business to business finance  
 Small business finance   
Business
finance consultant   
Business finance magazine 
  Business finance schools


-
  YAHOO! GROUPS LINKS

  
Visit your group Axapta-Knowledge-Village on the
web.
   
To unsubscribe from this group, send an email to:
 [EMAIL PROTECTED]
   
Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service.

  
-






___ 
NEW Yahoo! Cars - sell your car and browse thousands of new and used cars 
online! http://uk.cars.yahoo.com/


Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends. 
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] Fresh Produce

2006-01-24 Thread Girish Bhatkal
our organisation (Index computer systems, in UK) is
working on fresh produce module and are already live
with a few customers.

--- Craig Fidler [EMAIL PROTECTED] wrote:


-
Hi

 

Anyone working on a fresh produce vertical?

 


The views expressed in this email are, unless
otherwise stated, those of the author and not those
of the BS3 Group or its management.  The information
in this e-mail is confidential and is intended 
solely for the addressee. Access to this e-mail by
anyone else is unauthorised. If you are not 
the intended recipient, any disclosure, copying,
distribution or any action taken or omitted in 
reliance on this, is prohibited and may be unlawful. 
Whilst all reasonable steps are taken to 
ensure the accuracy and integrity of information and
data transmitted electronically and to preserve 
the confidentiality thereof, no liability or
responsibility whatsoever is accepted if information
or data is, for whatever reason corrupted or does not
reach its intended destination.


[Non-text portions of this message have been removed]



Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.

  

-
  YAHOO! GROUPS LINKS

  
Visit your group Axapta-Knowledge-Village on the
web.
   
To unsubscribe from this group, send an email to:
 [EMAIL PROTECTED]
   
Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service.

  
-








___ 
Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail 
http://uk.messenger.yahoo.com


Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends. 
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] Fresh Produce

2006-01-24 Thread Girish Bhatkal
our organisation is working on fresh produce module
and are already live with a few customers.

--- Craig Fidler [EMAIL PROTECTED] wrote:


-
Hi

 

Anyone working on a fresh produce vertical?

 


The views expressed in this email are, unless
otherwise stated, those of the author and not those
of the BS3 Group or its management.  The information
in this e-mail is confidential and is intended 
solely for the addressee. Access to this e-mail by
anyone else is unauthorised. If you are not 
the intended recipient, any disclosure, copying,
distribution or any action taken or omitted in 
reliance on this, is prohibited and may be unlawful. 
Whilst all reasonable steps are taken to 
ensure the accuracy and integrity of information and
data transmitted electronically and to preserve 
the confidentiality thereof, no liability or
responsibility whatsoever is accepted if information
or data is, for whatever reason corrupted or does not
reach its intended destination.


[Non-text portions of this message have been removed]



Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.

  

-
  YAHOO! GROUPS LINKS

  
Visit your group Axapta-Knowledge-Village on the
web.
   
To unsubscribe from this group, send an email to:
 [EMAIL PROTECTED]
   
Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service.

  
-






___ 
NEW Yahoo! Cars - sell your car and browse thousands of new and used cars 
online! http://uk.cars.yahoo.com/


Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends. 
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] creating sales line

2005-12-30 Thread Girish Bhatkal
Manoj,

  you can refer the following to create the
functionality. 

static void createSalesLine(Args _args)
{
salesLine   _salesLine;
salesLine   salesLine;// original sales line
salesQtynewQty = 5; // new sales qty
salesTable  salesTable =
SalesTable::find(salesLine.SalesId);
;
_salesLine.clear();
_salesLine.initFromSalesTable(salesTable);
_salesLine.initFromSalesLine(salesLine,true,true);
_salesLine.SalesQty   = newQty;
salesLine::modifySalesQty(_salesLine,inventDim::find(_salesLine.InventDimId));
_salesLine.LineAmount =
_salesLine.calcLineAmount(_salesLine.SalesQty);
_salesLine.createLine(false,false,false,true,false,false,false);
}

cheers,
Girish


--- manoj kumar [EMAIL PROTECTED] wrote:

 Hi Girish,

  I have done that, while inserting it is
 updating the same record as it accessing the same
 recordset.I need to create a new record for the same
 sales order for which i have to retrieve values from
 the sales header and first sales line. Can you help
 how to create a new record..

   Regards,
   Manoj
 
 manoj kumar [EMAIL PROTECTED] wrote:
 Hi Girish,

I can return the mod value or multiples of 10 but
 not the both and  where to create this sales
 line.Whether to write in salestable- datasource-
 salesline-salesqty -modified method or in
 saleslinecreate function. Please suggest
   regards,
   Manoj
 
 Girish Bhatkal [EMAIL PROTECTED] wrote:
   you need to make modification to achieve this.
 here
 below is a hint:
 
 Qty  =  salesLine.salesQty mod 10; // Qty would be
 the
 remainder
 
 if(QTY != 0)
 {
   write code to pop up the decision buttona and then
 update the sales line and then create a new line
 with
 salesQty = Qty.
 }
 
 hope this is helpful.
 
 cheers,
 Girish
 --- manoj kumar [EMAIL PROTECTED] wrote:
 
  
  Hi   when i create a sales order and if the
 quantity
  is not in multiple of tens, for eg.,i create sales
  order for 15 quantity, system will ask to do it
 for
  20, because i set it in multiples of 10.Now when i
  click no, then salesorder for 10 quantity should
 be
  done and as well as remaining 5 quantity is also
  done in another line with same details like ware
  house,item number and all. Please any body help..
 
   Thanks,
   Manoj
  
  Send instant messages to your online friends
  http://in.messenger.yahoo.com 
 
 
 
 

___
 
 NEW Yahoo! Cars - sell your car and browse thousands
 of new and used cars online!
 http://uk.cars.yahoo.com/
 
 
 Sharing the knowledge on Axapta.
 Visit www.frappr.com/axapta for axapta friends. 
 
   
 
   Send instant messages to your online friends
 http://in.messenger.yahoo.com 
 
 Sharing the knowledge on Axapta.
 Visit www.frappr.com/axapta for axapta friends. 
 
 
 
 
 -
   YAHOO! GROUPS LINKS 
 
 
 Visit your group Axapta-Knowledge-Village on
 the web.
 
 To unsubscribe from this group, send an email
 to:
 
 [EMAIL PROTECTED]
 
 Your use of Yahoo! Groups is subject to the
 Yahoo! Terms of Service. 
 
 
 -
   
 
   
 
 
 Send instant messages to your online friends
 http://in.messenger.yahoo.com 




___ 
Yahoo! Photos – NEW, now offering a quality print service from just 8p a photo 
http://uk.photos.yahoo.com


 Yahoo! Groups Sponsor ~-- 
Put more honey in your pocket. (money matters made easy).
http://us.click.yahoo.com/F9LvrA/dlQLAA/cosFAA/kGEolB/TM
~- 

Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends. 
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] creating sales line

2005-12-29 Thread Girish Bhatkal
Manoj,
  
   Where to write the code depends on many factors.
Should this functionality also be valid if sales line
are created from any other place ? Its always advised
not to write functions on the forms . you could check
this validation on table salesLine validatewrite
method. you can call the function (to calculate and
create salesline, better write it in a class) from
this method.
There could be some better ways but this just came
in the mind.

You do can write function to calculate the multiple of
10 and remainder value, both. logic could be
int Multi10 = salesqty / 10;
int partial = salesqty mod 10;

if partial is not equal to 10 then give a message and
if selected No then create a new line for partial qty
and update the present line with qty Multi10 * 10.
if selected Yes then update the present line with
(Multi10 + 1) * 10.
   you can find out a different logic to calculate,
the above is one of the way to calculate. 
i am not sure why you need to return a value. for some
reason if you want to return multiple values then you
need to use containers.

cheers,
Girish
   

--- manoj kumar [EMAIL PROTECTED] wrote:

 Hi Girish,

I can return the mod value or multiples of 10 but
 not the both and  where to create this sales
 line.Whether to write in salestable- datasource-
 salesline-salesqty -modified method or in
 saleslinecreate function. Please suggest
   regards,
   Manoj
 
 Girish Bhatkal [EMAIL PROTECTED] wrote:
   you need to make modification to achieve this.
 here
 below is a hint:
 
 Qty  =  salesLine.salesQty mod 10; // Qty would be
 the
 remainder
 
 if(QTY != 0)
 {
   write code to pop up the decision buttona and then
 update the sales line and then create a new line
 with
 salesQty = Qty.
 }
 
 hope this is helpful.
 
 cheers,
 Girish
 --- manoj kumar [EMAIL PROTECTED] wrote:
 
  
  Hi   when i create a sales order and if the
 quantity
  is not in multiple of tens, for eg.,i create sales
  order for 15 quantity, system will ask to do it
 for
  20, because i set it in multiples of 10.Now when i
  click no, then salesorder for 10 quantity should
 be
  done and as well as remaining 5 quantity is also
  done in another line with same details like ware
  house,item number and all. Please any body help..
 
   Thanks,
   Manoj
  
  Send instant messages to your online friends
  http://in.messenger.yahoo.com 
 
 
 
 

___
 
 NEW Yahoo! Cars - sell your car and browse thousands
 of new and used cars online!
 http://uk.cars.yahoo.com/
 
 
 Sharing the knowledge on Axapta.
 Visit www.frappr.com/axapta for axapta friends. 
 
 
 
   SPONSORED LINKS 
 Business finance course   Business to
 business finance   Small business finance
 Business finance consultant   Business finance
 magazine   Business finance schools 
 
 -
   YAHOO! GROUPS LINKS 
 
 
 Visit your group Axapta-Knowledge-Village on
 the web.
 
 To unsubscribe from this group, send an email
 to:
 
 [EMAIL PROTECTED]
 
 Your use of Yahoo! Groups is subject to the
 Yahoo! Terms of Service. 
 
 
 -
   
 
   
 
 
 Send instant messages to your online friends
 http://in.messenger.yahoo.com 




___ 
Yahoo! Exclusive Xmas Game, help Santa with his celebrity party - 
http://santas-christmas-party.yahoo.net/


 Yahoo! Groups Sponsor ~-- 
Put more honey in your pocket. (money matters made easy).
http://us.click.yahoo.com/F9LvrA/dlQLAA/cosFAA/kGEolB/TM
~- 

Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends. 
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] creating sales line

2005-12-28 Thread Girish Bhatkal
you need to make modification to achieve this. here
below is a hint:

Qty  =  salesLine.salesQty mod 10; // Qty would be the
remainder

if(QTY != 0)
{
  write code to pop up the decision buttona and then
update the sales line and then create a new line with
salesQty = Qty.
}

hope this is helpful.

cheers,
Girish
--- manoj kumar [EMAIL PROTECTED] wrote:

 
 Hi   when i create a sales order and if the quantity
 is not in multiple of tens, for eg.,i create sales
 order for 15 quantity, system will ask to do it for
 20, because i set it in multiples of 10.Now when i
 click no, then salesorder for 10 quantity should be
 done and as well as remaining 5 quantity is also
 done in another line with same details like ware
 house,item number and all. Please any body help..

  Thanks,
  Manoj
 
 Send instant messages to your online friends
 http://in.messenger.yahoo.com 




___ 
NEW Yahoo! Cars - sell your car and browse thousands of new and used cars 
online! http://uk.cars.yahoo.com/


 Yahoo! Groups Sponsor ~-- 
Put more honey in your pocket. (money matters made easy).
http://us.click.yahoo.com/F9LvrA/dlQLAA/cosFAA/kGEolB/TM
~- 

Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends. 
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: MST Round-off error in Invoice Approval Journal

2005-12-06 Thread Girish Bhatkal
i had also seen this error at a client's site. and as
subbu has mentioned you need to go to General ledger/
parameters/ledger . here you enter the maximum penny
difference and the maximum penny - rounding in
secondary currency and it should solve the pbm. I am
not a financial expert so i had tried different values
and it worked on 0.02 for me.

good luck,

cheers,
Girish

--- Subrahmanyam, Mamidi [EMAIL PROTECTED] wrote:

   Hi Irving,

   Did you guy make any customization to increase the
 number of decimals?.

   However, we have these kind of problems earlier.
 How we did solve is:

   You may want to go to Parameters of the particular
 module:
   Goto - Settlement  and then try to change max
 penny differences so that code should not ( like
 0.001) if the MST differece = 0.1 . Please change
 the settling for the instalnece to 0.001 ( howber
 form shows 0.00 ). It should solve your problem. I
 bet on this.

   Let me know if this does not solve.
   thanks,
   subbu
 
 Irving [EMAIL PROTECTED] wrote:
   Hi Sun Fen
 
 Thank you for your suggestion, but it didn't solve
 my problem.
 
 It's when I post general expence invoices in the
 Invoice Approval 
 Journal, that I get a penny difference.
 
 Regards
 
 Irving
 
 --- In Axapta-Knowledge-Village@yahoogroups.com, Sun
 Fen Chen 
 [EMAIL PROTECTED] wrote:
 
  Hi Irving,
  
  After you fetch the voucher (after fetching it
 will not balance), 
 you have
  to click Function - Purchase order.
  
  When you post the Invoice approval journal, have
 you clicked 
 Function -
  Purchase order in the Invoice journal line?
  This will post the purchase order invoice from
 Invoice journal.
  
  
  Regards,
  Sun Fen
  
  
  On 12/5/05, Irving [EMAIL PROTECTED] wrote:
  
   Dear All
  
   Thanks for the input, but I'm afraid it didn't
 solve my problem.
  
   The different account are set up correctly so
 I'm able to post 
 penny
   differences.
   I can find round-off setup at GL/Setup/Exchange
 Rates, but I 
 can't
   find any setup concerning secondary currency.
  
   Any input will be welcome, Thanks
  
   Regards
  
   koffidan
  
   --- In Axapta-Knowledge-Village@yahoogroups.com,
 Tarek Saleh
   [EMAIL PROTECTED] wrote:
   
Dear Asrar
   
   The penny differances must have an account
 in GL befor setup
   its parameter thes account is located in the
 system accounts 
 setup
   (GL\setup\posting\system accounts) and u should
 define a ledger
   account for thes  penny differance system
 account befor setup the
   parameter,
  and about the folowing error you should
 check the vendor 
 posting
   profile and the vendor setup for currency.
   
  Feed back after testing
  All the best
  Tarek saleh
   
Asrar Ahamed [EMAIL PROTECTED] wrote:
Hi,
   
  Set up penny difference field under
 GL/Parameters/Ledger.
  Thanks,
   
   
Irving [EMAIL PROTECTED] wrote:
  I have posted an invoice in the Invoice
 Register Journal:
   
Then I go to the Invoice Approval Journal and
 fetch the posted
voucher/invoice. When I post the Invoice
 Approval Journal I get
   the
following error message:
   
Message (08:23:39)
Voucher 'god-00159', date '09-11-2005',
 account '7521', amount
currency '0,01', amount MST '0,01',
 alternative amount '0,00',
currency 'DKK', text ''
   
Voucher 'god-00159', date '09-11-2005',
 account '7521', amount
currency '-25,25', amount MST '-25,25',
 alternative 
 amount '0,00',
currency 'DKK', text ''
   
Voucher 'god-00159', date '09-11-2005',
 account '7521', amount
currency '13,88', amount MST '13,88',
 alternative 
 amount '0,00',
currency 'DKK', text ''
   
Voucher 'god-00159', date '09-11-2005',
 account '7521', amount
currency '11,38', amount MST '11,38',
 alternative 
 amount '0,00',
currency 'DKK', text ''
   
Voucher 'god-00159', date '09-11-2005',
 account '7411', amount
currency '-126,25', amount MST '-126,25',
 alternative
   amount '0,00',
currency 'DKK', text 'test'
   
Voucher 'god-00159', date '09-11-2005',
 account '7412', amount
currency '126,25', amount MST '126,25',
 alternative 
 amount '0,00',
currency 'DKK', text 'test'
   
Voucher 'god-00159', date '09-11-2005',
 account '7421', amount
currency '-101,00', amount MST '-101,00',
 alternative
   amount '0,00',
currency 'DKK', text 'test'
   
Voucher 'god-00159', date '09-11-2005',
 account '3731', amount
currency '55,50', amount MST '55,50',
 alternative 
 amount '0,00',
currency 'DKK', text 'test'
   
Voucher 'god-00159', date '09-11-2005',
 account '6321', amount
currency '45,50', amount MST '45,50',
 alternative 
 amount '0,00',
currency 'DKK', text 'test'
   
Voucher 'god-00159', date '09-11-2005',
 account '3781', amount
currency '0,00', amount MST '-0,02',
 alternative amount '0,00',
currency 'DKK', text 'Øredifferencer, Bilag
 god-0015'
   
The transactions on voucher 

RE: [Axapta-Knowledge-Village] Invoice updating of PO

2005-12-01 Thread Girish Bhatkal
sorry, i could not understand your query. do you want
to neglect the under delivery functionality and always
close the order after posting the invoice with the
received qty? If yes, then you will have to make
modification to achieve this.
  

--- Nihar Saraiya [EMAIL PROTECTED]
wrote:

 Hi Girish
  
 I am aware of Under Delivery functionality and how
 it is set up. My question
 is can we have a work around of Invoice Updating the
 PO with 'receive'
 quantity only, ofcourse with setting the check box
 for 'Close' at line
 level.
  
 Am i asking a bit more of functionality in Axapta?
  
 Nihar
 
   _  
 
 From: Girish Bhatkal
 [mailto:[EMAIL PROTECTED] 
 Sent: Wednesday, November 30, 2005 7:58 PM
 To: Axapta-Knowledge-Village@yahoogroups.com
 Subject: RE: [Axapta-Knowledge-Village] Invoice
 updating of PO
 
 
 Did you also enable on the purchase ledger
 parameters/
 updates tab the field accept under-delivery? 
 it works with both the combination of entering
 the
 percentage on the PO line and also it should be
 enabled on the parameters.
 
 --- Nihar Saraiya
 [EMAIL PROTECTED]
 wrote:
 
  Hi Girish
   
  I tried what u said at PO line level.
  After allowing the underdelivery percentage, i got
 a
  message,
  'Under-delivery of line is 52.38 percentage, but
 the
  allowed under-delivery
  is only 52.38 percent.
   
  Am i still missing something very basic!!
   
  nihar
  
_  
  
  From: Girish Bhatkal
  [mailto:[EMAIL PROTECTED] 
  Sent: Wednesday, November 30, 2005 5:38 PM
  To: Axapta-Knowledge-Village@yahoogroups.com
  Subject: Re: [Axapta-Knowledge-Village] Invoice
  updating of PO
  
  
  yes, you need to allow under delivery (set the
  percentage on the Po line also enable accept
  underdelivery on the purchase ledger parameters).
  you
  could also set it on the item master.
  
  
  --- Nihar Saraiya
  [EMAIL PROTECTED]
  wrote:
  
   Hi All

   A small scenario.

   I have PO with an item line of quantity 13
 units. 
   Updated the PO having entered, units 'Received'
 as
   10.
   Posting Receipt List and Packing List with 10
  units.

   Now i want to close the PO, as i will not be
   receiving remaining 3 units.
   How this has to be done?
   While Posting Invoice, in the Quantity field in
  the
   Parameter tab i selected
   'Receive now' and at the line level, lines tab i
  set
   the checkbox for
   'Close'. Iwas not able to post the invoice since
  the
   infolog gave Under
   Delivery error.

   I dont think to cancel the remaining units i
 need
  to
   set the
   'Under-delivery'.

   What am i missing?

   Regards
   Nihar Saraiya,
   
   Confidentiality Notice
   
   This email is confidential and may also be
   privileged. If you are not the
   intended recipient please notify the sender
   immediately. You must not copy
   or use it for any purpose or disclose its
 contents
   to any other person. The
   sender accepts no responsibility for viruses
   received with or changes made
   to this email after it was sent. Any opinion
   expressed in this email may be
   personal to the sender.
   

   
  
  
  
  
 

___
  
  Yahoo! Model Search 2005 - Find the next catwalk
  superstars -
  http://uk.news.yahoo.com/hot/model-search/
 http://uk.news.yahoo.com/hot/model-search/ 
  http://uk.news.yahoo.com/hot/model-search/
 http://uk.news.yahoo.com/hot/model-search/  
  
  
  Sharing the knowledge on Axapta. 
  
  
  
  
  SPONSORED LINKS 
  Business finance course   Business to business
  finance   Small
  business finance   
  Business finance consultant   Business finance
  magazine   Business
  finance schools   
  
_  
  
  YAHOO! GROUPS LINKS 
  
  

  *  Visit your group Axapta-Knowledge-Village
 

http://groups.yahoo.com/group/Axapta-Knowledge-Village

http://groups.yahoo.com/group/Axapta-Knowledge-Village
 
   on the web.

  
  *  To unsubscribe from this group, send an
 email to:
  
 
 [EMAIL PROTECTED]
 

mailto:[EMAIL PROTECTED]
  ribe 

  
  *  Your use of Yahoo! Groups is subject to the
  Yahoo! Terms of Service
  http://docs.yahoo.com/info/terms/
 http://docs.yahoo.com/info/terms/  .
 
  
  
_  
  
  
  
 
 
 
 

___
 
 To help you stay safe and secure online, we've
 developed the all new Yahoo!
 Security Centre. http://uk.security.yahoo.com
 http://uk.security.yahoo.com
 
 
 
=== message truncated ===






___ 
Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail 
http://uk.messenger.yahoo.com


 Yahoo! Groups Sponsor ~-- 
Put more honey in your pocket. (money matters made easy).
http://us.click.yahoo.com/F9LvrA/dlQLAA/cosFAA/kGEolB/TM

RE: [Axapta-Knowledge-Village] Invoice updating of PO

2005-11-30 Thread Girish Bhatkal
Did you also enable on the purchase ledger parameters/
updates tab the field accept under-delivery? 
it works with both the combination of entering the
percentage on the PO line and also it should be
enabled on the parameters.

--- Nihar Saraiya [EMAIL PROTECTED]
wrote:

 Hi Girish
  
 I tried what u said at PO line level.
 After allowing the underdelivery percentage, i got a
 message,
 'Under-delivery of line is 52.38 percentage, but the
 allowed under-delivery
 is only 52.38 percent.
  
 Am i still missing something very basic!!
  
 nihar
 
   _  
 
 From: Girish Bhatkal
 [mailto:[EMAIL PROTECTED] 
 Sent: Wednesday, November 30, 2005 5:38 PM
 To: Axapta-Knowledge-Village@yahoogroups.com
 Subject: Re: [Axapta-Knowledge-Village] Invoice
 updating of PO
 
 
 yes, you need to allow under delivery (set the
 percentage on the Po line also enable accept
 underdelivery on the purchase ledger parameters).
 you
 could also set it on the item master.
 
 
 --- Nihar Saraiya
 [EMAIL PROTECTED]
 wrote:
 
  Hi All
   
  A small scenario.
   
  I have PO with an item line of quantity 13 units. 
  Updated the PO having entered, units 'Received' as
  10.
  Posting Receipt List and Packing List with 10
 units.
   
  Now i want to close the PO, as i will not be
  receiving remaining 3 units.
  How this has to be done?
  While Posting Invoice, in the Quantity field in
 the
  Parameter tab i selected
  'Receive now' and at the line level, lines tab i
 set
  the checkbox for
  'Close'. Iwas not able to post the invoice since
 the
  infolog gave Under
  Delivery error.
   
  I dont think to cancel the remaining units i need
 to
  set the
  'Under-delivery'.
   
  What am i missing?
   
  Regards
  Nihar Saraiya,
  
  Confidentiality Notice
  
  This email is confidential and may also be
  privileged. If you are not the
  intended recipient please notify the sender
  immediately. You must not copy
  or use it for any purpose or disclose its contents
  to any other person. The
  sender accepts no responsibility for viruses
  received with or changes made
  to this email after it was sent. Any opinion
  expressed in this email may be
  personal to the sender.
  
   
  
 
 
 
 

___
 
 Yahoo! Model Search 2005 - Find the next catwalk
 superstars -
 http://uk.news.yahoo.com/hot/model-search/
 http://uk.news.yahoo.com/hot/model-search/ 
 
 
 Sharing the knowledge on Axapta. 
 
 
 
 
 SPONSORED LINKS 
 Business finance course   Business to business
 finance   Small
 business finance  
 Business finance consultant   Business finance
 magazine  Business
 finance schools   
 
   _  
 
 YAHOO! GROUPS LINKS 
 
 
   
 *  Visit your group Axapta-Knowledge-Village

http://groups.yahoo.com/group/Axapta-Knowledge-Village
  on the web.
   
 
 *  To unsubscribe from this group, send an email to:
 
 [EMAIL PROTECTED]

mailto:[EMAIL PROTECTED]
 ribe 
   
 
 *  Your use of Yahoo! Groups is subject to the
 Yahoo! Terms of Service
 http://docs.yahoo.com/info/terms/ . 
 
 
   _  
 
 
 




___ 
To help you stay safe and secure online, we've developed the all new Yahoo! 
Security Centre. http://uk.security.yahoo.com


 Yahoo! Groups Sponsor ~-- 
Put more honey in your pocket. (money matters made easy).
http://us.click.yahoo.com/F9LvrA/dlQLAA/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] Vendor invoices

2005-11-30 Thread Girish Bhatkal
let me know if my understanding of the requirement is
right. 
a. The supplier sends the packing slip per order (if
some orders are received in parts then multipe packing
slips are received).
b. the supplier then sends the invoice which has
multple packing included in it (the list of delivery
notes is available on the invoice).
c. now you want to post the invoice by delivery notes.


If my understanding is right, then you need to make
changes to achieve this requirement . Using standard
functionality this cannot be achieved. I remember
there were a few discussion earlier also regarding a
similar requirement.



--- Syner P [EMAIL PROTECTED] wrote:

 Hello,

   I am new to Axapta and have a problem about
 invoice recording.
   We have purchase orders related with a supplier.
   They send us a packing slip per order but a
 combined invoices including more than one order.
   How can can I record this invoices and match with
 corresponding packing slips ?

   Thanks



 
   
 -
  Yahoo! Personals
  Single? There's someone we'd like you to meet.
  Lots of someones, actually. Yahoo! Personals






___ 
Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail 
http://uk.messenger.yahoo.com


 Yahoo! Groups Sponsor ~-- 
Help Sudanese refugees rebuild their lives through GlobalGiving.
http://us.click.yahoo.com/V42rFC/EbOLAA/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] Harry ! this one for u: Journal Upload

2005-10-31 Thread Girish Bhatkal
Priyank, are you sure you want to use Profit/loss
journal to include the opening inventory in the
system. I feel using Movement journal is a more
appropriate one to include the opening inventory.
It would be better if other people also gives
their opinions on which journal to be used.

--- Subrahmanyam, Mamidi [EMAIL PROTECTED] wrote:

 Hi Priyanka,
  
 You need to assign the inventdim programatically if
 you have to attach inventdim. I remeber Girish
 posted  some sample code in the past..
  
 the code looks like below...
  
 Tablename yourTable;
 InventDim inventDim;
  
 ;
  inventDim.clear();
  
  inventDim.configId = 'configid'  // coming from
 external source like flat file;
  inventDim.inventLocationId = 'your ware
 house';//coming from external source like flat file;
  
 your can attach your InventDimId to yor table like
 this
  
  yourTable.inventDimId =
 InventDim::findorcreate(inventDim).InventDimId;
  
  
 this is just for your infoPlease browse the
 forum for the more details .
  
 thanks,
 subbu
  
  
  
  
  
  
  
  
 
 
 Priyank Krishna [EMAIL PROTECTED] wrote:
 I have to upload the Profit  Loss Inventory Journal
 for initialising the item stock on-hand in a fresh
 system. I tried it to upload with sample code
 mentioned in your site.The code is fabulous but I
 could not upload Inventory Journal since there is
 InventDim Datasource is attached additionally with
 its transactions form. Pls help how to tackle it.
  
 Thanks in advance !
  
 Priyank
 
 
 
 -
 Enjoy this Diwali with Y! India Click here 
 
 Sharing the knowledge on Axapta. 
 
 
 
 SPONSORED LINKS 
 Business finance course Business to business finance
 Small business finance Business finance consultant
 Business finance magazine Business finance schools 
 
 -
 YAHOO! GROUPS LINKS 
 
 
 Visit your group Axapta-Knowledge-Village on
 the web.
   
 To unsubscribe from this group, send an email
 to:
 
 [EMAIL PROTECTED]
   
 Your use of Yahoo! Groups is subject to the
 Yahoo! Terms of Service. 
 
 
 -
 
 
 
   
 -
  Yahoo! FareChase - Search multiple travel sites in
 one click.  




___ 
How much free photo storage do you get? Store your holiday 
snaps for FREE with Yahoo! Photos http://uk.photos.yahoo.com


 Yahoo! Groups Sponsor ~-- 
Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page
http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/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] we have 120 license,but only 110-114user logined and axapta give not enought license message,why?

2005-10-24 Thread Girish Bhatkal
This situation happens when users/clients do not log
off normally from the AOS, an example is that they are
forcing their system to reboot while still connected
on the AOS. This causes the users connection to appear
as still active.

One soluton is as Varden has mentioned You have to
stop both AOS and delete the axdat.udb, then restart
again the AOS cluster.
A drawback on this solution is you need to logoff
all the clients connected to the server before you
shutdown the AOS.


Other soluton is tweaking / adding some keys at the
Windows (OS) registry where the AOS machines are
running.

a) Go to
“HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip”.
b) Add a value (DWORD) by the name “KeepAliveTime”. 
c) Change the value to the time in miliseconds you
require (typically 3-5 minutes, (I.e. 18 to 30
decimal).
d) Reboot the system to make the change take effect.

You should note that the “KEEP_ALIVE” checking in
Windows by default is checking for dead connections
every 2 hours. The connection from the disrupted
client will therefore be active on the system for up
to 2 hours. To reduce this time adjust the AOS
machines TCP/IP settings in the registry (refer to
Microsoft Knowledge Base article: Q158474). The issue
is really that dead connections can only be detected
by using them for transport - and thus the
“”KEEP_ALIVE” packets transmitted should be reduced to
the least acceptable level.

WARNING: Using Registry Editor incorrectly can cause
serious problems that may require you to reinstall
your operating system.


good luck 

cheers,
Girish

--- Varden Morris [EMAIL PROTECTED] wrote:

 
 This is usually a result of the axdat.udb file not
 being properly updated as a result of improper
 
 shutting down of the AOS (Possible power outage or
 the AOS service was stopped while the various
 instances of Axapta were running). You may fix the
 problem by stopping the AOS and deleting the
 axdat.udb file. After startup the problem should go
 away.
 
  
 
 Varden Morris
 
 Senior Developer
 
 WellPoint Systems Inc.
 Suite 2000, 500 - 4th Ave SW
 Calgary, Alberta, Canada 
 T2P 2V6
 
  
 
 (403) 444-5848 direct
 
 (403) 444-3900 main
 
 (403) 615-1604 cell
 
 www.wellpoint.ca
 
 
 [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
 dear all,
   some times we can login 115 users,sometimes we
 only can login 112,and then the system give me the
 following message:
  cannot start navision axapta,as more users are
 running the system than the purchased rights allow.
 
 could some one give me some sollution or advice??
 
 
 
 Best regards, 
   
 qhpeng
 [EMAIL PROTECTED]
 2005-10-24
 
 
 
 
 Sharing the knowledge on Axapta. 
 
 
 
 SPONSORED LINKS 
 Business finance course Business to business finance
 Small business finance Business finance consultant
 Business finance magazine Business finance schools 
 
 -
 YAHOO! GROUPS LINKS 
 
 
 Visit your group Axapta-Knowledge-Village on
 the web.
   
 To unsubscribe from this group, send an email
 to:
 
 [EMAIL PROTECTED]
   
 Your use of Yahoo! Groups is subject to the
 Yahoo! Terms of Service. 
 
 
 -
 
 
 
 
   
 -
  Yahoo! FareChase - Search multiple travel sites in
 one click.  




___ 
How much free photo storage do you get? Store your holiday 
snaps for FREE with Yahoo! Photos http://uk.photos.yahoo.com


 Yahoo! Groups Sponsor ~-- 
Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page
http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/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] Urgent : How to upload data to generate Sales orders

2005-10-22 Thread Girish Bhatkal
even though only SalesTable and SalesLine are required
its important to get the correct InventDimId in the
salesLine table. As everyone knows that the
inventDimId is created depending upon the dimension
combination i dont use the standard axapta template
import.
   I would write a function and use it to import the
sales orders.  
   if we do want to use standard axapta template then
we should use all the 3 tables, SalesTable, SalesLine
and InventDim. 

--- Hemant Kumthekar [EMAIL PROTECTED] wrote:

 I will try uploading using your template and let you
 know the outcome.
  
 Hemant
 
 Priyank Krishna [EMAIL PROTECTED] wrote:
 I tried as per u said but no luck...help
 
 lukas nugroho [EMAIL PROTECTED] wrote: 
 Dear preety,
 
 to create sales order form excel, you need to use
 SalesTable and SalesLines only. You ought to fill
 the
 requirement field (yellow field). do not change or
 delete some field on excel regenerated from axapta.
 hope it helps
 
 --- Priyank Krishna [EMAIL PROTECTED]
 wrote:
 
  Thanks for reponse !
   
  I have used existing Excel template Import
  functionality for creating sales orders but could
  not succeed.
   
  you please tell me correct format.I used
  SalesTable,SalesLine,InventDim what else is
  remaining into it.
   
  Your response is waited
  
  Hemant Kumthekar [EMAIL PROTECTED] wrote:
  Hi,
   
  You may like to create the Excel spreadsheet from
  Axapta  AdministrationPeriodicData
 export/Import
   Excel Spreadsheet.  I have upload sales orders
 
  Lines using the same technique, quite simple. If
 you
  need the format let me know.
   
  Hemant
  
  Priyank Krishna [EMAIL PROTECTED] wrote:
  Can anyone please tell me the way to upload data
 in
  SalesTable  SalesLine with the purpose of
 creating
  Sales orders.
   
  Any responses are welcome.
   
  Cheers,
  Preety
  
  
  -
  Yahoo! India Matrimony: Find your partner now. 
  
  -
  Yahoo! Music Unlimited - Access over 1 million
  songs. Try it free. 
  
  Sharing the knowledge on Axapta. 
  
  
  
  -
  YAHOO! GROUPS LINKS 
  
  
  Visit your group Axapta-Knowledge-Village on
  the web.

  To unsubscribe from this group, send an email
  to:
  
 
 [EMAIL PROTECTED]

  Your use of Yahoo! Groups is subject to the
  Yahoo! Terms of Service. 
  
  
  -
  
  
  
  
  -
   Yahoo! India Matrimony: Find your partner now.
 
 
 
   
 
 __ 
 Yahoo! Mail - PC Magazine Editors' Choice 2005 
 http://mail.yahoo.com
 
 
 Sharing the knowledge on Axapta. 
 
 
 
 
 -
 Yahoo! India Matrimony: Find your partner now. 
 
 Sharing the knowledge on Axapta. 
 
 
 
 -
 YAHOO! GROUPS LINKS 
 
 
 Visit your group Axapta-Knowledge-Village on
 the web.
   
 To unsubscribe from this group, send an email
 to:
 
 [EMAIL PROTECTED]
   
 Your use of Yahoo! Groups is subject to the
 Yahoo! Terms of Service. 
 
 
 -
 
 
 
   
 -
  Yahoo! FareChase - Search multiple travel sites in
 one click.  






___ 
Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail 
http://uk.messenger.yahoo.com


 Yahoo! Groups Sponsor ~-- 
Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page
http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/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]

2005-10-22 Thread Girish Bhatkal
what error are you getting. i am using this
environment since a long time. 
   THe only time you can get into problem is trying to
connect to a client to connect to a higher version of
application. i,e we should not use Sp2 client to
connect to Sp3 or SP4.

If you have multiple installations on your machine and
if you want to work on Axapta v3 - Sp3 and SP4
application then you have the client and server
upgraded to Sp4 . This way you can use the same client
to connect to the SP3 and SP4 applications.


--- sri ram [EMAIL PROTECTED] wrote:

 hi girish,
  Sorry to say I tried the same with Axapta 3.0
 installed on my AOS and as a
 3 tier sp4 thin client tried to acess the same. Its
 giving me an error.
  Please suggest if any cheanges are to be made
 during client installation.
  Thanking you.
  Regards
 Sri Ram
  On 10/20/05, Girish Bhatkal
 [EMAIL PROTECTED] wrote:
 
  its alright for you to use the SP4 client to run
 Sp3
  or lower level applications/servers. But you
 should
  not connect Sp3 client to Sp4 application.
 
  --- Alessandro Ghidini [EMAIL PROTECTED] wrote:
 
   Hi group.. I'd like to install two different
 Axapta
   service packs on the
   same computer.. Basically i need an sp3 client
 for a
   3 level connection to
   an sp3 server and an sp4 installation on my pc
 for
   testing purposes.
  
  
  
   If i try to make a new Axapta client
 installation on
   my pc, installer
   recognizes the old installation and tries to use
   that for repairing or
   changing.. So i can install a new client..
  
  
  
   Any suggestion? Thanks in advance.
  
  
  
   Alessandro
  
  
  
  
  
  
  
   Ghidini Ing. Alessandro
  
   Kibuz SRL
  
   Galleria Ludovico Mortara, 2 - 46100 - Mantova
  
   Telefono: +39 0376 220605
  
   Fax: +39 0376 367439
  
   Email: mailto:[EMAIL PROTECTED]
 [EMAIL PROTECTED]
  
  
  
  
 
 
 
 
 
 
 

___
  Yahoo! Messenger - NEW crystal clear PC to PC
 calling worldwide with
  voicemail http://uk.messenger.yahoo.com
 
 
  Sharing the knowledge on Axapta.
 
 
 
  SPONSORED LINKS
Business finance

coursehttp://groups.yahoo.com/gads?t=msk=Business+finance+coursew1=Business+finance+coursew2=Business+to+business+financew3=Small+business+financew4=Business+finance+consultantw5=Business+finance+magazinew6=Business+finance+schoolsc=6s=185.sig=I8jDsORmsaYn0BeqghcJ2w
 Business
  to business

financehttp://groups.yahoo.com/gads?t=msk=Business+to+business+financew1=Business+finance+coursew2=Business+to+business+financew3=Small+business+financew4=Business+finance+consultantw5=Business+finance+magazinew6=Business+finance+schoolsc=6s=185.sig=fCzze7cxm1K7TVKkzAaOrA
 Small
  business

financehttp://groups.yahoo.com/gads?t=msk=Small+business+financew1=Business+finance+coursew2=Business+to+business+financew3=Small+business+financew4=Business+finance+consultantw5=Business+finance+magazinew6=Business+finance+schoolsc=6s=185.sig=v9sWAno7Kz4WuL8Tadcdhw
  Business
  finance

consultanthttp://groups.yahoo.com/gads?t=msk=Business+finance+consultantw1=Business+finance+coursew2=Business+to+business+financew3=Small+business+financew4=Business+finance+consultantw5=Business+finance+magazinew6=Business+finance+schoolsc=6s=185.sig=d1xwT3WL0E6XBf6cAV5BXA
 Business
  finance

magazinehttp://groups.yahoo.com/gads?t=msk=Business+finance+magazinew1=Business+finance+coursew2=Business+to+business+financew3=Small+business+financew4=Business+finance+consultantw5=Business+finance+magazinew6=Business+finance+schoolsc=6s=185.sig=qphRINaNuVm_6bwoQxgUmg
 Business
  finance

schoolshttp://groups.yahoo.com/gads?t=msk=Business+finance+schoolsw1=Business+finance+coursew2=Business+to+business+financew3=Small+business+financew4=Business+finance+consultantw5=Business+finance+magazinew6=Business+finance+schoolsc=6s=185.sig=1RfnhYZpV99RKWRZzSH4gA
   --
  YAHOO! GROUPS LINKS
 
 
 - Visit your group

Axapta-Knowledge-Villagehttp://groups.yahoo.com/group/Axapta-Knowledge-Village
 on the web.
  - To unsubscribe from this group, send an
 email to:


[EMAIL PROTECTED][EMAIL PROTECTED]
  - Your use of Yahoo! Groups is subject to the
 Yahoo! Terms of
 Service http://docs.yahoo.com/info/terms/.
 
 
   --
 
 




___ 
To help you stay safe and secure online, we've developed the all new Yahoo! 
Security Centre. http://uk.security.yahoo.com


 Yahoo! Groups Sponsor ~-- 
Help Sudanese refugees rebuild their lives through GlobalGiving.
http://us.click.yahoo.com/hjNroD/EbOLAA/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

Re: [Axapta-Knowledge-Village]

2005-10-20 Thread Girish Bhatkal
its alright for you to use the SP4 client to run Sp3
or lower level applications/servers. But you should
not connect Sp3 client to Sp4 application.

--- Alessandro Ghidini [EMAIL PROTECTED] wrote:

 Hi group.. I'd like to install two different Axapta
 service packs on the
 same computer.. Basically i need an sp3 client for a
 3 level connection to
 an sp3 server and an sp4 installation on my pc for
 testing purposes.
 
  
 
 If i try to make a new Axapta client installation on
 my pc, installer
 recognizes the old installation and tries to use
 that for repairing or
 changing.. So i can install a new client..
 
  
 
 Any suggestion? Thanks in advance.
 
  
 
 Alessandro
 
  
 
  
 
  
 
 Ghidini Ing. Alessandro
 
 Kibuz SRL
 
 Galleria Ludovico Mortara, 2 - 46100 - Mantova
 
 Telefono: +39 0376 220605
 
 Fax: +39 0376 367439
 
 Email:  mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]
 
  
 
 






___ 
Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail 
http://uk.messenger.yahoo.com


 Yahoo! Groups Sponsor ~-- 
Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page
http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/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] Axapta Demo Installation Error : 1602

2005-10-11 Thread Girish Bhatkal
on which machine have u installed the AOS. it is
better to install on the same machine on which the
application is installed. If the database server is on
another machine then see that you have proper access
to that machine. (you can check that by connecting to
the database using the odbc ).
   i feel this problem is because of access problem.
you also try to restart the machine on which the AOS
is installed and try again.

good luck,


--- Pushpa Bherwani [EMAIL PROTECTED]
wrote:

 hi
 Thanks a lot for the help 
 I have installed AOS
 Its running in Services
 but through Control Panel it shows status as Stopped
 and when I start it , it again goes Stopped within
 seconds
 What could be the reason ?
  
 Thanks
 Pushpa 
 
 Lalith Jayantha [EMAIL PROTECTED] wrote:
 
 Hi
 
 You need to install Aos. its in axapta installation
 CD.
 
 Lalith 
 --- Pushpa Bherwani [EMAIL PROTECTED]
 wrote:
 
  Hi
  Thanks for the reply
  That gave me a clue what is to be done 
  but i m still not getting the actual way
   
  firstly i have a confusion regarding AOS
  Does it need some separate installation or what ??
  I have installed MSDE and Microsoft Axapta 3.0 SP3
  demo
   
  so do i need something else to get AOS coz i can't
  see AOS service manager running in my machine's
  services ...Plz answer this.
   
  
  Girish Bhatkal [EMAIL PROTECTED] wrote:
  in the axapta configuration you set the
 application
  path (system directory). here you give the path of
  the
  application (in your case it would be the path
 where
  the application is set on server B).make sure that
  you
  give the proper access rights for the application
  folder on server B and see that the folder can be
  accessed from machine A.
 i hope you are looking for this answer?
  
  --- Pushpa Bherwani
 [EMAIL PROTECTED]
  wrote:
  
   Hi


   I have now created a new database in my server 
   and noe I can run Axapta Demo through that dsn.
   Anyhow its working 

   Thanks to all  for the help 

   But can someone tell me that if I have Axapta
   running on some machine say Server A
   and my application is in some client machine say
   Machine B
   then how can I logon to Axapta which is o
 Machine
  A
   through my application which is on Machine B

   Thanks
   I hope someone will come with a solution

   Pushpa
   
   
   Hi,

Can you check whether the AOS is running.
 Control
   Panel  Navision Axapta  Object Server. Check
  what
   is the  AOS name, and also check your 3-tier
   configuration the Client tab.

   HK
   
   Lalith Jayantha [EMAIL PROTECTED]
 wrote:
   
   Hi 
   
   can you run the axapta without server in 2tire 
   
   
   Lalith
   --- Pushpa [EMAIL PROTECTED]
 wrote:
   

Hi 

I am getting the following error ahile
  installing
Axapta Demo

Server not found : 1602

I have server and application on same machine.

The strange thing is that I first installed
 demo
which ran smoothly 
for 2-3 days and then suddenly in stopped
  working
giving server not 
found
 errro , I am using the local as server

I reinstalled it but now its not working on my
system.

Please help me to sort out this.

Thanks
Pushpa






   
   
   
   
   __ 
   Yahoo! Mail - PC Magazine Editors' Choice 2005 
   http://mail.yahoo.com
   
   
   -
   Yahoo! for Good
   Click here to donate to the Hurricane Katrina
  relief
   effort. 
   
   Sharing the knowledge on Axapta. 
   
   
   
   SPONSORED LINKS 
   Business finance course Business to business
  finance
   Small business finance Business finance
 consultant
   Business finance magazine Business finance uk 
   
   -
   YAHOO! GROUPS LINKS 
   
   
   Visit your group Axapta-Knowledge-Village
 on
   the web.
 
   To unsubscribe from this group, send an
 email
   to:
   
  
 
 [EMAIL PROTECTED]
 
   Your use of Yahoo! Groups is subject to the
   Yahoo! Terms of Service. 
   
   
   -
   
   
   
   
   -
Yahoo! India Matrimony: Find your partner now.
  
  
  


  
 

___
  
  Yahoo! Messenger - NEW crystal clear PC to PC
  calling worldwide with voicemail
  http://uk.messenger.yahoo.com
 
=== message truncated ===




___ 
To help you stay safe and secure online, we've developed the all new Yahoo! 
Security Centre. http://uk.security.yahoo.com


 Yahoo! Groups Sponsor ~-- 
Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page
http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/kGEolB/TM

Re: [Axapta-Knowledge-Village] Axapta Demo Installation Error : 1602

2005-10-09 Thread Girish Bhatkal
in the axapta configuration you set the application
path (system directory). here you give the path of the
application (in your case it would be the path where
the application is set on server B).make sure that you
give the proper access rights for the application
folder on server B and see that the folder can be
accessed from machine A.
   i hope you are looking for this answer?

--- Pushpa Bherwani [EMAIL PROTECTED]
wrote:

 Hi
  
  
 I have now created a new database in my server 
 and noe I can run Axapta Demo through that dsn.
 Anyhow its working 
  
 Thanks to all  for the help 
  
 But can someone tell me that if I have Axapta
 running on some machine say Server A
 and my application is in some client machine say
 Machine B
 then how can I logon to Axapta which is o Machine A
 through my application which is on Machine B
  
 Thanks
 I hope someone will come with a solution
  
 Pushpa
 
 
 Hi,
  
  Can you check whether the AOS is running. Control
 Panel  Navision Axapta  Object Server. Check what
 is the  AOS name, and also check your 3-tier
 configuration the Client tab.
  
 HK
 
 Lalith Jayantha [EMAIL PROTECTED] wrote:
 
 Hi 
 
 can you run the axapta without server in 2tire 
 
 
 Lalith
 --- Pushpa [EMAIL PROTECTED] wrote:
 
  
  Hi 
  
  I am getting the following error ahile installing
  Axapta Demo
  
  Server not found : 1602
  
  I have server and application on same machine.
  
  The strange thing is that I first installed demo
  which ran smoothly 
  for 2-3 days and then suddenly in stopped working
  giving server not 
  found
   errro , I am using the local as server
  
  I reinstalled it but now its not working on my
  system.
  
  Please help me to sort out this.
  
  Thanks
  Pushpa
  
  
  
  
  
  
 
 
 
 
 __ 
 Yahoo! Mail - PC Magazine Editors' Choice 2005 
 http://mail.yahoo.com
 
 
 -
 Yahoo! for Good
 Click here to donate to the Hurricane Katrina relief
 effort. 
 
 Sharing the knowledge on Axapta. 
 
 
 
 SPONSORED LINKS 
 Business finance course Business to business finance
 Small business finance Business finance consultant
 Business finance magazine Business finance uk 
 
 -
 YAHOO! GROUPS LINKS 
 
 
 Visit your group Axapta-Knowledge-Village on
 the web.
   
 To unsubscribe from this group, send an email
 to:
 
 [EMAIL PROTECTED]
   
 Your use of Yahoo! Groups is subject to the
 Yahoo! Terms of Service. 
 
 
 -
 
 
 
   
 -
  Yahoo! India Matrimony: Find your partner now.






___ 
Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail 
http://uk.messenger.yahoo.com


 Yahoo! Groups Sponsor ~-- 
Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page
http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/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] DataStatus on inventtrans

2005-09-28 Thread Girish Bhatkal
i belive the fields in the index should be in proper
order.  

 In case (in table inventTrans) you are using the
Index StatusItemIdx then you need to include in your
select statement first statusReceipt, then
StatusIssue, then ItemId and then DateStatus. If you
dont want to use any of these in the select statement
then you can exclude it but have it in a proper order.

 This is the reason we see multiple Indexes
created on the table (take ex InventTrans). The
ItemIdx should be used when you are going to have Item
first in the index.

Take another example of SalesLine.
If you are making a search by SalesId and SalesStatus
we use SalesStatusIdx (see the method
calcCreditBalance in the salesLine table and see the
order of fields used in the statement).

  Also should consider no of times the
record/combination of records are available. 

   If we see the find methods we usually see that
the index used is the one which is unique or least nos
of lines. This is also because there would be only
one/least record with the combination.
Ex; SalesLine table SalesLineIdx. 

May be all my assumptions/findings may not be right.
but we are here to learn.

cheers,
Girish

--- Harry (Harshawardhan Deshpande
[EMAIL PROTECTED] wrote:

 hi
  
 1. the order of where clause statement is not
 important
 2. I would recommend not putting any index hint to
 begin with and check the sql trace to see which
 index is being selected.
 3. If you are not happy with the performance then
 try things like #placeholder etc. Depends on how
 many times this statement is being called. 
  
 regards
  
 harry
 
 James Flavell [EMAIL PROTECTED] wrote:
 Hi can somebody tell me the field 'DateStatus' on
 inventtrans is set at what points?
  
 I am just trying to improve performance on
 inventtrans searchs and can see the index
 'StatusItemIdx' is useful to me.  Basically I want
 to find all the inventtrans cost for sales invoices
 for a period of time and hence why any index that
 has a date in it would be very useful.
  
 My thinking is if date financial exists on
 inventtrans can I assume date status will ALWAYS be
 the same date as financial for that particular
 inventtrans record?  And therfore replace in my
 select using datefinancial with datastatus...
  
 Part of my select originally would be (basically the
 std select to calc cost for an custinvoicetrans but
 with date range added):
  
   inventTrans.dateFinancial   
= _runStart
   inventTrans.dateFinancial   
   = _runEnd
   inventTrans.ItemId  
  == 'ABC'
   inventTrans.qty 
  != 0
  
 inventTrans.packingSlipReturned   == 0
   inventTrans.statusReceipt   
  = StatusReceipt::Purchased
   inventTrans.statusIssue 
  = StatusIssue::Sold
   _invoiceTrans.InventTransId 
  != 
 
 but I am wondering can I change it to:
  
   inventTrans.dateStatus  
 = _runStart
   inventTrans.dateStatus  
 = _runEnd
   inventTrans.ItemId  
 == 'ABC'
   inventTrans.qty 
  != 0
  
 inventTrans.packingSlipReturned   == 0
   inventTrans.statusReceipt   
  = StatusReceipt::Purchased
   inventTrans.statusIssue 
  = StatusIssue::Sold
   _invoiceTrans.InventTransId 
  != 
 
 
 and be sure of always getting  the same result (i.e.
 once data finanical then the inventtrans datastatus
 will not change)?
  
 Also I am just wondering the order of my where
 clause statements is important or not?  I know in
 XAL previously that supposedly it was best to put
 them in the same order as the fields used in the
 index but not sure if any such 'feature' is still
 present in Axapta
  
 If I can use dateStatus would you recommend I use
 this StatusItemIdx as an index hint?  I am just
 wondering since ItemId is not the first component
 then to me the search will have to go through ALL
 inventtrans that are sold or purchased.  If I use an
 index with itemid as the first component then the
 search will immediately be narrowed down to the item
  
  
 Thanks
 James
  
 
 
 Sharing the knowledge on Axapta. 
 
 
 
 SPONSORED LINKS 
 Business finance course Business to business finance
 Small business finance Business finance consultant
 Business finance magazine Business finance uk 
 
 -
 YAHOO! GROUPS LINKS 
 
 
 Visit your group Axapta-Knowledge-Village on
 the web.
   
 To unsubscribe from this group, send an email
 to:
 
 [EMAIL PROTECTED]
   
 Your use of Yahoo! Groups is subject to the
 Yahoo! Terms of Service. 
 
 
 -
 
 
 
   
 -
 Yahoo! for Good
  Click here to donate to the Hurricane Katrina
 

RE: [Axapta-Knowledge-Village] DataStatus on inventtrans

2005-09-28 Thread Girish Bhatkal
Hi James,

during one of my previous implementation (2 yrs back)
we had some performance issues and a Consultant from
MS had visited us. he asked me to change the order of
the select statements in order to improve the
performance. This is because of the way the data is
read. Since then i  have been following this. 
   If anyone feels what i have mentioned is wrong,
then please do let us know.

cheers,
Girish

--- James Flavell [EMAIL PROTECTED] wrote:


-
Thanks Grish,

The part about fields being in order I was thinking
about the where clauses
in my select statments...whether they needed to come
in the same order in my
select statement as the order of the fields in the
index.  TO clarify, are
you saying the order of the clauses in the select
statement have an impact
on performance?

In terms of order of fields in the index I fully
understand the importance
of getting those right.

Thanks
James


-Original Message-
From: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On
Behalf Of Girish
Bhatkal
Sent: 28 September 2005 18:31
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] DataStatus on
inventtrans


i belive the fields in the index should be in proper
order.  

 In case (in table inventTrans) you are using the
Index StatusItemIdx then you need to include in your
select statement first statusReceipt, then
StatusIssue, then ItemId and then DateStatus. If you
dont want to use any of these in the select statement
then you can exclude it but have it in a proper order.

 This is the reason we see multiple Indexes
created on the table (take ex InventTrans). The
ItemIdx should be used when you are going to have Item
first in the index.

Take another example of SalesLine.
If you are making a search by SalesId and SalesStatus
we use SalesStatusIdx (see the method
calcCreditBalance in the salesLine table and see the
order of fields used in the statement).

  Also should consider no of times the
record/combination of records are available. 

   If we see the find methods we usually see that
the index used is the one which is unique or least nos
of lines. This is also because there would be only
one/least record with the combination.
Ex; SalesLine table SalesLineIdx. 

May be all my assumptions/findings may not be right.
but we are here to learn.

cheers,
Girish

--- Harry (Harshawardhan Deshpande
[EMAIL PROTECTED] wrote:

 hi
  
 1. the order of where clause statement is not
 important
 2. I would recommend not putting any index hint to
 begin with and check the sql trace to see which
 index is being selected.
 3. If you are not happy with the performance then
 try things like #placeholder etc. Depends on how
 many times this statement is being called.
  
 regards
  
 harry
 
 James Flavell [EMAIL PROTECTED] wrote:
 Hi can somebody tell me the field 'DateStatus' on
 inventtrans is set at what points?
  
 I am just trying to improve performance on
 inventtrans searchs and can see the index
 'StatusItemIdx' is useful to me.  Basically I want
 to find all the inventtrans cost for sales invoices
 for a period of time and hence why any index that
 has a date in it would be very useful.
  
 My thinking is if date financial exists on
 inventtrans can I assume date status will ALWAYS be
 the same date as financial for that particular
 inventtrans record?  And therfore replace in my
 select using datefinancial with datastatus...
  
 Part of my select originally would be (basically the
 std select to calc cost for an custinvoicetrans but
 with date range added):
  
   inventTrans.dateFinancial   
= _runStart
   inventTrans.dateFinancial   
   = _runEnd
   inventTrans.ItemId  
  == 'ABC'
   inventTrans.qty 
  != 0
  
 inventTrans.packingSlipReturned   == 0
   inventTrans.statusReceipt   
  = StatusReceipt::Purchased
   inventTrans.statusIssue 
  = StatusIssue::Sold
   _invoiceTrans.InventTransId 
  != 
 
 but I am wondering can I change it to:
  
   inventTrans.dateStatus  
 = _runStart
   inventTrans.dateStatus  
 = _runEnd
   inventTrans.ItemId  
 == 'ABC'
   inventTrans.qty 
  != 0
  
 inventTrans.packingSlipReturned   == 0
   inventTrans.statusReceipt   
  = StatusReceipt::Purchased
   inventTrans.statusIssue 
  = StatusIssue::Sold
   _invoiceTrans.InventTransId 
  != 
 
 
 and be sure of always getting  the same result (i.e.
 once data finanical then the inventtrans datastatus
 will not change)?
  
 Also I am just wondering the order of my where
 clause statements is important or not?  I know in
 XAL

Re: [Axapta-Knowledge-Village] Form refresh from a class

2005-09-26 Thread Girish Bhatkal
Hi Subbu,

 suppose i want to call the doRefresh method on the
salesTable form, from a class/job then

TreeNode treeNode =
TreeNode::findNode('Forms').AOTfindChild('SalesTable');

treeNode.AOTrefresh();
treeNode.treeNodeRelease();
treeNode = NULL;
  
but what should i do to include the method doRefresh
from the salesTable. i tried a few things but i get
error that the Treenode object is not initialised. i
had modification as

treenode = 
TreeNode::findNode('forms').AOTfindChild('\\salesTable\methods\doRefresh');

can you tell me where am i going wrong.
thanks

cheers,
Girish  


--- Subrahmanyam, Mamidi [EMAIL PROTECTED] wrote:

 Hi Girish,
  
 How are you doing?. what if I use to get the same
 result as follows.
  
 //
  
 TreeNode treeNode =
 TreeNode::findNode('Forms').AOTfindChild('Form');
  ;
treeNode.AOTrefresh();
treeNode.treeNodeRelease();
treeNode = NULL;
  
 /*/
  
  
  is there any problem if I use this?.
  
 BTW, I will send you a seperate email with all info.
  
 your buddy,
 subbu
 
 Girish Bhatkal [EMAIL PROTECTED] wrote:
 hi, i understand the way to send the element and
 refresh. But what if we want to update a datasource
 of
 a form (which is already open). In this case the
 data
 is updated in a class but the class is not directly
 called from the form .
 
 --- wb [EMAIL PROTECTED] wrote:
 
 
 -
 Hi Girish,
 You can see for example form LedgerJournalTable,
 at method init
 
 journalFormTable = new
 LedgerJournalFormTable(element);
 
 LedgerJournalTable ledgerJournalTable()
 {
 return ledgerJournalTable;
 }
 
 hope this help you,
 wb
 
 2005/9/21, Girish Bhatkal
 [EMAIL PROTECTED]:
  Hi Guys,
  
 I have a bookrefresh method on a form (which
  refreshes the datasource). Is it possible in
 someway
  to run this method from a class (provided we know
 the
  FORM name). 
  
 I understand the way where in we get the caller
  name when the class is run from the form and
 execute
  the method. 
  
  But in my case the class which is going to
 call
  this method on the form is not directly called
 from
  the Form.
  
   i tried to use the sysGlobalCache but i could
 not
  get the solution. can anyone let me know how can
 we
  achieve this.
  
  thanks,
  
  cheers,
  Girish
  
 
 
 
 Sharing the knowledge on Axapta.
 
   
 
   SPONSORED LINKS  

 Business finance course 
  
 Business to business finance
  
  Small business finance 
  
 Business
 finance consultant  
 
 Business finance magazine   
  
   Business finance uk   
  

 
 -
   YAHOO! GROUPS LINKS
 
   
 Visit your group Axapta-Knowledge-Village on
 the
 web.

 To unsubscribe from this group, send an email
 to:
 [EMAIL PROTECTED]

 Your use of Yahoo! Groups is subject to the
 Yahoo!
 Terms of Service.
 
   
 -
 
 
 
 
 
   
   
 

___
 
 Yahoo! Messenger - NEW crystal clear PC to PC
 calling worldwide with voicemail
 http://uk.messenger.yahoo.com
 
 
 Sharing the knowledge on Axapta. 
 
 
 
 SPONSORED LINKS 
 Business finance course Business to business finance
 Small business finance Business finance consultant
 Business finance magazine Business finance uk 
 
 -
 YAHOO! GROUPS LINKS 
 
 
 Visit your group Axapta-Knowledge-Village on
 the web.
   
 To unsubscribe from this group, send an email
 to:
 
 [EMAIL PROTECTED]
   
 Your use of Yahoo! Groups is subject to the
 Yahoo! Terms of Service. 
 
 
 -
 
 
 
   
 -
 Yahoo! for Good
  Click here to donate to the Hurricane Katrina
 relief effort. 




___ 
To help you stay safe and secure online, we've developed the all new Yahoo! 
Security Centre. http://uk.security.yahoo.com


 Yahoo! Groups Sponsor ~-- 
Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page
http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/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] Form refresh from a class

2005-09-21 Thread Girish Bhatkal
Hi Guys,

   I have a bookrefresh method on a form (which
refreshes the datasource). Is it possible in someway
to run this method from a class (provided we know the
FORM name). 

   I understand the way where in we get the caller
name when the class is run from the form and execute
the method. 

But in my case the class which is going to call
this method on the form is not directly called from
the Form.

 i tried to use the sysGlobalCache but i could not
get the solution. can anyone let me know how can we
achieve this.

thanks,

cheers,
Girish



___ 
To help you stay safe and secure online, we've developed the all new Yahoo! 
Security Centre. http://uk.security.yahoo.com


 Yahoo! Groups Sponsor ~-- 
Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page
http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/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] Hiding confidential data in axapta

2005-09-20 Thread Girish Bhatkal
i believe the record level security should help
achieve what you are looking for.

cheers,
Girish
--- Harry (Harshawardhan Deshpande
[EMAIL PROTECTED] wrote:

 hi
  
 I seem to remember a discussion that said it is
 possible encrypt a string.
  
 If it is not available then it should be easy to
 write your own function
  
 regards
  
 harry
 
 
 tj_jayson [EMAIL PROTECTED] wrote:
 Hi All,
 
 Is it possible to hide (or encrypt) salary data
 field from viewing 
 from everybody other than HR manager?
 
 This includes stopping viewing from Table browser
 and backend SQL data 
 base by IT department.
 
 Thanks
 
 JJT
 
 
 
 
 Sharing the knowledge on Axapta. 
 
 
 
 SPONSORED LINKS 
 Business finance course Business to business finance
 Small business finance Business finance consultant
 Business finance magazine Business finance uk 
 
 -
 YAHOO! GROUPS LINKS 
 
 
 Visit your group Axapta-Knowledge-Village on
 the web.
   
 To unsubscribe from this group, send an email
 to:
 
 [EMAIL PROTECTED]
   
 Your use of Yahoo! Groups is subject to the
 Yahoo! Terms of Service. 
 
 
 -
 
 
 
   
 -
 Yahoo! for Good
  Click here to donate to the Hurricane Katrina
 relief effort. 




___ 
How much free photo storage do you get? Store your holiday 
snaps for FREE with Yahoo! Photos http://uk.photos.yahoo.com


 Yahoo! Groups Sponsor ~-- 
Help Sudanese refugees rebuild their lives through GlobalGiving.
http://us.click.yahoo.com/hjNroD/EbOLAA/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] Adjusting Global Data Types

2005-09-14 Thread Girish Bhatkal
there should not be any problem. but i would advice to
take a database backup before doing any changes.
good luck,

--- Roberto Pineda [EMAIL PROTECTED] wrote:


-
Hello to All.

We have to increase the Account Number size from 11 to
15, but i want to know what happens if we do it at
this moment, now the system has almost two years
working.

Is there a problem with the data or SQL database?
How could we do this without severe issues?
We have Axapta 3.0 SP3.
Thanks in advance.

Roberto Pineda

__
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam
¡gratis! 
Regístrate ya - http://correo.espanol.yahoo.com/ 


Sharing the knowledge on Axapta.

  

  SPONSORED LINKS  
   
Business finance course   
Business to business finance  
 Small business finance   
Business
finance consultant   
Business finance magazine 
  Business finance schools


-
  YAHOO! GROUPS LINKS

  
Visit your group Axapta-Knowledge-Village on the
web.
   
To unsubscribe from this group, send an email to:
 [EMAIL PROTECTED]
   
Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service.

  
-








___ 
Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail 
http://uk.messenger.yahoo.com


 Yahoo! Groups Sponsor ~-- 
Put more honey in your pocket. (money matters made easy).
http://us.click.yahoo.com/r7D80C/dlQLAA/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] Invoice amount number to letter, printed in the invoice !!!!!!!!!!!

2005-09-04 Thread Girish Bhatkal
Hi Ricardo,

you may have to write a display method
here below is a job which is used to print number to
text. use the code in the display method ...

static void numberToWords(Args _args)
{
global  global = new global();

print global::numeralsToTxt_ES(12121.39);
print global::num2Text(12121.39);
pause;

}

hope this would help.

cheers,
Girish
--- Ricardo Cortés [EMAIL PROTECTED]
wrote:

 Hi everybody
  
 Does anymone know, how to translate the invoice
 amount to letter and print it in the invoice?
  
 Thanks in advance
  
 Ricardo Cortés
  
  
 
 __
 Correo Yahoo!
 Espacio para todos tus mensajes, antivirus y
 antispam ¡gratis! 
 Regístrate ya - http://correo.yahoo.com.mx/ 






___ 
Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail 
http://uk.messenger.yahoo.com


 Yahoo! Groups Sponsor ~-- 
Put more honey in your pocket. (money matters made easy).
http://us.click.yahoo.com/r7D80C/dlQLAA/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] Need your exp on Purchasing for Items of type Service

2005-09-02 Thread Girish Bhatkal
did you also check the Round-off on the exchange
currency form / round-off tab?

--- Subrahmanyam, Mamidi [EMAIL PROTECTED] wrote:

 Hi,
  
 I need your different experiences on packing slip /
 invoicing of expense items ( Service ).
  
 For example, I have this funny scenario going on.
  
 1. I created a Unit called 'M' for meters and I gave
  3 decimals for that in the Unit Table.
  
 2. Since Its an Service Item, I didn;t include 
 Units on InventTable-Quantity Table for this item
 for 'Purchase Order' quantity.
  
 3. I created a PO with 'quantity'  25.04. So it
 shows up '25.04' on the PuchQty on the PurchOrder
 purch Lines Tab. but it shows orderedQty as  '25'
 only as it rounds off to Zero decimals since it  has
 no units InventTable - Quantity- Unit.
  
 4. I put the debugging points right from
 PurchLine.ModifyPurchQty  to InventUpdate,
 Inventupd_* classes. to see the complete process and
 I understood how the inventory movement is happening
 in the code.
  
 But I have problem at the time of invoice due to
 '0.04' in update in Inventupd_Pysical.updateNow as
 its throwing an error
  
 So what is your experiences in invocing the PO for
 service Items, i.e expense.
 Do we need to have to specify the Unit of
 Measurement for that item tied to a InventTable -
 Quantity-purchaseorder Column - Unit ?.
  
 is there any way, we can avoid hitting inventory for
 this service items?.
  
 Appreciate your experiences.
  
 Thanks  Regards,
 Subbu
  
  
  
 
   
 -
  Start your day with Yahoo! - make it your home page







___ 
Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail 
http://uk.messenger.yahoo.com


 Yahoo! Groups Sponsor ~-- 
Put more honey in your pocket. (money matters made easy).
http://us.click.yahoo.com/r7D80C/dlQLAA/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] Picking list created when no onhand stock was available

2005-08-26 Thread Girish Bhatkal
Hi everybody,

The following is the scenario:

  The picking lists are generated from salesLedger/
periodic/Sales Update/ picking list

on the Item stock model group the following are set:
Physical negative stock - not active
Financial negative stock - active
Registration requirements - active
picking requirements - not active

the client said that a pick list was printed this
morning even when the stock was not available.

   i tried to post another picking list for the same
line  but i could not as i got the expected error that
no stock was available. 

But when i got to salesorder/ posting/ picking list
registration i can see the picking list posted, today
, with this item (with a particular batch, warehouse
and location) which does not have any onhand stock.

 when i see the transactions i see that the stock
avaiable was deducted yesterday and hence i believe
there was never any stock today.

   had anyone seen this problem earlier and can any
one tell what could be the condition when the picking
list was created.

This had happened earlier too. i would appreciate
any thoughts on this issue.

cheers,
GIrish



___ 
To help you stay safe and secure online, we've developed the all new Yahoo! 
Security Centre. http://uk.security.yahoo.com


 Yahoo! Groups Sponsor ~-- 
Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page
http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/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] Grouping and sorting at the same time

2005-08-23 Thread Girish Bhatkal
 X++ DOES NOT allow to use both in the same select
statement.  this is one of the main difference between
X++ and SQL.

--- vishnu verma [EMAIL PROTECTED]
wrote:

 hi all,
 I am having one problem.
 I want to group the records based on customer
 account and sort them by their names.how can i do
 that.If any one can help me then i'll be highly
 obliged.
 Thanks
 Vishnu Prakash Verma.
 
   
 -
 Check out Yahoo! India Rakhi Special for Rakhi
 shopping, contests and lots more. 
 http://in.promos.yahoo.com/rakhi/index.html






___ 
Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail 
http://uk.messenger.yahoo.com


 Yahoo! Groups Sponsor ~-- 
font face=arial size=-1a 
href=http://us.ard.yahoo.com/SIG=12hgf3os3/M=362131.6882500.7825259.1493532/D=groups/S=1705001380:TM/Y=YAHOO/EXP=1124813425/A=2889190/R=0/SIG=10r90krvo/*http://www.thebeehive.org
Put more honey in your pocket. (money matters made easy) Welcome to the Sweet 
Life - brought to you by One Economy/a./font
~- 

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] Deleting posted Journals

2005-08-22 Thread Girish Bhatkal
Nihar,
  there are ways to delete records from the table
(using jobs) even after posting. But because many
other tables also get posted and because of data
consistency its always adviced not to forcefully
delete the posted transaction data.
   you have to reverse the journal posting by posting
the reverse entry. This will make sure that all the
postings are adjusted.

good luck,

cheers,
Girish

--- Nihar Saraiya [EMAIL PROTECTED]
wrote:

 Hi Girish.
  
 Thanks for the reply.
 The thing is that we have now exported the data from
 development server to
 live server with the posted transactions. Now we
 need to delete these
 transactions from the live server. There are not
 more than 5 posted journals
 in the Live server.
  
 How can these be deleted?
 If one can provide us with the details of which
 table need it to be deleted
 from, to start with, will be very highly
 appreciated.
  
 I am not quiet sure, but is there any way thru AOT,
 these journals be
 deleted?
  
 Waiting for the reply.
  
 Regards
 Nihar 
  
 -Original Message-
 From: Girish Bhatkal
 [mailto:[EMAIL PROTECTED]
 Sent: Sunday, August 21, 2005 10:57 PM
 To: Axapta-Knowledge-Village@yahoogroups.com
 Subject: Re: [Axapta-Knowledge-Village] Deleting
 posted Journals
  
 while exporting the data you first create the
 defination group. in the include table groups tab
 you can unselect the groups which you dont want
 include. after exporting the data using the
 defination
 group you can choose the same setup to import in the
 live system. 
 
 good luck,
 
 cheers,
 Girish
 
 
 --- sherin francis [EMAIL PROTECTED] wrote:
 
  Hi All!
   
  We are transferring data from the development
 server
  to the live server for one of our clients. 
  Some dummy data in Journals were entered and even
  posted in the development server. We now require
 to
  restore only the setups and none of the posted
  journal data into the live server.
  In short we would like to delete all the posted
  journals.
   
  I believe there is some macro that can be run
 within
  Axapta that does this work.
  Can anyone shed some light on this issue?
   
  Regards,
  Sherin Francis
  
  
  -
   Start your day with Yahoo! - make it your home
 page
 
 
 
 
 

___
 
 To help you stay safe and secure online, we've
 developed the all new Yahoo!
 Security Centre. http://uk.security.yahoo.com
 http://uk.security.yahoo.com
 
 
 
 Sharing the knowledge on Axapta. 
 
 
 
   _  
 
 YAHOO! GROUPS LINKS 
  
 *  Visit your group 
 Axapta-Knowledge-Village

http://groups.yahoo.com/group/Axapta-Knowledge-Village
  on the web.
   
 *  To unsubscribe from this group, send an
 email to:
  
 [EMAIL PROTECTED]

mailto:[EMAIL PROTECTED]
 ribe 
   
 *  Your use of Yahoo! Groups is subject to
 the Yahoo! Terms
 http://docs.yahoo.com/info/terms/  of Service. 
  
   _  
 
 




___ 
To help you stay safe and secure online, we've developed the all new Yahoo! 
Security Centre. http://uk.security.yahoo.com


 Yahoo! Groups Sponsor ~-- 
font face=arial size=-1a 
href=http://us.ard.yahoo.com/SIG=12h3tek6j/M=362131.6882500.7825259.1493532/D=groups/S=1705001380:TM/Y=YAHOO/EXP=1124717960/A=2889190/R=0/SIG=10r90krvo/*http://www.thebeehive.org
Put more honey in your pocket. (money matters made easy) Welcome to the Sweet 
Life - brought to you by One Economy/a./font
~- 

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] Why so slow???

2005-08-16 Thread Girish Bhatkal

yes as subbu has mentioned in the select method if the
field has an index then always use index hint.
   if you see any of the find methods on the tables
index hint is always used. This acts like pointers
in C. This will improve the performance a lot.
But in your code it would be best if you use

  SalesTable = SalesTable::find(_salesId);


--- Subrahmanyam, Mamidi [EMAIL PROTECTED] wrote:

 Hi Brandon,
 I am also running in the 3 tier. Basically you are
 reading the ascii file record fields to fetch the
 SalesId for that customer. Since you are using
 SalesTable , since SalesId is the unique index, you
 can include firstonly the statement to:
  
  Select firstonly SalesTable
 where SalesTable.SalesId ==
 _salesId; this is speed up the fetching the record
 rather than selecting whole Table j. Its just better
  way. (  You can use 
   
  Select SalesTable
   Index SalesIdx
  where SalesTable.SalesId ==
 _salesId; ). but since you are SalesId is uniuque,
 its nice to use 'firstonly'.
  
  
 I am afraid what other things are causing slowness.
  
 Umm, will see if anyone has any thoughts.Sicne you
 said you are experiencing slowness only for
 Confirmation , I am curious to know anyone has any
 explike this.
  
 Can anyone share if you have this kind of exp?.
  
 Best of luck,
 subbu
  
  
  
  
  
  
  
  
  
  
 
  
 
  
 
 
 Brandon George [EMAIL PROTECTED] wrote:
 Ok,
  
  Thanks for the reply... btw, this is running in a
 3-tier environment - Client - AOS - Database. You
 said you could make use of the SalesIdx, what do you
 mean by that? How in code can you make use of the
 SalesIdx? Can you give me an example of explain?
  
 To give you a better understanding of this code, it
 is being called from in a Batch type of process,
 where a Flat File is read in with information that
 supplies info - to get SalesId. So this runs on
 about 300-2000 orders a day, depending on the Orders
 and time of year.
  
 Anyway any more advice, on how to use the SalesIdx
 would be great!
  
 thanks,
 Brandon
 
 
 -
 From: Axapta-Knowledge-Village@yahoogroups.com
 [mailto:[EMAIL PROTECTED] On
 Behalf Of Subrahmanyam, Mamidi
 Sent: Monday, August 15, 2005 2:40 PM
 To: Axapta-Knowledge-Village@yahoogroups.com
 Subject: RE: [Axapta-Knowledge-Village] Why so
 slow???
 
 
 
 or may be use firstonly. But I am not sure why this
 is executed slowly on your environment.
 will see if anyone has other thoughts like, run on
 clinet/server etc etc...
 
 
 Subrahmanyam, Mamidi [EMAIL PROTECTED] wrote:
 Hi Brandon,
  
 I created a sales order with quatation and tried to
 confirm your code. Its confirming to salesorder and
 its pretty fast . However i am doing in a job. 
  
 But if I use SalesIdx on the select SalesTable
 statement, i could save 1/4 of the execution time (
 just by using WinAPI:;GetTickCount() before and
 after trcy catch block )
  
 But I am not sure what else is causing the slowness.
 
  
 Actually, I was also doing the same std code  by
 keeping the job ( confirming/postings etc etc )
 attached a menu item. but ours run very fast.
  
 Umm, I am handsup :(. We will see for others
 comments.
  
 hope you will get rid of this soon.
  
 Thanks,
 subbu
 
 
 Brandon George [EMAIL PROTECTED] wrote:
 Sure thing,
  
 We are running Axapta 3.0 with SP3. Below is the
 code used to Confirm the Orders:
  
 public boolean confirmSalesOrder(SalesId  _salesId)
 {
 SalesFormletter SalesFormletter;
 SalesTable  SalesTable;
 boolean b = false;
 ;
  
 try
 {
 SalesFormletter =


SalesFormletter::construct(DocumentStatus::Confirmation,true);
  
 SalesTable.clear();
 Select SalesTable
 where SalesTable.SalesId ==
 _salesId;
  
 SalesFormletter.update(SalesTable,
 
 systemDateGet(),
 
 SalesUpdate::All,
 
 AccountOrder::None,
  false,
  false);
 b = true;
 }
 catch
 {
 // error occured
 b = false;
 }
  
 return b;
  
 }
  
 Thanks for reviewing it, maybe you can give me some
 pointers!
  
 thanks,
 Brandon
 
 
 -
 From: Axapta-Knowledge-Village@yahoogroups.com
 [mailto:[EMAIL PROTECTED] On
 Behalf Of Subrahmanyam, Mamidi
 Sent: Monday, August 15, 2005 10:26 AM
 To: Axapta-Knowledge-Village@yahoogroups.com
 Subject: RE: [Axapta-Knowledge-Village] Why so
 slow???
 
 
 
 Hi Brandon,
  
 Can you please post your code here to see if I can
 run it in my development server?.
 We also do the similar kind of stuff using
 connectivitty studio.
 Anyway, Can you please share the code what exactly
 you are doing?. which version of axapta and which
 version of SP?.
  
 Thanks,
 

Re: [Axapta-Knowledge-Village] reading table outside axapta database

2005-08-15 Thread Girish Bhatkal
Hi Andres,
   i think there was a few postings earlier too on
this did you check the earlier postings on this group
? anyway one of the job is as below

static void Update(Args _args)
{
// connection
ODBCConnection  oDBCConnection;
gTest   gTest;   // new table in
axapta created to test
LoginProperty   loginProperty;
Statement   statement;
ResultSet   resultSet;
companyId   Company;

str FMrequestId;
;
// Initialize Connection
loginProperty   = new LoginProperty();
loginProperty.setServer(SQL-UK); // server name 
 
loginProperty.setDatabase(FM_AXAPTA); //
database name
loginProperty.setUsername(sa); // userId on the
database
loginProperty.setPassword(mn); // password on
the database
// Create Connection Object
oDBCConnection  = new
ODBCConnection(loginProperty);
statement   =
oDBCConnection.createStatement();


while select gTest where gTest.Complete == NoYes::Yes
  {
FMrequestId = gTest.Comments; // the field with
which is used to filter and select the external table
resultset = statement.executeQuery(SELECT * FROM
RequestTable where RequestTable.FMRecid = ' +
FMRequestId + ' +  AND DATAAREAID = ' + company +
'  +
UPDATE
RequestTable set Status = 'EXPORTED' where FMRecid =
' + FMRequestId + '); // working


while(resultset.next())
  {
 print resultset.getString(1); // the
first field in the external table which is a string
 print resultset.getReal(2);   // the
second field in the external table which is   real
 }

 }
 pause;
}


--- Andres Janno [EMAIL PROTECTED] wrote:

 
 Hello!
 
 Is it possible to get value to form field outside
 axapta database?
 For example completly different table from other
 mssql database?
 
 Regards,
 Andres
 
 
  Yahoo! Groups Sponsor
 ~-- 
 font face=arial size=-1a

href=http://us.ard.yahoo.com/SIG=12hot3nls/M=362131.6882500.7825259.1493532/D=groups/S=1705001380:TM/Y=YAHOO/EXP=1124091606/A=2889190/R=0/SIG=10r90krvo/*http://www.thebeehive.org
 Put more honey in your pocket. (money matters made
 easy) Welcome to the Sweet Life - brought to you by
 One Economy/a./font

~-
 
 
 Sharing the knowledge on Axapta. 
 Yahoo! Groups Links
 

http://groups.yahoo.com/group/Axapta-Knowledge-Village/
 

 [EMAIL PROTECTED]
 
  
 
 
 




___ 
How much free photo storage do you get? Store your holiday 
snaps for FREE with Yahoo! Photos http://uk.photos.yahoo.com


 Yahoo! Groups Sponsor ~-- 
font face=arial size=-1a 
href=http://us.ard.yahoo.com/SIG=12hason8f/M=362343.6886682.7839641.1493532/D=groups/S=1705001380:TM/Y=YAHOO/EXP=1124103017/A=2894354/R=0/SIG=11qvf79s7/*http://http://www.globalgiving.com/cb/cidi/c_darfur.html;Help
 Sudanese refugees rebuild their lives through GlobalGiving/a./font
~- 

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: Questionnaire

2005-08-10 Thread Girish Bhatkal
I am not sure what is the actual requirement in
complete. But i assume that record to be attached can
be any table (not predefined), something like in
standard questionnaire we can select from a list of
tables. But along with this it is required to go a
step further and against the table also select the
record (from the table). 
   


--- Amit Jain [EMAIL PROTECTED] wrote:

 Hello Ananth,
  
 For Which type of transaction you want to attach a
 questionaire because there can be inventory
 transactions, financial transactions and different
 base tables are used for the same. I agree with the
 solution given by Girish (my mate, who worked with
 me for 2 years) but where to put the code to make
 the reference with the newly(or existing) created
 table for the questionaire has to be figured out
 depending on the transactions type in business.
  
 Regards
  
 Amit Jain
  
 
 
 girish_axapta [EMAIL PROTECTED] wrote:
 Hi Ananth,
 
with the present functionality its not possible.
 you have to make 
 changes to achieve this. i would advice not to touch
 the present 
 functionality but create a new functionality to
 attach the questions 
 to the transaction records. you can take the tableId
 and the recordId 
 as the references to attach. 
 Good luck,
 
 
 cheers,
 Girish
 
 --- In Axapta-Knowledge-Village@yahoogroups.com,
 anantha raman 
 [EMAIL PROTECTED] wrote:
  Hi all
   
 i want to attach a questionnaire to a
 transaction level. 
 Can anyone help me in doing this. thanks in advance.
 
   
  Regards
  Ananth
   
 
  
  
  
  
  -
   Sell on Yahoo! Auctions  - No fees. Bid on great
 items.
 
 
 
 
 Sharing the knowledge on Axapta. 
 
 
 
 SPONSORED LINKS 
 Business finance course Business to business finance
 Small business finance Business finance consultant
 Business finance magazine Business finance schools 
 
 -
 YAHOO! GROUPS LINKS 
 
 
 Visit your group Axapta-Knowledge-Village on
 the web.
   
 To unsubscribe from this group, send an email
 to:
 
 [EMAIL PROTECTED]
   
 Your use of Yahoo! Groups is subject to the
 Yahoo! Terms of Service. 
 
 
 -
 
 
 
   
 -
  Start your day with Yahoo! - make it your home page





___ 
How much free photo storage do you get? Store your holiday 
snaps for FREE with Yahoo! Photos http://uk.photos.yahoo.com


 Yahoo! Groups Sponsor ~-- 
font face=arial size=-1a 
href=http://us.ard.yahoo.com/SIG=12hebd1v9/M=362343.6886682.7839641.1493532/D=groups/S=1705001380:TM/Y=YAHOO/EXP=1123688588/A=2894354/R=0/SIG=11qvf79s7/*http://http://www.globalgiving.com/cb/cidi/c_darfur.html;Help
 Sudanese refugees rebuild their lives through GlobalGiving/a./font
~- 

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] run time lookup - get value

2005-08-08 Thread Girish Bhatkal
The lookup now works... 
  i am not sure earlier why it used to always return
value 0. 


--- Girish Bhatkal [EMAIL PROTECTED] wrote:


-
Hi,
  i am trying to have a lookup on a stringEdit field
no datasource/field/EDT attached in the properties. i
have written the following lookup method on the
stringEdit field and I AM ABLE to get the lookup. But
when i select the record the value does not get
selected in the stringEdit field. can anyone tell me
what am i missing.

here tableId and fieldId are selected from another
table.

public void lookup()
{
Query   query   = new Query();
QueryBuildDataSourcequeryBuildDataSource;
SysTableLookup  sysTableLookup;
;

sysTableLookup  =
SysTableLookup::newParameters(tableId,StringEdit);
sysTableLookup.addLookupfield(fieldId,true);

sysTableLookup.addLookupfield(tableId, fieldId);

queryBuildDataSource =
query.addDataSource(tableId);

sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();

}

thanks,

Girish



___

To help you stay safe and secure online, we've
developed the all new Yahoo! Security Centre.
http://uk.security.yahoo.com


Sharing the knowledge on Axapta.

  

  SPONSORED LINKS  
   
Business finance course   
Business to business finance  
 Small business finance   
Business
finance consultant   
Business finance magazine 
  Business finance schools


-
  YAHOO! GROUPS LINKS

  
Visit your group Axapta-Knowledge-Village on the
web.
   
To unsubscribe from this group, send an email to:
 [EMAIL PROTECTED]
   
Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service.

  
-






___ 
To help you stay safe and secure online, we've developed the all new Yahoo! 
Security Centre. http://uk.security.yahoo.com


 Yahoo! Groups Sponsor ~-- 
font face=arial size=-1a 
href=http://us.ard.yahoo.com/SIG=12h2hjnpb/M=362131.6882500.7825259.1493532/D=groups/S=1705001380:TM/Y=YAHOO/EXP=1123524935/A=2889190/R=0/SIG=10r90krvo/*http://www.thebeehive.org
Put more honey in your pocket. (money matters made easy) Welcome to the Sweet 
Life - brought to you by One Economy/a./font
~- 

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] Infolog Log error - Record is dele ted by another user.

2005-07-17 Thread Girish Bhatkal
that's what i said. when you have a record in form 1
which uses  table1. Now when a class is called from
form1 and in the class if the record from the table1
is deleted in the class if the refresh is not properly
made, it will give the said error.


--- Nihar Saraiya [EMAIL PROTECTED]
wrote:

 Hi Girish
  
 No, I am not trying to delete an axapta form per se,
 but a record (line)
 from a form. To be precise, I had this problem, when
 trying to delete a CoA
 line.
  
 Regards
 Nihar Saraiya
  
 -Original Message-
 From: Girish Bhatkal
 [mailto:[EMAIL PROTECTED]
 Sent: Thursday, July 14, 2005 7:11 PM
 To: Axapta-Knowledge-Village@yahoogroups.com
 Subject: Re: [Axapta-Knowledge-Village] Infolog Log
 error - Record is
 deleted by another user.
  
 i think its to do with refresh. 
 Do you get this problem while deleting the standard
 axapta forms?
 
 if you have created a function in which the delete
 happens through a class and on the form you try to
 refresh it, it gives that message??? i am not sure
 if
 the same thing you are facing. 
   If you delete/update the record from another form
 and want the parent form to be refreshed then you
 need
 to refresh the parent form from the child form
 itself.
 
 
 
 --- Subrahmanyam, Mamidi [EMAIL PROTECTED]
 wrote:
 
  I don;t know the any standard solution is there.
 But
  if I get the similar kind of message 'Record is
  already deletd by another user' ,  Axapta asks me
  refresh the form by clicing 'restore'  button on
 the
  command menu...
   
   will see if anyone has any std solution...
   
  -subbu
   
  
  
  Nihar Saraiya [EMAIL PROTECTED]
  wrote:
  
  
  Hi All
  
   
  
  One has Often noticed when at a particular point
 of
  time, when data is being tried to be deleted, an
  Infolog pop's up mentioning that, the record is
  deleted by another user.
  
   
  
  I did check that all the end users have been
 logged
  in with different User Log In names, and would be
  accessing different forms.
  
   
  
  Many users may not have faced this error, but
 still
  I would like to know, what can be done to avoid it
  happening again. Any setup or configuration
  modifications required?
  
   
  
  Regards
  
   
  
  Nihar Saraiya
  
  
  
  Sharing the knowledge on Axapta. 
  
  
  
  -
  YAHOO! GROUPS LINKS 
  
  
  Visit your group Axapta-Knowledge-Village on
  the web.

  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!?
  Tired of spam?  Yahoo! Mail has the best spam
  protection around 
  http://mail.yahoo.com http://mail.yahoo.com  
 
 
 
   
   
 

___
 
 Yahoo! Messenger - NEW crystal clear PC to PC
 calling worldwide with
 voicemail http://uk.messenger.yahoo.com
 http://uk.messenger.yahoo.com 
 
 
 Sharing the knowledge on Axapta. 
 
 
 
 ? LSpots keywords ?? HM ADS ? 
   _  
 
 YAHOO! GROUPS LINKS 
  
 *  Visit your group 
 Axapta-Knowledge-Village

http://groups.yahoo.com/group/Axapta-Knowledge-Village
  on the web.
   
 *  To unsubscribe from this group, send an
 email to:
  
 [EMAIL PROTECTED]

mailto:[EMAIL PROTECTED]
 ribe 
   
 *  Your use of Yahoo! Groups is subject to
 the Yahoo!
 http://docs.yahoo.com/info/terms/  Terms of
 Service. 
  
   _  
 
 




___ 
How much free photo storage do you get? Store your holiday 
snaps for FREE with Yahoo! Photos http://uk.photos.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:
http://docs.yahoo.com/info/terms/
 





RE: [Axapta-Knowledge-Village] Infolog Log error - Record is dele ted by another user.

2005-07-17 Thread Girish Bhatkal
in the method which calls the class in the form, after
the class is called (where the line is deleted) you
could write table_ds.executeQuery()


--- Nihar Saraiya [EMAIL PROTECTED]
wrote:

 That's fine, since I do not have the technical
 background, I may not have
 understood your reply on the 1st place.
  
 Can I conclude that one need to press F5 or use
 'Restore' from the menu,
 'Command'.
  
 Regards
 Nihar Saraiya
  
 -Original Message-
 From: Girish Bhatkal
 [mailto:[EMAIL PROTECTED]
 Sent: Sunday, July 17, 2005 5:59 PM
 To: Axapta-Knowledge-Village@yahoogroups.com
 Subject: RE: [Axapta-Knowledge-Village] Infolog Log
 error - Record is dele
 ted by another user.
  
 that's what i said. when you have a record in form 1
 which uses  table1. Now when a class is called
 from
 form1 and in the class if the record from the table1
 is deleted in the class if the refresh is not
 properly
 made, it will give the said error.
 
 
 --- Nihar Saraiya
 [EMAIL PROTECTED]
 wrote:
 
  Hi Girish
   
  No, I am not trying to delete an axapta form per
 se,
  but a record (line)
  from a form. To be precise, I had this problem,
 when
  trying to delete a CoA
  line.
   
  Regards
  Nihar Saraiya
   
  -Original Message-
  From: Girish Bhatkal
  [mailto:[EMAIL PROTECTED]
  Sent: Thursday, July 14, 2005 7:11 PM
  To: Axapta-Knowledge-Village@yahoogroups.com
  Subject: Re: [Axapta-Knowledge-Village] Infolog
 Log
  error - Record is
  deleted by another user.
   
  i think its to do with refresh. 
  Do you get this problem while deleting the
 standard
  axapta forms?
  
  if you have created a function in which the delete
  happens through a class and on the form you try to
  refresh it, it gives that message??? i am not sure
  if
  the same thing you are facing. 
If you delete/update the record from another
 form
  and want the parent form to be refreshed then you
  need
  to refresh the parent form from the child form
  itself.
  
  
  
  --- Subrahmanyam, Mamidi [EMAIL PROTECTED]
  wrote:
  
   I don;t know the any standard solution is there.
  But
   if I get the similar kind of message 'Record is
   already deletd by another user' ,  Axapta asks
 me
   refresh the form by clicing 'restore'  button on
  the
   command menu...

will see if anyone has any std solution...

   -subbu

   
   
   Nihar Saraiya
 [EMAIL PROTECTED]
   wrote:
   
   
   Hi All
   

   
   One has Often noticed when at a particular point
  of
   time, when data is being tried to be deleted, an
   Infolog pop's up mentioning that, the record is
   deleted by another user.
   

   
   I did check that all the end users have been
  logged
   in with different User Log In names, and would
 be
   accessing different forms.
   

   
   Many users may not have faced this error, but
  still
   I would like to know, what can be done to avoid
 it
   happening again. Any setup or configuration
   modifications required?
   

   
   Regards
   

   
   Nihar Saraiya
   
   
   
   Sharing the knowledge on Axapta. 
   
   
   
   -
   YAHOO! GROUPS LINKS 
   
   
   Visit your group Axapta-Knowledge-Village
 on
   the web.
 
   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!?
   Tired of spam?  Yahoo! Mail has the best spam
   protection around 
   http://mail.yahoo.com http://mail.yahoo.com  
 http://mail.yahoo.com
 http://mail.yahoo.com   
  
  
  


  
 

___
  
  Yahoo! Messenger - NEW crystal clear PC to PC
  calling worldwide with
  voicemail http://uk.messenger.yahoo.com
 http://uk.messenger.yahoo.com 
   http://uk.messenger.yahoo.com
 http://uk.messenger.yahoo.com  
  
  
  Sharing the knowledge on Axapta. 
  
  
  
  ? LSpots keywords ?? HM ADS ? 
_  
  
  YAHOO! GROUPS LINKS 
   
  *  Visit your group 
  Axapta-Knowledge-Village
 
 

http://groups.yahoo.com/group/Axapta-Knowledge-Village
 
=== message truncated ===




___ 
How much free photo storage do you get? Store your holiday 
snaps for FREE with Yahoo! Photos http://uk.photos.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:
http://docs.yahoo.com/info/terms/
 





Re: [Axapta-Knowledge-Village] Aos exam

2005-07-14 Thread Girish Bhatkal
there are a few file uploaded on axapta links site.

http://www.axapta-links.com/

a few documents are available on the axapta CD itself.
which document are you precisely looking for?

--- Mike Matta [EMAIL PROTECTED] wrote:

 My company is signing the contract to purchase
 Axapta and consulting as we speak.  I will be
 heavily involved with developing and implementation.
  I am having major trouble finding training
 materials (can't get anything from the VAR until the
 deals is inked).
 
 Gloria has an outstanding question.  Maybe this is
 common knowledge to Axapta veterans, but to newbies,
 training materials are non-existent.
 
 Any help obtaining training materials would be
 greatly appreciated.
 
 Thanks!
 Mike
   - Original Message - 
   From: Gloria Sun 
   To: Axapta-Knowledge-Village@yahoogroups.com ;
 [EMAIL PROTECTED] 
   Sent: Thursday, July 14, 2005 8:46 AM
   Subject: Re: [Axapta-Knowledge-Village] Aos exam
 
 
 
 
 Thanks for your all answer, I am very
 appreciated for this.
 
 Where can I find 'Deployment (AOS) Course
 Manual'  ebook?
 
 Thanks again,
 
 Gloria.
 
 
 
 


 
 
 
 ANIL OZAY [EMAIL PROTECTED] wrote: 
 
   Hi, 
 
   B and F. I selected these answers in exam.
 
 
   This title is explained  on Deployment (AOS)
 Course Manual ebook. 
 
   Regards,
 Anýl ÖZAY  
 Software Engineer / Axapta Specialist  
 MBSCP , MCP  
 Anadolu Biliþim Hizmetleri A.Þ.  
   
 Telefon  : +90 212 449 39 82  
 Faks  : +90 212 554 12 66  
 e-Posta  : [EMAIL PROTECTED] 
 
 www.bilisimanadolu.com 
 
 
 
 
 
 Gloria Sun [EMAIL PROTECTED] 
 Sent by:
 Axapta-Knowledge-Village@yahoogroups.com 
 14.07.2005 13:50 Please respond to
  
 Axapta-Knowledge-Village@yahoogroups.com 
 
 
To
 Axapta-Knowledge-Village@yahoogroups.com  
   cc  
   Subject [Axapta-Knowledge-Village]
 Aos exam 
 
   
 

 
 
 Hi all, 
 I am preparing for the Axapta server. 
 
 I found this question on the partner
 quide. i would appreciate if anyone tell me what's
 the right choices. 
 An Axapta Server Cluster has been
 established behind a firewall, and each Axapta
 Server runs one AOS instance. Below is a description
 of the IP addresses and the TCP port numbers of each
 instance. 
 Axapta Server One: IP address =
 192.168.10.1, TCP Port = 22035 
 Axapta Server Two: IP Address =
 192.168.10.2, TCP Port = 22035 
 Cluster name is Finance. 
 The following rules exist on the
 firewall: 
   - Allow all incoming TCP traffic on
 TCP port 22035, to IP address 192.168.10.1 
   - Allow all incoming TCP traffic on
 TCP port 22035, to IP address 192.168.10.2 
   - Allow all outgoing UDP traffic on
 Internet interface 
   - Allow all outgoing TCP traffic in
 Internet interface 
   
 What rules need to be set up to gain
 access to the Axapta Server Cluster Finance located
 behind the firewall? (Please select TWO responses) 
 A: Allow incoming TCP traffic on TCP
 Port 22035, from 127.0.0.1, to IP address
 192.168.10.1 
 B: Allow all incoming UDP traffic on TCP
 Port 2712, to IP address 192.168.10.1 
 C: Allow incoming TCP traffic on TCP
 Port 22035, from 127.0.0.1, to IP address
 192.168.10.2 
 D: Allow all incoming UDP traffic on UDP
 Port 2712, to TCP Port 22035 
 E: Allow all incoming TCP traffic on TCP
 port 22035, to IP address 192.168.10.255 
 F: Allow all incoming UDP traffic on TCP
 Port 2712, to IP address 192.168.10.2 
   
 
 Thanks. 


 
 
 
 
   Danny Gaethofs [EMAIL PROTECTED] wrote: 
   Dear all,
 
   In the CRM module there is an import
 relation/prospect journal 
   function which can be found under CRM,
 Periodic, Import.
 
   The file format for importing these relations
 can be defined under 
   CRM, Setup, Contact Management, Import
 
   I have not used this functionality before but
 am investigating 
   whether it could be usefull. 
 
   I need some help here! 
   If I understand it well. The relations and
 contact persons are 
   imported in journals, more precisely
 smmImportRelationJournal, 
   smmImportContactPersonJournal,
 smmImportBusSectorJournal.
   So they are not directly imported in the
 smmBusRelTable nor 
   ContactPerson and smmContactPersonsDetails.
 
   Using the transfer functionality the records
 in the journals can be 
   transferred to the smmBusRelTable,
 ContactPerson and 
   smmContactPersonsDetails.
 
 
   What I need to know here is how should I
 import 

Re: [Axapta-Knowledge-Village] Infolog Log error - Record is deleted by another user.

2005-07-14 Thread Girish Bhatkal
i think its to do with refresh. 
Do you get this problem while deleting the standard
axapta forms?

if you have created a function in which the delete
happens through a class and on the form you try to
refresh it, it gives that message??? i am not sure if
the same thing you are facing. 
  If you delete/update the record from another form
and want the parent form to be refreshed then you need
to refresh the parent form from the child form itself.



--- Subrahmanyam, Mamidi [EMAIL PROTECTED] wrote:

 I don;t know the any standard solution is there. But
 if I get the similar kind of message 'Record is
 already deletd by another user' ,  Axapta asks me
 refresh the form by clicing 'restore'  button on the
 command menu...
  
  will see if anyone has any std solution...
  
 -subbu
  
 
 
 Nihar Saraiya [EMAIL PROTECTED]
 wrote:
 
 
 Hi All
 
  
 
 One has Often noticed when at a particular point of
 time, when data is being tried to be deleted, an
 Infolog pop’s up mentioning that, the record is
 deleted by another user.
 
  
 
 I did check that all the end users have been logged
 in with different User Log In names, and would be
 accessing different forms.
 
  
 
 Many users may not have faced this error, but still
 I would like to know, what can be done to avoid it
 happening again. Any setup or configuration
 modifications required?
 
  
 
 Regards
 
  
 
 Nihar Saraiya
 
 
 
 Sharing the knowledge on Axapta. 
 
 
 
 -
 YAHOO! GROUPS LINKS 
 
 
 Visit your group Axapta-Knowledge-Village on
 the web.
   
 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!?
 Tired of spam?  Yahoo! Mail has the best spam
 protection around 
 http://mail.yahoo.com 






___ 
Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail 
http://uk.messenger.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:
http://docs.yahoo.com/info/terms/
 





RE: [Axapta-Knowledge-Village] [development-axapta] Clearing an Axapta Database of All transactional data

2005-07-14 Thread Girish Bhatkal
as subbu has mentioned its better to use impor/export.
i would have created a new defination group and would
exclude the transactions and others which are not
required and import it in a new company and then
delete the original company.
   i feel its risky to force delete the transactions.

--- Dyachenko, Dmitry [EMAIL PROTECTED]
wrote:

 Ok then. Perhaps, I didn't realize what was the
 problem.
 
  
 
   _  
 
 From: Axapta-Knowledge-Village@yahoogroups.com
 [mailto:[EMAIL PROTECTED] On
 Behalf Of
 Subrahmanyam, Mamidi
 Sent: Wednesday, July 13, 2005 5:02 PM
 To: Axapta-Knowledge-Village@yahoogroups.com
 Subject: RE: [Axapta-Knowledge-Village]
 [development-axapta] Clearing an
 Axapta Database of All transactional data
 
  
 
 Hi Dimitry,
 
  
 
 Just adding my experiece...
 
  
 
 SalesOrders/SalesLine etc etc etc also come under
 dynamic data kind of
 thing.( worksheet and lines) I think Brandon
 wants to delete those
 kind of stuff also along with postings 
 
  
 
 Actually, we had the same scenario. but we actaully
 eliminated these in
 the Import Template We unchecked all except what we
 wanted..But as
 you said its not easy
 
  
 
 I learnt a new classDatabaseTransDelete. I
 didn;t know till now...
 
  
 
 Thanks  regards,
 
 subbu
 
  
 
  
 
 Dyachenko, Dmitry [EMAIL PROTECTED]
 wrote:
 
   As far as I understood guys want to delete just
 those
 transactions, which they created during their
 development step. Or I've
 missed the idea? 
 
   BTW, the class deletes the following categories of
 tables
 
   TableGroup::Transaction:,  WorksheetHeader,
 TableGroup::WorksheetLine
 

 
   
   _  
 
 
   From: Axapta-Knowledge-Village@yahoogroups.com
 [mailto:[EMAIL PROTECTED] On
 Behalf Of Hemant
 Kumthekar
   Sent: Wednesday, July 13, 2005 4:16 PM
   To: Axapta-Knowledge-Village@yahoogroups.com
   Subject: RE: [Axapta-Knowledge-Village]
 [development-axapta]
 Clearing an Axapta Database of All transactional
 data
 

 
   Hi,
 

 
   There is a class called DatabaseTransDelete, this
 claa will
 delete all the transactions from all the tables.
 Note only TRANSACTIONS,
 not the master tables.
 

 
   Hemant
   
   Dyachenko, Dmitry [EMAIL PROTECTED]
 wrote:
 
   Afaik, there is no such a class in core axapta.
 You guys
 need to figure out which tables you want to clean up
 manually and which
 criteria you want to apply. Anyways you'll need to
 recalculate gl
 balance and inventory. Well, taking into account
 that you need to clean
 up ledger transactions... well, it's not gonna be
 easy.
 

 
   
   _  
 
 
   From: Axapta-Knowledge-Village@yahoogroups.com
 [mailto:[EMAIL PROTECTED] On
 Behalf Of Brandon
 George
   Sent: Wednesday, July 13, 2005 3:23 PM
   To: Axapta-Knowledge-Village@yahoogroups.com;
 development-axapta@yahoogroups.com
   Subject: [Axapta-Knowledge-Village]
 [development-axapta]
 Clearing an Axapta Database of All transactional
 data
 

 
   Hello All,
 

 
   We are working with our Axapta Dev
 environment, and
 part of the development process involves Sales
 Transactions, for testing
 out the code we have wrote. We are now ready to cut
 the Application and
 Database to our training environment, BUT we want to
 get rid of all
 Transactions before we do so.
 

 
   Does anyone know of a Class / Job / Code that will
 run
 on an Axapta Database and clear it CORRECTLY of all
 transactional data?
 

 
   thanks in advance,
 
   Brandon
 

 
   
   
   Sharing the knowledge on Axapta. 
 
   
   
   Sharing the knowledge on Axapta. 
   
   
 
   SPONSORED LINKS 
 
 Business finance course

http://groups.yahoo.com/gads?t=msk=Business+finance+coursew1=Business

+finance+coursew2=Business+to+business+financew3=Small+business+financ

ew4=Business+finance+consultantw5=Business+finance+magazinew6=Busines

s+finance+schoolsc=6s=185.sig=I8jDsORmsaYn0BeqghcJ2w
 
 
 Business to business finance

http://groups.yahoo.com/gads?t=msk=Business+to+business+financew1=Bus

iness+finance+coursew2=Business+to+business+financew3=Small+business+f

inancew4=Business+finance+consultantw5=Business+finance+magazinew6=Bu

siness+finance+schoolsc=6s=185.sig=fCzze7cxm1K7TVKkzAaOrA
 
 
 Small business finance

http://groups.yahoo.com/gads?t=msk=Small+business+financew1=Business+

finance+coursew2=Business+to+business+financew3=Small+business+finance

w4=Business+finance+consultantw5=Business+finance+magazinew6=Business

+finance+schoolsc=6s=185.sig=v9sWAno7Kz4WuL8Tadcdhw
 
 
 Business finance consultant
 
=== message truncated ===





RE: [Axapta-Knowledge-Village] SP2 line with zero qty in Update is still shown in printout of delivery and invoice

2005-07-01 Thread Girish Bhatkal
i changed the qty on SalesEditLines i.e the posting
screen. There on Lines tab/Update 
--- James Flavell [EMAIL PROTECTED] wrote:


-
Thanks girish,

You set the qty to zero in the psosting screen is it?
Or on actual sales
line/deliver now?
Just want to check because I tried 2 different std
system and they both
still show for delivery notes and invoices

Mmm just had a thought is it maybe something to do
with selecting to see
backorder quantity??? Let me check
Thanks
James


-Original Message-
From: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On
Behalf Of Girish
Bhatkal
Sent: 01 July 2005 17:16
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] SP2 line with
zero qty in Update is
still shown in printout of delivery and invoice


Hi James,

   yes i have tried that too. Infact when there was a
requirement from a
client that they needed to post the invoice by
delivery note then i that
case all i did was the lines which were not to be
posted i updated the qty
to zero and these lines were neglected. So i am not
sure why this is
happening at ur end. Might be some changes were made
to include all the
lines.

--- James Flavell [EMAIL PROTECTED] wrote:


-
Sorry Girish,

I forgot to mention I had several lines to update and
I just set one of them
as zero qty.  Can you try that instead and see whether
the zero line appears
on the print out with zero qty.

Thanks
James


-Original Message-
From: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On
Behalf Of Girish
Bhatkal
Sent: 01 July 2005 01:07
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] SP2 line with
zero qty in Update is
still shown in printout of delivery and invoice


Hi James,
   i am not sure why its happening at ur end. I just
now created a SO then when posting the delivery note i
changed the Update qty to zero . The order did not get
posted and i got a msg that No lines for posting or
quantity = 0. earlier when there was a requirement of
posting the invoice for only certain lines i just made
the qty = 0 and did have to delete the lines.

--- James Flavell [EMAIL PROTECTED] wrote:

 Hi
  
 I just noticed for sales order  quotation and
 confirmation that if I select
 Qty 'All' and then cahnge the update qty to zero
 then these zero lines do
 not get printed BUT when I do the same during
 delivery or invoice printing
 the zero lines still get printed!!!
  
 In order to not get the zero lines printed I have to
 delete the lines from
 the posting update screen...
  
 Can anyone tell me any good reason for why Axapta
 behaves this way?
 Personnally I think this is an error (i.e. it is not
consistent and if 
 I say update zero then it should consider it outside
of
 the updating)
  
 Anyone know how to fix to make consistent?
  
 Thanks
 James
 



  
  

___

Yahoo! Messenger - NEW crystal clear PC to PC calling
worldwide with
voicemail http://uk.messenger.yahoo.com


Sharing the knowledge on Axapta. 
Yahoo! Groups Links



 




Sharing the knowledge on Axapta.



-
  YAHOO! GROUPS LINKS

  
Visit your group Axapta-Knowledge-Village on the
web.
   
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
   
Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service.

  
-





  
  

___

Yahoo! Messenger - NEW crystal clear PC to PC calling
worldwide with
voicemail http://uk.messenger.yahoo.com


Sharing the knowledge on Axapta. 
Yahoo! Groups Links



 




Sharing the knowledge on Axapta.



-
  YAHOO! GROUPS LINKS

  
Visit your group Axapta-Knowledge-Village on the
web.
   
To unsubscribe from this group, send an email to:
 [EMAIL PROTECTED]
   
Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service.

  
-








___ 
Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail 
http://uk.messenger.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:
http://docs.yahoo.com/info/terms/
 




Re: [Axapta-Knowledge-Village] New demo data

2005-06-18 Thread Girish Bhatkal
thanks. i will give it a try. i have in any case will
contact the MS office at uk to see if we can get the
new demo (if any is available).

cheers,
Girish
--- Hemant Kumthekar [EMAIL PROTECTED] wrote:

 Hi Girish,
  
 I think if you delete the company and re-import the
 data base it will work. In my case also it gave
 error on Axapta 3 Sp3 , I didn't see any items, so I
 deleted the company and re-created the company and
 imported, it will give you the error message for
 inventdims but this time I can see the data in all
 tables. Just give a try.
  
 HK
 
 Girish Bhatkal [EMAIL PROTECTED] wrote:
 Hi ,
 
   does anyone know from where can we get any new
 demo
 data (after the one provided with Sp1).
 
With the old data  (Sp1) i am facing one or the
 other problem. When we import the data on Axapta 3,
 SP4 we get a message that inventDimId axapta is
 already available and did not create this record.
 Because of this on the forms like Item Master,
 sales/purchase form we cannot view the lines. 
 
   When i created a new Item it created a new
 InventDimId in the InventDim table (where in the
 earlier versions it used to be Axapta). Has anyone
 any idea about how to get the new demo data. I have
 also gone through the dataupgrade process in the
 application.
 
 thanks,
 
 Girish
 
 
   
   
 

___
 
 Yahoo! Messenger - NEW crystal clear PC to PC
 calling worldwide with voicemail
 http://uk.messenger.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. 
 
 
 __
 Do You Yahoo!?
 Tired of spam?  Yahoo! Mail has the best spam
 protection around 
 http://mail.yahoo.com 




___ 
How much free photo storage do you get? Store your holiday 
snaps for FREE with Yahoo! Photos http://uk.photos.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:
http://docs.yahoo.com/info/terms/
 




Re: [Axapta-Knowledge-Village] Reserve by code

2005-06-01 Thread Girish Bhatkal
Hi Harry,

 what i have done is that while transfering if the qty
is less in the fromwarehouse i check if its reserved
against a sales line (in inventtrans table). if i find
the line then i remove the reservation and also
include the record (i.e towarehouse,
salesLine.inventTransId, qty) in a new table. Then
when the transfer is done i will go back and again
reserve against the salesLine (i pick the records from
the new table which holds the salesLine and new
warehouse details). It works well.
  thanks again.

cheers,
Girish

--- Harry (Harshawardhan Deshpande
[EMAIL PROTECTED] wrote:

 hi
  
 Yes, this method is used when you know the sales
 order line that has to be reserved.
  
 However, this method will not solve your problem.
 The problem you have is that there is no link
 between the transfer journal and the sales order
 line.
  
 The axapta logic is as follows:
  
 User has transferred 10 items from warehouse A to
 warehouse B.
  
 After the transfer is posted, select any lines
 totalling 10 quantities from the previous dimension
 of the transfer journal (i.e. warehouse A) and try
 to re-reserve the line.
  
 The reservation is handled via multiple methods but
 you will have to make sure that you are calling the
 correct method.
  
 if confused, take a look at updateReserveAgain
 method. The paramters passed to this method are old
 dimension and quantity. This method will first
 select issue transactions from the old dimension
 that matches the quantity and will try to rereserve
 the lines.
  
 regards
  
 harsh 
  
  
  
 
 
 Girish Bhatkal [EMAIL PROTECTED] wrote:
 Hi Harry,
   thanks for the info. i had found that the
 following
 method from class InventUpd_Reservation is used
 while
 reserving from standard sales order form.
 InventUpd_Reservation::updateReserveFromForm
 
 thanks again.
 
 cheers,
 Girish
 --- Harry (Harshawardhan Deshpande
 [EMAIL PROTECTED] wrote:
 
  hi
   
  Say Sales order is on Warehouse MW, Location A1
  Say Purchase order is received on Warehouse MW,
  Location A2
   
  Say a transfer journal is posted from MW-A1 to
 MW-A2
   
  Your sales order is still on MW-A1 so Axapta
 cannot
  reserve the stock against MW-A2.
   
  However, the sales order inventory line status
  remains ReservPhysical this is incorrect since
 there
  is no stock in MW-A1 to reserve against. This is a
  bug.
   
  What you could perhaps do is 
   
  Class: InventUpdate.
   
  Copy method UpdateReserveAgain to a new method
  called say UpdateReserveAgainPhysical (or pass
 new
  paramters to the existing method).
   
  The above method looks for transaction that are
  reserveOrdered, you will have to change this to
 look
  for transactions that are reservedPhysical.
   
  next look at method writeInventTrans line 75 and
 76
  has the following code.
   
  if (reserveAgainDimId)
 
 

this.updateReserveAgain(reserveAgainDimId,_inventTrans.qty);
  
  Insert your own code after these lines ..say...
   
  if (_inventTrans.Qty 0  !reserveAgainDimId
 
  _inventTrans.TransType ==
  InventTransType::InventTransfer)
  this.newmthod(_inventTrans.inventDimId
  ,_inventTrans.qty *-1);
   
  This will atleast set the status of the sales
 order
  back to Ordered
   
  I have not tested this to find out side-effects
 but
  something like this should work.
   
  regards
   
  harsh
  
   
  
  
  Girish Bhatkal [EMAIL PROTECTED] wrote:
  Hi harsh,
  
  here is the scenario in detail
  
  1. i create a PO for an Item A in warehouse MW and
  location 001. i receive the Item A in location
 001.
  
  2. Now i create a SO (with auto reservation) for
  Item
  A and warehouse MW.  Now the system will
  automatically
  reserve the received item.
  
  3. Now since 002 is the outbound location the user
  wants to move  (transfer journal) the item from
  location 001 to 002. 
  
  4. right now since the item was already reserved,
  the
  user has to first go to the sales line , unreserve
  the
  line. then make the transfer journal posting. then
  go
  back to sales line and reserve again.
  
  5. the requirement was that when the transfer
  journal
  is posted, the system should first find the
 reserved
  sales line (if pick list not posted) and unreserve
  it.
  Now the transfer posting should be complted and
 then
  again the reservation to the sales line has to be
  done
  (as this time it will be from new location).
  
  i hope the query is clear now. if you have worked
 on
  something like this then let me know.
have a nice week end.
  cheers,
  Girish
  
  --- Harry (Harshawardhan Deshpande
  [EMAIL PROTECTED] wrote:
  
   hi Girish

   questions:

   If a line has the status of reserved that means
  its
   not yet received. How can you transfer an item
  that
   has not yet been received?

   What am I missing? What you say should work in
   standard axapta

   regards

   harsh
   Girish Bhatkal [EMAIL PROTECTED]
 wrote:
   Hi Guys,
   
  Has any one worked

Re: [Axapta-Knowledge-Village] Reserve by code

2005-05-31 Thread Girish Bhatkal
Hi Harry,
  thanks for the info. i had found that the following
method from class InventUpd_Reservation is used while
reserving from standard sales order form.
InventUpd_Reservation::updateReserveFromForm

thanks again.

cheers,
Girish
--- Harry (Harshawardhan Deshpande
[EMAIL PROTECTED] wrote:

 hi
  
 Say Sales order is on Warehouse MW, Location A1
 Say Purchase order is received on Warehouse MW,
 Location A2
  
 Say a transfer journal is posted from MW-A1 to MW-A2
  
 Your sales order is still on MW-A1 so Axapta cannot
 reserve the stock against MW-A2.
  
 However, the sales order inventory line status
 remains ReservPhysical this is incorrect since there
 is no stock in MW-A1 to reserve against. This is a
 bug.
  
 What you could perhaps do is 
  
 Class: InventUpdate.
  
 Copy method UpdateReserveAgain to a new method
 called say UpdateReserveAgainPhysical (or pass new
 paramters to the existing method).
  
 The above method looks for transaction that are
 reserveOrdered, you will have to change this to look
 for transactions that are reservedPhysical.
  
 next look at method writeInventTrans line 75 and 76
 has the following code.
  
 if (reserveAgainDimId)


this.updateReserveAgain(reserveAgainDimId,_inventTrans.qty);
 
 Insert your own code after these lines ..say...
  
 if (_inventTrans.Qty 0  !reserveAgainDimId 
 _inventTrans.TransType ==
 InventTransType::InventTransfer)
 this.newmthod(_inventTrans.inventDimId
 ,_inventTrans.qty *-1);
  
 This will atleast set the status of the sales order
 back to Ordered
  
 I have not tested this to find out side-effects but
 something like this should work.
  
 regards
  
 harsh
 
  
 
 
 Girish Bhatkal [EMAIL PROTECTED] wrote:
 Hi harsh,
 
 here is the scenario in detail
 
 1. i create a PO for an Item A in warehouse MW and
 location 001. i receive the Item A in location 001.
 
 2. Now i create a SO (with auto reservation) for
 Item
 A and warehouse MW.  Now the system will
 automatically
 reserve the received item.
 
 3. Now since 002 is the outbound location the user
 wants to move  (transfer journal) the item from
 location 001 to 002. 
 
 4. right now since the item was already reserved,
 the
 user has to first go to the sales line , unreserve
 the
 line. then make the transfer journal posting. then
 go
 back to sales line and reserve again.
 
 5. the requirement was that when the transfer
 journal
 is posted, the system should first find the reserved
 sales line (if pick list not posted) and unreserve
 it.
 Now the transfer posting should be complted and then
 again the reservation to the sales line has to be
 done
 (as this time it will be from new location).
 
 i hope the query is clear now. if you have worked on
 something like this then let me know.
   have a nice week end.
 cheers,
 Girish
 
 --- Harry (Harshawardhan Deshpande
 [EMAIL PROTECTED] wrote:
 
  hi Girish
   
  questions:
   
  If a line has the status of reserved that means
 its
  not yet received. How can you transfer an item
 that
  has not yet been received?
   
  What am I missing? What you say should work in
  standard axapta
   
  regards
   
  harsh
  Girish Bhatkal [EMAIL PROTECTED] wrote:
  Hi Guys,
  
 Has any one worked on unreserving and then
  reserving automatically (by coding). Is there
  anything
  that should be taken care of during this
  development.
  
The requirement is that if a reservation is done
  for
  an sales line for item A in warehouse MW then when
 a
  transfer journal is posted to move the item A from
  warehouse MW to warehouse Main then the
  reservation against the sales line should be
 removed
  and then automatically reserve against the item in
  Main warehouse.  Has anyone worked on this
  functionality? 
  
  thanks,
  
  cheers,
  Girish
  
  
  
 

___
  
  How much free photo storage do you get? Store your
  holiday 
  snaps for FREE with Yahoo! Photos
  http://uk.photos.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. 
  
  
  __
  Do You Yahoo!?
  Tired of spam?  Yahoo! Mail has the best spam
  protection around 
  http://mail.yahoo.com 
 
 
 
   
   
 

___
 
 Yahoo! Messenger - NEW crystal clear PC to PC
 calling worldwide with voicemail
 http://uk.messenger.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/
 
=== message

Re: [Axapta-Knowledge-Village] Reserve by code

2005-05-27 Thread Girish Bhatkal
Hi harsh,

here is the scenario in detail

1. i create a PO for an Item A in warehouse MW and
location 001. i receive the Item A in location 001.

2. Now i create a SO (with auto reservation) for Item
A and warehouse MW.  Now the system will automatically
reserve the received item.

3. Now since 002 is the outbound location the user
wants to move  (transfer journal) the item from
location 001 to 002. 

4. right now since the item was already reserved, the
user has to first go to the sales line , unreserve the
line. then make the transfer journal posting. then go
back to sales line and reserve again.

5. the requirement was that when the transfer journal
is posted, the system should first find the reserved
sales line (if pick list not posted) and unreserve it.
Now the transfer posting should be complted and then
again the reservation to the sales line has to be done
(as this time it will be from new location).

i hope the query is clear now. if you have worked on
something like this then let me know.
  have a nice week end.
cheers,
Girish

--- Harry (Harshawardhan Deshpande
[EMAIL PROTECTED] wrote:

 hi Girish
  
 questions:
  
 If a line has the status of reserved that means its
 not yet received. How can you transfer an item that
 has not yet been received?
  
 What am I missing? What you say should work in
 standard axapta
  
 regards
  
 harsh
 Girish Bhatkal [EMAIL PROTECTED] wrote:
 Hi Guys,
 
Has any one worked on unreserving and then
 reserving automatically (by coding). Is there
 anything
 that should be taken care of during this
 development.
 
   The requirement is that if a reservation is done
 for
 an sales line for item A in warehouse MW then when a
 transfer journal is posted to move the item A from
 warehouse MW to warehouse Main then the
 reservation against the sales line should be removed
 and then automatically reserve against the item in
 Main warehouse.  Has anyone worked on this
 functionality? 
 
 thanks,
 
 cheers,
 Girish
 
 
 

___
 
 How much free photo storage do you get? Store your
 holiday 
 snaps for FREE with Yahoo! Photos
 http://uk.photos.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. 
 
 
 __
 Do You Yahoo!?
 Tired of spam?  Yahoo! Mail has the best spam
 protection around 
 http://mail.yahoo.com 






___ 
Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail 
http://uk.messenger.yahoo.com


 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: [Axapta-Knowledge-Village] Multiple packing slips to one sales invoice

2005-05-27 Thread Girish Bhatkal
you need to do some modifications for this. earlier a
few daus back there was a question about a similar
function for which i had explained a work around. in
that case you could select the packing slip nos and
the corresponding qty was updated on the lines.
good luck,

--- ll_guok [EMAIL PROTECTED] wrote:


-
Hi,

 

Has anyone tried printing multiple packing slips on 1
sales invoice 
in Axapta Ver 3.0 SP2? I have the following scenario:

 

Sales Order Number: A001

Sales Order Quantity: 10 pcs

 

Packing Slip No: P001

Packing Slip Quantity: 2 pcs

 

Packing Slip No: P002

Packing Slip Quantity: 3 pcs

 

Packing Slip No: P003

Packing Slip Quantity: 3 pcs

 

I only want to invoice packing slip P001 and P002. If
I go to 
Accounts Receivables - Periodic - Sales Update -
Invoice, in my 
query selection, I link the CustPackingSlipSalesLink
to the Sales 
Order table, and select the Packing Slip Id P001 and
P002, I notice 
that the Update quantity will reflect 8 and not 5.
When I post the 
invoice, all three packing slips are posted on the
invoice, which is 
not what I have selected. 

 

Any way that I can select packing slips to post to the
invoice?

Thanks,
Lee Lee








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.





___ 
How much free photo storage do you get? Store your holiday 
snaps for FREE with Yahoo! Photos http://uk.photos.yahoo.com


 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/
 




[Axapta-Knowledge-Village] Reserve by code

2005-05-26 Thread Girish Bhatkal
Hi Guys,

   Has any one worked on unreserving and then
reserving automatically (by coding). Is there anything
that should be taken care of during this development.

  The requirement is that if a reservation is done for
an sales line for item A in warehouse MW then when a
transfer journal is posted to move the item A from
warehouse MW to warehouse Main then the
reservation against the sales line should be removed
and then automatically reserve against the item in
Main warehouse.  Has anyone worked on this
functionality? 

thanks,

cheers,
Girish



___ 
How much free photo storage do you get? Store your holiday 
snaps for FREE with Yahoo! Photos http://uk.photos.yahoo.com


 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: [Axapta-Knowledge-Village] Purchase Rejections

2005-03-17 Thread Girish Bhatkal

you need to create and post the credit note.

--- deepa_ramarao [EMAIL PROTECTED] wrote:

-


Hi,
 How are purchase rejections handled in Axapta

DR








Sharing the knowledge on Axapta.


Yahoo! Groups Sponsor  ADVERTISEMENT
 

-
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.


Send instant messages to your online friends http://uk.messenger.yahoo.com 


 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] Hi

2005-03-10 Thread Girish Bhatkal

yes, the second database (in second system) should be
able to be connected from the first machine using
ODBC. 

--- panda arabinda [EMAIL PROTECTED] wrote:


-
HI Girish,
Thanks for giving idea.But as per your solution 
the other database should be there in the intranet or
not ? I think one application should be able to talk
with the other database. is not it ?
 
Regards
 Arabinda


--- Girish Bhatkal [EMAIL PROTECTED] wrote:
 Hi santosh,
Well almost everything is possible. But do they
 want just the Sales order and purchase order to
 synchronise. What about the inventory? even though
 you
 get a solution of having the same SO's and PO's
 created and posted, this could happen only if
 inventory is also updated. 
 
   But if the other things are thought of then you
 could write code to read the data from another
 database (using to ODBCConnection). After getting
 the
 data you need to write a function to create the SO's
 and PO's.
   This function has to be written at both the
 applications (assuming they are just copy of the
 same
 application). Then setup to run this function in
 batch, set to run at the end of the day.
 
 hope this would help you.
 
 cheers,
 Girish
 
 
 --- Varden Morris [EMAIL PROTECTED] wrote:
  
  Hi santosh
  
   
  
  I think the solution would be journal entries. You
  can use standard Axapta to export the data from
 the
  SalesTable and SalesLine tables for the sales
 orders
  and the PurchTable and PurchLine tables for the
  purchase orders. 
  
   
  
  After this you could then create tables in Axapta
 to
  hold the data from these tables so that you can
 use
  standard Axapta to import the data.
  
   
  
  You then need to write code to create journal
  entries from these tables and then use standard
  Axapta to post the journals. 
  
   
  
  Varden Morris
  
   
  
  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]   
  
  
  santosh padhi [EMAIL PROTECTED] wrote:Hi
 all
  
  Hi all,
  
My client's requirement is 
  
  there is 2 location.there they wants to setup 2
  separate application and database.There is no
  centrlize server. In 1 location they create 10 p.o
  and
  15 s.o.
  In another location they creates 5 p.o and 10 s.o.
  on
  the same day all the p.o and s.o will
  synchronize.Mean
  in both of the location all the p.o and s.o record
  should updated.How it is possible?
  
  any solution highly appreciated.
  
  santosh
  
 


  Yahoo! India Matrimony: Find your life partner
  online
  Go to: http://yahoo.shaadi.com/india-matrimony
  
  
  Sharing the knowledge on Axapta. 
  
  
  Yahoo! Groups SponsorADVERTISEMENT
  
  
  -
  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. 
  
  
  
  
  -
  Celebrate Yahoo!'s 10th Birthday! 
   Yahoo! Netrospective: 100 Moments of the Web 
 
 Send instant messages to your online friends
 http://uk.messenger.yahoo.com 
 



__ 
Do you Yahoo!? 
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/ 


Sharing the knowledge on Axapta.


Yahoo! Groups Sponsor  ADVERTISEMENT
 

-
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.





__ 
Do you Yahoo!? 
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/ 


 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] Hi

2005-03-09 Thread Girish Bhatkal

Hi santosh,
   Well almost everything is possible. But do they
want just the Sales order and purchase order to
synchronise. What about the inventory? even though you
get a solution of having the same SO's and PO's
created and posted, this could happen only if
inventory is also updated. 

  But if the other things are thought of then you
could write code to read the data from another
database (using to ODBCConnection). After getting the
data you need to write a function to create the SO's
and PO's.
  This function has to be written at both the
applications (assuming they are just copy of the same
application). Then setup to run this function in
batch, set to run at the end of the day.

hope this would help you.

cheers,
Girish


--- Varden Morris [EMAIL PROTECTED] wrote:
 
 Hi santosh
 
  
 
 I think the solution would be journal entries. You
 can use standard Axapta to export the data from the
 SalesTable and SalesLine tables for the sales orders
 and the PurchTable and PurchLine tables for the
 purchase orders. 
 
  
 
 After this you could then create tables in Axapta to
 hold the data from these tables so that you can use
 standard Axapta to import the data.
 
  
 
 You then need to write code to create journal
 entries from these tables and then use standard
 Axapta to post the journals. 
 
  
 
 Varden Morris
 
  
 
 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]   
 
 
 santosh padhi [EMAIL PROTECTED] wrote:Hi all
 
 Hi all,
 
   My client's requirement is 
 
 there is 2 location.there they wants to setup 2
 separate application and database.There is no
 centrlize server. In 1 location they create 10 p.o
 and
 15 s.o.
 In another location they creates 5 p.o and 10 s.o.
 on
 the same day all the p.o and s.o will
 synchronize.Mean
 in both of the location all the p.o and s.o record
 should updated.How it is possible?
 
 any solution highly appreciated.
 
 santosh
 


 Yahoo! India Matrimony: Find your life partner
 online
 Go to: http://yahoo.shaadi.com/india-matrimony
 
 
 Sharing the knowledge on Axapta. 
 
 
 Yahoo! Groups SponsorADVERTISEMENT
 
 
 -
 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. 
 
 
 
   
 -
 Celebrate Yahoo!'s 10th Birthday! 
  Yahoo! Netrospective: 100 Moments of the Web 

Send instant messages to your online friends http://uk.messenger.yahoo.com 


 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: [Axapta-Knowledge-Village] Re: Alternate Parts

2005-03-07 Thread Girish Bhatkal

Hi vshan,
  just be careful before including the dimensions (i
am assuming that by dimensions you mean
Configurations) to identify the alternate items.
Because if you are including the configurations only
to include the alternates then remember that this
configuration would be activated against this Item for
every transacction you make (inventory transactions,
purchases, sales etc..).
i would have advised to include a new table and
make modifications to include the new requirement.
good luck,

cheers,
Girish



--- vshan12_rao [EMAIL PROTECTED] wrote:

-

Hi,
   Thank You. But the user requires a facility wherein
he has an 
option to choose from a list of alternates. He may do
this as the 
rates may vary.  We are trying the option of defining
one part 
number and using dimensions to indicate alternates

vshan


--- In Axapta-Knowledge-Village@yahoogroups.com,
Hemant Kumthekar 
[EMAIL PROTECTED] wrote:
 Hi,
  
 The existing Alternate part is only used in Sales
Order module. 
Axapta will use the Alternate item depending upon the
option you had 
chosen 
  
 1. Never  - No action
 2. Nothing In Inventory - Stock for Item A is
checked and if 
nothing is found looks for Item B which you had
defined as alternate 
and if found in stock Axapta replaces the Sales Order
line with Item 
B
 3. Always - whenever Item A is entered in Sales
Order line, it 
will be replaced by Item B  
  
 If you have to have a list of alternate items for
one item then 
you may have to build a relation as shown below
  
 Item #  Alternate Item
  
 ITEM A  --  ITEM B
 ITEM B  --  ITEM C
 ITEM C  --  ITEM A
  
 So when you try to sell Item A , and if B is not in
stock but C 
has some Qty in Stock , Axapta will suggest Item C
when you try to 
save the Sales Order Line. The above example is true
for the 
option Nothing in Inventory.
  
 HK
  
  
  
  
 
 vshan12_rao [EMAIL PROTECTED] wrote:
 
 Hi, 
   What is the facility for multiple alternate parts
in Axapta? 
 How does the existing alternate part feature work?
 
 vshan
 
 
 
 
 
 Sharing the knowledge on Axapta. 
 
 
 Yahoo! Groups SponsorADVERTISEMENT
 
 
 -
 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. 
 
 
 
 __
 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 Sponsor  ADVERTISEMENT
 

-
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.


Send instant messages to your online friends http://uk.messenger.yahoo.com 


 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] postal code from uk as file for axapta

2005-03-01 Thread Girish Bhatkal

you may have to purchase it from Royal mail or some
other agency.
you can check the below link
http://www.royalmail.com/portal/rm/jump2?mediaId=600127catId=400084

cheers,
Girish


 --- [EMAIL PROTECTED] wrote: 
 hi all,
 
 does anybody knows, where i could get a file for
 axapta whith the postal 
 code from the UK?
 
 thank`s
 
 sascha guettler 

Send instant messages to your online friends http://uk.messenger.yahoo.com 


 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: [Axapta-Knowledge-Village] High Importance!!!! Syntax error after a Int declaration.

2005-02-18 Thread Girish Bhatkal

Hi Raul,

yes it should always be partner's initialls and not
customers. 

 But suppose if you are directly working for an
end client then you could have their Initial. This is
to identify what's standard and what's new.

If your firm has got some outsource work then the
client (which would be an MBS parnter) would always
suggest to have their intials.

When i was working for my ex-employer we used to get
many developement work outsourced by some solution
centres in the US and other countries. They always
wanted us to use their initials (in fact this was one
of their requirement).So this would mean that these
organisation would have a unique initials , no matter
if it was outsourced or work was done inhouse.

   this we did  since way back when we used to work on
version 2.1. This was the requirement of most of the
Solution centres. In this way i cultivated the habit
of adding the prefix as a rule for naming.

  Guys, I am not saying adding suffix or not adding
any identification is wrong. Every one is RIGHT in
what they follow. This is not any individual's
decision. This rule is always decided on
Organisational level, whether if we need any
prefix/sufix added as a rule for naming conventions
and all the developers , within the organisation, have
to follow this rule. 
 As a technical consultant all i could do was give
advise to our clients and it was upto the client to
decide.

But i felt this was a very good discussion and i
am sure we all will be benifited from all the views.  

   Have a nice day

cheers,
Girish


 --- Raul Llorente Peña/OPENSOLUTIONS
[EMAIL PROTECTED] wrote: 

-
The problem of prefixes comes when you want to copy
funcionality from a customer to other, and have a
maintenance plan on them...
customer 1: PelbetPrefix: PLB_
customer 2: Ibmosher Prefix: IBM_
 
Object: PLB_Class1, PLB_CustReport, etc...
Export them, import in Ibmosher... objects called IMB_
with others PLB_ make no much sense... rename them
before importing, or after exporting... ok, now
objects have the right prefix... Pelbet suddenly
complaints about a bug, or want to add funcionality...
Shall I rename every corrected object in every
customer with that funcionality? Urgh, that
doesn't sound clear for me.
 
An intermediate solution could be to prefix objects
with the Partner initials, instead. I don't use to
prefix objects with company names (customer's nor
mine).
 
Raúl Llorente Peña 

Análisis, Desarrollo e Implementación en 
Microsoft Bussiness Solutions-Axapta
OPEN SOLUTIONS


-Paulius Cerniauskas [EMAIL PROTECTED]
escribió: -

Para: Axapta-Knowledge-Village@yahoogroups.com
De: Paulius Cerniauskas [EMAIL PROTECTED]
Fecha: 18/02/2005 09:43
Asunto: RE: [Axapta-Knowledge-Village] High
Importance Syntax error after a Int declaration.

You can find both advantages and disadvantages of
using prefixes. In my practice prefixes is good for
version control and client based object grouping.
Sufixes is good to trace inheritance, e.g. class or
EDT inheritance. As always it depends on your coding
style...
And try to get used to shortcuts F2, F11, Shift+F2
etc. I have found it very usefull...

regards




 
  
 
 Hmmm... are u a systems administrator by any chance?
 
  
 
 Your reasoning is perfectly logical if one is
 thinking from system
 administrator's point of view.
 
  
 
 For me as a programmer, it's the ease of reading the
 code and ease of
 upgrade that is more important. As said earlier,
 while reading the code,
 I don't want the prefix to interfere in my thinking
 and if I extend an
 Axapta table (new table to hold relevant
 information) or create an
 inheritance of a class then I want the new objects
 listed in relevance.
 (for e.g. I have extended InventMov_Purch class and
 given it the name
 InventMov_Purch_ShipmentMMS, this will make sure
 that my class is
 grouped together correctly.
 
  
 
 Adding tables to data import export groups has a
 very limited advantage,
 how many times does anyone do that? And I never use
 the F2 (lookup)
 functionality for coding.
 
  
 
 I was using a prefix in 2001 and have been using a
 suffix since then and
 I can confidently tell you that suffix will improve
 the coding speed in
 the long term. In fact all the solution centres that
 I have worked for
 have gone for the suffix. I would say try it for a
 week and see the
 results.*s*
 
  
 
 Regards
 
  
 
 harry
 
  
 
  
 
   _  
 
 From: Girish Bhatkal
 [mailto:[EMAIL PROTECTED] 
 Sent: Friday, 18 February 2005 12:41 p.m.
 To: Axapta-Knowledge-Village@yahoogroups.com
 Subject: RE: [Axapta-Knowledge-Village] High
 Importance Syntax error
 after a Int declaration.
 
  
 
 Hi Harry,
 from my experience i feel there is always an
 advantage of naming with identifier as a prefix. i.e
 if your client's name is ABCDE then you could pick
 the
 first 3 digits and then write ABC_TableName1. some
 of the advantages are:
 
 1. if you want to include the new