zaviagodev / frappe

MIT License
0 stars 1 forks source link

Customer Info tab on /app/sales-invoice #112

Closed chomchuen closed 8 months ago

chomchuen commented 9 months ago

Goal🎯

  1. Do data aggregation (get and calculate data correctly).
  2. Create 'Past Order' table in Customer tab on Sales invoice doctype.

Explanation

This table shows 'past PAID sales invoice' (Get past SI list until present current SI date create only. So order in the table won't be updated anymore). it have 3 column, 'Name', 'item quantity' and 'amount' Maximum 5 last orders.

Image

chomchuen commented 8 months ago

1st section completed.✅ only Past Order table not complete❌.

Screen Shot 2566-12-22 at 10 10 09
chomchuen commented 8 months ago
Screen Shot 2566-12-28 at 12 13 34
chomchuen commented 8 months ago

Approved✅

Screen Shot 2566-12-28 at 16 12 37
chomchuen commented 8 months ago
  1. Please continue create "past 'PAID' sales invoice table" (check 'Explanation' in 1st comment for detail of this table)

  2. Information in customer info will be latest data at current time and will not be updated anymore after save.

chomchuen commented 8 months ago
  1. Table will show maximum last 5 paid orders. Screen Shot 2567-01-05 at 14 22 35

    2.✅

chomchuen commented 8 months ago

Past order table shows only 5 orders even have >5 paid orders✅

Screen Shot 2567-01-05 at 15 20 55