Skip to content
UsecaseBoard
← All use cases
hacker newsInvoices

Turn a multi-invoice EDI message into a spreadsheet

At a glance

A commenter used ChatGPT to turn a D.96A invoice message into an Excel report, correcting its interpretation along the way. This workflow is listed under Invoices, Spreadsheets.

Agents / tools
ChatGPT, Excel

SourceBuilding a tool for these workflows? See weekly rates.

What they did

1) Open the ChatGPT web interface and upload the D.96A INVOIC text message containing the invoices. Ask it to analyze the message. 2) Check how many invoices it found. In the author’s case it parsed only the first; they told it the file contained 27, identified `MOA+77` as the invoice amount and explained that `BGM+381` marked invoice 19 as a credit note. 3) Request a detailed Excel report including all line items, initially with one worksheet per invoice. Then request a variant with all 27 invoices in one sheet and a column for the invoice or credit-note number. 4) Ask for a second sheet summarizing each invoice with a separate column for each MOA code. Inspect the generated workbook against the source and correct interpretation errors.

How it went

The commenter reported receiving an Excel file after correcting several code-interpretation mistakes. Their description of the final worksheet arrangement is ambiguous, so the exact final layout is not established.

Save ideas in this browser. Upvotes count across the board.

Prompt excerpt

No prompt excerpt was provided by the source.

Sponsored

CodeBuddy

Tencent Cloud AI coding assistant for IDE and CLI.

Try CodeBuddy ↗
Explore all →