Recent content by rdingman

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?