Inventory Adjustment

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 29260
interpreted = N
texte = I'm trying to deduct quantities ordered from inventory and do it as the order is submitted.I found the following code in the archives, but can't get it to make any deductions from inventory.[Replace db=pol.db&eqSKUdatarq=[sku]]Inv=[math][lookup db=pol.db&value=[sku]&lookinfield=SKU&returnfield=Inv]-[quantity][/math][/re place]I put this code on the ThankYou.tpl page which is accessed only after the order has been submitted.My database is named pol.db There are fields in it named SKU and Inv.Does anyone see why this code won't deduct ordered items from inventory?Thanks, Glenn ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Associated Messages, from the most recent to the oldest:

    
  1. Re: Inventory Adjustment SOLUTION (John Butler 2000)
  2. Re: Inventory Adjustment SOLUTION (Glenn Busbin 2000)
  3. Re: Inventory Adjustment (Glenn Busbin 2000)
  4. Re: Inventory Adjustment (John Butler 2000)
  5. Re: Inventory Adjustment (Kenneth Grome 2000)
  6. Re: Inventory Adjustment (Glenn Busbin 2000)
  7. Re: Inventory Adjustment (John Butler 2000)
  8. Re: Inventory Adjustment (Glenn Busbin 2000)
  9. Re: Inventory Adjustment (John Butler 2000)
  10. Inventory Adjustment (Glenn Busbin 2000)
I'm trying to deduct quantities ordered from inventory and do it as the order is submitted.I found the following code in the archives, but can't get it to make any deductions from inventory.[Replace db=pol.db&eqSKUdatarq=[sku]]Inv=[math][lookup db=pol.db&value=[sku]&lookinfield=SKU&returnfield=Inv]-[quantity][/math][/re place]I put this code on the ThankYou.tpl page which is accessed only after the order has been submitted.My database is named pol.db There are fields in it named SKU and Inv.Does anyone see why this code won't deduct ordered items from inventory?Thanks, Glenn ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Glenn Busbin

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

WebDNA 5.0 freeBSD?!!? (2003) Running _every_ page through WebCat ? (1997) t or f (1997) PCS Frames (1997) Summ=T Problem (1997) show all problem (1997) WCS Newbie question (1997) all records returned. (1997) RE: Pop-Up Redirects (1998) Web Catalog 2 demo (1997) WebCatalog for guestbook ? (1997) OH CRAP!!!!!- Template not found error!!! (1999) Emailer (1998) Date Question (2002) WebCatalog can't find database (1997) Mobile Phone "mailto:" (2008) Word search (1997) Dates (1998) [LINEITEMS] (2000) Banner DNA (1997)