Recent content by cfcanter

I am trying to printout all the *.pdf files in a directory "G:\Accounts". There are multiple subdirectories and each subdirectory may have multiple subdirectories. I've tried to copy code from VBA Developer's Handbook & from utteraccess without luck. Here is the code from utteraccess Sub...

THANK YOU! We tested 40 invoices and got it right each time. Craig Canter Controller Elgin IL

What is the key field I can use to link AP_13InvHistoryDetial (A/P Invoice History Detail File) & AP_12InvHistoryHeader (A/P Invoice History Header File) ? I see Invoice Number and Header Sequence Number in each table. The problem I have is where two vendors have the same invoice number...

Breaking down the query into separate tables worked great! Thank you! One further question - where do I find invoiced quantity? I have invoiced amount but not the qty. Craig Canter Controller Elgin IL

Here is my query: SELECT POP_RecptHistoryHeader.ReceiptType, POP_RecptHistoryHeader.ReceiptDate, POM_RecptHistoryLine.ItemNumber, POM_RecptHistoryLine.Description, POM_RecptHistoryLine.UnitOfMeasure, POM_RecptHistoryLine.ReceiptQty, POM_RecptHistoryLine.ReceiptAmount...

Hi Big Louie - I'm sorry to ask again, but I'm not getting it. I'm getting two receipts: One appears to be the actual receipt and the other the receipt of the invoice. For example: PO GC18042 will have receipt G020971 and I017014. The kicker is that I017014 will appear for more than one...

We are running MAS 200. I am trying to create a Received-Not-Invoiced report. If a canned report in MAS 200 exists, I doubt we can use it. Our predecessors were not very savvy in MAS and did more work arounds than anything. However, if you know of one I'll start there. In Crystal Reports...

Sorry, that doesn't work. I need to tie from the invoice back to the item that the invoice is paying. Craig Canter Controller Elgin IL

I am using Crystal reports against MAS 200. I need to extract the last invoice for each item purchased. I am willing to download into excel and sort to determine the latest invoice. The problem I am having is that I don't understand what tables to link the AP_History table to in order to...

Oops. We are on MAS 200. My apologies I cannot find the SOSourceJournal or SOGLBatchNo. Could they be called something else? Craig Canter Controller Elgin IL

Good morning! I am trying to write a crystal report extract against our MAS 90 database. From the G/L I have the following data: Acct Period Date Journal Batch Dr Cr 3010 12 1/31/06 SO-R0966 BTCH:R031_ 1000 I am trying to pull all the invoices that went...

Store Account Amount 500 12000 1000 500 12000 2000 600 12000 2000 I want to loop through an Access table like the one above and when the store number changes the loop stops. Basically I am writing to a file and want a new file to be created when the...

SORRY for placing this request in an SAP forum,but I'm hoping somebody can help. I'm looking for a text book on QAD Mfg/Pro. Any suggestions? Thanks Craig Canter Cost Accountant Sipex Milpitas, CA

When I boot up XP I need to have my different user's show up. For example I need to have CCanter and ADmin pop-up so I can choose Admin. Is there a compbination of keys to make this happen? Craig Canter Cost Accountant Sipex Milpitas, CA

We have a Lotus Approach database on a shared drive. When we try to open it we get the message a "This file was last saved with a previous version of Lotus. Do you want to convert it to Lotus Approach 3.0?" We respond yes. We get a message "Couldn't find the power key for the...