Customer master to sales order

(0) Share

Report

Posted on by Prabakaran.R

313

Hi Friends,

I want to add a cash on filed value from customer master table to sales order, In customer Master table i am having value but sales order i can not see that value.

Customer Master Page

Sales Order Page

Please help me on this issue.

Thank you

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (2)

Suggested answer

Mohana Yadav 61,204 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Did you check how Customer Name and other fields are flowing automatically when you select Customer no?

you need to add your field also in same place.

Was this reply helpful? Yes No
Prabakaran.R 313 on at

Like (0)

Report
Copy link

Link copied!

Hi mohana

Thank You for reply i have added the mam even though i did nt get please suggest to me to this.

Thank you

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report
Copy link

Link copied!

You need to write a code on Sales Header Table and on Validate trigger of Sell-To Customer No field.

Check the existing code how data flow from customer master table to Sales Order from that field.

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 61,204 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

yes, you need to write the code to flow. adding fields in customer and sales header wont flow data..

Was this reply helpful? Yes No
Prabakaran.R 313 on at

Like (0)

Report
Copy link

Link copied!

Hi Mohana

i have write this code but its taking all 1 discount amount for all customer

RecCustomer.RESET;

RecSalesHeader.RESET;

RecSalesHeader.SETRANGE("Sell-to Customer No.",RecCustomer."No.");

IF RecCustomer.FINDSET THEN BEGIN

CashDiscAmt := RecCustomer."Cash Discount %";

MESSAGE('%1',CashDiscAmt);

END;

Thank you

Was this reply helpful? Yes No
Verified answer

Mohana Yadav 61,204 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

where did you write this code?

you dont have to get customer and sales headers again.

Please check OnValidate trigger of Sell-To Customer No field.

and assign fields in right place

Was this reply helpful? Yes No
Verified answer

Sunil1991 170 on at

Like (0)

Report
Copy link

Link copied!

Hi,

In sales header table, on "Sell-to Customer No." field validate trigger, There is code written something like below, to get the values from customer to sales order:

"Sell-to Customer Name" := Cust.Name;
"Sell-to Customer Name 2" := Cust."Name 2";
"Sell-to Address" := Cust.Address;
"Sell-to Address 2" := Cust."Address 2";
"Sell-to City" := Cust.City;

With this code you have to add a single line code to show the cash discount %, like below

"Cash Discount %" := Cust."Cash Discuunt %";

Regards,

Sunil Kumar

Was this reply helpful? Yes No