Search results

My problem: I got 2 suppliers to fulfill one order. Which means I have 2 Purchase Order numbers and one invoice number. When customer sends payment, I need to record the payment receive date against both Purchase Order numbers. Sometimes I can have lots of purchases to fulfill one order and I...

Attach is the sample database I made. I appreciate you trying to help me. I tested the calculated field you mention, but the due date shows as error (see DueDateTEST qry).

Thats correct. Perhaps this example will help. Base on PayTerm "Sight DP", due date should be same as InvDate. Agent CUST OrderID InvoiceNo. Sales PayTerm ETD ETA InvDate DueDate A1 XYZ 202108 INV1 $10000 SIGHT DP 7/18/2021 9/4/2021 8/11/2021 8/11/2021 Or if PayTerm is...

Just the DueDate. Hence why I created the queries to calculate it. The rest of the dates are entered.

I have these fields in my table: Field Name Data Type Description ID AutoNumber Agent Text Sale Agent CUST Text Customer Name OrderID Text Sale order number InvoiceNo. Text Invoice number Sales Currency Sales Amount PayTerm Text Payment Terms ETD Date/Time Estimate Time of...

In my query, I have following fields: PayTerm, InvDate, DateMature, ETD, ETA, and DueDate. Base on the payment term, I'm trying to have database auto-calculate the Due Date in the query. Then update the due date in the table. The problem is that I have many payment terms. I try to fit them all...