What it is #
The Z-file is a finance export that turns a period’s shop sales into a journal to be imported to JDE accounting system. This report is available to Finance Administrators only.
STEP 1 — GENERATE THE FILE IN THE SHOP #
- Go to MU Portal → Reports.
- Choose the period you’re posting (e.g. This month, or a custom date range) and apply any filters you need.
- Click “Generate Z-file”
- A file downloads to your computer, ready to import into JDE.
STEP 2 — WHAT THE FILE CONTAINS #
One row per sale line, each tagged with its department’s company code (10 or 80), the JDE account it posts to (Business Unit + Object code), the net amount, and a reference (order number + customer name).
Summary “clearing” rows at the bottom — one pair per company code — carrying the total VAT to the VAT clearing account and the total gross to the sales clearing account.
The file is self-balancing: total debits equal total credits, so JDE accepts it as a complete, postable journal.
#
Good to Know #
Generate one file per posting cycle (e.g. monthly) — each file only covers the period you select.
VAT posts to a clearing account and sales to a sales clearing account, so the net effect matches the shop’s takings for the period.
If a period includes both company-10 and company-80 sales, they come in a single file with separate summary lines for each.
The account numbers, VAT codes and date format are set to match your finance team’s JDE configuration.
