Macola 7.6.400a Order shows open but it is closed

[mylox]

Any way to get those out of my report. If I go into orders and type in the order number is shows invoiced, so I can't modify it. If i go into multi level item view it shows open, if I go under order history it does not show up. Seems to be hung but I have no clue how to remove it out. Is there a way?

 

[dgillz]

Did you post the invoice?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[mylox]

yes they have been. Accounting just gave me this issue but the orders are open since 1/10/05! Since then they have closed the year 05 / 06 so I don't know if that has anything to do with it.

 

[dgillz]

If the invoice has been posted, the order should not even be there. How do you know it has been posted? If you try to post it, what happens?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[mylox]

it says order already invoiced access denied when I try and slect it, I try and unselect it no dice either. I try and post and says nothing in range.

 

[dgillz]

I asked you to post the invoice, not to select it.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[mylox]

unless I am wrong you go under OE-TRX-Invoices / Cash - Post invoices right?

It says nothing in range

 

[dgillz]

Yes.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[mylox]

yeah shows nothing in range. I tried everything to clear these short of going in the backend and clearing it out of SQL. That would be hard to do though because I am sure it is stored in more than 1 table

 

[dgillz]

That would be the next step. You need to get your reseller involved at this point, as you pointed out it hits multiple files.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[mylox]

Thanks for the fast responces by the way I really appreciate it.

 

[mylox]

anyone know what tables this stuff resides or have seen this issue before?

 

[dgillz]

You need to get your reseller or Exact directly involved. How many tables are affected is a function of what type of part it is. Kit items, POP or SFC pull items, Serial/Lot/Bin controlled items, weather of not you are using confirm ship or pick, or hard allocation, what cost method you are using, and I am sure a few more I cannot remember off the top of my head, will all play a part in determining the tables that need to be fixed.

Even the best Macola consultant in the work cannot do this without considerable research, and it is totally beyond the average power user.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[mylox]

Since the orders were from 2005 i went in the backend and changed the status from O to X and they went away from my reports. Beats deleting them and causing a mess. Now they are there but I can't see them.

 

[tpllc]

It sounds like the order is closed. Go to OE reports/order status/ closed orders.
From that report you can select the order or a range of orders. If you select the purge option I believe that the order will go away.

Steve Henley
Trianglepartners.com
Exact Software consulting, sales and implementations.

If the only tool you can use is a hammer then all your problems look like nails.

 

[mylox]

Went into OEORDHDR_SQL and turned the X back to O like it was and ran that report, said nothing in range =( Thanks anyway though!

 

[tpllc]

leave the header code at X this identifies the order as closed then the close purging the closed orders as I described should work. By changing the status in the order you made it act as if there were no closed orders.

Steve Henley
Trianglepartners.com
Exact Software consulting, sales and implementations.

If the only tool you can use is a hammer then all your problems look like nails.

 

[mylox]

Nope! oh well guess those files are just hung =(

 

[tpllc]

I never give up this easy. Please tell me what is the "status" of these orders from the OEORDHDR table? Like Don described how you have things set up determines what tables are updated. Tell me more about your operation.
1 do you use kits?
2 do you use features and options?
3 do you confirm picking or shipping?
4 do you use OE to PO?
5 do you use "pull" type orders in POP or SFC?
6 do you have “no” backorders for customers or items?
7 are any items lotted or serialized?
8 what version of Progression are you on?
9 what has your reseller said about this issue?
10 do you or anyone else make changes to the SQL tables directly, not through Macola?


Steve Henley
Trianglepartners.com
Exact Software consulting, sales and implementations.

If the only tool you can use is a hammer then all your problems look like nails.