How to Fix COP Lock File Error When Printing Invoice

How to Fix COP Lock File Error When Printing Invoice

Release Date: 08/21/2018

Q - Every time we try to print invoices or credit memos, we get this Btrieve error:

    Btrieve Error USE on CPFRMFIL COP Lock File

See sample screen below:


I don’t see anyone locking this file in the PSQL Monitor utility. Do you know how to fix this?

A - This one is a little bit tricky. The error is caused by CPLCKFIL.DAT. Since this one is not a Btrieve file, you can’t see who is locking it from the PSQL Monitor utility. 

To find out who is locking CPLCKFIL.DAT, you need to go to your PSQL server console and start Computer Management, go to Shared Folders -> Open Files and find who opened this file. See sample screen below:



With batch invoice printing, Elliott only allows one user at a time to print an invoice.  The existence of this file is to prevent two Elliott users from performing batch invoice printing at the same time.  Just get this user to logout and try to print invoices or credit memos again.


EMK


    • Related Articles

    • Btrieve Error USE on COP Lock File

      Q - Today, for whatever reason, we experienced a large amount of locking issues in the warehouse. Several times today we ran into the problem with printing invoices where we received a message "Btrieve Error USE on COP Lock File," and it stops ...

    • Getting PO Lock File Problem During PO Printing

      Q - I was attempting to print a Purchase Order and received the following message: Btrieve Error USE on PO Lock File - 065 File Locked A - The message implies you have two users trying to use "Print Purchase Order" function at the same time and that ...

    • System Lock File Requirements

      Lock files are used in Elliott to prevent users from entering transactions when other users are posting, to prevent users from entering transactions when invoices are printed, or to prevent multiple people from printing purchase orders at the same ...

    • Feature - Invoice History Printing with Currency Conversion

      Release Date - 11/8/18 This feature allows history invoices to be printed using currency conversion rates.This applies to any amount field, such as the unit price, extended amount, total sales, freight, misc. charges, tax amount, grand total, payment ...

    • How to Lock a Sales Order from Being Changed

      Q - We know that printing an invoice or selecting the order for billing will lock the order and prevent anyone from changing anything on the order from that point on. Are there any other ways to prevent users from changing orders without having to ...