RE: [development-axapta] Printing Sales invoice
Hi all, Posted next is the Dx Harry and I had sometime ago on teh other group about this form sort (take care it only works for 'After' setting...read on). Hope it helps and of course if not then post back :) Dx from sometiem ago: Hey thanks alot Harry, That is why I could not get it to work! At least now I can get the sort to work rather than wonder whether it was some nice idea by some programmer that never quite got off the ground ;) 'After' I believe is strictly just the printout so your thoughts about a problem after a few have been processed, I don't think anything is done. >From my understanding 'After' is more for batch update over night but you dont wnat to send it to the printer as if the print jams or low toner etc there is noone there to check and so you could come back in the morning and find that you just wasted sheets and sheets of paper etc... Thanks alot for your time and input, really appreciate it (I dont think I would have got around to testing the 'after' ...more likely to have given up!!!) Thanks James -Original Message- From: Harry Deshpande [mailto:[EMAIL PROTECTED] Sent: Monday, August 09, 2004 7:50 AM To: development-axapta@yahoogroups.com Subject: RE: [development-axapta] Form sort used for what? Hi James First of all... if you want to apply a different sort order then you have to finger around with newJournalList method of class salesFormLetter_PickingList. Now to your question as to why this is not working for you... To be very honest, I did not try this out. However, I have a feeling as to why this is not working out for you. Axapta as two methods of printing the picking lists. First method is print pickinglist one by one as soon as they are processed. Represented by Printout=current on salesEditLinesForm. Second method is print pickinglists after they are processed. Represented by Printout = after on salesEditLinesForm. Obviously the sort will not work if Printout = current, since picking lists are being printed as soon as they are processed. I do not think you cannot change the value of printout manually. This can be changed in the update method of class salesformletter this.initParameters(salesParmUpdate, PrintOut::Current); // Printout I have not made a study of why this has been set as current in standard Axapta and the implications of setting printout to after. (for eg. If the picking list operations fails after processing 5 picking lists then whether the previous picking lists are reversed and if they are not reversed and there is a system failure then picking lists will not be printed etc etc.) However,in order for the formSort to work this value will have to be set to after. Another option which you may want to look at will be to change the order in which picking list are processed. Hope this helps Regards harry _ From: James Flavell [mailto:[EMAIL PROTECTED] Sent: Saturday, 7 August 2004 11:28 a.m. To: development-axapta@yahoogroups.com Subject: RE: [development-axapta] Form sort used for what? Thanks very much Harry, Your example situation is a very good one and one that had not really crossed my mind :) my situation is very similar in that I want to make sure the warehouse pick priority customer stock first and therefore want the picking instructions to appear in customer prioirty order. I would refer the pick instruction number to be assigned in this order as it is more full proof but if it cannot then the print out in that order is the next best thing. Can you tell me exactly what you set to get it to work and what you did to test it worked? Like I said I have v3.0 SP2 and have set a sort but dont seem to get the printouts in that order (did you print to screen or printer...although I believe I should still be able to see the effect on the screen...) Thank you James -Original Message- From: Harry Deshpande [mailto:[EMAIL PROTECTED] Sent: Friday, August 06, 2004 6:03 AM To: development-axapta@yahoogroups.com Subject: RE: [development-axapta] Form sort used for what? Hi The questions still unanswered are: 1) Is the sort applied before or after the invoice number is assigned? i.e. can this sort influence the number assigned to a journal or does it only come into effect after each journal has been created (strictly the prinout) ** The sort cannot influence the number assigned to the journal and the sort is applied after the invoice number is assigned. can actually get it to work and maybe who actually uses this in a real life situation and if so can you add your input please :) ** Ummm, I do not know anyone who has used it but I can guess of a scenario... accounts department prints all the invoices during the night and the clerk files the invoices in the morning. Now if the invoices are being filed in alphabetical order (customer code or name) then you would sort them on that field. If the invoices are being filed in the number sequence then you
[development-axapta] Day - Month field
Hi, i'm trying to create a field in a table that contains a Day - Month information. There's a way to do this (eg. an extended data type?) without split the two informations in a single field for each one? Thanks! Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] Re: direct sql problem again
Hi,
use a 2nd Statement object for the inner loop as shown below:
Connection Con = new Connection();
Statement Stmt = Con.createStatement();
//### STMT2
Statement Stmt2 = Con.createStatement();
//### STMT2
ResultSet R,R1;
sql ='SELECT ACCOUNTNUM,ACCOUNTNAME,ACCOUNTPLTYPE,RECID FROM
LEDGERTABLE WHERE ACCOUNTNUM = \'699\'ORDER BY ACCOUNTNUM';
R=Stmt.executeQuery(sql);
while (R.next())
{
acno1=R.getString(1);
i = R.getInt(3);
k= R.getString(4);
if(strlen(acno1)==3)
{
if(i==LedgerAccountType::sum)
{
sql = 'SELECT FROMACCOUNT,TOACCOUNT FROM
LEDGERTABLEINTERVAL WHERE ACCOUNTTABLEID ='+_tableId+' AND
ACCOUNTRECID = '+k+'';
//### STMT2
R1 = Stmt2.executeQuery(sql);
//### STMT2
while(R1.next())
{
print R1.getString(1),' ',R1.getString(2),' ',k;
pause;
}
}
else
{
//bl.
}
}acno1
} ledgertable2
it just takes the first value from the second resultset and then go
out of the loop.
Regards,
Onno
Yahoo! Groups Sponsor
ADVERTISEMENT
Yahoo! Groups Links
To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/
To unsubscribe from this group, send an email to:[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [development-axapta] AOS Client Error
Hi All, does everybody have step by step installation server with AOS and client configuration to connect AOS ? please i need resolution. because some time i connect to AOS trough client doesn't connect. i dont know why ? thanks for your attention. best regards Chievaz --- In development-axapta@yahoogroups.com, Andrae, Tobias [EMAIL PROTECTED] wrote: use the client's directory as application directory for your client (e.g. c:\axapta\client) hth Tobias -Ursprüngliche Nachricht- Von: chievaz_regalz [mailto:[EMAIL PROTECTED] Gesendet: Do 03.03.2005 04:31 An: development-axapta@yahoogroups.com Cc: Betreff: *SPAM* [development-axapta] AOS Client Error Hai All, I need help ... I try to connect axapta client with AOS server. but everytime login i get error in illegal directory structure for axapta application. then i map axapta application directory from server to server \\servername\axapta application. thats get axapta run well with AOS configuration. this mean that configuration same as with 2 tier configuration, WHY ??. i need connect with 3 tier configuration, so user doesn't need to map axapta application directory from server. i need resolution .. thanks for your attention. chievaz regalz Yahoo! Groups Links [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [development-axapta] Re: direct sql problem again
thanks it worked.
onnobid [EMAIL PROTECTED] wrote:
Hi,
use a 2nd Statement object for the inner loop as shown below:
Connection Con = new Connection();
Statement Stmt = Con.createStatement();
//### STMT2
Statement Stmt2 = Con.createStatement();
//### STMT2
ResultSet R,R1;
sql ='SELECT ACCOUNTNUM,ACCOUNTNAME,ACCOUNTPLTYPE,RECID FROM
LEDGERTABLE WHERE ACCOUNTNUM = \'699\'ORDER BY ACCOUNTNUM';
R=Stmt.executeQuery(sql);
while (R.next())
{
acno1=R.getString(1);
i = R.getInt(3);
k= R.getString(4);
if(strlen(acno1)==3)
{
if(i==LedgerAccountType::sum)
{
sql = 'SELECT FROMACCOUNT,TOACCOUNT FROM
LEDGERTABLEINTERVAL WHERE ACCOUNTTABLEID ='+_tableId+' AND
ACCOUNTRECID = '+k+'';
//### STMT2
R1 = Stmt2.executeQuery(sql);
//### STMT2
while(R1.next())
{
print R1.getString(1),' ',R1.getString(2),' ',k;
pause;
}
}
else
{
//bl.
}
}acno1
} ledgertable2
it just takes the first value from the second resultset and then go
out of the loop.
Regards,
Onno
Yahoo! Groups SponsorADVERTISEMENT
-
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
-
Celebrate Yahoo!'s 10th Birthday!
Yahoo! Netrospective: 100 Moments of the Web
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
Yahoo! Groups Links
To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/
To unsubscribe from this group, send an email to:[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [development-axapta] Type of selected datagrid fields.
Sorry, of course you should then use enum2str(df.basetype()) instead of df.type John da_man812000 [EMAIL PROTECTED] wrote: Hi group! I have a problem, can I recognized selected field type from a datagrid where I only have fieldid and tableid. I have already tried to use typeof(anytype object) function, but I don't have the physical table object and field. Is this right way? Yahoo! Groups SponsorADVERTISEMENT - Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - Gesendet von Yahoo! Mail - Jetzt mit 250MB kostenlosem Speicher [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] Outer join in X++
Hi all,
I am trying to design a query in X++ which works in SQL. The SQL version is:
SELECT ADDRESS.*, CUSTTABLE.*
FROM CUSTTABLE LEFT OUTER JOIN ADDRESS
ON CUSTTABLE.RECID = ADDRESS.ADDRRECID
WHERE (ADDRESS.ADDRTABLEID = 77) AND
(CUSTTABLE.MODIFIEDDATE CONVERT(DATETIME, '2005-03-01
00:00:00', 102)) AND
(ADDRESS.ADDRESSTYPE = 'Invoice')
Which returns a single row. I am trying to use the following in X++ and it
returns every row:
while select custTable outer join address
where (address.AddrTableId == tableNum(CustTable)
address.AddrRecId == custTable.RecId)
(address.AddressType == Invoice)
(custTable.modifiedDate sinceDate ||
address.modifiedDate sinceDate)
{ //do stuff with adddress and custTable }
I can't seem to find the equivalent of the 'on' keyword in X++, how would I
achieve this? I don't want to manually go through each custTable record and
do the check in X++, I would rather let the DB do the work.
Thanks,
Matt Benic
Axapta and .Net Developer
UTi Sun Couriers Division
The universal aptitude for ineptitude
makes any human accomplishment an incredible miracle.
- Col. John P. Stapp
www.smallfrymobile.com
Yahoo! Groups Sponsor
ADVERTISEMENT
Yahoo! Groups Links
To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/
To unsubscribe from this group, send an email to:[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] Re: Outer join in X++
Hi Matt,
I think this should work.
while SELECT CUSTTABLE
WHERE (ADDRESS.ADDRTABLEID == 77)
(CUSTTABLE.MODIFIEDDATE mkdate(1, 3, 2005))
OUTER JOIN ADDRESS
where CUSTTABLE.RECID == ADDRESS.ADDRRECID
ADDRESS.ADDRESSTYPE == 'Invoice'
Axapta works different with joins.
First you define your where clause for the main table and after
your join you specify an extra where with your join specifications.
So the 2nd where is your on keyword.
I searched for outer join in classes to get an example from Axapta.
Regards,
Nico
--- In development-axapta@yahoogroups.com, Matt Benic [EMAIL PROTECTED]
wrote:
Hi all,
I am trying to design a query in X++ which works in SQL. The SQL
version is:
SELECT ADDRESS.*, CUSTTABLE.*
FROM CUSTTABLE LEFT OUTER JOIN ADDRESS
ON CUSTTABLE.RECID = ADDRESS.ADDRRECID
WHERE (ADDRESS.ADDRTABLEID = 77) AND
(CUSTTABLE.MODIFIEDDATE CONVERT(DATETIME, '2005-
03-01
00:00:00', 102)) AND
(ADDRESS.ADDRESSTYPE = 'Invoice')
Which returns a single row. I am trying to use the following in X++
and it
returns every row:
while select custTable outer join address
where (address.AddrTableId == tableNum(CustTable)
address.AddrRecId == custTable.RecId)
(address.AddressType == Invoice)
(custTable.modifiedDate sinceDate ||
address.modifiedDate sinceDate)
{ //do stuff with adddress and custTable }
I can't seem to find the equivalent of the 'on' keyword in X++, how
would I
achieve this? I don't want to manually go through each custTable
record and
do the check in X++, I would rather let the DB do the work.
Thanks,
Matt Benic
Axapta and .Net Developer
UTi Sun Couriers Division
The universal aptitude for ineptitude
makes any human accomplishment an incredible miracle.
- Col. John P. Stapp
www.smallfrymobile.com
Yahoo! Groups Sponsor
ADVERTISEMENT
Yahoo! Groups Links
To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/
To unsubscribe from this group, send an email to:[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] creation of extended data type and base enum
Hi There, Does anyone knows how to create extended data type and append base enum by using codes? Please help me. Actually i have a problem with filteration, and i really this solution to make it work. Thank you Regards, Rozie SMILE __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [development-axapta] Type of selected datagrid fields.
Sorry, but of course youe should use df.basType() to get the type of your field. John Hans-Walter Bous [EMAIL PROTECTED] wrote: Hi, try something like this: DictTable dt = new Dicttable(tableid); DictField df = new DictField(dt.id(), fieldId); ; df.type will return you the type of the field as enum (TYPES). So enum2Value(df.type()) will give you the text of the type. Best wishes John da_man812000 [EMAIL PROTECTED] wrote: Hi group! I have a problem, can I recognized selected field type from a datagrid where I only have fieldid and tableid. I have already tried to use typeof(anytype object) function, but I don't have the physical table object and field. Is this right way? Yahoo! Groups SponsorADVERTISEMENT - Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - Gesendet von Yahoo! Mail - Jetzt mit 250MB kostenlosem Speicher [Non-text portions of this message have been removed] Yahoo! Groups SponsorADVERTISEMENT - Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - Gesendet von Yahoo! Mail - Jetzt mit 250MB kostenlosem Speicher [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] Adding new field to inventrans and getting it populated
Hi I would like to know what I need to do to add a new field to the inventrans and to get this field populated. I have a customer PO number that ends up being many Axapta sales orders and this PO number is very importnat for the my client to review inventory movements. I could use the batch number inventory dimension to record this PO number but dont think this is the best approach so I want to mkae a new field on the inventtrans and get this field copied from the sales order down to the inventtrans. Is this the best/correct way? If so can I just add the field (same name as sales order) and put it in one of the field groups and the system will take care of the rest (me dreaming?) or do I have to change a lot of code to get inventrans correctly populated? Is my appraoch advised/difficult? Thanks James [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [development-axapta] Re: Outer join in X++
Thanks, but the problem is that I want to select from custtable and address
if either of the two have been changed, not just if custtable has been
changed, so if I limit the custtable select before doing the join, I cut out
the cases where the address has changed but the custtable has not..
Regards,
Matt Benic
Axapta and .Net Developer
UTi Sun Couriers Division
The universal aptitude for ineptitude
makes any human accomplishment an incredible miracle.
- Col. John P. Stapp
www.smallfrymobile.com http://www.smallfrymobile.com
-Original Message-
From: nicolaan [mailto:[EMAIL PROTECTED]
Sent: 09 March 2005 05:17 PM
To: development-axapta@yahoogroups.com
Subject: [development-axapta] Re: Outer join in X++
Hi Matt,
I think this should work.
while SELECT CUSTTABLE
WHERE (ADDRESS.ADDRTABLEID == 77)
(CUSTTABLE.MODIFIEDDATE mkdate(1, 3, 2005))
OUTER JOIN ADDRESS
where CUSTTABLE.RECID == ADDRESS.ADDRRECID
ADDRESS.ADDRESSTYPE == 'Invoice'
Axapta works different with joins.
First you define your where clause for the main table and after
your join you specify an extra where with your join specifications.
So the 2nd where is your on keyword.
I searched for outer join in classes to get an example from Axapta.
Regards,
Nico
--- In development-axapta@yahoogroups.com, Matt Benic [EMAIL PROTECTED]
wrote:
Hi all,
I am trying to design a query in X++ which works in SQL. The SQL
version is:
SELECT ADDRESS.*, CUSTTABLE.*
FROM CUSTTABLE LEFT OUTER JOIN ADDRESS
ON CUSTTABLE.RECID = ADDRESS.ADDRRECID
WHERE (ADDRESS.ADDRTABLEID = 77) AND
(CUSTTABLE.MODIFIEDDATE CONVERT(DATETIME, '2005-
03-01
00:00:00', 102)) AND
(ADDRESS.ADDRESSTYPE = 'Invoice')
Which returns a single row. I am trying to use the following in X++
and it
returns every row:
while select custTable outer join address
where (address.AddrTableId == tableNum(CustTable)
address.AddrRecId == custTable.RecId)
(address.AddressType == Invoice)
(custTable.modifiedDate sinceDate ||
address.modifiedDate sinceDate)
{ //do stuff with adddress and custTable }
I can't seem to find the equivalent of the 'on' keyword in X++, how
would I
achieve this? I don't want to manually go through each custTable
record and
do the check in X++, I would rather let the DB do the work.
Thanks,
Matt Benic
Axapta and .Net Developer
UTi Sun Couriers Division
The universal aptitude for ineptitude
makes any human accomplishment an incredible miracle.
- Col. John P. Stapp
www.smallfrymobile.com
Yahoo! Groups Links
Yahoo! Groups Sponsor
ADVERTISEMENT
Yahoo! Groups Links
To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/
To unsubscribe from this group, send an email to:[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
AW: [development-axapta] Day - Month field
Hi, just create an extended data type of the type date and set the property dateYear to year not shown. Use this in your table ;-) hth Tobias -Ursprüngliche Nachricht- Von: gennarociulla [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 9. März 2005 10:03 An: development-axapta@yahoogroups.com Betreff: [development-axapta] Day - Month field Hi, i'm trying to create a field in a table that contains a Day - Month information. There's a way to do this (eg. an extended data type?) without split the two informations in a single field for each one? Thanks! Yahoo! Groups Links -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.0 - Release Date: 08.03.2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.0 - Release Date: 08.03.2005 Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
