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

    Journal Entries: Wrong total when importing from a sql database

    I used System.Convert.ToDateTime() Still get the same exception. The table that the program gets the data from uses a smalldate to store the value... Can you think of anything else to try?
  2. pacifistk

    Journal Entries: Wrong total when importing from a sql database

    EXCEPTION: System.Runtime.InteropServices.COMException (0x80004005): View call failed at ACCPACXAPILib.xapiFieldClass.PutWithoutVerification(Object newVal) at ACCPAC_Imports.ACCPAC_Main.AddJournalEntry() in n:\ash\accpac_imports\accp ac_main.cs:line 1156 at...
  3. pacifistk

    Journal Entries: Wrong total when importing from a sql database

    I'm importing using the xapi from a c#.net program that I'm working on.
  4. pacifistk

    Journal Entries: Wrong total when importing from a sql database

    Thanks that was it! Now I have 1 more problem, one of my requirements is to be able to post journal entries with a modified date, every date field I try to modify (Batch->created/edited) or (header->dateentry) or (detail->transdate) I get an exception. Which date fields can be modified ...
  5. pacifistk

    Journal Entries: Wrong total when importing from a sql database

    Here is my data going from my source table: Detail...
  6. pacifistk

    Journal Entries: Wrong total when importing from a sql database

    I'm still stuck, the only place I set a value for the credit and debit is in transamt, yet when I import it still goes to zero. Would you mind looking at my test data?
  7. pacifistk

    Journal Entries: Wrong total when importing from a sql database

    Thanks ! So I only need to set the transamt and the scruamt ? Kevin Clough Collages.net
  8. pacifistk

    Journal Entries: Wrong total when importing from a sql database

    I set the JRNLCR = JRNLDR .01 in the header. I set DEBITTOT and CREDITTOT = .01 in the batch I set the trans amt in 1 detail to .01 and -.01 in the other. Accpac shows each entry as 0, and the totals as .02 for credit and debit. Also, my details are not being assigned entry numbers properly...

Part and Inventory Search

Back
Top