Hi,
Until recently, all my clients have agreed to 30 days from date of invoice as the due date. This is calculated by Sage (correctly) and shown on the invoice.
Now I have a couple of new clients who want invoices by 3rd week of the month to be paid by the end of the following month. I can't add a number of days as it (occasionally) either throws me to the beginning of the month after (which is unacceptable to me) or too early in the month (unacceptable to the clients).
On the individual customer record, in the Credit Control section, I have tried setting the Payment Due From to "days before the last day of the following month" and have set the Payment Due to both 0 (but that simply added 30 days to the Invoice date) or 1 (thinking to say 30 or 29 wouldn't be far out) - but that simply added 1 to the invoice date.
I'm assuming that EITHER I need to pick another variable in the Report Designer (for all other customers, I'm using an expression: INVOICE.INVOICE_DATE + SALES_LEDGER.PAYMENT_DUE_DAYS) OR I need to make a relatively complex expression? What do I need to change?
Alison