System Generated Customer Event Log - Not Working

SUGGESTED

This week, my Sage 50 just stopped generating entries in the Customer Event Log after we create a Sales Order, Invoice or Receipt of funds.

Before, Sage would automatically generate a System Entry in the Customer Log: "Sales Order to Ship", as soon as you create/save a S/O; "Invoice Sent" as soon as an invoice is created/saved; and, "Receipt" when a receipt is inputted. It stopped on its own but we are still able to input manual entries such as "Comments" or other manual entries.

I have already run a "Data Verification" Check off the File drop-down menu, after a backup. It checked out fine, but the system is still not generating the automatic log that we rely on.

Has anyone seen this problem on Sage before?

  • 0
    SUGGESTED

    Hi JulianY,

    I have seen this before, it seems the EVENTLOG.DAT file in your company folder is corrupted or damaged. See Article 43412 “Event log not showing latest activity” on how to resolve this.

    Thanks

  • 0 in reply to JSelemani

    Hi JSelemani,

    Thank you for your reply! I will try this later today when I get Sage all to myself.

    A couple of quick question though. If I follow the process described  in the link, will it:

    1. Create a brand new EVENTLOG.DAT file and resulting a loss of all log history that we have in there?

    2. Will this process change my accounting period?

    Many, many thanks again for your help!

    B/Julian

  • 0 in reply to JulianY

    EVENTLOG.DAT will be recreated next time you select to open Company, make sure to select Yes in the pop-up screen. This file will be empty, but once you complete steps indicated in above Article, logs will be recreated. Removing this file will not change your accounting period.

    Thanks.

  • 0 in reply to JSelemani

    Hi JSelemani,

    The solution suggest did not work. It actually wiped out all my logs including the system generated postings in the log. I had to rename the old EVETLOG.OLD back to EVENTLOG.DAT. The file I don't believe is corrupted, as I am actually able to write and save any comments into the EVENTLOG.DAT file by just manually enter the comments and date and save.

    What I find strange is that, if I have an back-order that is from 2 months ago, and I re-invoice it so I ship all the back-order items, the system actually posts the invoice entry in the Customer Logs.

    I am wondering if it is something in my logs/sales order/invoice settings for system posting (if there are any global/system settings area..)

    any thoughts?

    Thanks again.

    Julian

  • 0 in reply to JulianY
    SUGGESTED

    Apart from renaming EVENTLOG.DAT file, did you complete all steps indicated in the Article 43412 “Event log not showing latest activity” ?

    Un-post / Re-post all journal should populate newly created EVENTLOG.DAT will all transactions.

  • 0 in reply to JSelemani

    I did not change the accounting period, so I left my accounting period 1 = Jan 2013 - this is the only item that I left alone. Everything else, I followed to a T, based on the steps in  the "Error: "File System Error 7 in file: EVENTLOG.DAT" when trying to view the event log"  Knowledge Base.

    support.na.sage.com/.../viewdocument.do

    To answer your question, Un-post deleted all the transactions (both system generated and manual trans) in the log. But, when I reposted all, all the transactions did not appear (both system generated an manual)

    At that point, I renamed the EVENTLOG.OLD back to EVENTLOG.DAT and got all my old logs back.

    I still don't think the file is corrupt b/c I am at least able to manually write logs (I could add comments in the customer log) and therefore write/save to the EVENTLOG.DAT file. It just that the system generated logs (Sales Order, Invoice, Receipts, etc) are not being generated in the Customer Logs.