export the order details for import export
enter customer orders (cartons per fruit per customer; either manually entered or imported from Excel sheet)
for each carton record:
* carton content (predefined fruit list, remember last selection),
* customer name (predefined list, A,B, C,..., remember last selection),
* net fruit weight
Note 1: predefined fruit list must be customisable by user (about 20 entries)
Note 2: after entering content (fruit) and customer, app should display currently recorded vs total ordered cartons for that customer and that fruit
Output packing list and commercial invoice (preferably as MS Excel sheet)
PACKING LIST
Section 1:
show for each customer:
* per fruit: ordered # of cartons, delivered # of cartons, number of cartons of each net weight (carton weights vary somewhat), total delivered weight (per fruit)
* total number of cartons for this customer, total weight for this customer
* grand total of all cartons ordered and all cartons delivered
Section 2:
summary table of all orders:
* per customer (row):
fruit 1 (cartons, weight), fruit 2 (cartons, weight), fruit 3..., total cartons, total weight
* totals per column: fruit 1 cartons, weight, fruit 2....
* totals per column: estimated gross weight (net weight * carton weight factor (size S, M, L))
* fixed text template for packing list info (shipper, etc.)
COMMERCIAL INVOICE
* fixed text template (shipper, date, etc.)
* table (numbers from packing list):
columns: fruit name, # of cartons, net weight, gross weight, price/kg (to be manually filled and remembered by app), total
final row: totals of each column (except price)