Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: dtmb
  • Content: Threads
  • Order by date
  1. dtmb

    ICHIST Query

    How can I query ICHIST to produce two different set of data on the same report i.e using two similar parameters but for different time periods. Thanks
  2. dtmb

    Specific Data from ICSTAT

    Hello all, I would like to be able to extract shipment data from ICSTAT for periods of Lastweek lasttwoweeks etc for shipments to add to a market list so that there is some sort of a history for each product. Can anyone advise how this can be achieved. Thanks
  3. dtmb

    Location Details Summarized

    Hello, **Spec** Accpac 5.3a running on Pervasive V8 I have two locations numbered 1 & 2. I successfully created a market list in crystal reports, but have one problem, each item is printed twice due to the different locations. How can I get the quantities at both locations to be summarized so...
  4. dtmb

    Outlet Production Stock

    Using accpac 5.3a At the end of the month an inventory is done at each outlet, is there a method that can be used to enter this into accpac and get a valuation. This method must not affect the system balance for the items. Thanks
  5. dtmb

    Menu Item Slu names

    System: Micros 9700 I have entered some new SLU in the database, and would like to have them available on the workstations. Does anyone know how to do this? Thanks
  6. dtmb

    Accpac Sort Order

    Is there a way to change the sort order for accpac inventory worksheets, its currently set to category then item number. Could it be changed to category them item description. Thanks.
  7. dtmb

    Shipment Summary

    This is a query I created from invdat SELECT ICSHIPD.FMTITEMNO, ICSHIPD.ITEMDESC, ICSHIPD.SHIPQTY, ICSHIPD.STOCKUNIT, ICSHIPD.UNITCOST, ICSHIPD.SHIPCOST, ICSHIPD.ICACCT, ICSHIPH.FISCYEAR, ICSHIPH.FISCPERIOD, ICSHIPH.CUSTNO, ICSHIPH.CUSTNAME, ICSHIPD.EXPRICEHM FROM ICSHIPD ICSHIPD, ICSHIPH...
  8. dtmb

    Shipment not printing

    My computer will not print/view shipment. all the other pc works fine. What could be the cause of this.
  9. dtmb

    Accpac Recomendations

    What is the recomended spec for a server to run accpac with 10 users. Thanks
  10. dtmb

    Shipment Re-Setting (very frustrating)

    Whenever the users create a shipment in inventory control and the available quantity changes after you enter a long list of items (ex you had 50 eggs available you orderd 49, another user post an order for 2 which lefts 48 available) and you try to post the shipment its gives the error but does...
  11. dtmb

    Micros Export & Modifier

    Hello, I need help with two things for Micros 9700. 1. I need to export the price list so that I can modify it in excel and make a report from it. 2. How do I add a modifier to an item. example. Beef Burger is the item; when it is ordered I would like it to prompt the waiter to...
  12. dtmb

    Summarize Items On crytal Report

    I have a crystal report created from accapac data base, it has all the items used by a customer for a particular date. On that date the customer might have purchased the item five times example eggs 10 @ 10.00 eggs 20 @ 20.00 eggs 30 @ 30.00 how do I get the report to summarize this total to...
  13. dtmb

    What database feild do I use to find Item Price

    I am trying to do a custom price list that will show the actual cost per item, even if the item is not is stock. So far I have no luch acheiving this. Thanks for any suggestions you may have

Part and Inventory Search

Back
Top