Macola 7.6.2 (Pervasive)

[cogebi]

An order was entered somehow with an Order # of 0 . Now that order can not be accessed or deleted but shows up in our daily order report.
How can we delete this order? When you call up the order, it shows nothing in it (also when you call up the customer number it shows order # 0 (actually 00000000) but nothing in it. When you print out an order status report, it then shows the detail inside it but you can not access this order, ship it, etc.
Any suggestions?
Thanks.
Wayne

 

[vbajock]

Link the Order header and Order Line item tables to an access database and delete it there.

 

[dgillz]

You also want to delete this order from the OEINQORD Table, as well as the OEHDRAUD and OELINAUD tables if audit trails are being kept.

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

http://www.trianglepartners.com

 

[cogebi]

Where do the order header and order line item tables reside in Macola?
Thanks.

 

[vbajock]

Are you running PSQL or MS SQL?

 

[cogebi]

We are running PSQL

 

[crystalreporting]

If you have Pervasive, establish an ODBC connection to the appropriate Macola data directory (through control panel). Then, using MSAccess or MSQuery, add the tables listed above one at a time, and delete the offending record in each. If you don't have MSAccess, MSQuery is probably your best bet - it's a standard feature of MSOffice (most versions) and can be accessed by running MSExcel, and selecting Data, Get External Data. It does not install by default, but if it is installed, it can also be run standalone (look for MSQuery32.exe). You can also run SQL statements from within MSQuery. In MSAccess, you'll need to 'link' the Macola table(s) to a blank MSAccess database.

Peter Shirley

http://www.linkcorp.com

 

[dgillz]

cogebi,

Just to clarify, you do not want to delete the tables, just the individual records from the tables. Hence then need to use MS Access or a similar tool.

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

http://www.trianglepartners.com

 

[crystalreporting]

I should've added one 'less technical' alternative as well - depending on the sizes of your files, you could export them to text (through the standard export option in Macola's System Manager), edit them with MSWordpad or a similar text editor, delete the offending record(s), then import them back into Macola.

Peter Shirley

http://www.linkcorp.com

 

[cogebi]

I like this simple method best, in what file can I find this pending order (and is it just in one file)? Thanks.

 

[crystalreporting]

A sales order hits a number of Macola tables/files. The primary ones are OEORDHDR and OEORDLIN. Removing the offending record(s) from these two tables would at least get it off of any open order reports. In addition, OELINCMT, OEHDRAUD, OELINAUD may also need to be edited. OEINQORD will also be hit, but you can re-create this once you've handled the first two by running 'Load OE View Master File' under OE Processes. I'd make a copy of OEORDHDR.BTR and OEORDLIN.BTR, then in Macola (as Supervisor) export these two tables. Edit them one at a time using MSWordpad, removing the record that is giving you the problem. Lastly import them, and make sure all of your information/orders are intact. Please - make a copy of the two files first, and make sure no-one else is in Macola (OE at the least) during the entire process.

Peter Shirley

http://www.linkcorp.com

 

[MacolaHelp]

I prefer using pervasive control center for manipulating data. It is a live link & no need to have users exit the application. Also, no formatting problems or issues that I have sometimes seen using odbc connection to MS tools. In addition to the files previously mentioned, you might also need some others if any of the line items were kits, features, multibin, or pulled manufacturing items. If any of these conditions exist, post & we can tell you the other files to modify. You will want to run reset allocations after you delete these records. If production orders are associated with the lines, you need to reset on order as well.

 

[abaldwin]

Just a word of caution...!!!!!!

I do not mean to sound degrading and I surely do not intend to offend you in anyway, but it sounds like you do not have much experience working with the "raw" data that resides in the underlying database tables for Macola.

I would suggest that you have your Macola reseller clean up this entry for you, or at least provide some training on how to manipulate data outside the normal macola useage.

Once you gain access to the underlying macola data it is very easy to Muck things up Royaly.

Once again. Just a fair warning about doing what you want to do



Andy "A database programmer from way back" Baldwin
abaldwin@des-champs.com


Andy Baldwin