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