--- title: "Mapping of inventory transaction journal to FMUTA file export" slug: "mapping-of-inventory-transaction-journal-to-fmuta-file-export" description: "Mapping of inventory transaction journal to FMUTA file export" tags: ["check-ai", "QA611"] updated: 2024-06-10T09:07:49Z published: 2024-06-10T09:07:50Z canonical: "docs.retailvista.net/mapping-of-inventory-transaction-journal-to-fmuta-file-export" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.retailvista.net/llms.txt > Use this file to discover all available pages before exploring further. # Mapping of inventory transaction journal to FMUTA file export <span class="fr-marker" data-id="0" data-type="true" style="display: none; line-height: 0;"></span><span class="fr-marker" data-id="0" data-type="false" style="display: none; line-height: 0;"></span>This document describes the mapping of the RetailVista inventory transaction journal to the FMUTA file format. The general structure of this format is described in QA610. In that QA, header and detail lines are described, each with their own column numbers. This document establishes a link between the RetailVista inventory transaction journal and the column numbers of FMUTA. A new header line is started in the FMUTA file for each inventory transaction journal and process type, so the line number is always 0. | RetailVista data | FMUTA destination | Remark | | --- | --- | --- | | Line number | Header line column 1 | See introduction about line numbers | | Journal type | Header line column 2 | | | Journal date from/to | Header line column 8 | | | Journal export code | Header line column 3 | | | Fiscal year | Header line column 5 | *1 | | Period | Column 4 headline | | | Journal number | Column 6 headline | Maximum 5 characters are supported, the rest will be truncated | | 'N' | Column 32 headline | Always exported as 'N' | | | | | | Line amount | Column 13 detail line | | | Line general ledger export code | Column 9 detail line | | | Line description | Column 7 detail line | Can be truncated to the maximum journal description length setting | | Line date | Column 8 detail line | | *1 - The fiscal year and period can be automatically calculated by RetailVista based on the journal date. It takes into account the settings in RetailVista for the duration of a period. It can be a month or 4 weeks. When exporting the journal, it can be indicated in the export screen whether the year and period should be automatically calculated, or a manual year and period can be entered in that screen.