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...

Obviously not hard enough. Had mental block and was looking at invoice entry. But a solution is a solution. Thank you, Rick

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...

Zemp, how do go about getting this Macro? thanks, Rick

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...

Yes. The order is set to 2 for future, but is changing to 1 without any user intervention. It appears to be based on current date matching future date.

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

Yes, but that only gives one choice. I need to seperate the invoice and order confirmation - different default address for each form. Does the delivery method refer to all forms or to one specific one?

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...

No, I was just trying to confirm the order of events. Thanks for the info.

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...

Ok, we will try rerunning it when the users are off and see what happens. I was just trying to determine if there is specific procedure (i.e. only run data integrity on one module at a time). Otherwise, it should have done what you stated but didn't.

Just to confirm, I ran integrity check/fix on all modules, but you are suggesting I should run it for OE only?

We ran it for all modules.

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...