Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Unanswered

Importing Credit Card transactions using electronic reporting

(1) ShareShare
ReportReport
Posted on by

Hello,

I'm currently working on creating an electronic reporting import format for processing credit card transactions from AMEX. Here's how it's structured:

  • Header record: identified by '0' at at the starting position. 
  • Market summary record: identified by '8' at at the starting position. 
  • Employee transaction records (multiple per employee): identified by '1' at at the starting position. 
  • Employee summary record (one per employee): identified by '2' at at the starting position. 
  • Trailer record: identified by '9' at at the starting position. 

Each employee's records are repeated multiple times within the file.

Here’s a sample sequence (txt):
Note there are no delimiters it's position based.

0 (Header)
8 (Market summary)
1 (Employee transaction - EMP001)
1 (Employee transaction - EMP001)
1 (Employee transaction - EMP001)
2 (Employee summary - EMP001)
1 (Employee transaction - EMP002)
1 (Employee transaction - EMP002)
2 (Employee summary - EMP002)
9 (Trailer)

I've successfully imported transactions for one employee. However, when attempting to import files with transactions for multiple employees (e.g., three employees), the process stops after the first employee's records. Maybe the issue is related to the employee summary records being in-between? (type 2).
 
Format:
 
 
When I try to import - file only partially imported. 
 
 
This is the output of the format map to model ( Attached file)
 

Could you please provide advice on how to handle multiple employees' transactions effectively within this structure, especially regarding the possible impact of the employee summary records?

Thank you in advance.

Best regards,

  • Adis Profile Picture
    Adis 2,429 on at
    Importing Credit Card transactions using electronic reporting
    Hey,
     
    Do you have any formulars in the format or in the mapping? My first thought is you are using FIRSTORNULL somewhere, in that case the system would just pick the first record.
    Maybe you can share the mapping tag for one or two lines.
     
    Did you create the configuration from scratch or from an existing Microsoft configuration? In case there is one from Microsoft, I would check how it was implemented, maybe it will give you a clue.
     
    Kind regards, Adis

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,642 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans