PO's created in User Acct can not be reprinted? 1

[smtoomey3]

I have a user who is unable to reprint PO's that were created using her acct, no one else can print PO's she created either they have to change the buyer and then they can print them. She is able to print PO's created by other users. Any ideas??

 

[dgillz]

What error message are you getting?

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

http://www.gainfocus.biz

 

[stravis]

Initialize the PO Buyer Print File (POBUYERP if you are using Pervasive or the POBUYERP_SQL table if you are using Microsoft SQL Server). When printing purchase orders a record is created in this table to lock any other user from printing orders for a buyer planner. If the process fails before removing the lock then you will have to initialize the PO Buyer Print File.

Scott Travis

http://www.infospring.net

 

[smtoomey3]

Buyer/Planner record locked at another location.

 

[stravis]

To clear up your error, follow these instructions if you are using Macola SQL

1. Log everyone out of Macola
2. Open Query Analyzer and Log in to your Macola SQL Server.
3. Run the following script

use msllockdb

delete maclocks
delete macopentables

4. Close Query Analyzer
5. Log back in
6. Initialize the POBUYERP_SQL table

or these instructions if you are using Macola with Pervasive Btrieve.

1. Log everyone out of the workstations.
2. Reboot your Macola Server
3. Log back in.
4. Initialize the POBUYERP table

 

[dgillz]

Scott's answers are 100% correct.

This error message is in and of itself an error. I have already reported this to Exact. It should read "PO Buyer/Planner Print File Locked at Another Station". This is totally different from "Buyer/Planner Record Locked at Another Station".

Usually you can just initialize the POBUYERP file and be done with it, but Scott's answer will take care of it 100% of the time, IMHO. And a star to you Scott.

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

http://www.gainfocus.biz

 

[smtoomey3]

Thanks,,,I'll give that a try

 

[smtoomey3]

Just out of curiosity if I was to just delete the line out of the POBUYERP Table that references the user with the problem would that fix the issue?

 

[dgillz]

Yes, deleteing the line out of this table is in essence the same as initializing the table.

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

http://www.gainfocus.biz