[Axapta-Knowledge-Village] Error number sequences
Dear all,
When I use the next code I get an error message.
Numberseq numberseq;
;
numberseq = numberseq::newgetnum(smmparameters::numrefrelationaccount
());
if(numberseq)
{
print numberseq.num();
numberseq.used();
}
System does not support setup 'continuous' of number sequene 'CRM_119'
Number selection is canceled.
The code is used during data import to assign values to relaccount .
In the data import definition x++ code on a field print numberseq.num
() should be input = numberseq.num()
I have been using this before without problems. So if someone could
help me out here please let me know.
Of course I could solve this by disabling the continuous flag, which
seem to work.
Regards,
Danny
Yahoo! Groups Sponsor ~--
font face=arial size=-1a
href=http://us.ard.yahoo.com/SIG=12h56dc38/M=362343.6886682.7839641.1493532/D=groups/S=1705001380:TM/Y=YAHOO/EXP=1122988040/A=2894350/R=0/SIG=10tj5mr8v/*http://www.globalgiving.com;Make
a difference. Find and fund world-changing projects at 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: *SPAM* [Axapta-Knowledge-Village] Error number sequences
thanks Tobias;
This works now.
regards,
Danny
--- In Axapta-Knowledge-Village@yahoogroups.com, Andrae, Tobias
[EMAIL PROTECTED] wrote:
Hi Danny,
try this:
Numberseq numberseq;
;
ttsbegin;
numberseq = numberseq::newgetnum
(smmparameters::numrefrelationaccount
());
if(numberseq)
{
print numberseq.num();
numberseq.used();
ttscommit;
}
HthTobias
System does not support setup 'continuous' of number
sequene 'CRM_119'
Number selection is canceled.
The code is used during data import to assign values to relaccount .
In the data import definition x++ code on a field print
numberseq.num
() should be input = numberseq.num()
I have been using this before without problems. So if someone could
help me out here please let me know.
Of course I could solve this by disabling the continuous flag,
which
seem to work.
Regards,
Danny
Sharing the knowledge on Axapta.
Yahoo! Groups Links
Yahoo! Groups Sponsor ~--
font face=arial size=-1a
href=http://us.ard.yahoo.com/SIG=12ho6thdm/M=362343.6886682.7839641.1493532/D=groups/S=1705001380:TM/Y=YAHOO/EXP=1123003425/A=2894350/R=0/SIG=10tj5mr8v/*http://www.globalgiving.com;Make
a difference. Find and fund world-changing projects at 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/
[Axapta-Knowledge-Village] Team In Charge
Dear all, On the project filter you can find a radio button team in charge. Where are the teams created? How does Axapta keeps track of the modifications made by each team to object in the AOT? regards, Danny Yahoo! Groups Sponsor ~-- font face=arial size=-1a href=http://us.ard.yahoo.com/SIG=12hu2gh73/M=362343.6886682.7839641.1493532/D=groups/S=1705001380:TM/Y=YAHOO/EXP=1122646639/A=2894352/R=0/SIG=11fdoufgv/*http://www.globalgiving.com/cb/cidi/tsun.html;Help tsunami villages rebuild at GlobalGiving. The real work starts now/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: *SPAM* [Axapta-Knowledge-Village] dialog = super()
Tobias,
If I understand you well it is just a shorter version for writing:
DialogRunbase dialog;
super();
Regards,
Danny
--- In Axapta-Knowledge-Village@yahoogroups.com, Andrae, Tobias
[EMAIL PROTECTED] wrote:
Hi Danny,
this code is taken out of a class extending RunBase or
RunbaseBatch. So the super() call will execute the dialog() method
of that parent class instead of redefining everything again.
Hth Tobias
-Ursprüngliche Nachricht-
Von: Danny Gaethofs [mailto:[EMAIL PROTECTED]
Gesendet: Sonntag, 24. Juli 2005 16:25
An: Axapta-Knowledge-Village@yahoogroups.com
Betreff: *SPAM* [Axapta-Knowledge-Village] dialog = super()
Dear all,
I found this dialog() method in the developer's guide:
Can someone tell me what exactly the statement
DialogRunbase dialog = super(); does.
public Object dialog()
{
DialogRunbase dialog = super();
;
dialogField = dialog.addField(typeId(Integer));
dialog.addTabPage(Tab label);
dialog.addField(typeid(itemid));
return dialog;
}
What is the benefit of using that approach?
regards,
Danny Gaethofs
Sharing the knowledge on Axapta.
Yahoo! Groups Links
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] USR layer modifications vs CUS Layer
Dear all, I have a job defined in the USR layer of development environment Y. Now I make some change to this job in development environment X but in the CUS layer. When I copy the axcus.aod (environment X) to development environment Y, I notice that both layers (USR and CUS) are visible. It does not matter whether I am logged into the USR or CUS layer. When I open the code upgrade tool for the object in the USR layer, I can see the workspace tab, usr and cus tab. From some test I did with other objects (classes) I learned that the workspace tab contains the active application object, meaning the one that is executed when users log into axapta. Is this correct? regards, Danny 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] Import business relations
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 relations that have multiple contactpersons? What should be the layout of the input file? Can I have the following layout, columns business relation fields, columns contactperson fields AND in the file a record for each of the contactpersons. regards, Danny 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] Data Import Definition and BuildAddress() method
Dear all, On the smmImportRelJournal I found a method BuildAddress(). This method can be executed through the button functions. The method builds up the Address data from city, street, country and so on. The method does nothing more then calling the static method FormatAddress on the table Address. Now I tried to call this method from within the Conversion Tab in a data definition. It compiles without a problem but when I start importing data I get strange errors about tts start loops and so on. Has anyone tried to use this method in a data definition? regards, Danny 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] Re: Converting CRM quotation to sales order
Dear all, I have been looking into this problem today and have some questions. The clicked() method that converts the quotation to a sales order checks the security rights on the table CustTable using the method CustTableInsert() and SalesTableInsert(). Both methods uses the security key custTables to find the rights. Although the access on the CustTable is set to View the clicked() method will allow the creation of the customer. When I debug the clicked() method I notice the access right retrieved is full control, which is not correct. Can someone tell me what exactly the method rights() does on the class DictSecurity? regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, bbfen [EMAIL PROTECTED] wrote: We did a mod to display a warning message if the user try to convert a quote to sales order for a prospect. The warning message tells the user a sales order cannot be created, please contact AR to create customer... For the user to view the customer (without the ability to create them), use the Axapta security system. --- In Axapta-Knowledge-Village@yahoogroups.com, jaykay_nl [EMAIL PROTECTED] wrote: I want to prevent that a user can create a customer when converting a CRM quotation to a sales order. In CRM a quotation can be made for i.e. a prospect (a non- customer). When converting this quotation to a sales order, Axapta also converts the business relation to the type customer and creates a record in the customer table. Last step is not want, as this process is separated within the organization. So converting a CRM quotation of a prospect to a sales order should not be possible as this function should not be able to create a customer record. Still a user must be able to view the customer table. Any idea how this can be solved? Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/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] Business Analysis: Cognos and Axapta
Dear all, Is there anyone that has experience with using Cognos in combination with Axapta. How does this relate to the Axapta 3.0 business analysis tool (using OLAP)? regards, Danny 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] Re: Report with Labels A4 Paper in columns
Dear Oscar, Try to answer your question but I am a bit in a hurry. I have managed to create such kind of reports a while back. I have had some discussions about it on this group. You can find these when you look for Positioning Programmable section. If you can not find it in the message section, then try it here: http://www.mail-archive.com/cgi-bin/htsearch? method=andformat=shortconfig=axapta-knowledge- village_yahoogroups_comrestrict=exclude=words=Positioning+Programm able+section I got it working in two ways, one is the way as discussed in and the other one is by creating a body in which I repeat the values to print 3 times but with different positions. regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, oscarcaravaca [EMAIL PROTECTED] wrote: Hi there, We need to make a report with 3 columns label paper. I mean, i have a A4 preformated label paper like this: ___ | | | | | ArtCode | ArtCode| ArtCode | | BARCODE | BARCODE| BARCODE | |_|__|_| | | | | I have been working with columns property of Reports, but i cannot get print in 3 columns, it is showing me the report only in 1 column. any ideas? What i have to print is allways the same info on each label the times that user says. Thanks all 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/
[Axapta-Knowledge-Village] Re: Know a lot about subcontracting?
Dear Luc, What precisely do you want to know? Are you aware of the different BOM Line Types that exist and what you can do with them. Regards, Danny Gaethofs the Netherlands --- In Axapta-Knowledge-Village@yahoogroups.com, l_vroom [EMAIL PROTECTED] wrote: Hi, Who has a good idea how to implement subcontracting in a manufacturing enviroment. We need to track down the posting of the components from our warehouse and need to be able to match an invoice from our supplier for the delivered work. Anyone? Regards, Luc 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/
[Axapta-Knowledge-Village] Error with macro
Dear all, I have a strange error with a newly created macro. When I create a new macro and try to use it in a form then the macro is not recognized. I have tried several things already but I cannot get this problem solved. I tried a selective update of the cross reference for the record type macro. But it does not help. Anyone has some ideas about how I can fix this problem. regards, Danny 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/
[Axapta-Knowledge-Village] Re: Error with macro
Sorry all for your time, I found the reason for it. It was in the definition of the macro itselve. I created a macro that contained the next line #define.Test-Lookup Now it seems that the - does not work. Only the underscore _ is accepted. However when I defined the macro no warning or error was given. regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, Danny Gaethofs [EMAIL PROTECTED] wrote: Dear all, I have a strange error with a newly created macro. When I create a new macro and try to use it in a form then the macro is not recognized. I have tried several things already but I cannot get this problem solved. I tried a selective update of the cross reference for the record type macro. But it does not help. Anyone has some ideas about how I can fix this problem. regards, Danny Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/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] How can I find what RecId will be the next to be used?
Raul,
Why do you select the firstonly record. This will give you the
record for SysEvent (id 3).
Now try this:
select firstonly SS
where SS.name == seqno
you would get closer to the matching values.
They do not match but this must have something to do with the fact
that the kernel is pulling multiple numbers at the same time.
I have run your job a few times and noticed that the nextval in the
table systemsequences remained the system, until the value of the
recid shown in the warning reach this value.
regards,
Danny
--- In Axapta-Knowledge-Village@yahoogroups.com, Raul Llorente
Peña/OPENSOLUTIONS [EMAIL PROTECTED] wrote:
Sorry David, but your appointment is invalid. When a user log into
Axapta, the Kernel takes 25 recids into cache, and adds 25 to next
value. Try yourself as below (create a table called T with a single
string field called A):
static void Job4(Args _args)
{
SystemSequences SS;
T T;
int i;
;
for (i=1; i= 3; i++)
{
//select * from SS where SS.Id == -2;
select firstonly SS;
info (int2str(SS.nextVal));
T.A = 'Hello';
T.insert();
warning (int2str(T.RecId));
}
}
As you see, the values shown don't match... That's why I don't want
to use the table SystemSequences nor class SystemSequences (it
doesn't provide any method to look the recId that will be about to
be used).
More suggestions???
Raúl Llorente Peña
Análisis, Desarrollo e Implementación en
Microsoft Bussiness Solutions-Axapta
OPEN SOLUTIONS
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/
[Axapta-Knowledge-Village] Re: Very large item master
Dear Lourens, The only way to get this done is by importing the data directly into Axapta from a flat file, CSV format. You can not sustain with only importing into the InventTable. You will have to populate these tables also: * InventTableModule * InventItemLocation * InventDim: regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, lourens1210 [EMAIL PROTECTED] wrote: Hi all We will soon be working at a client with an item master in excess of 1.9 million items. The migration of these items to Axapta seems a daunting task considering the following: Excell can handle 65,536 lines of data in a sheet which means if one uses Axapta's excel spreadsheet templates you will need about 30 templates. This will take about 8 full days to upload onto Axapta. Besides these logistical hassles the process of cleaning up the data before import will also be a messy one to say the least. Does anybody have any suggestions how to approach this. Lourens Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/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] Re: 4th Financial Dimension
Dear Fernando, You will have to add the fourth dimension to the development environment. 1. First determine which name or code you want to give to your new dimension. Suppose you want to add a dimension named Country. First start with adding this new dimension to the Extended Data Type SysDimension as the fourth dimension. You will find the Extended Data Types in the AOT under the node Data Dictionary, 2. Next adding a new dimension requires modifying the next 7 extended data types: * Dimension * DimensionAllocation * DimensionAllocation2 * DimensionCriteria * DimCheck * DimensionLedgerJournal * MandatoryDimension You will have to add a new array element to each of these extended data types. You will notice that each of these contain two of the existing dimensions as array elements. You will wonder why the Department is not an Array Element. This is because it is covered with the Extended Data Type definitions. AS can be seen in the property sheet for the Extended Data Type. Label and HelpText refer to the Department. The new array element on MandatoryDimension is to have the validation on the form LedgerTable. 3. Modify the relations on the Extended Data Types Dimension and DimensionCriteria. This is necessary to be able to look up the dimensions in the table dimensions from dimension fields. Suppose you do a lookup on the dimension Cost Center. The relation will ensure you only get the list of cost centers from the dimensions table. The fact is that the relationships, you define on an Extended Data Type, are automatically inherited by the later tables. You will have to define two types of relations on the new array element. Add the Next Relations: Country == Dimensions.Num 3 == Dimensions.DimensionCode 4. Add a relation to the LedgerJournalTransTable. This one is needed for the intercompany lookup. Create a relation similar to the existing InterCoDimension1 and 2. Additionally if you want to have the new dimension shows up in the form Business Relations (CRM) do the following: 1. Add the field group Dimension to the table smmBusRelTable as follows: Find the node Field Groups on the table. Add the new field group Dimension. Drag and drop the field dimension from the field list onto the group. 2. Modify the group Dimension in the form smmBusRelTable. Find the tabPage Dimensions in the Design. Select the [Group: Dimension] Open Properties Go to the field DataSource and fill in smmBusRelTable Go to the field DataGroup and select Dimension Now I believe it is best to compile the whole environment. Kind regards, Danny Gaethofs --- In Axapta-Knowledge-Village@yahoogroups.com, fvittes [EMAIL PROTECTED] wrote: We have just gotten our license for the 4th financial dimension, uploaded it, and recompiled. But we are still not able to see the 4th dimension in any of the froms. Has any body faced this issue before? Regards, Fernando. 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] Re: number range per month
Willem, I have not done it yet, but I looked a bit at how the number sequences work technically. In another ERP Application I have been working with for 10 years, it was possible to define a Number Sequence with a counter reset function checkbox for numbers including a date value in the format. Say for example you wanted to start counting a 1 every year, you were able to use one number sequence continuously year in and out. One condition was the year should be part of the format. I believe such a generic solution would be easy to implement. A checkbox indicating the counter should reset once the condition changed. Condition would then be next month or next year. Much luck with finding the right solution. Danny Gaethofs --- In Axapta-Knowledge-Village@yahoogroups.com, willem_baelde [EMAIL PROTECTED] wrote: hello, has someone already developed number ranges for journal vouchers per month ? regards, Willie 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] Re: Configuration and tables Exporting
Dear Luis, I suppose you already learned how to use data import/export. Create a new data defintion group. Have a look at the checkboxes under the tab included table groups. Uncheck the checkbox Transaction if you do not want transactions like CustTrans, ... Uncheck the checkbox Main if you do not want base information. You can find the definitions of all the options in the developer's guide. Regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, Luis Ernesto Resendiz [EMAIL PROTECTED] wrote: Hi all, Can I export not only parameters but also all the configuration and tables of a company and then import to a new one but with no transactions? Thanks for your help LR Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/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] Re: wkofyr
Dear Alfonso, Jens, There happens to be a hot fix for this problem posted 27/1/2005. Weeknumber wasn't displayed correctly in tools/systemdate/calendar. Affected object: \Classes\Global\weekofYear Install hotfix HF30SP3_041. regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, Jens Strandberg [EMAIL PROTECTED] wrote: Hello, You may have a display bug in Axapta's calendar. If you have a week 53 and a week 2 (i.e. NO week 1), this is the case. Fix it in global::WeekOfYear(). Change 1 to 2 and 2 to 1 in the case-statements; that will do the trick... /Jens -Oprindelig meddelelse- Fra: Danny Gaethofs [mailto:[EMAIL PROTECTED] Sendt: 4. februar 2005 09:52 Til: Axapta-Knowledge-Village@yahoogroups.com Emne: [Axapta-Knowledge-Village] Re: wkofyr Dear Alfonso, What date are you submitting? If you run these lines of code in a job: print wkofyr(SystemDateGet()); print SystemDateGet(); pause; Tell us the results. In my environment I get week 5, date 4-2-2005. Which is correct. If that is not the case at your side, then have a look at your system date settings. regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, Alfonso Collados Arroyo [EMAIL PROTECTED] wrote: Hi all: I 'm using the wkofyear function and I see that this function returns always one week less . Why? Thanks Alfonso Sharing the knowledge on Axapta. Yahoo! Groups Links 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/
[Axapta-Knowledge-Village] Re: Reversing a packing slip
Thanks Karina, This works even better. After posting the packing slip the deducted qty is decreased, the qty on order is set back. regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, Karina Normann Jakobsen [EMAIL PROTECTED] wrote: Hi Danny, You can also choose to enter a negative quantity in the field delivery now on the quantity on the sales order line (it was build for this purpose) and post a packing slip using the method deliver now. Med venlig hilsen/Best regards/Mit freundlichen Grüßen Karina Normann Jakobsen Program Manager From: Danny Gaethofs [mailto:[EMAIL PROTECTED] Sent: 2. februar 2005 16:19 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Reversing a packing slip Dear all, I have been looking for a way to reverse a packing slip without having to create a negative sales order line. I found a way using the Deliver remainder functions on the SalesLine. The field contains the quantity that goes in the update quantity on the posting packing slip form. Are there any financial consequences when handling the reversal using the following procedure? Select the SalesLine for which the packingSlip has been posted. Click the button Functions and select Deliver remainder. Now enter the quantity that is on the PackingSLip but now inverted (negative). The value entered will update the field DeliverRemainder on the SalesLine. It will become negative. Post a PackingSlip for this negative quantity. Now there will be no quantity at all on the SalesLine. Repeat the function Deliver remainder but for the original quantity on the PackingSlip. Hereafter delete the SalesLine! regards, Danny 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] mailto:[EMAIL PROTECTED] subject=Unsubscribe * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . 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/
[Axapta-Knowledge-Village] Re: Batch Process
Alfonso, As far as I know it is not possible but maybe I am wrong and someone did succeed. What you should do is recreate your job but as a class. The class should extend RunBaseBatch. Have a look at the class Tutorial_RunBaseBatch. regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, Alfonso Collados Arroyo [EMAIL PROTECTED] wrote: Hi all: I have a job and I want to throw that job in a Batch Process. How can I do this, Thanks, Alfonso 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] Re: Auto report as finished.
Sunfen, Can you check the settings of the configuration key TRADE option Registration/Picking. Is it marked? regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, Yifat Halili [EMAIL PROTECTED] wrote: Hi there, What you are describing is exactly what I am looking for. I cannot get it to work, please help. Axapta 3, service pack 2. All configuration keys are on. I am not sure what else needs to be on. Thanks in advance __ Yifat Halili From: sunfen [mailto:[EMAIL PROTECTED] Sent: Thursday, February 03, 2005 7:16 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Auto report as finished. Hi Yifat, I have tried it, It will automatically create a BOM journal based on default BOM journal and calculate the cost when you invoice the sales order. You use this when there is no production order for that BOM item. When you post the invoice, it will create item receive transaction for BOM item and item issue for BOM components. See the posted journal at Inventory management-Journals-Item transactions-Bill of materials Regards, Sun Fen -Original Message- From: yifath1 [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Date: Wed, 02 Feb 2005 12:20:45 - Subject: [Axapta-Knowledge-Village] Auto report as finished. Hi all, Does anyone know how to use Auto-report at finished on the item master under the reference tab? The explanation says one thing, but i can not seem to do what the explanation says. (it says that once you post a sales order than a BOM journal is created and posted...if the tick box is on) has anyone used this? can anyone help? Thanks Yifat Sharing the knowledge on Axapta. Yahoo! Groups Links 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] mailto:[EMAIL PROTECTED] subject=Uns ubscribe * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/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] Re: Auto report as finished.
Dear Sunfen, I am getting the same error message. Tell us whether you configuration key for trade register/picking is marked or not. So we can possibly exclude this key as the cause for the fact that it is not working at our side. regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, Yifat Halili [EMAIL PROTECTED] wrote: Hi Sun, I have configured my bom, and the configuration key for trade is on (register/pick) The error I get is that the BOM can not be picked as there are none available from stock... Can you help? Regards, Yifat __ From: sunfen [mailto:[EMAIL PROTECTED] Sent: Friday, February 04, 2005 5:25 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Auto report as finished. Importance: High Hi Yifat, Have you configured your BOM properly? I only check the auto report as finished and configure the bom components. What is the error message? I am also using Axapta 3, sp2. Regards, Sun Fen -Original Message- From: Yifat Halili [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Date: Thu, 3 Feb 2005 16:11:22 +0200 Subject: RE: [Axapta-Knowledge-Village] Auto report as finished. Hi there, What you are describing is exactly what I am looking for. I cannot get it to work, please help. Axapta 3, service pack 2. All configuration keys are on. I am not sure what else needs to be on. Thanks in advance __ Yifat Halili From: sunfen [mailto:[EMAIL PROTECTED] Sent: Thursday, February 03, 2005 7:16 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Auto report as finished. Hi Yifat, I have tried it, It will automatically create a BOM journal based on default BOM journal and calculate the cost when you invoice the sales order. You use this when there is no production order for that BOM item. When you post the invoice, it will create item receive transaction for BOM item and item issue for BOM components. See the posted journal at Inventory management-Journals-Item transactions-Bill of materials Regards, Sun Fen -Original Message- From: yifath1 [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Date: Wed, 02 Feb 2005 12:20:45 - Subject: [Axapta-Knowledge-Village] Auto report as finished. Hi all, Does anyone know how to use Auto-report at finished on the item master under the reference tab? The explanation says one thing, but i can not seem to do what the explanation says. (it says that once you post a sales order than a BOM journal is created and posted...if the tick box is on) has anyone used this? can anyone help? Thanks Yifat Sharing the knowledge on Axapta. Yahoo! Groups Links 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] mailto:[EMAIL PROTECTED] subject=Un s ubscribe * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT http://us.ard.yahoo.com/SIG=129bskqvr/M=298184.5639630.6699735.30011 76/ D=groups/S=1705001380:HM/EXP=1107572448/A=2532114/R=2/SIG=12kptpbhu/* htt p:/clk.atdmt.com/NFX/go/yhxxxnfx002014nfx/direct/01/time=1107486 048 093435 http://view.atdmt.com/NFX/view/yhxxxnfx002014nfx/direct/01/time =11 07486048093435 http://us.adserver.yahoo.com/l? M=298184.5639630.6699735.3001176/D=group s/S=:HM/A=2532114/rand=899951961 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] mailto:[EMAIL PROTECTED] subject=Uns ubscribe * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM ~-
[Axapta-Knowledge-Village] Re: Phantom,production,automatic firm, master planning
Dear Yifat, There are two types of Stop explosion fields on the tab References of the item: - BOM Calculation Stop Exlosion - Item Coverage Stop Explosion The first one is responsible for the cost calculation. I think you have to mark the latter one, to avoid an order is created. Normally this one ensure that explosion stops at this item (bom) and planned orders are generated for the item itself and not for the underlying items. Personally, what happens is a bit strange when we take into account the definition of a phantom. A phantom should always be exploded. At least that is what apics tells us, unless the phantom is in inventory (on stock). Orders should never be created for the phantom itselve. But give it a try, and let me know whether it works. regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, Yifat Halili [EMAIL PROTECTED] wrote: Thanks for the reply, The thing is that I need the BOM AB and BB to explode in the main BOM A. But I don't see why it creates 2 more orders...(which I don't need) The stop explosion is for price calculation and for item coverage... which I need both... because bom AB, and BB are also sold on their own. Any other suggests - will be highly appreciated. __ Yifat From: anilsinha1968 [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 02, 2005 1:37 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Phantom,production,automatic firm, master planning Hi, Switch on Stop Explosion check Box on the Reference Tab on Item Master for BOM A. With this setting BOM A will not be exploded and production order for BOM AB and BB will not be created. Regards Anil Sinha --- In Axapta-Knowledge-Village@yahoogroups.com, yifath1 [EMAIL PROTECTED] wrote: Hi all, I have a BOM A made up of item AB and item BB both of type BOM. I have stated that they are phantoms in the BOM. I run master planning, and have AUTOMATIC FIRMING on. So Axapta automatically firms the production order of BOM A. It creates the picking list for all the items as required. BUT it also creates 2 other production orders for item AB and BB. The BOM of which is empty. I dont want the 2 other production orders to be created as the consumption of the raw material already happens in the production order of BOM A. Can any one help... please? Many thanks Yifat 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] mailto:[EMAIL PROTECTED] subject=Uns ubscribe * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . 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] Re: Auto report as finished.
Dear Sunfen, Can tell us what the Configuration key settings are for Trade, Registration/Picking? Which version are you on? regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, sunfen [EMAIL PROTECTED] wrote: Hi Yifat, I have tried it, It will automatically create a BOM journal based on default BOM journal and calculate the cost when you invoice the sales order. You use this when there is no production order for that BOM item. When you post the invoice, it will create item receive transaction for BOM item and item issue for BOM components. See the posted journal at Inventory management-Journals-Item transactions-Bill of materials Regards, Sun Fen -Original Message- From: yifath1 [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Date: Wed, 02 Feb 2005 12:20:45 - Subject: [Axapta-Knowledge-Village] Auto report as finished. Hi all, Does anyone know how to use Auto-report at finished on the item master under the reference tab? The explanation says one thing, but i can not seem to do what the explanation says. (it says that once you post a sales order than a BOM journal is created and posted...if the tick box is on) has anyone used this? can anyone help? Thanks Yifat Sharing the knowledge on Axapta. Yahoo! Groups Links Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/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] Re: Import Classes
Dear Giordi, I have not found best practice guidelines that specify you should recompile it, but I learned that after importing objects it was necessary to do a recompilation. I experieced importing classes in the VAR layer required me to recompile the class also in the user layer to have it working correctly. Sometimes it is necessary to import things twice or more, unexplainable. Maybe it is because for tables and classes not the full definitions are exported and imported but only the changes that have been made. Unless you specify it otherwise during the import. Sometimes you also need to do a compile forward. For example: in case you made changes to the class SalesFormLetter. regards, Danny Gaethofs --- In Axapta-Knowledge-Village@yahoogroups.com, jesmondus [EMAIL PROTECTED] wrote: Hi, i have a small query regarding import of classes!! when importing classes to an Axapta layer. Should they be re- compiled or not?? I'm not quite sure about it since axapta already does a compilation while importing a class, but i'm not sure if a re-compilation of the classes is required or not? giordi Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/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] Re: Run On Property
Dear Rabih, The RunOn property decides where the application object is executed, where the object created will reside/live. Values are: - Client - Server - Called from (default) You will find more detailed information in the developer's guide. Regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, RFK142 [EMAIL PROTECTED] wrote: Guys, What happens when I put a class or a query's Run On property to Called From? --Rabih Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/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] Re: Tax group not properly defaulted
Dear Karina, Thanks a lot. This explains where the value is coming from. I have looked at the functionality on the terms of delivery. I have some additional questions about the sales tax address options. Why is it looking at the tax group of the alternate address when I have selected the option Delivery. What is the purpose of the option Alt.Del. then? How can the option Invoice be used ? Is the tax group then taking from the invoice account? I have tested this in sales orders and it does not work. Probably it is used elsewhere. Do you happen to know this? Kind regards, Danny Gaethofs --- In Axapta-Knowledge-Village@yahoogroups.com, Karina Normann Jakobsen [EMAIL PROTECTED] wrote: It can be controlled by the terms of delivery and an alternative address E.g. try to select sales tax address Delivery on your Term of Delivery. Add that terms of delivery to your customer. Create an Alternative address type Delivery for your customer and add a separate Sales tax group on that address. Then you use the Sales tax group from the Alternative address as default value instead of the Sales tax group from the customer master. Med venlig hilsen/Best regards/Mit freundlichen Grüßen Karina Normann Jakobsen Program Manager From: Danny Gaethofs [mailto:[EMAIL PROTECTED] Sent: 28. januar 2005 09:12 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Tax group not properly defaulted Dear Sun Fen, Thanks for your reply. This confirms what I was thinking. Although it looked promising a combination of fields that determine the tax group. I have not looked at the code yet. I first want to check whether it is a known problem or related to initialization issues like parameters. I am running axapta 3.0 SP3 including all hot fixes with no customization on the sales order. At least not in that area. When the tax group of a customer who has outstanding orders is changed, the outstanding order header and line tax group should not be changed. As a result of only changing the tax group in the customer record it does not. That is working correctly. For a customer with no outstanding orders when I type in the customer account code in the sales order header the tax group in the header is overwritten with the new tax group. I personally do not find this accepted behavior. Users can make mistakes. I find it correct when a new customer account is selected. Now in my environment the tax group is not overwritten for a customer with outstanding orders. But when I enter a new order for this customer the tax group is not defaulted from the customer but from somewhere else. Is someone running 3.0 sp3 with all hot fixes who experiences the same problem. regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, sunfen [EMAIL PROTECTED] wrote: Hi Danny, The sales tax group is defaulted from Customer master only and not from any setups such as terms of deliveries. There must be something wrong with your code. Regards, Sun Fen -Original Message- From: Danny Gaethofs [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Date: Thu, 27 Jan 2005 17:37:56 - Subject: [Axapta-Knowledge-Village] Re: Tax group not properly defaulted Girish, All of it happens in the sales order. Even before something has been done with the sales order. That is why I am surprised. What I also notice is that when you are in the sales order header and go to the customer record, change the tax group. Then in the order header type in the customer code again the tax group is not defaulted. To me this seems to work correct, in that sense that I believe that values ones defaulted should not be overwritten. Unless another customer is selected. However in standard it overwrites the defaults when the customer code is entered again. Now in my customer's environment it does not. And when I create a new order it is not defaulting the value from the customer record, which I changed, but takes the old value. Can you elaborate a bit on the way it works with the terms of delveries. Is there somewhere a table that has the combination of tax group and delivery term? regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, Girish B [EMAIL PROTECTED] wrote: Hi danny, Hope you have updated the tax group on the Customer master. if you create the new sales order (manually) for the customer then i am sure it picks up from the customer master. But if you use the copy from journal functionality then it would copy from the the order which is used to copy. Have you set the delivery terms? here we specify the place of taxation and this also sometimes determines the tax
[Axapta-Knowledge-Village] US GTM Setup
Dear all, I have been working with another ERP system that had functionality to support the complex Tax system in the US and connections with Vertex. Is it possible to establish the complex setup in Axapta required to support the US tax requirements? Is it possible to connect to Vertex ? regards, Danny Gaethofs 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] Re: How to keep Word Documents in Axapta
Dear compashi, Checkout the document management functionality. Check in Tools, Options, Tab General, the field Document handling active is enabled. regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, compashi [EMAIL PROTECTED] wrote: Hello to All, Friends i want to know that how i can keep a bunch of my company policy documents created in MS word, on Axapta.Does this requires any third party licesnse or the feature Document Handling can help me in any way. If Document handling can do this task than please elaborate that how i can do the same. If you know any document or website where above informattion can be fetched please let me know.I will be highly oblidged. Thanks in Advance. 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/
[Axapta-Knowledge-Village] Re: I have checked it out
Dear Compashi, You have to attach these documents to a record. As an example: Suppose you have an item in the database and for this item you have some instructions stored in a document. We first have to setup a kind of repository where the files are going to be stored. Therefore go to Basic, Setup, Document management, select Document types. Now create a new document type, CTRL+N. Give the type a suitable name, example: , ItemInstr. Select a Job description from the drop down list. As an example you could select Attach file. Go to tab General. Set the field Group to file. Specify the archive directory where the files should be stored. Now we have defined the document type and archive directory we can attach the document to one of the available items in the database. Open the items form. Select an item of your choice. Push the button Document handling in the Toolbar or select it from the Tools menu. In the window that opens create a new entry, CTRL+N. Select the document type we defined earlier. Once you select this type an explorer window opens asking for a file name. Now select a document in the file system. You can specify whether the document is for internal purposes or not. Now go to your file system and check the content of the repository directory we created earlier. You will see a new file is in the repository. It is a copy of the file we imported. What we learn from it is that: - axapta makes a copy of the files we provide and stores it in its own repository ( the location we can define in document types) - if we remove the entry in the document handling window for the item, the document is deleted. We can also create a document from within the document handling window for the item. In fact we can attach all kind of files to a record. We can choose whatever table and record there is in the database, unless the parameter Use active document tables is set. In that case documents can only be attached to tables that are made active in Basic, Setup, Document handling, Active document tables. Here you will have to push the button update. Axapta will then generate the tables. I have not checked exactly where the list of tables is coming from. You can for example use the table CompanyInfo. If you have checked the parameter Use active document tables and you have not added the table CompanyInfo to the Active document tables you will not be able to add documents to the company records. Now if you disable the parameter it will be possible. Or if you add the table CompanyInfo to the active document tables it should also be possible. When you open the company info option, Basic, Setup, you can try to add documents. Another way should be using the check table check box on the document type, but unfortunately I am not getting this to work properly. regards, Danny --- compashi [EMAIL PROTECTED] wrote: Hello dgaethofs, I have checked it out and it's but perhaps you have not understood what i want that i have certain documents which are in formats viz. .pdf,.doc,.xls etc.And i want these static document to be online in my Axapta Application. I hope now you must have understood that what i want. __ Do you Yahoo!? Yahoo! Mail - Find what you need with new enhanced search. http://info.mail.yahoo.com/mail_250 Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/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] SysINetTable
Dear all, How is this table getting populated. Should contain user records but it does not in my environment. regards, Danny 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/
[Axapta-Knowledge-Village] Index on the Forms data source
dear all, I have seen several forms where the property index on the data source has been filled with the index that exists already on the table. Can someone tell me why this is done? Is it a bad design? As an example look at the form and table PaymTerm. The index TermIdx is assigned to the property index on the form. Is that index not automatically used ? Regards, Dann 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/
[Axapta-Knowledge-Village] Tax group not properly defaulted
Dear all, When creating sales orders the tax group of a customer is not correct defaulted when there are existing orders for the customer. When orders exist for a customer and the tax group is changed in the customer record, I noticed that when creating a new order the tax group is not defaulted from the customer record. It looks as if it is taken from existing orders which however seems unlogic. Has someone noticed this error before. Could it have something to do with caching. We are running axapta 3.0 with service pack 3 and all hotfixes installed. regards, Danny Gaethofs 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/
[Axapta-Knowledge-Village] Re: Tax group not properly defaulted
Girish, All of it happens in the sales order. Even before something has been done with the sales order. That is why I am surprised. What I also notice is that when you are in the sales order header and go to the customer record, change the tax group. Then in the order header type in the customer code again the tax group is not defaulted. To me this seems to work correct, in that sense that I believe that values ones defaulted should not be overwritten. Unless another customer is selected. However in standard it overwrites the defaults when the customer code is entered again. Now in my customer's environment it does not. And when I create a new order it is not defaulting the value from the customer record, which I changed, but takes the old value. Can you elaborate a bit on the way it works with the terms of delveries. Is there somewhere a table that has the combination of tax group and delivery term? regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, Girish B [EMAIL PROTECTED] wrote: Hi danny, Hope you have updated the tax group on the Customer master. if you create the new sales order (manually) for the customer then i am sure it picks up from the customer master. But if you use the copy from journal functionality then it would copy from the the order which is used to copy. Have you set the delivery terms? here we specify the place of taxation and this also sometimes determines the tax, depending on the conditions set.. hope these point will help you solve the problem. cheers, Girish --- Danny Gaethofs [EMAIL PROTECTED] wrote: - Dear all, When creating sales orders the tax group of a customer is not correct defaulted when there are existing orders for the customer. When orders exist for a customer and the tax group is changed in the customer record, I noticed that when creating a new order the tax group is not defaulted from the customer record. It looks as if it is taken from existing orders which however seems unlogic. Has someone noticed this error before. Could it have something to do with caching. We are running axapta 3.0 with service pack 3 and all hotfixes installed. regards, Danny Gaethofs 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. ___ ALL-NEW Yahoo! Messenger - all new features - even more fun! 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/
[Axapta-Knowledge-Village] Form Design property
Dear all, There is a property Mode on the node Design of forms. The property can have one of the following four values: ADD WATCH EDIT DELETE Can someone tell what the purpose or influence is of setting this property? regards, Danny Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/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] Re: Modified version of reports
Dear Madtrs, I suppose you are able to go to the development environment. In the AOT the node reports contains all standard reports and your own customized repots. If you want to start building a new report based on an existing one, find the existing report, right-click and select duplicate from the shortcut menu. This will create a copy of the existing report, which you can then rename and modify as you wish. Keep in mind however that documents like the invoice are in most instances called from a class method. Modifying the copy does not make sense unless you add functionality to existing methods to call this new document. Regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, madtrs [EMAIL PROTECTED] wrote: Hello, Can anyone tell me how I can modify Axapta reports? I do not want to overwrite canned reports. I only want to customize certain canned reports and save them as new reports. Is there a general report section in Axapta where all reports are located regardless of its parent module? Thanks for any assistance, Madtrs 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/
[Axapta-Knowledge-Village] Changing ID's Extended Data Types
Dear all, I have a situation where extended data types are created in the user layer and need to transferred to the var layer. I have done some tests and those show a change will not influence the data in the database. However just to be sure, will a change of id have an influence on axapta. I am replacing the user defined extended data type with one defined in the var layer. regards, Danny 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/
[Axapta-Knowledge-Village] Re: Changing ID's Extended Data Types
Thanks Preston, I am aware of the id's fields on tables get. I had this problemn and have already solved it. (transferred the definition to the var layer and handle the data). I only need to do it for the extended data types now. regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, Preston A. Larimer [EMAIL PROTECTED] wrote: If you add a field to a table in the USR layer, using a an EDT that was defined in the USR layer, the filed will exist on the table in the USR layer, it gets a fieldId in the range of USR layer ID's, if you come back later and change the EDT on that field to an EDT defined in that VAR layer, the field on the table will STILL exist in the USR layer and with the same FieldID it had before, EDT used will not affect the layer of a field. If you want this field in another layer you will have to delete the field from the table, and re-add it in the appropriate layer. Keep in mind Axapta makes use of fieldID's in classes, forms and report definitions even though it's not readably visible , and doing a change like this will most likely mean touching every other object in Axapta that is currently using that field, also if the field contains data you will have to come up with a plan to preserve it. It may be wiser to create a new field in the desired layer, create a job to copy data from the old to the new, and then edit each of the AOT objects that make use of the old field to point at the new; you can then safely delete the old field. -Preston _ From: Danny Gaethofs [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 25, 2005 6:32 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Changing ID's Extended Data Types Dear all, I have a situation where extended data types are created in the user layer and need to transferred to the var layer. I have done some tests and those show a change will not influence the data in the database. However just to be sure, will a change of id have an influence on axapta. I am replacing the user defined extended data type with one defined in the var layer. regards, Danny 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] mailto:[EMAIL PROTECTED] subject=Unsubsc ribe * Your use of Yahoo! Groups is subject to the Yahoo! http://docs.yahoo.com/info/terms/ Terms of Service. 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/
[Axapta-Knowledge-Village] SalesLine disappears
Dear all, I have a SalesLine record that is not shown in the form SalesTable while the record is available in the table SalesLine. One can even create a new line and it will be added to the Table SalesLine with the same line number as the one that is not visible. Using the debugger I have been trying to track where the salesLine table records are retrieved in the form. But I cannot succeed. Two questions: - has anyone experienced the same issue, lines not displayed in the form while they are available - what method is responsible for retrieving the salesLine record and display it in the form Regards, Danny 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] Re: SalesLine disappears
Girish, We are not seeing the salesid in the form. I have checked the table salesLine and saw that the record is in there. Something happened when the user was processing the sales order. The salesID in the salesLine table is equal to the salesId in the salestable table and still the record is not displaying in the form. So I am trying to figure out how come. And thus when in the form the record is retrieved. regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, Girish B [EMAIL PROTECTED] wrote: sorry this is a stupid question of mine , do you see the salesId in the salesLine table?? and how r u populating the salesline table ? --- Danny Gaethofs [EMAIL PROTECTED] wrote: - Dear all, I have a SalesLine record that is not shown in the form SalesTable while the record is available in the table SalesLine. One can even create a new line and it will be added to the Table SalesLine with the same line number as the one that is not visible. Using the debugger I have been trying to track where the salesLine table records are retrieved in the form. But I cannot succeed. Two questions: - has anyone experienced the same issue, lines not displayed in the form while they are available - what method is responsible for retrieving the salesLine record and display it in the form Regards, Danny 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. ___ ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/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] Re: SalesLine disappears
Girish, We are not seeing the salesid in the form. I have checked the table salesLine and saw that the record is in there. Something happened when the user was processing the sales order. The salesID in the salesLine table is equal to the salesId in the salestable table and still the record is not displaying in the form. So I am trying to figure out how come. And thus when in the form the record is retrieved. regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, Girish B [EMAIL PROTECTED] wrote: sorry this is a stupid question of mine , do you see the salesId in the salesLine table?? and how r u populating the salesline table ? --- Danny Gaethofs [EMAIL PROTECTED] wrote: - Dear all, I have a SalesLine record that is not shown in the form SalesTable while the record is available in the table SalesLine. One can even create a new line and it will be added to the Table SalesLine with the same line number as the one that is not visible. Using the debugger I have been trying to track where the salesLine table records are retrieved in the form. But I cannot succeed. Two questions: - has anyone experienced the same issue, lines not displayed in the form while they are available - what method is responsible for retrieving the salesLine record and display it in the form Regards, Danny 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. ___ ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/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] Re: SalesLine disappears
Dear all, There seems something wrong with the InventDim table. Once I removed the table from the Form (made a duplicate) I can see the salesLine. regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, Danny Gaethofs [EMAIL PROTECTED] wrote: Girish, We are not seeing the salesid in the form. I have checked the table salesLine and saw that the record is in there. Something happened when the user was processing the sales order. The salesID in the salesLine table is equal to the salesId in the salestable table and still the record is not displaying in the form. So I am trying to figure out how come. And thus when in the form the record is retrieved. regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, Girish B [EMAIL PROTECTED] wrote: sorry this is a stupid question of mine , do you see the salesId in the salesLine table?? and how r u populating the salesline table ? --- Danny Gaethofs [EMAIL PROTECTED] wrote: - Dear all, I have a SalesLine record that is not shown in the form SalesTable while the record is available in the table SalesLine. One can even create a new line and it will be added to the Table SalesLine with the same line number as the one that is not visible. Using the debugger I have been trying to track where the salesLine table records are retrieved in the form. But I cannot succeed. Two questions: - has anyone experienced the same issue, lines not displayed in the form while they are available - what method is responsible for retrieving the salesLine record and display it in the form Regards, Danny 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. ___ ALL-NEW Yahoo! Messenger - all new features - even more fun! 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/
[Axapta-Knowledge-Village] Re: SalesLine disappears
Myrl, Indeed somebody has been juggling with the inventDim. I copied the value from the inventDim record back into the salesLine but it is not solving the problem. Any other possibilities? regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, Myrl Stadnick [EMAIL PROTECTED] wrote: Check to see if an inventdimId exists in the salesline. If the inventory dimension does not exist on the salesline the record will not show. The innerjoin linktype property of the datasource on the inventDim table has to have a record to match a record of InventdimId from the salesline. Once there is a match the record will show. Hope this helps. Myrl -Original Message- From: Danny Gaethofs [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 18, 2005 8:37 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: SalesLine disappears Dear all, There seems something wrong with the InventDim table. Once I removed the table from the Form (made a duplicate) I can see the salesLine. regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, Danny Gaethofs [EMAIL PROTECTED] wrote: Girish, We are not seeing the salesid in the form. I have checked the table salesLine and saw that the record is in there. Something happened when the user was processing the sales order. The salesID in the salesLine table is equal to the salesId in the salestable table and still the record is not displaying in the form. So I am trying to figure out how come. And thus when in the form the record is retrieved. regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, Girish B [EMAIL PROTECTED] wrote: sorry this is a stupid question of mine , do you see the salesId in the salesLine table?? and how r u populating the salesline table ? --- Danny Gaethofs [EMAIL PROTECTED] wrote: - Dear all, I have a SalesLine record that is not shown in the form SalesTable while the record is available in the table SalesLine. One can even create a new line and it will be added to the Table SalesLine with the same line number as the one that is not visible. Using the debugger I have been trying to track where the salesLine table records are retrieved in the form. But I cannot succeed. Two questions: - has anyone experienced the same issue, lines not displayed in the form while they are available - what method is responsible for retrieving the salesLine record and display it in the form Regards, Danny 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. ___ ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com Sharing the knowledge on Axapta. Yahoo! Groups Links 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/
[Axapta-Knowledge-Village] Re: SalesLine disappears
Thanks all for your help. Second attempt copying the InventDimId to the salesLine did solve the problem. regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, Danny Gaethofs [EMAIL PROTECTED] wrote: Myrl, Indeed somebody has been juggling with the inventDim. I copied the value from the inventDim record back into the salesLine but it is not solving the problem. Any other possibilities? regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, Myrl Stadnick [EMAIL PROTECTED] wrote: Check to see if an inventdimId exists in the salesline. If the inventory dimension does not exist on the salesline the record will not show. The innerjoin linktype property of the datasource on the inventDim table has to have a record to match a record of InventdimId from the salesline. Once there is a match the record will show. Hope this helps. Myrl -Original Message- From: Danny Gaethofs [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 18, 2005 8:37 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: SalesLine disappears Dear all, There seems something wrong with the InventDim table. Once I removed the table from the Form (made a duplicate) I can see the salesLine. regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, Danny Gaethofs [EMAIL PROTECTED] wrote: Girish, We are not seeing the salesid in the form. I have checked the table salesLine and saw that the record is in there. Something happened when the user was processing the sales order. The salesID in the salesLine table is equal to the salesId in the salestable table and still the record is not displaying in the form. So I am trying to figure out how come. And thus when in the form the record is retrieved. regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, Girish B [EMAIL PROTECTED] wrote: sorry this is a stupid question of mine , do you see the salesId in the salesLine table?? and how r u populating the salesline table ? --- Danny Gaethofs [EMAIL PROTECTED] wrote: - Dear all, I have a SalesLine record that is not shown in the form SalesTable while the record is available in the table SalesLine. One can even create a new line and it will be added to the Table SalesLine with the same line number as the one that is not visible. Using the debugger I have been trying to track where the salesLine table records are retrieved in the form. But I cannot succeed. Two questions: - has anyone experienced the same issue, lines not displayed in the form while they are available - what method is responsible for retrieving the salesLine record and display it in the form Regards, Danny 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. ___ ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com Sharing the knowledge on Axapta. Yahoo! Groups Links 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] Caching
Dear all, When doing modifications users have to log out and log in again to see the modification in a 3-tier environment. Sometimes they have to do this a few times before actually the modificiation is visible. Because of this I have a few questions: - Is it possible to realize modifications are made visible without users having to log out and without having to use Refresh tools on the client. - How does the application knows that something is already cached? I have been looking and testing with the class SysGlobalCache methods. The set() method is called almost every time an object is opened or changed. - How can a cached class or method be released? Regards, Danny Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/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] Re: VAR/USR Layer changes and data
Jesper, Running ax3.0SP3. You are absolutely right. I tested it today and the data disappears after synchronization. ## SQL Administration You suggest SQL Administration, Table, Synchronize could to the trick. I have tested this but it deletes the data also. You probably ment to say use SQL Administration for synchronization. ## Field Id modification I am following the other way you suggested. It is working! ## Export/Import with ID Values Someone else suggested me, to export the usr layer with ID Values from the production environment. Import the xpo with ID Values into the VAR layer of the development environment. Then copy the VAR layer from the development back to the production environment. I have also been doing some test following this method. I notice that when I import the xpo in the VAR layer the objects will keep their ID from the USR Layer. I stopped testing because in that way it seems logical that the data remains available, because the ID´s are not changing. Question here is whether the object, fields in this case, really belong to the VAR Layer. Has someone experimented or used this in the past. regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, Jesper Kehlet [EMAIL PROTECTED] wrote: You don't mention anything about synchronizing. Did you? That is the lithmus-test... From: Danny Gaethofs [mailto:[EMAIL PROTECTED] Sent: Monday, January 10, 2005 10:54 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: VAR/USR Layer changes and data Dear Jesper, I am running axapta 3.0 sp3. To simulate the situation I did some testing in a test-environment and in a development-environment. I created a new field for the table VendTable in both environments. In my test-environment I did it in the usr layer. In my development environment I did it in the var layer. Same name for the field. I entered data in the field for the records in my test-environment. I logged out of both environments. I removed the axusr.aod and related files from the test- environment application directory. I copied the axvar.aod and related files from the development-environment to the test-environment application directory. I started the axapta test-environment. Axapta then starts building the axapd.aoi, axapden-us.khi and axapden-us.ahi files. After that I logged in and checked whether the data entered previously was still there. I checked the field id, which was changed from 51 into 31. The data was still in the fields. regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, Jesper Kehlet [EMAIL PROTECTED] wrote: Your explanation is a little confusing: Did you do a synchronize in your own environment? What version of Axapta are you using? From: Danny Gaethofs [mailto:[EMAIL PROTECTED] Sent: Monday, January 10, 2005 9:57 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: VAR/USR Layer changes and data Dear all, The reason for my question was that my customer made noticed after they installed the var layer that the field values were deleted. I did some testing in my own environment. I removed the USR layer file axusr.aod and related files and replaced them by axvar.aod. After logging back into axapta I saw the id's of the fields were changed from 51 to 31. The data in the fields was not deleted. I conclude that using this approach replacing axusr.aod with axvar.aod will not change the content of the fields in the table being modified. Only thing that is changed are the id's. regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, Jesper Kehlet [EMAIL PROTECTED] wrote: Use the SQL Administration/Tables/Synchronize -- it works just fine, at least in 3.0. Another way to go about this, and if it's only a few fields (Caution: Should be done in 2-tier mode with AOSs shut down, and without anybody else in the system!): 1. In the SqlDictionary table, find the fields, and change their field ids to the new field ids (5 - 3), then log out. 2. Put the new VAR/USR layer in there. 3. Start Axapta and perform synchronization to create other new fields etc. Of course, test it in a test environment before you perform updates in live environments -- you may experience some trouble that causes it to go haywire, especially in heavily customized systems. From: Danny Gaethofs [mailto:[EMAIL PROTECTED] Sent: Monday, January 10, 2005 8:12 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] VAR/USR Layer changes and data Dear all, One of my customers has made table
[Axapta-Knowledge-Village] SysPrintForm/Email
Dear all, Can someone tell me how the selection made in the SysPrintForm is returned to the form SalesEditLines. When selecting email I want to influence the outlook id that is used for sending the message. Is it possible to use another sender id then the outlook id of the user/employee. Which method calls outlook from these forms? regards, Danny Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/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] VAR/USR Layer changes and data
Dear all, One of my customers has made table changes in the usr layer. They added new fields. These fields have been used already in their production database and of course values have been entered. Now I need to transfer these changes to the VAR layer. I notice when I just export the changes and import them in the var layer, nothing happens. Is this correct, I assume it is a way the software is trying to keep things consistent. As such it is not possible to overwrite changes made in the user layer. Am I correct that it is not possible to load these changes into the var layer while they are still in the usr layer. Is this behavior only valid for tables? How can I get the changes transferred to the var layer without loosing the data already entered. regards, Danny Gaethofs 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/
[Axapta-Knowledge-Village] Re: VAR/USR Layer changes and data
Dear all, The reason for my question was that my customer made noticed after they installed the var layer that the field values were deleted. I did some testing in my own environment. I removed the USR layer file axusr.aod and related files and replaced them by axvar.aod. After logging back into axapta I saw the id's of the fields were changed from 51 to 31. The data in the fields was not deleted. I conclude that using this approach replacing axusr.aod with axvar.aod will not change the content of the fields in the table being modified. Only thing that is changed are the id's. regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, Jesper Kehlet [EMAIL PROTECTED] wrote: Use the SQL Administration/Tables/Synchronize -- it works just fine, at least in 3.0. Another way to go about this, and if it's only a few fields (Caution: Should be done in 2-tier mode with AOSs shut down, and without anybody else in the system!): 1. In the SqlDictionary table, find the fields, and change their field ids to the new field ids (5 - 3), then log out. 2. Put the new VAR/USR layer in there. 3. Start Axapta and perform synchronization to create other new fields etc. Of course, test it in a test environment before you perform updates in live environments -- you may experience some trouble that causes it to go haywire, especially in heavily customized systems. From: Danny Gaethofs [mailto:[EMAIL PROTECTED] Sent: Monday, January 10, 2005 8:12 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] VAR/USR Layer changes and data Dear all, One of my customers has made table changes in the usr layer. They added new fields. These fields have been used already in their production database and of course values have been entered. Now I need to transfer these changes to the VAR layer. I notice when I just export the changes and import them in the var layer, nothing happens. Is this correct, I assume it is a way the software is trying to keep things consistent. As such it is not possible to overwrite changes made in the user layer. Am I correct that it is not possible to load these changes into the var layer while they are still in the usr layer. Is this behavior only valid for tables? How can I get the changes transferred to the var layer without loosing the data already entered. regards, Danny Gaethofs 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] mailto:[EMAIL PROTECTED] subject=Uns ubscribe * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . 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] Re: VAR/USR Layer changes and data
Dear Jesper, I am running axapta 3.0 sp3. To simulate the situation I did some testing in a test-environment and in a development-environment. I created a new field for the table VendTable in both environments. In my test-environment I did it in the usr layer. In my development environment I did it in the var layer. Same name for the field. I entered data in the field for the records in my test-environment. I logged out of both environments. I removed the axusr.aod and related files from the test-environment application directory. I copied the axvar.aod and related files from the development-environment to the test-environment application directory. I started the axapta test-environment. Axapta then starts building the axapd.aoi, axapden-us.khi and axapden-us.ahi files. After that I logged in and checked whether the data entered previously was still there. I checked the field id, which was changed from 51 into 31. The data was still in the fields. regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, Jesper Kehlet [EMAIL PROTECTED] wrote: Your explanation is a little confusing: Did you do a synchronize in your own environment? What version of Axapta are you using? From: Danny Gaethofs [mailto:[EMAIL PROTECTED] Sent: Monday, January 10, 2005 9:57 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: VAR/USR Layer changes and data Dear all, The reason for my question was that my customer made noticed after they installed the var layer that the field values were deleted. I did some testing in my own environment. I removed the USR layer file axusr.aod and related files and replaced them by axvar.aod. After logging back into axapta I saw the id's of the fields were changed from 51 to 31. The data in the fields was not deleted. I conclude that using this approach replacing axusr.aod with axvar.aod will not change the content of the fields in the table being modified. Only thing that is changed are the id's. regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, Jesper Kehlet [EMAIL PROTECTED] wrote: Use the SQL Administration/Tables/Synchronize -- it works just fine, at least in 3.0. Another way to go about this, and if it's only a few fields (Caution: Should be done in 2-tier mode with AOSs shut down, and without anybody else in the system!): 1. In the SqlDictionary table, find the fields, and change their field ids to the new field ids (5 - 3), then log out. 2. Put the new VAR/USR layer in there. 3. Start Axapta and perform synchronization to create other new fields etc. Of course, test it in a test environment before you perform updates in live environments -- you may experience some trouble that causes it to go haywire, especially in heavily customized systems. From: Danny Gaethofs [mailto:[EMAIL PROTECTED] Sent: Monday, January 10, 2005 8:12 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] VAR/USR Layer changes and data Dear all, One of my customers has made table changes in the usr layer. They added new fields. These fields have been used already in their production database and of course values have been entered. Now I need to transfer these changes to the VAR layer. I notice when I just export the changes and import them in the var layer, nothing happens. Is this correct, I assume it is a way the software is trying to keep things consistent. As such it is not possible to overwrite changes made in the user layer. Am I correct that it is not possible to load these changes into the var layer while they are still in the usr layer. Is this behavior only valid for tables? How can I get the changes transferred to the var layer without loosing the data already entered. regards, Danny Gaethofs 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] mailto:[EMAIL PROTECTED] subject=Uns ubscribe * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . 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] mailto:[EMAIL PROTECTED] subject=Uns ubscribe * Your use of Yahoo! Groups is subject
[Axapta-Knowledge-Village] Re: simple report question
Raul, This sounds logical. I am going to try it first thing tommorrow. Let you know whether it works. Danny --- In Axapta-Knowledge-Village@yahoogroups.com, Raul Llorente Peña/OPENSOLUTIONS [EMAIL PROTECTED] wrote: 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] simple report question
Dear all, I want to realize that a control field in a programmable section repeats 5 times on the first line of my report. To test this I created a simple programmable section containing the field ItemId. I send the item record from the fetch() method. Using a while loop in my fetch method and a counter I want the item to be printed 5 times on the first line of my report. I am not able to succeed, instead the item prints on five lines. Can someone explain me how I can realize this. Axapta 3.0 SP3. Danny 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] Re: simple report question
Dear Raul,
Before I asked this question I already investigated the
tutorial_positioning. This one is not solving my problem.
I already tried several ways to get it done but unsuccessfull.
I have been trying it with the topMargin and leftMargin, but that is
not working.
I have tried it your way but neither that is working. Perhaps I am
overlooking something in your explanation:
But what happens is that it is only printed below each other .
I have tried with setting the property of the control to right, but
then all prints on the right side.
my fetch() method contains:
topPostion = 13;
leftPosition = 6;
element.gotoYmm100(topPosition * 100);
while (ctr = numberoftimes)
{
element.gotoYmm100(topPostion*100); // need to rewind the position
on the page
element.execute(1);
if (ctr mod 5 == 0)
{
topPosition = topPosition + certainHeight;
leftPosition = leftMargin + certainWidth;
}
else
{
leftPosition = leftPosition + certainWidth;
}
element.gotoYmm100(topPosition*100);
ctr = ctr + 1
}
regards,
Danny
--- In Axapta-Knowledge-Village@yahoogroups.com, Raul Llorente
Peña/OPENSOLUTIONS [EMAIL PROTECTED] wrote:
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] Printing Labels/Stickers
Hello all, I need to develop a report that enable us to print labels/stickers for items. The label contains the item name, number, and other characteristics. For each Item a number of labels need to be printed. Now I have been looking for similar existing reports in the AOT but I cannot find one. Our label paper is A4 Format and contains three columns with labels width 64 mm and height 34 mm. Now a user can select the number of labels to print for a specific item. It means I somehow have to keep a counter. Print row by row labels. Is there an example available somewhere or is someone willing to share such kind of report. So I can use it as the basis. regards, Danny Yahoo! Groups Sponsor ~-- Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/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] Pack/Unpack - Modifications of SalesEditLinesForm
Dear all, I have added a checkbox PrintCertificate to the Form SalesEditLinesForm. To ensure the checkbox is enabled when the form runs (should only be enabled when posting is selected) I have set given the variable PrintCertificate the value True in the Dialog() method of the class SalesFormLetter_PackingSlip. However I do not see the checkbox as enabled when the dialog runs. The value of the variable PrintCertificate is assigned to the variable PrintCertificateChoice after accepting input in the dialog. The same as this is done for the checkbox PrintShippingLabel. I have seen that the classDeclaration of the class SalesFormLetter_PackingSlip contains a parmList, which is used in the pack() method and later in the unpack() method. Is it possible - although I run in 2 tier mode - on my laptop, that the pack() method is executed. And more important can it influence the value of the new fields. regards Danny Yahoo! Groups Sponsor ~-- Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/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] Macro Question
Dear all,
I have created a macro in the AOT containing the following:
#localmacro.TRA_Macro_Local1
print Hello local world;
pause;
#endmacro
Now I created a job containing the following:
static void TRA_Macro_Global1(Args _args)
{
#TRA_Macro_Local1
}
I expected I could just call the macro to have the code stored in
the macro executed. It makes no difference if I call the macro Local
or Global. The above is not working.
How can I put a large amount of code in a macro and execute it at
compile time?
regards,
Danny
Yahoo! Groups Sponsor ~--
$4.98 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/Q7_YsB/neXJAA/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] Re: Macro Question
Thanks Raul, Max, Otto, This confirms what I have been seeing. You always have to declare the macro before you can use it. There is not much difference between a macro library and a global macro or a local macro defined in the AOT. You have to declare it first before you can use it in a method. In my example stating #TRA_Macro_Local1 twice would do the job. Maybe it is a matter of terminology Global to me means more the way Max describes it. Declare the macro and its context, and use it where you want, whithout having to declare it at the beginning of the method or before using it. Using the #define macro to declare a symbolic constant globally also requires that we put it in a global macro or in a macro library which has to be declared before using it. regards, Danny --- In Axapta-Knowledge-Village@yahoogroups.com, Raul Llorente Peña/OPENSOLUTIONS [EMAIL PROTECTED] wrote: Yahoo! Groups Sponsor ~-- Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/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] Print 3 logos in PageFooter
Dear all, I need to print 3 logos in the footer of a standard document. How can I size these logos horizontally (width) and vertically (height). The property Height on the pageFooter does not help. It only defines the height of the pageFooter. I do not want to set the exact measurements of the bitmap using the properties width and height. I have set the property ResizeBitMap to yes and in fact expected the bitmaps to size (in width and height) based on the height setting of the PageFooter. Is there a way to make this work, without having to set the height and width on the bitmaps. regards, Danny Yahoo! Groups Sponsor ~-- $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/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] Pagefooter
Dear All, I have a pageFooter that only prints on the first pag. No space should be reserved for the footer in subsequent pages. How can I realize this? Regards, Danny Yahoo! Groups Sponsor ~-- $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/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] Checkbox printShippingLabel
Dear all, I have added a new checkbox the form SalesEditLines. CheckBox is named: printCertitificate, property AutoDeclaration = yes, AllowEdit = No, Skip = yes I Made sure that several methods on the Class SalesFormLetter are modified: - ClassDeclaration: add printCertificate - initParameters: set value for printCertificate I added two new methods on the class: - posPrintCertificate: set position - printCertificate: return the value of printCertificate Made sure that methods on Form SalesEditLines are modified: - ClassDeclaration: add printCertificateChoice - closeOk: added parameter printCertificateChoice - rearrange: added parameter printCertificate.value - run: retrieve value printCertificateChoice from container - active() method on datasource SalesParmTable: added setting of checkbox value (printCertificate.value(printCertificateChoice) Now I notice when I select the checkbox it is deselected immediately afterwards. It has something to do with the setting of printCertificate from the beginning. When I set it to yes in the classFormLetter.dialog the opposite occurs. When I deselect the checkbox it is enabled. Can someone help me out here regards, Danny Yahoo! Groups Sponsor ~-- $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/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] Re: Exporting data import/export definition groups
Hennie, You have to create a new definition group (type standard) and add the tables SysExpImpGroup SysExpImpField SysExpImpTable using the table setup. If you set user criterion you can restrict the definition groups that are selected for export. Thereafter just import the .dat or .def file, into your other environment. regards, Danny Gaethofs --- In [EMAIL PROTECTED], Hennie Potgieter [EMAIL PROTECTED] wrote: Hi, I have set up a big data import definition group job that I use to import legacy data into Axapta. I now want to move this job to my live environment but the Export button is disabled. Why is this or how am I suppose to export a definition group? Hennie Yahoo! Groups Sponsor ~-- Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/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] Data import error
Dear all, I have exported data import/export definitions from my development database. When importing my data import/export definition groups into a test database I get an error message. The message says not enough rights to insert the data or the imported file only contains shared tables. When importing the dat/def-file using the import wizard it works fine. The problem I have is that it seems impossible now to import other data using the definition groups. I get the message New table are available which have not been included in your group XXX. I seem not be able to solve this. Whatever I try, created new company, use the admin login, ... It certainly will be a small thing that I am overlooking. Anyone aware of this problem and knows how to solve it? regards, Danny Yahoo! Groups Sponsor ~-- $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/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] Emailing instead of printing.
Dear all, Can I have the email address defaulted automatically from the customer contact person when I select email during printing of an invoice? If that functionality is not standard provided which class do I need to modify? I have looked at the from SysPrintForm but can not find out how the selections made there are transferred. regards, Danny Gaethofs Yahoo! Groups Sponsor ~-- Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/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] QueryBuildRange question
Dear all, I added a QueryBuildRange to my query. I expected that when opening the Criteria column I would see all the unique values available in my table but I do not. I believe I understand the reason, but while I am not sure, I just want to have some input of you. I think it is because I am not using a field that is indexed. It happens I am using a field that is part of an index. This is the QueryBuildRange I added to my query: qryBuildRange = qryBuildDataSource.addRange(FieldNum(Address, AddrTableID)); The field AddrTableId is part of the index AddreIdx, which contains the fields AddrRecId and LineNum. How can I get the full list of available values shown in the column criteria? regards, Danny Yahoo! Groups Sponsor ~-- $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/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: RE : [Axapta-Knowledge-Village] QueryBuildRange question
it is just a job I am running --- In [EMAIL PROTECTED], Steeve Gilbert [EMAIL PROTECTED] wrote: There's not link between fields in indexes and range not being there. Try pressing Reset when you see the range columns. In what method did you add your range? Steeve... -Message d'origine- De : Danny Gaethofs [mailto:[EMAIL PROTECTED] Envoyé : 6 décembre 2004 06:23 À : [EMAIL PROTECTED] Objet : [Axapta-Knowledge-Village] QueryBuildRange question Dear all, I added a QueryBuildRange to my query. I expected that when opening the Criteria column I would see all the unique values available in my table but I do not. I believe I understand the reason, but while I am not sure, I just want to have some input of you. I think it is because I am not using a field that is indexed. It happens I am using a field that is part of an index. This is the QueryBuildRange I added to my query: qryBuildRange = qryBuildDataSource.addRange(FieldNum(Address, AddrTableID)); The field AddrTableId is part of the index AddreIdx, which contains the fields AddrRecId and LineNum. How can I get the full list of available values shown in the column criteria? regards, Danny Sharing the knowledge on Axapta. Yahoo! Groups Links Yahoo! Groups Sponsor ~-- $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/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] Re: unbalanced x++ ttsbegin/ttscommit
dear Girish,
Thanks a lot! The problem is solved. I got rid of the unbalance by
moving the ttsbegin down the prompt and closing it accordingly.
regards,
Danny
--- In [EMAIL PROTECTED], Girish B
[EMAIL PROTECTED] wrote:
put the ttsbegin after
if (qryRunAddress.prompt()) and then close the
transaction by ttscommit accordingly.
cheers,
Girish
--- Danny Gaethofs [EMAIL PROTECTED] wrote:
-
dear all,
I am writing a job to update some values on a table
based on input
from the user.
The user is presented a query input form and can enter
a value.
The whole job is intended to enable users to correct
the relations
between alternate addresses and custtable.
The job now generates an unbalanced x++
ttsbegin/ttscommit error,
which I am unable to resolve. Is there someone that
can help me out.
Hereafter part of the job.
static void UTIL_CreateAddressRelation(Args _args)
{
Address address;
CustTable custTable;
Query qryAddress;
QueryRunqryRunAddress;
QueryBuildDataSourceqryBuildDataSource;
QueryBuildRange qryBuildRange;
qryAddress = new Query();
qryBuildDataSource =
qryAddress.addDataSource(TableNum
(Address));
qryBuildRange =
qryBuildDataSource.addRange(FieldNum
(Address, AddrTableId));
qryBuildRange.value(*);
qryBuildDataSource.update(true);
/* begin transaction */
ttsbegin;
qryRunAddress = new QueryRun(qryAddress);
if (qryRunAddress.prompt()) // here is where
the query starts
{
while (qryRunAddress.next())
{
address =
qryRunAddress.get(TableNum(Address));
print address.Name;
print address.AddrRecId;
print address.AddrTableId;
print address.AddrTableId == 77;
pause;
switch (address.AddrTableId)
{
case 77:
{
select custTable
where custTable.AccountNum
== 4002;
if (custTable)
{
print
custTable.AccountNum;
pause;
ttsbegin;
address.AddrRecId =
custTable.RecId;
address.update();
ttscommit;
}
break;
}
default:
print Default; pause;
} // end switch
} // end while
} // end if
/* end transaction */
ttscommit;
}
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! Mail - You care about security. So do we.
http://promotions.yahoo.com/new_mail
Yahoo! Groups Sponsor ~--
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/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] Find RecId
Dear all, I have a small question. I have a table that contains a field of type string. This fields contains values that correspond to recid's in another table. Now I want to use the first table and find the records in the other table. I am looking for a way to search for recid's based on values in a string field. Something like select table where RecId == (stringfield) How can I transform the stringfield into a recid type or vice versa ? the function any2str is not working regards, Danny Yahoo! Groups Sponsor ~-- $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/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] Re: Find RecId
Andreas,
No that is not working.
You can check it when you print for example:
print custTable.name + num2str(custTable.RecId)
Now that is not what I am trying to do but it gives me the quickest
result to check whether it is possible.
regards and thanks anyway,
Danny
--- In [EMAIL PROTECTED], Andrae, Tobias
[EMAIL PROTECTED] wrote:
num2str() ?
-Ursprüngliche Nachricht-
Von: Danny Gaethofs [mailto:[EMAIL PROTECTED]
Gesendet: Mo 06.12.2004 16:26
An: [EMAIL PROTECTED]
Cc:
Betreff: [Axapta-Knowledge-Village] Find RecId
Dear all,
I have a small question. I have a table that contains a
field of
type string. This fields contains values that correspond to
recid's
in another table. Now I want to use the first table and find
the
records in the other table.
I am looking for a way to search for recid's based on values
in a
string field. Something like
select table
where RecId == (stringfield)
How can I transform the stringfield into a recid type or
vice versa ?
the function any2str is not working
regards,
Danny
Yahoo! Groups Sponsor --
--~--
$4.98 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/kGEolB/TM
-
---~-
Sharing the knowledge on Axapta.
Yahoo! Groups Links
Yahoo! Groups Sponsor ~--
$4.98 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/Q7_YsB/neXJAA/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: RE : RE : [Axapta-Knowledge-Village] QueryBuildRange question
Dear Steeve, See my previous message on the unbalance ttsbegin/ttscommit. That is the job. Have a look at it. When I run it I am only see one record in the list that pops up when I open the field criteria. regards, Danny --- In [EMAIL PROTECTED], Steeve Gilbert [EMAIL PROTECTED] wrote: Can you send your job here? Steeve... -Message d'origine- De : Danny Gaethofs [mailto:[EMAIL PROTECTED] Envoyé : 6 décembre 2004 09:14 À : [EMAIL PROTECTED] Objet : Re: RE : [Axapta-Knowledge-Village] QueryBuildRange question it is just a job I am running --- In [EMAIL PROTECTED], Steeve Gilbert [EMAIL PROTECTED] wrote: There's not link between fields in indexes and range not being there. Try pressing Reset when you see the range columns. In what method did you add your range? Steeve... -Message d'origine- De : Danny Gaethofs [mailto:[EMAIL PROTECTED] Envoyé : 6 décembre 2004 06:23 À : [EMAIL PROTECTED] Objet : [Axapta-Knowledge-Village] QueryBuildRange question Dear all, I added a QueryBuildRange to my query. I expected that when opening the Criteria column I would see all the unique values available in my table but I do not. I believe I understand the reason, but while I am not sure, I just want to have some input of you. I think it is because I am not using a field that is indexed. It happens I am using a field that is part of an index. This is the QueryBuildRange I added to my query: qryBuildRange = qryBuildDataSource.addRange(FieldNum(Address, AddrTableID)); The field AddrTableId is part of the index AddreIdx, which contains the fields AddrRecId and LineNum. How can I get the full list of available values shown in the column criteria? regards, Danny Sharing the knowledge on Axapta. Yahoo! Groups Links Sharing the knowledge on Axapta. Yahoo! Groups Links Yahoo! Groups Sponsor ~-- Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/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] Re: Purpose of Axapta Tables
Dear Ahmed, Hennie, Start by looking at the form SalesTable. You will see the data sources that are used, SalesLine, SalesTable, InventDim. These are the tables that are directly used in some way. For sure the salesline and salestable are used. When an invoice is created you clicked the button posting. This will ultimately activate the class SalesFormLetter_Invoice. Tables populated during that process are for example: CustInvoiceJour, SalesParmTable, SalesParmLine, ... But it is possible if you activate buttons and functionality behind it that you update other tables. It goes too far to explain all of it. Best is you start looking at the form. Let us know precisely what you are looking for. regards, Danny --- In [EMAIL PROTECTED], Ahmed Ibrahim [EMAIL PROTECTED] wrote: That would be great if you help me for the same. I keen to know it. Ahmed Hennie Potgieter [EMAIL PROTECTED] wrote: If you find this, I would like to see it too. This would be a tremendous help. Hennie -Original Message- From: madtrs [mailto:[EMAIL PROTECTED] Sent: Friday, 03 December 2004 20:38 PM To: [EMAIL PROTECTED] Subject: [Axapta-Knowledge-Village] Purpose of Axapta Tables Hello, Does anyone know where I can find a reference to Axapta tables? I'd like to know what tables are populated when a sales order is created? What tables are created when an invoice is created and posts, etc? Thanks... __ Do you Yahoo!? Yahoo! Mail - Easier than ever with enhanced search. Learn more. http://info.mail.yahoo.com/mail_250 Sharing the knowledge on Axapta. Yahoo! Groups Links 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!? Yahoo! Mail - You care about security. So do we. Yahoo! Groups Sponsor ~-- Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/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] PDF and email
Dear all, I have a few questions on emailing sales documents as pdf files. In the printer setup form I can select Email recipient, message format PDF and Save in print archive. When I do so my outlook mail is opened and the pdf file is attached, I only have to add an email address. I also notice the pdf file is stored in a document archive directory I created a while back. The questions I have are: 1. Is it possible to have the email address defaulted automatically from the customer contact person. If not standard available in what direction do I have to search to get this modified. In other words what classes or forms. 2. I can define a document archive directory for each customer. How can I ensure that the document is archived in the directory of the respective customer. (recipient of the document) 3. I suppose if I want all users in the organization to have access to the archive I have to use a shared disk drive. Am I correct? 4. I saw that the printer selection is done using the form SysPrintForm. But how the settings are used when I print the document I am not able to understand. Can someone shed some lights on this. regards, Danny Gaethofs Yahoo! Groups Sponsor ~-- $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/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] Re: add field to table
Hello Rhodpr, When adding new fields to a table the best approach is to create either an extended data type or a base enum for the new field. The EDT can extend other existing data types. In that way a lot of properties are inherited automatically later on when creating the fields in your table. Next you drag the new EDT to your fields node and the new field is created. Ok but suppose you did it your way, the new field you created will become visible in the forms data source node for the table. Open the data source in another window, find your new field and drag it to the place in the design where you want to have it positioned. There is even an easier way to make it visible in your form. If the field you added can be assigned to an existing field group in the table definition, it will automatically be included in the form. Give it a try! regards, Danny --- In [EMAIL PROTECTED], RHODPR [EMAIL PROTECTED] wrote: Hi guys, how can i add a brand new field to the inventory table? what I did so far : -) add a field to the table via AOT -- Data Dictionary -- Tables -- InventTable -- Fields : rightclick : new -- string. -) add the field to the form via AOT -- Forms -- InventTable -- Designs -- Design -- [Tab:Tab] -- [TabPage:General] -- [Group:Column1] -- [Group:Identification] : rightclick : new control -- stringEdit. No problems so far : the new stringeditbox has the same properties as StringEdit:ctrlItemId. Problem is that this field is not shown on the inventory table, and I can't add it via the setup of the table. Even after synchronization, the new field is not visible... thanks in advance! Yahoo! Groups Sponsor ~-- Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/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] SQL Server 2000 and MSDE
Dear all, Can I run Axapta with MSDE and SQL Server 2000 on the same system? I am running Axapta with an MSDE database on my laptop. Now for some reason I need to do some testing with SQL Server 2000. Can I have Axapta installed with the two database systems? regards, Danny Yahoo! Groups Sponsor ~-- $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/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] Re: Export modified objects at date
Dear Ahmed, Create a project. Open the project and select the application objects using a filter. In the filter you can indicate with the button select which application objects should be selected. You can add the created date or the modified date as a selection parameter. regards, Danny --- In [EMAIL PROTECTED], mbsdeveloper [EMAIL PROTECTED] wrote: Dears, Can someone help me. I want to export only the objects which is modified at date or in period in usr layer. regards Ahmed. Yahoo! Groups Sponsor ~-- Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/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] Hot Fixes
Dear all, I have been loading hot fixes in the VAR layer for some time now. But every time I do so I am wondering what the best approach is to load those hot fixes. Reading the text files of some of the hot fixes they always say open the development environment and import the xpo's. I know I can run into problems when loading hot fixes in the VAR layer. At least when I have made changes in the VAR layer, a hot fix can overwrite these. Can you share your experiences on this matter with me? regards, Danny Gaethofs Yahoo! Groups Sponsor ~-- Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/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] Re: 3rd party tax packages
Dear John, Have you looked for the Vertex Solution. I know it integrates with a lot of ERP applications. I have supported an install of Vertex in Europe, the Netherlands but with another ERP application. Regards, Danny Gaethofs --- In [EMAIL PROTECTED], John Remsberg [EMAIL PROTECTED] wrote: My client is looking for a 3rd party product to load/update the Axapta tax tables on a regular basis. It would also be helpful if the product also had all of the reporting forms for the various counties across the US. Do anyone have any suggestions? Weve looked at TaxWare and it's a little too expensive. Thanks, -John R. - Do you Yahoo!? The all-new My Yahoo! Get yours free! Yahoo! Groups Sponsor ~-- $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/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] SalesInvoice Document
Dear all, I have a question about Section Groups. Section Groups always refer to a table. What influence has this table on the position where the group content is printed. I added a section group to the BodyReference and this section group pointed to the table CustInvoiceJour. I expected the data to be printed at the end of the BodyReference but instead it printed even before the line item was printed. I have been looking in the developer's guide and the best practices guide but cannot find more information on how to use section groups. Is there someone that has a detailed description of this. regards, Danny Yahoo! Groups Sponsor ~-- $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/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] Re: Sales Invoice Layout
Dear Aji, All, I have figured it out. The methods initFromSalesTable and initFromSalesLine which can be found respectively on the table CustInvoiceJour and CustInvoiceTrans handle the initialization of the fields in these two tables. These methods are called by the method insertProForma(), which is called by the method createJournal (), which was called by the run() method on the class SalesFormLetter. regards, Danny Gaethofs --- In [EMAIL PROTECTED], Danny Gaethofs [EMAIL PROTECTED] wrote: Dear Aji, All, Thank you for explaining me the use of Docu::copy. I did have a look at the method copy but apparently not good enough. I was also a bit in a hurry. Thanks for making it clear. While I was reading your reply, two questions come up: 1. Can you tell me which method copies the data from Table SalesLine to CustInvoiceTrans. 2. Do you happen to have such a display method available? Just the basic format. Next when do you consider adding the fields to the table CustInvoiceTrans is justified? regards, Danny Gaethofs --- In [EMAIL PROTECTED], Aji Sarosa [EMAIL PROTECTED] wrote: Hi Danny, Not every fields you add to salesLine must also exist in CustInvoiceTrans, unless it is necessary for some reasons. If you want those fields to be printed on the invoice, you can try to modify the SalesInvoice report and add display methods to lookup data from your additional SalesLine's fields. Docu:copy(SalesLine, CustInvoiceTrans) is used to duplicate a document handling note's record in table DocuRef. This static method doesn't copy entire fields of SalesLine to CustInvoiceTrans, but it duplicates the document note's record belongs to salesLine to custInvoiceTrans' document note. It will then modify refTableId, refRecId, and refCompanyId (data area / company account id) which was previously set specific to salesLine to CustInvoiceTrans. Just don't confuse yourself with the term 'copy'. Sometimes you have to examine the codes behind the words. In this case, try to examine the static method copy(..) in class Docu, and analyze what it is doing actually. As a note, don't use Axapta's table browser to examine data contained in table DocuRef since some field visibilities are set to 'No'. You can set the visibility properties to 'Yes', or if you avoid to change the existing application, browse the table directly from the SQL Server. Regards, -Aji Sarosa- --- Danny Gaethofs [EMAIL PROTECTED] wrote: Dear all, I have added some fields to the salesline table. These fields should be printed on the invoice. The data printed on the invoice is taken from the tables custInvoiceJour and CustInvoiceTrans. These tables same to be populated with the methods writeJournal and writeJournalLine on the class SalesFormLetter_Invoice. These methods call a static copy method. For example: Docu::copy(salesLine, CustInvoiceTrans). Am I correct to assume that when I add the new fields also to the CustInvoiceTables that these are automatically taken over with the copy method. This method creates a new entry in the second parameter and copies the whole dataAreaId to this new record. I am assuming that dataAreaId includes all the fields on the salesLine table. Can someone help or confirm my assumptions. Regards, Danny Gaethofs __ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com Yahoo! Groups Sponsor ~-- $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/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] Re: Sales Invoice Layout
Dear Aji, All, Thank you for explaining me the use of Docu::copy. I did have a look at the method copy but apparently not good enough. I was also a bit in a hurry. Thanks for making it clear. While I was reading your reply, two questions come up: 1. Can you tell me which method copies the data from Table SalesLine to CustInvoiceTrans. 2. Do you happen to have such a display method available? Just the basic format. Next when do you consider adding the fields to the table CustInvoiceTrans is justified? regards, Danny Gaethofs --- In [EMAIL PROTECTED], Aji Sarosa [EMAIL PROTECTED] wrote: Hi Danny, Not every fields you add to salesLine must also exist in CustInvoiceTrans, unless it is necessary for some reasons. If you want those fields to be printed on the invoice, you can try to modify the SalesInvoice report and add display methods to lookup data from your additional SalesLine's fields. Docu:copy(SalesLine, CustInvoiceTrans) is used to duplicate a document handling note's record in table DocuRef. This static method doesn't copy entire fields of SalesLine to CustInvoiceTrans, but it duplicates the document note's record belongs to salesLine to custInvoiceTrans' document note. It will then modify refTableId, refRecId, and refCompanyId (data area / company account id) which was previously set specific to salesLine to CustInvoiceTrans. Just don't confuse yourself with the term 'copy'. Sometimes you have to examine the codes behind the words. In this case, try to examine the static method copy(..) in class Docu, and analyze what it is doing actually. As a note, don't use Axapta's table browser to examine data contained in table DocuRef since some field visibilities are set to 'No'. You can set the visibility properties to 'Yes', or if you avoid to change the existing application, browse the table directly from the SQL Server. Regards, -Aji Sarosa- --- Danny Gaethofs [EMAIL PROTECTED] wrote: Dear all, I have added some fields to the salesline table. These fields should be printed on the invoice. The data printed on the invoice is taken from the tables custInvoiceJour and CustInvoiceTrans. These tables same to be populated with the methods writeJournal and writeJournalLine on the class SalesFormLetter_Invoice. These methods call a static copy method. For example: Docu::copy(salesLine, CustInvoiceTrans). Am I correct to assume that when I add the new fields also to the CustInvoiceTables that these are automatically taken over with the copy method. This method creates a new entry in the second parameter and copies the whole dataAreaId to this new record. I am assuming that dataAreaId includes all the fields on the salesLine table. Can someone help or confirm my assumptions. Regards, Danny Gaethofs __ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com Yahoo! Groups Sponsor ~-- $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/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] Re: Address Field in CustTable
Thanks Allan, Do you happen to know why the country code is printed on documents such as invoice, confirmation, and so on. This does not seem logical to me. But maybe it is just a matter of initialization. regards, Danny Gaethofs --- In [EMAIL PROTECTED], allanwallis [EMAIL PROTECTED] wrote: On the menu choose Basic/setup/addresses/Address Format Find the address line for the country and tick the Expand Box 'E' You will now get the Country Name rather than the Country Code Have a look at the formataddress() method on the address table to see what happens Hope this helps --- In [EMAIL PROTECTED], Danny Gaethofs [EMAIL PROTECTED] wrote: Dear all, When an address is assembled in the field addressview the country code is added to the view. Can someone tell me how the address field is assembled. I have been searching for it, but cannot find a method or something else that does take care of it. In fact what I want is - or what axapta should do - lookup the country name and put it in the field. The reason is that the address field is printed on documents and it always prints the country code instead of the country name. If someone solved the issue of printing the country name in another way I would like to hear it. I am now trying to solve it in the custtable form address field. regards, Danny Yahoo! Groups Sponsor ~-- Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/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] Sales Documents
Dear all, I have been looking at the design of the sales documents and am a bit surprised that all of them are developed as separate designs. I need some help in confirming some doubts I have. A lot of these documents share common data and layout. Has there been a special reason for doing it this way. Is it not possible to use section templates and so on to build the design. regards, Danny Gaethofs Yahoo! Groups Sponsor ~-- $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/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] Address Field in CustTable
Dear all, When an address is assembled in the field addressview the country code is added to the view. Can someone tell me how the address field is assembled. I have been searching for it, but cannot find a method or something else that does take care of it. In fact what I want is - or what axapta should do - lookup the country name and put it in the field. The reason is that the address field is printed on documents and it always prints the country code instead of the country name. If someone solved the issue of printing the country name in another way I would like to hear it. I am now trying to solve it in the custtable form address field. regards, Danny Yahoo! Groups Sponsor ~-- $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/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/
