Search results for query: *

Trying to match Purchace order VS Item pricing to verify our margins..... This works fine: SELECT POPORH1.PONUMBER, POPORH1.VDNAME, POPORL.ITEMNO, POPORL.ITEMDESC, POPORL.OQORDERED, POPORL.UNITCOST FROM (POPORL INNER JOIN POPORH1 ON POPORL.PORHSEQ = POPORH1.PORHSEQ) INNER JOIN ICITEM ON...

Hello using the following query to get qty SOLD for 2009: SELECT OEINVD.ITEM, Sum(OEINVD.QTYSHIPPED) AS SUMSOLD FROM OEINVH INNER JOIN OEINVD ON OEINVH.INVUNIQ = OEINVD.INVUNIQ GROUP BY OEINVD.ITEM, OEINVH.INVFISCYR HAVING (((OEINVH.INVFISCYR)="2009")); and the following to get RETURNS for...

Not sure i'm in the right place fo rthis question. I have a text box and would like to have the text in in auto fit...is this possible ? That is if the words are longer that the fixed withd of teh text box the font gets reduced....

Hello, Is it possible to: 1- P/O Purchase Order Entry : Display the Items SORTED by ITEM NUMBER (in sted of sorted as order entered)? If so how ? 2- What part of the crystal report that prints out the PO would I need to modify to ALSO sort by ITEM Number ?

I'm using th efololowing SQL: SELECT OESHDT.CUSTOMER, OESHDT.ITEM, OESHDT.YR, OESHDT.PERIOD, OESHDT.TRANDATE, OESHDT.DAYENDSEQ, OESHDT.TRANSSEQ, OESHDT.LINENO, OESHDT.TRANNUM, OESHDT.ORDDATE, OESHDT.SHIPDATE, OESHDT.SALESPER, OESHDT.QTYSOLD, OESHDT.SCSTSALES, OESHDT.FAMTSALES, OESHDT.SAMTSALES...

I created a Purchase order with many items. One of the Items on the PO DOES NOT PRINT.... If I query the PO this item shows up in the results... However when I go to print the PO this Items does not show up in the print out. I verified the Item and it is like all the others that print out on...

I must build a query to get our Commission Reports going... We are in Pervasive 9 AccPac 5.5. What tables woudl I need to get the Invoices and Credit Notes so I can build this report ?

Trying to query Pervasive 9 (accpac5.5) with the following query I built in access (which is linked to accpac pervasive tables): SELECT ICITMV.VENDNUM, ICITMV.VENDNAME, ICILOC.ITEMNO, ICILOC.QTYONHAND, ICILOC.QTYONORDER, ICILOC.QTYSALORDR, ICILOC.QTYONHAND-ICILOC.QTYSALORDR AS NET_AVAIL...

I'm trying to run the following query through excel VBA to an accpac 5.5 pervasive database: SELECT ICITMV.VENDNUM, ICITMV.VENDNAME, ICILOC.ITEMNO, ICILOC.QTYONHAND, ICILOC.QTYONORDER, ICILOC.QTYSALORDR, ICILOC.QTYONHAND-ICILOC.QTYSALORDR AS NET_AVAIL, ICSTATI.SALESQTY, ICSTATI.SALESQTY/365 AS...

We just finished our year end physical count of inventory. We have the coount information in an excel spreadsheet..... Is it possible to import these counts into accpac 5.5? Would I import here: I/C : Physical Inventory Quantities ?

We have accpac 5.5 is there a back order report ? if so WHERE ?

We have MANY orders in accpac for a particular customer that were brough in from EDI. The Items are price by Contract Price List.....Because these orders have a special discount (TRADE SHOW) we must now manually add a 7% discount to all of thses orders..... Q: Is it possible to use SQL and add...

Hello I'm using the following to select from pervasive Accpacc DB: SELECT ICITMV.ITEMNO, ICITMV.VENDCOST, ICITEM.DESC FROM ICITMV INNER JOIN ICITEM ON ICITMV.ITEMNO = ICITEM.ITEMNO WHERE (((ICITMV.ITEMNO)='101553')) GROUP BY ICITMV.ITEMNO, ICITMV.VENDCOST, ICITEM.DESC HAVING (((Count(1))=1))...

During our Accpac Set up we imported customer specific pricing to the contract pricing of AP. However, now if a customer has a cash discount the discount must be manually inserted on the order line.... In hindsight we should have set up INDIVIDUAL price lists for these customers rather than a...

Hello, I'm using th efollowing to add a query to an excel worksheet: With ActiveSheet.QueryTables.Add(Connection:=sConn, Destination:=Range("A1")) .CommandText = sSql .Refresh BackgroundQuery:=False End With This works, however if I change to another...

I need to query the accpac sales and sales details tables. We are on the latest accpac windows with pervasive 9 I need to build an sql query within a date range grouping sales by cust and item. The data I saw stored in the pervasive table is formated like this: 20071230 How would I build the...

Hello, I need to add NON STOCK items to a purchase order to our vendors. These NON STOCK items are basically generic instructions for our product that I woudl like to add to a PO as a PO line thus allowing me to CHOSE which comments (NON STOCK ITEMS) I want to apear on the PO. How can I do this ?

we are using pervaise 9. I would like to email a query result. can this be done? can this be done as a scheduled task ? any sample code would be apreciated

I havea bout 100 sales orders to delete for a particular customer with a particular item....Is it possible to bulk delete thes Sales orders or must it be done one by one?

I'm very new to accpac and Pervasive. We have installed 5.5 with Pervasive 9.6 I would like to make data back ups 1- Can this be done WITHOUT 3rd party software? 2- Would this be a good way to go about this: @echo off :: variables set drive=C:\My Laptop Backups ::set folder=\%date:/=-% ...