How and Where I should store user accepted values
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3

Thread: How and Where I should store user accepted values

  1. #1
    Join Date
    Apr 2011
    Posts
    3

    How and Where I should store user accepted values

    Hey guys ....

    Good day!

    I have developed a simple accounting system in VB6 with access as database. In my program I need to post SALES/PURCHASE

    Transactions to relevant GL account heads. for this purpose I should know GL ACCOUNT CODES for "SALES" and "PURCHASE".

    Please note that these account codes are Autonumbers and I have to get these codes from access table.

    My question is how and where I should store these codes (and several others) to get them in my GL Posting program? right

    now I am storing these codes in a table named PARA FILE. I don't know if its a good way to store these fix values.

    Any type of help would highly be appreciated

    Best Regards

    ZEE

  2. #2
    Join Date
    Jul 2001
    Location
    Sunny South Africa
    Posts
    11,099

    Re: How and Where I should store user accepted values

    OK, so what is it exactly what you're trying to do?

  3. #3
    Join Date
    Apr 2011
    Posts
    3

    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 ...

    Best Regards

    ZEE

Posting Permissions

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


Windows Mobile Development Center


Click Here to Expand Forum to Full Width

This is a CodeGuru survey question.


Featured


HTML5 Development Center