Does anybody have any smart ideas for getting a nicely formatted order form directly from RMS? I want to be able to give staff a page with the list of items from a supplier, with sell price, MPQ, and barcode and the reorder number, and a space where they fill in the quantity required. If it looked something like a PO printout, with lines under each item to make it easy to use it would be ideal!
Any suggestions?
Thanks!
I don't have the nicely formatted form you're looking for, but if someone doesn't post the XML, you may have to create your own in excel.
This will give you sample info on the supplier, reading the supplier, item and supplierlist tables which have the info you're looking for.
SELECT supplier.suppliername, item.description, item.price, supplierlist.masterpackquantity, item.itemlookupcode, supplierlist.reordernumber FROM supplier, item, supplierlist WHERE item.id = supplierlist.itemid AND supplier.suppliername = 'a datum corporation';
instead of 'a datum corporation' you would type your actual supplier name
then export the result to a csv file where you can tweak it and embellish it. hope this helps.....
"Philip Gass - Creative Gardens -" wrote:
Any suggestions?
Thanks!
-- Philip Gass Donaghadee Garden Centre
Have something to add? Share your thoughts — no account required.
Ask the community — no account required