[Axapta-Knowledge-Village] where Clause

2004-11-07 Thread Alfonso Collados Arroyo
Hi all, I want to make a select statement like this: Select Table where Table.Field IN (Value1,Value2); How can I do this in X++? I’m interested in IN clause. Regards, Alfonso   Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo

Re: [Axapta-Knowledge-Village] Posting Journal?

2004-11-07 Thread vaibhav pednekar
hi, In what scenario did this error threw up, cuz i didnt receive this error till now while using the inventory movement journal. Also checked the Posting Journals forms, there no record in it. Can you check your Inventory Movement Journal setup, also eager to know, how come this error is not s

RE: [Axapta-Knowledge-Village] Shipments Vs Carrier Capacity

2004-11-07 Thread vaibhav pednekar
hello ottawa, You can try using the Pallet types and Pallets from Inventory breakdown to record the qty under each type of shipment carrier. need some modifications here. About the forecast, u need to generate a report based on your requirement. The delivery date which u confirm to the client

RE: [Axapta-Knowledge-Village] Shipments Vs Carrier Capacity

2004-11-07 Thread James Flavell
If you accurately use the delivery date ('estaimted date' on inventorytrans) then you should be able to just use the inventorytrans report filtered on recipt/issue status (sorry I dont know exactly where you inventory trans are going to be generated from) and this estaimted date field

[Axapta-Knowledge-Village] Shipments Vs Carrier Capacity

2004-11-07 Thread ottawa_m2003
Hi, My customer has a plant which Manufactures consumer electronics. They had a contract with UPS as the carrier. Is there any report , I can forecast and tell the UPS about my next week's Shipments Vs Carrier Capacity based on the previous data (shipments & Carrier Capacity)?. Any help is

[Axapta-Knowledge-Village] Posting Journal?

2004-11-07 Thread mchiat
Hi all, When i try to post the Inventory Movement Journal an error threw out saying that the journal is not attached to the posting journal. The only way to solve this problem is to go to the GL > Setup > Journals > Journal names and create the posting journal for the voucher series. Ju

RE: [Axapta-Knowledge-Village] RE: Mutliple Workcenters with same operation

2004-11-07 Thread Harry Deshpande
Hi   You need a modification to do this   Regards   harry    From: Gokhan Can [mailto:[EMAIL PROTECTED] Sent: Thursday, November 04, 2004 8:55 PM To: [EMAIL PROTECTED] Subject: Mutliple Workcenters with same operation Hi all;   I have a problem about work

[Axapta-Knowledge-Village] RE: Mutliple Workcenters with same operation

2004-11-07 Thread Fajar Hidayat
Hi Gokhan.   In which work center is default you wanna do your operations?it is in automated or it is in manual? If it is in automated, do you want to automatically systems move your load to the manual? or you wait till the automated machine is full first and when the manual is empty then y

[Axapta-Knowledge-Village] Re: Isn't weired with Axapta?

2004-11-07 Thread george_spl
While implementation consultants routinely need to be trouble- shooting occasional package bugs and errors as they arise: (a) the primary focus of consulting should surely be in value-add activity for a client, not making Axapta work. This should be the true intellectual property of the par

[Axapta-Knowledge-Village] Axapta Professionals

2004-11-07 Thread Frank Labriola
Hello Axapta Professionals We have an urgent need for Axapta Professionals possessing various skill-sets for lucrative, long-term contract work and permanent employment in Denmark, throughout Europe, and in the United States. Please contact us right away, describe your core skills and expe

[Axapta-Knowledge-Village] Re: Question on Scope of an IF Statement.

2004-11-07 Thread luisxbmo
Hi Bob, You are correct, if there are no braces then the first statement following the if is in scope... as would be the first statement following an else if there was one. int i=1; ; if(i==0) i=2; else i=3; print i; will print 3 int i=1; ; if(i==1)

[Axapta-Knowledge-Village] Re: Axapta performance

2004-11-07 Thread luisxbmo
Hi all, Here is some general stuff that I hope you can use when dealing with performance in Axapta. I have not seen or heard of anyone with a data size that was really a problem for SQL Server as such, however a combination of factors can work together to cause serious performance problems for

Re: [Axapta-Knowledge-Village] I really need help SalesInvoice

2004-11-07 Thread vaibhav pednekar
hi bob, really sorry, but it was with my previous company, and i dont have it now. But it should be simple, u need to check the current invoice how does it print the total misc. charges and then in the misc. charges add the checkbox for printing. if it is checked then u alter the misc charges

[Axapta-Knowledge-Village] Question on Scope of an IF Statement.

2004-11-07 Thread bob . brinker
Hi All, I am a little confused by the scope of an IF statement.What is the scope of the first ?IF? statement below taken from the fetch in the SalesInvoiceUS report? I thought that the curly brackets { and } controlled the scope but there is no curly bracket { following the first IF. It appears

Re: [Axapta-Knowledge-Village] I really need help SalesInvoice

2004-11-07 Thread bob . brinker
Hi Vaibhav, Thanks for the info. Would you mind sharing the code you used to print the misc charges. I tried selecting based on RecId but was not successfull. Thank You again, Bob  Bob BrinkerOakdene Group, Inc.2625 Butterfield Rd. (Suite 212E)Oak Brook, IL 60523-1261(630)368-1046 x/230(630)368

Re: [Axapta-Knowledge-Village] Constant Production Time for a batch

2004-11-07 Thread vaibhav pednekar
hello UCS, sorry i find ur name difficult to write and pronounce. You can do the following:- In the Route on the operation under times tab u can specify - Run Time - 15 Process qty - 250 hours/time - for this u need to specify the conversion factor for hours to minutes for 30 min it is 0.0167