When trying to delete unnecessary data, the system may display library procedure errors 5 or 6. Their reasons and solutions are described below.
Error 5: Invalid Data Removal Parameters
If error 5 appears, it means that the dates or the parameter of the correspondent are incorrectly selected.
To solve the problem, make sure that:
- Invoice date of incoming balances is less than Min. date of stored documents. Please note that dates cannot be equal.
- The base date of documents is less than or equal to the Invoice date of incoming balances. To find the base date of documents, do the following:
- Open the Sdbman.exe application
- Go to Maintenance > Execute procedure
- In the window that opens, enter the ShParams value in the Procedure field
- Click Execute
- The base date of the documents is shown in field 110, column 101.
- For the selected Correspondent of incoming balances in the Type 2 field, the Special Correspondent is selected. To determine the type of correspondent:
- Open the SH.exe application
- Go to Dictionaries > Counterparties > Correspondents
- Go to the All correspondents tab
- Find the selected correspondent
- Make sure its Type 2 is special correspondent
Error 6: Deleted and Saved Documents are Linked
If the message about an error in the server library procedure 6 appears, then there are documents in the deleted period that refer to the remaining ones.
Information about such documents is recorded in the server log. If the data for a specific position of the invoice cannot be deleted, the following is displayed in the log:
- Invoice number
- Invoice date
- Product name.
Let's consider the examples of errors in the logs:
Example log 10/22/2021 15: 02: 23- Obstructed docs (type 1, 5) 10/22/2021 15: 02: 23- P2w / t763 10/6/2020 Jameson Whiskey 10/22/2021 15: 02: 23- w / t45 1/20/2020 Pine nuts
The Obstructed docs (type 1, 5) error — return of goods to the supplier / return of goods from the buyer refers to the deleted invoices (p / n or p / n).
Solution:
Change the period for deleting documents
Change document flow - create invoices of a different type.
Example log
10/22/2021 15:02:23- Obstructed docs (type 9)
10/22/2021 15: 02: 24- P2psn949 12/29/2019
Error Obstructed docs (type 9) - the expenditure part of the internal sale is in the deleted period, and the receipt of the internal sale is in the retained part of the invoices.
Solution:
Change the period for deleting documents
Change invoice dates
Change document flow - create expense and receipt invoices.
Example log
10/22/2021 15:02:24- Obstructed docs (pdoc refs)
10/22/2021 15: 02: 24- Invoice No. 27 2/25/2016
10/22/2021 15: 02: 24- p / n8 3/31/2016
10/22/2021 15: 02: 24- p / n8 3/31/2016
10/22/2021 15: 02: 24- p / n37 12/25/2019
10/22/2021 15: 02: 24- p / n36 12/24/2019
10/22/2021 15: 02: 24- p / n38 12/24/2019
10/22/2021 15: 02: 24- p / n39 12/25/2019
10/22/2021 15: 02: 24- p / n36 12/24/2019
Obstructed docs (pdoc refs) error - invoices that are referenced by payment documents in the left period are deleted.
Solution:
Change the period for deleting documents
Change payment dates.
Example log
10/22/2021 15:02:24 - Obstructed docs (idoc refs)
10/22/2021 15: 02: 24- Invoice No. 27 2/25/2016
Obstructed docs (idoc refs) error - invoices referenced by invoices in the period to be left are deleted.
Solution:
Change the period for deleting documents
Change invoice dates.