RE : [development-axapta] Re: How to access enum values in loop
I'm not sure if it's what you want, but maybe you could use the function enum2str(enumtype) and insert this value into the string field?
Bacon Joannick
Stagiaire Informatique / IT trainee
B O A - F R A N C | M I R A G E
T 418.227.1181 #2313
F 418.227.1188
www.boa-franc.com
-Message d'origine-
De : prabodh_kelkar [mailto:[EMAIL PROTECTED]
Envoy : 18 septembre, 2003 09:20
: [EMAIL PROTECTED]
Objet : [development-axapta] Re: How to access enum values in loop
Hi Harry,
Thanks for giving me time and trying out things for me
You tried to insert value in a enum field ABC.
But I was trying the reverse way.
I wanted to insert enum value to string field and not reverse way.
At last what i did is, i put all values to container, then used
conpeek function in loop to get values from the container then
inserted that value by converting to string.
Do u have any way to insert enum value to string field ???
Thanks,
Prabodh Kelkar
--- In [EMAIL PROTECTED], Harry [EMAIL PROTECTED] wrote:
hi Prabodh!
Confused.
I tried on my machine. Tried to insert value in a enum field ABC.
When i = 0
at the time of inserting the table browser shows the value of
ABC::None,
when i was 1 table browser shows the value of ABC::A and so on.
Are u trying something different?
regards
harry deshpande
-Original Message-
From: prabodh_kelkar [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 16 September 2003 8:46 p.m.
To: [EMAIL PROTECTED]
Subject: [development-axapta] Re: How to access enum values in loop
Hi,
I tried following code
int i = 0;
while (i= enumcnt(nameofenum))
{
ABCTable.columnname = i;
ABCTable.insert();
i++
}
But if u assign i to ABCTable.columnname, then, in the table the
value of i at that particular time is saved, and not the value of
element at i'th position in the enum.
Can we do that???
Thanks,
Prabodh
--- In [EMAIL PROTECTED], Harry [EMAIL PROTECTED]
wrote:
hi Prabodh!
int i = 0;
while (i= enumcnt(nameofenum))
{
ABCTable.columnname = i;
ABCTable.insert();
i++
}
will work.
all enum values are stored as integers and the text is displayed
when
browsing the table.
regards
harry
-Original Message-
From: prabodh_kelkar [mailto:[EMAIL PROTECTED]
Sent: Monday, 15 September 2003 10:43 p.m.
To: [EMAIL PROTECTED]
Subject: [development-axapta] Re: How to access enum values in
loop
Hi All,
Thanks for reply...
But It didn't solve my problem. It seems that I am not able to ask
question in proper way..
I am writing a job to populate data in table
In the job I want to insert the values from enum in the column.
there are 10 values in enum and I want to insert those 10 values
as
different rowsso I am using a loop.
In that loop I want to assign .
ABCTable.ColumnName = Enumvalue of enum at element equal to
Counter ;
then I use -- ABCTable.insert();
but, in loop i am not able to get value of the element at position
equal to counter, in the enum.
How should I do that?
Thanks,
Prabodh Kelkar
--- In [EMAIL PROTECTED],
[EMAIL PROTECTED]
wrote:
Hi,
try this.
int counter;
SysDictEnum SysDictEnum;;
SysDictEnum = new SysDictEnum(EnumNum(ABC));
for (counter = 0;
counter = enumcnt(ABC)-1;
counter++)
{
info(SysDictEnum.index2Label(counter));
}
Mit freundlichen Gren / Best regards / Med venlig Hilsen
Jesper Jrgensen
Original Message processed by Tobit InfoCenter
Subject: [development-axapta] Re: How to access enum values in
loop
(15-Sep-2003 11:32)
From:[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Hi,
Thanks for quick reply
But this is not my problem.
say that there is enum TestEnum1 with 4 elements A,B,C
and D. I want to print A,B,C and D...
I want to do this using a for loop with counter i...
How to get the element of enum TestEnum1 at position i,
programmatically and print it
Thanks,
Prabodh Kelkar
--- In [EMAIL PROTECTED], Harry [EMAIL PROTECTED]
wrote:
hi
int i = 0;
while (i= enumcnt(nameofenum))
{
i is the value of enum, do something with i.
i++
}
will work as long as the useenumvalues property of the enum is
set
to true
regards
harry deshpande
-Original Message-
From: prabodh_kelkar [mailto:[EMAIL PROTECTED]
Sent: Monday, 15 September 2003 9:08 p.m.
To: [EMAIL PROTECTED]
Subject: [development-axapta] How to access enum values in
loop
Hi,
I want to use the values of enum in loop.
I want to use the counter of the loop to navigate through the
elements/values of an enum. i.e. I want to get next value of
enum
as
loop navigates..How
RE : [development-axapta] Re: How to move up section on SalesInvoice
There's also another way to hide those fields without saving the space, use the .visible(false) function in place of the .hide()
After, if you need to display them again, use the .visible() or .visible(true) property
public void executeSection()
{
if (element.page() != 1)
{
//labels
InvoiceTo.visible(false);
Branch.visible(false);
DeliveredTo.visible(false);
//fields
CustInvoiceJour_InvoicingName.visible(false);
CustInvoiceJour_InvoicingAddress.visible(false);
BranchName.visible(false);
BranchAddress.visible(false);
CustInvoiceJour_DeliveryName.visible(false);
CustInvoiceJour_DeliveryAddress.visible(false);
}
super();
}
Bacon Joannick
Stagiaire Informatique / IT trainee
B O A - F R A N C | M I R A G E
T 418.227.1181 #2313
F 418.227.1188
www.boa-franc.com
-Message d'origine-
De : Preston A. Larimer [mailto:[EMAIL PROTECTED]
Envoy : 19 septembre, 2003 15:55
: [EMAIL PROTECTED]
Objet : RE: [development-axapta] Re: How to move up section on SalesInvoice
Carol in the execute section method you can use this.Height(0, Units::mm) to set the height to 0.
-Original Message-
From: carolkilduff [mailto:[EMAIL PROTECTED]
Sent: Friday, September 19, 2003 8:05 AM
To: [EMAIL PROTECTED]
Subject: [development-axapta] Re: How to move up section on SalesInvoice
Thanks for your advice Preston,
Do you mean set the section height in the executesection method? How
do I do this through code?
Regards,
Carol.
--- In [EMAIL PROTECTED], Preston A. Larimer
[EMAIL PROTECTED] wrote:
Carol, set the section height to be zero when you don't want it
displayed, or if there are still a few elements you are displaying
it,
just shorten the section height.
-Preston
-Original Message-
From: carolkilduff [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 18, 2003 11:47 AM
To: [EMAIL PROTECTED]
Subject: [development-axapta] How to move up section on SalesInvoice
Hi
I'm customising the SalesInvoice report. I only need to display
the
name and address details on the first page and not on subsequent
pages. I have done this by hding the fields in the executesection
method of the PageHeader: Invoice.
public void executeSection()
{
if (element.page() != 1)
{
//labels
InvoiceTo.hide();
Branch.hide();
DeliveredTo.hide();
//fields
CustInvoiceJour_InvoicingName.hide();
CustInvoiceJour_InvoicingAddress.hide();
BranchName.hide();
BranchAddress.hide();
CustInvoiceJour_DeliveryName.hide();
CustInvoiceJour_DeliveryAddress.hide();
}
super();
}
My problem is that when these fields don't print after the first
page, the lines section (SectionGroup: CustInvoiceJour) still
appears
in the same place rather than moving up the page to fill the space
where the name and address details have been hidden. Is there
anyway
I can position this section group differently on pages after the
first page?
Thanks for any advice.
Carol.
.
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] 2 report from salespickinglistjournal
Hi all, I have a little problem with the salespickinglistjournal report.
We had to change some of the standard functionality of Axapta to add our own.
We would like to create a new report with the same old function (that validate the picking) and launch after
our own.
I've override the print() function like that
Public int print(){
;
PickingReport = new ReportRun(new args(BOAPickingReport));
PickingReport.run();
Return true;
}
My question is :
How do I send the selected row from SalesPickingListJournalLine into that report? I mean I would like to take
The salespickinglistjournalline range and use it into that new report. How can I do that without using the
SalesPickingListJournalLine and SalesPickingListjournalTable in the BOAPickingReport?
Thanks in advance
Bacon Joannick
Stagiaire Informatique / IT trainee
B O A - F R A N C | M I R A G E
T 418.227.1181 #2313
F 418.227.1188
www.boa-franc.com
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta]
Hi all, I have a grid with the data I want, now I want to send a report related to one(or many) line in the grid, how can I do that? Bacon Joannick Stagiaire Informatique / IT trainee B O A - F R A N C | M I R A G E T 418.227.1181 #2313 F 418.227.1188 www.boa-franc.com Yahoo! Groups Sponsor ADVERTISEMENT Click Here! Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE : RE : [development-axapta] (unknown)
I would, but the problem is that I don't use any class, I use a menuItemButton and the showQueryValues method doesn't seems to exist elsewhere in the report
Thanks anyway :)
Bacon Joannick
Stagiaire Informatique / IT trainee
B O A - F R A N C | M I R A G E
T 418.227.1181 #2313
F 418.227.1188
www.boa-franc.com
-Message d'origine-
De : Cenk Ince [mailto:[EMAIL PROTECTED]
Envoy : 7 octobre, 2003 09:20
: [EMAIL PROTECTED]
Objet : RE: RE : [development-axapta] (unknown)
Hi
Try to override showQueryValues on class from which you call report.
I hope it helps.
-Original Message-
From: Joannick Bacon [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 07, 2003 3:58 PM
To: [EMAIL PROTECTED]
Subject: RE : [development-axapta] (unknown)
Thanks, it seems to works like I want
The only problem left is that when executing the report(with the clicked button) there's one prompt opening and I don't want that.
I try to overload the fetch method to remove the element.prompt() and element.query.prompt() but it doesn't seem to work, any clue?
Thanks
Bacon Joannick
-Message d'origine-
De : Thomas Vogt Poulsen [mailto:[EMAIL PROTECTED]
Envoy : 7 octobre, 2003 02:29
: [EMAIL PROTECTED]
Objet : [development-axapta] (unknown)
Hey Joannick
When working with datasources on a form you can set the grid-
proportie MultiSelect to YES. This makes it possible to mark one or
more lines.
I think the following eks. should do something like you wanted. In
the example the dataSource is CustTable.
The example is from 2.5 and there mayby a smarter way in 3.0.
Public void generateReport()
{
Argsargs = new Args();
MenuFunctionmenuFunction = new MenuFunction({REPORT MenuItem})
CustTable selectedCustomers;
selectedCustomers = CustTable_DS.getFirst();
if (selectedCustomers)
{
while (selectedCustomers) // MORE THAN ONE SELECTED
{
args.record(selectedCustomers);
menuFunction.run(_args);
selectedBunch = CustTable_ds.getNext();
}
}
else // JUST THE ACTIVE RECORD
{
args.record(selectedCustomers);
menuFunction.run(_args);
}
}
Best of luck
Thomas Poulsen
AXDATA A/S
--- In [EMAIL PROTECTED], Joannick Bacon
[EMAIL PROTECTED] wrote:
Hi all, I have a grid with the data I want, now I want to send a
report
related to one(or many) line in the grid, how can I do that?
Bacon Joannick
Stagiaire Informatique / IT trainee
B O A - F R A N C | M I R A G E
T 418.227.1181 #2313
F 418.227.1188
www.boa-franc.com
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Yahoo! Groups Sponsor
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE : [development-axapta] (unknown)
Thanks, it seems to works like I want
The only problem left is that when executing the report(with the clicked button) there's one prompt opening and I don't want that.
I try to overload the fetch method to remove the element.prompt() and element.query.prompt() but it doesn't seem to work, any clue?
Thanks
Bacon Joannick
-Message d'origine-
De : Thomas Vogt Poulsen [mailto:[EMAIL PROTECTED]
Envoy : 7 octobre, 2003 02:29
: [EMAIL PROTECTED]
Objet : [development-axapta] (unknown)
Hey Joannick
When working with datasources on a form you can set the grid-
proportie MultiSelect to YES. This makes it possible to mark one or
more lines.
I think the following eks. should do something like you wanted. In
the example the dataSource is CustTable.
The example is from 2.5 and there mayby a smarter way in 3.0.
Public void generateReport()
{
Argsargs = new Args();
MenuFunctionmenuFunction = new MenuFunction({REPORT MenuItem})
CustTable selectedCustomers;
selectedCustomers = CustTable_DS.getFirst();
if (selectedCustomers)
{
while (selectedCustomers) // MORE THAN ONE SELECTED
{
args.record(selectedCustomers);
menuFunction.run(_args);
selectedBunch = CustTable_ds.getNext();
}
}
else // JUST THE ACTIVE RECORD
{
args.record(selectedCustomers);
menuFunction.run(_args);
}
}
Best of luck
Thomas Poulsen
AXDATA A/S
--- In [EMAIL PROTECTED], Joannick Bacon
[EMAIL PROTECTED] wrote:
Hi all, I have a grid with the data I want, now I want to send a
report
related to one(or many) line in the grid, how can I do that?
Bacon Joannick
Stagiaire Informatique / IT trainee
B O A - F R A N C | M I R A G E
T 418.227.1181 #2313
F 418.227.1188
www.boa-franc.com
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Yahoo! Groups Sponsor
ADVERTISEMENT
Click Here!
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE : [development-axapta] datafield property of section group
You set the datafield property to a fieldname when you want to make a break between different records values For exemple Name : SectionGroup_SalesLine Table : SalesLine DataField : SalesId Will do something like that SalesId VendAccount. 110 22 340 if you remove the dataField SalesId and you may have something like this SalesId VendAccount 110 110 22 340 3 40 REMEMBER, in order to work, you have to use a sortfield with the same fieldname in the datasource Bacon Joannick Stagiaire Informatique / IT trainee B O A - F R A N C | M I R A G E T 418.227.1181 #2313 F 418.227.1188 www.boa-franc.com -Message d'origine- De : Cenk Ince [mailto:[EMAIL PROTECTED] Envoy : 16 octobre, 2003 04:41 : [EMAIL PROTECTED] Objet : [development-axapta] datafield property of section group Hi all; There are three properties in section groups in reports; Name, Data Field, Table. In some Section Groups, DataField is set, but in the others, it is not set. I wonder when to set a datafield property of a section group. Thanks in advance. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. Yahoo! Groups Sponsor Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] Haf a cheque - Half a question
Hi all, I'm actually looking to modify the display order of the cheque. I found the report Cheque_US, but the problem is that what is print is not only that report, there is also a section on the upper page where the detail information is printed (customer, invoice date, currency) I would like to know where to find this information to be able to change the information order Tnx in advance Bacon Joannick Stagiaire Informatique / IT trainee B O A - F R A N C | M I R A G E T 418.227.1181 #2313 F 418.227.1188 www.boa-franc.com Yahoo! Groups Sponsor ADVERTISEMENT click here Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE : [development-axapta] How to know the selected Language.
Infolog.language() Bacon Joannick Stagiaire Informatique / IT trainee B O A - F R A N C | M I R A G E T 418.227.1181 #2313 F 418.227.1188 www.boa-franc.com -Message d'origine- De : johnn_16 [mailto:[EMAIL PROTECTED] Envoy : 24 octobre, 2003 13:34 : [EMAIL PROTECTED] Objet : [development-axapta] How to know the selected Language. Hi, I want to know the global language of the application. I know that there is curExt() and curExt() to know the user and the selected compagny, but I want to know if there is a keyword to got the global language. (the one used in the whole application and that can be set in AxConfig) Thanks! Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. Yahoo! Groups Sponsor ADVERTISEMENT click here Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE : [development-axapta] Adjustment
I'm not sure, but there's maybe a way to do it. You could update the rightjustify field of SQLDictionary to true. tts begin; SELECT FORUPDATE SQLDictionary WHERE SQLDictionary.tableId == ?? SQLDictionary.FieldId == ?? ; RightJustify = true; SQLDictionary.update() tts commit; Bacon Joannick Stagiaire Informatique / IT trainee B O A - F R A N C | M I R A G E T 418.227.1181 #2313 F 418.227.1188 www.boa-franc.com -Message d'origine- De : byteway_so [mailto:[EMAIL PROTECTED] Envoy : 28 octobre, 2003 10:08 : [EMAIL PROTECTED] Objet : [development-axapta] Adjustment Hi all, I wonder if it is possible to adjust a field of a table programmatically. I know how to get to the SQLDictionary record for the specifick field. It goes something like: MyTable _table; int _tableId; int _fieldId; ; _tableid = _table.TableId; _fieldId = fieldName2Id(_tableid,MYCOLUMNNAME); But after I have that record, what do I need to do to get the Adjustment of the field for example to right? Any help would be appreciated. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. Yahoo! Groups Sponsor ADVERTISEMENT click here Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] Cost of inventory
Hi everyone, In the table InventTrans, they are 6 costAmount fields (Posted, STD, settled, physical, adjustment, operations). I want to make a report that compute the value of the inventory( selling cost, buying cost ). When looking in the Inventory Management Items Transactions menu, I can find the Cost for the purchased items, not the sold one. Is there anyway to find those selling cost? (and where if possible) Additional info : I could make a procedure that will compute the value of the InventTrans table (field Qty, and the costAmount needed) but right now, the only procedure looking like that is InventTrans.CostValue() for the Sales cost and taking the costAmountPhysical for any other kind of cost. I am right in the selection of those fields? FINALY!!! The problem with this custom procedure is the date selection, which date to pick when transtype of sales, BOM, purch.. Sometimes it's the dateFinancial, others datephysical or dateinvent How do I know which one to pick? Thanks for reading this long mail Event more thanks if you can respond :) Bacon Joannick Stagiaire Informatique / IT trainee B O A - F R A N C | M I R A G E T 418.227.1181 #2313 F 418.227.1188 www.boa-franc.com Yahoo! Groups Sponsor Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] date query bug
Hi again everybody, we've encounter a bug lately in axapta When we're making a queryRun and adding date value with the date2str() function, that date isn't recognize. We've trace the problem to the source, the regional settings of Windows. The real problem is : we're using the date format '-MM-DD' in the query, but since one user is in format 'DD-MM-', the query range isn't not associated correctly, thus some data is left behind. Does any of you have a hot fix for this problem, or do we have to return in all our reports with this problem and correct it to date2str(_date,-1,-1,-1,-1,-1,-1,-1)? Thanks in advance Bacon Joannick Stagiaire Informatique / IT trainee B O A - F R A N C | M I R A G E T 418.227.1181 #2313 F 418.227.1188 www.boa-franc.com Yahoo! Groups Sponsor Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] inventOnHand report modifications
Hi all, I'd like to make some change to the inventOnHand report to be able to sort it by itemGroupId and itemName(or the equivalent in inventTxt) For that, I need to add inventTable and inventTxt table in the query. Is there any way to do it by code by updating the fetch method, or do I have to change the class inventReport_OnHand as well as the datasource of the inventOnHand report? Thanks all Bacon Joannick Stagiaire Informatique / IT trainee B O A - F R A N C | M I R A G E T 418.227.1181 #2313 F 418.227.1188 www.boa-franc.com Yahoo! Groups Sponsor ADVERTISEMENT click here Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
