Recent content by katididdy

That worked...I now show only invoices that are open. Thank you! My next step is to only pull out those invoices that will be 60-90 past due in 10 days. I'm going to have the user enter in a date. That date - doc due date = x. If x is between 60-90, I want that open invoice to show.

That did make a big difference in the number of pages, but I am still seeing open and closed invoices. I'm going to have to tweek this a lot to get only the open invoices to show. Thank you for your input. If you have any more suggestions, I will try them!

That didn't work. I still have both open and closed on the report.

How did you write that SQL view? I've been trying to do the same thing for 2 days, and I get all the invoices for each customer, paid or open. I'm trying to only view the open invoices. Please share how you got this to work.

Below is an example of the date I am getting in return: Cust# 2 has no open invoices, yet all the info prints. 5712 has an open invoice, and the invoice info prints. cus_no cus no apply_to_no Doc Due Date doc_type total Days Late 2 //this is the group header group by customer 1st...

Hi, I'm writing an aging report in Crystal 8. What I'd like to do is suppress the detail section and group header/footer 2 if there isn't an open invoice. Can anyone assist?

Problem solved. There were directories in the root that were deleted. Once they were restored, the issue was resolved. Thanks for reading!

No one in my compnay is able to login to progression. We are on 7.6.300C. When clicking on progression workflow explorer, we get this error: JMP0015I-U [PID:00000744 TID:00000C44] CANNOT CALL PROGRAM 'PC_READ_DRIVE'. CODE=0x7e PGM=MACPATHS ADR=01D12409 There was a box to press OK, and then...

Thank you for your advice.

I got the report and display names to change - I don't know why it finally worked, though. The version I'm on is 7.6.300c. Now I keep going in each company to verify the report and display names are company appropriate. Along the topic of closing final year-end --- would I do this in the live...

I agree and know that - but I was looking at previous questions/answers and someone suggested looking at that file. That's why I put that part in. I went to Progression Setup Utility to create 008, and named it Final Fiscal 2008. I then logged in as supervisor under 008 company and went to...

I created a new company for 2008 before doing final close. However, when I change the report name and display name in Fisal_2008 under system manager, it also is being changed in the Live company. I've gone into the macsql.cfg, and here is one example: [Company_008] Name=Final Close 08...

Nevermind! I had to enter the mn_no in ardisfil. I looked at other db's but forgot that one.

My AR person is trying to post and is getting the error "Invalid Account Posting Not Allowed". I found that there wasn't an account listed for the frt_mn_no for an order, and I entered the correct information into the db. However, she is still unable to post. Does anyone have any suggestions?

Thank you every one for your input. I finally got the numbers to add up.