Page 4 of 4 FirstFirst 1234
Results 46 to 57 of 57
  1. #46
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101

    Hi Greg,

    Would it be safe to say that for options 1,2 and 3 (VAT deductible transactions) we need to add two records to the GL table, one to capture the NetValue/ContraAccount and the other to capture the appropriate VAT amount/VAT Account?

    Cheers,
    Vlad
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  2. #47
    Greg is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jun 2020
    Posts
    44
    Yes in the debit side two, one for cost (NetValue/ContraAccount) and one for VAT (VAT amount/VAT Account). On credit side is one only.

  3. #48
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Hi Greg,

    Here you are, I think it works as you expect it now.

    Cheers,
    Attached Files Attached Files
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  4. #49
    Greg is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jun 2020
    Posts
    44
    Hi Vlad,

    it works perfect now! Thank you!

    The only problem is now that I don't know how you put it all that things together.
    I hope I can still ask you if I add later some new tax transactions. Thank you very much and I wish you a nice day!

    Greg

  5. #50
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Hi Greg,
    Glad to hear! I'm sure you can figure out what I did by examining the code and queries involved. For the credit side the record is added in code by using the recordset.AddNew method with all inputs coming from the main form(EntryHead). The debit side records are added by the append query which is based on a new union query (in order to add the NetValue and VAT portions of the VAT-deductible transactions).
    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  6. #51
    Greg is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jun 2020
    Posts
    44
    Hi Vlad,

    May I ask for advice to leading me in the right direction.
    If I want to add yet another VAT Form specifically for outgoing invoices, let’s say form VAT3. Form VAT2 is only intended for the incoming invoices and it would be to long if I added additional columns to this form.
    How should I do this? Should I add additional append/delete Queries as it were already done for VAT2 form or I need just need somehow rework existing queries?

    For example I somehow managed to rework the existing queries mainly by changing source from VAT2 to VAT3 under the criteria. But in this way, of course, transfers (post to GL) from the VAT2 form no longer work.

    I appreciate your response and help.
    Cheers

  7. #52
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Hi Greg,

    Sorry, I've been away for a few days. It all depends on your business rules/user preference. You could design one master form where you select the type of invoice (incoming vs. outgoing) and change the rules accordingly or you could have two forms (VAT2 for incomming and VAT3 for outgoing) and open the right one based on the invoice "type". You would have to obviously adapt the queries (and maybe the VBA code) for each case , but that should be easy if you follow the existing ones.

    Cheers,
    Vlad
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  8. #53
    Greg is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jun 2020
    Posts
    44
    Thanks Vlad! I was thinking having two forms based on invoice type. Do you think in this case I would only have adapt existing queries or I would also have to add additionally queries e.g. another append query, another delete query, and additional "selected" queries which were made for VAT2 form? I hope I'm not asking you too much in detail where the answer is more complex. I would like to have some guide in which direction I need to continue by adding another form. Thank you again.
    Cheers

  9. #54
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Hi Greg,

    It would be easier to create two separate sets of queries to go with the two forms. It could be done with one set but you would have to create some custom VBA functions for the Account and Debit fields to return the proper value based on which form is loaded.
    So I would say just leave the ones for VAT2 the way they are and make copies of them and adapt for the new frmVAT3.

    Cheers,
    Vlad
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  10. #55
    Greg is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jun 2020
    Posts
    44
    Hi Vlad,
    does it mean that I also make a new Union Query for the new frmVAT3 as well?

  11. #56
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Yes, I think so.
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  12. #57
    Greg is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jun 2020
    Posts
    44
    Thank you Vlad agian for your last tips! I've managed to make transfers for another form VAT3. I have some new problems, but I opened a new topic for this purpose. If you were interested here are some more details. https://www.accessforums.net/showthr...946#post459946

    Cheers
    Greg

Page 4 of 4 FirstFirst 1234
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 12-09-2016, 08:58 AM
  2. Replies: 1
    Last Post: 04-06-2016, 09:26 AM
  3. Replies: 2
    Last Post: 07-29-2015, 07:50 AM
  4. Replies: 4
    Last Post: 03-29-2014, 01:29 AM
  5. Replies: 1
    Last Post: 01-24-2013, 05:50 PM

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