Skip to Content
author's profile photo Former Member
Former Member

Amex KR1025 File Upload - Accounting Run Number Generation

Hello Experts,

We plan to use Amex KR1025 daily data file and upload the same using PRCC in to our R/3 Enterprise version 4.7. When we receives the file from Amex, we have developed a customised conversion program that converts this data file into a SAP acceptable format file before it can be uploaded, and during this process, I realised that accounting run number is generated with a static number from Amex file and by adding month and date of the file from file header. For example, company code 'AB12' will have an id as 020527 given to us by Amex and the conversion program adds month and date as 0708(07 being july and 08 being file date). Now I imagine that currently it will work but in future ie, next year there will be an issue with this when it repeats the same number as this number will be repeated again when we upload for file for July 8th, 2011.

Wondering if anyone out there who could share their experience(s) concerning Accounting Run Number in Amex KR1025 data file.

Rgds

CONMJI

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 09, 2010 at 04:28 AM

    Hello,

    Yes, you are correct. Next year it will say that the run number already exists and will not process the file. In the KR1025 file, the header line has the date which should be unique since amex will only create 1 file for each day. We use this date with the company id to create the run number. This will make sure that unique files are loaded and duplicates are errored out. If the combination of the company id and date (mmddyy) is too long, I would truncate the company id since that will be the same in all files for this company, you'll still be able to process correctly without the risk of duplicating.

    Hope this helps.

    Sal

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 09, 2010 at 10:59 AM

    Yes, you need to change the logic for accounting number. It is must to use atleast DDMMYY if not DDMMYYYY in the accounting number. Try to concatenate the country code 2 digits before Date. eg USDDMMYYYY

    We dont use KR1025 but we use this logic for CCF and VCF format files.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 09, 2010 at 03:49 PM

    Many thanks Guys.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.