If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register or Login
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Re: How and Where I should store user accepted values

Re: How and Where I should store user accepted values

OK Let me explain it a bit further ...

I have a program thru which user inputs all his sales invoices details like Customer Code, product Code, Qty, Rate, Amount etc ...

Now later after confirmation he needs to post the invoice amount to that particular customer's GL Account. structure of GL Transaction table contains Debit Account Code (which is the Customer Account Code), Credit Account Code (which is the SALES Account Code in this case), Transaction Amount (which is the total amount of that particular invoice.

Customer Account Code i can get from Customer Table
Amount I can get from Sales Table

But for Sales Account Code I need to store it some where so that whenever the user post invoices to General Ledger then I could take SALES ACCOUNT CODE from that place to inset records in GL Transaction table ...

For this purpose currently I am storing this SALES ACCOUNT CODE in a separate table and retreive it from there at the time of posting ... so I just want to ask if its the right practice or there could be some better option?

note that its just an example. I have to store several values like this in that table ...