[Axapta-Knowledge-Village] Using Date in Query String In COM Connector

2004-11-10 Thread Joel WU
Hello: I have this line of C# Code In Axapta, we have Date2Str function use in query, however, How do we do this in COM Connector DateString =2004-11-15; AxCustTable.ExecuteStmt(select * From %1 where %1.ScanDate == \+ DateString + \); Regards, Joel Sharing the

[Axapta-Knowledge-Village] C# COM Connector

2004-11-09 Thread Joel WU
Hi My code is as follow in C# DateString = 2004-11-10 AxCustTable = Axapta.CreateRecord(MyTable); AxCustTable.ExecuteStmt(select * From %1 where %1.ScanDate = '+ DateString + '); What is the problem with this statement? I get no exception, but it just give me all the

[Axapta-Knowledge-Village] Using Date in Query String In COM Connector

2004-11-09 Thread Joel WU
Hello: I have this line of C# Code In Axapta, we have Date2Str function use in query, however, How do we do this in COM Connector DateString =2004-11-15; AxCustTable.ExecuteStmt(select * From %1 where %1.ScanDate == \+ DateString + \); Regards, Joel Sharing the

[Axapta-Knowledge-Village] Axapta 2.5 COM Connector Web Service Error

2004-11-08 Thread Joel WU
Hi all: I have the problem when I try to test the Webservice using C# using the Axapta COM Connector I get a exception when I try to logon to Axpata. However I wont have such error when I write a Windows Application using C# Any one know what is happening to my code? Regards,

[Axapta-Knowledge-Village] Code upgrade from 2.5 to 3.0

2004-09-16 Thread Joel WU
Dear All: We are going to upgrade Axapta 2.5 to 3.0, I using manual upgrade method, and now I am in the stage that need to change the programming code because many part is different between these two version. Like Lookup table and ConfigID in these two version. So my question is

RE: [Axapta-Knowledge-Village] Re: Average Cost

2004-08-26 Thread Joel WU
Hi Yes, my company is using weighted average also it also bring lots of problem. Make the inventory figure a mess. Because weighted has be to careful with every record it make to the system. Any wrong data will make the cost go so high and cant reduce it back so easily. We still

[Axapta-Knowledge-Village] SpecTrans

2004-08-26 Thread Joel WU
Hi Anyone know in Axapta 2.5 table name SpecTrans Use for what? Record what kind of record. Regards, Joel Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go

[Axapta-Knowledge-Village] Rename Value

2004-08-23 Thread Joel WU
Hi Everyone: Does anyone know hoe to batch rename a field value from one value to another? Like rename itemid. Regards, Joel Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go

[Axapta-Knowledge-Village] ActiveX DLL problem in Axapta 2.5

2004-08-03 Thread Joel WU
Hi everyone: I have a function that I have put in to an ActiveX DLL written using VB. I have to write this function because I am using Axapta 2.5 it doesnt support ASCW and CHRW function in Axapta. So I put it in a report to manipulate my string and return a string to me. Public

RE: [Axapta-Knowledge-Village] ActiveX DLL problem in Axapta 2.5

2004-08-03 Thread Joel WU
Gahr -Ursprüngliche Nachricht- Von: Joel WU [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 3. August 2004 08:25 An: [EMAIL PROTECTED] Betreff: [Axapta-Knowledge-Village] ActiveX DLL problem in Axapta 2.5 Hi everyone: I have a function that I have put in to an ActiveX DLL written

RE: [Axapta-Knowledge-Village] Device Context

2004-07-27 Thread Joel WU
other things, a pie. It uses a com component for this (the file is called CFX2032.DLL). First, it generates the image as a file and then connects it to a ReportBitmapControl in the report. Finally, the image is deleted. //Lars -Original Message- From: Joel WU [mailto

[Axapta-Knowledge-Village] Barcode support in Axapta 2.5 SP4

2004-07-02 Thread Joel WU
Hi Everyone: Anyone knows is there any support of Barcode in Axapta 2.5? If so, where to find the documentation. If not, what Barcode control can use in both Form and report? Regards, Joel WU Sharing the knowledge on Axapta. Yahoo! Groups Sponsor

Re: [Axapta-Knowledge-Village] Product Costing and Posting in Production

2004-06-23 Thread Joel WU
This is only what my company is doing, just for reference. One of the possible solution is to embed the production cost (not material) into the routing, and work centre, so when the production order complete and post to ledger module, it can capture the cost. And if your company is use

Re: [Axapta-Knowledge-Village] Product Costing and Posting in Production

2004-06-23 Thread Joel WU
. The Picking list is being posted. 2.The Route Card is being posted. 3. When Production is report as finished 4. When the Costing is run and the final product is being costed. FYI, I've chosen Item + Workcenters to be my posting type. Thousands thanks. Joel WU [EMAIL PROTECTED] wrote