Skip to main content
Dynamics 365 Community / Forums / Finance forum / Import data sales line...
Suggested answer

Import data sales line data from excel sheet and price and discount update from Trade and agreement journal

editSubscribe (0) ShareShare
ReportReport
Posted on by 2,988

Hi Experts,

I want to import Sales order lines from excel sheet. But as the data (Sales order lines)import from excel sheet, the Price and discount automatically updated from Trade and agreement journal form. Is is possiable  please support.

Dynamics 365 finance and operations

These fields are required in excel import.
1. Read one id removed from the sales import file. Not required.
2. Yellow is required.
3. Sales price come from the trade agreement journal.
Make sure when sales import upload sales price should come
from a trade agreement journal in the sales line.
4. Line discount if has in the trade agreement journal so it comes
automatically sales order line. Otherwise, the user adds manually in
the line discount field.5. Line percentage if has in the trade agreement
journal so it comes automatically sales order line. Otherwise, the user adds manually in the percentage field.
6. If a customer has multiple addresses when a user adds an address against multiple items
it should be updated in the address field.
7. Size and configuration must be updated in the sales order lines.
Sales price come from the trade agreement journal. Make sure when sales import
upload sales price should come from a trade agreement journal in the sales line

Best Regards,

Shabir Ahmad