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

...String Dim TUNITCOST As String Dim THASCOMMENT As String Dim TVDCODE As String Do Until EOF(1) Line Input #1, inputStr If inputStr = "*" Then Exit Do Else word = Split(Trim(inputStr), " ", 2, 1) Select Case word(0) Case "VDCODE"...

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

...Dim THASCOMMENT As String Dim TVDCODE As String 'READING VALUES FROM FILE Do Until EOF(1) Line Input #1, inputStr If inputStr = "*" Then Exit Do Else word = Split(Trim(inputStr), " ", 2, 1) Select Case word(0) Case "VDCODE"...

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...

...As Variant MsgBox ("1") Open App.Path & "\" & FILENAME For Input As #1 Do Line Input #1, inputStr If inputStr = "**" Then Exit Do Else word = Split(inputStr, ":", 2, 1) If word(0) = "ORDDATE" Then ordate =...