Search results for query: *

Hi tuba , Thanks , for the help on Accpac session date. Please let me know how to calculate the taxes for taxable items in order entry (For example STATE,COUNTY)? Thanks Saravanan

Hi all i want to know the table in which the session date is stored. Thanks Saravanan

Hi All, Session.Open(String userID, String password, String companyID, DateTime sessionDate, 0) when we use the above statement it throughs error only on some system as 'ACCPAC.Advantage.Server.Session.Open(String userID, String password, String orgID, DateTime sessionDate, Int32 flags...

Hi tuba i have different database in which i am using a temporary table, for which i have to use picking slip report, what i did was copied the original picking slip report in the database expert i could able to connect my table via DSN, but i don't know how to map the field to a report...

Hi All, I have a temporary table from which i have to show picking slip report of AAS5.4A. (OEPICKSHIPMENT2), please guide me on how to make use of this AAS5.4a standard picking slip report that shows my local table information. Thanks Saravana

Hi All I modified the existing report "oeinv01.rpt" to "aroeinv.rpt". It works fine in local system but if we acscess a remote system and run the report then each line items are printed in seperate page instead of one page. Please guide me what could be the wrong. i also modified the...

Hi, I am trying to fetch records in AR invoice for a particular date range using views. Here i am using the following line .Browse "datermit >=" & txtInvDateRangeFrom & " and datermit <= " & txtInvDateRangeTo, True but it is not working. But if i use only browse "",true then it gives me all...

Hi everyone, I will look at all the invoices that have been fully paid in the selected month for the selected customer or salesperson. All the selected invoices will be printed. I am using accpac version 54A. i want to know the procedure to catch the above. Please help me. Thanks...

Hi I use the following code for opening the item details (Note : OnRecordChanged event) Session.Open userID, Password, Company_id, Date, 0 Dim Item_details As ACCPACXAPILib.xapiView Set Item_details = Session.OpenView("ic0310", "ic") i want avoid hard coding the...

Hi Everyone, Here i use the following code to get user id , company id and company name in my development part . Session.Init "", "PO", "PO1210", "54A" userID = SignOn.SignOn(Session) userID = Session.userID Company_id = Session.CompanyID but i want to know the password for which user...

Hi I am trying to change the line item comments /instruction for existing POs from other modules. .i use the following code it works but i have no result. Dim ITEM_WISE_Note As ACCPACXAPILib.xapiView Dim Session As ACCPACXAPILib.xapiSession Set Session =...

Hi Everyone , I am going to develope a new utility which is run under the "Order entry module" in AAs5.4. i have a doubt. How to integrate the new, sql tables in AAS 5.4. Please give me a solution for the above. Thanks Saravanan.

Hi, How Can I connect to ACCPAC 'server' remotely to post the AAS data by views using xAPI where the local system doesnt have the AAS ? if you have any idea about this pls explain. Thanks Saravanan

Hi I tried the macro which is shown below, to create a PO return in AAS5.4A. It works fine and creates a new PO return entry in ACCpac. But the problem is i am inserting multiple line items (line1, line2,line3...), but only one line item is displayed in Accpac 5.4A (i.e last line item is...

Hi I am looking in Order entry module. Thanks Saravanan.T

Hi I tried the macro which is shown below, to create a PO return in AAS5.4A. It works fine and create a new return entry in ACCpac. But the problem is "there is no change in the "quantity on hand" for the item . Please guide me where i was wrong. Dim TCOMMENT As String Dim...

Hi, If the PO type is blank we cannot post any purchase order. what is the use of blanket purchase order? or PO Type ? please expalin me.. Thanks Saravanan

Hi Version accpac 5.4A Thanks saravanan.T

Hi, The sample macro is given below, which is very long. Still i am having a problem when i insert an order detail. it is generating an error, Internal errror "Order detail". "Operation is not allowed" i also use session.errors for traping the error. But i am unable to fix the bug. Please...

Hi, I tried this macro. when we run the macro while it reach the line Oheaderfields("CUSTOMER").value = "1200". it is generating an error "view call failed". if i use oHeaderFields(word(0)).Value = str((word(1))) it is working. But when i insert the Header information it is generating...