No Line Items for this order

[jfuller0219]

Hello all, look forward to speaking with you..

We recently ran into an issue after going through routine daily work in Macola. After we invoiced a company in Macola, we are now not able to open ANY open orders for them in Multiple Level Item View. We can enter part numbers in with results being the correct orders, but when you click on an open order, you get an error saying "No Line Items for this order."

Any ideas what could be causing this?

We are on Macola Progression 7.7.5, SQL 2005, Server 2003 environment.

Josh

 

[dgillz]

Please run the following query in SQL Management studio:

SELECT oeordhdr_sql.ord_type, oeordhdr_sql.ord_no, oeordlin_sql.line_seq_no, oeordlin_sql.item_no
FROM oeordhdr_sql LEFT OUTER JOIN
      oeordlin_sql ON oeordhdr_sql.ord_type = oeordlin_sql.ord_type AND oeordhdr_sql.ord_no = oeordlin_sql.ord_no
WHERE item_no is null

This will tell you how many orphaned order lines you have. Add a "not" before "null" and you'll see which orders do have line items. Please report back your findings and we'll take it from there.

If you have a backup from the prior day, please keep it.

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[jfuller0219]

Shows a large number of results.. Do you want them all? Here was the message.. (1789 row(s) affected)

That was with the "not null" string.

 

[dgillz]

This makes no sense. This is a SELECT query. You should not get any message about the # of rows affected, it should just show the rows with a record count. This could be a SQL 2005 thing, but I doubt it. Please recheck this and let me know.

Also please run this without the NOT, this will tell you where you have problems. On the 1789 rows, please test these as they should show up in Multi Level Item View.

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html