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

    Linking two unrelated tables

    Hi all, Give me some time to prepare more info so that you guys have a clearer picture. Maybe tomorrow. Thanks,
  2. 136jooseng

    Linking two unrelated tables

    Hi all, I am not a VB user. I could only write report in CR (OEM version of ACCPAC). Can I issue command like UNION in CR. If so, how??? Thanks.
  3. 136jooseng

    Linking two unrelated tables

    I have 2 tables: GLPOST (posted accounting entries) GLPEND (pending accounting entries) These tables are not linked. However, they do have some fields that are the same (since the pending entries will ultimately become posted entries, when posting procedure is activated) Can I put these...
  4. 136jooseng

    Need Codes to run Crystal Rpt from ACCPAC

    Yes, I'm using CR 7.0 How do I compile a report? I can't find any button for Compiling, even though the supplementary toggle tool button is pressed.
  5. 136jooseng

    Linking Invoice table to Payment table

    Thanks again for the replies. There were 3 tables: Customer,Invoice,Payment I don't know how to use running total field that evalutes only on the first record of each group by invoice number. Can you explan in more details? is it true that I cannot issue any selection statement for Payment...
  6. 136jooseng

    Linking Invoice table to Payment table

    Thanks for the replies. I moved the invoice info to the details-a and payment info to details-b. I met with 3 problems:- 1. Some invoices were paid by instalments. As such, where there were 4 payments, the invoice info appeared 4 times. 2. Some payments transactions were system-generated...
  7. 136jooseng

    Linking Invoice table to Payment table

    I am using CR 7.0 to run reports for ACCPAC a/c software. I have 2 data tables in ACCPAC. AROBL - invoice info AROBP - payment info Objective - to show all invoices status, unpaid, fully paid or partially paid. (Invoice info was in the group header, payment info in the details) I link these...
  8. 136jooseng

    Need Codes to run Crystal Rpt from ACCPAC

    I am just an accountant user of ACCPAC for Windows. I use Seagate Crystal Report to write simple reports. One such report is an Analysis of GL Posting Data. The selection parameters are: From_FiscalYear, To_FiscalPeriod, From_FiscalPeriod, To_Fiscal Period. How can I run this CR from ACCPAC...

Part and Inventory Search

Back
Top