Search results for query: *

DB2 system, 5.3, 15 user license I have 15 users with combination of XP and 2000 clients. System has been in place for almost 2 years. Just added two XP clients (not execeeding 15) as we normally do and getting strange results. For example, I can access Item Master, but when I try to open OE...

System 5.3, DB2 I have a customer who wants copies of invoices already sent for the past two weeks. They were sent via EDI orginally so the customer never did have a hard copy. 1. Is there a way to reprint an invoice? 2. Can paremeters be used - from <beginning inv> to <ending invoice>...

I am a user with basic Access experience. I have created a simple database to record inspection records of incoming receipts. The structure is 3 tables as follows: mastertable: CID - container ID Date - date of receipt PO - purchase order number sampletable...

Hi. We are running 5.3 on DB2. We had made some description changes in the item master and realized that they weren't being recognized in new Orders. It appears that the description is coming from the Price List instead. First, I want to confirm that. Second, can the description be changed...

System: 5.3, DB2 We have been flagging orders "F" for future orders. The code appears to change automatically to "A" once the expected ship date equals current date. I just want to confirm that this is handled by Accpac and if so, is there a way to turn off this feature. Thanks, Rick

System is 5.3, DB2. We email our invoices and order confirmations. The customer master has an email field on the address tab and also one on the Contacts. When emailing the forms, which address is being used for which form. I want to be able to send confirmation to one email address and...

Running 5.3 on DB2 We use PO's for all items including non stock/inventory purchases such as supplies. My example is: Item 700141, coded as non stock category 70000, acct set 3 Account set 3 uses clearing AP clearing account 21208,non-stock clearing account 21252 Category 70000 has 65310...

We are on Version 5.3, DB2. Majority of sales are invoiced to US, in US dollars and then converted to Canadian dollars. My question is when the order is invoiced, which exchange rate is used to convert to functional dollars for GL? The one assigned at the time of order, or the current spot...

Our system is V5.3 running on DB2. We noticed that an item in the Location table has an order quantity of 480 but when searching the open order file directly via MS Access, there is no order(s) for this item. The item in question is a raw material and normally wouldn't be placed on a sales...

When optional fields are created, you can set the defaults to add it automatically to new items. I want to add optional fields to existing items without doing it manually. Can I export the item master, add the optional fields and import back into Accpac? Does the sort order of the input file...

I need to issue 12 cheques to a vendor dated each month for the next year. I would need to print them now, but record once only in the appropiate month. Can I just record and print each check in the applicable month? My fiscal year end is December. Will I be able to go forward into next year...

We have the matrix setup from item number to category to GL. The problem is that the purchaser may not use the right item number, but when doing the receipt and then the invoice, the only GL number revealed is the clearing account number. Is there any way to have the GL number from the...

Has anyone written a macro that will invoke Day End Processing automatically? We try to do it last thing everyday, but it never fails to get missed a couple times a week. I can't seem to find a third party utility for this. This a great forum and I have picked up valuable tips.

Is there anyway to mass delete items from Pricelists (we several, couple thousand items each). When updating from Accpac Pro to Advantage 5.2/3 (before my time) they created pricelists for raw materials and work items that didn't need them, which is 80% of my database.