Search results for query: *

How do i unselect it for billing? That's where I'm hung up i guess.

In macola ES 9, I'm getting this error on an order. I have tried doing the print invoices trick to toggle the status between 8 and 9. Right now the status is 8, and our parts ordering department has already created a new order to replace this one. How do I delete this order when the above...

Delete it from teh dbo.oeordhdr_sql table or delete it from the macole ES gui?

OK so new info. I'm looking at the dbo.oeordhdr_sql tableand this particular order has an inv_no, inv_dt and the selection_cd column is X. Posted is NULL. I'm wondering if I can change some values in here to get it unstuck?

Seems to be the same with both versions.

OK I tried it again using the crystal print invoices option, didn't click print duplicates. The software crashed during this, and the status is 9 now, but when I try to view under OE enter orders i get "order already invoiced. access denied" It's not showing up in the customer card either.

I get the same error whether print duplicate invoices is checked or not. Do you know what could cause this?

In a previous question I asked, I was given some instructions for fixing an invoice stuck in limbo. When trying to do this for another order, I get "No data which meets the criteria entered". So from OE & RMA screen, I chose Invoices>Print Invoices. Then i pick the order number from the order...

OK. I verified that she (AR clerk) did do that. I'm still getting the same error though.

My AR person just went in and tried looking at it and the status changed to 8 - Selected

Would it make sense to change those fields to currency now? those user defined fields aren't being used elsewhere.

OK the status there says 9. Invoice PRT

Is this what you're asking for?

The status says open.

I have this issue again and it's slightly different now. At the reprint order step (1) I'm getting an error "No data which meets the criteria entered" It's also not showing up on the pre post.

@dgillz, I don't own flexibility. @crystalrporting, I've tried casting as and converting but I always get "Error converting data type varchar to numeric." Using exactly your code all the numeric values converted to decimal come out as 0.000000.

Unfortunately I have very little coding experience at all.

I'm having trouble finding information on how to use the designer in Macola 9.6.900. On the order entry screen my old boss put in 2 fields for Cash Receipts but he used user_def_fld_3\4 for those cash values. This is making it very difficult for us to report\calculate on those because those...

The error messages is Error Number 94 Source Bank\CreateTransaction Invalid use of Null. The error message came on step 6 Edit: Performing the above 6 steps a second time somehow fixed it. I'm not sure why it didn't work the first time but did the second.

OK I tried what you recommended CrystalReporting, but my AR clerk got an error message. Now the order is in the following tables, still unable to post. [dbo].[oeinqord_sql].[ord_no] [dbo].[oelinaud_sql].[ord_no] [dbo].[oelinaud_sql].[ord_no] [dbo].[oelinaud_sql].[ord_no]...