MAS90 4.05. error 40 in program powudc @ line 2560

[Guest_imported]

When trying to delete obsolete PO's I receieved a message telling me that I had material return req to still be updated. I went into that program to update and received this message. Upon further investigation, I discovered that an inventory item had been returned on a regular PO The Po was from April of 2006, of course it is closed. I do not know how to fix it. I am not able to update any Receipt of Goods or Invoices in the PO Module. Please Help

Thank You
Mellone

 

[BigLouie]

Error 40 POWUDC 2550 or Error 40 POWUDC 2560, when posting the Return of Goods Register

Entry Type: Informational

Product: Sage MAS 90 ERP, Sage MAS 200 ERP, Sage MAS 200 ERP - SQL Server Edition

Application: Purchase Order

Version Reported: All Versions

Subject:
Error 40 POWUDC 2550 or Error 40 POWUDC 2560, when posting the Return of Goods Register and the return of goods is referencing a purchase order which was purged during Period End Processing. In other words, if a return is entered and not posted, then Period End is performed which purges the purchase order referenced by the return, the error will occur. This issue can also be caused by receiving and invoicing a P/O line, then creating a return of goods which references that line, then deleting the completed line from P/O entry before updating the return of goods.

Steps to Duplicate:

1. Open Purchase Order / Main / Purchase Order Entry
2. Create a new purchase order. Add any quantity of any item. Click 'Accept'.
3. Open Purchase Order / Main / Receipt of Goods Entry and process a receipt of goods with an invoice number so the purchase order is completed. Update the Receipt Register.
4. Purchase Order / Mat Req/Return / Return of Goods Entry, create a return of goods referencing the same purchase order from above. Do NOT update the return; leave it sitting in data entry.
5. Purchase Order / Period End / Period End Processing and select 'Purge Completed Purchase Orders'
Note: This step involves the 'Number of Days to Retain Completed PO' option in Purchase Order Options.
6. Go back into Return of Goods Entry and attempt to update the Return of Goods Register
7. Notice the error 40 occurs because the PO was purged


Expected Behavior:
For the Purchase Order Period End to prohibit access until all Purchase Order data entry has been posted. This includes Receipt of Goods Entry, Receipt of Invoice Entry, Return of Goods Entry & Material Requisition Issue Entry.

Possible Workaround:
Note: Extreme caution should be taken when selecting Debug. Only type the commands shown in the below instructions.

1. Recreate the error, click 'Info' and then click 'Debug'
2. At the prompt (>), type the following: ? POE$ and press 'Enter'. This should give you the return of goods number. Type Bye to close the Debug.

Note: Use caution when working with repair utilities. Always make a backup first. If necessary, seek the assistance of a qualified Sage Software business partner or Customer Support analyst.
3. Open Library Master / Repair / Data File Display and Maintenance (DFDM)
4. In the 'File Name' field, type POExxx (where "xxx" = company code) and press 'Enter'
5. Click the 'Key Scan' button and select the return number from the debug steps above.
6. After selecting the return, click 'Delete' and answer Yes to "Delete the current record?"
Note: If using batch entry, the same return number will need to be deleted from the batch file. If not using batch entry, proceed to step 11
7. To delete the return record from the batch, if DFDM is still open, click into the 'File Name' field to clear
8. Click the browse icon (yellow folder) to the right of the 'File Name' field which will open an explore window.
9. Locate the POxxx folder (where "xxx" = company code) and then look for POEbbbbb.soa (where bbbbb is the batch number) Example: if the batch number was "123", look for POE00123.soa. Double-click on the file which will open it in DFDM.
10. After selecting the batch, click 'Key Scan', select the return number and delete it
11. Open Library Master / Repair / Analyze and Relink Line Files, select Purchase Order for the application and the company code
12. From the list of files, select POFxxx Return Entry Line File. Click 'Proceed'
13. Next open Library Master / Repair / Rebuild Application Sort Files, select Purchase Order and the company code. Click 'Rebuild' and answer 'Yes' to "Would you like to recalculate open purchase order quantities in the inventory masterfile also?

 

[BigLouie]

Let me add that I found this through a method that you should have, could have use. Go to the Sage web page. Log in or sign up. Since you are on v4.05 I assume you are current on your subscription. Then go to Knowledge Base and type in the error number, program name and line number as as you have at the top of this post. It would have given you the response I posted.

 

[Guest_imported]

I followed the instrucitons provided to retrieve the key (from the debug information) and did the file repair (deleting the said key). Problem is resolved - thank you for detailed instructions!