General Ledger Exchange - Import Error Message

[carolamrt]

I am importing a large set of monthly GL transactions. MAS90 4.05. From an Excel spreadsheet.

Succeeded in getting the spreadsheet past the validation stage. But when I do the actual import process, all records are skipped and this is the error message I get.

Skip Reason/Comment - "You must enter at least one line"

Any advice would be greatly appreciated.

And I cannot imagine that we really need to enter the Line sequence number and Journal Register number manually instead of having the system just get the next sequential number. Am I missing something?

I am using the standard, not the alternate format.

For the Account Description I am using what is in the spreadsheet, which may not exactly match character for character what is in the MAS90 GL Master file. I cannot imagine why this field is necessary. Given the appropriate GL Account, MAS90 already has the Account Description.

For Journal Register Number I am putting in "001000" and the parameter is set to get the next available register if this one is already used. I really don't want our staff to have to go in and get the next number from MAS90 when this is something that MAS90 can do all by itself.

For Line Sequence Number I did a Fill Series in Excel starting with 1 and ending with 600. There are 600 entries. Again, this field should not be required. MAS90 should be able to increment this all by itself.

I was thinking I might try an ASCII text file instead of Excel. There is a note on the only documentation I could find:

NOTE The ASCII text file type requires that each data field be positioned at particular character positions. All other file types must store each data field as a separate field or column.

Are the values of these particular character positions documented? Or is it trial and error.

If anyone has successfully done this and can offer assistance I surely would be grateful.

 

[carolamrt]

Giving up.

I do not understand how Sage can sell a product line and withhold the documentation needed to use it.

I will try VI next.

 

[BigLouie]

Verify that the correct General Ledger Exchange format is used, and that there are no blank fields or columns within the source file layout. For example, if using standard exchange format, make sure that there are no blank fields or columns between the 'Source Module' and 'Posting Amount' fields.

There is excellent documentation in the Help files plus in the Sage support web page there are two Word docs detailing how to set it up and possible error conditions and resolution.

 

[carolamrt]

Big Louie - I have TRIED to get documentation.

I have been all over the Sage Website. I see some hints that there are doc files but I certainly haven't found them. A couple of web links state "attached doc file" but there is never anything attached and no link.

I do have the Exchange FAQ that is part of the Library Master chm. And that is what I am working with.

If you can either provide me a link or send the doc files I would be SO GRATEFUL.

This should be very easy to find by hitting the F1 key or doing a Google. I get really frustrated when I can't find the necessary documentation within a few mouse clicks and a google or two.

No Blank Fields between Source Module and Posting Amount???? But the Format on the FAQ shows a Reference Description that is "N/A" for the standard exchange format. When I eliminate this column I get Out Of Balance errors on the validation. When I include it, but empty, the validation works but I get the error message stated above.

The transactions DO balance. All numbers add up to zero.

 

[carolamrt]

Big Louie Thank You!!!

I am fine now.

If you are anywhere near southern california I will treat you to a lovable puppy.