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
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...
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
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
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.
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...
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...
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...
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...
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.