1. Home
  2. Point-Of-Sale Software
  3. P.O. Order Number

P.O. Order Number

Hi all -

I'm wondering which table and column in the database holds the "Order No." on the purchase order?

I just received a large quantiy of Order No. from a major supplier and I'd like to use an update statement to update the item table with the order number for several hundred UPS/Itemlookup numbers.

If anyone can point me the direction of the table/column for the "order no." I'd really appreciate that.

Thanks Jerry

Reply to
Jerry
Loading thread data ...

Reply to
Ahmed Nashat

qHi Jerry As mentioned by Ahmed, I need to add one more thing, what if the items are not Supplierlist table. then you need to give an insert statmenet execute the below code:

INSERT into SupplierList (ItemID,SupplierID,Cost,ReorderNumber) select Item.ID As ItemID,Supplier.ID As SupplierID,Item.Cost,ExcelReorderNumber from Item,Supplier,ExcelFile Where Item.ItemLookupcode=Excel.Lookupcode AND Supplier.Code='DATUM'

in 1.. Assuming that your order numbers are in excel sheet with the Itemlookupcodes, import your excel sheet into the database in a table called ExcelSuppCodes 2.. execute the following statement:- update supplierlist set supplierlist.reordernumber=ExcelSuppCodes.OrderNumber from ExcelSuppCodes,Item where ExcelSuppCodes.ItemLookupcode=Item.ItemLookupcode and item.id=supplierlist.itemid Nashat

"Jerry" wrote:

Reply to
Akber Alwani

That helps a lot, but what is: Supplier.Code='DATUM'?

Reply to
Jerry

Thank helps but what is DATNUM?

and Supplier.Code='DATUM'

Reply to
Jerry

It's the supplier code for one of the suppliers in the sample database. You should replace it with the code of the supplier you wanted to add.

Glenn Adams Tiber Creek C> >> qHi Jerry

Reply to
Glenn Adams [MVP - Retail Mgmt

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.