How can I create an invoice form for submitting to a WSS 2.0 List - InfoPath Dev
in

InfoPath Dev

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

Last post 07-06-2008 09:59 PM by Clay Fox. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 07-04-2008 09:43 PM

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

    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.

  • 07-06-2008 09:59 PM In reply to

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

    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.

Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.