We need to change Salesperson codes on Customer card to another salesperson code. If it changed on customer table, I understand we have posted documents related to previous Salesperson codes. Also, I understand posted documents cannot be changed
However, I would need advice how to change in the Sales Invoice Header, Value Entry & Cust. Ledger Entry Table. [ for reporting purpose] Can I directly modify the value of "Salesperson Code" in Sales Invoice Header, Value Entry & Cust. Ledger Entry Table. Using configuration package,
- Create configuration package
- Add related table s [Sales Invoice Header, Value Entry & Cust. Ledger Entry Table]
- Export by excel
- Make adjustment to data in excel and save the file
- Go back to configuration package and import by excel
- Apply the data
Appreciate your valuable advice please? am using BC 19 at this point.
Many Thanks, Indu