Skip to Content
avatar image
Former Member

FMS on UDF to based on Base document type

Hi All

I need to populate a UDF on an AR Invoice if the invoice is based on a sales order.

if its based on a Delivery note, it should be blank and the user needs to input info in that field.

However it's not working so well, as it populates it even when i copy from a delivery.

I didnt use the docnum = docentry in my where clause because the docnum and docentry is not the same.

SELECT DISTINCT 'from Mill' from OINV T0 inner join INV1 T1 on T0."DocEntry" = T1."DocEntry"

where T1."BaseType" = '17'

Any advise on where to change?

Should i join on the DLN1 table as well?

Thank you

Jerusha

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 22, 2015 at 10:26 AM

    Use the below one when you use FMS in row level

    select case when $[$38.43.0]='17' then 'From Mill' else '' end

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      FMS for HANA DB

      select case when (select top 1 v1.basetype from inv1 v1 inner join oinv v on v.docentry=v1.docentry

      where v.docnum=$[oinv."Docnum"])='17' then 'From Mill' else '' end

  • Oct 23, 2015 at 01:13 PM

    Hi,

    Link sales order and AR invoice.

    Thanks.

    Add comment
    10|10000 characters needed characters exceeded