Re: [Axapta-Knowledge-Village] How to do pack slip against a receipt list???

[naveen negi]

Dear,

You what to say based on registration you what to make single packing slip,if 
this the Query then do the folloowing things:-
* AP-->Periodic-->Purchaseorder-->select packing slip-->in parameter 
tab page--> Quantity field --> select registration.
* same tab page  on other option --> summary purchase--> summary update 
-->select invoice account.
 
It will solve your problem.
Take care
Part of Team.




From: Sasi Kumar 
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Thursday, 12 March, 2009 1:18:29 PM
Subject: Re: [Axapta-Knowledge-Village] How to do pack slip against a receipt 
list???


i mean pack slip against regsitration quantities.

i.e PACSLIP1 for 20 nos
PACSLIP 2 for 80 nos.

--- On Thu, 3/12/09, Sasi Kumar  wrote:


From: Sasi Kumar 
Subject: [Axapta-Knowledge- Village] How to do pack slip against a receipt 
list???
To: Axapta-Knowledge- vill...@yahoogro ups.com
Date: Thursday, March 12, 2009, 7:34 AM


Dear All,

I have created a PO for 100 nos. Registered the items on two occasions...
I mean
On 1oth March , i registered 20 nos and
on 11th March , remaining 80 nos registered.

Today i want to do pack slip agianst the regsitered quantities.

Is there any way to do it??

Reply asap.

Regards
Sasi







  Add more friends to your messenger and enjoy! Go to 
http://messenger.yahoo.com/invite/

[Axapta-Knowledge-Village] AX vs NAV

[Tim]

What are the differences between Dynamics AX an NAV? 

What are the advantages one has over the other? 

How different are they to implement? 

Which one has a more promising future? 

Thanks for your insight. 
Tim 

Re: [Axapta-Knowledge-Village] Re: How to do pack slip against a receipt list???

[Sasi Kumar]

HI anil,
 
i need to do the pack slip against the receipt list.
 
PCASLIP1 against RECEIPTLIST1
PACKSLIP2 against RECEIPT LIST 2
 


--- On Thu, 3/12/09, Anil Kumar Sinha  wrote:


From: Anil Kumar Sinha 
Subject: [Axapta-Knowledge-Village] Re: How to do pack slip against a receipt 
list???
To: Axapta-Knowledge-Village@yahoogroups.com
Date: Thursday, March 12, 2009, 8:56 AM


Generate 2 Packing slip. First for 20 nos. and second for 80 nos.
Use Deliver now functionality.

Regards
Anil Sinha

--- In Axapta-Knowledge-Village@yahoogroups.com, Sasi Kumar 
 wrote:
>
> i mean pack slip against regsitration quantities.
>  
> i.e PACSLIP1 for 20 nos
> PACSLIP 2 for 80 nos.
>
> --- On Thu, 3/12/09, Sasi Kumar  wrote:
>
>
> From: Sasi Kumar 
> Subject: [Axapta-Knowledge-Village] How to do pack slip against a receipt 
> list???
> To: Axapta-Knowledge-Village@yahoogroups.com
> Date: Thursday, March 12, 2009, 7:34 AM
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Dear All,
>  
> I have created a PO for 100 nos. Registered the items on two occasions..
> I mean
> On 1oth March , i registered 20 nos and
> on 11th March , remaining 80 nos registered.
>  
> Today i want to do pack slip agianst the regsitered quantities.
>  
> Is there any way to do it??
>  
> Reply asap.
>  
> Regards
> Sasi
>






News-Flash of Axapta Knowledge Village
===
VISIT THE Microsoft Dynamics AX Knowledge Village at LINKEDIN:
http://www.linkedin.com/e/gis/165338.

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

Come and choose your preferred name for Microsoft Dynamics AX on the Axapta 
Knowledge Village, Visit www.axapta-knowledge-village.tk
Yahoo! Groups Links






  

[Axapta-Knowledge-Village] Re: Excel Import - XML generation

[tkbsmanian]

Hi,

1.
Do you need the Excel data into Xml data? Why don't you generate Xml after 
successful Excel import, from table? Not clear need more clarity.

2.
Validation methods from table level will be called based on the validation 
level defined in the definition group used for the excel export/import.

If the validation level is 'None' no validation methods will be called. If it 
is 'Table' only validateWrite() method on the table will be called. If it is 
'Field' then both validateWrite() and validateField() method on the table will 
be called.

Hope this may be helpful.


\Balasubramanian Kumaran

--- In Axapta-Knowledge-Village@yahoogroups.com, Anitha E  
wrote:
>
> Hi all,
> 
> How to generate XML when the data is imported via Excel??
> I could not trace which table level method is called when the data is
> Excel-imported???
> 
> 
> -- 
> Best Regards,
> Anitha Eswaran.
>

RE: [Axapta-Knowledge-Village] sales orders after invoicing

[Alaa Assem]

Thanks guys this is what I was looking for J 

Thanks all for your help 

Regards,

 

Alaa Assem Mohamed

 

From: Axapta-Knowledge-Village@yahoogroups.com
[mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Sumit Loya
Sent: Thursday, 12 March, 2009 10:50 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] sales orders after invoicing

 

Hi,

 

In Accounts Receivable -> Setup -> Parameters -> Update tab

 

There is a setting "Safety level of invoiced orders". If you set it to
"Locked" users cannot change the order after it is invoiced.

 

Regards,

Sumit

On Thu, Mar 12, 2009 at 1:21 PM, Steen Rabol  wrote:

Changing price or qty on invoiced lines would ‘just’ change the order top
open and then the you can invoice it again, but have in mind that the qty
cannot be lower than the original qty and it will result in two invoices for
the same sales order, is that what you want ?

 

 

Fra: Axapta-Knowledge-Village@yahoogroups.com
[mailto:axapta-knowledge-vill...@yahoogroups.com] På vegne af Alaa Assem
Sendt: 12. marts 2009 08:34
Til: Axapta-Knowledge-Village@yahoogroups.com
Emne: [Axapta-Knowledge-Village] sales orders after invoicing

 

Hi,

I just want to know if there is anything that prevents the user from
changing the price and Qty in sales order after it has been invoiced?

Please we need to do this ASAP, so any help would be appreciated.

Thanks in advance all,

Regards,

 

Alaa Assem Mohamed

 

Re: [Axapta-Knowledge-Village] Calling SQL Statement thru Axapta

[Pankaj Gupta]

Bang on mukesh g,, running code on server solved the problem ;)
Thanks reddy too ...Ya the permission should be outside the caller
code.thnks for this valuable info.


On Thu, Mar 5, 2009 at 1:39 PM, sreenath reddy wrote:

>   Hi,
>
> Separate the logic of execution of the execute query in to a different
> method.
>
> Your caller should run on server. For more examples,
>  you can look at releaseupdateDB classes.Here is the separate static method
> for executing the query.
>
> protected static ResultSet statementExeQuery(str_sql,
>  Connection _con = null)
> {
> ResultSet   resultSet;
> Statement   statement;
> ;
>
> try
> {
> if(!_con)
> {
> _con = new Connection();
> }
>
> statement = _con.createStatement();
>
> // Do not call assert() here, do it in the caller
> // BP deviation documented
> resultSet = statement.executeQuery(_sql);
> }
> catch (Exception::Error)
> {
> throw error("@SYS99562");
> }
>
> return resultSet;
> }
>
> Thanks ,
> Sreenath Reddy
>
>
>
> --- On *Wed, 3/4/09, Mukesh Kumar * wrote:
>
>
> From: Mukesh Kumar 
> Subject: Re: [Axapta-Knowledge-Village] Calling SQL Statement thru Axapta
> To: Axapta-Knowledge-Village@yahoogroups.com
> Date: Wednesday, March 4, 2009, 1:00 PM
>
>  Hi Pankaj,
>
>Try to do this by using a class and Set the runon property of the
> class to Server.
>
> Regards,
> Mukesh
>
> On Thu, Feb 19, 2009 at 5:44 PM, Pankaj Gupta  com
> > wrote:
>
>>   Hi Guys!
>>
>> There is one requirement where i need to call a stored procedure of SQL
>> Database (SQL Server 2005) from Ax2009. I have copied my requirment to
>> simplest example below: During the execution of code it throws these errors
>>
>> Request for the permission of type 'SqlStatementExecute Permission'
>> failed.
>> (S)\Classes\ SqlStatementExec utePermission\ demand
>> (S)\Classes\ Statement\ executeQuery
>> (C)\Jobs\StoredProc edure - line 33
>>
>> Cannot select a record in  ().The SQL database has issued an error.
>>
>>  _ _ _ _ _ _
>> _ _ _
>>
>> userConnection = new Connection() ;
>> stmt = userConnection. createStatement( );
>>
>>
>> sql = "select %1 from %2 where %3 = %4 and %5 = %6";//'SO-101245'";
>> sql = strfmt(sql,
>>  ReleaseUpdateDB: :backendFieldNam e(tablenum(
>> SalesTable) , fieldnum(SalesTable , custaccount) ),
>>  ReleaseUpdateDB: :backendTableNam e(tablenum(
>> SalesTable) ),
>>  strfmt(nlslower, ReleaseUpdateDB: :backendFieldNam
>> e(tablenum( SalesTable) , fieldnum(SalesTable , SalesId))),
>>  sqlSystem.sqlLitera l('SO-101245', true),
>>  strfmt(nlslower, ReleaseUpdateDB: :backendFieldNam
>> e(tablenum( SalesTable) , fieldnum(SalesTable , DataAreaId)) ),
>>  sqlSystem.sqlLitera l(Curext( ),true));
>>
>>
>> permission = new SqlStatementExecute Permission( sql);
>> permission.assert( );
>>
>>
>> sqlres = stmt.executeQuery( sql);
>> CodeAccessPermissio n::revertAssert( );
>>
>> sqlres.next( );
>>
>> info(sqlres. getString( 1));
>>  _ _ _ _ _ _
>> _ _ ___
>>
>> Guys I have tried using the LoginProperty class and ODBC connection but no
>> avail. Different error came at times but could not login thru Ax2009. My Sql
>> server is on another machine and m very much have access rights over that
>> machine and SQL Server.
>>
>> Please help me out , wat m missing ?
>> Thnks in advance.
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> --
>> Pankaj Kumar Gupta
>> --
>> Software Developer | MBS Ax.
>> Tectura India. - +91 9953559549.
>>
>
>
>
> --
> Mukesh Mutreja
> # 09818421567
>
>
>  
>



-- 
Pankaj Kumar Gupta
-- 
Software Developer | MBS Ax.
Tectura India. - +91 9953559549.

Re: [Axapta-Knowledge-Village] Ax 2009 Fixed Assets Pdf

[Naeem Sarwar]

http://ax-pmp.weebly.com/axapta.html



On Thu, Mar 12, 2009 at 12:19 PM, Abhay  wrote:

> Does any body have the pdf for Fixed Assets in AX2009.  Please send the
> same if you have it.
>
> Regards
> Abhay
>
> THIS E-MAIL IS CONFIDENTIAL and intended solely for the use of the
> individual to whom it is addressed.
>

Re: [Axapta-Knowledge-Village] Assigning Raw material to operation

[seetharaman subramani]

HI,

Thankyou All

 I got it , but iam getting it only if i go through item > bom (button) >
lines > general tab > opertion no.
Not through inventory mgt > BOM > general tab > opertion no.

Special thanks to Hany & Anilsinha





On Thu, Mar 12, 2009 at 1:54 PM, hany ali  wrote:

>  Dear all,
>
> find the attached file.
>
> To assign a specific RM to an operation follow this path
>
> *Inventory management* > *Bills of materials* > *Lines > General tab > opn
> no. field.*
> **
> then select the opn no. that the RM will only for this operation
>
> Have a nice day
>
> Hany
>
> --- On *Wed, 3/11/09, see_5623 * wrote:
>
>
> From: see_5623 
> Subject: [Axapta-Knowledge-Village] Assigning Raw material to operation
> To: Axapta-Knowledge-Village@yahoogroups.com
> Date: Wednesday, March 11, 2009, 3:47 PM
>
>  Hi All!
>
> How to assign raw material to individual operation which is required at the
> time of that particular operation.
>
> EG:
> Z = X + Y
> X & Y are raw material. Z is finished product.
> Operation :
> 10: Drilling ( here only X is required)
> 20: Assebmling (here Y will be introduced)
>
> Could anyone help me in to assign raw material to individual operation
> which is required at the time of that particular operation.
>
> Thanks in advance,
> See5623
>
>
> 
>

[Axapta-Knowledge-Village] Ax 2009 Fixed Assets Pdf

[Abhay]

Does any body have the pdf for Fixed Assets in AX2009.  Please send the same if 
you have it.Regards
AbhayTHIS E-MAIL IS CONFIDENTIAL and intended solely for the use of the individual
to whom it is addressed.

Re: [Axapta-Knowledge-Village] Runbase reports and reports with dialog method

[Sumit Loya]

Hi,

I can tell you two differences..

1. If you run a report directly class "RunBaseReportStd" is used. This is a
child class of RunBaseReport. But when we create any class for reports we
derive it with RunBaseReport.

2. If you create a class you can have overloading of methods for the fields.
I see that this is not possible in fields in a dialog that are in the report
directly.

Regards,
Sumit

On Wed, Mar 11, 2009 at 7:06 PM, pranam mukher
wrote:

>  Hi all
> I need some clarifications.
> 1.Whats is the difference betweeen runbase reports and we encounter some
> reports in AOT which have Dialog method and GetfromDialog method ??? both
> reports can be catagorized into RunbaseReports.???
>
> Pls justify???
>
>
>
> regards
> Pranam.
>
>
>
>
>
> --
> Get perfect Email ID for your Resume. Get before others 
> grab.
>
> 
>

Re: SV: SV: [Axapta-Knowledge-Village] Axapta Com PHP

[nicoschueller]

Super!

This is a very big help for me!

Thanks!


--- In Axapta-Knowledge-Village@yahoogroups.com, "Steen Rabol"  
wrote:
>
> Yes a XML document as parameter
> 
>  
> 
>  
> 
> e.g 
> 
> $xml =  "";
> 
> $xml .= ""1234567";
> 
> $xml .= "Customer name";
> 
> $xml .= "";
> 
>  
> 
> Then 
> 
>  
> 
> $result = $axObj->CallStaticMethod("MyClass", "MyMethod", $xml);
> 
>  
> 
> If($result == -1)
> 
>Echo  "Some ax error…";
> 
> Else
> 
> Echo "Custname updated";
> 
>  
> 
>  
> 
> Then in AX, in class `MyClass' have a method
> 
>  
> 
> Public static server int MyMethod(str param)
> 
> {
> 
> XmlDocument doc = XmlDocument();
> 
> XmlElement root,item;
> 
> CustAccountcustAccount;
> 
> CustNamecustName;
> 
> CustTable custTable;
> 
>;
> 
>  
> 
> doc.loadXml(param);
> 
> root = doc.getNamedElement(`parameters');
> 
>  
> 
> if(!root)
> 
> {
> 
> // Define your error codes
> 
> return -1;
> 
> }
> 
>  
> 
> // Extract parameters
> 
> custAccount = root.getNamedElement("custaccount").innerText();
> 
> custName= root.getNameElement("custname").innerText();
> 
> ttsbegin;
> 
> custTable = CustTable::find(custAccount,true);
> 
> custTable.name = custName;
> 
> custTable.update();
> 
> ttscommit;
> 
>  
> 
> return 1; // Ok
> 
> }
> 
>  
> 
> Hope that it help.
> 
>  
> 
> Best
> 
> Steen

[Axapta-Knowledge-Village] Re: How to do pack slip against a receipt list???

[Anil Kumar Sinha]

Generate 2 Packing slip. First for 20 nos. and second for 80 nos.
Use Deliver now functionality.

Regards
Anil Sinha

--- In Axapta-Knowledge-Village@yahoogroups.com, Sasi Kumar 
 wrote:
>
> i mean pack slip against regsitration quantities. 
>  
> i.e PACSLIP1 for 20 nos
> PACSLIP 2 for 80 nos.
> 
> --- On Thu, 3/12/09, Sasi Kumar  wrote:
> 
> 
> From: Sasi Kumar 
> Subject: [Axapta-Knowledge-Village] How to do pack slip against a receipt 
> list???
> To: Axapta-Knowledge-Village@yahoogroups.com
> Date: Thursday, March 12, 2009, 7:34 AM
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> Dear All,
>  
> I have created a PO for 100 nos. Registered the items on two occasions.. 
> I mean
> On 1oth March , i registered 20 nos and 
> on 11th March , remaining 80 nos registered.
>  
> Today i want to do pack slip agianst the regsitered quantities. 
>  
> Is there any way to do it?? 
>  
> Reply asap.
>  
> Regards
> Sasi
>

[Axapta-Knowledge-Village] Re: sales orders after invoicing

[Anil Kumar Sinha]

There is a field in AR Parameter where you can setup whether invoiced sales 
order can be modified or not. Field name is "Safety Level of Invoiced order" on 
"Updates" tab. Set this field to "Locked". 
Then no one can modify the invoiced order.

Regards
Anil Sinha


--- In Axapta-Knowledge-Village@yahoogroups.com, "Alaa Assem"  
wrote:
>
> Hi,
> 
> I just want to know if there is anything that prevents the user from changing 
> the price and Qty in sales order after it has been invoiced?
> 
> Please we need to do this ASAP, so any help would be appreciated.
> 
> Thanks in advance all,
> 
> Regards,
> 
>  
> 
> Alaa Assem Mohamed
>

Re: [Axapta-Knowledge-Village] sales orders after invoicing

[Sumit Loya]

Hi,

In Accounts Receivable -> Setup -> Parameters -> Update tab

There is a setting "Safety level of invoiced orders". If you set it to
"Locked" users cannot change the order after it is invoiced.

Regards,
Sumit

On Thu, Mar 12, 2009 at 1:21 PM, Steen Rabol  wrote:

>Changing price or qty on invoiced lines would ‘just’ change the order
> top open and then the you can invoice it again, but have in mind that the
> qty cannot be lower than the original qty and it will result in two invoices
> for the same sales order, is that what you want ?
>
>
>
>
>
> *Fra:* Axapta-Knowledge-Village@yahoogroups.com [mailto:
> axapta-knowledge-vill...@yahoogroups.com] *På vegne af *Alaa Assem
> *Sendt:* 12. marts 2009 08:34
> *Til:* Axapta-Knowledge-Village@yahoogroups.com
> *Emne:* [Axapta-Knowledge-Village] sales orders after invoicing
>
>
>
> Hi,
>
> I just want to know if there is anything that prevents the user from
> changing the price and Qty in sales order after it has been invoiced?
>
> Please we need to do this ASAP, so any help would be appreciated.
>
> Thanks in advance all,
>
> Regards,
>
>
>
> Alaa Assem Mohamed
>
>  
>

Re: [Axapta-Knowledge-Village] (unknown)

[Anitha E]

Hi..
Thanks for the suggestion..

I am able to import the excel data and generate XML for the same.
included the outbound logic in Definition group -> import criteria.

Now it is working fine.

I shall try point no:2 mentioned in ur mail.
Thanks.

Regards,
Anitha.
On Thu, Mar 12, 2009 at 1:06 AM, balasubramanian kumaran <
tkbsman...@yahoo.com> wrote:

> Hi,
>
> 1.
> Do you need the Excel data into Xml data? Why don't you generate Xml after
> successful Excel import, from table? Not clear need more clarity.
>
> 2.
> Validation methods from table level will be called based on the validation
> level defined in the definition group used for the excel export/import.
>
> If the validation level is 'None' no validation methods will be called. If
> it is 'Table' only validateWrite() method on the table will be called. If it
> is 'Field' then both validateWrite() and validateField() method on the table
> will be called.
>
> Hope this may be helpful.
>
>
> \Balasubramanian Kumaran
>
>
>
>
>
> --
> Share files, take polls, and make new friends - all under one roof. Click
> here.
>
> 
>

Re: [Axapta-Knowledge-Village] How to do pack slip against a receipt list???

[Sasi Kumar]

i mean pack slip against regsitration quantities. 
 
i.e PACSLIP1 for 20 nos
PACSLIP 2 for 80 nos.

--- On Thu, 3/12/09, Sasi Kumar  wrote:


From: Sasi Kumar 
Subject: [Axapta-Knowledge-Village] How to do pack slip against a receipt 
list???
To: Axapta-Knowledge-Village@yahoogroups.com
Date: Thursday, March 12, 2009, 7:34 AM















Dear All,
 
I have created a PO for 100 nos. Registered the items on two occasions.. 
I mean
On 1oth March , i registered 20 nos and 
on 11th March , remaining 80 nos registered.
 
Today i want to do pack slip agianst the regsitered quantities. 
 
Is there any way to do it?? 
 
Reply asap.
 
Regards
Sasi






  

SV: [Axapta-Knowledge-Village] sales orders after invoicing

[Steen Rabol]

Changing price or qty on invoiced lines would ‘just’ change the order top open 
and then the you can invoice it again, but have in mind that the qty cannot be 
lower than the original qty and it will result in two invoices for the same 
sales order, is that what you want ?

 

 

Fra: Axapta-Knowledge-Village@yahoogroups.com 
[mailto:axapta-knowledge-vill...@yahoogroups.com] På vegne af Alaa Assem
Sendt: 12. marts 2009 08:34
Til: Axapta-Knowledge-Village@yahoogroups.com
Emne: [Axapta-Knowledge-Village] sales orders after invoicing

 

Hi,

I just want to know if there is anything that prevents the user from changing 
the price and Qty in sales order after it has been invoiced?

Please we need to do this ASAP, so any help would be appreciated.

Thanks in advance all,

Regards,

 

Alaa Assem Mohamed

[Axapta-Knowledge-Village] How to do pack slip against a receipt list???

[Sasi Kumar]

Dear All,
 
I have created a PO for 100 nos. Registered the items on two occasions. 
I mean
On 1oth March , i registered 20 nos and 
on 11th March , remaining 80 nos registered.
 
Today i want to do pack slip agianst the regsitered quantities. 
 
Is there any way to do it?? 
 
Reply asap.
 
Regards
Sasi


  

[Axapta-Knowledge-Village] sales orders after invoicing

[Alaa Assem]

Hi,

I just want to know if there is anything that prevents the user from changing 
the price and Qty in sales order after it has been invoiced?

Please we need to do this ASAP, so any help would be appreciated.

Thanks in advance all,

Regards,

 

Alaa Assem Mohamed