RE: [development-axapta] Copy Item to another company/dataarea
Hi, There are two methods. 1. Export it using Administration Periodic Export Need to setup the definition group. Then select the corresponding tables you want to export. 2. Create a job using the changecompany() function. Regards From: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] On Behalf Of axaeffect Sent: Wednesday, April 21, 2010 12:36 PM To: development-axapta@yahoogroups.com Subject: [development-axapta] Copy Item to another company/dataarea Hi all, How to copy item (InventTable, InventTableModule, InventeItemLocation) to another company/dataarea? Kindly advise, Thanks, Axl [Non-text portions of this message have been removed]
RE: [development-axapta] Unable to move form fields around
Hi, Maybe this field is with a group. Try dragging a field in the data source and put it in the design. From: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] On Behalf Of shamika Sent: Tuesday, April 20, 2010 11:28 PM To: development-axapta@yahoogroups.com Subject: [development-axapta] Unable to move form fields around Hello, I am unable to move form fields around. Columns in header of PO status form can not moved around. Line columns are moving around. I checked respective design properties and all are set properly. Any thoughts?? Thanks, Sam [Non-text portions of this message have been removed]
RE: [development-axapta] Re: Using Display methods...
Hi Khan,
If you are using wrong types of return, AX will automatically give you an
error msg. It's okay to use the primitive data types but the best practice
is use the EDT. No need to query Purchline. In VendPackingslipTrans there is
a method named purchine. You can already get the purchprice and the payment.
From: development-axapta@yahoogroups.com
[mailto:development-axa...@yahoogroups.com] On Behalf Of BURAK UYGUR
Sent: Thursday, April 08, 2010 2:50 PM
To: development-axapta@yahoogroups.com
Subject: RE: [development-axapta] Re: Using Display methods...
Hi Khan,
Try these;
- Be sure of set rigth DataSource property of these objects in report
design.
- Be sure of your PurchLine has a RecId (You can find it by debug)
- I assume that your query like this: VendPackingSlipTrans - PurchLine, in
this case if your body has VendPackingSlipTrans datasource PurchLine won't
have RecId and won't show any data.
Burak
From: development-axapta@yahoogroups.com
mailto:development-axapta%40yahoogroups.com
[mailto:development-axapta@yahoogroups.com
mailto:development-axapta%40yahoogroups.com ] On Behalf Of ricardopichler
Sent: Tuesday, April 06, 2010 7:37 PM
To: development-axapta@yahoogroups.com
mailto:development-axapta%40yahoogroups.com
Subject: [development-axapta] Re: Using Display methods...
Hi Khan Axapta,
This happen because you are using wrong types to return. Try to change the
first to PurchPrice and the second to VendPaymTermId. I don't know why, but
the display methods doesn't work when you use primary data type to return.
[]s
Pichler
--- In development-axapta@yahoogroups.com
mailto:development-axapta%40yahoogroups.com
mailto:development-axapta%40yahoogroups.com, Khan Axapta
axaptak...@...mailto:axaptak...@... wrote:
Hi Friends,
I am a new guy doing Technical stuff AX.
I am creating a report from VendPackingSlipTans
I have created 2 display method on PurchLine Table to display
Purchaseprice PaymentMethod
display real ItmPrice()
{
PurchLine purchLine;
;
select PurchPrice from purchLine
where purchLine.ItemId == this.ItemId purchLine.PurchId ==
this.purchId;
info(this.ItemId);
info(purchLine.ItemId);
return purchLine.PurchPrice;
}
-
display str DelTerms()
{
PurchTable purchTable;
;
select Payment from purchTable
where purchTable.PurchId == this.PurchId;
return purchTable.Payment;
}
--
I am using these methods in VendPackingSlipTrans to display purchasePrice
PaymentMethod.
But when i run the report both coloumns are coming blank.
Kindly Advice what might be the reason.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
RE: [development-axapta] Fw: [Axapta-Knowledge-Village] Display methods...
Hello,
It will be much easier to use this.
In the VendPackingSlipTrans theres is a method purchline. It will not be
accurate if your condition is just itemid. Need to know the InventTransId.
Display real ItmPrice()
{
;
Return this.purchline().PurchPrice;
}
The data will not show if you haven’t put a datasource on the display method
you put in the report.
Hope this will help you.
From: development-axapta@yahoogroups.com
[mailto:development-axa...@yahoogroups.com] On Behalf Of Khan Axapta
Sent: Tuesday, April 06, 2010 3:28 PM
To: mail2eani...@gmail.com
Cc: AX Knowledge; development axapta
Subject: [development-axapta] Fw: [Axapta-Knowledge-Village] Display methods...
Hi Anitha,
Thanks for your reply.
I am trying to create a report with the below fields. I am using only one Table
: VendPackingSlipTrans
VendPackingSlipTrans Table : fields
purchId
ItemId
Name
Purch_Unit
PackingSlipId
DeliveryDate
Ordered
Qty
Remain
for the purchase price field in the report of the Item i have created a method
on PurchLine Table
display real ItmPrice()
{
PurchLine purchLine;
;
select PurchPrice from purchLine
where purchLine.ItemId == this.ItemId purchLine.PurchId == this.purchId;
return purchLine.PurchPrice;
}
Since PurchasePrice DeliveryTerms fields are not available in
VendPackingSlipTrans Table
I have created a field : Real in the report Body Properties are :
Table : PurchLine
DataMethod : itmPrice
the same way i am following for Delivery Terms.
display str DelTerms()
{
PurchTable purchTable;
;
select Payment from purchTable
where purchTable.PurchId == this.PurchId;
return purchTable.Payment;
}
PO Item Name
from
VendPackingSlipTrans Table
UOM
from
VendPackingSlipTrans Table CURRENCY
from
VendPackingSlipTrans Table Price
from
Method on
PurchLine Table ORDER QTY
from
VendPackingSlipTrans Table
RECD. QTY
from
VendPackingSlipTrans Table BAL. QTY
from
VendPackingSlipTrans Table STATUS
from
VendPackingSlipTrans Table PAYMENT TERM
from
Method on
PurchLine Table GRN No
from
VendPackingSlipTrans Table GRN Date
from
VendPackingSlipTrans Table Delivery Schedule 1
Delivery Schedule 11
MFS 40% kg sar 2.5 250 250 0 Closed 30days
Hope this is clear for you, Kindly advice me how solve this issue.
BR
Khan.
- Forwarded Message
From: Anitha Santosh mail2eani...@gmail.com mailto:mail2eanitha%40gmail.com
To: axapta-knowledge-vill...@yahoogroups.com
mailto:Axapta-Knowledge-Village%40yahoogroups.com
Sent: Tue, April 6, 2010 9:06:00 AM
Subject: Re: [Axapta-Knowledge-Village] Display methods...
Khan,
I guess you have attached the method in Body part of the report design.
what is the table name property in the Body ??
If the table name is not PurchLine , the values will not be displayed.
Mail me if you have further doubts.
Regards,
AnithaSantosh
On Sun, Apr 4, 2010 at 7:53 PM, Khan Axapta axaptak...@yahoo. com wrote:
Hi Friends,
I am a new guy doing Technical stuff AX.
I am creating a report from VendPackingSlipTans
I have created 2 display method on PurchLine Table to display
Purchaseprice PaymentMethod
display real ItmPrice()
{
PurchLine purchLine;
;
select PurchPrice from purchLine
where purchLine.ItemId == this.ItemId purchLine.PurchId == this.purchId;
info(this.ItemId) ;
info(purchLine. ItemId);
return purchLine.PurchPric e;
}
- - - - -
display str DelTerms()
{
PurchTable purchTable;
;
select Payment from purchTable
where purchTable.PurchId == this.PurchId;
return purchTable.Payment;
}
- - - - --
I am using these methods in VendPackingSlipTran s to display purchasePrice
PaymentMethod.
But when i run the report both coloumns are coming blank.
Kindly Advice what might be the reason.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
RE: [development-axapta] Security Key
Hello, Don’t need the profiler. Just check the user account inside ax then check what is his permission. Ruel From: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] On Behalf Of Hemant Kumthekar Sent: Friday, March 12, 2010 10:31 PM To: development-axapta@yahoogroups.com Subject: Re: [development-axapta] Security Key Hi, There is a security profiler tool which can be used to check the access. You need to get that from Microsoft support. Hemant From: shamika shamik...@yahoo.com mailto:shamikask%40yahoo.com To: development-axapta@yahoogroups.com mailto:development-axapta%40yahoogroups.com Sent: Thu, March 11, 2010 2:29:07 PM Subject: [development-axapta] Security Key Hello, I wanted to check security key access of logged-in user. Lets say, userId is dev11. Then I want to check whether dev11 has full access for security key, say VendKey (which is maintained in some table as a parameter). Does anybody have an idea about how to do the same? Please let me know. Thanks in advance, Sam [Non-text portions of this message have been removed] __ Information from ESET NOD32 Antivirus, version of virus signature database 4944 (20100314) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com __ Information from ESET NOD32 Antivirus, version of virus signature database 4944 (20100314) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com [Non-text portions of this message have been removed]
RE: [development-axapta] Customization Problem
Hi, Actually Ax have 2 inventdimid in transfer. InventdimId and InventdimIdto. Try to read the code of InventJourtransfer form. You will see how the InventDimId is supplied. Regards From: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] On Behalf Of Åßü Ôwãî§ Sent: Wednesday, February 24, 2010 3:54 AM To: development-axapta@yahoogroups.com Subject: [development-axapta] Customization Problem Hi, I have done customization thru which I am taking input of serial number in itemid field and then thru code have replaced itemid with corresponding itemid and inventdim id. The customization is running successfully on Sales Order and Purchase Order forms but on Transfer orders it is not running properly and inventdimid is automatically replaced with default inventdimid. When I debugged the code in modified method of ItemId field of Transfer orders form I found out that \Classes\FormStringControl\modified method is also called soon after this which might be resetting inventdimid. I will be very grateful if anyone of you could help me solving this problem. Thanks in advance. Abu Owais [Non-text portions of this message have been removed] __ Information from ESET NOD32 Antivirus, version of virus signature database 4910 (20100302) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com __ Information from ESET NOD32 Antivirus, version of virus signature database 4910 (20100302) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com __ Information from ESET NOD32 Antivirus, version of virus signature database 4913 (20100303) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com [Non-text portions of this message have been removed]
RE: [development-axapta] Re: Query extended range failure, linking InventTrans and InventDim
Hi,
Try using View. Create a view for your lookup form. Don't need to trouble
yourself. Then you just need to filter it out in you form.
Regards
From: development-axapta@yahoogroups.com
[mailto:development-axa...@yahoogroups.com] On Behalf Of pkpeterson652
Sent: Tuesday, March 02, 2010 9:49 PM
To: development-axapta@yahoogroups.com
Subject: [development-axapta] Re: Query extended range failure, linking
InventTrans and InventDim
Of course as soon as I submitted this, found the problem. Changed the
addRange for InventSerial id to value(SysQuery::valueEmptyString());
Paul
--- In development-axapta@yahoogroups.com
mailto:development-axapta%40yahoogroups.com , pkpeterson652
ppeter...@... wrote:
Creating a custom lookup Form and when I execute the lookup I receive the
following message:
Query extended range failure: InventDim.InventSerialId is not a valid
datasource.field pair near pos 29.
What I want selected from InventTrans is:
1. Records associated with a particluar Production order (ItemId and
InventTransId selections)
2. Records that aren't associated with a serial number.
In the init method of the data source (InventTrans) I have coded the
following:
public void init()
{
Query q;
QueryBuildDataSource qB;
QueryBuildDataSource qB2;
;
super();
q = new Query();
qB = q.addDataSource(tablenum(InventTrans));
qB.addRange(Fieldnum(InventTrans,ItemId)).value(prodTable.itemid);
qB.addRange(FieldNum(InventTrans,InventTransId)).value(prodTable.InventTrans
Id);
qB.addRange(FieldNum(InventTrans,Qty)).value(' 0');
qB2 = qB.addDataSource(tablenum(InventDim));
qB2.addLink(FieldNum(InventTrans,
InventDimId),fieldNum(InventDim,InventDimid), qB.name());
qB2.addRange(Fieldnum(InventDim,InventSerialId)).value(strfmt('(%1.%2 =
)', 'InventDim', fieldStr(InventDim, InventSerialId)));
qB2.joinMode(JoinMode::InnerJoin);
this.query(q);
}
The query that is built from the above looks like this:
SELECT * FROM InventTrans WHERE ((ItemId = N'038020AH')) AND
((InventTransId = N'LOT003279')) AND ((Qty0)) JOIN * FROM InventDim WHERE
InventTrans.inventDimId = InventDim.inventDimId AND
(((InventDim.InventSerialId = )))
Don't understand the reason for the message and what what I need to change
to eliminate it.
Any help would be appreciated, Paul
__ Information from ESET NOD32 Antivirus, version of virus signature
database 4910 (20100302) __
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
__ Information from ESET NOD32 Antivirus, version of virus signature
database 4910 (20100302) __
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
__ Information from ESET NOD32 Antivirus, version of virus signature
database 4913 (20100303) __
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
[Non-text portions of this message have been removed]
RE: [development-axapta] Can we have Serial Number in Packing Slip?
Hi, Try to do marking then after that put the total qty in the received now field. The when you are posting select in the posting combo box received now. Problem solve. Regards From: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] On Behalf Of enki...@free.fr Sent: Tuesday, March 02, 2010 9:59 PM To: development-axapta@yahoogroups.com Subject: Re: [development-axapta] Can we have Serial Number in Packing Slip? Hi, concerning your first point, il you don't pass through picking list or register on your sales lines, how could the application know which serial numbers are picked from stock ? Maybe your point is to automaticaly link the packing slip generation for each picking list you validate. For the second point, you just have to go to : Account payable | Setup | Forms | Form setup. On packing slip tab, you check the serial number checkbox. Regards, Geoffrey - Mail Original - De: Loganathan S sivl...@yahoo.com mailto:sivlogu%40yahoo.com À: development-axapta@yahoogroups.com mailto:development-axapta%40yahoogroups.com Envoyé: Mercredi 24 Février 2010 07:09:52 GMT +01:00 Amsterdam / Berlin / Berne / Rome / Stockholm / Vienne Objet: [development-axapta] Can we have Serial Number in Packing Slip? Hi there, We would like have the following for one of our customer. Most of the the Item having Serial Numbers (We did the required setups in Item) 1. How we can post packing slip without Picking List? 2. Can we select Serial Number in Packing Slip? (Ax providing option to select in Pick List Registration. However our customer dont want Picking List and its registrattion. They want single step registration of Packing Slip with Serial Number) How the above two can be achived? Thanks in Advance, Loganathan S __ Information from ESET NOD32 Antivirus, version of virus signature database 4910 (20100302) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com __ Information from ESET NOD32 Antivirus, version of virus signature database 4910 (20100302) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com __ Information from ESET NOD32 Antivirus, version of virus signature database 4911 (20100303) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com [Non-text portions of this message have been removed]
RE: [development-axapta] How to Enter group of field data in One Text field.
Khalil UR Rehman,
Try to put a code in the modified method of the said field and concatenate
all.
Example:
public void modifiedField(fieldId _fieldId)
{
super(_fieldId);
switch (fieldExt2Id(_fieldId))
{
case fieldnum(InventTable, ItemId):
this.ItemName = this.ItemName ? this.ItemName : this.ItemId;
this.setNameAlias();
// added code
this.NewField = Item Number + Item Name + Dimension Group + Hieght + Width +
Depth;
//
break;
}
}
From: development-axapta@yahoogroups.com
[mailto:development-axa...@yahoogroups.com] On Behalf Of Khalil Rehman
Sent: Sunday, December 13, 2009 5:38 AM
To: Knowlege Village; Adeel AX Technical Consultant; AX Consultant Sumit
Loya; Development Axapta; Development Group
Subject: [development-axapta] How to Enter group of field data in One Text
field.
Dear All,
in Inventory Master form, i have a requirement that if i enter Data in Item
Number, Item Name, Dimension Group, Hieght, Width, Depth fields. it should
be combined in a new field place on form automatically.
thanks regards.
KHALIL UR REHMAN
__
Windows Live Hotmail: Your friends can get your Facebook updates, right from
HotmailR.
http://www.microsoft.com/middleeast/windows/windowslive/see-it-in-action/soc
ial-network-basics.aspx?ocid=PID23461::T:WLMTAGL:ON:WL:en-xm:SI_SB_4:092009
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
RE: [development-axapta] Dynamics Connection Error
Hello, Try to join the client in a workgroup then join it again in the domain. Sometimes client tend to loose the connection to the domain -Original Message- From: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] On Behalf Of suneel babu Sent: Saturday, 30 May, 2009 5:10 PM To: Development; Axapta Knowledge village; Arjit babu Ax; amit bhatt AX Subject: [development-axapta] Dynamics Connection Error Dear All., I had problem of AOS connection from my client systems. when i try to connect from the client to AOS it throws Failed to establish connection. In AOS system it connected, I try to ping the Server IP and Port from the client it was working properly. And client configuration also ok. I try to save the configuration file from the AOS and copy the file to client system. Even that was unsuccessfull. Any one help me regarding the error., Regards., Suneel. _ Drag n' drop-Get easy photo sharing with Windows LiveT Photos. http://www.microsoft.com/india/windows/windowslive/photos.aspx [Non-text portions of this message have been removed] Yahoo! Groups Links
RE: [development-axapta] SetCurrent method on Axapta
Hello,
inventDim.data(InventDim::find(inventQuarantineOrder.InventDimId)); //
replace the data with the new search data
inventDim_ds.setCurrent(); // makes it current
_
From: development-axapta@yahoogroups.com
[mailto:development-axa...@yahoogroups.com] On Behalf Of pranam mukher
Sent: Friday, 22 May, 2009 2:13 PM
To: axa knwoldge
Cc: dev ax
Subject: [development-axapta] SetCurrent method on Axapta
hi all
Could you please tel me what is the purpose of the method
setCurrent()
For Ex:
if (inventQuarantineOrder.InventDimId != inventDim.InventDimId)
{
inventDim.data(InventDim::find(inventQuarantineOrder.InventDimId));
inventDim_ds.setCurrent();
}
Please help me on this.
Share files, take polls, and make new friends - all under one roof. Go to
http://in.promos. http://in.promos.yahoo.com/groups/ yahoo.com/groups/
[Non-text portions of this message have been removed]
__ NOD32 4099 (20090525) Information __
This message was checked by NOD32 antivirus system.
http://www.eset.com
[Non-text portions of this message have been removed]
RE: [development-axapta] Error whle running Sales tax payment
Abhay, That error message actually occur when you're doing the update command in table. Maybe your select forupdate haven't returned any record. Ex. Select forupdate table If (table) - add this validation to know if your select statement have record Table.update() _ From: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] On Behalf Of Abhay Sent: Thursday, 02 April, 2009 9:27 PM To: development-axapta@yahoogroups.com Cc: axapta-knowledge-vill...@yahoogroups.com Subject: [development-axapta] Error whle running Sales tax payment Dear All, If I enter a Purchase Order with Sales tax or VAT and then run the Sales tax Payment Cycle I am getting the following error please help urgent requirement .Cannot edit a record in Adjustment (TaxAdjustments_IN). The record has never been selected. I do not know why this eror is appearing when the records exist in the posted Journal Voucher. Regards Abhay [Non-text portions of this message have been removed] __ NOD32 4005 (20090413) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com [Non-text portions of this message have been removed]
RE: [development-axapta] Where is comming from this transaction?
Hello, You can use the inventrans also. Try looking for the voucher. _ From: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] On Behalf Of jquinteroz Sent: Wednesday, 08 April, 2009 11:26 PM To: development-axapta@yahoogroups.com Subject: [development-axapta] Where is comming from this transaction? Hi!: I have a lot of transactions like this in the end of year process: DatePhysical Qty TransType Voucher InventTransId StatusRece 13/31/2008 1,159 Profit/Loss ICV00109 L0009 Purchasing In InventTrans table. I looked for original documents using InventTransId but the form don't show any original document for thatI searched also in InventTransPosting but I don't find any related document... How I can find which is the related document?. -- Joe __ NOD32 4005 (20090413) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com [Non-text portions of this message have been removed]
Re: [development-axapta] lookup method 4.0
I think this one will work. try to override the
lookup.
public void lookup(FormControl _formControl, str
_filterStr)
{
SysTableLookup sysTableLookup =
SysTableLookup::newParameters(tablenum(tablename),_FormControl);
Query query = new Query();
;
query.addDataSource(tableNum(tablename));
query.dataSourceTable(tableNum(tablename)).addRange(fieldNum(tablename,
fieldname)).value(value);
sysTableLookup.addLookupfield(fieldNum(tablename,
fieldname));
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
}
--- Claas Heinrich [EMAIL PROTECTED] wrote:
Hi!
I created a form with a stringedit in axapta 3.0 and
simply added the
lookup method.
Everything works fine.
I click the Looku Button and axapta enters the
method.
In 4.0 the same code doesn't work...
Is this a bug?
Greeting,
Claas Heinrich
Yahoo! Groups Links
http://groups.yahoo.com/group/development-axapta/join
(Yahoo! ID required)
mailto:[EMAIL PROTECTED]
__
Yahoo! Singapore Answers
Real people. Real questions. Real answers. Share what you know at
http://answers.yahoo.com.sg
[development-axapta] Resource File
I need to get a image resource file. how can i retrieve it. thanks Yahoo! Singapore Answers Real people. Real questions. Real answers. Share what you know at http://answers.yahoo.com.sg
