on 12-03-2007 8:35 AM
Hello,
we want to print a due-date or payment date on our invoice documents based on the billing date + payment term.
Simple example:
billing date = 1.12.2007
payment term = 30 days net
due date = 31.12.2007
Does someone know how to calculate this within Smartforms?
Very important for us is that the function knows how to handle the different payment terms, means just a date calculation is no enough.
Thx. a lot!!!
Use the FM
J_1A_SD_CI_DUEDATE_GET
ITEM_DERIVE_FIELDS
In BSID I do not think there is invoice due date field available. "Inv Due Date" is not invoice due date. Pl check.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Wolfgang
Yes this could be possible with the help of ABABer.
Whatever Payment Terms you are maintaining are stored in Table <b>TVZBT</b>. From the said table, extract the description of Payment Term and take the numeric value, say for example for "<i>0002</i>" the description would be 15 days net. In this, <u>you have to read it</u> to get numeric "<b>15</b>" and subsequently, use a function module to add this number with the billing date.
But ensure that you have to maintain in all texts of Payment Terms some numeric value; even for immediate payment, you have to maintain "0" value. Then only, that numeric value can be read and your requirement can be met.
All this can be done by a ABABer.
Thanks
G. Lakshmipathi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Check BSEG table and the filed "Baseline payment dte".
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You can get this date in BSID table,can you check it by giving accounting document.Here in this tabel there is a field called Inv. due date there you can get this.
Regards,
Chandra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Ask ur ABAPER to take value from VBRK-ZTERM.
Put this value in T052 Table and pick value T052-ZTAG1
Add the no. of days i.e the value in T052-ZTAG1 with the billing date .
This will be ur payement due date.
There is one standard function module to calculate date i.e it will directly add the value in Field T052-ZTAG1 with the Billing Date .
Hope this help
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
102 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.