Re: [development-axapta] Add DialogField in report
Hello anton_tjiptadi,
ïîíåäåëüíèê, 6 äåêàáðÿ 2004 ã., you wrote:
a> I'm trying to add dialog field to my report, code is below :
a> public Object dialog()
a> {
a> DialogRunBase dialog = super();
a> ;
a> dialog.addGroup("Range");
a> dialogTaxInvNo = dialog.addField(typeid
a> (MLR_LedgerJournalTrans),"Tax Invoice :","Tax Invoice Number");
a> return dialog;
a> }
a> I've created an EDT called MLR_LedgerJournalTrans which relate to
a> table LedgerJournalTrans. When I execute the class, it did shows a
a> new textbox with LookUp to table LedgerJournalTrans, only the
a> problem is what I really want is to filter some of the record so for
a> example only show records with CurrencyCode "EUR".
Add to the EDT a relation to the table with fixed value of field
currency
--
Best regards,
Max
http://belugin.newmail.ru
ICQ:9406811
Yahoo! Groups Sponsor
ADVERTISEMENT
Yahoo! Groups Links
To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/
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: [development-axapta] Query Dimension
Hi,
try this:
this.query().dataSourceNo(2).addRange(fieldId2Ext(fieldnum(ProdBOM,Dimension),1)).value(QueryValue('SubCon'));
Michael
>From: "kamchung322" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: [EMAIL PROTECTED]
>Subject: [development-axapta] Query Dimension
>Date: Mon, 06 Dec 2004 02:19:02 -
>
>
>
>Hi All,
>
>How can I only query Dimension[1] value = 'SubCon'. I try to use the
>following code but it will filter Dimension[1] = 'SubCon', Dimension
>[2] = 'SubCon' and Dimension[3] = 'SubCon'
>
>this.query().dataSourceNo(2).addRange(FieldNum(ProdBOM,
>Dimension)).value(QueryValue('SubCon'));
>
>
>Regards.
>
>Kenneth.
>
>
>
>
>
>
Yahoo! Groups Sponsor
ADVERTISEMENT
Yahoo! Groups Links
To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/
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: [development-axapta] Query Dimension
this.query().dataSourceNo(2).addRange(fieldId2Ext(fieldNum(ProdBOM,Dimension),3));
qbr.value("somevalue");
Regards
Ahmed
kamchung322 <[EMAIL PROTECTED]> wrote:
Hi All,
How can I only query Dimension[1] value = 'SubCon'. I try to use the
following code but it will filter Dimension[1] = 'SubCon', Dimension
[2] = 'SubCon' and Dimension[3] = 'SubCon'
this.query().dataSourceNo(2).addRange(FieldNum(ProdBOM,
Dimension)).value(QueryValue('SubCon'));
Regards.
Kenneth.
Yahoo! Groups SponsorADVERTISEMENT
-
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
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! Mail - 250MB free storage. Do more. Manage less.
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
Yahoo! Groups Links
To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/
To unsubscribe from this group, send an email to:[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] Re: Add DialogField in report
Wow, thanks man, it works... :))
uhmm.. one more thing, can the column in the autolookup "dress up" a
bit, 'cause the data seems to truncate for just a view character
even if I only show two columns.
ex :
Vouc.. | Amount.. |
CPP_4..| 4598.. |
CPX_4..| 124567.. |
O yeah.. the data show did coming from AutoLookup Fieldgroup in
table definitions right ?
thanks again,
Anton
--- In [EMAIL PROTECTED], Max Belugin
<[EMAIL PROTECTED]> wrote:
>
> Hello anton_tjiptadi,
>
> ïîíåäåëüíèê, 6 äåêàáðÿ 2004 ã., you wrote:
>
> a> I'm trying to add dialog field to my report, code is below :
>
> a> public Object dialog()
> a> {
>
> a> DialogRunBase dialog = super();
> a> ;
> a> dialog.addGroup("Range");
> a> dialogTaxInvNo = dialog.addField(typeid
> a> (MLR_LedgerJournalTrans),"Tax Invoice :","Tax Invoice Number");
>
> a> return dialog;
> a> }
>
> a> I've created an EDT called MLR_LedgerJournalTrans which relate
to
> a> table LedgerJournalTrans. When I execute the class, it did
shows a
> a> new textbox with LookUp to table LedgerJournalTrans, only the
> a> problem is what I really want is to filter some of the record
so for
> a> example only show records with CurrencyCode "EUR".
>
> Add to the EDT a relation to the table with fixed value of
field
> currency
>
> --
> Best regards,
> Max
>
> http://belugin.newmail.ru
> ICQ:9406811
Yahoo! Groups Sponsor
ADVERTISEMENT
Yahoo! Groups Links
To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/
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: [development-axapta] Re: Add DialogField in report
Hello anton_tjiptadi, ïîíåäåëüíèê, 6 äåêàáðÿ 2004 ã., you wrote: a> Wow, thanks man, it works... :)) a> uhmm.. one more thing, can the column in the autolookup "dress up" a a> bit, 'cause the data seems to truncate for just a view character a> even if I only show two columns. a> ex : a> Vouc.. | Amount.. | a> CPP_4..| 4598.. | a> CPX_4..| 124567.. | you can play with displayWidth properties of corresponding EDTs (or fields AFAIR) a> O yeah.. the data show did coming from AutoLookup Fieldgroup in a> table definitions right ? yes -- Best regards, Max http://belugin.newmail.ru ICQ:9406811 Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 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: [development-axapta] Executing a report from a self made form
if the class extend from runbasereport class then go for the following :
Next steps
1- in your class you should overrdie lastValueElementName as the following
public identifiername lastValueElementName()
{
return reportStr(CustAccountStatementExt); // CustAccountStatementExt is report name.
}
2- in main() method of the class you will write the following
public static void main(Args args)
{
// CustReport_AccountStatementExt :::--- the class which you have created
CustReport_AccountStatementExt custReport_AccountStatementExt = new CustReport_AccountStatementExt();
;
if (custReport_AccountStatementExt.prompt())
{
custReport_AccountStatementExt.run();
}
}
3- create Action menuitem refered to your class.
4- in the init() method of the report you will add the following code:
custReport_AccountStatementExt = element.args().caller();
since
custReport_AccountStatementExt is the class and you have to define a variable from that class in report classdeclaration
then you can you use custReport_AccountStatementExt in the report and calling function to return with the values which the user entered.
try to look at custReport_AccountStatementExt class to get more knowledge
Ahmed
anton_tjiptadi <[EMAIL PROTECTED]> wrote:
Hi, I want to run a report from Form, which I made it earlier, The
Form supposed to cater user criteria first and then they click OK
button, then the report runs.
ps : I just created a Class to run the form and it can display the
form, but I have no idea to do next ?
btw, What is the prupose of funtion Pack and Unpack, since I'm a
newbie here :)
thanks in advance,
Anton
Yahoo! Groups SponsorADVERTISEMENT
-
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
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! Mail - You care about security. So do we.
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
Yahoo! Groups Links
To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/
To unsubscribe from this group, send an email to:[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] Re: Add DialogField in report
eh.. sorry Max, couldn't find DisplayWidth property, there's only DisplayHeight and DisplayLength in EDT property ? (nb I'm using Axapta ver3.0 SP3) ..and what is fields AFAIR ? :) ps : even when I double the stringsize of the EDT, still the lookup as it was (small) thanks, --- In [EMAIL PROTECTED], Max Belugin <[EMAIL PROTECTED]> wrote: > > Hello anton_tjiptadi, > > ïîíåäåëüíèê, 6 äåêàáðÿ 2004 ã., you wrote: > > a> Wow, thanks man, it works... :)) > > a> uhmm.. one more thing, can the column in the autolookup "dress up" a > a> bit, 'cause the data seems to truncate for just a view character > a> even if I only show two columns. > a> ex : > a> Vouc.. | Amount.. | > a> CPP_4..| 4598.. | > a> CPX_4..| 124567.. | > > you can play with displayWidth properties of corresponding EDTs (or > fields AFAIR) > > a> O yeah.. the data show did coming from AutoLookup Fieldgroup in > a> table definitions right ? > > yes > > -- > Best regards, > Max > > http://belugin.newmail.ru > ICQ:9406811 Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] Axapta 2.5 SP2, Win XP SP2 , Office XP / Outlook
Helllo, since we have installed the 1st pc on WinXP / Office XP each time we start Axapta (2.5 /Sp2) on that box, outlooks pops up and asks 4 "A programm is trying to access e-mail" Allow access for .. If i say yes, it's ok for the time i have Axapta open, but when in re-open Axapta next time, i'm asked again .. very boreing.. anygood hints how to avoid this? Thx Pirmin Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] Decimal, delimiter problems on AOS
Hello there, We are having some problems displaying numbers correctly. Default, Axapta would display one million as "1,000,000.00" (let's call that default display) However, we need to switch "," and ".", so that "1.000.000,00" (let's call that custom display) The settings on the AOS server looks just fine, but still I am quite sure, that AOS is the problem. We are running Ax 3.0 SP3 on Oracle. Running AOS: Default display Running AOS/Citrix: Default display Running AOS in 2-tier mode: Custom display All above scenarios use the same client. If I run Axapta on SQL locally: Custom display Checking the settings on AOS (Control panel and AxConfig) reveals no difference from my "own", local setup. Any hints would be greatly appreciated. Thanks in advance ! Best Regards, Jens Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] Decimal, delimiter problems on AOS
A small misprint... :-) Running AOS: Default display Running AOS/Citrix: Default display Running Axapta in 2-tier mode: Custom display -Oprindelig meddelelse- Fra: Jens Strandberg [mailto:[EMAIL PROTECTED] Sendt: 6. december 2004 11:27 Til: [EMAIL PROTECTED] Com (E-mail) Emne: [development-axapta] Decimal, delimiter problems on AOS Hello there, We are having some problems displaying numbers correctly. Default, Axapta would display one million as "1,000,000.00" (let's call that default display) However, we need to switch "," and ".", so that "1.000.000,00" (let's call that custom display) The settings on the AOS server looks just fine, but still I am quite sure, that AOS is the problem. We are running Ax 3.0 SP3 on Oracle. Running AOS: Default display Running AOS/Citrix: Default display Running AOS in 2-tier mode: Custom display All above scenarios use the same client. If I run Axapta on SQL locally: Custom display Checking the settings on AOS (Control panel and AxConfig) reveals no difference from my "own", local setup. Any hints would be greatly appreciated. Thanks in advance ! Best Regards, Jens Yahoo! Groups Sponsor ADVERTISEMENT -- Yahoo! Groups Links a.. To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ b.. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 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: [development-axapta] Axapta 2.5 SP2, Win XP SP2 , Office XP / Outlook
Hi Pirmin, Apparently you have swithed on the outlook synchronization field on the tab outlook of the employees. it can also be that you did not have the configuration key outlook synchronization under CRM Series enabled before and you did not. regards, Danny --- pbercher <[EMAIL PROTECTED]> wrote: > > > Helllo, > > since we have installed the 1st pc on WinXP / Office > XP each time we > start Axapta (2.5 /Sp2) on that box, outlooks pops > up and asks 4 > "A programm is trying to access e-mail" Allow > access for .. > If i say yes, it's ok for the time i have Axapta > open, but when in > re-open Axapta next time, i'm asked again .. very > boreing.. anygood > hints how to avoid this? > > Thx > > Pirmin > > > > > > > __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] How to search a string with wildcard character "?"
Hi, I am customizing Axapta form "SysDatabaseLogSetup" which use DatabaseLog" table .I have added one functionality in form column "Name of Table" for finding the name of Table when a user right click on this column. I have already added a funtionality to open System form "SysFormSearch" for finding any table name in column but I am not able to search a table name when a user entered a string with "?". So if any one have any idea how to acheive this pls let me know. If u are not still clear pls let me know by email me at [EMAIL PROTECTED] Thanks Sukhvir Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 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: [development-axapta] problem: COM -> MSWORD
Hey Mca To achieve the below mentioned points you will have to use COM objects the below mentioned points are acheive in the CRM modules w.r. to quotations thing For direct reference just peek on to the following classes 1) smmDocuActionCOM_Word_Quotation 2) DocuActionCOM_Word. For data insertion onto the excel file do refer to the method insertQuotationLines() in the smmDocuActionCOM_Word_Quotation class.. njoy ur work. Deepak Shetty >From: "mca_prog" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: [EMAIL PROTECTED] >Subject: [development-axapta] problem: COM -> MSWORD >Date: Fri, 03 Dec 2004 08:18:22 - > > > >Hi all, > >I want to do some things with a word-document from within Axapta. >Here are my problems/questions: >1) Open a new Word-document based on a given template. > >2) Writing text and tables to the document where i want to determine >which text style or table style should be used (heading1, heading2 >etc.). > >3) Putting text into the different cells of the tables that i >inserted. > >If hope someone can help me with these questions! Even when it's >just an answer to one of the questions or only a push in the wright >direction. > > >Regards, >Mca > > > > > > Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] table to XML
Hi all, I have to write some field of a table to an XML document. The elements in the XML document are not the actual field names, so right now I manually create the XML document : I create an element, and I put the data from the table between its starting and closing tag. Is it possible to make Axapta write some fields of a table to an XLM document? And is it possible to change the way the elements are named? Thanks! Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] Re: Axapta 2.5 SP2, Win XP SP2 , Office XP / Outlook
Hi Danny, thx 4 u answer, but.. - all users / empl have "outlook synchronizatin" off and i tried with the Admin user , so the CRM security shouldnt be the prob. Any other idea(s)? THX Pirmin --- In [EMAIL PROTECTED], Danny Gaethofs <[EMAIL PROTECTED]> wrote: > > Hi Pirmin, > > > Apparently you have swithed on the outlook > synchronization field on the tab outlook of the > employees. > > it can also be that you did not have the configuration > key outlook synchronization under CRM Series enabled > before and you did not. > > > regards, > Danny > --- pbercher <[EMAIL PROTECTED]> wrote: > > > > > > > Helllo, > > > > since we have installed the 1st pc on WinXP / Office > > XP each time we > > start Axapta (2.5 /Sp2) on that box, outlooks pops > > up and asks 4 > > "A programm is trying to access e-mail" Allow > > access for .. > > If i say yes, it's ok for the time i have Axapta > > open, but when in > > re-open Axapta next time, i'm asked again .. very > > boreing.. anygood > > hints how to avoid this? > > > > Thx > > > > Pirmin > > > > > > > > > > > > > > > > > __ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] Re: Axapta 2.5 SP2, Win XP SP2 , Office XP / Outlook
Hi Danny hmm .. Outlook synchronization is switched off 4 all empl. I tried with the admin user, so the CRM security shouldn't be the prob. Any other ideas? Thx Pirmin --- In [EMAIL PROTECTED], Danny Gaethofs <[EMAIL PROTECTED]> wrote: > > Hi Pirmin, > > > Apparently you have swithed on the outlook > synchronization field on the tab outlook of the > employees. > > it can also be that you did not have the configuration > key outlook synchronization under CRM Series enabled > before and you did not. > > > regards, > Danny > --- pbercher <[EMAIL PROTECTED]> wrote: > > > > > > > Helllo, > > > > since we have installed the 1st pc on WinXP / Office > > XP each time we > > start Axapta (2.5 /Sp2) on that box, outlooks pops > > up and asks 4 > > "A programm is trying to access e-mail" Allow > > access for .. > > If i say yes, it's ok for the time i have Axapta > > open, but when in > > re-open Axapta next time, i'm asked again .. very > > boreing.. anygood > > hints how to avoid this? > > > > Thx > > > > Pirmin > > > > > > > > > > > > > > > > > __ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] A call to South African Axapta technical users
To all South African Axapta technical users, We (the Axapta implementation and development team at UTi Sun couriers) feel that the technical users at all Axapta sites in South Africa could benefit from creating a local Axapta user community. We envision such a community learning from each other's experiences, and helping motivate a greater focus on the part of Microsoft when it comes to providing quality training and support in this country. We would like to be able to share experiences regarding implementations, volumes and development, as well as helping recommend competent third party training institutions and implementation partners. We would also like to hear from any other such communities in other countries to be able to learn what steps they have taken towards establishing productive user groups. Regards, Matt Benic Axapta Developer UTi Sun Couriers Division "The universal aptitude for ineptitude makes any human accomplishment an incredible miracle." - Col. John P. Stapp Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 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: [development-axapta] Re: Axapta 2.5 SP2, Win XP SP2 , Office XP / Outlook
I ran out of options, but for what it is worth. The classes that execute the synchronize are: smmInit.initFromServer called from class Application smmInit.initFromClinet called by initFromServer smmInit.initEMailEventHandler called from initFromClient. It is this method that checks for the outlook user. But if you disabled the Configuration key and no employee is enabled it should not be called. regards, Danny --- pbercher <[EMAIL PROTECTED]> wrote: > > > Hi Danny > > > hmm .. > Outlook synchronization is switched off 4 all empl. > I tried with the admin user, so the CRM security > shouldn't be the > prob. > > Any other ideas? > > Thx > > Pirmin > --- In [EMAIL PROTECTED], Danny > Gaethofs > <[EMAIL PROTECTED]> wrote: > > > > Hi Pirmin, > > > > > > Apparently you have swithed on the outlook > > synchronization field on the tab outlook of the > > employees. > > > > it can also be that you did not have the > configuration > > key outlook synchronization under CRM Series > enabled > > before and you did not. > > > > > > regards, > > Danny > > --- pbercher <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > Helllo, > > > > > > since we have installed the 1st pc on WinXP / > Office > > > XP each time we > > > start Axapta (2.5 /Sp2) on that box, outlooks > pops > > > up and asks 4 > > > "A programm is trying to access e-mail" > Allow > > > access for .. > > > If i say yes, it's ok for the time i have Axapta > > > open, but when in > > > re-open Axapta next time, i'm asked again .. > very > > > boreing.. anygood > > > hints how to avoid this? > > > > > > Thx > > > > > > Pirmin > > > > > > > > > > > > > > > > > > > > > > > > > > > __ > > Do You Yahoo!? > > Tired of spam? Yahoo! Mail has the best spam > protection around > > http://mail.yahoo.com > > > > > > > __ Do you Yahoo!? The all-new My Yahoo! - Get yours free! http://my.yahoo.com Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] Add cost to inventory and recalculate issues
Hello everybody, We've been working with Axapta for about one year and we're currently developing one little module do add some direct and indirect cost based on Ledger Accounts using a cost month closing journal and job (splitting direct cost for salary for example into the orders that have time appointment in the month, and indirect costs like Administrative cost based in total hours appointed in the orders, then update de inventory and after, the ledger), there's no problem with this. But we need to add this cost to the inventory, we're currently researching to use the InventTransAdjust class that fills the field adjust for a specified inventTrans voucher. This is the most correct way to do this? Another question is, as we use de average cost, and our issues was with the previous cost, does the Inventory month closing will adjust all the issues for the goods??? For example, the cost of a semi- manufactured good will change with this (as we add´s up the cost with InventTransAdjust), and consequently the cost of finish manufactured good have to change to production order cost + semi- manufactured cost (the new one with that InventTransAdjust adjustment) + the amount that we add up to the order with InventTransAdjust. Example: Production Order 1 : semi manufactured have to be adjusted in $10 due administrative and other direct costs (this process its ok, no problem with that) + std Axapta cost ( not touched, BOM cost + cost of work centers, already in the inventory when the production order was finished) = $100 Production Order 2 : finish manufactured good 1 have to be adjusted in $33 due administrative and other direct costs (this process its ok, no problem with that) + std Axapta cost ( not touched, BOM cost + cost of work centers, already in the inventory when the production order was finished) = $120 Finish good 1 120 + 10 + 33 | | - semi manufactured 100 + 10 As it is, all the issues for finish good 1 has to be corrected in 43 when we run the inventory month closing and adjust. And the issues for semi manufactured have to be corrected in 10. This can be tested if we purchase some raw material, product some semi manufactured good with it, product another finish good with the semi- manufactured good then sell it. Turn back on purchase invoice for the raw material and adjust the cost with the misc. charges function, all the cost tree has to be changed. Does Axapta do this??? Thanks Rodrigo Matiazo [EMAIL PROTECTED] Cadia Consulting do Brasil Ltda. Av. Eng. Luis Carlos Berrini, 1091 2º andar Edifício A R S Cep. 04571-010 - Brooklin - SP Tel. (55-11) 5505-0173 Fax. (55-11) 5505-0659 www.cadia-consulting.com.br Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] empty select statement
Hi, how can I make sure that a select statement is not empty? For example if I make a statement select firstonly from inventTable where inventTable.itemID = "It001"; how can I know whether inventTable is containing any records? If the record It001 doesn't exist yet, I should create it. Yet therefor I need to be able to check if it exists or not... Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 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 : [development-axapta] empty select statement
If (inventTable) {
//A record is selected
}
Steeve...
-Message d'origine-
De : RHODPR [mailto:[EMAIL PROTECTED]
Envoyé : 6 décembre 2004 12:44
À : [EMAIL PROTECTED]
Objet : [development-axapta] empty select statement
Hi,
how can I make sure that a select statement is not empty? For
example if I make a statement
select firstonly from inventTable where inventTable.itemID = "It001";
how can I know whether inventTable is containing any records? If
the record It001 doesn't exist yet, I should create it. Yet
therefor I need to be able to check if it exists or not...
Yahoo! Groups Links
Yahoo! Groups Sponsor
ADVERTISEMENT
Yahoo! Groups Links
To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/
To unsubscribe from this group, send an email to:[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
