Search results for query: *

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.

We cleared the accumulators, and I have the value for all of last year, but I need the amount from 6/25 to 12/31. When I add up all the sales for each from oelinhst or oehdrhst the amount isn't the same as in sls_last_yr. I added the credits in, and that didn't work either. I know the answer...

Can anyone tell me how macola figures sls_last_year? When I look at the arcusfil I get one amount. The amount is different in oehdrhst and oelinhst. I can't use the total sales last year for my reporting.... I need it for a little more than 6 months. I was using the last year sale's amount...

The issue has been resolved!! Thank you for your inputs!

When I was clearing AR period-to-date accumulators, I also accidentally selected year-to-date accumulators. Is there a way to reverse this?

I need to post, but when I select "Post From Subledger" and fill out the boxes, I get an error that the period is out-of-balance and I can't post. The person who used to take care of Macola is no longer with the company, and I have been told that he was able to do something to allow posting...