adding new fields in Trans Sales entry

Pradeep_Krishna

Hi, Experts,

I have to add two fields (customerNo,customerName). That has to lookup the values from the Customer table 5050.

Since we have no direct link to the customer table from Trans.Sales entry.

Could someone suggest how we can fetch both the values from the customer table

Thanks in Advance.

txeriff

Trans. Sales Entry.... LS retail...

Well, the standard approach would be to find where LS retail is inserting data in trans. sales entry, try this:
https://mibuso.com/downloads/gdt-where-used-tool



Another approach could be (but will slow down a lot) using calculated fields (flowfields).

Pradeep_Krishna

I have created a flow field in trans sales entry as sell to customer No from sales header using lookup. this helped me to create a link to customer table. After that i added customer no and customer Name filed as flow field look up from customer table's No and name fields. As the values of sell to customerNo from trans sales entry and Customer .No equal.
I got the Answer that i have expected. Thanks.