Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. bodlela

    Dump without .DCT files

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

    "Reconciliation date XXXX is in a locked period"

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

    Error: Invalid input with Home currency transaction

    It is Generated by CB module
  4. bodlela

    Error: Invalid input with Home currency transaction

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

    Get AR Customer Total Outstanding Balance

    Hi DjangMan, You are the man. Thanks a lot BR
  6. bodlela

    Get AR Customer Total Outstanding Balance

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

    Get AR Customer Total Outstanding Balance

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

    Get AR Customer Total Outstanding Balance

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

    Day End Processing Error - OE Shipment

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

    Day End Processing Error - OE Shipment

    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 '...
  11. bodlela

    Day End Processing Error - OE Shipment

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

    Day End Processing Error - OE Shipment

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

    Day End Processing Error - OE Shipment

    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)...
  14. bodlela

    Day End Processing Error - OE Shipment

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

    Password change is required.

    Hi The problem was in the database setup > security. The server IP was wrong. Thanks for supporting. Regards
  16. bodlela

    Password change is required.

    Hi Thanks for responding. We even crate a new user with no luck. We are still getting the same message. Regards
  17. bodlela

    Password change is required.

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

    AR/AR Revaluation

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

    VB6 - Refrerenced memory at 0x0000000c could not be &quot;read&quot;

    Thanks guys. It is working now.
  20. bodlela

    VB6 - Refrerenced memory at 0x0000000c could not be &quot;read&quot;

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

Part and Inventory Search

Back
Top