Primary supplier

convoluted,

thanks for your suggestions. we're not using HQ as our warehouse is on a different (and very old) system. we had thought of using one of the subdesciption fields to put in the secondary suppliers similar to your idea of using bin location. I am told to export the entire database, add this in and then reimport back into RMS would mean we would lose our history. Does this sound right to you?

best wishes

"c> If you're not using BIN LOCATION you could use this field to track the real

In an ideal situation you'd have RMS at both locations (the warehouse and the store) then all you'd do is transfers between warehouse and store.

Having different, independent systems at the warehouse and store you're forced to create POs at the store (to receive from whse) and probably an invoice (a sale) at the warehouse (to ship to store). If at the store you've assigned the warehouse as the primary supplier and the actual vendor as the secondary supplier, this complicates things somewhat in terms of "copying" the secondary supplier into the subdescription1 field (or the bin location field);

suppliers are linked to items in the supplierlist table; the item table will reference the primary supplier, not the secondary supplier. Copying the secondary supplier assigned to an item in the supplierlist table into the subdesc1 (or bin location) field in the item table would require a sql query that in layman's terms says (copy the supplier name in the supplier table into the subdesc1 field in the item table where the supplier is not referenced as a supplier in the item table (the primary supplier) but IS referenced as a supplier in the supplierlist table. I'm still pretty green when it comes to sql queries so I'm not in a position to give you an immediate answer; maybe a more experienced sql user will post the correct INSERT or UPDATE statement.

Until then, and going forward, you have a couple of options: 1) type into BIN LOCATION the real vendor name and 2) assign the real vendor as the primary supplier and the warehouse as the secondary supplier, where all your POs will be for the warehouse. The latter might be a better approach as it will allow you to run a sales report by the primary supplier and also create your POs referencing the warehouse as the supplier. My RMS is version 2 and I don't see subdesc1 as a filterable field in the detailed sales report, thus my mentioning the bin location field.

H> convoluted,