Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. katididdy

    Suppress detail/group 1/group 2

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

    Suppress detail/group 1/group 2

    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!
  3. katididdy

    Suppress detail/group 1/group 2

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

    AR Aging 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.
  5. katididdy

    Suppress detail/group 1/group 2

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

    Suppress detail/group 1/group 2

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

    Unable to login to pwe.exe

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

    Unable to login to pwe.exe

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

    Company setup Report Name/Display Name

    Thank you for your advice.
  10. katididdy

    Company setup Report Name/Display Name

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

    Company setup Report Name/Display Name

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

    Company setup Report Name/Display Name

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

    Invalid Account Posting Not Allowed

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

    Invalid Account Posting Not Allowed

    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?
  15. katididdy

    Sales Last Year

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

    Sales Last Year

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

    Sales Last Year

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

    Clear Accumulators

    The issue has been resolved!! Thank you for your inputs!
  19. katididdy

    Clear Accumulators

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

    Post with Period out of balance

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

Part and Inventory Search

Back
Top