doc date from ODLN on OINV

[former_member377478]

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

[agustin_marcoscividanes]

Hi

are you overwriting the due date in invoice form?

I suggest you to create an UDF to save this value, and I would assign the FMS to this field.

To finish, you have to add this field to your layout.

Kind regards

Agustín Marcos Cividanes