Item Card: How to show the customer of the item?

cosch1

Hello to all the experts,
i would like to have a link on "item card" to show the last customer of the item wilth amount and price like the history on the "Sales Order Card".

Has anyone an idea or a complete solution???

With greetings from germany!
cosch

hemantOne

hi,

U can use Item button-->Entries-->ledger entries on Item card to find this.

cosch1

thanks for answering, but there isn't the customer name to see, and that's what my colleagues wan#t to see! There's only the customer no. to see.

vijay_g

it's not mapping with standard nav you can add a new button having SaveAs with this entries form. add a test box to contain customer name with help of source no.

cosch1

yes, i'll see it, but how to get in the customer name with help of customer no. into the text box?

Belias

a lookup flowfield is the easiest way...be aware that if you have to filter on the name for some reason, you'll probably have some performance problems (because you're trying to filter a calculated field).
Do you know what are flowfields?if not, just study application designer guide pdf you can find on the product cd!

vijay_g

look at "G/L Account Name" field in G/L entry table it comes by Account No.