Payment Terms Comparision..

satish_nav

HI Experts..

I want to compare Payment terms in Purchase order with the vendor payment terms belonging to that PO. But in both tables Payment terms FIELD is defined in Code DataType,, how can i compare this fields.
And i tried to get the diffrence between DueDate and Posting Date.. By this i got Integer but this integer value also cannot compare with the Payment Terms code in Vendor Card..

kine

Code could be compared as normal text - "IF Code1 = Code2 then" or "IF Code1 <> Code2 then"

And i tried to get the diffrence between DueDate and Posting Date

Regarding the dates, what you want to know? That the dates are different? That the DueDate is calculated correctly based on the payment terms? Than just use the payment terms dateformula and apply it to the posting date and compare the result with due date...

satish_nav

By this work, for each PO i want to put a boolean Field to show whether the vendor supplying under Payment terms as defined for that vendor or is they exced.

Here I got problem is that

Date + DateFormula --> Cannot do this Operation
Integer + DateFormula > Cannot do this Operation


Can you Explain me clearly Plz..

kine

Look at CALCDATE function... ;-)

satish_nav

Thank You Kine....I got it. \:D/