Re: How can I create an invoice form for submitting to a WSS 2.0 List

Clay Fox — Mon, 07 Jul 2008 04:59:26 GMT

Hi There.

You have found one of the deficiencies of SharePoint. It is a flat data structure. So you cannot display repeating elements or relational structures.

The best solution is to use SQL. I have done this same thing many times with the Database Accelerator from www.qdabra.com. You can have any relational data you want and be able to create truly enterprise solutions.

How can I create an invoice form for submitting to a WSS 2.0 List

tcheung — Sat, 05 Jul 2008 04:43:02 GMT

Hello,

I have created a Receivable List on WSS 2.0 to track various payments to be received. This list allows only 1 item category per row (ie labour charge category is on one row, utility charge category is on another row, etc). However, each invoice we send out to clients will contain a multiple of these type of various charges.

I'd like to create an Invoice Form such that:

1) the billing department user can create an invoice with the different charges on a single form (rather than entering the different charges line by line on the Receivable List).

2) the items added onto the invoice form will be added onto the Receivable List automatically (if there are 2 items charged, there'd be 2 rows entered on the Receivable List).

3) the invoice form can be printed and sent to client, and saved on WSS 2.0 so we can retrieve, track, and view say a year later on what we charged at when and to whom.

I unfortunately have not found any tutorials online that can show me how to do this without resorting to the use of an external dB or some coding. Is this possible with just using Infopath and WSS 2.0? If so, can someone show me how? Thanks.

Browser Forms

Re: How can I create an invoice form for submitting to a WSS 2.0 List

How can I create an invoice form for submitting to a WSS 2.0 List