Sage 100

I am importing into Sage 100 Advanced ERP 2014 into Transaction Journal Entry. I believe I have all Line fields that need to be assigned. I am getting the event log ""L Record Invalid or Write Failed. is not on file.

@LarryBradford, it sounds like a required column is not getting populated. I tend to reverse engineer imports that get ornery by manually entering the transaction I want to import. I then use VI to export the entry into a text file and see how it compares to the file I am trying to import. I then try to use the exported data in an import, defining every column with data, to prove that the process works. It if does, it's now just matter of finding what is in the file that you didn't have and finding the missing data elements required. I know it sounds basic but sometimes, reverse engineering is easier than banging my head. With transaction entries the required columns vary depending upon the type of entry entered. (Just like in the data entry screen.)

DO they have batches turned on and you're not filling in the batch field?

Here is one that worked in v4.50. I used it to import the beginning inventory balances a couple years back. I would think it should still work in 2014.

So, The answer was to add the Bank Code to the lines. Even though this was an adjustment (not a transfer). Scott Brady called me back and had recalled having the issue. He could not tell me if it was a 2014 only issue.

Oops, my bad. Completely misinterpreted the issue. My apologies... The fact about the bank code makes a lot of sense since transaction JE is all about the bank code and getting the cash account information to post to the bank rec. While TJE is a heckuva lot better than the old version, it is frustrating how different it is from JE.

I agree. The header tab has to have the bank code. Lines only need bank code for transfers. My sell is it was designed to look like layman's screens else ware with a header and detail screen.