EDI Generator for muliple input records (multiple records in 1 page)

B2B Manager for EDI
1

I am exporting Invoices (Saved Search Main Line = FALSE, grouped rows = TRUE) to an FTP as EDI 810 (x12).

I have set up the FTP with EDI file definition, and parser correctly (I replaced the default mapping for all the transaction level segments BIG, N1, ITD etc. But kept the mapping for envelope level data same e.g. ISA, GS, ST etc.). I have set the max occurrences of Transaction in a GS to 1 (it was 1000 by default) since I want 1 transaction per envelope.

When I try to sync multiple file with NS Export Page Size = 1, it creates two files in the FTP. But when keep the NS Export Page Size to default, I get the following error:

Message: 
    Mandatory loop N1 is missing

  Code: mandatory_loop_absent

  Source: Resource
  
  Timestamp: 2025-05-13T22:28:32.016Z

  Error ID: 1369237714
  
  Trace key : 621523

The image shows an error log indicating that "Mandatory loop N1 is missing," with details such as the code "mandatory_loop_absent" and a timestamp. (Captioned by AI)
The image shows an error log indicating that "Mandatory loop N1 is missing," with details such as the code "mandatory_loop_absent" and a timestamp. (Captioned by AI)1689×283 39.1 KB

When I tried to create a sample output in the EDI generator, it worked fine.

The image displays a code editor with JSON file definition rules for an "Amazon Vendor Central US 810" invoice, alongside a sample flow data section and a generated file preview. (Captioned by AI)
The image displays a code editor with JSON file definition rules for an "Amazon Vendor Central US 810" invoice, alongside a sample flow data section and a generated file preview. (Captioned by AI)1698×700 71.1 KB

I tried to change the EDI Generator sample input; instead of input being a record JSON object, I changed it to a array with two JSON object (corresponding to 2 JSON records). When I previewed with this sample input, I got the same missing N1 loop error as I posted above

The image shows a text editor with JSON code for file definition rules and an error message indicating that a mandatory loop, N1, is missing. (Captioned by AI)
The image shows a text editor with JSON code for file definition rules and an error message indicating that a mandatory loop, N1, is missing. (Captioned by AI)1693×697 68.4 KB

There must be a way to export a batch of records/multiple records in a single page (where page size > 1) and import them to an FTP as EDI files where 1 EDI file correspond to 1 record from the export step. E.g. If we export 4 invoices, we should be able to create 4 EDI files and each file has 1 envelope (1 ISA), 1 group (1 GS) and 1 transaction (1 ST set). Can anyone help me with this?

Setting the page size to 1 really makes it a cake walk but for a large volume this is not practical. There has to be a way to do this without setting the page size in the NS export to 1

2

Hi @sujitdesai
Could you please share the file definition rules, sample flow data, and the expected output file? Also, could you confirm whether the ISA and GS information will remain the same across all transactions, aside from the control numbers?