Re: [development-axapta] How to add Values into Report at runtime
Hi Praneeth, The Values are the Gold component in an Bom type item.18k gold, 10k gold etc., Let me be more clear, As I said I have one table which has one field and the values are 10k,14k Also I have field in inventtable to check what type of gold does the item is. I want to run a report for finished good item and need to show how much 10k, 18k...gold is available in the Finished Good item. My question is I need to add those table values into the report at run time. Hands that Help is Holier than Lips that Pray --- On Tue, 11/25/08, vamsi praneeth [EMAIL PROTECTED] wrote: From: vamsi praneeth [EMAIL PROTECTED] Subject: Re: [development-axapta] How to add Values into Report at runtime To: development-axapta@yahoogroups.com Date: Tuesday, November 25, 2008, 1:19 PM Hi siva, Could you just be more clear about your question? I mean what does those values under 10k,18k,20k signify? --- On Tue, 11/25/08, Siva kumar [EMAIL PROTECTED] com wrote: From: Siva kumar [EMAIL PROTECTED] com Subject: [development- axapta] How to add Values into Report at runtime To: Axapta Development development- [EMAIL PROTECTED] ps.com, MBS Axapta axapta-knowledge- [EMAIL PROTECTED] ups.com Date: Tuesday, November 25, 2008, 12:17 PM Hi all, I had come across a situation where I need to print the table field value as report field column in the middle of the report during runtime. Lets say I have a table xxxTable with one field which has the values 10k,18k and 22k. I want this values to be printed as report column from a report which uses different datasource. Report Datasource is Item master. Item Desc Qty 10k 18k 22k StdCost Ext.amount. BR-14 3 120.0 130.0 125.0 100.0 300.00 the values are calculated at run time and need to show the values. Please if any one has solution please let me know. Thanks in advance, MGS Hands that Help is Holier than Lips that Pray [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]
[development-axapta] How to use User ID
Hi All Please tell me how to use User ID in x++ code. Thanks
[development-axapta] Receiving items from purchase order in x++
Hi, I want to be able to receive items on a PO, but process one by one, rather than one go as is the option within AX. I want to be able to update the status of the line to received and then when all items are received run a function to post the entire PO. The current code I am using to process each line is: PurchTable purchTable; PurchLine purchLine; TransDate transDate; ; transDate = SystemDateGet(); try { ttsbegin; purchTable = PurchTable::find(myPOId); select forupdate purchLine where purchLine.PurchId == myPOId purchLine.ItemId == myItem purchLine.LineNum == mynum; purchLine.PurchReceivedNow = RecQty; purchLine.RemainPurchPhysical = (purchLine.RemainPurchPhysical - RecQty); purchLine.setInventReceivedNow(); if (purchLine.RemainPurchPhysical == 0) { purchLine.setPurchStatus(); } purchLine.update(true); ttscommit; } catch (Exception::Error) { return got an error; } return processed; } With the above code, it sets the status as cancelled. Do I have to calculate and set the REmainPurchFinancial value as well in order for it to give the correct status. Is there not a function that can receive an item and calculate this automatically? After all the status of items is set to received (ie all items have matching quantity to that ordered) I will post the PO using the following code - I don't think there will be a problem here: purchformletter = purchformletter::construct(DocumentStatus::PackingSlip,true); purchtable.clear(); purchtable = purchtable::find(myPOId); purchformletter.update(purchtable,myDelNo,systemDateGet(),purchUpdate: :All,AccountOrder::None, NoYes::No, NoYes::Yes); Some help on this would be much appreciated.
RE: [development-axapta] Receiving items from purchase order in x++
Sorry not stopped to read your code but can't you use the status 'Registered' (PO line / Functions / Register) and then just do Delivery note posting based on Registered? _ From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Shabbir Ahsan Sent: 25 November 2008 23:58 To: development-axapta@yahoogroups.com Subject: [development-axapta] Receiving items from purchase order in x++ Hi, I want to be able to receive items on a PO, but process one by one, rather than one go as is the option within AX. I want to be able to update the status of the line to received and then when all items are received run a function to post the entire PO. The current code I am using to process each line is: PurchTable purchTable; PurchLine purchLine; TransDate transDate; ; transDate = SystemDateGet(); try { ttsbegin; purchTable = PurchTable::find(myPOId); select forupdate purchLine where purchLine.PurchId == myPOId purchLine.ItemId == myItem purchLine.LineNum == mynum; purchLine.PurchReceivedNow = RecQty; purchLine.RemainPurchPhysical = (purchLine.RemainPurchPhysical - RecQty); purchLine.setInventReceivedNow(); if (purchLine.RemainPurchPhysical == 0) { purchLine.setPurchStatus(); } purchLine.update(true); ttscommit; } catch (Exception::Error) { return got an error; } return processed; } With the above code, it sets the status as cancelled. Do I have to calculate and set the REmainPurchFinancial value as well in order for it to give the correct status. Is there not a function that can receive an item and calculate this automatically? After all the status of items is set to received (ie all items have matching quantity to that ordered) I will post the PO using the following code - I don't think there will be a problem here: purchformletter = purchformletter::construct(DocumentStatus::PackingSlip,true); purchtable.clear(); purchtable = purchtable::find(myPOId); purchformletter.update(purchtable,myDelNo,systemDateGet(),purchUpdate: :All,AccountOrder::None, NoYes::No, NoYes::Yes); Some help on this would be much appreciated. [Non-text portions of this message have been removed]
[development-axapta] Re: Receiving items from purchase order in x++
Hi, I am not sure what you mean. Looking at the purchLine table there are two methods 'registered' and 'registeredInPurchUnit', both of which seem to only retrieve data not update. Looking at the WMSArrival overview form may offer another way. There doesn't seem to be a simple function to just set a single line as arrived with the data being committed, so setting a line as arrived in the WMSArrival form leaves the PurchLine table alone so status of the line is set to open - how do I then get an updated list as to progress??? Has anyone dealt with an issue like this before. Thanks in advance --- In development-axapta@yahoogroups.com, James Flavell [EMAIL PROTECTED] wrote: Sorry not stopped to read your code but can't you use the status 'Registered' (PO line / Functions / Register) and then just do Delivery note posting based on Registered? _ From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Shabbir Ahsan Sent: 25 November 2008 23:58 To: development-axapta@yahoogroups.com Subject: [development-axapta] Receiving items from purchase order in x++ Hi, I want to be able to receive items on a PO, but process one by one, rather than one go as is the option within AX. I want to be able to update the status of the line to received and then when all items are received run a function to post the entire PO. The current code I am using to process each line is: PurchTable purchTable; PurchLine purchLine; TransDate transDate; ; transDate = SystemDateGet(); try { ttsbegin; purchTable = PurchTable::find(myPOId); select forupdate purchLine where purchLine.PurchId == myPOId purchLine.ItemId == myItem purchLine.LineNum == mynum; purchLine.PurchReceivedNow = RecQty; purchLine.RemainPurchPhysical = (purchLine.RemainPurchPhysical - RecQty); purchLine.setInventReceivedNow(); if (purchLine.RemainPurchPhysical == 0) { purchLine.setPurchStatus(); } purchLine.update(true); ttscommit; } catch (Exception::Error) { return got an error; } return processed; } With the above code, it sets the status as cancelled. Do I have to calculate and set the REmainPurchFinancial value as well in order for it to give the correct status. Is there not a function that can receive an item and calculate this automatically? After all the status of items is set to received (ie all items have matching quantity to that ordered) I will post the PO using the following code - I don't think there will be a problem here: purchformletter = purchformletter::construct(DocumentStatus::PackingSlip,true); purchtable.clear(); purchtable = purchtable::find(myPOId); purchformletter.update(purchtable,myDelNo,systemDateGet(),purchUpdate: :All,AccountOrder::None, NoYes::No, NoYes::Yes); Some help on this would be much appreciated. [Non-text portions of this message have been removed]