Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

doc date from ODLN on OINV

Hello,

please, could you help me with the  following problem. We decided to put the real date of  the delivery into the layout of the invoice.

I have used FMS :

ShipDate from Delivery

it could be like following lines:

     IF $[INV1.BaseType] = 15

          BEGIN

               SELECT

                    T0.DocDueDate -- <i>or T0.DocDate</i>

               FROM

                    ODLN T0

               WHERE

                    T0.DocEntry = $[INV1.BaseEntry]

          END

     ELSE

          BEGIN

               SELECT $[OINV.DocDate]

          END

Everything goes well, but it goes also for all already issued invoices, so it doesn´t correspond to the dates on the invoices , which have been already sent to our client´s . It should be a problem during backward checking from  auditors, because a date of delivery in the invoices is different now. ( it has been changed after using FMS.

Could you insert into the query above  that the conditions are valid for the invoices issued  from e.g 01-10-2015?

Thank you in advance,

regards

martina

Former Member
Not what you were looking for? View more on this topic or Ask a question