Does any one uses this as a payment term? "50% Dow...
# accounting
s
Does any one uses this as a payment term? "50% Down / 50% Net 30" the reason I am asking is due date is same as today when I use this as payment term
a
Did you set days until due to be 30?
s
Yes I did, but then it ignores 50% down due upon receipt
a
Oh so it would first have a due date of today but then once the 50% down payment is applied it would move the due date out 30 days?
s
That’s what I am hoping for, I don’t know if it does that
a
No pricing terms won’t do that. At least I don’t think I would set the days till due, to 0 on the payment term Then use a workflow to move it out 30 days after the down payment is made I bet if you make a saved search of invoices with those payment terms AND Amt Paid/Amount is greater than or equal to .50 Then use that as the criteria for a scheduled work flow In your workflow make the action be Set Field value Field = Due Date Value = {trandate} + 30
s
Hmm so I should have a field on the invoice that says down payment made? Or look at related records of a invoice and if that is greater than 50% then trigger the workflow
Also this is not the only weird one, there are 4 or 5 like this, so I gotta do this for each one of them
a
That is unfortunate. I don’t think I’ve seen anywhere the payment term can control “2 dates” for the due date. You only have 1 value available to control the due date Maybe Billing Schedules would be better. I’m not familiar with Billing Schedules but I think that provides more advanced functionality
a
I do not have an answer since I am new to NS but I have the same issue. I was hoping others knew how to handle this stuff.
a
@Suitestallion sorry just saw your earlier message I would add a checkbox to the invoice called “due date moved” I would make a scheduled workflow based on the Invoice record. The saved search criteria would be Type = Invoice Terms =50% Down/50% Net 30 Formula Numeric = {amountpaid}/{amount} >= 50% Due Date Moved = F Then the state of your workflow has 2 actions 1. Set Field Value action on Entry, Field = Due Date, Value={today} + 30 2. Set Field Vlaue action on Entry, Field = Due Date Moved, Value = T Then if you had multiple terms you could always make a few Set field value actions to move the due date For example, set a condition of terms = 50% Down/50% Net 45 then Set field value to Due Date + 45 And if terms are 50% Down/50% Net 15 the set field value to Due Date+15 Also could you just make 2 invoice one Due on Recipt and 1 Net 30?