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
