Share
ReportWhere does the value of the DSCPCTAM field in SOP10100 come from?
*This post is locked for comments
You’re offline. This is a read only version of the page.
Announcements
Where does the value of the DSCPCTAM field in SOP10100 come from?
*This post is locked for comments
OK. Thanks.
Please note the existence of SY03300.DSCPCTAM. In the SY03300 you can set whether the payment terms are a percent discount or dollar amount. Then on a sales order it will pull up the payment terms assigned to the customer and then apply the payments accordingly. So if there is a percent amount it will take the total of the order multiply by the discount and drop that number into the SOP10100.DSCPCTAM filed. If the amount is a flat dollar amount it will drop that number into that field.
On the order with DSCPCTAM = 0, the pymtrmid is NET 60. In the SY03300 table, the DSCPCTAM value associated with that pymtrmid is 0, For 150, the pymtrmid is 1.5DUE20-BM, which is associated with a DSCPCTAM of 150 in SY03300. For 200, the pymtrmid is 2%10TOFM-T. Again, that pymtrmid is associated with DSCPCTAM of 200 in SY03300. That is why I think the DSCPCTAM value on SOP10100 is coming from the SY03300 table, based on the PYMTRMID. But I would like expert verification of that assumption. None of the orders have a trade discount.
What are the payment terms on those invoices? On any of those invoices are you offering a trade discount?
I think you are misunderstanding my question. I know what the field is used for. But it contains a value that is not entered at the time the order is created. I have three orders. In that field, one has a value of 0, the second has a value of 150 and the third has a value of 200. In none of the three cases did I enter the value. It defaulted from -- somewhere. I want to know where.
This is taken from the SDK.
Discount Available
Freight: The discount available calculated on the freight amount. This field is used in some tax calculations.
Discount Available
Misc: The discount available calculated on the miscellaneous amount. Used in some tax calculations.
Discount Available
Amount: The amount of the discount available on debit type documents, e.g. Quote, Order, Invoice.
Discount Returned: The amount of discounts returned for Return documents only.
Discount Taken
Amount: Amount of discount taken on the document (Not used on Return documents).
Discount Percent
Amount: Used to determine the Discount Available Amount. This field is multiplied by the Total invoice amount to calculate the Discount Available Amount. (Not used if Payment Terms ID is being used).
Discount Dollar
Amount: When a value exists in this field, it will override the setting in the SY_Payment_Terms file for calculating Discount Amount Available for this transaction only. If there is a value in the Discount Percent Amount field, this field will be empty.
Right, but the value in the field defaults from somewhere. It looks like it may be from the SY03300 table, based on the value of the PYMTRMID field for the customer, but I'm still tracking that down.
That is the discount percent amount. If you offer a percentage discount on the invoice this would be the dollar amount of the discount.
#1
Almas Mahfooz
3
User Group Leader
All responses (
Answers (
