Skip to Content
avatar image
Former Member

GL1025 File specification-AMEX

Hi All,

I want to test GL1025 file uplaod in SAP. I got one test file with some test data. I want to replace the test data with my system data. I am unable to identify the specification s of the file and replace accordingly.

For example:

In GL1025 file, I am seeing the data as:

0136554         6 14629     GL1025  0001 01 2 014-12-19 1 4353 03 2007-09-21 P0 354 8402 +000000003 423249 +000 8317073 82525000000000000000 82014121914353 3510378402 8402 +00 0000003423249+0000000 00000000+00000000 3423249 +000000 008317073+0 0 00+000000008317073000000000000229

Now, I want to add my system employee number, credit card number, expense type and dates etc.

Now how do I understand as to which data pertains to what, so that I can replace them with my data. In simple words, I want to decode the test GL1025 file and identify the data to be replaced with correct values. Once my test file is ready I can upload them to my SAP and test.

Please help.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Dec 29, 2014 at 02:33 PM

    Hi,

    Let me attach the file I am trying to match with the GL1025 file specification. These are old sample data, which needs to replaced with new sample data. Hope you have the AMEX file specification.

    <Attachment removed by Moderator as requested by Poster> Message was edited by: Lukas Weigelt

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 23, 2014 at 05:38 PM

    Hi Vijay,

    You can contact AMEX and they can provide you with the GL1025 file specification - AMEX call this as 'Data File Guide' . The file specification will list the position of individual fields which you can check and compare with the data in the file.

    Hope this helps.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Vijay,

      If you have received the GL file from AMEX then it should really match. Unless someone has manually tweaked the contents of the file. Sorry for a stupid question but are you sure that you are looking at the GL file spec and matching it with a GL file and not with KR file and vice versa?

      Without looking at the file I am unable to help you.

      Thanks

      Ankur