Sage 100

Client has created a new company with the same accounts as old company and wants to copy over Recurring Journals. Wrote an export from old company (can't just copy files because the AccountKey field isn't the same for the same Account) and when I try to import into new company, each line says you can't import because it's out of balance (by the amount of the line). I have Accept Out Of Balance set to Y. Any suggestions? (4.40 PU1 or 2)

Does the Records tab/screen need to be populated?

I don't have ""Header separate from line record"" checked, so I'm not sure what I would do on the Records tab, since that has both of them on there but would indicate to me that they were separate lines. This 4.40 doesn't seem to use the Records tab much anymore, but since there are no instructions, one is, of course, bumbling about in the dark. So, I put something on for the Header - said if 1st char not equal blank. So it then told me that I had to have at least one line and failed everything. POS...

Not sure if this helps or not, but did you see this Forum thread? http://community.sagemas.com/t5/Personalization-Customization/Import-GL-Recurring-Entries/m-p/18691

I got all excited (and pissed because I looked up ""recurring import"" before I posted here and I didn't find that darn post) and made the change he/she mentioned, but alas - still no go. On 4.3 I could get the headers in, but no lines no matter what my credit looked like.

I have found with JE's in v4.4 that you have to import the GL account to a temp field, then do a calc on the temp field for the GL account import. It doesn't sound like the same issue, but worth a try.

I did have to do that, but that part is OK

OK, everyone, here is the deal. The import now works, because I took out the L.PostingComment field. I kid you not. AND you can't have a negative value in the Credit field, as I thought that other posting implied, so that may have changed between 4.3 and 4.4.

Lately for J/E imports I have been using just the debit field. The business object will automatically move the amount to the credit column if it has a negative.

I often do that, too. Let me be more specific on my solution - the problem was the L.PostingComment field BECAUSE the value of that field in the import file was BLANK. This was also true when importing in the Standard Journal file - if the line comment field was blank, the line would not import. It's not a required field, so WEIRD.

@JimWoodhead - I like that method as having amounts in one column makes it easier in Excel to verify that the JE balances with an =sum formula.