×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Macola is stating “Nothing in Range” for Open Customer Orders

Macola is stating “Nothing in Range” for Open Customer Orders

Macola is stating “Nothing in Range” for Open Customer Orders

(OP)
In Inventory Management \ View \ Multiple Item View, I enter an item number and click the Open Cust Orders button, and Macola displays "Nothing in Range". I've looked into the OEORDLIN_SQL and their are 74 orders out there with that item.

I'm on Progression 7.7.1 SQL.

I'm seeing the same thing with some other Items as well, but it was able to get some items to display correctly. It's odd, we use this functionality every day.

I have closed Macola and reopened it.

RE: Macola is stating “Nothing in Range” for Open Customer Orders

Please run reset quantity on order and reset allocations with the "rest inventory trx" checkbox checked, and try this again. Let us know the results.

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools: www.gainfocus.biz/exceladdin.html

RE: Macola is stating “Nothing in Range” for Open Customer Orders

(OP)
Ran both Processes, but no change. Still cannot see any orders for various items.

RE: Macola is stating “Nothing in Range” for Open Customer Orders

This could be caused by "orphaned" OE Order Line records - order lines without a header. Please run the following SQL query to see if there are any orphans.

CODE

SELECT OEORDLIN_SQL.ord_type, OEORDLIN_SQL.ord_no, OEORDHDR_SQL.ord_no AS HdrOrder
FROM OEORDLIN_SQL OEORDLIN_SQL LEFT OUTER JOIN 
        OEORDHDR_SQL OEORDHDR_SQL ON OEORDLIN_SQL.ord_type = OEORDHDR_SQL.ord_type AND  
        OEORDLIN_SQL.ord_no = OEORDHDR_SQL.ord_no
WHERE (OEORDHDR_SQL.ord_no IS NULL) 

If these exist we need to figure out how and why. There should never happen. Please post back with results.

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools: www.gainfocus.biz/exceladdin.html

RE: Macola is stating “Nothing in Range” for Open Customer Orders

(OP)
You're amazing Don! There was an RMA they tried to delete. Somehow they got the header, but there were some lines left. Deleted them, and problem was solved. Thanks again!

RE: Macola is stating “Nothing in Range” for Open Customer Orders

Run reset allocations again as this may affect the numbers.

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools: www.gainfocus.biz/exceladdin.html

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close