Skip to Content

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 20, 2015 at 01:39 PM

    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

    Add comment
    10|10000 characters needed characters exceeded