Results 1 to 8 of 8
  1. #1
    marianne is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2009
    Location
    Asia Pacific Region
    Posts
    150

    design problem

    hello all!

    i have this problem. how do I automate creating an accounting journal entry when I enter quantities and amounts of sales transactions or any transaction there is. I cannot figure it out how to automate that one.

    can someone give me an idea please or example perhaps so I can study it. thanks.

    I have an idea in my mind but it is very vague for me.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Hi Marianne,
    I'm not sure what you mean when you say "accounting journal entry". Are you talking about an Accounting System of some kind?

  3. #3
    marianne is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2009
    Location
    Asia Pacific Region
    Posts
    150
    yes RG. its something like accounting system. what I would like to do is when I am in entering items of sale and something like amount of discount, it will automatically generate accounting entry for the sale and discount.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Do you have something like a Finalize button? If so, you can create any amout of records you want.

  5. #5
    marianne is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2009
    Location
    Asia Pacific Region
    Posts
    150
    no I do not have. but I can build one. I was thinking instead of building finalize button, I can incorporated the codes in the finalize button in the save button.

    I dont get what you mean about" If so, you can create any amount of records you want."

    RG, I would like to automatically generate account entry from entering sales and discount transaction like this one:

    cash 10,000
    sales 8,000
    discount 2,000

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I'm afraid I still do not completely understand your issue Marianne. Appearantly just binding your form to a query is not adequate for your process. How about just using the BeforeUpdate event of the form to run the other Update queries you need to keep the accounting records up to date? No Save/Finalize button needed.

  7. #7
    marianne is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2009
    Location
    Asia Pacific Region
    Posts
    150
    actually i think this does not involve queries RG. i think this just involve setting up my chart of accounts and setting up what account title to be used on a specific transaction. thereby like when I input sales discount of 2000, if will automatically create sales discount entry in one field in my subform.

  8. #8
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You are probably correct Marianne. I'm not up to designing an accounting system at this point in my life. If I can help in some other way, just post.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Table design problem
    By wasim_sono in forum Database Design
    Replies: 0
    Last Post: 04-08-2009, 06:21 AM
  2. Relationship Design
    By krymer in forum Database Design
    Replies: 3
    Last Post: 11-28-2008, 09:09 PM
  3. Database Design Problem
    By Kurth in forum Access
    Replies: 0
    Last Post: 08-14-2008, 04:09 AM
  4. Forms design problem
    By GeorgeD in forum Forms
    Replies: 2
    Last Post: 05-08-2008, 12:28 AM
  5. Design help
    By marix in forum Database Design
    Replies: 1
    Last Post: 04-18-2007, 07:54 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums