cancel
Showing results for 
Search instead for 
Did you mean: 

Formatted search

Former Member
0 Kudos

Hi ,

I have to show the VAT and CST No. in the reports. From the BP master data Accounting tab i am not able to retrieve the data.so I created the UDF for VAT and CST.

how i have to give the formatted search for that

I tried with select $[S2018.0.0]

but i did not get the result.can u please explain me

Thanks,

Varalakshmi.

Accepted Solutions (1)

Accepted Solutions (1)

former_member197621
Active Contributor
0 Kudos

Hai varalakshmi kuraganti

using CRD7 table u can solve your issue

i give u one example,test this in sales order

select TaxId2 from crd7 where cardcode= $[ordr.cardcode]

Answers (2)

Answers (2)

msundararaja_perumal
Active Contributor
0 Kudos

Hi,

Go thorough this document it will help you in understanding Formatted search and in resolving your issue.

[How to define and use Formatted Search|https://websmp105.sap-ag.de/~form/sapnet?_FRAME=CONTAINER&_OBJECT=011000358700004566652005E]

0 Kudos

Dear Kuraganti,

I have noticed that you put a link to a sftp file. We cannot open such links if it is not the sftp file that we normally use to get database from our partners/customer.

Can you please add the information in the message itself?

Thank you.

Marcella Rivi

SAP Business One Forums Team