Amazon settlement report list the $ about orders and platform fees.
I want to sync from Amazon settlement report to ERPNext for the company financial report.
My first idea is group by date and type and creates Journal Entry.
But if I want to drill down to check the order sales, the average cost per order… etc
How should I do?
Currently, my idea:
- Create new fields on Journal Entry to define it is an order and record Amazon order id.
Create chart with filter custom fields.
- Create sale orders with the information, but I don’t create Payment and Deliver Note, the orders will be overdue eventually.
Thanks for any suggestions.