This has been somewhat stalled, but this week I got a request to
change the CSV.
And I checked to see if I could export a fully styled spreadsheet
instead - which worked out (using
axlsx).
Stil would still have the number and amount as first cells, but is
meant to be a bit more self-explanatory with regards to the rest.
Please find an excel sheet and pdf attached. (I'd like to add the
creation date as well - and delivery date, when that is present in
Foodsoft.)
Would this be an improvement, and work for everyone?
Regards,
- Willem
On 11-04-15 00:21, Willem van Engen
wrote:
Hi,
I'd like to update the Fax PDF (or Order PDF), to make it a bit
more beautiful and to provide some more information:
* show more price info (deposit & tax), so that it's clear
upfront what the foodcoops thinks the prices are,
* put unit and unit_quantity together in "100 g x 5" - not all
suppliers are familiar with the term "unit quantity"
* include the "total unit of the unit_quantity" - we'll call it
pack_size. So "100 g x 5 = 500 g" (*)
* show prices of the full unit_quantity / box, as that's what the
supplier usually expects
* include totals of net, deposit, vat and gross price
Please find two examples attached (though the articles are a bit
random - deposit for cheese? nevertheless it shows the
possibilities).
QUESTION: Would this change be a problem for anyone? Would this be
an improvement?
Since it may affect the ordering routine, I'd like to check before
making the change.
If there are no objections, I'd like to release this with the next
version, probably somewhere around the end of April.
Regards,
-Willem
(*) It appears that it's not always clear to suppliers what the
unit is, especially when the foodcoop has adapted the unit to
something smaller (and increased the unit_quantity) - e.g. a
farmer supplies in boxes of 5 kg, but the foodcoop divides per 500
g. Then the form would show "500 g x 10", which is not something
he may recognise so easily. Still for articles counted by pieces
(e.g. bottles of milk) it is needed to keep this info ("500 ml x 5
= 2500 ml").