Alpha Video Training
Results 1 to 5 of 5

Thread: Export Invoice with Header & Line Items

  1. #1
    Tom Petrou
    Guest

    Default Export Invoice with Header & Line Items

    Is there a way as in access to print and invoice with the header and line items together as one text file?

    In the export function, you can only export the header or line items.

    Any ideas?

    Thanks,

    Tom Petrou

  2. #2
    Member
    Real Name
    Bill Warner
    Join Date
    Apr 2000
    Posts
    905

    Default RE: Export Invoice with Header & Line Items

    When you export, you can select any of the fields from any of the tables in a set. Therefore, if HEADER is your parent table and ITEMS is your one-many child table, you can export whichever fields you need from both HEADER and ITEMS.

    Keep in mind that if, for example, you have two parent records, and the first has 3 child records and the second has 5, you will get a total of 8 records exported. The parent record fields will be duplicated for each child record you have in that parent.

  3. #3
    "Certified" Alphaholic
    Real Name
    jim chapman
    Join Date
    Apr 2000
    Posts
    1,779

    Default RE: Export Invoice with Header & Line Items

    Hi Tom,

    As Bill has replied, you sure can export this way. However, I'm confused by what you mean by 'print and invoice.... as one text file'. Are you saying that you want the 'report' printed and saved as a text document, all records as one text file?

    You could write a simple xbasic routine that stepped through the records extracted the wanted data and then wrote the data to a text file, or to another *.dbf file in a different format.

    Jim

  4. #4
    Tom Petrou
    Guest

    Default RE: Export Invoice with Header & Line Items

    Thanks for the info. I will give it a try.
    Regards:

    Tom Petrou

  5. #5
    Tom Petrou
    Guest

    Default RE: Export Invoice with Header & Line Items

    Jim:

    Thanks for the Idea. I will also give this approach a try.

    Tom P.

Similar Threads

  1. Qlinker Invoice Items
    By Greg Suhok in forum Alpha Five Version 5
    Replies: 1
    Last Post: 01-17-2004, 11:01 AM
  2. Calculated Field in Invoice Header
    By Jay Sims in forum Alpha Five Version 5
    Replies: 13
    Last Post: 01-16-2004, 08:25 AM
  3. Saving invoice totals to Header
    By Jeff, Richards in forum Alpha Five Version 5
    Replies: 13
    Last Post: 06-03-2003, 08:42 PM
  4. trouble with invoice items
    By Joyce Kinmont in forum Alpha Five Versions 2 and 3
    Replies: 1
    Last Post: 04-14-2001, 06:50 PM
  5. LineItems subtotal in Invoice Header
    By Mike Konoff in forum Alpha Five Version 4
    Replies: 6
    Last Post: 07-24-2000, 05:58 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •