Recent content by bodlela

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

It is Generated by CB module

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 DjangMan, You are the man. Thanks a lot BR

Hi Tuba2007 Thanks for responding. I am following your suggestion but I still cannot get the same figure as the Accpac is showing for O/E pending balance. "select * from ARIBH where IDCUST='XXX' and DATEBUS=0" retuns no rows. "select SUM (ordtotal) from OEORDH where customer='XXX' and...

Hi Ettiene Thanks for replying. I understand ARCUS.AMTBALDUET/AMTBALDUEH refers to Outstanding AR Balance but I need the Total Outstanding Balance which include the AMTBALDUEH/AR/OE/Other pending balance. Please advice

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.

It hangs on that shipment then pop up a window with ERROR as title and "Day End Processing could not process all transactions." as a message.

Hi all the day end is stopping on the shipment number SH1400005083. Below is the RVSPY from the moment that shipment is loaded up to the Error. PLease advice. [21bc.7ff.1418] * field=11, size=22, buffer='\53\48\31\34\30\30\30\30\35\30\38\33\20\20\20\20\20\20\20\20\20\20' -> 'SH1400005083 '...

Ettienne, Like I said, I made a second post replying to the first. Please search for: [21bc.7ff.1418] 9002 <==[12:08:45.04;t=125;ovh=125] {**ERROR**} Please advice

Sorry Ettiene I made a second post replying to the first post...just search on your internet browser for ERROR please. Sorry again Thanks

I am sorry. The correct RVSPY is this one [21bc.7ff.1418] OE0560: OEPOSTC [12:08:06.72].Put(view=0x0B087CD4, field=3, size=4, verify=0, buffer='\00\00\00\00' -> '????') [21bc.7ff.1418] 0 <==[12:08:06.72;t=0;ovh=0] {} [21bc.7ff.1418] OE0560: OEPOSTC [12:08:06.72].Init(view=0x0B087CD4)...

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 The problem was in the database setup > security. The server IP was wrong. Thanks for supporting. Regards