Results 1 to 5 of 5

Thread: Keeping a log of invoice modification

  1. #1

    Thread Starter
    Hyperactive Member Mike Storm's Avatar
    Join Date
    Jun 2017
    Location
    Belgium
    Posts
    425

    Keeping a log of invoice modification

    Hi,

    In mi application i want to keep track of modifications made to invoices affter they have been printed...
    In ideial conditions if there is something that is not correct when a user emits a invoice, would be created a credit or debit doc.
    Sometimes it does not go like that, the document gets returned and modified.

    So i was thinking of having a table to log this modifications, where column 1 would represent invoice number, Column 2 date of emition, column 3 date of modification and then the columns with product description, quantity, unit price and total value ans well as column for the respective user that emited the invoice and the user that executes the modification.

    Is this the correct way of doing it or is there a better solution, will this bring me any issues on the database?

  2. #2
    PowerPoster
    Join Date
    Jun 2015
    Posts
    2,224

    Re: Keeping a log of invoice modification

    sounds pretty typical to me.
    Not sure what Database you're using, but the standard is to have triggers automatically populate the history tables.

  3. #3

    Thread Starter
    Hyperactive Member Mike Storm's Avatar
    Join Date
    Jun 2017
    Location
    Belgium
    Posts
    425

    Re: Keeping a log of invoice modification

    Hi,
    Im using a SQL database.
    Never worked with triggers, can you indicate me a tutorial related to this subject please?

  4. #4
    PowerPoster
    Join Date
    Jun 2015
    Posts
    2,224
    Last edited by DEXWERX; Aug 7th, 2017 at 03:38 PM.

  5. #5

    Thread Starter
    Hyperactive Member Mike Storm's Avatar
    Join Date
    Jun 2017
    Location
    Belgium
    Posts
    425

    Re: Keeping a log of invoice modification

    Thanks

Posting Permissions

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



Click Here to Expand Forum to Full Width