Skip to main content
Question

How to add due date on SO PDF?

  • Nov 3, 2026 5:15 PM UTC
  • 1 reply
  • 3 views
  • Translate All

Forum|alt.badge.img

Hello all,

I have been try to add Due date based on the terms for the Customer under SO PDF (SO641010). has anyone added or if anybody could guide me?

 

Any help would really be appreciated.

1 reply

Steve Milner
Varsity III
Forum|alt.badge.img+6
  • Varsity III
  • Nov 3, 2026 5:29 PM UTC

@Harry the field is already in SO641010's schema as [SOOrder.DueDate], but it prints blank on a regular sales order. The order only calculates a due date from its Invoice Date. It only gets an Invoice Date on order types that don't require shipping and have Bill Separately turned on, like IN or CS orders. On the SO type it stays empty no matter what terms the customer has.

So calculate it in the report instead. The Terms table is already joined to SOOrder in SO641010 (it fills the TERMS box), so you don't need a new relation. Add a textbox next to TERMS:

=IIf([Terms.DueType]='N', DateAdd([SOOrder.OrderDate], 'd', [Terms.DayDue00]), Null)

That covers Fixed Number of Days terms like 30D. The other due date types (end of month, day of next month and so on) each need their own branch. Check the Due Date Type on Credit Terms (CS206500) to see which ones your customers actually use.

Treat the printed date as an estimate. The invoice calculates its own due date from the invoice date, so if you invoice later than the order date the two won't match. If you'd rather count from the delivery date the report already prints, use [SOOrder.ShipDate] in place of [SOOrder.OrderDate].

Translate