-
Aug 7th, 2017, 02:14 AM
#1
Thread Starter
Hyperactive Member
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?
-
Aug 7th, 2017, 02:31 PM
#2
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.
-
Aug 7th, 2017, 02:33 PM
#3
Thread Starter
Hyperactive Member
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?
-
Aug 7th, 2017, 02:39 PM
#4
Re: Keeping a log of invoice modification
Last edited by DEXWERX; Aug 7th, 2017 at 03:38 PM.
-
Aug 7th, 2017, 02:40 PM
#5
Thread Starter
Hyperactive Member
Re: Keeping a log of invoice modification
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|