Relationship Between PaymentCondition and PaymentTermTemplate Entities
Introduction
The PaymentCondition and PaymentTermTemplate entities can be used as standard entities. However, both the entities are related to each other whereby creating a record for one of the entity might create a record for the other entity.
Description
The PaymentCondition entity has a parent-child (1 to many) relationship with the PaymentTermTemplate entity. Thus, if you create a record in PaymentCondition, it might or might not create a record in PaymentTermTemplate. This depends on the DueDateType value.
To create a PaymentCondition record that will automatically create a PaymentTermTemplate record
Set the DueDateType to any value except “9” (refer to Figure 1). A record will be automatically created in the PaymentTermTemplate entity with the TermPercentage property = 1.
To create a PaymentCondition record without creating a PaymentTermTemplate record
Set the DueDateType value to “9”. No record will be created in the PaymentTermTemplate entity and you will have to manually create a record in the PaymentTermTemplate entity.
|
DueDateType |
Description |
|
1 |
Date + Payment Term |
|
2 |
Date -> End of the month -> Day of the month |
|
3 |
Date -> End of the next month -> Day of the month |
|
4 |
Date + Payment Term -> End of the month -> Day of the month |
|
5 |
Date + Payment Term -> End of the next month -> Day of the month |
|
6 |
Date + Payment Term -> x.end of the month -> Day of the month |
|
7 |
Date + Payment Term (in months) |
|
8 |
Date -> End of the month + X months |
|
9 |
Terms |
|
A |
Invoice Date + Payment Term |
|
B |
Order Date + Payment Term |
|
C |
Fulfillment Date + Payment Term |
|
D |
Order Confirmation Date + Payment Term |
Figure 1
More than one line can be created for the PaymentTermTemplate entity if the value of the PaymentCondition property is the same and refers to the PaymentConditionCode property in the PaymentCondition entity. For the lines that are created for the same PaymentCondition property, the total sum of the TermPercentage property must be “1” because the system does not provide validation on the TermPercentage property. For example,
PaymentCondition
PaymentTermTemplate
|
PaymentCondition |
PaymentDays |
TermPercentage |
|
T2 |
10 |
0.2 |
|
T2 |
30 |
0.8 |
In the example above, the TermPercentage column of 0.2 + 0.8 = 1
Related document
| Main Category: |
Support Product Know How |
Document Type: |
Online help main |
| Category: |
On-line help files |
Security level: |
All - 0 |
| Sub category: |
General |
Document ID: |
19.927.380 |
| Assortment: |
Exact Synergy Enterprise
|
Date: |
05-01-2010 |
| Release: |
243 |
Attachment: |
|
| Disclaimer |