Results 1 to 2 of 2
  1. #1
    Alex Motilal is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Nov 2008
    Location
    Coimbatore, India
    Posts
    192

    Query to extract balance payment amount

    I am using a Database which involves processing and disposal of Cotton Lint and Cotton Seeds. Buyers pay amounts on different days against their contracts. Deliveries are made subsequently. What is the buyers credit balance is easily known. What I want to know is, if it is possible to create a query so that what balance is against a particular payment.


    When a buyer takes delivery, the invoice value should adjust from the payment, in which balance is there & shortage should be adjusted from the next payment & the query should be able to show the balance of each payments.

    Thanks

  2. #2
    Mickjav is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Mar 2019
    Location
    Margate, Kent
    Posts
    123
    Total Invoiced - Total Receipts will leave the ballance to be paid but we would need to see the tables to be able to create you a query

    mick

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

Similar Threads

  1. Replies: 7
    Last Post: 06-15-2017, 02:36 AM
  2. Replies: 11
    Last Post: 11-28-2015, 10:14 PM
  3. General Ledger Query With Opening Balance and Running Balance
    By muhammadirfanghori in forum Queries
    Replies: 3
    Last Post: 03-12-2015, 07:17 AM
  4. Replies: 12
    Last Post: 07-18-2014, 01:22 PM
  5. Replies: 4
    Last Post: 01-21-2014, 10:39 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