Due-date or payment date on invoices

[Former Member]

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!!!

[Former Member · Accepted solution]

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.

[Lakshmipathi]

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

[Former Member]

Hi,

Check BSEG table and the filed "Baseline payment dte".

[Former Member]

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

[Former Member]

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

[Former Member]

hi pandey could you tell that function module .i searched i didn't get pls urgent.