Search results for query: *

Hi all Accpac 5.3 Server crushed and the only back up they have is a dump folder where the .DCT files are missing. Is there something that can be done to sort it out? Best Regards

Hi All Client is using Sage ERP Accpac 6.0, MSSQL 2008 Issue In Bank Services, after selecting a transaction to be reversed, the following error occurs: "Invalid input. Reconciliation date XXXX is in a locked period for Bank Services in Common Services' Fiscal Calendar." Note: XXXX refers to...

Hi all, I am having an error message in GL batches: Home currency transaction for account 40000-XXX does not have a rate of 1 OR the source and functional amounts are not equal, when posting this batch entry. The company is multicurrency but it is giving this error. Please advise

Hi All I wonder how Accpac calculates the Total Outstanding Balance we see on the "AR Customer Inquiry - Credit Status Tab". I need to be able to get the same figure from SQL queries. Please advice.

Hi All We are using A4W 6.0 MSSQL 2008 R2. We are having issues running Day End - it stops on a OE Shipment just before the error. below is the RVSPY file. I would appreciate if someone could help me see where the error is coming from. Please advice [764.7ff.358] IQ0070: ICITEM...

Hi All No user is logging in successfully on Accpac. The system keep saying "password change is required." for every users. Accpac 60; MSQL server 2008 database. Please advice

Hi All We are running AR and AP Revaluation in a multicurrency company as we normally do every month but this time no batch is being generated. Accpac 6.0 SQL Server database. Please advice

Hi all My VB6 program made to enter PO Invoices from RCP form is returning "Referenced memory at 0x0000000c could not be read" error on line << PORCP1header.Update >>. This was working in A4W 55A. I just changed it to point to A4W 60A. Please help me figuring out what is wrong in my code...

Hi I developed a web app in .NET that enter transactions on Accpac 5.5 using Accpac.Advantage assembly. Everything works on my laptop but on the accpac server I am getting "Retrieving the COM class factory for component with CLSID {13898C04-C674-4B4E-B5C0-D78AF3E566CA} failed due to the...

Hi all I using the below formula on Excel: =IF(AND(Sheet1(2)!$A$2=Sheet5!$A$2,$D$1=Sheet5!$B2),Sheet5!$C2,"") Where is $D$1, 'D' refers to the column letter. I would like to get it dynamically. I tried to use =IF(AND(Sheet1(2)!$A$2=Sheet5!$A$2,CHAR(64+COLUMN())&1=Sheet5!$B2),Sheet5!$C2,"")...

Hi I trying to create AR invoices from a excel file with no luck. Im getting "null reference exception - Object reference not set to an instance of an object." on the line: ARINVOICE1headerFields.FieldByName("INVCTYPE").SetValue("2", false); // ' Invoice Type Please advice private void...

Hi All I did install Sage Accpac Insight on a PC running win XP and office 2007. But trying to run "refresh" I get the error : "Unknow Analyst dll Error" Any Ideas? Thanks

Hi All Client running Accpac 5.5 SP2 got an IC Transfer that is not coming up when printing IC reports. I did notice that there is nothing related to this transfer on ICIVAL table but I can see it using IC Transfer entry form. Seems like the transaction didnt finish processing! Any idea how...

Hi All I had insight reports that were pointing to the Accpac 5.3 server. I changed them to point to Accpac 5.5 Server because we did Accpac and Insight upgrade. Then running the report is returning nothing!! Any help would be appreciated

Hi there When we enter a P/O invoice the detail line comes by default with the Fully Invoiced option set to 'Yes'. Is there a way to have this option coming by default has 'No' Thanks in Advance

Hi there I need to create a view like gl transaction listing report for bank accounts (11... or 12...) but instead of showing the account transaction I need to see the transaction which the account is dealing with. Some thing like: SELECT GLPOST_1.ACCTID, GLPOST_1.FISCALYR...

Hi all My client did ship 400 unit of an item but just invoiced 30 units. When trying to invoice the remaining qty the system says that the shipment is completed. Can some one explain how the system deals with shipments partially invoiced. On PO module we have the option to do many invoices...

Hi all I am having negative inventory quantities for many items on A4W 5.5 pu2, but we are not allowing negative inventory levels on IC. Also we have QTY received not costed which does not get rid even running day end sucessfully. IC moviment report is showing balance 0 (zero) for a particular...