Page 2 of 2 FirstFirst 12
Results 16 to 18 of 18
  1. #16
    Perfac's Avatar
    Perfac is offline Expert
    Windows 10 Access 2016
    Join Date
    May 2016
    Location
    Centurion Pretoria
    Posts
    618
    No KD2017. With humble respect, in my threads I described it comprehensively. It updates the unit price when fields quantity, and Inventory Item(SubLdgAcc) is edited, after opening any invoice. After the idea I mentioned last, it works perfect now. No changes of unit price. Thank you very much. I think Microsoft must employ me and Ruben, what do you think Ajax?

  2. #17
    kd2017 is offline Well, I tried at least.
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    1,142
    Quote Originally Posted by Perfac View Post
    Another idea that crossed my mind in the last minute. The Max expression can establish the latest invoice number, then the calculations on the fields "UnitPrice" should not happen if the invoice number is smaller than the current invoice. Or am I nuts? If ever a previous invoice is opened, even the second to last one, it will not recalculate the unit price, that will work.
    This proposed strategy might cause conflict with this requirement

    Quote Originally Posted by Perfac View Post
    I like if an error was made yesterday on an invoice, to edit the invoice and fix it.
    Quote Originally Posted by Perfac View Post
    No KD2017. With humble respect, in my threads I described it comprehensively.
    I wish you the best of luck.

  3. #18
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    hmmmm. think you need to ask Microsoft!

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 03-07-2019, 11:58 AM
  2. Replies: 16
    Last Post: 12-28-2017, 02:04 PM
  3. Replies: 26
    Last Post: 11-02-2016, 10:38 AM
  4. Replies: 5
    Last Post: 03-22-2016, 04:06 PM
  5. Replies: 0
    Last Post: 12-13-2012, 03:18 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