Personally, I prefer control separatelly Planned date and Due date.
In our company, Due date enter by Sales and Purchasing team or pulled automatically from contact.
Then, Finance team enter Planned date to confirm payment date and genearate Payable invoice report to checking.
If planned date is blank, no need to pull the due date automatically instead.
Said report have each column and able to sort indivdually.
In case of below, if we specify planned date, pick up only B.
A Due date: 27.Dec Planned date: Blank
B Due date 27.Dec Planned date: 27.Dec
Personally, I prefer control separatelly Planned date and Due date.
In our company, Due date enter by Sales and Purchasing team or pulled automatically from contact.
Then, Finance team enter Planned date to confirm payment date and genearate Payable invoice report to checking.
If planned date is blank, no need to pull the due date automatically instead.
Said report have each column and able to sort indivdually.
In case of below, if we specify planned date, pick up only B.
A Due date: 27.Dec Planned date: Blank
B Due date 27.Dec Planned date: 27.Dec