OLD MAS90 IMPORT TRANSACTION PROBLEM

Hi guys.. 

I just tried to "import transactions" (Xchange tab)  with DIF file on my MAS90 ver3.4 (it's very old. It's time to upgrade... anyway)

All thing's going well except 'year'. For example, whatever I key in or put in 12/31/23 or 12/31/2023 or etc.... , it always got the year '00' like 12/31/00 or 08/31/00. 

Except "year", everything including amount, comments, account code etc... is fine. 

Is there anybody who can deal with this kind of bug?? 

Or Sage does not support very old ver. of MAS90 anymore ? 

Waiting for the Savior. I'm sure he'll be very grateful.

  • 0

    Hi  - haven't looked at in, like, forever - but I'm guessing you're talking about the old GL Exchange Utility on the General Ledger menu. The oldest version I have handy is 2017, but it still exists - and there is a help menu included (there used to be a KB article that we used as reference, but with the "new and improved" KnowledgeBase I am not even going to look for it at this late hour).

    Here is something from the help menus that might answer your question:
    "What general ledger exchange file types are supported?

    When defining an exchange setting, you can specify the type of file that will be used to exchange data. The following file type formats are supported for importing and exporting data:

    • ASCII

    • CSV (Comma Separated Values)

    • Excel

    • XML (Extensible Markup Language)

    In addition, DIF, Excel, PDF, and Word are supported for exporting data. For more information about supported file types for exchange settings, see Sage Online.

    Note  To import data from a file type that is not listed above, you must create an intermediate file (for example, a .txt file) using one of the supported formats; however, most applications provide a data exporting feature that supports one of the above file types.

    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."

    So it may be as simple as the fact that your DIF file can be used to export, but not import. I've never tried to use that file type, so I can't speak more to that.

    When I first saw your post I thought it might be the Date Format. Looking at another section of the Help Files, and I am reminded there are 2 different G/L Exchange types, Standard and Alternate:
    "

    Field Description

    Alternate Exchange Format

    Standard Exchange Format

    Account Number

    9 characters maximum (not including separators)

    41 characters maximum (including separators)

    Account Description

    30 characters

    50 characters

    Transaction Date

    8 characters

    Note Transaction dates must be formatted as MM/DD/YY.

    10 characters

    Note Transaction dates must be formatted as YYYY-MM-DD.

    "

    If that doesn't answer your question, perhaps someone else can find the old KB article.

  • 0 in reply to rclowe

    Hi, RCLOWE

    really really appreciate your kind help. Until now, I can not import properly. However, you teach me a lot.. 

    Thank you so much. 

    Have a nice weekend.