Integrated modules' year-end processing

This topic describes the year-end processing tasks involved for the Distribution SX.e modules that update General Ledger: Accounts Payable, Accounts Receivable, and Inventory.

Accounts Payable year-end processing

Several accounts payable reports support year-end adjustments that might be required in General Ledger. Run these reports in detail, and save them as a file or email for auditing purposes:

  • Vendor Period Analysis Report
  • Vendor Trial Balance Report
Note: Do not change the current year in SA Administrator Options-Financials-Fiscal Year if you expect to do any back-posting. The correct year is updated automatically when GL Administrator Year End Report is run.

Run the Vendor Administrator Federal 1099 Print report at the end of the calendar year for 1099 vendors only. If you run Vendor Administrator Federal 1099 Print before running the Vendor Administrator Year End Report, then specify Current for the (C)urrent or (P)revious Year's Payments report option to pull Vendor Setup year-to-date (YTD) data. If you run Vendor Administrator Federal 1099 Print after running the Vendor Administrator Year End Report, then specify Previous year's payments for the (C)urrent or (P)revious Year's Payments report option to pull Vendor Setup Last YTD data.

Run the Vendor Administrator Year End Report at the end of the calendar year for 1099 vendors only. Run it at the end of the fiscal year for all other vendors. Running Vendor Administrator Year End Report clears these YTD balances for each vendor:

  • Invoices
  • Payments
  • Returns
  • Rebates
  • Discounts Taken
  • Discounts Lost
  • # of POs
  • # of POs Late
Note: Running the Vendor Administrator Year End Report on the last day of the fiscal year is not required, however, you must run it before your first day of processing in the new fiscal year. If you require assistance, contact Infor Support Services.

Accounts Receivable year-end processing

Several accounts receivable reports support year-end adjustments that might be required in General Ledger. Run these reports in detail, and save them as a file or email for auditing purposes:

  • Customer Period Analysis Report
  • Customer Trial Balance Report
Note: Do not change the current year in SA Administrator Options-Financials-Fiscal Year if you expect to do any back-posting. The correct year is updated automatically when GL Administrator Year End Report is run.

Run the Customer Administration Year End Report at the end of the fiscal year. Running Customer Administration Year End Report clears these YTD balances for each customer:

  • Sales
  • Cost
  • Returns
  • Service Charges
  • Cash Discounts
  • Unearned Discounts
  • Rebates

We recommend running the year-end report when these YTD balance fields reflect correct amounts. Customer records do not contain Last YTD fields. You can view Last YTD data in the Sales Manager reports.

Note: Running the Customer Administration Year End Report on the last day of the fiscal year is not required, however, you must run it before your first day of processing in the new fiscal year. If you require assistance, contact Infor Support Services.

Inventory year-end processing

Several inventory reports support year-end adjustments that might be required in General Ledger. Run these reports in detail, and save them as a file or email for auditing purposes:

  • Product LIFO Valuation Master List Report (if you report by LIFO)
  • Product FIFO Report (if you report by FIFO)
  • Product Warehouse Inventory Audit Report (if you report by LIFO/FIFO)
  • Product Trial Balance of Direct Orders Report
  • Product Trial Balance of Non Stock Inventory
  • Product Trial Balance of Stock Inventory
  • PD Rebates Due Trial Balance (if using rebates)
  • VA Work in Process Trial Balance (if using Value Add)
Note: Do not change the current year in SA Administrator Options-Financials-Fiscal Year if you expect to do any back-posting. The correct year is updated automatically when GL Administrator Year End Report is run.

Run the Product Administration Year End Process Report at the end of the fiscal year. Running Product Administration Year End Process Report clears these YTD balances for each warehouse product:

  • Issues
  • Receipts
  • Returns In
  • Returns Out
Note: Running the Product Administration Year End Process Report on the last day of the fiscal year is not required, however, you must run it before your first day of processing in the new fiscal year. If you require assistance, contact Infor Support Services.