Create and Apply Credit Memos to Invoices via CSV Import

Scenario

To create Credit Memos and apply it to Invoices via CSV Import.

 

Solution

1. Create a CSV File

• External ID
• Customer Internal ID
• Invoice Internal ID
• Item Internal ID
• Item Amount
• Applied Amount
• Location
• Date

1. Make sure to include the following as columns on the CSV File
2. Save the file as CSV (Comma Delimited) (*.csv)
3. Navigating to Setup > Import/Export > Import CSV Records
4. Import Assistant:
5. Import type: Select Transaction
6. Record Type: Select Credit Memo
7. Upload CSV File
8. Click Next
9. Scan & Upload CSV File:
10. Import Options: Select Transaction
11. Data Handling: Select Add
12. Click Next
13. File Mapping:
14. Field Mapping:
15. Map all of the fields listed in Step 1 and any other required fields as follows:
16. Customer Internal ID
17. <<<==>>>
18. Credit Memo : Customer (Req)
19. External ID
20. <<<==>>>
21. Credit Memo : ExternalId
22. Location
23. <<<==>>>
24. Credit Memo : Location (Req)
25. Date
26. <<<==>>>
27. Credit Memo : Date (Req)
28. Applied Amount
29. <<<==>>>
30. Credit Memo Apply : Payment
31. Invoice Internal ID
32. <<<==>>>
33. Credit Memo Apply : Apply (Req)
34. Item Amount
35. <<<==>>>
36. Credit Memo Items : Amount
37. Item Internal ID
38. <<<==>>>
39. Credit Memo Items : Item (Req)
40. Click Next
42. Save mapping & Start Import:
43. Enter Import Map Name
44. Click Save & Run