Lookup dash
Nancy Palmquist
nlp at vss3.com
Mon May 22 10:24:06 PDT 2017
Wayne,
I would add that it saves space to use Header/ Detail files.
For example,
If I have a record that is setup to hold 15 line items, then it will
have space for Quantity, price, extension, ship date - maybe backorders
etc. This data will be repeated 15 times on every invoice - even if the
invoice does not have 15 items.
When you setup Header files to hold all the totals, shipping and billing
into, etc and detail files for the line item information, one record per
line item, you just shortened the storage required per invoice.
It gives you better access to reports. I want a report by inventory
part, all I have to do is search the detail. Easy report to write.
If you continue down the One record system for the Invoice, be sure to
setup a unique numbering system. For example, INVNUM-PAGE
so stuff will stay in order.
Nancy
On 5/22/2017 12:30 PM, Richard D. Williams via Filepro-list wrote:
> On 5/19/2017 3:15 PM, Wayne Smith via Filepro-list wrote:
>> Would somebody have an example of how to use the lookup - my client
>> would like to do multiple paged invoices and his business has grown
>> so well
>> over the years he asked me if I could make his existing 15 Item invoice
>> continue to another record in the same file he is in and just add the
>> usual
>> stuff, name, address, city, etc in the free record and start him down in
>> the area where he puts in inventory code. (page 2) with a
>> bal.forward of
>> course.
>>
>> The list has always been useful in the past and will look foward to
>> trying
>> anything....I can't seem to figure it out.
>>
>> Thanks ahead of time,
>>
>> Wayne Smith
>> Port Orange, Florida
>> -------------- next part --------------
>> An HTML attachment was scrubbed...
>> URL:
>> <http://mailman.celestial.com/pipermail/filepro-list/attachments/20170519/31bfd3e9/attachment.html>
>> _______________________________________________
>> Filepro-list mailing list
>> Filepro-list at lists.celestial.com
>> Subscribe/Unsubscribe/Subscription Changes
>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>>
>>
>>
>>
> Wayne,
>
> Sounds to me you need to change your file structure to a
> header/detail, instead of a set 15 item per invoice.
>
> The lookup - syntax does allow you to get a new record within the same
> file and you could copy all the data
> from this invoice# to the new record, clear out the 15 lines and move
> to that record in update mode.
>
> The questions remains, is that really the best method to accomplish
> unlimited item son any invoice?
>
> If you do not know how to create a header/detail I would be happy to
> show you.
>
> Richard D. Williams
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
--
Nancy Palmquist MOS & filePro Training Available
Virtual Software Systems Web Based Training and Consulting
PHONE: (412) 835-9417 Web site: http://www.vss3.com
More information about the Filepro-list
mailing list