Download
Description | Size | Download |
---|---|---|
The template works with both the Microsoft Store edition and the desktop edition of the app. Make sure you have installed one of them. How to use:
| 1196 KB | Download |
License: Private Use (not for distribution or resale). See our Terms of Use.
Detail
This template is designed for produce distributors and wholesalers. If your business sells agriculture and farming products, then try this template.
The cell named "oknShipVia" is changed to an integral numeric, indicating the number of days between the invoice date and the shipping date. For example, if you enter "3" in the "oknShipVia" cell and the invoice date is July 5, 2023, the shipping date will be July 8, 2023. This is calculated automatically using the following Excel formula:
=oknShipVia+oknInvoiceDate
The "Due Date" cell is also calculated using an Excel formula like this:
=oknShipDate+oknPaymentTerm
So in this form design, the "Payment Term" cell accepts an integral numeric value only.
In the bottom section, there is a declaration like this:
The perishable Agricultural commodities listed on this invoice are sold subject to the statutory trust authorized by section 5(c) of the Perishable Agricultural Commodities Act , 1930 (7 U.S.C.499e(c)). The seller of these commodities retains a trust claim over these commodities, all inventories of food or other products derived from these commodities, and any receivable or proceeds from the sale of these commodities until full payment is received.
Format and Specification
Template# | c5119 |
Belongs to | |
Format (XLS or XLSX) | .xlsx |
Columns | 5 |
Lines | 12 |
Line Height (Points) | 21.75 |
Print Area | $D$3:$K$46 |
Papaer Orientation | Portrait |
Default Margins (Points) | |
Left | 18.00 |
Right | 18.00 |
Top | 75.60 |
Bottom | 75.60 |
Price | Free |