Search results for query: *

Hello, I need to verify pricing before importing sales orders into accpac 6.0/MSSQL I have the vba I need, however having trouble getting the correct SQL query to return rows with information needed by VBA procedure to verify pricing. Fields needed to verify pricing: ICPRICP.UNITPRICE...

Hello, I need a «Quick» way for our shipping dept to create a SHIPMENT once an order was picked.... I was thinking of this: Dump this query onto an Excel spreadsheet: SELECT OEORDH.ORDNUMBER, OEORDH.ORDUNIQ, OEORDD.LINETYPE, OEORDD.ITEM, OEORDD.DESC, OEORDD.QTYBACKORD FROM OEORDD INNER JOIN...

Hello.. Will this work : UPDATE POPORL SET POPORL.EXPARRIVAL = 20100418 FROM POPORH1 POPORL WHERE POPORL.PORHSEQ=POPORH1.PORHSEQ AND POPORH1.PONUMBER="004386"

Hello, We are using Sage Accpac 500 ERP (Version 5.5A). Is it possible to have web pages QUERY the database ? What set ups must be done if possible to accomplish this ?

Hello, Trying to built a simple ACCPAC report which requires OPTIONAL FIELD TABLE VALUES to be JOINED to the MAIN select ...... I have this : SELECT POPORH1.DATE, POPORH1.PONUMBER, POPORH1.VDNAME, POPORL.ITEMNO, POPORL.ITEMDESC, POPORH1.EXPARRIVAL AS PO_ETD, POPORL.EXPARRIVAL AS LINE_ETA...

Sage Accpac 500 ERP (Version 5.5A) with Pervasive 9: I need to provide a spreadsheet with our YEAR END INVENTORY QTY by item with the last received date, last received date cost(prior to year end), and ITEM value at year end.... Can this be done via a few SQL queries ?