Re: [Axapta-Knowledge-Village] Re: Document grouping conditions
Actually, AX4.0/SP1, the display menu item for this is SalesFormLetterSortingParameters and the form name is SalesFormLetterSortingParameters and actually it has security key custsetup... AOT path = Cust - Setup - Form - Sort Probably I might be looking differently from what you are looking??? Steeve Gilbert [EMAIL PROTECTED] wrote: I still don't know where this is hidden in the main menu but I've found the form. What I was looking for is : SalesSummaryParameters. Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, Jens Strandberg [EMAIL PROTECTED] wrote: Steeve, I believe that you are looking for Sales Ledger + Setup + Forms; Form sorting ... /Jens _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steeve Gilbert Sent: Monday, December 03, 2007 11:11 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Document grouping conditions I'm looking for the form where you can setup the criteria that decide how a customer document (Picking list, packing slip, invoice) is grouped. By this I mean : If I select 100 orders and try to validate the PackingSlip, Axapta will group them by customer id, shipping address, etc... I'm looking for the form where I setup those condition (customer id, shipping address). If I remember correctly, the form has a tab for each document and in each of them you find 2 list with arrow between them so you can activate a condition or not. I can never manage to remember where this is hidden. If anyone can tell me where I could find that form, that'd be nice. Thanks! [Non-text portions of this message have been removed] - Be a better pen pal. Text or chat with friends inside Yahoo! Mail. See how. [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Re: File permissions
ok. where is the report running ( Menuitem for that report - runon property ).
is that on client or on server or calledfrom?
hint#1: if it is set to server, Can you change the return type from void to
client static void...see if that helps...
I am thinking that the code is set to run on server and the file you are
entering is 'Viewed' as on server in stead of your local path...
if hint#1 does not help, pls try to change the report runon to 'calledfrom'
or client. then it should work..
paulinavk [EMAIL PROTECTED] wrote:
It is a void method called from within the fetch method of a report
based on the tutorial_RunbaseReportStd. The file name is entered
via a dialog with the dialog field type as filenameopen. The file I
am trying to overwrite has full control attributes.
Paulina
--- In Axapta-Knowledge-
[EMAIL PROTECTED], Subrahmanyam,Mamidi [EMAIL PROTECTED] wrote:
umm ok.
Can you please tell me the return mode of method where this code
was written?.
is that client static , static or void method?.
I am assuming that file name and file paths are correct..
paulinavk [EMAIL PROTECTED] wrote:
Thanks for your help. I added the fileIOPermission.demand
(); but it
doesn't make any difference. I am running via terminal server. I
assumed I would be running it off the client and the file is
located
in the my Documents folder.
Do you think it's to do with terminal server?
P.
--- In Axapta-Knowledge-Village@yahoogroups.com, Subbu
subbu_oh@ wrote:
Hi there,
Can you make sure to include the below
fileIOPermission = new FileIOPermission(mstrExportPath, 'w');
fileIOPermission.assert();
fileIOPermission.demand();
And also is this error you are getting when u run it on client
or
on
server?
And also where is the file located?. in the local or off of the
server?.
Yes. in Ax4.0 there is a code security feature. same applies
for
ODBC connection too
Kind regards,
Subbu
--- In Axapta-Knowledge-Village@yahoogroups.com, paulinavk
belforte@ wrote:
Hi again, I'm still having trouble with my file permissions, I
had
no trouble in v3.2 but the permission thing has me stumped in
v4
(sp2).
This is the code I have and I get an error in the info log
saying
file permission was not granted and of course the commaio file
is
always null so I dont get to the write. Where have I gone
wrong?
Paulina.
FileIOpermission permission;
CommaIO commaFile;
str Contents;
permission = new FileIOpermission(inputCSV,r);
if (permission == null)
throw error(permission not granted);
permission.assert();
Contents = check this out;
commaFile = new CommaIO(inputCSV,W+);
if (CommaFile != null)
{
commaFile.write(contents);
}
CodeAccessPermission::revertAssert();
}
-
Never miss a thing. Make Yahoo your homepage.
[Non-text portions of this message have been removed]
-
Be a better pen pal. Text or chat with friends inside Yahoo! Mail. See how.
[Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Re: File permissions
Hi Mike,
I think I am aware of this document. Its good to secure the code though. May
be it was incliuded in Ax4.0 because of Auditing/Security compliance.
Paulina might have set his menuitem to run on server and hence he is not able
to see the file (path) ... I think he has to either bind this to run on client
for this method or set the menu item as calledfrom or client
Kind regards,
Subbu
OneNeck IT services.
Michael Fruergaard Pontoppidan [EMAIL PROTECTED] wrote:
For more information on this feature :) see
http://www.microsoft.com/downloads/details.aspx?FamilyID=5e050494-1613-4b3a-9363-d69d60c56877DisplayLang=en
Michael
From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On
Behalf Of Subrahmanyam,Mamidi
Sent: 27. november 2007 17:40
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] Re: File permissions
ok. where is the report running ( Menuitem for that report - runon property ).
is that on client or on server or calledfrom?
hint#1: if it is set to server, Can you change the return type from void to
client static void...see if that helps...
I am thinking that the code is set to run on server and the file you are
entering is 'Viewed' as on server in stead of your local path...
if hint#1 does not help, pls try to change the report runon to 'calledfrom' or
client. then it should work..
paulinavk [EMAIL PROTECTED]mailto:belforte%40paradise.net.nz wrote:
It is a void method called from within the fetch method of a report
based on the tutorial_RunbaseReportStd. The file name is entered
via a dialog with the dialog field type as filenameopen. The file I
am trying to overwrite has full control attributes.
Paulina
--- In Axapta-Knowledge-
[EMAIL PROTECTED]mailto:Village%40yahoogroups.com, Subrahmanyam,Mamidi
[EMAIL PROTECTED] wrote:
umm ok.
Can you please tell me the return mode of method where this code
was written?.
is that client static , static or void method?.
I am assuming that file name and file paths are correct..
paulinavk [EMAIL PROTECTED] wrote:
Thanks for your help. I added the fileIOPermission.demand
(); but it
doesn't make any difference. I am running via terminal server. I
assumed I would be running it off the client and the file is
located
in the my Documents folder.
Do you think it's to do with terminal server?
P.
--- In
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com,
Subbu
subbu_oh@ wrote:
Hi there,
Can you make sure to include the below
fileIOPermission = new FileIOPermission(mstrExportPath, 'w');
fileIOPermission.assert();
fileIOPermission.demand();
And also is this error you are getting when u run it on client
or
on
server?
And also where is the file located?. in the local or off of the
server?.
Yes. in Ax4.0 there is a code security feature. same applies
for
ODBC connection too
Kind regards,
Subbu
--- In
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com,
paulinavk
belforte@ wrote:
Hi again, I'm still having trouble with my file permissions, I
had
no trouble in v3.2 but the permission thing has me stumped in
v4
(sp2).
This is the code I have and I get an error in the info log
saying
file permission was not granted and of course the commaio file
is
always null so I dont get to the write. Where have I gone
wrong?
Paulina.
FileIOpermission permission;
CommaIO commaFile;
str Contents;
permission = new FileIOpermission(inputCSV,r);
if (permission == null)
throw error(permission not granted);
permission.assert();
Contents = check this out;
commaFile = new CommaIO(inputCSV,W+);
if (CommaFile != null)
{
commaFile.write(contents);
}
CodeAccessPermission::revertAssert();
}
-
Never miss a thing. Make Yahoo your homepage.
[Non-text portions of this message have been removed]
-
Be a better pen pal. Text or chat with friends inside Yahoo! Mail. See how.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
-
Get easy, one-click access to your favorites. Make Yahoo! your homepage.
[Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Re: File permissions
umm ok.
Can you please tell me the return mode of method where this code was written?.
is that client static , static or void method?.
I am assuming that file name and file paths are correct..
paulinavk [EMAIL PROTECTED] wrote:
Thanks for your help. I added the fileIOPermission.demand(); but it
doesn't make any difference. I am running via terminal server. I
assumed I would be running it off the client and the file is located
in the my Documents folder.
Do you think it's to do with terminal server?
P.
--- In Axapta-Knowledge-Village@yahoogroups.com, Subbu
[EMAIL PROTECTED] wrote:
Hi there,
Can you make sure to include the below
fileIOPermission = new FileIOPermission(mstrExportPath, 'w');
fileIOPermission.assert();
fileIOPermission.demand();
And also is this error you are getting when u run it on client or
on
server?
And also where is the file located?. in the local or off of the
server?.
Yes. in Ax4.0 there is a code security feature. same applies for
ODBC connection too
Kind regards,
Subbu
--- In Axapta-Knowledge-Village@yahoogroups.com, paulinavk
belforte@ wrote:
Hi again, I'm still having trouble with my file permissions, I
had
no trouble in v3.2 but the permission thing has me stumped in v4
(sp2).
This is the code I have and I get an error in the info log
saying
file permission was not granted and of course the commaio file
is
always null so I dont get to the write. Where have I gone wrong?
Paulina.
FileIOpermission permission;
CommaIO commaFile;
str Contents;
permission = new FileIOpermission(inputCSV,r);
if (permission == null)
throw error(permission not granted);
permission.assert();
Contents = check this out;
commaFile = new CommaIO(inputCSV,W+);
if (CommaFile != null)
{
commaFile.write(contents);
}
CodeAccessPermission::revertAssert();
}
-
Never miss a thing. Make Yahoo your homepage.
[Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Re: File permissions
and also,
may be as a test, you can keep the file in your local directory on the
terminal service and see what happens...I am sure you might have tried.. I had
this issue some time back..but I remeber I had to change the runtype property
to get rid of this error...and also if the same code when I kept in a batch
mode, I too had some issues and again I had to change the return type paramters
to forcefully bind to local..
Subrahmanyam,Mamidi [EMAIL PROTECTED] wrote:
umm ok.
Can you please tell me the return mode of method where this code was written?.
is that client static , static or void method?.
I am assuming that file name and file paths are correct..
paulinavk [EMAIL PROTECTED] wrote:
Thanks for your help. I added the fileIOPermission.demand(); but it
doesn't make any difference. I am running via terminal server. I
assumed I would be running it off the client and the file is located
in the my Documents folder.
Do you think it's to do with terminal server?
P.
--- In Axapta-Knowledge-Village@yahoogroups.com, Subbu
[EMAIL PROTECTED] wrote:
Hi there,
Can you make sure to include the below
fileIOPermission = new FileIOPermission(mstrExportPath, 'w');
fileIOPermission.assert();
fileIOPermission.demand();
And also is this error you are getting when u run it on client or
on
server?
And also where is the file located?. in the local or off of the
server?.
Yes. in Ax4.0 there is a code security feature. same applies for
ODBC connection too
Kind regards,
Subbu
--- In Axapta-Knowledge-Village@yahoogroups.com, paulinavk
belforte@ wrote:
Hi again, I'm still having trouble with my file permissions, I
had
no trouble in v3.2 but the permission thing has me stumped in v4
(sp2).
This is the code I have and I get an error in the info log
saying
file permission was not granted and of course the commaio file
is
always null so I dont get to the write. Where have I gone wrong?
Paulina.
FileIOpermission permission;
CommaIO commaFile;
str Contents;
permission = new FileIOpermission(inputCSV,r);
if (permission == null)
throw error(permission not granted);
permission.assert();
Contents = check this out;
commaFile = new CommaIO(inputCSV,W+);
if (CommaFile != null)
{
commaFile.write(contents);
}
CodeAccessPermission::revertAssert();
}
-
Never miss a thing. Make Yahoo your homepage.
[Non-text portions of this message have been removed]
-
Never miss a thing. Make Yahoo your homepage.
[Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Re: Files and file readers
static void ExtUpdate210(Args _args)
{
ExtCodevalueTable extTableValue;
AsciiIO file ;
container fields;
int p;
ItemId itemid;
InventTable invTable;
;
file = new AsciiIo(C:\\FS\\SRI\\2.txt,R);
file.inFieldDelimiter('\t'); // tab seperated
file.inRecordDelimiter('\r\n');
ttsbegin;
while(true)
{
fields = file.read();
if(!conpeek(fields,1))
break;
p = p+1;
itemid = conpeek(fields,1);
invTable = InventTable::find(itemid);
select forupdate extTableValue where extTableValue.ExtCodeRelationTableId
== 175
extTableValue.ExtCodeRelationRecId == invTable.RecId;
if(extTableValue.RecId)
{
extTableValue.ExtCodeValue = itemid;
extTableValue.ExtCodeValueAlias = itemid;
extTableValue.doUpdate();
}
}
ttscommit;
}
ricardodegouveia [EMAIL PROTECTED] wrote:
I tried to run this code but AX just hangs
static void Job2(Args _args)
{
#file
TextIo file = new TextIo('C:\\Sample Data Test
2.txt',#io_read);
Container data;
int i;
;
file.inFieldDelimiter('\t');
if(file)
{
while(file.status() == IO_Status::Ok)
{
for(i = 1;i=conlen(data);i++)
{
info(any2str(conpeek(data,i)));
}
}
}
}
Can anyone see the problem?
--- In Axapta-Knowledge-Village@yahoogroups.com, Arijit Basu
[EMAIL PROTECTED] wrote:
Hi Ricardo,
My friend *Harish Mohanbabu (MVP - AX)* has some related code in
his blog.
http://www.harishm.com/Navision/Code.html
Hope it helps
Arijit Basu
http://daxguy.blogspot.com/
On 11/20/07, ricardodegouveia [EMAIL PROTECTED] wrote:
Hi i have a text file which contains results that i want to
upload into
a table in Dynamics AX? Any advice to this? Are the file readers
in AX
and if so does anyone have a coded example of reading a text file
into
an AX table?
Thanking you in advance,
Ricardo
--
Arijit Basu
[Non-text portions of this message have been removed]
-
Be a better sports nut! Let your teams follow you with Yahoo Mobile. Try it now.
[Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Release COM object
Hi Steeve,
I am not a C# developer. But I am not sure if you have used as i used to do
in C++
if(MyCom)
{
myCom.Close();
myCom = NULL;
}
the bove code should decrement the pointer to the object's handle.
good luck,
Subbu
Steeve Gilbert [EMAIL PROTECTED] wrote:
Hi guys,
I would like to know how to release a COM (as in Component Object
Model) correctly.
I've created a .NET COM dll with VS2005 that I use in Ax3.0 SP3. When
I use the COM in Axapta, it doesn't release reference to the COM until
I close Axapta. So when I make modification to my dll and rebuild it,
VS can't recreate the dll stating that the file is in use.
To release the COM, so far i've tried :
myCom.finalize();
myCom.detach();
myCom = null;
But no success. Any idea?
__
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]
Re: [Axapta-Knowledge-Village] Axapta training
Hi Laxman/Varden, All what I am doing is just - advising Tajudeen to check the credentials of the trainer/institution. I KNOW how the most training instituions work in India. FYI, I was trained from MS guys, USA. I just felt little fishy/pushy when Ashwathi said They are ready to provide and undertake training related for axapta 4.0 also. 4.0 is just couple of months old. Again, tajudden as i said 'if the trainer is so trained o train you, he wont be sitting in the training institute'. They normally quarentee you the placement, obviously end up the tutor for the next batch...just kidding... As I informed I am just advising Tajudeen to get trained from MS partners. We wish Tajudeen good luck and welcome to Axapta and I feel its better not to scare tajudeen further. We can stop here unless Ashwathi declaress the Instituion,. -Subbu MS double Certifed Master Varden Morris [EMAIL PROTECTED] wrote: My honest opinion on this is that I believe that training in Dynamics AX is great in giving you a jump start. What you get out of the training can be dependent on several factors. The more practical experience you have the better it will be, plus the way how the instructor delivers the course. I realize that teaching is an art that some people do a great job at while others do not. Personally, I have gone to one instructor lead training and it was a great jump start, but it was only a fraction of what needed to pass the exam. The majority of the preparation for the exam came from my practical experience. It took me three tries to pass that exam. I took about three months after the second try and went back through the hard to understand course materials. During my practices it came to me and I passed the exam hands down on the third try. I have also passed other MBS exams without instructor lead training. I purchase or acquire the material from MCTs in organizations that I have worked. I install the software and practice from it. For one of the exams it took me three tries to pass, same as when I did the instructor lead course. For another it took me one shot as a result of my experience in that area. This can take a few months but it worth the practice to ensure that you will be prepared to deal with real life situations on the job. It also takes a lot of discipline and determination to get this done. In saying all of this, I believe that instructor lead courses that are properly delivered are great in helping people to understand what is expected of them, and a lot is also dependent on practical experience. I have personally lead a number training and I realize that mentorship can be a big help as people go off on there own and questions start coming to their heads. Varden Morris 85 Saddleland Close N.E. Calgary, Alberta T3J 5J5 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] - Original Message From: meena lakshmanan [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Saturday, February 24, 2007 9:49:49 PM Subject: Re: [Axapta-Knowledge-Village] Axapta training Hi Subbu, I have gone through your comments regarding training. I strongly advise you that you don't discourage others to take training from MS learning solutions competency partners. May be in US, you do not find any trusted source for training or I do not know how you have got succeeded either by having gone through the manuals or some other source which I am not supposed to tell since it may not be good for you. Moreover, I am of the opinion, no body can get certified if he or she has not undergone training provided by the MS partner wherein the students courseware and intensive lab training will be provided as per the guidelines of Microsoft.As per your advise ie., studying manual alone, no body will get succeed and will not have a exposure to application part which is most important. Financial series alone will comprise of General Ledger, Accounts Receivable, Accounts Payable and Fixed Assets which require extensive lab training and by looking at the manual ( As per your advise ), he may get succeed only if he has got practical knowledge of applying all the parameters etc., Even if he gets certified by studying manual and/or through some other source, he may find difficulty once he gets offer based on the ceritification. This is for your information, please and also I strongly advise all the one who want to be axapta professional to take training in MS Learning Solutions Competency Partners who are specialised in giving training for Microsoft Dynamics - AX. Regards, Lakshmanan. --- Subrahmanyam, Mamidi [EMAIL PROTECTED] com wrote: Hi Tajudeen, I stringly advise to get the training from MS or from a local MS partner in India. Dont get fooled by some money milking guys in Inida. I know how it works in Training centers in India. The logic is very simple. if the trainer is so trainined
Re: [Axapta-Knowledge-Village] Axapta training
Hi Tajudeen, I stringly advise to get the training from MS or from a local MS partner in India. Dont get fooled by some money milking guys in Inida. I know how it works in Training centers in India. The logic is very simple. if the trainer is so trainined to train you, he wont be sitting there to train you for 10 to 20K INR (salary) in the training company. He would be better working in the implemetations for companies. Trust me, if it rains in US ( software boom) , all the one man armed (some uneducated too) training companies open shelters or umbrellas ( Training centers ) and corrupt the system. I dont have anything aginst in bangalore/hyderabad/chennai. I am from Indai too. So giving a hint to watch out the outcome fr your money. if you read the manuals for 2 monhs , anybody can get certifed :-). So get trained from MS educational institution. I never watsed my money in india. My 2 US cents. Thanks Regards, subbu Double Certified Axapta Master ( Both tech and functional ) tajudeen M.A [EMAIL PROTECTED] wrote: DearAshwathi We need training for General ledger, account payabale,account receiveable,inventory management and SCM and master planning Regards M.A.Tajudeen --- ashwathi_123 [EMAIL PROTECTED] wrote: they are ready to provide and undertake training realted for axapta 4.o also. pl inform your requirement(which module,). regards ashwathi __ Sucker-punch spam with award-winning protection. Try the free Yahoo! Mail Beta. http://advision.webevents.yahoo.com/mailbeta/features_spam.html - Food fight? Enjoy some healthy debate in the Yahoo! Answers Food Drink QA. [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Re: Stop field displaying default value
Ok. We have a mod over there#2 is the way anyway :-). ignore my earlier email if u r using std axapta Subbu [EMAIL PROTECTED] wrote: Hello hang on, I have looked at the code and its getting defaulted from the salesupdate paramters.. so, dont make any modifications unnescessarily AR - Setup - Paramters - shipments - bill of landing and find out the frieght charge terms and wipe that out if you dont want that And also, in future if you want o code also, its always recommended do at the class member/methods intilization level... Good luck, subbu --- In Axapta-Knowledge-Village@yahoogroups.com, bobchamp5 [EMAIL PROTECTED] wrote: Thank you Brandon for the quick response and detailed explanation. That helps alot. Thanks Bob --- In Axapta-Knowledge-Village@yahoogroups.com, Brandon George Brandon.George@ wrote: Bob, Couple of ways to do this: 1.) Change the Base Enum so the first value is blank. [Not Recommended] 2.) Create New Base Enum, that is the same as old, except with blank and change the field to extend from that one. [Ok] a.) Add code that would check on ValidateWrite() to see if blank is selected and if so do not allow write, and throw error 3.) If PREPAID is not a valid option for you at all, change the Text value / label for that enum element to DO NOT USE [something like that], and add code to check and throw error if used. [50/50] If I were to do it, I would do number (2) but then you have to realize that you are modifying this, document it, so that on upgrades you make sure this gets carried over. thanks, J. Brandon George Senior Technical Architect Sunrise Technologies, Inc. http://www.sunriseconsult.com Cell: 706-412-7726 Office: 336-722-6741 http://www.sunriseconsult.com/ http://www.sunriseconsult.com/ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of bobchamp5 Sent: Monday, January 29, 2007 2:14 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Stop field displaying default value I am trying stop the Freight Charge Terms field under Bill of Lading from defaulting to PREPAID when form is opened, which is the first value in the enum associated with this field. How can I change this to leave the field blank and force the user to drop down and select one of the choices. I thought this would be an easy fix, but I cant figure this out. Thanks Bob [Non-text portions of this message have been removed] - Be a PS3 game guru. Get your game face on with the latest PS3 news and previews at Yahoo! Games. [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] UtilElements error
Hi James, I smell that your layer file got corrupted looks like... I would suggest the following 1. Find a backup of the application folder, and restoring the backup (or at least the layer file -- axZZZ.aod where ZZZ is the layer where the problem is). Once the layer file has been replaced, remove the AXAPD.AOI file again, and restart in 2 tier mode to get everything rebuilt 2. And try to touch the UtilElements table I feel this should resolve the issue please let us know your exp. Thanks Regadrs, Subbu Double Certified Axapta Master James Flavell [EMAIL PROTECTED] wrote: This table is not in SQL as far as I know (I checked and could not find it) .. its a system table Thanks James -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 27 January 2007 23:48 To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] UtilElements error James, Can't you delete it from whithin SQL? - Oorspronkelijk bericht - Van: James Flavell [mailto:[EMAIL PROTECTED] Verzonden: zaterdag, januari 27, 2007 04:16 AM Aan: Axapta-Knowledge-Village@yahoogroups.com Onderwerp: [Axapta-Knowledge-Village] UtilElements error Hi everyone, I have a 'corrupt' UtilElelemtns record such that the element InventCostListTrans is appearing in the USR layer although it has never been changed. This causes Axapta to crash whenever this element is touched in the AOT. Previously I have been able to correct such errors by deleting the record in UtilElements but this time the error message appears: Cannot delete a record in UtilElements The record number does not comply with the original number Can anyone help explain or provide a way to delete this record. Thanks James [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Come and choose your preferred name for Microsoft Dynamics AX on the Axapta Knowledge Village, Visit www.axapta-knowledge-village.tk Yahoo! Groups Links - Finding fabulous fares is fun. Let Yahoo! FareChase search your favorite travel sites to find flight and hotel bargains. [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Help me out!
hi pankaj_dbc, please post your code so that you will be helped -subbu Brandon George [EMAIL PROTECTED] wrote: I have never tried this before, but you might be able to build a query from a query. So for example: Query1 = Order By DataSet Query2 = Built from Query 1, Group by the DataSet I also thought you could Order and Group By within X++ SQL Statements... thanks, J. Brandon George Senior Technical Architect Sunrise Technologies, Inc. http://www.sunriseconsult.com Cell: 706-412-7726 Office: 336-722-6741 http://www.sunriseconsult.com/ http://www.sunriseconsult.com/ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of pankaj_dbc Sent: Thursday, January 25, 2007 12:46 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Help me out! In one of my reports I need to sort one of my field in ascending order, I have already used the group by clause in my select query so it is not allowing me to use the order by clause along with that. Can anybody suggest me anyway to do it. [Non-text portions of this message have been removed] - Everyone is raving about the all-new Yahoo! Mail beta. [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Re: Production closing error: Quantity ordered may not be reduced, as there are
Hi, I am not sure if you have already solved this. Can you please check the InventTransID of the problemed Line, to see if that exists in inventTrans table with status 'Onorder' and the same line exits in InventJournalTrans table?. I beleive the journal posting is incomplete/errored/messed up and didnget updated properly. or if are a techy guy, you might want to put in a debug point near and around Inventmovement / upd classes/subclasses to see where irs erroring out. Good Luck, Subbu 1 less for double master. futzawm [EMAIL PROTECTED] wrote: Hi Harry, thanks for the response. I can't find the line in any of the BoM journals (there isn't a BoM journal associated with that particular production which has not been registered). So just to be sure, would the line in the database you mention be the line in the 'InventTrans' table--i.e., the line with references? Thanks again! Mikki --- In Axapta-Knowledge-Village@yahoogroups.com, Harry Deshpande [EMAIL PROTECTED] wrote: Hi If this field is filled up then there is a BOM journal that has not been posted. If you cant see this in the form then search for the line in the database. If (you find the line) Delete this line and you should be ok else Let me know. Regards Harry This posting is provided AS IS with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm; The code provided (if any) may be written from the point of view of a third party and the programming style/development standards may suit such a point of view. From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of futzawm Sent: 17 January 2007 18:21 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Production closing error: Quantity ordered may not be reduced, as there are Thanks for your response, Harry. I believe you are referring to the 'General' tab of the 'Transactions' form. Yes, there's an inventory reference (the field is 'TransChildRefId' and the Type is 'Picking List Journal'). Would that be of significance? Note that the status of the transaction is 'On order' as pointed out in my original question. Regards. Mikki --- In Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com, Harry Deshpande harryd@ wrote: hi Is there any inventory reference on the inventory transaction for the item? I dont have Ax in front of me right now, but this reference is I think on the second tab and the field is InventRefChildId or something similar regards harry From: Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED]mailto:Axapta-Knowledge-Village%40yahoogroups.com] On Behalf Of futzawm [EMAIL PROTECTED] Sent: Monday, January 15, 2007 9:23 PM To: Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: [Axapta-Knowledge-Village] Production closing error: Quantity ordered may not be reduced, as there are.. Please help on the following problem (I have seen similar questions in the forum but none Were resolved): We are trying to close a production order and the following error is being generated: Calculating BOM Consumption Posting - Picking list journal Journal: PJ Voucher: PV Line No: 1 Item No: 00123 Quantity ordered may not be reduced, as there are not enough stock transactions with 'on order' status. The items are 'Sold', 'Deducted' or 'Picked'. The production was started with the item in question but another item was substituted during production. Registration of the picking list journal was thus done with the item consumption = 0. There are no transactions with 'Sold', 'Deducted' or 'Picked' status for the item as referring to that particular production. However, the item transactions show a quantity equal to the original started quantity with status 'On Order' for that particular production (therefore, no reason for the error not enough stock transactions with 'On Order' status). I saw one earlier response to this type of problem by fvatne where it was suggested that the problem can be a result of mismatch between different dimensions. This seemed a logical reason but the problem was not solved even after we removed all dimension restrictions on the particular item. How would we be able to resolve this problem? Would be very grateful for some pointers. Thanks. Mikki [Non-text portions of this message have been removed] - Expecting? Get great news right away with email Auto-Check. Try the Yahoo! Mail Beta. [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Ledger Un Settlement Report
Hi, I am wondering if there is any standard existing Financial report which can give the list of all un settled ( or waiting to settled ) ledger transactions?. The existing report 'Ledger Transactions' can be 1:n to LedgerSettlement table to get the settled vouchers. but I am looking to see if there is any report to get the info on all the unsettled transactions?. Any help / work around will be appreciated, Thansk in Advance, subbu - Cheap Talk? Check out Yahoo! Messenger's low PC-to-Phone call rates. [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Account Length
Hi Faiqa, 1. if you want to change the account lenght for all companies, you can change the EDT of accoutNum ( highest parent ) properties in the AOT 2. if you want to change per company, you can admnistration - setup-adjust global variables etc etc...you can set the length over there...I guess 20 is the length We extended.for accoun and projeID...but you can always map back to the char variable in SQL( 1000 chars?) Caution: Axapta suggests you that you cange the lengths with proper justification before you load the data into tables or it will lead to data inconsistancy or values will not be fetched in queries.for more info, you can browse the forum for previous posts. Yes. you can rename the default dimensions ( financial??) by changing the lable in the EDT or ENUMs..we renamed configID too... And what is the Seggeration query in GP you are talking about? what does in do in reporting? any insight will be helpful to see if that feature available in axapta. I guess it should since GP is also a baby from Microsoft as Axapta good luck, take care, Subbu Agus Riyadi [EMAIL PROTECTED] wrote: Hi Faiqa, You can enlarge the string width of Ledger Account through AccountNum Extended Data Type ( I don't know whether Gread Plains use the same concept of EDT or not - never use it). It is converted into varchar data type in the physical database which means you can set it to maxium of 8000 characters width as documented in SQL server ( CMMIW). I have no insight of your second query. Regards, Agus On 12/1/06, Faiqa Khushi [EMAIL PROTECTED] wrote: Hi , I am new to Axapta Dynamics, previously I worked over Great Plains Dynamics. Please help me about few queries: How much maximum Ledger Account length we can define in Axapta? Can we segregate our account in parts while generating reports from Axapta as we can do in GP using Segment features? Please reply me apart from using Dimensions. Can we rename the default Dimensions? Regards, Faq [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] - Any questions? Get answers on any topic at Yahoo! Answers. Try it now. [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Account Length
Hi Faiqa, 1. if you want to change the account lenght for all companies, you can change the EDT of accoutNum ( highest parent ) properties in the AOT 2. if you want to change per company, you can admnistration - setup-adjust global variables etc etc...you can set the length over there...I guess 20 is the length We extended.for accoun and projeID...but you can always map back to the char variable in SQL( 1000 chars?) Caution: Axapta suggests you that you cange the lengths with proper justification before you load the data into tables or it will lead to data inconsistancy or values will not be fetched in queries.for more info, you can browse the forum for previous posts. Yes. you can rename the default dimensions ( financial??) by changing the lable in the EDT or ENUMs..we renamed configID too... And what is the Seggeration query in GP you are talking about? what does in do in reporting? any insight will be helpful to see if that feature available in axapta. I guess it should since GP is also a baby from Microsoft as Axapta good luck, take care, Subbu Agus Riyadi [EMAIL PROTECTED] wrote: Hi Faiqa, You can enlarge the string width of Ledger Account through AccountNum Extended Data Type ( I don't know whether Gread Plains use the same concept of EDT or not - never use it). It is converted into varchar data type in the physical database which means you can set it to maxium of 8000 characters width as documented in SQL server ( CMMIW). I have no insight of your second query. Regards, Agus On 12/1/06, Faiqa Khushi [EMAIL PROTECTED] wrote: Hi , I am new to Axapta Dynamics, previously I worked over Great Plains Dynamics. Please help me about few queries: How much maximum Ledger Account length we can define in Axapta? Can we segregate our account in parts while generating reports from Axapta as we can do in GP using Segment features? Please reply me apart from using Dimensions. Can we rename the default Dimensions? Regards, Faq [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] - Need a quick answer? Get one in minutes from people who know. Ask your question on Yahoo! Answers. [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Duplicate LineNum
Hi James, how are you man?. We had this problem back in 2004 where we had the same PO line being generated when you go on clicking 'New' line without filling up any items. say if you click the 'New' to create the line for 3 times, the line number will be 3 only and start from 3... The way we fixed is, 1. Create a job which will output you the PO ( or SO's) with duplicate line numbers. 2. Fix them using a job. 3. Change the PurchLineIdx on Puchline to allow duplicates to 'No' That above took care of everythign. thats my exp James. James Flavell [EMAIL PROTECTED] wrote: Hi Lars and Patrick I had a customer today who had problem of line number being the same for a lot of lines on their PO. We found out that if the user creates a new PO line but does NOT fill in the item number and then creates one more PO line (so 2 lines with no item numbers). When they go back to these lines and fill in the item numbers both lines get the same line number. Example: Create PO line with item X (line num1) Create PO line with no item (line num2) Create PO line with no item (line num3) Go back and assign item number to the two PO lines (line num 2 and 3 change to be the same number) Note: Once both PO lines have the same number if you add any more lines in between these 2 then all the lines have the same linenum. This happens in SP2 and SP5 (in between SP not tested but expected to be the same) Has anyone experienced this and have a solution for it? I believe the problem is the PO lines without item number are not really table records (i.e. only existing as 'form records') and so the line numbering routine basically ignores (or does not see them) when you come back and assign item number (i.e. the line numbering only looks at committed records in the PO line table to determine is there any line before and after the line that has been inserted). Thank James James Flavell CITP Pte Ltd Singapore Tel: +65 97582281 www.columbusit.com -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of chuapatrickd Sent: 20 July 2006 18:11 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: LineNum Hi Lars, Yes. You are correct. I've applied a filter and then add a new record. I was given a linenum of 3 which is already existing among the line, thus there is really redundancy. Anyway, I'll just have to be very careful on this. regards, Patrick --- In Axapta-Knowledge-Village@yahoogroups.com, Lars Holm [EMAIL PROTECTED] wrote: Be careful using this feature as it is buggy. When a filter has been applied to the datasource (e.g. the user has found a specific record), only the line number from this one record is considered and not the other line numbers in the table thus it will cause reduncancy. Best regards, Lars _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:Axapta- [EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 20. juli 2006 09:20 To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] LineNum Hi, In the SalesLine form, there is a property called counterfield in SalesLine DataSource. There, u have to mention the field to be incremented. Here, LineNum is given. So, it will be incremented automatically. i think u get my solution. regs, Hema. S chuapatrickd chuapatrickd@ mailto:chuapatrickd%40yahoo.com yahoo.com To: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: [Axapta-Knowledge-Village] LineNum groups.com 20/07/2006 12:35 PM Please respond to Axapta-Knowledge-Village Hi, In SalesLine Table, there is a field Linenum which gets incremented each time you add a new item in the Sales order. I'm just wondering how this is automatically incremented. I want to simulate this routine since I've added also a field linenum to my table. Regards, Patrick [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links - Want to start your own business? Learn how on Yahoo! Small Business. [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Re: Trade Logistics Training Material
Hi,
The Training Material and the axapta help ( such as field descritpion and
utility , even thoguh std axapta help is not good) should be more than enough
to get certified. Recently I am certified in T L ,scoring 93% . The key is
simple. Just study the manuals and e -course. I could not find BOM material.
One has to study that too.
Good Luck,
Subbu
Nitesh [EMAIL PROTECTED] wrote:
Manish ,
That is more then sufficient.
Nitesh
On 11/28/06, maneesh_jain [EMAIL PROTECTED] wrote:
Hi,
I have E-academy courses for Trade Essentials 3.0 and Logistics
Essentials 3.0. Are they any good for the TL exam preparation?
Thanks,
Maneesh
--- In
Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com,
lars_kjaersgaard
[EMAIL PROTECTED] wrote:
Hi Rasika,
I am very much interested in TL exam materials. I would be very
grateful If you would mail me the material.
Maybe I have som materials you are interested in? We can talk about
it.
Best regards
Lars
Hi,
I am Rasika from Sri Lanka.
I did TL exam resently and got through. If you still searching
for the materials I can send it. Pl. write to me if you want it.
wbr,
Rasika
- - ---
Ring'em or ping'em. Make PC-to-phone calls as low as 1ยข/min with
Yahoo! Messenger with Voice.
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/ axapta for axapta friends.
SPONSORED LINKS Business finance course Business to business
finance Small business finance
Business finance consultant Business finance magazine Business
finance schools
YAHOO! GROUPS LINKS
Visit your group Axapta-Knowledge- Village on the web.
To unsubscribe from this group, send an email to:
Axapta-Knowledge- Village-unsubscr [EMAIL PROTECTED] com
Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
[Non-text portions of this message have been removed]
- - ---
Find out what India is talking about on - Yahoo! Answers India
Send FREE SMS to your friend's mobile from Yahoo! Messenger
Version 8. Get it NOW
[Non-text portions of this message have been removed]
__
___
Sponsored Link
Mortgage rates near 39yr lows.
$510k for $1,698/mo. Calculate new payment!
www.LowerMyBills.com/lre
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
-
Access over 1 million songs - Yahoo! Music Unlimited.
[Non-text portions of this message have been removed]
Re: RE : RE : [Axapta-Knowledge-Village] Regarding multithreading concept in Axapta
Hi Steve Sir, I apolozise for this dely as I am travelling. I did this in previous project ( employer ) and I sent an email to send me the project xpo to my collegue and am waiting upon him. I will remaind him again. sorry for the delay. thanks regards, subbu Steeve Gilbert [EMAIL PROTECTED] wrote: Hi Subbu! Hope you're doing well. I just wanted to know if you could send me the stuff you did on threads. This is not a priority since there's not on going project on this so take the time you need. I'm looking forward to see what you've done on threads. Have a nice day! Steeve... -Message d'origine- De : Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de Subrahmanyam, Mamidi Envoyรฉ : 22 mars 2006 09:40 ร : Axapta-Knowledge-Village@yahoogroups.com Objet : RE: RE : [Axapta-Knowledge-Village] Regarding multithreading concept in Axapta Hi Harry, Well, Its true thats it very hard to debug a dead lock in any multi thread environment and moreover, creation of the thread handles are not very favorable in windows.and I think there is a limit of 2400 ( ?? ) handles on Windows. at any time..User interface is possible ( only ) in MFC Steve, I contacted MS iniially for any good documentaion on this and they said no documentation available and refered a small tutorial :D I will send you a private email on the stuff I did. have a great day. thanks regards, subbbu Harry Deshpande [EMAIL PROTECTED] wrote: Hi Steve My advice is to stay away from threads in Axapta *s* the biggest problem is that you cannot debug threads so if some code logic is in-correct then you cannot use debugger to step thru the process. Plus I have a suspicion that thread process cannot have any user interface such as process bar etc. Regards Harry This posting is provided AS IS with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm; The code provided (if any) may be written from the point of view of a third party and the programming style/development standards may suit such a point of view. -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steeve Gilbert Sent: 21 March 2006 21:27 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE : [Axapta-Knowledge-Village] Regarding multithreading concept in Axapta Hi Subbu, A couple of months ago we try to do some multithreading with the thread class in Axapta but it wasn't working very well so we abandoned it. But if there's other way to do that I am for it. So I wanted to see what WinAPI::createdThread() look like but it doesn't exist in our installation Ax 3.0 SP3. Is it in a later SP or do I need something else? Thanks, Steeve... -Message d'origine- De : Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de Subrahmanyam, Mamidi Envoyรฉ : 21 mars 2006 14:24 ร : Axapta-Knowledge-Village@yahoogroups.com Objet : Re: [Axapta-Knowledge-Village] Regarding multithreading concept in Axapta X++ is not favorable compared to C++ in terms of system programming. in C++, we have many options/ std Cthread class with all thread functions inlcuding mutex objects. 1. for normal purpose, we have a sleep(milli secs) function in X++ 2. If you want to spawn multiple threads, we have WinAPI class: In C++, we have CMutex, waitforSingleObject, waitForMultipleObjects ( = ~ Semaphore ) , but in X++, we have the following WinAPI::createdThread() WinAPI::waitforSingleObject(threadId, waittime) etc etc... This is as per my knowledge... Good Luck. thanks, Subbu truptiranjan nayak [EMAIL PROTECTED] wrote: Hi, can anybody tell me how to do coding using multithreading concept. Ex: Suppose i am updating the invenTtrans table in my class. After updating the invenTtrans table i want to stop the execution for 1000 milliseconds as in Java. (t.sleep(1000)). Thanks Trupti - Yahoo! Travel Find great deals to the top 10 hottest destinations! [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. 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: [Axapta-Knowledge-Village] Mandatory unit introduced by MBS?
Hi James,
I thought of asked MS. Here is the answer I got.
//
3/28/2006 1:59:00 PM PST -- Subrahmanyam Hi,
in SP5/AX3, the unit of measurement was made mandatory on the salesLine when
we are creating. This is not there in SP3/AX3.
can you tell me the reason why its made mandatory?
thanks regards,
Subbu
--
3/28/2006 2:23:00 PM PST -- Jakob Barnard Subbu, thank you for contacting
Axapta Support today. We tested this in SP2, SP3, and then in SP4 is where this
change takes place. I will be looking through the SP4 release notes to see if I
can fine an answer for you.
So far I have not been able to turn anything up however as to a bug number or
change report as to why this was added in SP4.
//
ha ha ha, they are also in the same boatTypical MS
James Flavell [EMAIL PROTECTED] wrote:
Thanks Subbu,
I managed to get the error you are talking about using both SP1 and SP4 :)
But take note you need to have:
PO/SO line having unit (that is not rounded to zero decimals)
Inventory unit set as blank on item master
(Can you confirm this was/is the problem you faced)
So actually making the SO line unit mandatory means it is more likely that
users will face the error!!!
In my case if both the SO line and item master inventory unit are blank then
there is no rounding problem because both SO line and inventory trans get
rounded to 0 decimal.
The same is true for PO lines.
Okay thanks for the help but I am still really scratching my head why MBS
made the sales line unit mandatory. I would have thought it would be better
to make the item master 'Inventory' unit mandatory!!!???
Anyone else can shed some more insights into this?
Thanks Subbu once again
James
-Original Message-
From: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Subrahmanyam,
Mamidi
Sent: 27 March 2006 10:55
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Mandatory unit introduced by MBS?
Hi James,
This is my exp:
if there is no Unit for sales ( as well as Purch )
1. Created an Item code 'ABCD' with all the nescessary data, but no unit
for sales.
2. Created a sales order for that item with Qty = 200.25 ( for example,
with a real value )
3. When you save that line, we will see SalesQty = 200.25, but the amount
gets rounded off to 200. so the inventQty shows as 200.
InventQty calcQtyOrdered(Qty _qtySalesPurch = realMin())
{
InventQty qty;
InventTable inventTable;
Qty qtySalesPurch = _qtySalesPurch;
;
if (qtySalesPurch == realMin())
qtySalesPurch = this.salesPurchQty;
if (!qtySalesPurch)
return 0;
inventTable = this.inventTable();
qty = UnitConvert::qty(qtySalesPurch,
this.purchSalesUnit,
inventTable.inventUnitId(),
this.itemId);
return decRound(qty,InventTable::inventDecimals(this.itemId));
}
when we dont maintain units, I beliver, everything will get rounded off to
zero decimals ( because of nu Unit ) and we end up facing problmes when we
do inventmonvent ( invoicing /picknglist ) etc etc..
willing to learn other exp...The above was my real time problem faced...
Can Anyone say that I am wrong?
thanks regads,
Subbu
James Flavell [EMAIL PROTECTED] wrote:
Hi Jens
Basically because the data was never setup with units. I mean all their
items come only in standard unit so there are no conversions etc so why
bother setting up any unit records that have to be maintained etc just use
blank...its just additional work for the user is the original reasoning.
But now that unit is made mandatory then probably will have to go and set
all that up. But I still would like to know why has the unit now been made
mandatory (earlier version is was not mandatory) and why is it only on the
salesline and not the purchase line
Thanks
James
-Original Message-
From: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Jens
Strandberg
Sent: 27 March 2006 03:09
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Mandatory unit introduced by MBS?
James,
Out of curiosity: Why wouldn't you have unit required in sales line ?
And: Isn't it filled out automatically when you have keyed in the item id ?
/Jens
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
Yahoo! Groups Links
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
-
YAHOO! GROUPS LINKS
Visit your group Axapta-Knowledge-Village on the web.
To unsubscribe from this group
RE: [Axapta-Knowledge-Village] Mandatory unit introduced by MBS?
Hi James,
This is my exp:
if there is no Unit for sales ( as well as Purch )
1. Created an Item code 'ABCD' with all the nescessary data, but no unit for
sales.
2. Created a sales order for that item with Qty = 200.25 ( for example, with
a real value )
3. When you save that line, we will see SalesQty = 200.25, but the amount
gets rounded off to 200. so the inventQty shows as 200.
InventQty calcQtyOrdered(Qty _qtySalesPurch = realMin())
{
InventQty qty;
InventTable inventTable;
Qty qtySalesPurch = _qtySalesPurch;
;
if (qtySalesPurch == realMin())
qtySalesPurch = this.salesPurchQty;
if (!qtySalesPurch)
return 0;
inventTable = this.inventTable();
qty = UnitConvert::qty(qtySalesPurch,
this.purchSalesUnit,
inventTable.inventUnitId(),
this.itemId);
return decRound(qty,InventTable::inventDecimals(this.itemId));
}
when we dont maintain units, I beliver, everything will get rounded off to
zero decimals ( because of nu Unit ) and we end up facing problmes when we do
inventmonvent ( invoicing /picknglist ) etc etc..
willing to learn other exp...The above was my real time problem faced...
Can Anyone say that I am wrong?
thanks regads,
Subbu
James Flavell [EMAIL PROTECTED] wrote:
Hi Jens
Basically because the data was never setup with units. I mean all their
items come only in standard unit so there are no conversions etc so why
bother setting up any unit records that have to be maintained etc just use
blank...its just additional work for the user is the original reasoning.
But now that unit is made mandatory then probably will have to go and set
all that up.
But I still would like to know why has the unit now been made mandatory
(earlier version is was not mandatory) and why is it only on the salesline
and not the purchase line
Thanks
James
-Original Message-
From: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Jens
Strandberg
Sent: 27 March 2006 03:09
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Mandatory unit introduced by MBS?
James,
Out of curiosity: Why wouldn't you have unit required in sales line ?
And: Isn't it filled out automatically when you have keyed in the item id ?
/Jens
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
Yahoo! Groups Links
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
-
YAHOO! GROUPS LINKS
Visit your group Axapta-Knowledge-Village on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
-
-
Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+
countries) for 2ยข/min or less.
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
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] Mandatory unit introduced by MBS?
Just adding ,
if we dont add Unit of measurement, it gets rounded off.
I think, someone might have compared to Baan Vs Axapta, ight have logged a
case with MSnot sure the exact reason...but I am sure that when we dont
maintain Units on SalesLines, that amount gets rounded off.
any other thoughts,
Thanks Regards,
Subbu
Subrahmanyam, Mamidi [EMAIL PROTECTED] wrote:
Hi James,
This is my exp:
if there is no Unit for sales ( as well as Purch )
1. Created an Item code 'ABCD' with all the nescessary data, but no unit for
sales.
2. Created a sales order for that item with Qty = 200.25 ( for example, with
a real value )
3. When you save that line, we will see SalesQty = 200.25, but the amount
gets rounded off to 200. so the inventQty shows as 200.
InventQty calcQtyOrdered(Qty _qtySalesPurch = realMin())
{
InventQty qty;
InventTable inventTable;
Qty qtySalesPurch = _qtySalesPurch;
;
if (qtySalesPurch == realMin())
qtySalesPurch = this.salesPurchQty;
if (!qtySalesPurch)
return 0;
inventTable = this.inventTable();
qty = UnitConvert::qty(qtySalesPurch,
this.purchSalesUnit,
inventTable.inventUnitId(),
this.itemId);
return decRound(qty,InventTable::inventDecimals(this.itemId));
}
when we dont maintain units, I beliver, everything will get rounded off to
zero decimals ( because of nu Unit ) and we end up facing problmes when we do
inventmonvent ( invoicing /picknglist ) etc etc..
willing to learn other exp...The above was my real time problem faced...
Can Anyone say that I am wrong?
thanks regads,
Subbu
James Flavell [EMAIL PROTECTED] wrote:
Hi Jens
Basically because the data was never setup with units. I mean all their
items come only in standard unit so there are no conversions etc so why
bother setting up any unit records that have to be maintained etc just use
blank...its just additional work for the user is the original reasoning.
But now that unit is made mandatory then probably will have to go and set
all that up.
But I still would like to know why has the unit now been made mandatory
(earlier version is was not mandatory) and why is it only on the salesline
and not the purchase line
Thanks
James
-Original Message-
From: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Jens
Strandberg
Sent: 27 March 2006 03:09
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Mandatory unit introduced by MBS?
James,
Out of curiosity: Why wouldn't you have unit required in sales line ?
And: Isn't it filled out automatically when you have keyed in the item id ?
/Jens
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
Yahoo! Groups Links
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
-
YAHOO! GROUPS LINKS
Visit your group Axapta-Knowledge-Village on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
-
-
Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+
countries) for 2ยข/min or less.
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
-
YAHOO! GROUPS LINKS
Visit your group Axapta-Knowledge-Village on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
-
-
New Yahoo! Messenger with Voice. Call regular phones from your PC and save big.
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
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] Regarding multithreading concept in Axapta
X++ is not favorable compared to C++ in terms of system programming. in C++, we have many options/ std Cthread class with all thread functions inlcuding mutex objects. 1. for normal purpose, we have a sleep(milli secs) function in X++ 2. If you want to spawn multiple threads, we have WinAPI class: In C++, we have CMutex, waitforSingleObject, waitForMultipleObjects ( = ~ Semaphore ) , but in X++, we have the following WinAPI::createdThread() WinAPI::waitforSingleObject(threadId, waittime) etc etc... This is as per my knowledge... Good Luck. thanks, Subbu truptiranjan nayak [EMAIL PROTECTED] wrote: Hi, can anybody tell me how to do coding using multithreading concept. Ex: Suppose i am updating the invenTtrans table in my class. After updating the invenTtrans table i want to stop the execution for 1000 milliseconds as in Java. (t.sleep(1000)). Thanks Trupti - Yahoo! Travel Find great deals to the top 10 hottest destinations! [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Yahoo! Mail Use Photomail to share photos without annoying attachments. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] Cost calculation crisis
Hi Mkye, 1. which verson of axapta you are running? 2. if you are running Ax3.0 , did you put HF30SP3_058 - Axapta IC Rollup for 3.0 SP3 HF30SP2_034 - Axapta IC Rollup for 3.0 SP2 I think your problem should be solved if you put that hot fix. Happy Days and good Luck. Thanks Regards, subbu [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: We are running Axapta with standard costing selected and are having serious issues with the Inventory close process. The system seems to be making a lot more adjustments than what we want to see and calculating costs at incorrect amounts. Is anyone out there running inventory close - and for standard costs? Try Juno Platinum for Free! Then, only $9.95/month! Unlimited Internet Access with 1GB of Email Storage. Visit http://www.juno.com/value to sign up today! Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Yahoo! Mail Bring photos to life! New PhotoMail makes sharing a breeze. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] Cost calculation crisis
Hi there, We contacted MS when one of the item got costed in hundreds of millions. I I am not directly involved as I was a silent wtacher for that painfull effort that went for 3 months sent you a personal email on this... Please let me know if you need any specific info. Thanks Regards, subbu [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Thanks subbu_oh! Unfortunately, the HF30SP3_058 - Axapta IC Rollup for 3.0 SP3 patch is already in. It does not solve all of our problems - only a small portion. Have you run the close successfully? Thanks. -- Subrahmanyam, Mamidi [EMAIL PROTECTED] wrote: Hi Mkye, 1. which verson of axapta you are running? 2. if you are running Ax3.0 , did you put HF30SP3_058 - Axapta IC Rollup for 3.0 SP3 HF30SP2_034 - Axapta IC Rollup for 3.0 SP2 I think your problem should be solved if you put that hot fix. Happy Days and good Luck. Thanks Regards, subbu [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: We are running Axapta with standard costing selected and are having serious issues with the Inventory close process. The system seems to be making a lot more adjustments than what we want to see and calculating costs at incorrect amounts. Is anyone out there running inventory close - and for standard costs? Try Juno Platinum for Free! Then, only $9.95/month! Unlimited Internet Access with 1GB of Email Storage. Visit http://www.juno.com/value to sign up today! Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Yahoo! Mail Bring photos to life! New PhotoMail makes sharing a breeze. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Try Juno Platinum for Free! Then, only $9.95/month! Unlimited Internet Access with 1GB of Email Storage. Visit http://www.juno.com/value to sign up today! Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Yahoo! Mail Bring photos to life! New PhotoMail makes sharing a breeze. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] Urgent: Sort RecordBuffer in descending order.
Hi Krishna, I think its not possible to use ReCordSortedList class to sort the records in decending order. My recomendation is that you may have to create a temporary table and do a 'Inser_recordSet' and then use select orderby or group by with option Asc or desc... These are just my thoughts.. Thanks Regards, subbu Priyank Krishna [EMAIL PROTECTED] wrote: Hello friends! This a query to discuss with you. I need to sort a record buffer with any key field of it in descending order. I tried using RecordSortedList but it all only sort the records in ascending order. Any trick pls let me advise. Thanks in advance! - Jiyo cricket on Yahoo! India cricket Yahoo! Messenger Mobile Stay in touch with your buddies all the time. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Yahoo! Mail Bring photos to life! New PhotoMail makes sharing a breeze. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] Printing of Check Again
Hi Vivek, There should be 6 status. 1. Non 2. Sent 3.Received 4.Approved 5.Rejected 6.ReUse please let me know the menu path you are looking at and are you using Ax3 and Sp3? vivek sharma [EMAIL PROTECTED] wrote: I guess there is no such reuse option . Only five options are there as mentioned in Asrar's reply . Vivek Nancy L Hall [EMAIL PROTECTED] wrote: The Reuse option does allow you to reuse the check number. I would invetigate why you do have that option, uless the journal is posted. --- vivek sharma [EMAIL PROTECTED] wrote: Hi Nancy What u said is quite true and correct . But what will happen in case we want to use the same check number . In case we are printing check number also from Axapta on check leaf and in case that leaf is somehow is not printed properly beacuse of printer error or something like that . Than in that case what can be the solution. If the above case happens than we only have one solution in axapta to cancel the check and generate check with new check number. Or is there any solution which can reuse the same check number and print check again?? Regards Vivek Nancy L Hall [EMAIL PROTECTED] wrote: I have the option available in 3.0. Have you posted your Payment Journal? If so, then the options will be grayed out. If not posted, you can still use the Rejected Option and Axapta will assign a new Check number, once status is changed to None. Then generate payments again. --- Asrar Ahamed [EMAIL PROTECTED] wrote: Hi Hemant, I have Axapta 3.0, I could see only the following options in Pyament Journal Lines Payment Status: - None - Sent - Received - Approved - Rejected From where I can see the re-use options??? Thanks, Hemant Kumthekar [EMAIL PROTECTED] wrote: Hi, Select the Payment Line in Payment Journal Payment Status Reuse. Hemant vivek sharma [EMAIL PROTECTED] wrote: How can we print a check again in bank module again if the check printed first time through payment journal is not correct or improper?? - Yahoo! Mail Use Photomail to share photos without annoying attachments. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Yahoo! Mail Use Photomail to share photos without annoying attachments. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Yahoo! Messenger NEW - crystal clear PC to PC calling worldwide with voicemail [Non-text portions of this message have been removed] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - === message truncated
Re: [Axapta-Knowledge-Village] Printing of Check Again
And one more thought is, 1. If you have a erroneous check generated while printing ( or whatsoever may be the reason ), if you want to print the same check number, you need to void it out right??. Once you have voided it out and then may be if you want to use the same check number, I am not sure if you reset the chequer numbering sequence F-Check in the bank parameters ... and print your check and rest it back vivek sharma [EMAIL PROTECTED] wrote: I guess there is no such reuse option . Only five options are there as mentioned in Asrar's reply . Vivek Nancy L Hall [EMAIL PROTECTED] wrote: The Reuse option does allow you to reuse the check number. I would invetigate why you do have that option, uless the journal is posted. --- vivek sharma [EMAIL PROTECTED] wrote: Hi Nancy What u said is quite true and correct . But what will happen in case we want to use the same check number . In case we are printing check number also from Axapta on check leaf and in case that leaf is somehow is not printed properly beacuse of printer error or something like that . Than in that case what can be the solution. If the above case happens than we only have one solution in axapta to cancel the check and generate check with new check number. Or is there any solution which can reuse the same check number and print check again?? Regards Vivek Nancy L Hall [EMAIL PROTECTED] wrote: I have the option available in 3.0. Have you posted your Payment Journal? If so, then the options will be grayed out. If not posted, you can still use the Rejected Option and Axapta will assign a new Check number, once status is changed to None. Then generate payments again. --- Asrar Ahamed [EMAIL PROTECTED] wrote: Hi Hemant, I have Axapta 3.0, I could see only the following options in Pyament Journal Lines Payment Status: - None - Sent - Received - Approved - Rejected From where I can see the re-use options??? Thanks, Hemant Kumthekar [EMAIL PROTECTED] wrote: Hi, Select the Payment Line in Payment Journal Payment Status Reuse. Hemant vivek sharma [EMAIL PROTECTED] wrote: How can we print a check again in bank module again if the check printed first time through payment journal is not correct or improper?? - Yahoo! Mail Use Photomail to share photos without annoying attachments. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Yahoo! Mail Use Photomail to share photos without annoying attachments. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Yahoo! Messenger NEW - crystal clear PC to PC calling worldwide with voicemail [Non-text portions of this message have been removed] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this
Re: [Axapta-Knowledge-Village] Printing of Check Again(Nice answer from MS guy)
Just found something for your reference.Its a nice answer.. MSFT: To be able to print a check twice would be a serious security problem - and probably illegal in several countries around the world. In the case with wrong paper etc., you simply have to void the check in the payment journal and create a new check. Exactly as you'd have to do if you misprint something when writing a check from your own checkbook Best of luck, subbu vivek sharma [EMAIL PROTECTED] wrote: I guess there is no such reuse option . Only five options are there as mentioned in Asrar's reply . Vivek Nancy L Hall [EMAIL PROTECTED] wrote: The Reuse option does allow you to reuse the check number. I would invetigate why you do have that option, uless the journal is posted. --- vivek sharma [EMAIL PROTECTED] wrote: Hi Nancy What u said is quite true and correct . But what will happen in case we want to use the same check number . In case we are printing check number also from Axapta on check leaf and in case that leaf is somehow is not printed properly beacuse of printer error or something like that . Than in that case what can be the solution. If the above case happens than we only have one solution in axapta to cancel the check and generate check with new check number. Or is there any solution which can reuse the same check number and print check again?? Regards Vivek Nancy L Hall [EMAIL PROTECTED] wrote: I have the option available in 3.0. Have you posted your Payment Journal? If so, then the options will be grayed out. If not posted, you can still use the Rejected Option and Axapta will assign a new Check number, once status is changed to None. Then generate payments again. --- Asrar Ahamed [EMAIL PROTECTED] wrote: Hi Hemant, I have Axapta 3.0, I could see only the following options in Pyament Journal Lines Payment Status: - None - Sent - Received - Approved - Rejected From where I can see the re-use options??? Thanks, Hemant Kumthekar [EMAIL PROTECTED] wrote: Hi, Select the Payment Line in Payment Journal Payment Status Reuse. Hemant vivek sharma [EMAIL PROTECTED] wrote: How can we print a check again in bank module again if the check printed first time through payment journal is not correct or improper?? - Yahoo! Mail Use Photomail to share photos without annoying attachments. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Yahoo! Mail Use Photomail to share photos without annoying attachments. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Yahoo! Messenger NEW - crystal clear PC to PC calling worldwide with voicemail [Non-text portions of this message have been removed] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the
RE: [Axapta-Knowledge-Village] Printing of Check Again
by the company's management. 3. 3) Each company must disclose whether it has adopted a code of ethics and requires prompt disclosure of any change to this code of ethics. As you can see, re-use of a check number may not be legally viable in the US depending on the type of business and or government requirements. Microsoft may not have realized that allowing re-use (SP4) can impact the Sarbanes-Oxley compliance of Dynamics-AX. Confidentiality Notice: This e-mail contains confidential and/or privileged information and is intended to be read only by the person or authorized representative of the organization to whom it is addressed. If you are neither of these persons, you have received this e-mail in error. Please do not print, copy, re-transmit, disseminate or otherwise use the information, all of which are prohibited. Please immediately notify the sender by return e-mail or by telephone at (303)593-1246 that you have received this communication in error and delete this e-mail from your system. Thank you. John T. Lindsay Micro Sciences Company 303 593-1246 303 593-1248 Fax _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Hemant Kumthekar Sent: Sunday, February 26, 2006 5:11 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Printing of Check Again John, Just to make clarification that Re Use is in SP4 now. Hemant John Remsberg [EMAIL PROTECTED] wrote: The reuse function is part of the BKD PowerPak. John Lindsay [EMAIL PROTECTED] wrote: I have to agree with the MS response. Checks in the US have the check number imprinted in the MICR number at the bottom of the check. This is done in magnetic ink, unless you are printing the check on a laser with a MICR cartridge, the check number will not match. Furthermore, good audit practices should require that any mis-printed checks be voided and logged. Resetting of the check number would violate the audit trail best practices. Confidentiality Notice: This e-mail contains confidential and/or privileged information and is intended to be read only by the person or authorized representative of the organization to whom it is addressed. If you are neither of these persons, you have received this e-mail in error. Please do not print, copy, re-transmit, disseminate or otherwise use the information, all of which are prohibited. Please immediately notify the sender by return e-mail or by telephone at (303)593-1246 that you have received this communication in error and delete this e-mail from your system. Thank you. John T. Lindsay Micro Sciences Company 303 593-1246 303 593-1248 Fax _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of vivek sharma Sent: Sunday, February 26, 2006 11:34 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Printing of Check Again Thanks Subrahmanyam i will try ur solution . Thanks to all for replying my small query. Regards Vivek Subrahmanyam, Mamidi [EMAIL PROTECTED] wrote: Ok. This is my final thought.. 1. You can void the cheque for check number '01' 2. You can reset the check number sequence from '0x' to '01' 3. Print your check with check number '01' 4. Reset the check number Number sequence to '0x' please let me know if you still can not get what you want or I will talk to someone from my finance team. Thanks Regards, subbu vivek sharma [EMAIL PROTECTED] wrote: I guess there is no such reuse option . Only five options are there as mentioned in Asrar's reply . Vivek Nancy L Hall [EMAIL PROTECTED] wrote: The Reuse option does allow you to reuse the check number. I would invetigate why you do have that option, uless the journal is posted. --- vivek sharma [EMAIL PROTECTED] wrote: Hi Nancy What u said is quite true and correct . But what will happen in case we want to use the same check number . In case we are printing check number also from Axapta on check leaf and in case that leaf is somehow is not printed properly beacuse of printer error or something like that . Than in that case what can be the solution. If the above case happens than we only have one solution in axapta to cancel the check and generate check with new check number. Or is there any solution which can reuse the same check number and print check again?? Regards Vivek Nancy L Hall [EMAIL PROTECTED] wrote: I have the option available in 3.0. Have you posted your Payment Journal? If so, then the options will be grayed out. If not posted, you can still use the Rejected Option and Axapta will assign a new Check number, once status is changed to None. Then generate payments again. --- Asrar Ahamed [EMAIL PROTECTED] wrote: Hi Hemant, I have Axapta 3.0, I could see only the following options in Pyament Journal Lines
RE: [Axapta-Knowledge-Village] Printing of Check Again
Hi John, Again, I agree with you completely. But sometimes, have to do break the law in order to keep things moving :P.. I agree from the functional perspective...And also it depends upon the client aslo who are sometimes very sticky to their ideas and will not listen to our suggestions. We have many areas where we can break the law..for example, There was an incident, 2005 fiscal was closed completely and the client found that there should be an adjust to be posted back to 2005 during a audit. He can not do that since the period was closed completely. But the client didnt listen and had to be done. and hence what is required here is to break the lawlike, using open source code X++, we can change all the relevent tables ( Trans ) propertied to edit mode and change the records, write a job to post the journal. We did 4 decimal customization..for european envionement, and once in a bluemoon, we get unknown, could not be duplicable problems and then we need to use the (nasty ) work around .:D Anyway, I will stop here. I hope someone with better ideas will share their exp . or I am sure someone from MS will be watching this thread in silent mode Take care, thanks, subbu John Lindsay [EMAIL PROTECTED] wrote: And by giving a work around, we now have a situation where someone could comprise the system security and print a false check and then reset the check counter. Confidentiality Notice: This e-mail contains confidential and/or privileged information and is intended to be read only by the person or authorized representative of the organization to whom it is addressed. If you are neither of these persons, you have received this e-mail in error. Please do not print, copy, re-transmit, disseminate or otherwise use the information, all of which are prohibited. Please immediately notify the sender by return e-mail or by telephone at (303)593-1246 that you have received this communication in error and delete this e-mail from your system. Thank you. John T. Lindsay Micro Sciences Company 303 593-1246 303 593-1248 Fax _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Subrahmanyam, Mamidi Sent: Sunday, February 26, 2006 10:28 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Printing of Check Again Hi , I am fully with you. Its the same as if you mistyped the date/name/amount on a check from your cheque book (or damaged cheque ) , you need to issue another cheque. Morever, there is a Re Use option available. I dont know if they did any customozation which messaed up with this form or he has to check with his developer ot himself going to AOT if the properties set to invisible...a lot thing to check... Morever, I just have given a work around as he is not satisfied with all our messages. Hence, I gave him the nasty practice just to get the work done :-) by resetting the number sequence, print the cheque and get back. And also, there are many ways of doing this also. Lik you can edit the cheuqe layout, edit the cheque number there and print that cheque..But he said he is using preprinted cheque... Anyway, I wish good luck to him Thanks Regards, subbu John Lindsay [EMAIL PROTECTED] wrote: This is a very interesting topic and I would appreciate further discussion. Whether Re Use is available or not - The basic issue goes to sound (read: secure) accounting practices. US checks require MICR numbers in the following format: There are five major fields on a MICR line : 1. Auxiliary On Us - contains check number if present; bracketed by on us symbols 2. EPC - one character located to the left of the transit field if present 3. Transit - 9 digits including check digit 4. On Us - variable length 19 digits max; between transit and amount fields 5. Amount - 10 digits zero filled; bracketed by two amount symbols Two of the five major fields are broken into multiple fields: Transit (9 digits) 6. Routing Number (digits 1-4) 7. Bank Number (digits 5-8) 8. Check Digit (1 digit) On Us 9. Account Number - Variable length; always followed by the On Us symbol 10. Check number - Located in various places in the on us field 11. TPC - max 6 characters; Located to right of account number This should match the check number printed on the check. If a check is mis-printed, the check(s) should be marked void by the operator and filed in a secure place. Destruction of voided checks should be logged. This prevents check fraud. This is from the US Department of Justice Private Trustee Handbook regarding check numbering. The trustee is still responsible for monitoring and verifying the numerical sequence of estate checks, in order to detect if unauthorized checks were printed. For example, let's say that the last check number authorized by the trustee was 105. Unbeknownst to the trustee, someone gains access
Re: [Axapta-Knowledge-Village] URGENT: Multilocalizaton setup
Hello Alessandro, Here is my experiece on Multi locationzations. We have 3 localisations on three different Databases. Northa America, Spain and Germany... We could have installed in one database for all these three localisations. I think MS is still working on this. and not sure if this is accountable in AXapta4.0. I think there is a white paper on this. But not possible or nor advisable to use for Ax3.0 unless its a simple system with few modules. And also, having three databases for three environments, you will have better control on the tables as the table structures are different for these environments ( majority tables ) and also Finace modules are different due to different account ing / taxation principles coming to intercompany setup, yes, some interfaces were developed , no problem..we use connectivty studio for this purpose whihc is very handy...and also we have intercompany setup ( customized party ) from Spain to Parisyou can imagine how much is the complexity... coming to ledger consolidations, yes, we did modify the ledgerconsolidate class to include three currencies ( EUR,Pound,USD ) for the consolidation and we have a very good company design. and we export the trasactions files and do consolidation in different currcies in different environment.. I am not sure for Ax4 , but for Ax3, MS recoommned to have three databases and 2 AOSs for our project ... please let me know if you need more detailsI am sure you end up doing more customizations.depending upon how complex is your system best of luck though. Subbu Zappia Alessandro [EMAIL PROTECTED] wrote: Hi everybody, Is it possible to install more than one localization in a unique axapta application and db? This seems to be strongly needed for a company that has more subcompanies in different countries when features like intercompany, consolidation, web integration thru business connector are absolutely needed. Unfortunately these localizations are distributed separately at the moment (North European, Italian, spainish, ) so the installation itself seems to be a problem... Anyone ever faced such situation or something similar? Many many thanks for any help! [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Brings words and photos together (easily) with PhotoMail - it's free and works with Yahoo! Mail. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] Printing of Check Again
Is there any issue if you can put 'stop payment on the cheque' and issue a new cheque?.. its would be nicer to see why do you want to reissue the same cheque# corrected?.. this is just my thoughtsmay not be useful. but someone may ask you the same question like why why dont you put a stop on the payment and issue the new cheque... best of luck, subbu vivek sharma [EMAIL PROTECTED] wrote: How can we print a check again in bank module again if the check printed first time through payment journal is not correct or improper?? - Yahoo! Mail Use Photomail to share photos without annoying attachments. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - What are the most popular cars? Find out at Yahoo! Autos [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] Item Inventory unit
Hi , We have the similar problem as our Item master got intially set up without Units for all these three modules. so when we create a PO line, the qty gets rounded to zero decimals...hence we faced the problems during the invoicing..but we are having work around for this to live with.. We can do as per Hemants recomendation. but its tooo many trasactions to touch or smell.. so we gave up... this is my peice of exp.. -subbu In Memories [EMAIL PROTECTED] wrote: It will change the inventory value. So i believe i have to reset the post transactions and then create new items with the new unit or what? thanks Hemant Kumthekar [EMAIL PROTECTED] wrote: Hi, If you want to change the unit of measure you can do so, but before doing that, take care if the new unit of measure will chnage any inventory valuation. If not then you first need to delete all the open Transactions i.e the Transactions generated by P.O / S.O / Production Order in Open Order or Ordered status. Also you need to check how are you goign to take care of any inventory on hand. Typically I will issue out all my inventory, then delete all open orders for that Item, then change the UoM and then receive back the inventory with new UoM. Hope this may help, but try it out in a TEST environment. Hemant In Memories [EMAIL PROTECTED] wrote: hi transactions for a certain item were posted when the Inventory Unit of this item was X. now we want to change this Unit to Y. As i know we cant because transactions already exist. Is there a way to change unit? is the UOM is saved with transactions or its just the quantity?? thanks - Yahoo! Autos. Looking for a sweet ride? Get pricing, reviews, more on new and used cars. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Brings words and photos together (easily) with PhotoMail - it's free and works with Yahoo! Mail. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - IN MEMORIES - Yahoo! Autos. Looking for a sweet ride? Get pricing, reviews, more on new and used cars. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Relax. Yahoo! Mail virus scanning helps detect nasty viruses! [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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: AW: RE : [Axapta-Knowledge-Village] Views in Axapta
Happy coding.. may be this piece could be useful..
static void forFun()
{
Treenode treeNode, child;
xInfo xInfo = new xInfo();
Object object;
int tableId = -1;
;
treeNode = xinfo.rootNode().AOTfindChild('Data
Dictionary').AOTfindChild('Views');
//if there already, please delete
child = treeNode.AOTfindChild('Subbu');
if (child)
{
child.AOTdelete();
}
// Add View...
treeNode.AOTadd('Subbu');
treeNode.AOTsave();
// add meta data
treeNode =
treeNode.AOTfindChild('Subbu').AOTfindChild('Metadata').AOTfindChild('Data
Sources');
treeNode.AOTadd('CustTable');
treeNode.AOTsave();
treeNode.AOTrestore();
treeNode.AOTrefresh();
treeNode = treeNode.AOTfindChild('Address_1(Address)');//gets always
defaulted
treeNode.AOTsetProperties(setProperty(treeNode.AOTgetProperties(),
Table, CustTable));
treeNode.AOTsetProperties(setProperty(treeNode.AOTgetProperties(),
Name, CustTable View));
treeNode.AOTsave();
treeNode.AOTrestore();
treeNode.AOTrefresh();
// treeNode = treeNode;
if(treeNode)
{
info(treeNode.treeNodePath());
treeNode.treeNodeRelease();
treeNode = null;
}
}
Subbu,
Andreas Rudischhauser [EMAIL PROTECTED] wrote:
I don't think it is good to use sql right here...
Von: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] Im
Auftrag von DIEGO MARIANO GAGLIANO
Gesendet: Montag, 20. Februar 2006 17:21
An: Axapta-Knowledge-Village@yahoogroups.com
Betreff: Re: RE : [Axapta-Knowledge-Village] Views in Axapta
hi Andres
Why you not try to use SQL Statment directly, and resolve the issue more
quick and have better performance.
This is an example:
str mysql;
Connection Con = New Connection();
Statement Stmt = Con.createStatement();
ResultSet R;
;
mysql = SELECT COUNT(ISOST) AS IsOst, ISESTADOREPARACION, ISDPTO,
ISENGARANTIA, ISENMANTENIMIENTO;
mysql += FROM dbo.ISREPAR_MANT A;
mysql += WHERE dataareaid = 'inl' GROUP BY ISDPTO, ISESTADOREPARACION,
ISENGARANTIA, ISENMANTENIMIENTO;
R = Stmt.executeQuery(mysql);
while (R.next() )
{
print r.getstring(1)+ +r.getstring(2)+ +r.getstring(3)+
+r.getstring(4)+ +r.getstring(5);
}
I hope this is you are asking for.
My best
Diego
Steeve Gilbert [EMAIL PROTECTED] wrote:
Hi Andreas,
Try using the TreeNode object instead. Use Appl.dbSynchronize(...) to sync
you new view.
Regards,
Steeve...
-Message d'origine-
De : Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] De la
part de Andreas Rudischhauser
Envoyรฉ : 20 fรฉvrier 2006 10:02
ร : Axapta-Knowledge-Village@yahoogroups.com
Objet : [Axapta-Knowledge-Village] Views in Axapta
I need to add a View programmatically and tried the DictView class, but
I don't get it to work.
Has anyone an example on how to add a View with Datasources to the AOT?
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
Yahoo! Groups Links
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course Business to business finance Small business
finance Business finance consultant Business finance magazine Business
finance schools
-
YAHOO! GROUPS LINKS
Visit your group Axapta-Knowledge-Village on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
-
Best regards,
Diego Gagliano
-
Yahoo! Messenger NEW - crystal clear PC to PC calling worldwide with voicemail
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course
http://groups.yahoo.com/gads?t=msk=Business+finance+coursew1=Business+finance+coursew2=Business+to+business+financew3=Small+business+financew4=Business+finance+consultantw5=Business+finance+magazinew6=Business+finance+schoolsc=6s=185.sig=I8jDsORmsaYn0BeqghcJ2w
Business to business finance
http://groups.yahoo.com/gads?t=msk=Business+to+business+financew1=Business+finance+coursew2=Business+to+business+financew3=Small+business+financew4=Business+finance+consultantw5=Business+finance+magazinew6=Business+finance+schoolsc=6s=185.sig=fCzze7cxm1K7TVKkzAaOrA
Small business finance
Re: [Axapta-Knowledge-Village] Re: Type Casting in Axapta Urgent Please
Hi, pls post top some piece of code where you are getting error. That should work.check for typos.. good luck, subbu vlnarasimhan2004 [EMAIL PROTECTED] wrote: Hi, I tried using this method. But it says This function has not been declared. what do i have to do?? Regards, Gayatri --- In Axapta-Knowledge-Village@yahoogroups.com, Vikas Garg [EMAIL PROTECTED] wrote: Hi Gayatri, Make use of 'enum2str' method and u can modify your code as follows: (inventtable.ItemId==enum2str(routeopr.ItemCode)) Thanks Vikas Garg _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of gayatringayatri Sent: Wednesday, February 15, 2006 5:46 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Type Casting in Axapta Urgent Please Hi, Actually I want to compare these two fields inventtable.ItemId==routeopr.ItemCode Inventtable.ItemId is of string type and routeopr.ItemCode is of baseenum type. When i do compare it gives this error message Operand types are not compatible with the operator. What do i have to do? How can i do type casting? Help needed urgent please... Kind Regards, Gayatri. Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business http://groups.yahoo.com/gads? t=msk=Business+finance+coursew1=Business+fin ance+coursew2=Business+to+business+financew3=Small+business+finance w4=Bus iness+finance+consultantw5=Business+finance+magazinew6=Business+fin ance+sc hoolsc=6s=185.sig=I8jDsORmsaYn0BeqghcJ2w finance course Business http://groups.yahoo.com/gads? t=msk=Business+to+business+financew1=Busines s+finance+coursew2=Business+to+business+financew3=Small+business+fi nancew 4=Business+finance+consultantw5=Business+finance+magazinew6=Busines s+finan ce+schoolsc=6s=185.sig=fCzze7cxm1K7TVKkzAaOrA to business finance Small http://groups.yahoo.com/gads? t=msk=Small+business+financew1=Business+fina nce+coursew2=Business+to+business+financew3=Small+business+finance w4=Busi ness+finance+consultantw5=Business+finance+magazinew6=Business+fina nce+sch oolsc=6s=185.sig=v9sWAno7Kz4WuL8Tadcdhw business finance Business http://groups.yahoo.com/gads? t=msk=Business+finance+consultantw1=Business +finance+coursew2=Business+to+business+financew3=Small+business+fin ancew4 =Business+finance+consultantw5=Business+finance+magazinew6=Business +financ e+schoolsc=6s=185.sig=d1xwT3WL0E6XBf6cAV5BXA finance consultant Business http://groups.yahoo.com/gads? t=msk=Business+finance+magazinew1=Business+f inance+coursew2=Business+to+business+financew3=Small+business+finan cew4=B usiness+finance+consultantw5=Business+finance+magazinew6=Business+f inance+ schoolsc=6s=185.sig=qphRINaNuVm_6bwoQxgUmg finance magazine Business http://groups.yahoo.com/gads? t=msk=Business+finance+schoolsw1=Business+fi nance+coursew2=Business+to+business+financew3=Small+business+financ ew4=Bu siness+finance+consultantw5=Business+finance+magazinew6=Business+fi nance+s choolsc=6s=185.sig=1RfnhYZpV99RKWRZzSH4gA finance schools _ YAHOO! GROUPS LINKS * Visit your group Axapta-Knowledge-Village http://groups.yahoo.com/group/Axapta-Knowledge-Village on the web. * 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. _ [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Yahoo! Mail Use Photomail to share photos without annoying attachments. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] Re: Throw inside TTS catch outside TTS
Hi Alex,
The concept should be as follows as its the same for C++ or JAVA. I am pretty
sure it should be the case for all object oriented labgugaes.
Whenever a throw occurs in a nested try catch blocks , depending upon the
return type, the Immediate catch should be hit.Since the return type here
is error and the immediate catch block should be hit...
..or
How can we hit the inner exception?...
interesting..let me dig into more
Alexander [EMAIL PROTECTED] wrote:
Hi Steeve,
This is normal Axapta behavior. Here is Developer's giude quote:
If an error is thrown and the first try block does not catch the
exception, the exception is propagated to the next try block, and so
forth. The outermost level is the normal handling of errors in
X++.
Your exception was caught by FIRST try operator.
Alex...
--- In Axapta-Knowledge-Village@yahoogroups.com, Steeve Gilbert
[EMAIL PROTECTED] wrote:
Running this :
try {
ttsbegin;
try {
throw Exception::Error;
} catch (Exception::Error) {
info(Catch inside TTS);
}
ttscommit;
} catch (Exception::Error) {
info(Catch outside TTS);
}
Shows Catch oustide TTS. Is it intended that the catch inside
the TTS
doesn't catch the exception thrown?
Steeve...
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course Business to business finance Small business
finance Business finance consultant Business finance magazine Business
finance schools
-
YAHOO! GROUPS LINKS
Visit your group Axapta-Knowledge-Village on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
-
-
Yahoo! Mail
Use Photomail to share photos without annoying attachments.
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
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] Re: Throw inside TTS catch outside TTS
Yo Steve,
I commneted the ttsbegin part...Now I could hit 'Catch inside TTS'
try {
// ttsbegin;
try {
throw Exception::Error;
} catch (Exception::Error) {
info(Catch inside TTS);
}
// ttscommit;
} catch (Exception::Error) {
info(Catch outside TTS);
}
so something with tts commands..
did you find out any thing Steve on this???.
As per theory, it should hit the immediate catch level till it finds the
return macth...
subbu
Subrahmanyam, Mamidi [EMAIL PROTECTED] wrote:
Hi Alex,
The concept should be as follows as its the same for C++ or JAVA. I am pretty
sure it should be the case for all object oriented labgugaes.
Whenever a throw occurs in a nested try catch blocks , depending upon the
return type, the Immediate catch should be hit.Since the return type here
is error and the immediate catch block should be hit...
..or
How can we hit the inner exception?...
interesting..let me dig into more
Alexander [EMAIL PROTECTED] wrote:
Hi Steeve,
This is normal Axapta behavior. Here is Developer's giude quote:
If an error is thrown and the first try block does not catch the
exception, the exception is propagated to the next try block, and so
forth. The outermost level is the normal handling of errors in
X++.
Your exception was caught by FIRST try operator.
Alex...
--- In Axapta-Knowledge-Village@yahoogroups.com, Steeve Gilbert
[EMAIL PROTECTED] wrote:
Running this :
try {
ttsbegin;
try {
throw Exception::Error;
} catch (Exception::Error) {
info(Catch inside TTS);
}
ttscommit;
} catch (Exception::Error) {
info(Catch outside TTS);
}
Shows Catch oustide TTS. Is it intended that the catch inside
the TTS
doesn't catch the exception thrown?
Steeve...
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course Business to business finance Small business
finance Business finance consultant Business finance magazine Business
finance schools
-
YAHOO! GROUPS LINKS
Visit your group Axapta-Knowledge-Village on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
-
-
Yahoo! Mail
Use Photomail to share photos without annoying attachments.
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course Business to business finance Small business
finance Business finance consultant Business finance magazine Business
finance schools
-
YAHOO! GROUPS LINKS
Visit your group Axapta-Knowledge-Village on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
-
-
What are the most popular cars? Find out at Yahoo! Autos
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
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] Re: Throw inside TTS catch outside TTS
Something I found on technet...
When an exception is thrown, execution continues at the innermost catch
statement OUTSIDE the outermost ttsbegin/ttscommit. This is because when an
Exception is thrown, all transactions are aborted with an implicit ttsabort
That explains a lot me why we did not go into inner level.
Happy programming...
subbu
Subrahmanyam, Mamidi [EMAIL PROTECTED] wrote:
Yo Steve,
I commneted the ttsbegin part...Now I could hit 'Catch inside TTS'
try {
// ttsbegin;
try {
throw Exception::Error;
} catch (Exception::Error) {
info(Catch inside TTS);
}
// ttscommit;
} catch (Exception::Error) {
info(Catch outside TTS);
}
so something with tts commands..
did you find out any thing Steve on this???.
As per theory, it should hit the immediate catch level till it finds the
return macth...
subbu
Subrahmanyam, Mamidi [EMAIL PROTECTED] wrote:
Hi Alex,
The concept should be as follows as its the same for C++ or JAVA. I am pretty
sure it should be the case for all object oriented labgugaes.
Whenever a throw occurs in a nested try catch blocks , depending upon the
return type, the Immediate catch should be hit.Since the return type here
is error and the immediate catch block should be hit...
..or
How can we hit the inner exception?...
interesting..let me dig into more
Alexander [EMAIL PROTECTED] wrote:
Hi Steeve,
This is normal Axapta behavior. Here is Developer's giude quote:
If an error is thrown and the first try block does not catch the
exception, the exception is propagated to the next try block, and so
forth. The outermost level is the normal handling of errors in
X++.
Your exception was caught by FIRST try operator.
Alex...
--- In Axapta-Knowledge-Village@yahoogroups.com, Steeve Gilbert
[EMAIL PROTECTED] wrote:
Running this :
try {
ttsbegin;
try {
throw Exception::Error;
} catch (Exception::Error) {
info(Catch inside TTS);
}
ttscommit;
} catch (Exception::Error) {
info(Catch outside TTS);
}
Shows Catch oustide TTS. Is it intended that the catch inside
the TTS
doesn't catch the exception thrown?
Steeve...
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course Business to business finance Small business
finance Business finance consultant Business finance magazine Business
finance schools
-
YAHOO! GROUPS LINKS
Visit your group Axapta-Knowledge-Village on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
-
-
Yahoo! Mail
Use Photomail to share photos without annoying attachments.
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course Business to business finance Small business
finance Business finance consultant Business finance magazine Business
finance schools
-
YAHOO! GROUPS LINKS
Visit your group Axapta-Knowledge-Village on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
-
-
What are the most popular cars? Find out at Yahoo! Autos
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course Business to business finance Small business
finance Business finance consultant Business finance magazine Business
finance schools
-
YAHOO! GROUPS LINKS
Visit your group Axapta-Knowledge-Village on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
-
-
Yahoo! Mail
Use Photomail to share photos without annoying attachments.
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
* To unsubscribe from
Re: [Axapta-Knowledge-Village] Multiple branches under single company
Hi , My present implementation also intially thought of going for 4 axapta companies for 4 plants in US. But, however, we used the same company and used financial dimensions and also we did customize the std axapta for firming/BOM etc etc classes along with some reports and we could manages some other stuff with nameing convention by adding the plantID etc etc... Please let me know if you need any specific scenario that is common to both of us so that we can discuss Thanks Regards, Subbu Hemant Kumthekar [EMAIL PROTECTED] wrote: Hi, We have similar kind of requirements and we are leaning more towards using Warehouse and modifying posting by of General Ledger by warehouse(we have not made any decesion yet). Financial Dimensions also helps , but imagine if all divisons are going to use the same customer or vendor we cannot have posting based on that nor Items because Items will be shared. Implementing by warehouse will take care of master planning , forecasting. Hemant snk19692000 [EMAIL PROTECTED] wrote: Hi all, I request comments on how to handle the below scenario. The client has many branches but they belong to the same company. The solution proposed was to use one of the dimensions for branches. In this we faced the following problems. 1.Branch wise number sequences ie. continuity of document numbers for all document types. 1.Branch wise reports viz. Financial Statements like Trial Balance / Balance sheet. 3. How would we restrict access to all data/documents raised with respect to each branch with respect to Add/View/Update/Delete. I.e.. A document raised by a user of one branch should be accessed only by users of that branch whether for viewing / updating / deleting etc. Currently the dimensions are available only for capturing info and reporting purpose. How to handle these requirements in Axapta? The client would not prefer use multiple companies for each branch, since he has centralized payments and purchases. Thanks in advance. Regards Nanda Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Yahoo! Mail Use Photomail to share photos without annoying attachments. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Yahoo! Mail Use Photomail to share photos without annoying attachments. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] Purchase Order - Posting error
Hello, Even the error message says that the warehouse is missing, if we add the ware house, it should be fine. I think the reason for you to get this is, you might have selected 'ware as primary stocking; in inventroy dimensions for that Itemthen we need to have specifiy the ware house...or we get this error... just my thoguths. thanks, subbu G Radhakrishnan [EMAIL PROTECTED] wrote: Thanks --- Per Jakobsen [EMAIL PROTECTED] wrote: You need to add a warehouse in the Purchas order line for the specified Item that you are trying to post www.axaptamodules.com From: G Radhakrishnan [EMAIL PROTECTED] Reply-To: Axapta-Knowledge-Village@yahoogroups.com To: Axapta Group Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Purchase Order - Posting error Date: Fri, 3 Feb 2006 11:39:06 -0800 (PST) MIME-Version: 1.0 X-Originating-IP: 206.190.38.214 X-Sender: [EMAIL PROTECTED] Received: from n6a.bullet.scd.yahoo.com ([66.94.237.40]) by bay0-mc5-f6.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.211); Fri, 3 Feb 2006 11:49:44 -0800 Received: from [66.218.69.1] by n6.bullet.scd.yahoo.com with NNFMP; 03 Feb 2006 19:39:16 - Received: from [66.218.66.32] by t1.bullet.scd.yahoo.com with NNFMP; 03 Feb 2006 19:39:15 - Received: (qmail 67558 invoked from network); 3 Feb 2006 19:39:12 - Received: from unknown (66.218.66.217) by m26.grp.scd.yahoo.com with QMQP; 3 Feb 2006 19:39:12 - Received: from unknown (HELO web51609.mail.yahoo.com) (206.190.38.214) by mta2.grp.scd.yahoo.com with SMTP; 3 Feb 2006 19:39:11 - Received: (qmail 81937 invoked by uid 60001); 3 Feb 2006 19:39:06 - Received: from [81.10.2.170] by web51609.mail.yahoo.com via HTTP; Fri, 03 Feb 2006 11:39:06 PST X-Message-Info: JGTYoYF78jG/DTlN/LnbG23NzLmeR0b/n0OspSv97ek= Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=lima; d=yahoogroups.com;b=tmHs6nGQfM3hAMlaZUuPNWIDh6gPVK40yXGH9rIaqeJfsJRROMwZ7HJmARz4NMo5V1KITnmauwBH+SHjxlM9yhVjRTtXohVg7i0Os1omdqz7DR51vcKAAorJ1o/gTMc1; X-Yahoo-Newman-Property: groups-email X-Apparently-To: Axapta-Knowledge-Village@yahoogroups.com X-eGroups-Msg-Info: 1:12:0:0 X-Yahoo-Profile: gkk_man Mailing-List: list Axapta-Knowledge-Village@yahoogroups.com; contact [EMAIL PROTECTED] Delivered-To: mailing list Axapta-Knowledge-Village@yahoogroups.com List-Id: Axapta-Knowledge-Village.yahoogroups.com Precedence: bulk List-Unsubscribe: mailto:[EMAIL PROTECTED] Return-Path: [EMAIL PROTECTED] X-OriginalArrivalTime: 03 Feb 2006 19:49:44.0958 (UTC) FILETIME=[FB4B29E0:01C628FA] Hi all, What could be the reason for the following error. I tried posting delivery note. Stock dimension 'Warehouse' is primary input/output dimension and must consequently be specified. What is the missing setup for this task? Thanks in advance. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Brings words and photos together (easily) with PhotoMail - it's free and works with Yahoo! Mail. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] New field in custtable and salestable.
Hi Guy3, Here is waht you have to do: 1. create RPD in saleslines also as you want to save it in SalesLines also. 2. Whenever you select custNum, to polulate that value into Salestable, you need to put the below code in SalesTable - IntiFromCustTable; at the end this.RPD = custTable.RPD; 3.In SalesLine, please create a relation; salesLine.RPD == SalesTable.RPD... Thats I have in my head as of now... please let me know if you more info..YAHOO MSN# SUBBU_OH good luck gayatri,s ubbu gayatringayatri [EMAIL PROTECTED] wrote: Hi, I have created a new field called RPD in custtable and salestable of stringedit type. This field is an additional identificaton for the customer and dont have any other impact. The values for RPD in cust table will be unique. I want the RPD field to be there in SalesForm header and sales line and to be saved in salestable and salesline. I have included that in the design in sales header and salesline. When i create a new sales order how can i get value for RPD from custtable for the corresponding customer and display in salesform header and salesline. In which forms, classes, i have to make changes. Regards, Gayatri. Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Yahoo! Autos. Looking for a sweet ride? Get pricing, reviews, more on new and used cars. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] Lookup Form[Period JournalLine]
Hi Memories,
Please dont do that way. and swap them back to original.That will cause
absurb results.
Here is what ou have to do to achive our way..
Classes - LedgerJournalEngine_LedgerPeriodic
Then Overide the method - InitValue(). This actually initiates the default
values for period journals..
Just before Super use _ledgerJournalTrans.FreqCode = PeriodUnit::Month;
So the overall code will look like this:
void initValue(LedgerJournalTrans _ledgerJournalTrans)
{
_ledgerJournalTrans.FreqCode = PeriodUnit::Month;
super(_ledgerJournalTrans);
}
Best of luck...
Subbu
In Memories [EMAIL PROTECTED] wrote:
I swapped the EnumValue for each of day and month and it month is coming by
default now but is there any side effect for doing so.
Varden Morris [EMAIL PROTECTED] wrote: For this particular case, the Lookup
method for the control is overriden and the form AssetLookup is being used to
do the lookup. You should therfore modify this form by dragging and dropping
the required fields from the data source to the grid control.
In Memories [EMAIL PROTECTED] wrote: Hi,
How can i add more columns to a standard lookup form? example in GL, Inventoy
to fixed assets lines journals, want to add more columns to the lookup form
that drops down to select Fixed asset number.
thanks in advance,
IN MEMORIES
-
What are the most popular cars? Find out at Yahoo! Autos
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course Business to business finance Small business
finance Business finance consultant Business finance magazine Business
finance schools
-
YAHOO! GROUPS LINKS
Visit your group Axapta-Knowledge-Village on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
-
Varden Morris
Senior Developer
WellPoint Systems Inc.
Microsoft Gold Certified Partner
(403) 444-5848 direct
(403) 444-3900 main
(403) 615-1604 cell
www.wellpoint.ca
[EMAIL PROTECTED]
-
What are the most popular cars? Find out at Yahoo! Autos
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course Business to business finance Small business
finance Business finance consultant Business finance magazine Business
finance schools
-
YAHOO! GROUPS LINKS
Visit your group Axapta-Knowledge-Village on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
-
IN MEMORIES
-
Yahoo! Autos. Looking for a sweet ride? Get pricing, reviews, more on new and
used cars.
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course Business to business finance Small business
finance Business finance consultant Business finance magazine Business
finance schools
-
YAHOO! GROUPS LINKS
Visit your group Axapta-Knowledge-Village on the web.
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!?
With a free 1 GB, there's more in store with Yahoo! Mail.
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
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] Lookup Form
Hi Memories, Yes. Our friend Varden is correct as I was searching in diferent place...AssetTable... Actualy, the lookup method was overriden in this case so as to point the lookup form..This is just adding more columns..for this.. So in future, if you want to do similar coding, you may want to find out if the lookup method is overiden, if not, look for the fields group in auto lookup . Unlike, if you want to filter or create a run time lookup, then we need to code using SysTableLookup class.etc. I think you might have already did..,but I am just sharing my exp... Happy Coding.. Best of luck.. Takecare, subu Varden Morris [EMAIL PROTECTED] wrote: You are most welcome. Could you please give me some more details on where to find this control for the journal line of period journals? I looked through the entire form and I think I am missing it. In Memories [EMAIL PROTECTED] wrote: Thanks Varden for the reply i didnt even know about this form. It worked. before i tried AssetTable lookup group but didnt work. one more thing if you please: in the peridic Journal line the Unit (Days, Months, Year) is based on a Enum PeriodicUnit which by default is coming Days whenever adding new line, how to change this default to Months? Its not a property ya?? just coding? Again thanks Varden Morris [EMAIL PROTECTED] wrote: For this particular case, the Lookup method for the control is overriden and the form AssetLookup is being used to do the lookup. You should therfore modify this form by dragging and dropping the required fields from the data source to the grid control. In Memories [EMAIL PROTECTED] wrote: Hi, How can i add more columns to a standard lookup form? example in GL, Inventoy to fixed assets lines journals, want to add more columns to the lookup form that drops down to select Fixed asset number. thanks in advance, IN MEMORIES - What are the most popular cars? Find out at Yahoo! Autos [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - Varden Morris Senior Developer WellPoint Systems Inc. Microsoft Gold Certified Partner (403) 444-5848 direct (403) 444-3900 main (403) 615-1604 cell www.wellpoint.ca [EMAIL PROTECTED] - What are the most popular cars? Find out at Yahoo! Autos [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - IN MEMORIES - Bring words and photos together (easily) with PhotoMail - it's free and works with Yahoo! Mail. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - Varden Morris Senior Developer WellPoint Systems Inc. Microsoft Gold Certified Partner (403) 444-5848 direct (403) 444-3900 main (403) 615-1604 cell www.wellpoint.ca [EMAIL PROTECTED] - Yahoo! Autos. Looking for a sweet ride? Get pricing, reviews, more on new and used cars. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant
Re: [Axapta-Knowledge-Village] Lookup Form
Hi Varden,
Why dont we suggest in doing
Classes - LedgerJournalEngine_LedgerPeriodic so that it will not change
whereever LedgerJournalTrans is used.. I think I recommend in doing the period
class so that it applied for thet periodic journal only...
Varden Morris [EMAIL PROTECTED] wrote:
Hi In Memories,
The only side effect I can see from doing this is that everywhere this enum
is used the default value will be month. One Alternative is to insert the line
of code shown below in the initValue method on the ledgerJournalTrans data
source in the form. In order to get around the hard coding you could add a
parameter value to the GL module and set the required value from there. This
however involves some amount of coding.
Please note that if you want this to be the default whenever a line is
inserted in the ledgerJournalTrans table from any location in the application
the best place to place the code is in the initValue method of the
ledgerJournalTrans table.
void initValue()
{
super();
ledgerJournalTrans.FreqCode = PeriodUnit::Month;
ledgerJournalEngine.initValue(ledgerJournalTrans);
}
In Memories [EMAIL PROTECTED] wrote:
G.L module ---PeriodicPeriodic Journal - Lines Field Name = Unit
, next to the Currency.
Form Name = LedgerJounalTransPeriodic
in the general tab, Grid, ComboBox:LedgerJournalTrans_FreqCode, freqCode is
based in an Enum.
Thanks
Varden Morris [EMAIL PROTECTED] wrote:
You are most welcome. Could you please give me some more details on where to
find this control for the journal line of period journals? I looked through the
entire form and I think I am missing it.
In Memories [EMAIL PROTECTED] wrote: Thanks Varden for the reply i didnt
even know about this form. It worked. before i tried AssetTable lookup group
but didnt work.
one more thing if you please: in the peridic Journal line the Unit (Days,
Months, Year) is based on a Enum PeriodicUnit which by default is coming Days
whenever adding new line, how to change this default to Months? Its not a
property ya?? just coding?
Again thanks
Varden Morris [EMAIL PROTECTED] wrote:
For this particular case, the Lookup method for the control is overriden and
the form AssetLookup is being used to do the lookup. You should therfore modify
this form by dragging and dropping the required fields from the data source to
the grid control.
In Memories [EMAIL PROTECTED] wrote: Hi,
How can i add more columns to a standard lookup form? example in GL, Inventoy
to fixed assets lines journals, want to add more columns to the lookup form
that drops down to select Fixed asset number.
thanks in advance,
IN MEMORIES
-
What are the most popular cars? Find out at Yahoo! Autos
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course Business to business finance Small business
finance Business finance consultant Business finance magazine Business
finance schools
-
YAHOO! GROUPS LINKS
Visit your group Axapta-Knowledge-Village on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
-
Varden Morris
Senior Developer
WellPoint Systems Inc.
Microsoft Gold Certified Partner
(403) 444-5848 direct
(403) 444-3900 main
(403) 615-1604 cell
www.wellpoint.ca
[EMAIL PROTECTED]
-
What are the most popular cars? Find out at Yahoo! Autos
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course Business to business finance Small business
finance Business finance consultant Business finance magazine Business
finance schools
-
YAHOO! GROUPS LINKS
Visit your group Axapta-Knowledge-Village on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
-
IN MEMORIES
-
Bring words and photos together (easily) with
PhotoMail - it's free and works with Yahoo! Mail.
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
-
YAHOO! GROUPS LINKS
Visit your group Axapta-Knowledge-Village on the web.
To unsubscribe from this group, send an
Re: [Axapta-Knowledge-Village] Lookup Form
Hi , There are many ways to try..But I am not sure if I uderstood your question correctly. but you may want to try this... You can go that Table ( AssetTable) - field groups - Auto Lookup( but this will change everywhere there is the lookup or you need to override lookup on the form..The code is already there in DEV guide... Please let me know if you need more help.. thanks, subbu In Memories [EMAIL PROTECTED] wrote: Hi, How can i add more columns to a standard lookup form? example in GL, Inventoy to fixed assets lines journals, want to add more columns to the lookup form that drops down to select Fixed asset number. thanks in advance, IN MEMORIES - What are the most popular cars? Find out at Yahoo! Autos [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Bring words and photos together (easily) with PhotoMail - it's free and works with Yahoo! Mail. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] Year end closing/opening: Serious Error
Strange!. no one expericed this issue...Am I singled out on this issue? -Subbu Subrahmanyam, Mamidi [EMAIL PROTECTED] wrote: Hi, I am trying to perform Fiscal Year End Opening transactions and got the following error: Error: Total of the transactions in the year is not 0.00. Total is -0.03. This is a serious error, Run \Check\ on ledger transactions. I debugged the code for the class and the summ of all the trasactions with certain criterias is becoming -0.03 for AmountMST. and then, it calls Currency::amount(-0.03) which returns - 0.03... Does anyone have thoughts on this.. I summed up all the vouchers and the balance is exactly zero for each and every voicher... However, I have the following thoughts in my mind.. 1. Will consistency check with Fix will work?. I checked the code for LedgerTrans - CheckFixBalance, what it does is, it creates the unbalanced amounts records with reverse sign...in ledgerTrans ..but is not creating any records in ledgerDimbalance etc etc did anyone do this ?. I am trying to see if anyone have tried this.. any opinions will be welcome. Thanks Regards, Subbu - Bring words and photos together (easily) with PhotoMail - it's free and works with Yahoo! Mail. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Bring words and photos together (easily) with PhotoMail - it's free and works with Yahoo! Mail. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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: (BUG}[Axapta-Knowledge-Village] Limit on attaching POs to a blanket Order
Hi Friends,
MS accpeted QueryBuildRange fails at 474 nested loopsSo we can not attach
more than 474 POs for a blanket order. If anyone wants the support email, I can
forward
Thanks,
subbu
Subrahmanyam, Mamidi [EMAIL PROTECTED] wrote:
Spent 9 nonstop hours.
I found the root cause..A bug in QueryBuoldRange class..Reported to MS..
-Subbu
Subrahmanyam, Mamidi [EMAIL PROTECTED] wrote:
Hi,
I am running into some issues when I select a Blanket order and then click on
Enquiries - Attached Purchase orders.
I am getting SQL trace error saying that can not select a record in
purchTable.
I traced the code. and I am curious what is the maximum limit of attached
purchase orders?.
I deleted random orders from 700 attached orders to 474 orders, then I don;t
get any SQL trace errors.
does anyone have any idea on the limit or any idea on the below SQL error?
//
ErrorMessage (11:51:35) Cannot select a record in Purchase table
(PurchTable). Purchase order: , .
The SQL database has issued an error.
Info Message (11:51:35) SQL error description: [Microsoft][ODBC SQL
Server Driver][SQL Server]Line 1: Incorrect syntax near '('.
Info Message (11:51:35) SQL statement: SELECT
A.PURCHID,A.PURCHNAME,A.ORDERACCOUNT,A.INVOICEACCOUNT,A.FREIGHTZONE,A.EMAIL,A.DELIVERYDATE,A.DELIVERYTYPE,A.CURRENCYCODE,A.PAYMENT,A.CASHDISC,A.PURCHPLACER,A.VENDGROUP,A.LINEDISC,A.DISCPERCENT,A.DIMENSION,A.DIMENSION2_,A.DIMENSION3_,A.DIMENSION4_,A.PRICEGROUPID,A.MULTILINEDISC,A.ENDDISC,A.DELIVERYADDRESS,A.TAXGROUP,A.DLVTERM,A.DLVMODE,A.PURCHSTATUS,A.MARKUPGROUP,A.PURCHASETYPE,A.URL,A.POSTINGPROFILE,A.TRANSACTIONCODE,A.DELIVERYZIPCODE,A.DLVCOUNTY,A.DLVCOUNTRY,A.DLVSTATE,A.SETTLEVOUCHER,A.DELIVERYNAME,A.COVSTATUS,A.PAYMENTSCHED,A.ONETIMEVENDOR,A.RETURNITEMNUM,A.FREIGHTSLIPTYPE,A.DOCUMENTSTATUS,A.CONTACTPERSONID,A.DEL_SUMINVOICEID,A.DEL_SUMPACKINGSLIPID,A.DEL_SUMPURCHASEORDERID,A.INVENTLOCATIONID,A.DEL_SUMRECEIPTSLISTID,A.ITEMBUYERGROUPID,A.PROJID,A.PURCHPOOLID,A.VATNUM,A.PORT,A.DEL_PURCHASEORDERORIGINALS,A.DEL_PURCHASEORDERCOPIES,A.INCLTAX,A.NUMBERSEQUENCEGROUP,A.LANGUAGEID,A.AUTOSUMMARYMODULETYPE,A.TRANSPORT,A.PRINTMODULETYPE,A.PAYMMODE,A.PAYMSPEC,A.FIXEDDUEDATE,A.DELIVERYCITY,A.DEL
IVERYSTREET,A.STATPROCID,A.REFDLVZIPCODE,A.VENDORREF,A.INTERCOMPANYCOMPANYID,A.INTERCOMPANYSALESID,A.INTERCOMPANYORDER,A.SUNBLANKETPOEFFECTIVITYSTART,A.SUNBOLNUMBER,A.SUNDLXORDERSTATUS,A.SUNSEARCHTRADEAGREEMENTS,A.CREATEDDATE,A.RECID
FROM PURCHTABLE A WHERE ((DATAAREAID=?) AND
((PURCHID=?)
OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID
Re: [Axapta-Knowledge-Village] Limit on attaching POs to a blanket Order
Spent 9 nonstop hours.
I found the root cause..A bug in QueryBuoldRange class..Reported to MS..
-Subbu
Subrahmanyam, Mamidi [EMAIL PROTECTED] wrote:
Hi,
I am running into some issues when I select a Blanket order and then click on
Enquiries - Attached Purchase orders.
I am getting SQL trace error saying that can not select a record in
purchTable.
I traced the code. and I am curious what is the maximum limit of attached
purchase orders?.
I deleted random orders from 700 attached orders to 474 orders, then I don;t
get any SQL trace errors.
does anyone have any idea on the limit or any idea on the below SQL error?
//
ErrorMessage (11:51:35) Cannot select a record in Purchase table
(PurchTable). Purchase order: , .
The SQL database has issued an error.
Info Message (11:51:35) SQL error description: [Microsoft][ODBC SQL
Server Driver][SQL Server]Line 1: Incorrect syntax near '('.
Info Message (11:51:35) SQL statement: SELECT
A.PURCHID,A.PURCHNAME,A.ORDERACCOUNT,A.INVOICEACCOUNT,A.FREIGHTZONE,A.EMAIL,A.DELIVERYDATE,A.DELIVERYTYPE,A.CURRENCYCODE,A.PAYMENT,A.CASHDISC,A.PURCHPLACER,A.VENDGROUP,A.LINEDISC,A.DISCPERCENT,A.DIMENSION,A.DIMENSION2_,A.DIMENSION3_,A.DIMENSION4_,A.PRICEGROUPID,A.MULTILINEDISC,A.ENDDISC,A.DELIVERYADDRESS,A.TAXGROUP,A.DLVTERM,A.DLVMODE,A.PURCHSTATUS,A.MARKUPGROUP,A.PURCHASETYPE,A.URL,A.POSTINGPROFILE,A.TRANSACTIONCODE,A.DELIVERYZIPCODE,A.DLVCOUNTY,A.DLVCOUNTRY,A.DLVSTATE,A.SETTLEVOUCHER,A.DELIVERYNAME,A.COVSTATUS,A.PAYMENTSCHED,A.ONETIMEVENDOR,A.RETURNITEMNUM,A.FREIGHTSLIPTYPE,A.DOCUMENTSTATUS,A.CONTACTPERSONID,A.DEL_SUMINVOICEID,A.DEL_SUMPACKINGSLIPID,A.DEL_SUMPURCHASEORDERID,A.INVENTLOCATIONID,A.DEL_SUMRECEIPTSLISTID,A.ITEMBUYERGROUPID,A.PROJID,A.PURCHPOOLID,A.VATNUM,A.PORT,A.DEL_PURCHASEORDERORIGINALS,A.DEL_PURCHASEORDERCOPIES,A.INCLTAX,A.NUMBERSEQUENCEGROUP,A.LANGUAGEID,A.AUTOSUMMARYMODULETYPE,A.TRANSPORT,A.PRINTMODULETYPE,A.PAYMMODE,A.PAYMSPEC,A.FIXEDDUEDATE,A.DELIVERYCITY,A.DEL
IVERYSTREET,A.STATPROCID,A.REFDLVZIPCODE,A.VENDORREF,A.INTERCOMPANYCOMPANYID,A.INTERCOMPANYSALESID,A.INTERCOMPANYORDER,A.SUNBLANKETPOEFFECTIVITYSTART,A.SUNBOLNUMBER,A.SUNDLXORDERSTATUS,A.SUNSEARCHTRADEAGREEMENTS,A.CREATEDDATE,A.RECID
FROM PURCHTABLE A WHERE ((DATAAREAID=?) AND
((PURCHID=?)
OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID
[Axapta-Knowledge-Village] Limit on attaching POs to a blanket Order
Hi,
I am running into some issues when I select a Blanket order and then click on
Enquiries - Attached Purchase orders.
I am getting SQL trace error saying that can not select a record in
purchTable.
I traced the code. and I am curious what is the maximum limit of attached
purchase orders?.
I deleted random orders from 700 attached orders to 474 orders, then I don;t
get any SQL trace errors.
does anyone have any idea on the limit or any idea on the below SQL error?
//
ErrorMessage (11:51:35) Cannot select a record in Purchase table
(PurchTable). Purchase order: , .
The SQL database has issued an error.
Info Message (11:51:35) SQL error description: [Microsoft][ODBC SQL
Server Driver][SQL Server]Line 1: Incorrect syntax near '('.
Info Message (11:51:35) SQL statement: SELECT
A.PURCHID,A.PURCHNAME,A.ORDERACCOUNT,A.INVOICEACCOUNT,A.FREIGHTZONE,A.EMAIL,A.DELIVERYDATE,A.DELIVERYTYPE,A.CURRENCYCODE,A.PAYMENT,A.CASHDISC,A.PURCHPLACER,A.VENDGROUP,A.LINEDISC,A.DISCPERCENT,A.DIMENSION,A.DIMENSION2_,A.DIMENSION3_,A.DIMENSION4_,A.PRICEGROUPID,A.MULTILINEDISC,A.ENDDISC,A.DELIVERYADDRESS,A.TAXGROUP,A.DLVTERM,A.DLVMODE,A.PURCHSTATUS,A.MARKUPGROUP,A.PURCHASETYPE,A.URL,A.POSTINGPROFILE,A.TRANSACTIONCODE,A.DELIVERYZIPCODE,A.DLVCOUNTY,A.DLVCOUNTRY,A.DLVSTATE,A.SETTLEVOUCHER,A.DELIVERYNAME,A.COVSTATUS,A.PAYMENTSCHED,A.ONETIMEVENDOR,A.RETURNITEMNUM,A.FREIGHTSLIPTYPE,A.DOCUMENTSTATUS,A.CONTACTPERSONID,A.DEL_SUMINVOICEID,A.DEL_SUMPACKINGSLIPID,A.DEL_SUMPURCHASEORDERID,A.INVENTLOCATIONID,A.DEL_SUMRECEIPTSLISTID,A.ITEMBUYERGROUPID,A.PROJID,A.PURCHPOOLID,A.VATNUM,A.PORT,A.DEL_PURCHASEORDERORIGINALS,A.DEL_PURCHASEORDERCOPIES,A.INCLTAX,A.NUMBERSEQUENCEGROUP,A.LANGUAGEID,A.AUTOSUMMARYMODULETYPE,A.TRANSPORT,A.PRINTMODULETYPE,A.PAYMMODE,A.PAYMSPEC,A.FIXEDDUEDATE,A.DELIVERYCITY,A.DEL
IVERYSTREET,A.STATPROCID,A.REFDLVZIPCODE,A.VENDORREF,A.INTERCOMPANYCOMPANYID,A.INTERCOMPANYSALESID,A.INTERCOMPANYORDER,A.SUNBLANKETPOEFFECTIVITYSTART,A.SUNBOLNUMBER,A.SUNDLXORDERSTATUS,A.SUNSEARCHTRADEAGREEMENTS,A.CREATEDDATE,A.RECID
FROM PURCHTABLE A WHERE ((DATAAREAID=?) AND
((PURCHID=?)
OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?))
OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?))
OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?))
OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?))
OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?))
OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?))
OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?))
OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?))
OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?))
OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?))
OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?))
OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?))
OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?))
OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?))
OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?))
OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?))
OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?))
OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?))
OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?))
OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?))
OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?))
OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?))
OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?))
OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?))
OR (PURCHID=?)) OR (PURCHID=?)) OR
(PURCHID=?)) OR (PURCHID=?)) OR (PURCHID=?)) OR
Re: [Axapta-Knowledge-Village] User logout already but still appear as online
Hi Hardi,Did you solve this problem ?. if not, you may want to try this... 1. Stop AOS 2. delete AXDAT.UDB file. 3. restart AOS. When you restart AOS, the new and correct version of AXDAT.UDB will be created.I feel your AXDAT.UDB file is corrupted...I think this you should solve your problem as it solved the same issue in our env. Good luck.thanks, subbuSetiaji [EMAIL PROTECTED] wrote: Strange..Did you give user name and password to other user,that can login from other computer with the same user name?It is true,that axapta dont have 'refresh' button.But for the user,we can see someone login to AOS or not without close the main menu.Usually,if we create new menu,it wont appear until we close the main menu,and reopen.-setiaji-.Hardi wrote:Hi everyoneI use Axapta 3.0 with AOS, my user logout already but still appear as online on the Administration/online users and he is still counted as one of the user consuming number of concurrent users (meaning: the system then will not let another user to login since total concurrent users already exceeds the maximum)What is the problem?Thanks regardsHardi T Yahoo! Photos Ring in the New Year with Photo Calendars. Add photos, events, holidays, whatever. Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Table Locking Mechanism
Hi, I am trying to understand how When Table locking occurs, what are the possible conditions for the Table dead lock to occur in Axapta.For Example:I will have5 Fat clients connected to DB. I will fire Inventory recalculate to operate on 'InventTrans' table, will this cuase any Table locking or any similar things. Of course, I am gonna have SQL trace inventigated.or Is there any way I can simulate a table locking using X++ with 2 users locking each other?.Any ideas will be helpful to me.Thanks, Subbu Yahoo! Shopping Find Great Deals on Gifts at Yahoo! Shopping Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. 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: [Axapta-Knowledge-Village] Re: MST Round-off error in Invoice Approval Journal
Hi Irving,Did you guy make any customization to increase the number of decimals?.However, we have these kind of problems earlier. How we did solve is:You may want to go to Parameters of the particular module: Goto - Settlement and then try to change max penny differences so that code should not ( like 0.001) if the MST differece = 0.1 . Please change the settling for the instalnece to 0.001 ( howber form shows 0.00 ). It should solve your problem. I bet on this.Let me know if this does not solve. thanks, subbuIrving [EMAIL PROTECTED] wrote: Hi Sun FenThank you for your suggestion, but it didn't solve my problem.It's when I post general expence invoices in the Invoice Approval Journal, that I get a penny difference.RegardsIrving--- In Axapta-Knowledge-Village@yahoogroups.com, Sun Fen Chen [EMAIL PROTECTED] wrote: Hi Irving, After you fetch the voucher (after fetching it will not balance), you have to click Function - Purchase order. When you post the Invoice approval journal, have you clicked Function - Purchase order in the Invoice journal line? This will post the purchase order invoice from Invoice journal. Regards, Sun Fen On 12/5/05, Irving [EMAIL PROTECTED] wrote: Dear All Thanks for the input, but I'm afraid it didn't solve my problem. The different account are set up correctly so I'm able to post penny differences. I can find round-off setup at GL/Setup/Exchange Rates, but I can't find any setup concerning secondary currency. Any input will be welcome, Thanks Regards koffidan --- In Axapta-Knowledge-Village@yahoogroups.com, Tarek Saleh [EMAIL PROTECTED] wrote: Dear Asrar The penny differances must have an account in GL befor setup its parameter thes account is located in the system accounts setup (GL\setup\posting\system accounts) and u should define a ledger account for thes penny differance system account befor setup the parameter, and about the folowing error you should check the vendor posting profile and the vendor setup for currency. Feed back after testing All the best Tarek saleh Asrar Ahamed [EMAIL PROTECTED] wrote: Hi, Set up penny difference field under GL/Parameters/Ledger. Thanks, Irving [EMAIL PROTECTED] wrote: I have posted an invoice in the Invoice Register Journal: Then I go to the Invoice Approval Journal and fetch the posted voucher/invoice. When I post the Invoice Approval Journal I get the following error message: Message (08:23:39) Voucher 'god-00159', date '09-11-2005', account '7521', amount currency '0,01', amount MST '0,01', alternative amount '0,00', currency 'DKK', text '' Voucher 'god-00159', date '09-11-2005', account '7521', amount currency '-25,25', amount MST '-25,25', alternative amount '0,00', currency 'DKK', text '' Voucher 'god-00159', date '09-11-2005', account '7521', amount currency '13,88', amount MST '13,88', alternative amount '0,00', currency 'DKK', text '' Voucher 'god-00159', date '09-11-2005', account '7521', amount currency '11,38', amount MST '11,38', alternative amount '0,00', currency 'DKK', text '' Voucher 'god-00159', date '09-11-2005', account '7411', amount currency '-126,25', amount MST '-126,25', alternative amount '0,00', currency 'DKK', text 'test' Voucher 'god-00159', date '09-11-2005', account '7412', amount currency '126,25', amount MST '126,25', alternative amount '0,00', currency 'DKK', text 'test' Voucher 'god-00159', date '09-11-2005', account '7421', amount currency '-101,00', amount MST '-101,00', alternative amount '0,00', currency 'DKK', text 'test' Voucher 'god-00159', date '09-11-2005', account '3731', amount currency '55,50', amount MST '55,50', alternative amount '0,00', currency 'DKK', text 'test' Voucher 'god-00159', date '09-11-2005', account '6321', amount currency '45,50', amount MST '45,50', alternative amount '0,00', currency 'DKK', text 'test' Voucher 'god-00159', date '09-11-2005', account '3781', amount currency '0,00', amount MST '-0,02', alternative amount '0,00', currency 'DKK', text 'รredifferencer, Bilag god-0015' The transactions on voucher 'god-00159' do not balance as per '09- 11- 2005'. (Company currency: 0,00 - secondary currency: 0,00) Posting has been cancelled. I don't understand why I get this message, please help, thanks. Regards - To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre. - Win a Yahoo! Vespa NEW - Yahoo! Cars has 3 Vespa LX125s to be won Enter Now! Sharing the knowledge on Axapta. - YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. 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: [Axapta-Knowledge-Village] Re: MST Round-off error in Invoice Approval Journal
Hi Irving,Did you guy make any customization to increase the number of decimals?.However, we have these kind of problems earlier. How we did solve is:You may want to go to Parameters of the particular module: Goto - Settlement and then try to change max penny differences so that code should not ( like 0.001) if the MST differece = 0.1 . Please change the settling for the instalnece to 0.001 ( howber form shows 0.00 ). It should solve your problem. I bet on this.Let me know if this does not solve. thanks, subbuIrving [EMAIL PROTECTED] wrote: Hi Sun FenThank you for your suggestion, but it didn't solve my problem.It's when I post general expence invoices in the Invoice Approval Journal, that I get a penny difference.RegardsIrving--- In Axapta-Knowledge-Village@yahoogroups.com, Sun Fen Chen [EMAIL PROTECTED] wrote: Hi Irving, After you fetch the voucher (after fetching it will not balance), you have to click Function - Purchase order. When you post the Invoice approval journal, have you clicked Function - Purchase order in the Invoice journal line? This will post the purchase order invoice from Invoice journal. Regards, Sun Fen On 12/5/05, Irving [EMAIL PROTECTED] wrote: Dear All Thanks for the input, but I'm afraid it didn't solve my problem. The different account are set up correctly so I'm able to post penny differences. I can find round-off setup at GL/Setup/Exchange Rates, but I can't find any setup concerning secondary currency. Any input will be welcome, Thanks Regards koffidan --- In Axapta-Knowledge-Village@yahoogroups.com, Tarek Saleh [EMAIL PROTECTED] wrote: Dear Asrar The penny differances must have an account in GL befor setup its parameter thes account is located in the system accounts setup (GL\setup\posting\system accounts) and u should define a ledger account for thes penny differance system account befor setup the parameter, and about the folowing error you should check the vendor posting profile and the vendor setup for currency. Feed back after testing All the best Tarek saleh Asrar Ahamed [EMAIL PROTECTED] wrote: Hi, Set up penny difference field under GL/Parameters/Ledger. Thanks, Irving [EMAIL PROTECTED] wrote: I have posted an invoice in the Invoice Register Journal: Then I go to the Invoice Approval Journal and fetch the posted voucher/invoice. When I post the Invoice Approval Journal I get the following error message: Message (08:23:39) Voucher 'god-00159', date '09-11-2005', account '7521', amount currency '0,01', amount MST '0,01', alternative amount '0,00', currency 'DKK', text '' Voucher 'god-00159', date '09-11-2005', account '7521', amount currency '-25,25', amount MST '-25,25', alternative amount '0,00', currency 'DKK', text '' Voucher 'god-00159', date '09-11-2005', account '7521', amount currency '13,88', amount MST '13,88', alternative amount '0,00', currency 'DKK', text '' Voucher 'god-00159', date '09-11-2005', account '7521', amount currency '11,38', amount MST '11,38', alternative amount '0,00', currency 'DKK', text '' Voucher 'god-00159', date '09-11-2005', account '7411', amount currency '-126,25', amount MST '-126,25', alternative amount '0,00', currency 'DKK', text 'test' Voucher 'god-00159', date '09-11-2005', account '7412', amount currency '126,25', amount MST '126,25', alternative amount '0,00', currency 'DKK', text 'test' Voucher 'god-00159', date '09-11-2005', account '7421', amount currency '-101,00', amount MST '-101,00', alternative amount '0,00', currency 'DKK', text 'test' Voucher 'god-00159', date '09-11-2005', account '3731', amount currency '55,50', amount MST '55,50', alternative amount '0,00', currency 'DKK', text 'test' Voucher 'god-00159', date '09-11-2005', account '6321', amount currency '45,50', amount MST '45,50', alternative amount '0,00', currency 'DKK', text 'test' Voucher 'god-00159', date '09-11-2005', account '3781', amount currency '0,00', amount MST '-0,02', alternative amount '0,00', currency 'DKK', text 'รredifferencer, Bilag god-0015' The transactions on voucher 'god-00159' do not balance as per '09- 11- 2005'. (Company currency: 0,00 - secondary currency: 0,00) Posting has been cancelled. I don't understand why I get this message, please help, thanks. Regards - To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre. - Win a Yahoo! Vespa NEW - Yahoo! Cars has 3 Vespa LX125s to be won Enter Now! Sharing the knowledge on Axapta. - YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. 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: [Axapta-Knowledge-Village] Delete Packing Slip Updated (Delivered) Status Sales orders
Hi Brandon, Just I am curious, why did you change std axapta process?. is theren't anyway to achive your setup or packingslip process without changing the std classes?. We also change packingslip process,Inventory movement process , Sales Order process, QOC , EDI, ~84 total interfaces ( which are coupled with Std classes)...( Just to name some ), but always without removing the existing functionality. Thanks Regards, subbuBrandon George [EMAIL PROTECTED] wrote: Well, in standard Axapta that would work, but that does not work with the current setup because we have changed standard axapta, packslip update process. I guess we will have to adjust our code so that applying a negative qty and then re-post the sales order. -Brandon From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of In MemoriesSent: Thursday, November 10, 2005 1:39 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: Re: [Axapta-Knowledge-Village] Delete Packing Slip Updated (Delivered) Status Sales orders since its deliverd u have to make a reverse transaction with a negative quantity, return, to cancel what has been delivered.Brandon George [EMAIL PROTECTED] wrote: Hello All, We need to know how to cancel / delete a Sales Order in Axapta, where it has been told in error, that the Sales Order has shipped. You can't just simply sit on the Record and delete it, so I am wondering does anyone know how I can delete / remove a Delivered status Sales Order (Also know as Packing Slip Update) Any help on this would be great! Plus this is a good one, and anyone who contributes, write something, I will do my best to list you on the blog entry post that I will post about this issue. -Brandon IN MEMORIES Yahoo! FareChase - Search multiple travel sites in one click. Yahoo! FareChase - Search multiple travel sites in one click. Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. 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: [Axapta-Knowledge-Village] Delete Packing Slip Updated (Delivered) Status Sales orders
Hi Brandon, I would do the following way. I will select the So to be backed out. on the QTY tab, I will log the same Qty ( delivered ) with negative qty under deliver now column. I will post the packingslip with 'delivernow' parameter selected. so now the shipped qty nullified so it reverts back to open order. now I use Salesline - functions - delivery remainder and click on 'cancel qty' to cancel the SO officially Best of luck. thanks Regards, subbuBrandon George [EMAIL PROTECTED] wrote: Along these same lines, how would one take a Sales Order back from being packing slip updated, back to a quote status? I assume you would have to remove all the journal entries associated with it. Has anyone every done this before? Either way, my first question should be easier. This one we can work out later! From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Brandon GeorgeSent: Wednesday, November 09, 2005 2:29 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] Delete Packing Slip Updated (Delivered) Status Sales orders Hello All, We need to know how to cancel / delete a Sales Order in Axapta, where it has been told in error, that the Sales Order has shipped. You can't just simply sit on the Record and delete it, so I am wondering does anyone know how I can delete / remove a Delivered status Sales Order (Also know as Packing Slip Update) Any help on this would be great! Plus this is a good one, and anyone who contributes, write something, I will do my best to list you on the blog entry post that I will post about this issue. -Brandon Yahoo! FareChase - Search multiple travel sites in one click. Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. 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: [Axapta-Knowledge-Village] Delete Packing Slip Updated (Delivered) Status Sales orders
Brandon, Regarding the second question, I think when it becomes 'opne order' , you can just switch back to 'quation' or 'journal' status. I think there is no harm just from my exp. thansk, subbuBrandon George [EMAIL PROTECTED] wrote: Along these same lines, how would one take a Sales Order back from being packing slip updated, back to a quote status? I assume you would have to remove all the journal entries associated with it. Has anyone every done this before? Either way, my first question should be easier. This one we can work out later! From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Brandon GeorgeSent: Wednesday, November 09, 2005 2:29 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] Delete Packing Slip Updated (Delivered) Status Sales orders Hello All, We need to know how to cancel / delete a Sales Order in Axapta, where it has been told in error, that the Sales Order has shipped. You can't just simply sit on the Record and delete it, so I am wondering does anyone know how I can delete / remove a Delivered status Sales Order (Also know as Packing Slip Update) Any help on this would be great! Plus this is a good one, and anyone who contributes, write something, I will do my best to list you on the blog entry post that I will post about this issue. -Brandon Yahoo! FareChase - Search multiple travel sites in one click. Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. 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: [Axapta-Knowledge-Village] Harry ! this one for u: Journal Upload
Hi Priyanka, You need to assign the inventdim programatically if you have to attach inventdim. I remeber Girish posted some sample code in the past.. the code looks like below... Tablename yourTable; InventDim inventDim; ; inventDim.clear(); inventDim.configId = 'configid' // coming from external source like flat file; inventDim.inventLocationId = 'your ware house';//coming from external source like flat file; your can attach your InventDimId to yor table like this yourTable.inventDimId = InventDim::findorcreate(inventDim).InventDimId; this is just for your infoPlease browse the forum for the more details . thanks, subbu Priyank Krishna [EMAIL PROTECTED] wrote: I have to upload the Profit Loss Inventory Journal for initialising the item stock on-hand in a fresh system. I tried it to upload with sample code mentioned in your site.The code is fabulous but I could not upload Inventory Journal since there is InventDim Datasource is attached additionally with its transactions form. Pls helphow to tackle it. Thanks in advance ! Priyank Enjoy this Diwali with Y! India Click here Yahoo! FareChase - Search multiple travel sites in one click. Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. 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: [Axapta-Knowledge-Village] Harry ! this one for u: Journal Upload
Hi Giri, How are you man?. still busy??. I think , PL journal would be a good way to include opening stock as it generates item receipt or issue will be generated in the inventory trasactions I hope she is including cost price etc etc... Any other ideas?. Thanks, subbuGirish Bhatkal [EMAIL PROTECTED] wrote: Priyank, are you sure you want to use Profit/lossjournal to include the opening inventory in thesystem. I feel using Movement journal is a moreappropriate one to include the opening inventory. It would be better if other people also givestheir opinions on which journal to be used.--- "Subrahmanyam, Mamidi" [EMAIL PROTECTED] wrote: Hi Priyanka, You need to assign the inventdim programatically if you have to attach inventdim. I remeber Girish posted some sample code in the past.. the code looks like below... Tablename yourTable; InventDim inventDim; ; inventDim.clear(); inventDim.configId = 'configid' // coming from external source like flat file; inventDim.inventLocationId = 'your ware house';//coming from external source like flat file; your can attach your InventDimId to yor table like this yourTable.inventDimId = InventDim::findorcreate(inventDim).InventDimId; this is just for your infoPlease browse the forum for the more details . thanks, subbu Priyank Krishna [EMAIL PROTECTED] wrote: I have to upload the Profit Loss Inventory Journal for initialising the item stock on-hand in a fresh system. I tried it to upload with sample code mentioned in your site.The code is fabulous but I could not upload Inventory Journal since there is InventDim Datasource is attached additionally with its transactions form. Pls help how to tackle it. Thanks in advance ! Priyank- Enjoy this Diwali with Y! India Click here Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKSVisit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.- - Yahoo! FareChase - Search multiple travel sites in one click. ___ How much free photo storage do you get? Store your holiday snaps for FREE with Yahoo! Photos http://uk.photos.yahoo.com Yahoo! FareChase - Search multiple travel sites in one click. Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. 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: [Axapta-Knowledge-Village] Harry ! this one for u: Journal Upload
I have read it again the material. I can conclude that we can use any one of them. You are right Giri. Because when we use Movement journal, we have an option of using offset GL account so that she can post it to Inventory GL account and offset GL account -subbuGirish Bhatkal [EMAIL PROTECTED] wrote: Priyank, are you sure you want to use Profit/lossjournal to include the opening inventory in thesystem. I feel using Movement journal is a moreappropriate one to include the opening inventory. It would be better if other people also givestheir opinions on which journal to be used.--- "Subrahmanyam, Mamidi" [EMAIL PROTECTED] wrote: Hi Priyanka, You need to assign the inventdim programatically if you have to attach inventdim. I remeber Girish posted some sample code in the past.. the code looks like below... Tablename yourTable; InventDim inventDim; ; inventDim.clear(); inventDim.configId = 'configid' // coming from external source like flat file; inventDim.inventLocationId = 'your ware house';//coming from external source like flat file; your can attach your InventDimId to yor table like this yourTable.inventDimId = InventDim::findorcreate(inventDim).InventDimId; this is just for your infoPlease browse the forum for the more details . thanks, subbu Priyank Krishna [EMAIL PROTECTED] wrote: I have to upload the Profit Loss Inventory Journal for initialising the item stock on-hand in a fresh system. I tried it to upload with sample code mentioned in your site.The code is fabulous but I could not upload Inventory Journal since there is InventDim Datasource is attached additionally with its transactions form. Pls help how to tackle it. Thanks in advance ! Priyank- Enjoy this Diwali with Y! India Click here Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKSVisit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.- - Yahoo! FareChase - Search multiple travel sites in one click. ___ How much free photo storage do you get? Store your holiday snaps for FREE with Yahoo! Photos http://uk.photos.yahoo.com Yahoo! FareChase - Search multiple travel sites in one click. Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. 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: [Axapta-Knowledge-Village] Export Project Node-Is there any solution
Oops. I think i forgot to add this peice to export the project node before that and also, did u observe a bug here. I forgot to set the flag on the export function hence it overrites everytime the file.
Please find the code which exports the Project Node and exports all the childs by appending the file.
static void Job31(Args _args){ ProjectNode ProjectNode; ProjectNode Father; ProjectNode Child; TreeNodeIterator Iterator; TreeNodeIterator childNodeIterator;
;
ProjectNode = infolog.projectRootNode(); ProjectNode = ProjectNode.AOTfindChild("Shared").AOTfindChild('SUN0001_IntelligentFirm'); // this node I know its name
ProjectNode.treeNodeExport('X:\\SUBBU\\ITEM\\SUN0001_IntelligentFirm.xpo'); Father = ProjectNode.getRunNode();
Iterator = Father.AOTiterator();
Child = Iterator.next(); //
while (Child) { child.treeNodeExport('X:\\SUBBU\\Item\\SUN0001_IntelligentFirm.xpo',1); // Subbu, pls appened the content Child = Iterator.next();
}
Father.treeNodeRelease(); Father = NULL;
if(Child) { Child.treeNodeRelease(); Child = NULL; }}
axapta tecnical consultant [EMAIL PROTECTED] wrote:
Thanks a lot Subbu...This code is working but I found there is only one diff that wwhen u import this xpo. Project node is not there
Thanks Again..
Maverick
- Original Message -----
From: Subrahmanyam, Mamidi
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Thursday, October 06, 2005 12:30 PM
Subject: Re: [Axapta-Knowledge-Village] Export Project Node-Is there any solution
Ok. I have tested the below code for you. It works for me and brings all the childs. You buy me a beer. I have wasted some time on this.
static void Job31(Args _args){ ProjectNode ProjectNode; ProjectNode Father; ProjectNode Child; TreeNodeIterator Iterator; TreeNodeIterator childNodeIterator;
;
ProjectNode = infolog.projectRootNode(); ProjectNode = ProjectNode.AOTfindChild("Shared").AOTfindChild('Abra'); // this node I know its name Father = ProjectNode.getRunNode();
Iterator = Father.AOTiterator();
Child = Iterator.next(); // while (Child) {
child.treeNodeExport('X:\\SUBBU\\Item\\Abra.xpo'); Child = Iterator.next();
}
Father.treeNodeRelease(); Father = NULL;
if(Child) { Child.treeNodeRelease(); Child = NULL; }}axapta tecnical consultant [EMAIL PROTECTED] wrote:
Hello Subu,
Thanks for your help.
I had already used projectNode and treeNode, but if you see the output of the code, itdoent have anything in it.
You can verify the original export file with the xpo created with this code.
Ihad not found any solution, please find the right way to export the project.
Thanks
Maverick
- Original Message -
From: Subrahmanyam, Mamidi
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Wednesday, October 05, 2005 8:06 PM
Subject: RE: [Axapta-Knowledge-Village] Export Project Node-Is there any solution
Hello Axapta Techo functional,
pls use this piece code for ur task...
static void forFun(Args _args){
ProjectNode projNode; TreeNode treeNode; str strPath; ;
treeNode = infolog.projectRootNode(); projNode = treeNode.AOTfindChild('Shared').AOTfindChild('SUN0001_IntelligentFirm');
info(projNode.treeNodeName());
strPath = "X:\\Subbu\\Item\\" + projNode.treeNodeName() + '.XPO';
info(strPath);
projNode.treeNodeExport(strPath );
}
Thanks,
subbu
Axapta TechnoFunctional [EMAIL PROTECTED] wrote:
Hi anil,
I have tried each and every option..I had played with this form but not able todo.Other than this i had also tried it with treenode class and projectNode class.
Please any one can help me in this regards.
I will be very thankfull, please come with proper code, becz i had tried all the options.
Thanks
Maverick
ANIL OZAY [EMAIL PROTECTED] wrote:
Hi Maverick,
When you click an Axapta project and export, youยll see Axapta Export Dialog. When you right click and click setup, you can see that, this form is ยSysExportDialogย. Browse this form. These form has ยExportย method for you ;)
Good luck,
Anil Ozay
Software Engineer
MCP,MBSCP
From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of axapta tecnical consultantSent: Tuesday, October 04, 2005 3:21 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] Export Project Node
Hello All,
Is it possible to export project from code.
If yes then please provide the code or any hint.
Thanks.
Maverick
Bu e-posta ve muhtemel eklerinde verilen bilgiler kisiye ozel ve gizlidir. Anadolu Bilisim Hizmetleri A.S. bu mesajin icerigi ve ekleri ile ilgili hicbir hukuki sorumluluk kabul etmez. Yetkili alicilardan degilseniz, bu mesajin herhangi bir sekilde ifsa edilmesi, kullanilmasi, kopyalanmasi, yayilmasi veya mesajda yer alan hususlarla ilgili olarak herhangi bir islem yapilmasi kesinlikle yasaktir. Bu durumda hemen mesajin gondericisini bilgilendiriniz ve mesaji sisteminizden siliniz. Elektronik mesajlar uzerinde yapilmis herhangi bir degisiklik veya sonuclari uzerinde
Re: [Axapta-Knowledge-Village] Export Project Node-Is there any solution
Ok. I have tested the below code for you. It works for me and brings all the childs.
static void Job31(Args _args){ ProjectNode ProjectNode; ProjectNode Father; ProjectNode Child; TreeNodeIterator Iterator; TreeNodeIterator childNodeIterator;
;
ProjectNode = infolog.projectRootNode(); ProjectNode = ProjectNode.AOTfindChild("Shared").AOTfindChild('Abra'); // this node I know its name Father = ProjectNode.getRunNode();
Iterator = Father.AOTiterator();
Child = Iterator.next(); // while (Child) {
child.treeNodeExport('X:\\SUBBU\\Item\\Abra.xpo'); Child = Iterator.next();
}
Father.treeNodeRelease(); Father = NULL;
if(Child) { Child.treeNodeRelease(); Child = NULL; }}axapta tecnical consultant [EMAIL PROTECTED] wrote:
Hello Subu,
Thanks for your help.
I had already used projectNode and treeNode, but if you see the output of the code, itdoent have anything in it.
You can verify the original export file with the xpo created with this code.
Ihad not found any solution, please find the right way to export the project.
Thanks
Maverick
- Original Message -----
From: Subrahmanyam, Mamidi
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Wednesday, October 05, 2005 8:06 PM
Subject: RE: [Axapta-Knowledge-Village] Export Project Node-Is there any solution
Hello Axapta Techo functional,
pls use this piece code for ur task...
static void forFun(Args _args){
ProjectNode projNode; TreeNode treeNode; str strPath; ;
treeNode = infolog.projectRootNode(); projNode = treeNode.AOTfindChild('Shared').AOTfindChild('SUN0001_IntelligentFirm');
info(projNode.treeNodeName());
strPath = "X:\\Subbu\\Item\\" + projNode.treeNodeName() + '.XPO';
info(strPath);
projNode.treeNodeExport(strPath );
}
Thanks,
subbu
Axapta TechnoFunctional [EMAIL PROTECTED] wrote:
Hi anil,
I have tried each and every option..I had played with this form but not able todo.Other than this i had also tried it with treenode class and projectNode class.
Please any one can help me in this regards.
I will be very thankfull, please come with proper code, becz i had tried all the options.
Thanks
Maverick
ANIL OZAY [EMAIL PROTECTED] wrote:
Hi Maverick,
When you click an Axapta project and export, youยll see Axapta Export Dialog. When you right click and click setup, you can see that, this form is ยSysExportDialogย. Browse this form. These form has ยExportย method for you ;)
Good luck,
Anil Ozay
Software Engineer
MCP,MBSCP
From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of axapta tecnical consultantSent: Tuesday, October 04, 2005 3:21 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] Export Project Node
Hello All,
Is it possible to export project from code.
If yes then please provide the code or any hint.
Thanks.
Maverick
Bu e-posta ve muhtemel eklerinde verilen bilgiler kisiye ozel ve gizlidir. Anadolu Bilisim Hizmetleri A.S. bu mesajin icerigi ve ekleri ile ilgili hicbir hukuki sorumluluk kabul etmez. Yetkili alicilardan degilseniz, bu mesajin herhangi bir sekilde ifsa edilmesi, kullanilmasi, kopyalanmasi, yayilmasi veya mesajda yer alan hususlarla ilgili olarak herhangi bir islem yapilmasi kesinlikle yasaktir. Bu durumda hemen mesajin gondericisini bilgilendiriniz ve mesaji sisteminizden siliniz. Elektronik mesajlar uzerinde yapilmis herhangi bir degisiklik veya sonuclari uzerinde Anadolu Bilisim Hizmetleri A.S.'nin sorumlulugu yoktur. Ayrica, e-posta mesajlarindaki hata ve/veya eksiklikten, virus icermesinden ve bilgisayar sisteminize verebilecegi herhangi bir zarardan Sirket olarak sorumluluk kabul etmeyecegimizi de bildiririz.This e-mail and any information included within any
attached document are private and confidential and intended solely for the addressee. Anadolu Bilisim Hizmetleri A.S. does not accept any legal responsibility for the contents of this message and any attached documents. If you are not the intended addressee, it is forbidden to disclose, use, copy, or forward any information within the message or engage in any activity regarding the contents of this message. In such case please notify the sender and delete the message from your system immediately. Anadolu Bilisim Hizmetleri A.S. also denounces any legal responsibility for any amendments made on the electronic message and the outcome of these amendments, as well as any error and/or defect, virus content and any damage that may be given to your system.
Find your next car at Yahoo! Canada Autos
Yahoo! for GoodClick here to donate to the Hurricane Katrina relief effort.
Yahoo! for Good
Click here to donate to the Hurricane Katrina relief effort.
Sharing the knowledge on Axapta.
SPONSORED LINKS
Business finance course
Business to business finance
Sm
Re: [Axapta-Knowledge-Village] Export Project Node-Is there any solution
Ok. I have tested the below code for you. It works for me and brings all the childs. You buy me a beer. I have wasted some time on this.
static void Job31(Args _args){ ProjectNode ProjectNode; ProjectNode Father; ProjectNode Child; TreeNodeIterator Iterator; TreeNodeIterator childNodeIterator;
;
ProjectNode = infolog.projectRootNode(); ProjectNode = ProjectNode.AOTfindChild("Shared").AOTfindChild('Abra'); // this node I know its name Father = ProjectNode.getRunNode();
Iterator = Father.AOTiterator();
Child = Iterator.next(); // while (Child) {
child.treeNodeExport('X:\\SUBBU\\Item\\Abra.xpo'); Child = Iterator.next();
}
Father.treeNodeRelease(); Father = NULL;
if(Child) { Child.treeNodeRelease(); Child = NULL; }}axapta tecnical consultant [EMAIL PROTECTED] wrote:
Hello Subu,
Thanks for your help.
I had already used projectNode and treeNode, but if you see the output of the code, itdoent have anything in it.
You can verify the original export file with the xpo created with this code.
Ihad not found any solution, please find the right way to export the project.
Thanks
Maverick
- Original Message -----
From: Subrahmanyam, Mamidi
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Wednesday, October 05, 2005 8:06 PM
Subject: RE: [Axapta-Knowledge-Village] Export Project Node-Is there any solution
Hello Axapta Techo functional,
pls use this piece code for ur task...
static void forFun(Args _args){
ProjectNode projNode; TreeNode treeNode; str strPath; ;
treeNode = infolog.projectRootNode(); projNode = treeNode.AOTfindChild('Shared').AOTfindChild('SUN0001_IntelligentFirm');
info(projNode.treeNodeName());
strPath = "X:\\Subbu\\Item\\" + projNode.treeNodeName() + '.XPO';
info(strPath);
projNode.treeNodeExport(strPath );
}
Thanks,
subbu
Axapta TechnoFunctional [EMAIL PROTECTED] wrote:
Hi anil,
I have tried each and every option..I had played with this form but not able todo.Other than this i had also tried it with treenode class and projectNode class.
Please any one can help me in this regards.
I will be very thankfull, please come with proper code, becz i had tried all the options.
Thanks
Maverick
ANIL OZAY [EMAIL PROTECTED] wrote:
Hi Maverick,
When you click an Axapta project and export, youยll see Axapta Export Dialog. When you right click and click setup, you can see that, this form is ยSysExportDialogย. Browse this form. These form has ยExportย method for you ;)
Good luck,
Anil Ozay
Software Engineer
MCP,MBSCP
From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of axapta tecnical consultantSent: Tuesday, October 04, 2005 3:21 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] Export Project Node
Hello All,
Is it possible to export project from code.
If yes then please provide the code or any hint.
Thanks.
Maverick
Bu e-posta ve muhtemel eklerinde verilen bilgiler kisiye ozel ve gizlidir. Anadolu Bilisim Hizmetleri A.S. bu mesajin icerigi ve ekleri ile ilgili hicbir hukuki sorumluluk kabul etmez. Yetkili alicilardan degilseniz, bu mesajin herhangi bir sekilde ifsa edilmesi, kullanilmasi, kopyalanmasi, yayilmasi veya mesajda yer alan hususlarla ilgili olarak herhangi bir islem yapilmasi kesinlikle yasaktir. Bu durumda hemen mesajin gondericisini bilgilendiriniz ve mesaji sisteminizden siliniz. Elektronik mesajlar uzerinde yapilmis herhangi bir degisiklik veya sonuclari uzerinde Anadolu Bilisim Hizmetleri A.S.'nin sorumlulugu yoktur. Ayrica, e-posta mesajlarindaki hata ve/veya eksiklikten, virus icermesinden ve bilgisayar sisteminize verebilecegi herhangi bir zarardan Sirket olarak sorumluluk kabul etmeyecegimizi de bildiririz.This e-mail and any information included within any
attached document are private and confidential and intended solely for the addressee. Anadolu Bilisim Hizmetleri A.S. does not accept any legal responsibility for the contents of this message and any attached documents. If you are not the intended addressee, it is forbidden to disclose, use, copy, or forward any information within the message or engage in any activity regarding the contents of this message. In such case please notify the sender and delete the message from your system immediately. Anadolu Bilisim Hizmetleri A.S. also denounces any legal responsibility for any amendments made on the electronic message and the outcome of these amendments, as well as any error and/or defect, virus content and any damage that may be given to your system.
Find your next car at Yahoo! Canada Autos
Yahoo! for GoodClick here to donate to the Hurricane Katrina relief effort.
Yahoo! for Good
Click here to donate to the Hurricane Katrina relief effort.
Sharing the knowledge on Axapta.
YAHOO! GROUPS LINKS
Visit your group "Axapta-Knowledge-Village" on the web.
To unsubscribe from this group, send an email to:[EMAIL PROTECTED]
Your u
RE: [Axapta-Knowledge-Village] Export Project Node-Is there any solution
Hello Axapta Techo functional,
pls use this piece code for ur task...
static void forFun(Args _args){
ProjectNode projNode; TreeNode treeNode; str strPath; ;
treeNode = infolog.projectRootNode(); projNode = treeNode.AOTfindChild('Shared').AOTfindChild('SUN0001_IntelligentFirm');
info(projNode.treeNodeName());
strPath = "X:\\Subbu\\Item\\" + projNode.treeNodeName() + '.XPO';
info(strPath);
projNode.treeNodeExport(strPath );
}
Thanks,
subbu
Axapta TechnoFunctional [EMAIL PROTECTED] wrote:
Hi anil,
I have tried each and every option..I had played with this form but not able todo.Other than this i had also tried it with treenode class and projectNode class.
Please any one can help me in this regards.
I will be very thankfull, please come with proper code, becz i had tried all the options.
Thanks
Maverick
ANIL OZAY [EMAIL PROTECTED] wrote:
Hi Maverick,
When you click an Axapta project and export, youยll see Axapta Export Dialog. When you right click and click setup, you can see that, this form is ยSysExportDialogย. Browse this form. These form has ยExportย method for you ;)
Good luck,
Anil Ozay
Software Engineer
MCP,MBSCP
From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of axapta tecnical consultantSent: Tuesday, October 04, 2005 3:21 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] Export Project Node
Hello All,
Is it possible to export project from code.
If yes then please provide the code or any hint.
Thanks.
Maverick
Bu e-posta ve muhtemel eklerinde verilen bilgiler kisiye ozel ve gizlidir. Anadolu Bilisim Hizmetleri A.S. bu mesajin icerigi ve ekleri ile ilgili hicbir hukuki sorumluluk kabul etmez. Yetkili alicilardan degilseniz, bu mesajin herhangi bir sekilde ifsa edilmesi, kullanilmasi, kopyalanmasi, yayilmasi veya mesajda yer alan hususlarla ilgili olarak herhangi bir islem yapilmasi kesinlikle yasaktir. Bu durumda hemen mesajin gondericisini bilgilendiriniz ve mesaji sisteminizden siliniz. Elektronik mesajlar uzerinde yapilmis herhangi bir degisiklik veya sonuclari uzerinde Anadolu Bilisim Hizmetleri A.S.'nin sorumlulugu yoktur. Ayrica, e-posta mesajlarindaki hata ve/veya eksiklikten, virus icermesinden ve bilgisayar sisteminize verebilecegi herhangi bir zarardan Sirket olarak sorumluluk kabul etmeyecegimizi de bildiririz.This e-mail and any information included within any
attached document are private and confidential and intended solely for the addressee. Anadolu Bilisim Hizmetleri A.S. does not accept any legal responsibility for the contents of this message and any attached documents. If you are not the intended addressee, it is forbidden to disclose, use, copy, or forward any information within the message or engage in any activity regarding the contents of this message. In such case please notify the sender and delete the message from your system immediately. Anadolu Bilisim Hizmetleri A.S. also denounces any legal responsibility for any amendments made on the electronic message and the outcome of these amendments, as well as any error and/or defect, virus content and any damage that may be given to your system.
Find your next car at Yahoo! Canada Autos
Yahoo! for Good
Click here to donate to the Hurricane Katrina relief effort.
Sharing the knowledge on Axapta.
SPONSORED LINKS
Business finance course
Business to business finance
Small business finance
Business finance consultant
Business finance magazine
Business finance uk
YAHOO! GROUPS LINKS
Visit your group "Axapta-Knowledge-Village" on the web.
To unsubscribe from this group, send an email to:[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Microsoft๏ฟฝ Business Solutions - Axapta๏ฟฝ 3.0 Bill of Materials
Hi, if anyone has this documentation on this, can you share with me?. The manual for T L has very basic info. Your help is grateful to me. Thanks Regards, Subbu Yahoo! for Good Click here to donate to the Hurricane Katrina relief effort. Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. 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: [Axapta-Knowledge-Village] SalesFormLetter.insertJournal()
Hello Brandon,
I believe this should solve it..You can browse similar code on AOT\classedd..
ttsbegin; numberSeq = this.allocateNumAndVoucher(); [number, voucher] = this.getNumAndVoucher();
if (this.updateNow()) {
this.postUpdate();
TransactionLog::create(this.transactionLogType(),this.transactionLogTxt()); ttscommit; } else
{
throw error
ttsabort; // Subbu
}
Brandon George [EMAIL PROTECTED] wrote:
Hello All!
I am writing custom Intercompany code. The "Out of the Box" Axapta Intercompany code works nothing like my company wants it too. Not to get to much into detail here, but that is that. So I have wrote a class, and created two tables that will handle the Intercompany Sales Order process.
Anyway there is a piece of code in the SalesFormLetter, the insertJournal() method. This method, to me, is setup strange:
ttsbegin; numberSeq = this.allocateNumAndVoucher(); [number, voucher] = this.getNumAndVoucher();
if (this.updateNow()) {
this.postUpdate();
TransactionLog::create(this.transactionLogType(),this.transactionLogTxt()); ttscommit; } else
throw error
What is strange to me is why the ttsbegin: and ttscommit are not on the same "level" or scope? I have seen this cause issues, and cause an unbalanaced TTSbegin / TTSCommit error, which makes the user have to close out and start a new session.
This happens of course when the Else is fired because the updateNow() returns false. Reason of course is the ttscommit is never reached, I believe. I was wondering if anyone has ever had any experince with this method, and why this method must execute like it does?
thanks,
Brandon
Yahoo! for Good
Click here to donate to the Hurricane Katrina relief effort.
Sharing the knowledge on Axapta.
YAHOO! GROUPS LINKS
Visit your group "Axapta-Knowledge-Village" on the web.
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: [Axapta-Knowledge-Village] SalesFormLetter.insertJournal()
Hi John,
Thank you for the nice email. But, can you tell me why there is an inbalance between ttsbegin and ttscommit levels?
I understand its a nested tts . ttsabort which I put will accout for immediate ttscommit. I guess it will not account for other ttsbegin nesteded loops.
May be , I need to do more invenstigation.
thanks,
subbuJohn Lindsay [EMAIL PROTECTED] wrote:
The ttsabort will not execute after the throw error. But after a through reading of the Axapta Transaction documentation, you will discover the true intent of the original code.
This is a nested ttsbegin.The insertJournal method starts with a ttsbeginthis.allocateNumAndVoucher contains a ttsbeginthis.getNumAndVoucher contains a ttsbeginthis.updateNow could have a ttsbegin (method overrides FormLetter method)this.PostUpdate has a ttsbegin
Nothing is committed until the final ttscommit
The throw statement automatically aborts the current transaction.
ttsbegin; numberSeq = this.allocateNumAndVoucher(); [number, voucher] = this.getNumAndVoucher();
if (this.updateNow()) {
this.postUpdate();
TransactionLog::create(this.transactionLogType(),this.transactionLogTxt()); ttscommit; } else
{
throw error
ttsabort;
}
Transactionsfrom the Axapta Developers Guide
A transaction is a logical unit of work. Transactions - all or nothing operations - ensure data integrity.
Consider the example where you want to update all prices in the system. If the system broke down or was aborted in the middle of the operation, some records would have been updated and others not. Performing the update inside a transaction guarantees that either everything is completed or nothing is done at all.
Another aspect of transactions is the capacity to lock records (or tables). If, for instance, someone is updating prices and another is using the prices at the same time, the result will be unknown (is it the price before or after the update?). Transactions ensure that, depending on the concrete alterations of the records, users get consistent data from the database (that is either all or no prices are altered). An even more difficult to manage example is the ยlost updateย:
Time
Task A
Task B
1.
-
-
2.
FETCH Record
-
3.
-
FETCH Record
4.
UPDATE Record
-
5.
-
UPDATE Record
In this example, task A reads a record, performs some changes and updates the record. Meanwhile task B reads the (original) record and performs some changes and updates the record afterwards. The update in task A at time 4 is lost. The solution is to lock the records (or tables) during update transactions (insert, update, and delete). This can be done by using the select forupdate statement.
ttsbegin
To mark the beginning of a transaction, you use the ttsbegin statement. This ensures data integrity and guarantees that all updates performed until the transaction ends (by ttscommit or ttsabort) are consistent (all or none).
TransactionBegin = ttsbegin ;
Starting a transaction is not meaningful if it is not ended, which is done by ttscommit or ttsabort. Therefore, there is only one coherent example illustrating those three commands. This example can be found below ttsabort.
ttscommit
To mark the successful end of a transaction, you use the ttscommit statement. This ends and commits a transaction. MorphX guarantees that a committed transaction will be performed according to intentions.
TransactionCommit = ttscommit ;
Transaction blocks may be nested
Statements between ttsbegin and ttscommit may include one or more transaction blocks, like the example below.
ttsbegin;
// some statements
ttsbegin;
//statements
ttscommit;
ttscommit;
In such cases you should note that nothing is actually committed until the successful exit from the final ttscommit.
ttsabort
The ttsabort command allows you to explicitly discard all changes in the current transaction. This results in the database being rolled back to the initial state: Nothing will have been changed.
TransactionAbort = ttsabort ;
Typically you will use this if you have detected that the user want to break the current job. Using ttsabort makes sure that the database is consistent.
Note
Most often the best solution is to use exception handling instead of ttsabort. The throw statement automatically aborts the current transaction.
From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Brandon GeorgeSent: Tuesday, September 27, 2005 9:37 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] SalesFormLetter.insertJournal()
Sabbu,
I believe you are right... that is the best approach...
From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Subrahmanyam, MamidiSent: Tuesday, September 27, 2005 11:31 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: Re: [Axapta-Knowledge-Village] SalesFormLetter.insertJournal()
Hello Brandon,
I believe this should solve it..You can browse similar code on AOT\classedd..
RE: [Axapta-Knowledge-Village] SalesFormLetter.insertJournal()
Hi John,
do you agree if I modify this way or do you see any problems?
// ttsbegin; (comented out )
(I don;t know why MS wants to hit this ttscommit for every condition.)
numberSeq = this.allocateNumAndVoucher(); [number, voucher] = this.getNumAndVoucher();
if (this.updateNow()) {
ttsbegin; // Subbu
this.postUpdate();
TransactionLog::create(this.transactionLogType(),this.transactionLogTxt()); ttscommit; } else
{
throw error
}
any thoguhts?
John Lindsay [EMAIL PROTECTED] wrote:
The ttsabort will not execute after the throw error. But after a through reading of the Axapta Transaction documentation, you will discover the true intent of the original code.
This is a nested ttsbegin.The insertJournal method starts with a ttsbeginthis.allocateNumAndVoucher contains a ttsbeginthis.getNumAndVoucher contains a ttsbeginthis.updateNow could have a ttsbegin (method overrides FormLetter method)this.PostUpdate has a ttsbegin
Nothing is committed until the final ttscommit
The throw statement automatically aborts the current transaction.
ttsbegin; numberSeq = this.allocateNumAndVoucher(); [number, voucher] = this.getNumAndVoucher();
if (this.updateNow()) {
this.postUpdate();
TransactionLog::create(this.transactionLogType(),this.transactionLogTxt()); ttscommit; } else
{
throw error
ttsabort;
}
Transactionsfrom the Axapta Developers Guide
A transaction is a logical unit of work. Transactions - all or nothing operations - ensure data integrity.
Consider the example where you want to update all prices in the system. If the system broke down or was aborted in the middle of the operation, some records would have been updated and others not. Performing the update inside a transaction guarantees that either everything is completed or nothing is done at all.
Another aspect of transactions is the capacity to lock records (or tables). If, for instance, someone is updating prices and another is using the prices at the same time, the result will be unknown (is it the price before or after the update?). Transactions ensure that, depending on the concrete alterations of the records, users get consistent data from the database (that is either all or no prices are altered). An even more difficult to manage example is the ยlost updateย:
Time
Task A
Task B
1.
-
-
2.
FETCH Record
-
3.
-
FETCH Record
4.
UPDATE Record
-
5.
-
UPDATE Record
In this example, task A reads a record, performs some changes and updates the record. Meanwhile task B reads the (original) record and performs some changes and updates the record afterwards. The update in task A at time 4 is lost. The solution is to lock the records (or tables) during update transactions (insert, update, and delete). This can be done by using the select forupdate statement.
ttsbegin
To mark the beginning of a transaction, you use the ttsbegin statement. This ensures data integrity and guarantees that all updates performed until the transaction ends (by ttscommit or ttsabort) are consistent (all or none).
TransactionBegin = ttsbegin ;
Starting a transaction is not meaningful if it is not ended, which is done by ttscommit or ttsabort. Therefore, there is only one coherent example illustrating those three commands. This example can be found below ttsabort.
ttscommit
To mark the successful end of a transaction, you use the ttscommit statement. This ends and commits a transaction. MorphX guarantees that a committed transaction will be performed according to intentions.
TransactionCommit = ttscommit ;
Transaction blocks may be nested
Statements between ttsbegin and ttscommit may include one or more transaction blocks, like the example below.
ttsbegin;
// some statements
ttsbegin;
//statements
ttscommit;
ttscommit;
In such cases you should note that nothing is actually committed until the successful exit from the final ttscommit.
ttsabort
The ttsabort command allows you to explicitly discard all changes in the current transaction. This results in the database being rolled back to the initial state: Nothing will have been changed.
TransactionAbort = ttsabort ;
Typically you will use this if you have detected that the user want to break the current job. Using ttsabort makes sure that the database is consistent.
Note
Most often the best solution is to use exception handling instead of ttsabort. The throw statement automatically aborts the current transaction.
From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Brandon GeorgeSent: Tuesday, September 27, 2005 9:37 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] SalesFormLetter.insertJournal()
Sabbu,
I believe you are right... that is the best approach...
From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Subrahmanyam, MamidiSent: Tuesday, September 27, 2005 11:31 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: Re: [Axapta-Knowledge-Village]
Re: [Axapta-Knowledge-Village] Form refresh from a class
HI Girish,
For somereasons, the village is taking more than 20 hours to post a message.
I am respoting it again.
I opened the SalesTable form. and I hit F5 on 'DoRefresh' method and it brings up the salesTable form
Same thing, I could do using as follows.
TreeNode treeNode =TreeNode::findNode('Forms').AOTfindChild('SalesTable').AOTfindChild('Methods').AOTFindChild('DoRefresh');
treeNode.AOTRun();
treeNode.treeNodeRelease();treeNode = NULL;
Can you please inform me if you wanted to run the dRefresh method...
yours buddy,
subbuGirish Bhatkal [EMAIL PROTECTED] wrote:
Hi Subbu,suppose i want to call the doRefresh method on thesalesTable form, from a class/job thenTreeNode treeNode =TreeNode::findNode('Forms').AOTfindChild('SalesTable');treeNode.AOTrefresh();treeNode.treeNodeRelease();treeNode = NULL;but what should i do to include the method "doRefresh"from the salesTable. i tried a few things but i geterror that the Treenode object is not initialised. ihad modification astreenode = TreeNode::findNode('forms').AOTfindChild('\\salesTable\methods\doRefresh');can you tell me where am i going wrong.thankscheers,Girish --- "Subrahmanyam, Mamidi" <[EMAIL PROTECTED]>wrote: Hi Girish, How are you doing?. what if I use to get the same result as follows. // TreeNode
treeNode = TreeNode::findNode('Forms').AOTfindChild('Form'); ; treeNode.AOTrefresh(); treeNode.treeNodeRelease(); treeNode = NULL; /*/ is there any problem if I use this?. BTW, I will send you a seperate email with all info. your buddy, subbu Girish Bhatkal <[EMAIL PROTECTED]>wrote: hi, i understand the way to send the element and refresh. But what if we want to update a datasource of a form (which is already open). In this case the data is updated in a class but the class is not directly called from the form . --- wb <[EMAIL PROTECTED]>wrote: - Hi Girish, You can see for example form LedgerJournalTable, at method init
journalFormTable = new LedgerJournalFormTable(element); LedgerJournalTable ledgerJournalTable() { return ledgerJournalTable; } hope this help you, wb 2005/9/21, Girish Bhatkal <[EMAIL PROTECTED]>: Hi Guys,I have a bookrefresh method on a form (which refreshes the datasource). Is it possible in someway to run this method from a class (provided we know the FORM name). I understand the way where in we get the caller name when the class is run from the form and execute the method. But in my case the class which is going to call this method on the form is not directly called from the Form.i tried to use the sysGlobalCache but i
could not get the solution. can anyone let me know how can we achieve this.thanks,cheers, Girish Sharing the knowledge on Axapta.SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance uk - YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject
to the Yahoo! Terms of Service. -___ Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance uk - YAHOO! GROUPS LINKSVisit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:
[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.- - Yahoo! for Good Click here to donate to the Hurricane Katrina relief effort. ___ To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre. http://uk.security.yahoo.com Yahoo! Groups Sponsor ~-- Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home pagehttp://us.click.yahoo.com/dpRU5A/wUILAA/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/
Yahoo! for Good
Click here to donate to the Hurricane Katrina relief effort.
Sharin
Re: [Axapta-Knowledge-Village] Security Keys
Hi I can copy both of your hints into one email:
static void SubbuTest(Args _args){
DictSecuritykey c;AccessRightsList accessRightsList;
;
while select accessRightsList where accessRightsList.recordType == AccessRecordType::SecurityKey
{
c = new DictsecurityKey(accessRightsList.id); info(strfmt('ID = %1 - Name = %2',accessRightsList.id, c.name()));
}
}Akash [EMAIL PROTECTED] wrote:
Hi,Try using DictSecurityKey Class.DictSecuritykey c = new DictsecurityKey(1);print c.name();pause;Hope this will help you.regardsAkash--- mohit rajvanshy [EMAIL PROTECTED] wrote:-Hi EveryOne,Is from axapta we can able to list out the securitykeys like a select statement we can get the data froma table. Let me explain...From AccessRightsList table i am able to get the Id'sfor security keys but if i want to list out those Id'sname is it possible? I can go and see those id's namesin AOT but is there any way to list them out in aprint statement?Thanx in advance...MohitRegardsMohit Rajvanshy
__ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.comSharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance
Small business finance Businessfinance consultant Business finance magazine Business finance
uk - YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on theweb. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo!Terms of Service. - __ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com__Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
Sharing the knowledge on Axapta.
YAHOO! GROUPS LINKS
Visit your group "Axapta-Knowledge-Village" on the web.
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: [Axapta-Knowledge-Village] Hiding confidential data in axapta
May be someone can use 'textBuffer' class to map the field to encrypt and de crypt...I never tried though.. I am just giving an hint from Technet.. Thanks, subbu"Dyachenko, Dmitry" [EMAIL PROTECTED] wrote: No. RLS wonยt help in this case. Using RLS doesnยt encrypt the data itself, it just restricts Ax users from watching some data. From: Axapta-Knowledge-Village@yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com] On Behalf Of Girish BhatkalSent: Tuesday, September 20, 2005 12:14 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: Re: [Axapta-Knowledge-Village] Hiding confidential data in axapta i believe the record level security should helpachieve what you are looking for.cheers,Girish--- "Harry (Harshawardhan Deshpande"[EMAIL PROTECTED] wrote: hi I seem to remember a discussion that said it is possible encrypt a string. If it is not available then it should be easy to write your own function regards harry tj_jayson [EMAIL PROTECTED] wrote: Hi All, Is it possible to hide (or encrypt) salary data field from viewing from everybody other than HR manager? This includes stopping viewing from Table browser and backend SQL data base by IT department. Thanks JJT Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance uk - YAHOO! GROUPS LINKSVisit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.- - Yahoo! for Good Click here to donate to the Hurricane Katrina relief effort. ___ How much free photo storage do you get? Store your holiday snaps for FREE with Yahoo! Photos http://uk.photos.yahoo.com Yahoo! for Good Click here to donate to the Hurricane Katrina relief effort. Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Does anyone know: ProjTable
Hi, Stragely when we come in the monring, we have our ProjTable Table got emptied in Production. We have no access to AOT and the DB admin says everything was fine and could have no reasons for this. Does anyone have any idea of suddely deletion of data in Axapta?. What could be the reasons?. We ( developers )don;t have access to AOT The log does not give me any info ( axapta log ). Any thoughts. Thanks, subbu__Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. 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: [Axapta-Knowledge-Village] Report Template
He he he he he.( joking...) Ok. Please duplicate the 'InternalList' template. Save it. and then restore it. Now compile. It won;t complain again about the compilation Thanks, subbuVarden Morris [EMAIL PROTECTED] wrote: Hi Jason I had the same problem before and I am not sure what is the cause. You can work this problem by creating a new report template then drag and drop the root object(s) from the original report template to the new one. It will then compile. In your case drag and drop page header object. yifath1 [EMAIL PROTECTED] wrote: Hi All I Am having a little bit of a problem Creating a Report Template ,I Have Pretty much Duplicated the "InternalList" Template.This exact copy does not Compile ,as it is not accepting any of the elements is there somewhere that I need to go to declare something ,or is there something that I am missing Any help would be Greatly appreciate Thanks JasonVarden MorrisSenior DeveloperWellPoint Systems Inc.(403) 444-5848 direct(403) 444-3900 mainwww.wellpoint.ca[EMAIL PROTECTED] Yahoo! for GoodClick here to donate to the Hurricane Katrina relief effort. __Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. 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: [Axapta-Knowledge-Village] Report Template
Hi Jason, I was he he heing because Axapta is very Sexy. It behaves somes nastily :-). have a nice day. Regards, subbuJason Crook [EMAIL PROTECTED] wrote: Thanks Guys Got it !! Regards Jason Crook Financial Systems Consultant Exordia(A Division Of PricewaterhouseCoopers) Tel : (011)797-4782 Fax : (011)209-4782 Cel : 082 887 0914 e-mail : [EMAIL PROTECTED] From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Subrahmanyam, MamidiSent: 12 September 2005 03:42 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: Re: [Axapta-Knowledge-Village] Report Template He he he he he.( joking...) Ok. Please duplicate the 'InternalList' template. Save it. and then restore it. Now compile. It won;t complain again about the compilation Thanks, subbuVarden Morris [EMAIL PROTECTED] wrote: Hi Jason I had the same problem before and I am not sure what is the cause. You can work this problem by creating a new report template then drag and drop the root object(s) from the original report template to the new one. It will then compile. In your case drag and drop page header object. yifath1 [EMAIL PROTECTED] wrote: Hi All I Am having a little bit of a problem Creating a Report Template ,I Have Pretty much Duplicated the "InternalList" Template.This exact copy does not Compile ,as it is not accepting any of the elements is there somewhere that I need to go to declare something ,or is there something that I am missing Any help would be Greatly appreciate Thanks JasonVarden MorrisSenior DeveloperWellPoint Systems Inc.(403) 444-5848 direct(403) 444-3900 mainwww.wellpoint.ca[EMAIL PROTECTED] Yahoo! for GoodClick here to donate to the Hurricane Katrina relief effort. __Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Yahoo! for Good Click here to donate to the Hurricane Katrina relief effort. Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Help: Print Management
Hi, I am trying to print 1 original and 3 copies for pickinglist report on Sales Order. Its always printing 1 original and 1 copy. Its not printing 3 copies. Any help please?. I set the PrintManagemtModuleType = cust. Any help will be appreciated. thanks 7 Regards, subbu__Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. 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: [Axapta-Knowledge-Village] Help: Print Management
Kind of weired. Its printing to printer , but not to the screen. But never mind, PrintManagement means printer management.?? Anyway, no problem. Thanks, subbu"Subrahmanyam, Mamidi" [EMAIL PROTECTED] wrote: Hi, I am trying to print 1 original and 3 copies for pickinglist report on Sales Order. Its always printing 1 original and 1 copy. Its not printing 3 copies. Any help please?. I set the PrintManagemtModuleType = cust. Any help will be appreciated. thanks 7 Regards, subbu __Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Help: PickingList Originals
Hi, My customer wants to see the running number on PickingList reportfor Sales Order . For example, they asked me to print 3 copies . Hence, what I did is, I menationed '3' in the print management. its printing 3 copies to the printer. But he also wants to see 'Picking List copy 1' , 'Picking List copy 2' 'Picking List copy 3'. I put debug point in the fetch() method to see whats going. what its doing is, its actually setting 3 copies on the printer as its not hitting the code 3 times. Is there any way, under this conditions, I can get the header control name 3 times ( or number of originals ) and do some manupulations?. Can anyone help me?. Thanks Regards, subbu __Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. 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: [Axapta-Knowledge-Village] Dynamic Lookup on Dialog
Hi Paul, Thank you for the hints. Regards, subbuPaulius Cerniauskas [EMAIL PROTECTED] wrote: the esiest way is to create new extended data type,e.g. AAA_ProjId and create a form ProjIdLookUp, whichfilters desired records. Then on AAA_ProjId FormHelpproperty filed specify that form you have justcreated.the other way is to use form with desired form controlthat has overwriten lookup method (instead of dialogclass with dialogField).how this works - check LedgerBalanceSheetPrint class.It uses Form as a dialog.then you should check ProjTable methodlookupProjWIP(). it constructs some specific querythat filters records.hope it helps--- "Subrahmanyam, Mamidi" [EMAIL PROTECTED] wrote: Hi Harry, I am using a dialog class in a report. dlvProjectId = _dialog.addField(typeid(ProjId), 'Select Project ID'); Can I filter records on this ProjectID on this dialog ?. The basic problem is I canot use a relation if I want to create and extend to ProjID . As I want to select only project starting with 'A'. I have no forms in my project. Can you please throw me some hints? Thanks Regards, subbu "Harry (Harshawardhan Deshpande" [EMAIL PROTECTED] wrote: hi I can confirm that yes it is certainly possible. I remember doing this by getting the control of the form design (being used for looup). regards harry "Subrahmanyam, Mamidi" [EMAIL PROTECTED] wrote: Has anyone tried to have a dynamic lookup on a dialogue field?. Of course we can do it in a form by overiding the control's lookup method. But just wondering if anyone has tried to have a dynamic lookup. My requirement is projectId. But for example, user just wants to see only 05.A 05.A.201 05.A.201.333 Means I am not able to have a EDT which extends to ProjID which can filter 'LIKE *.A* project IDs... Please can anyone let me know if anyone tried this way?. thanks Regards, subbu - Click here to donate to the Hurricane Katrina relief effort. - Click here to donate to the Hurricane Katrina relief effort. Sharing the knowledge on Axapta. SPONSORED LINKS Axapta Business finance course Business finance online course Business finance class Business finance schools Business finances - YAHOO! GROUPS LINKSVisit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.- - Click here to donate to the Hurricane Katrina relief effort.Paulius CerniauskasPhone: +37062049339ICQ: 280959446__Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Form on a dialog
Hi , I have a form . The form has a lookup string control. The lookup string control has a overidden lookup() method to do some fetching logic. so basically the form has only one stringcontrol with lookup. How do I paste ( add ) it on the dialog with out disturbing the lookup on the form in the Dialog?. Any thoughts ?. Thanks, subbu __Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. 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: [Axapta-Knowledge-Village] Form on a dialog
Thank Dmitry. that helped me. regards, subbu"Dyachenko, Dmitry" [EMAIL PROTECTED] wrote: Hi subbu, Itยs possible to use a form as a part of dialog box. See tutorial_runbaseform project in axapta. From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Subrahmanyam, MamidiSent: Wednesday, September 07, 2005 2:40 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] Form on a dialog Hi , I have a form . The form has a lookup string control. The lookup string control has a overidden lookup() method to do some fetching logic. so basically the form has only one stringcontrol with lookup. How do I paste ( add ) it on the dialog with out disturbing the lookup on the form in the Dialog?. Any thoughts ?. Thanks, subbu __Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Click here to donate to the Hurricane Katrina relief effort. Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Dynamic Lookup on Dialog
Has anyone tried to have a dynamic lookup on a dialogue field?. Of course we can do it in a form by overiding the control's lookup method. But just wondering if anyone has tried to have a dynamic lookup. My requirement is projectId. But for example, user just wants to see only 05.A 05.A.201 05.A.201.333 Means I am not able to have a EDT which extends to ProjID which can filter 'LIKE *.A* project IDs... Please can anyone let me know if anyone tried this way?. thanks Regards, subbu Click here to donate to the Hurricane Katrina relief effort. Sharing the knowledge on Axapta. SPONSORED LINKS Axapta Business finance course Business finance online course Business finance class Business finance schools Business finances YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. 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: [Axapta-Knowledge-Village] Dynamic Lookup on Dialog
Hi Harry, I am using a dialog class in a report. dlvProjectId = _dialog.addField(typeid(ProjId), 'Select Project ID'); Can I filter records on thisProjectID onthis dialog ?. The basic problem is I canot use a relation if I want to create and extend to ProjID . As I want to select only project starting with 'A'. I have no forms in my project. Can you please throw me some hints? Thanks Regards, subbu "Harry (Harshawardhan Deshpande" [EMAIL PROTECTED] wrote: hi I can confirm that yes it is certainly possible. I remember doing this by getting the control of the form design (being used for looup). regards harry "Subrahmanyam, Mamidi" [EMAIL PROTECTED] wrote: Has anyone tried to have a dynamic lookup on a dialogue field?. Of course we can do it in a form by overiding the control's lookup method. But just wondering if anyone has tried to have a dynamic lookup. My requirement is projectId. But for example, user just wants to see only 05.A 05.A.201 05.A.201.333 Means I am not able to have a EDT which extends to ProjID which can filter 'LIKE *.A* project IDs... Please can anyone let me know if anyone tried this way?. thanks Regards, subbu Click here to donate to the Hurricane Katrina relief effort. Click here to donate to the Hurricane Katrina relief effort. Click here to donate to the Hurricane Katrina relief effort. Sharing the knowledge on Axapta. SPONSORED LINKS Axapta Business finance course Business finance online course Business finance class Business finance schools Business finances YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. 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: [Axapta-Knowledge-Village] SpecTrans - 'Edit Closed Transactions' - Help needed
Freakingly, They marked some of the Open Trasactions which is bursting me. I unmarked them and that did the magic.
Thanks,
subbu"Subrahmanyam, Mamidi" [EMAIL PROTECTED] wrote:
Hi,
Today I am asked to look into a ticket.
There is a customer : ACBD'. and I am trying to reverse the vouchers 'aa' and 'bb'. So before doing that, I went to
AR - customers . Selected the CusID, 'ABCD' and viewd the trasactions and I do see vouchers 'aa' abd 'bb'.
So now I am trying to do reverse on the closed Trasactions ( AR - select cusID - functions - Edit closed Trasactions ).
I selected my voucher to be reversed and clicked on 'Reverse' button.
The error says'
' Vocuher does not exist '' '
'update is cancelled'.
fine. I thought some problem. I put a series of debugging points and finally ended up in
'CustVendReversePosting' class 'UpdateNow' method.
Now here is the scenarios.
Its going into this loop
while select specTrans where specTrans.specTableId == custVendTable.tableId specTrans.specRecId == custVendTable.recId { select firstonly forUpdate custVendSettlement where custVendSettlement.recId == specTrans.refId;
select firstonly forUpdate custVendTrans where custVendTrans.recId == custVendSettlement.transRecId;
select firstonly custVendTransOffset where custVendTransOffset.RecId == custVendSettlement.OffsetRecId;
if (! this.validate()) { throw error("@SYS25608"); }
Its hitting this.validate() method and throwing the error since CustVendTrans is Null.
Now after doing some more research,
when you mark a voucher in the 'Edit closed Trasactions', the records will be created in SpecTrans Table and when you mark they ( should ) are deleted.
for some reasons, its finding some unmatched records in SpecsTrans and looking for custVendsettle and custvendTrans map and retuning zero records and hence they are not validated...
ok. we took the backup of production yesterday night and copied into QA environment. Today we have this problem in Production and I am able to do reversals in QA !. I know it may be surprising for you.
what could be reasons for this?.
I storngly suspect user might have checked 'Mark' and for some reasons when they unchecked that one, they might notbe deleted...Everything else looks ok for me.
Can anyone help me to see if you had this type of problem earlier ?. and where and all do I need to check ( functional wise )?.
Your help will be much appreciated.
Thanks Regards,
subbu
__Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
Click here to donate to the Hurricane Katrina relief effort.
Sharing the knowledge on Axapta.
YAHOO! GROUPS LINKS
Visit your group "Axapta-Knowledge-Village" on the web.
To unsubscribe from this group, send an email to:[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Need your exp on Purchasing for Items of type Service
Hi, I need your different experiences on packing slip / invoicing of expense items ( Service ). For example, I have this funny scenario going on. 1. I created a Unit called 'M' for meters and I gave 3 decimals for that in the Unit Table. 2. Since Its an Service Item, I didn;t include Units on InventTable-Quantity Table for this item for 'Purchase Order' quantity. 3. I created a PO with 'quantity' 25.04. So it shows up '25.04' on the PuchQty on the PurchOrder purch Lines Tab. but it showsorderedQty as '25' only as it rounds off to Zero decimals since it has no units InventTable - Quantity- Unit. 4. I put the debugging points right from PurchLine.ModifyPurchQty to InventUpdate, Inventupd_* classes. to see the complete process and I understood how the inventory movement is happening in the code. But I have problem at the time of invoice due to '0.04' in update in Inventupd_Pysical.updateNow as its throwing an error So what is your experiences in invocing the PO for service Items, i.e expense. Do we need to have to specify the Unit of Measurement for that item tied to a InventTable - Quantity-purchaseorder Column - Unit ?. is there any way, we can avoid hitting inventory for this service items?. Appreciate your experiences. Thanks Regards, Subbu Start your day with Yahoo! - make it your home page Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. 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: [Axapta-Knowledge-Village] Need your exp on Purchasing for Items of type Service
Hi Giri, How are doing?. yeah, I checked the curency form rouding tab ( GL - setup -exch-rouding) for genral roudning/Purchase Order to '0.0001' with normal rouding. any thoughts why its happening?. Actually its throwing an error for Qty ( 0.04 diff ). Thanks Regards, subbuGirish Bhatkal [EMAIL PROTECTED] wrote: did you also check the Round-off on the exchangecurrency form / round-off tab?--- "Subrahmanyam, Mamidi" [EMAIL PROTECTED] wrote: Hi, I need your different experiences on packing slip / invoicing of expense items ( Service ). For example, I have this funny scenario going on. 1. I created a Unit called 'M' for meters and I gave 3 decimals for that in the Unit Table. 2. Since Its an Service Item, I didn;t include Units on InventTable-Quantity Table for this item for 'Purchase Order' quantity. 3. I created a PO with 'quantity' 25.04. So it shows up '25.04' on the PuchQty on the PurchOrder purch Lines Tab. but it shows orderedQty as '25' only as it rounds off to Zero decimals since it has no units InventTable - Quantity- Unit. 4. I put the debugging points right from PurchLine.ModifyPurchQty to InventUpdate, Inventupd_* classes. to see the complete process and I understood how the inventory movement is happening in the code. But I have problem at the time of invoice due to '0.04' in update in Inventupd_Pysical.updateNow as its throwing an error So what is your experiences in invocing the PO for service Items, i.e expense. Do we need to have to specify the Unit of Measurement for that item tied to a InventTable - Quantity-purchaseorder Column - Unit ?. is there any way, we can avoid hitting inventory for this service items?. Appreciate your experiences. Thanks Regards, Subbu- Start your day with Yahoo! - make it your home page___ Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com__Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. SPONSORED LINKS Axapta Business finance course Business finance online course Business finance class Business finance schools Business finances YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. 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: [Axapta-Knowledge-Village] ASCIIIO fieltype
Hi James,
I was also using terminal sever.
Are you trying to write Binarydata into a file using AsciiIO class?.
or are you trying to write it an excel file?. ( or CSV )
Fortunately, I didn;t experience this kind of settings problem.
Let us hope someone had similar exp and may share their exp.
But I feel the datatype ( Ascci or binary) is what you are having problems.
BTW, do you have other way to accomplish this?.
Like did you try uing Textbuffer, CommaIO, BinaryIo etc etc
best of luck.
thanks,
subbu
James Flavell [EMAIL PROTECTED] wrote:
Thanks Subbu,
What you write should work but I am still struggling ... I have tried everything in the type and delimiter but still I have the problem.
Can anyone help me, the machine I run the export on is a Windows terminal 2003 server. When I open the data import wizard in excel the file orgin type is 'MS-DOS(PC-8)' whereusually I think it is 'Windows ANSI' on my win2000 notebook. Is there possibly some setting on the server (Axapta or Termainal server) that is causing this?
If I take the file, open with a text editorand then save it with a different name. When I compare the two files with a file compare program then the two files do show up as different but when I use a hex editor and look inside everything is exactly the same with \r\n (0d 0a) at the end of everyline.
Does anyone know does excel add its own characters when opening a file?
Help please before I pull out all more hair or put my fist through the monitor!!!
James
-Original Message-From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Subrahmanyam, MamidiSent: 30 August 2005 11:15To: Axapta-Knowledge-Village@yahoogroups.comSubject: Re: [Axapta-Knowledge-Village] ASCIIIO fieltype
Hi James,
Here is my exp. I uploaded around 500K items using a job using ASCII file formatted with 'tab' limited filed file with every record as new line.
Here is a small piece for in reading a file with columns seperated with a tab.
file = new AsciiIo("X:\\subbu\\ITEM\\204_MRO_IC.txt","R"); file.inFieldDelimiter('\t'); file.inRecordDelimiter('\r\n');
So, I think when you want a output file with tab limited, I think I may need to change it to.
file = new AsciiIo("X:\\subbu\\ITEM\\204_MRO_IC.txt","W"); file.outFieldDelimiter('\t'); file.outRecordDelimiter('\r\n');
I am not sure if this helps.
Good Luck
thanks,
subbu
James Flavell [EMAIL PROTECTED] wrote:
Hi I am using the Axapta ASCIIIO file type for the first time but getting problems with carraige return/linefeed.
The file I create looks okay in notepad but in excel it has a blank line after every data line.
What should the outRecordDelimiter be set as?
I tried not setting, \r\n and also \n but they all seem to have the same problem
Below is my code, should I be using mode T or B? Supposedly this is a fixed length file...
txtFile = new AsciiIO(this.generate_FullPathFileName(),"wt");// txtFile.outRecordDelimiter('\r\n');// txtFile.outRecordDelimiter('\n');
Thanks
James
Start your day with Yahoo! - make it your home page
Start your day with Yahoo! - make it your home page
Sharing the knowledge on Axapta.
YAHOO! GROUPS LINKS
Visit your group "Axapta-Knowledge-Village" on the web.
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: [Axapta-Knowledge-Village] Any Idea abou this?
Hi, I am working in my DEV environment just for the sake of learning. I think we can not use strltrim() in X++ 'select where' statement. So i I tried to introduce spaces to get the correct count on LedgerTable using AccountNum as index. But already there are trasactions posted on these LedgerAccounts. Hence, we can not modify them at this point of time. You are right. I could be able to use LTRIM in SQL and get the records count. Actually I am looking for any info , like 'why Microsoft made Account is Right Aligned' and 'ItemID is left aligned'. Appreciate any info. Thanks, subbu DIEGO MARIANO GAGLIANO [EMAIL PROTECTED] wrote: Hi Subbu You used a normal Axapta select or SQL statement? If you used axapta declare the variable type as and resolve the problem If you used SQL statement when you create a select command add the command Ltrim Example: SELECT ACCOUNTNUM, VOUCHERFROM dbo.LEDGERTRANSWHERE (LTRIM(VOUCHER) = 'VA0001') Best regards, Diego M. Gagliano Please fill free to contact me if you have any question. I look forward to hear about you. Start your day with Yahoo! - make it your home page Start your day with Yahoo! - make it your home page Sharing the knowledge on Axapta. SPONSORED LINKS Axapta Business finance course Business finance online course Business finance class Business finance schools Business finances YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Any Idea abou this?
Hi, I am wondering if you guys know of this. Why is the field 'AccountNum' is right aligned and why not 'Left aligned'?. Does what factor judge alignment property?. Because this has significant effect in 'select' statements if I use AccountNum as Index. Any help is highly appreciated, Thanks Regards, subbu Start your day with Yahoo! - make it your home page Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. 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: [Axapta-Knowledge-Village] Expanding Project Id
Hi, We have changed ProjId to 20 digits. We changed ProjIdBase and AccountNum EDT to 20. However, there is an option in Administration - setup - system - adjust global type , ProjectID. however, this should be coupled with AccountNum EDT change . However this is per company only. ax0804 [EMAIL PROTECTED] wrote: Does anyone have experience expanding Project Id? The extended data type ProjIdBase is changed. Also LedgerJournalAC is changed as this controls the account number field in Project Cost journal.Some testing was done and no issues have been found. Just curious if other people have done similar things.Thanks in advance Start your day with Yahoo! - make it your home page Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. 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: [Axapta-Knowledge-Village] SQL Duplicate company error
Hi James,
as per your advice to duplicate the problem, I did as the following.
1. Created a new Table SUNExample with 2 fields and populated data.
2. Exporrted the Table /
3. Logged on to 'CUS' layer ( We don;t have access to VAR ) and reimported the SUNExample Table. There I added a third table to this table so that I made sure the same table name exists with different versions and populated diffferent data.
4. Now , I logged on to USR layer and duplicated the company - No problem or no SQL trans error.
5. Now, I logged in now to CUS layer and duplicated the company - No problem.
I am using SP3 and Ax3.
Microsoft Ax acts sometimes very fishy :(.
seems, like sometime IE crashes without reason. seems its also the same fishy :((
But, I will keep an eye and will discuss with you if I get this problem again.
kind regards
subbuJames Flavell [EMAIL PROTECTED] wrote:
I think this problem is the same as what I posted earlier about export always crashing and it was becausehaving some tables in both VAR and USR but as diferent eleemnts (i.e. 2 tables appear in the AOT with samename). I guess when Axapta gets to one of them it finds actual there is no SQL table name or something liek that and hence the error.
Once the programmer cleans up this mess I am pretty sure it will work.
Sync and compile every other day seems very wrong to me
Thanks for your input
James
-Original Message-From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Subrahmanyam, MamidiSent: 25 August 2005 22:01To: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] SQL Duplicate company error
Hi James,
This problem I face almost every alternative day. But I do get SQL error on a Table. Interesting it didn.t specify the table name for you.
What I do is, I will check/sync , reindex and do complete application compilation.
Then it works for me.
Best of luck.
Thanks,
subbu
James Flavell [EMAIL PROTECTED] wrote:
Has really noone faced this problem before?
Thanks
James
-Original Message-From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of James FlavellSent: 19 August 2005 17:26To: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] SQL Duplicate company error
Can anyone help me to know why I get this messagewhen I try the duplicate company function in 'CompanyAccounts'
Cannot execute the required database operation.,The SQL database has issued an error.SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'WHERE'.SQL statement: DELETE FROM WHERE DATAAREAID = {fn LCASE('DJF')}
I guess it is because there is no table name after the FROM but what has caused that? DJF is the new company I want to create via the duplicate and so from what I understand this DJF does not exist to start with so why is it doing a delete anyway?
Is there a stored SQL procedure or something that Axapta calls to do the duplicate as I am wondering maybe something is amiss in it (BTW the data export is done via pure Axapta codes or more direct SQL commands issued by Axapta? this may be the reason my data export also crashes maybe...).
Thanks
James
Yahoo! Mail for MobileTake Yahoo! Mail with you! Check email on your mobile phone. __Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
Sharing the knowledge on Axapta.
SPONSORED LINKS
Axapta
Business finance course
Business finance online course
Business finance class
Business finance schools
Business finances
YAHOO! GROUPS LINKS
Visit your group "Axapta-Knowledge-Village" on the web.
To unsubscribe from this group, send an email to:[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Bug filed in LedgerTable
Hi,
In continuation with my problem in Ledger consolidation export, I logged a case with Microsoft to see if they any answer why I get different values for 'Select count(Recid) from LedgerTable where LedgerTable.AccountNum != ' statement .
They could reporoduce the problemand accepted a bug and promised us to issue a hotfix for this LedgerTable. However, I am not happy as I feel its something to do with 3 tier cacheing on the Ledgertable.
Does anyone know why AccountNum ( i.e for LedgerTable ) is right aligned?. Is there any specific tech reason there?.
I ams sure some of you might have faced this problem.
/*/
8/28/2005 7:23:00 AM PDT -- SubrahmanyamHi,When I was doing consolidation export which involves exporting of 6 companies, It could not export all the account from ledgerTable ( due to cache ).After consolidation was done, our financial figures didn;t tally.It never happened to us before. Hence, I debugged 'LedgerConsolidate' class and I found one interesting issue in 'sumupTrasact' method, its behaving strangely for just one company ( 600 ) out of 6 companies.ok, in a nutshell, Axapta is returning the following.Select count(Recid) from LedgerTable where LedgerTable.AccountNum != '';then LedgerTable.Recid is returning wrong number of entries. Its returning 125 when there are 976 records in the Table.( but,when I use accountName rather than AccountNum, i.e, Select count(Recid) from LedgerTable where LedgerTable.AccountName != '' is returning correct records, 976 )I thought its a cache problem. Hence,
I deleted the usage data, refreshed usage data in the client( Tools - dev tools - appl objects - refresh AOD, refresh USages data, refresh dictionary ) but no luck.Even I tried in a job.flush LedgerTable;Select count(Recid) from LedgerTable where LedgerTable.AccountNum != '';but no luck,Finally to make it work, I needed to change the 'CacheLookup' property to 'none' from 'Entire Table' ( I know this is a the quick solution )But,Without turning off the Cachelookup from the entire Table, what should I be doing now to avoid this incident in future forever ?.Do I need to clear the cahce on the AOS also?.How do I find LedgerTable cache there?.Appreciate the help.Thanks,subbu--8/29/2005 6:57:00 AM PDT -- Andrew MetzgerGood morning Subbu,After taking a look at what is going on
here, it looks at though the LedgerTable may have duplicate records based on the RECID column. I think the LedgerTable is allowing duplicate RECID numbers, because it uses the RECID and DATAAREAID columns together. When selecting account numbers this can cause problems that you have run into, as well as another that I have run into.Run the script below to see if you see duplicate RECID values in the table:select RECID from LedgerTable group by RECID having count(*) 1If so, I'll go ahead and write this up as a bug so we can get this fixed. Please let me know if you have any questions.Thanks,Andy | Axapta Support--8/29/2005 8:58:00 AM PDT -- SubrahmanyamHi Andy,Good Morning!. Thank you.The statement you asked me to execute ( select RECID from LedgerTable group by RECID having count(*) 1 ) does not work
in X++ as its related to SQL.Is there anyway I can write a script in a job in Axapta to find out this( I don;t have access to Axapta DB )similar to this?.Thanks,subbu--8/29/2005 9:13:00 AM PDT -- SubrahmanyamSorry for my incomplete mail as I was having my internet problem.I was trying to run the script ( job ) in a company 600. Means, the data areadId is set to 600. Hence, I wrote a small script in X++while select count(Recid) from LedgerTable group by RecId { if(LedgerTable.Recid)
1 info(int2str(LedgerTable.RecId)); }The above didn;t print anything, which means that there are no duplicates.Can you please tell me when I change the 'Cachelookup' proprty on Ledgertable to 'None' from 'EntireTable', its fetching the correct number of records.Don't you think its a problem related to cachheing on the Table?.However if you have something in your mind, Please let me know.Appreciate your help.Thanks Regards,subbu--8/29/2005 10:49:00 AM PDT -- SubrahmanyamHi Andy,Thank You for the email. I asked my Axata Admin to run this script
on the Database Query analyser.His email says the below :"That query will not bring back the desired results as every record in this table exists in each company and when you use the Duplicate company feature it keeps the recid # but just changes the dataareaid."That means, there are no duplicate records with ReciID DataAreaId.Can you please inform me the next debugging step?.Appreciate your
RE: [Axapta-Knowledge-Village] Cancel Purchase Order
Sun Fen is right. We are doing the same as he advised / described for both Sales ORder / Purchase order. The moment you cancel the quantiy, the satus is setting to 'cancelled'. Thank you. kind regards, subbuSun Fen [EMAIL PROTECTED] wrote: If you change to order type = Journal, it will not affect your on hand.However it is not purposely used to cancel an open order. It is used as adraft only. As you know, purchase order type will affect Ordered field. However, usuallyfor open order we cancel it using Function - Deliver reminder - Cancelquantity and the purchase order will have the status of CancelledRegards,Sun Fen Chen-Original Message-From: Axapta-Knowledge-Village@yahoogroups.com[mailto:[EMAIL PROTECTED] On Behalf Of Philip R.FreimannSent: Tuesday, August 30, 2005 2:47 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] Cancel Purchase OrderWhat procedures do you use to cancel a purchase order?These are purchase orders that the vendor can not fill in a timely basis.We do not want to delete them. We want the visibility / history online to see the cancelled P.O.sDoes it work to simply change the 'Purchase order type' from'Purchase order' to 'Journal.'? Does this reverse all the previous journal or financial transactions?Sharing the knowledge on Axapta. Yahoo! Groups Links Start your day with Yahoo! - make it your home page Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. 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: [Axapta-Knowledge-Village] ledgerTrans.postload
Hi harry, We need to roundoff the LedgetTrans's amountMST and AmountCUR. hence I did this way. It works for me since I could round off them while reading/loading the records. I tested properly in the local axapta with the demo data. Thank you for the input. Regards, subbu"Harry (Harshawardhan Deshpande" [EMAIL PROTECTED] wrote: hi be very careful with this method, you can potentially manipulate every record when it is selected from anywhere i.e. from form or from a select statement. regards harry"Subrahmanyam, Mamidi" [EMAIL PROTECTED] wrote: Hi Does anyone have any idea of postload() function?. what does it do?. For example: LedgerTrans.postload(), what does it do?. Thanks, subbu Start your day with Yahoo! - make it your home page __Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Do you Yahoo!? Yahoo! Mail - Find what you need with new enhanced search. Learn more. Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. 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: [Axapta-Knowledge-Village] ledgerTrans.postload
:D. Thank you for the headsup and scaring me :)) Is there any solution there with you so that I can round off all the existing LedgerTrans Records's AmountCUR and AmountMST to 2 digits?. Presently I did it in DEV environment after I tested in demo installation. I moved this piece of code to QA Environment for user testing in a company of copy pf production as of yesterday PostLoad is already overridden there in LedgerTrans, so I just my 2 lines of code there. Is there any better solution there for rounding off the the exisitng records?. Problem is many people wrote the code and are no longer onsite now. You know when a ticket comes, onsite guy has to act :((. So is there any solution or idea you have which can round off to 2 decimals?. Appreciate the help. Thanks Regards, subbu "Harry (Harshawardhan Deshpande" [EMAIL PROTECTED] wrote: hi Subbu Demo data is never same as live data and testing is never enough. I just thought that you have enough problems right now and not add one more to the list of problems*s* regards harry"Subrahmanyam, Mamidi" [EMAIL PROTECTED] wrote: Hi harry, We need to roundoff the LedgetTrans's amountMST and AmountCUR. hence I did this way. It works for me since I could round off them while reading/loading the records. I tested properly in the local axapta with the demo data. Thank you for the input. Regards, subbu"Harry (Harshawardhan Deshpande" [EMAIL PROTECTED] wrote: hi be very careful with this method, you can potentially manipulate every record when it is selected from anywhere i.e. from form or from a select statement. regards harry"Subrahmanyam, Mamidi" [EMAIL PROTECTED] wrote: Hi Does anyone have any idea of postload() function?. what does it do?. For example: LedgerTrans.postload(), what does it do?. Thanks, subbu Start your day with Yahoo! - make it your home page __Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Do you Yahoo!?Yahoo! Mail - Find what you need with new enhanced search. Learn more. Start your day with Yahoo! - make it your home page Start your day with Yahoo! - make it your home page Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Urgent : Problem in Select count(RecId)
Hi, Today I have a P1 ticket saying that consolidation is not picking up all the transaction for just one company out of 8 export companies. They are all regular trasactions in LedgerTrans. I debugged LedgerConsolidate class and found an interesting issue after debugging in 'sumupTransact'; Select count(recid) from LedgerTable where LedgerTable.AccountNum != ''; LedgerTable.recid = 125 records ( these only exported ) but interestingly if I change it to Select count(recid) from LedgerTable where LedgerTable.AccountName != ''; LedgerTable.recid = 975 records. I felt I got fever for a moment. I reindexed the company when no one is there in the system. still I am getting 125 only. This sucks me now. Any idea why it happended?. I cleared all the cache for this company. Looks like I have a bad week end. help pls thanks, subbu Yahoo! Mail for Mobile Take Yahoo! Mail with you! Check email on your mobile phone. Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. 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: [Axapta-Knowledge-Village] Urgent : Problem in Select count(RecId)
When I set the table 'cachelookup prorty ' to 'none', I get the same orignal results which is 975 which is good. But...it sucks. I could not solve the problem. But I set temporarily the 'cahchelookupproperty in 'ledgerTable' to none for time being so that I can bring in all the regular transactions in consolidation. "Subrahmanyam, Mamidi" [EMAIL PROTECTED] wrote: Hi, Today I have a P1 ticket saying that consolidation is not picking up all the transaction for just one company out of 8 export companies. They are all regular trasactions in LedgerTrans. I debugged LedgerConsolidate class and found an interesting issue after debugging in 'sumupTransact'; Select count(recid) from LedgerTable where LedgerTable.AccountNum != ''; LedgerTable.recid = 125 records ( these only exported ) but interestingly if I change it to Select count(recid) from LedgerTable where LedgerTable.AccountName != ''; LedgerTable.recid = 975 records. I felt I got fever for a moment. I reindexed the company when no one is there in the system. still I am getting 125 only. This sucks me now. Any idea why it happended?. I cleared all the cache for this company. Looks like I have a bad week end. help pls thanks, subbu Yahoo! Mail for MobileTake Yahoo! Mail with you! Check email on your mobile phone. __Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. 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: [Axapta-Knowledge-Village] Urgent : Problem in Select count(RecId)
Hi I did, Flush LedgerTable; - No luck Tools - refresh AOD and Refresh usage , but no luck. So I suspect the problem is on AOS. So I am going to flush there also to see if it solves my problem. This is problem with 3 tier. Anyway, thanks . I am replying to my self :D subbu "Subrahmanyam, Mamidi" [EMAIL PROTECTED] wrote: When I set the table 'cachelookup prorty ' to 'none', I get the same orignal results which is 975 which is good. But...it sucks. I could not solve the problem. But I set temporarily the 'cahchelookupproperty in 'ledgerTable' to none for time being so that I can bring in all the regular transactions in consolidation. "Subrahmanyam, Mamidi" [EMAIL PROTECTED] wrote: Hi, Today I have a P1 ticket saying that consolidation is not picking up all the transaction for just one company out of 8 export companies. They are all regular trasactions in LedgerTrans. I debugged LedgerConsolidate class and found an interesting issue after debugging in 'sumupTransact'; Select count(recid) from LedgerTable where LedgerTable.AccountNum != ''; LedgerTable.recid = 125 records ( these only exported ) but interestingly if I change it to Select count(recid) from LedgerTable where LedgerTable.AccountName != ''; LedgerTable.recid = 975 records. I felt I got fever for a moment. I reindexed the company when no one is there in the system. still I am getting 125 only. This sucks me now. Any idea why it happended?. I cleared all the cache for this company. Looks like I have a bad week end. help pls thanks, subbu Yahoo! Mail for MobileTake Yahoo! Mail with you! Check email on your mobile phone. __Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Do you Yahoo!? Yahoo! Mail - You care about security. So do we. Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. 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: [Axapta-Knowledge-Village] SQL Duplicate company error
Hi James,
This problem I face almost every alternative day. But I do get SQL error on a Table. Interesting it didn.t specify the table name for you.
What I do is, I will check/sync , reindex and do complete application compilation.
Then it works for me.
Best of luck.
Thanks,
subbu
James Flavell [EMAIL PROTECTED] wrote:
Has really noone faced this problem before?
Thanks
James
-Original Message-From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of James FlavellSent: 19 August 2005 17:26To: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] SQL Duplicate company error
Can anyone help me to know why I get this messagewhen I try the duplicate company function in 'CompanyAccounts'
Cannot execute the required database operation.,The SQL database has issued an error.SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'WHERE'.SQL statement: DELETE FROM WHERE DATAAREAID = {fn LCASE('DJF')}
I guess it is because there is no table name after the FROM but what has caused that? DJF is the new company I want to create via the duplicate and so from what I understand this DJF does not exist to start with so why is it doing a delete anyway?
Is there a stored SQL procedure or something that Axapta calls to do the duplicate as I am wondering maybe something is amiss in it (BTW the data export is done via pure Axapta codes or more direct SQL commands issued by Axapta? this may be the reason my data export also crashes maybe...).
Thanks
James
Yahoo! Mail for Mobile
Take Yahoo! Mail with you! Check email on your mobile phone.
Sharing the knowledge on Axapta.
SPONSORED LINKS
Business finance course
Business to business finance
Small business finance
Business finance consultant
Business finance magazine
Business finance schools
YAHOO! GROUPS LINKS
Visit your group "Axapta-Knowledge-Village" on the web.
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: [Axapta-Knowledge-Village] SQL Duplicate company error
Hi James,
This kind of errors I get in my home installation axapta. I think you may be right if we have same Tables with different fields in USR/CUS, we may get this errorI don;t not get these kind of errors in our DEV/QA environment because we maintain always in one layer only.
Let me see if I clean up the USR layer , I can duplicate the problem.
thanks for the input and will let you know soon.
Thanks Regards,
subbu
James Flavell [EMAIL PROTECTED] wrote:
I think this problem is the same as what I posted earlier about export always crashing and it was becausehaving some tables in both VAR and USR but as diferent eleemnts (i.e. 2 tables appear in the AOT with samename). I guess when Axapta gets to one of them it finds actual there is no SQL table name or something liek that and hence the error.
Once the programmer cleans up this mess I am pretty sure it will work.
Sync and compile every other day seems very wrong to me
Thanks for your input
James
-Original Message-From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Subrahmanyam, MamidiSent: 25 August 2005 22:01To: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] SQL Duplicate company error
Hi James,
This problem I face almost every alternative day. But I do get SQL error on a Table. Interesting it didn.t specify the table name for you.
What I do is, I will check/sync , reindex and do complete application compilation.
Then it works for me.
Best of luck.
Thanks,
subbu
James Flavell [EMAIL PROTECTED] wrote:
Has really noone faced this problem before?
Thanks
James
-Original Message-From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of James FlavellSent: 19 August 2005 17:26To: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] SQL Duplicate company error
Can anyone help me to know why I get this messagewhen I try the duplicate company function in 'CompanyAccounts'
Cannot execute the required database operation.,The SQL database has issued an error.SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'WHERE'.SQL statement: DELETE FROM WHERE DATAAREAID = {fn LCASE('DJF')}
I guess it is because there is no table name after the FROM but what has caused that? DJF is the new company I want to create via the duplicate and so from what I understand this DJF does not exist to start with so why is it doing a delete anyway?
Is there a stored SQL procedure or something that Axapta calls to do the duplicate as I am wondering maybe something is amiss in it (BTW the data export is done via pure Axapta codes or more direct SQL commands issued by Axapta? this may be the reason my data export also crashes maybe...).
Thanks
James
Yahoo! Mail for MobileTake Yahoo! Mail with you! Check email on your mobile phone.
Do you Yahoo!?
Yahoo! Mail - Find what you need with new enhanced search. Learn more.
Sharing the knowledge on Axapta.
YAHOO! GROUPS LINKS
Visit your group "Axapta-Knowledge-Village" on the web.
To unsubscribe from this group, send an email to:[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Need some Help/thoughts
Hi Guys, I am in real shit. I am trying to see if any one has any experiences on changing the AmountCur and AmountMst to 4 decimals. Here is my scenario. My Europe customer wanted to see 4 digits on Discounts and Qty on Sales Order module. Initially we changed AMountCur and AmountMST, QTy EDTs to 4 decimals and curreny to 4 decimals in the exchange section. Then everything is started shon up to 4 digits and finance people wanted not to see 4 digits. Yes, it true they don;t want . What we did was, we created an extended data type inheriting from AmountCur and AmountMST changing the currency Decimals to 4 digits 0.0001 and fullfilled their needs. As time went on, we now have problems in ledgerSettlements , Journals, and invoices etc etc duw to the last 2 digits out of 4 digits. Since all these use LedgerTrans Table in one or other way, LedgerTrans now contains 2 dgits or 4 digits Amounts and they are not tallying due to 3rd and 4th decimals. We have a lot of tickets logged in and wereally need to act very fast. Since we have this problem for finance transactions , I am going to round off of the amounts in AmoutCur and AmountMST fields in LedgerTrans table to 2 decimals. 1. Is that advisable? 2. did u face this kind of problems? or how did you tackle kind of problems?. Any help will be highly appreciated. Thanks, subbu Start your day with Yahoo! - make it your home page Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
