x Want to participate? Join the group to interact
  • State Verified Answer
  • Replies 2 replies
  • Subscribers 41 subscribers
  • Views 3804 views
  • Users 0 members are here
Browse Forums
Announcements
234
topics
29
replies
General Discussion
5k
topics
13k
replies
Sage Data & Analytics
56
topics
95
replies
Sage Enterprise Intelligence
208
topics
406
replies
Sage Intelligence Reporting
121
topics
322
replies
Abhishek_C

SAGE X3/EM - error while closing period

SOLVED
Posted By

Hi All,

I'm getting error while closing fiscal period and didn't find any solution on forums for the same.   

Can anyone suggest me, how to resolve below error. So that I can close fiscal period. 

Error -  $VERF_TMP EXPE "Journal number" Entry that the batch task could not validate

Verifications "Company name" From 25/02/18 To 31/03/18
Ledger Legal
$VERF_TMP EXPE "Journal number" Entry that the batch task could not validate

If deleting entry is the only solution then kindly let me know what all tables should be use for deleting this entry which could waive of entry completely.

FYI, This journal created from supplier invoice.

Many thanks..

Regards,

Abhishek

  • 0

    Hello,

    Below is a similar error, also make sure that the accounting tasks function is turned on as well. 

    Error: "$VERF_TMP SPINV xx00000 Entry that the batch task could not validate".
    Products
    Sage X3 6

    Description

    When closing a month the following message appears in Common Data, G/L Accounting Tables, Fiscal Periods the Message came up as follows:

    • Ledger Legal
      "$VERF_TMP SPINV PABC00000112 Entry that the batch task could not validate".



    Disclaimer
    Backup Warning
    Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions. If necessary, seek the assistance of a qualified Sage business partner, network administrator, or Sage customer support analyst.

    Cause

    Look for any journals on Hold, Usage, Batch server, Accounting tasks.



    Resolution
    1. Check for Locked Symbols and Locked Processes:
      • Development, Utilities, Verifications, Locks, Locked symbols.
      • Development, Utilities, Verifications, Locks, Locked processes.
        • Look for users that have been logged in for abnormal amount of time.
        • Check to see if any processes seemed locked up that are related to these initial journal postings.
    2. Stop the accounting tasks and any EDI tasks, stop the batch server, restart the batch server, restart the accounting tasks and EDI tasks if any.
      • Nobody can be posting entries during this time.
    3. Setup, General parameters, Parameter values, CPT, MTC, MTCNBR, if it is set to 1000, increase it to the max which is 32,000.
    4. Check if there are any Journals on hold Usage, Batch server, Accounting tasks.
      • There may be temporary records (Invoices) in the GACCTMP table.
      • Development, Utilities, Maintenances,  In lines change the flag FLG from 1 to 0.
        • Prior to do this step stop the Accounting tasks.
        • Change the flag.
        • Start the Accounting tasks.



    Category
    Batches, entries, posting
    processing invoices, receipts, shipments, orders, data entry, and batch processing to current and previous years

    Entitlement
    Open
  • +1 in reply to Rafael
    verified answer

    Hello Rafael,

    Thank you for your detail reply.

    I have checked Locked symbols, Locked processes and didn't find any locked journal for respective company. However I can see 1 journal on hold in accounting task (VALPCE) screen. Also I found the same journal number in GACCTMP table, which is causing issue while closing period. 

    Kindly let me know how I can clear those from temp table and process for period closing successfully. I tried your below suggestion but issue remains same.

    Development, Utilities, Maintenances,  In lines change the flag FLG from 1 to 0.

    • Prior to do this step stop the Accounting tasks.
    • Change the flag.
    • Start the Accounting tasks.

    And it again updated FLG =1 when I started accounting task. 

    It would great if you can reply ASAP.

    Regards,

    Abhishek

*Community Hub is the new name for Sage City