Search results

I need to be able to do the following: 1) Record an invoice (total amount only) linked to the Cust ID. 2) Be able to record a payment against an invoice (both partial payments, and payments for multiple invoices) 3) On a form, when I am ready to record a payment I need to be able to...

I last question... Since I could not enter both an Inv ID and a Payment ID (re: recording an invoice or paying an invoice) on a single entry those could not be required fields, am I right? or am I missing something. Thanks so much for your help.

Final should look like this, right? Thanks for your help! Customer CustID Other Fields Invoice InvID InvCustID InvDate InvAmt Payment PymtID PymtCustID PymtDate PymtCk# PymtAmt InvoicePayment IPID IPInvID IPPymtID IPAllocAmt

I tried uploading a doc file to show my design along with the question I had above. Thanks.

Forget the above as it did not paste properly. I will post an image below.

I have the final as follows: (Note question below) Data Entity Fields Key Type tblInvoice InvNum P Text InvCustID Text InvDate D/T InvAmt Curr InvNotes Memo tblNonInvoice...

Thanks much, I will work on it today and if any problems will repost. Appreciate your help.

The Inv Amt needs to be offset by the Payment amount so that I can calculate the bal on an invoice. Will this junction table do that? I'm not sure.

I need to set up a database to record invoices (only the # and total amt, no line item breakdown). I then need to apply payments against the invoice(s) and find the current balance. Thus far I have the following: tblCustomer (CustID, other fields) tblInvoice (Num, CustID, Date, Amt)...