Re: Input on upcoming changes to the Fax/order PDF

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
Report Content as Inappropriate

Re: Input on upcoming changes to the Fax/order PDF

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?

- Willem

On 11-04-15 00:21, Willem van Engen wrote:

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.


(*) 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").

order_pdf.pdf (48K) Download Attachment
order_pdf.xlsx (38K) Download Attachment