Dynamics Community Forum Thread Details

Importing Credit Card transactions using electronic reporting

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,

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL