Skip to main content

KEPU Report

The KEPU is a form mandated by regulations, depicting the financial representation of goods entering, exiting, and remaining in the warehouse.

Overview​

Business Central automatically generates this form based on data from:

  • Sales Price Inventory Adjustment: Price change adjustments
  • Sales Invoices: Retail sales transactions
  • Sales Credit Memos: Returns and corrections
  • Other Documents: Related warehouse and sales documents

Accessing the KEPU Report​

To search for the report, enter KEPU Report in the search function.

Required Parameters​

Retail Location​

Enter the retail location for which you want to generate the report.

Purpose: Filters data to show only transactions for the selected retail location.

Posting Date Filter​

Filter the posting date range for the report period.

Options:

  • Single date
  • Date range (from..to)
  • Specific period (month, quarter, year)

Generating the Report​

Preview Function​

Clicking on Preview will provide access to the Book keeping Operations and Services report.

Report Contents​

The KEPU report displays:

Goods Entering​

  • Procurement documents
  • Transfers to retail location
  • Price adjustments (increases)
  • Other incoming transactions

Goods Exiting​

  • Sales invoices
  • Sales credit memos (returns)
  • Transfers from retail location
  • Other outgoing transactions

Warehouse Remainder​

  • Beginning balance
  • Ending balance
  • Quantities and values
  • Item-level details

Report Structure​

Financial Representation​

The report provides:

  • Quantity Tracking: Physical units in/out/remaining
  • Value Tracking: Financial values for all movements
  • Period Analysis: Data for the specified date range
  • Location Specific: Filtered by retail location

Compliance​

The KEPU report meets regulatory requirements for:

  • Financial reporting
  • Inventory tracking
  • Retail operations documentation
  • Audit trail maintenance

Best Practices​

Regular Generation​

  • Generate reports at regular intervals (daily, weekly, monthly)
  • Maintain consistent cutoff dates
  • Archive historical reports for reference

Data Verification​

Before generating the report:

  1. Ensure all documents are posted
  2. Verify sales price adjustments are complete
  3. Confirm no pending transactions
  4. Check date filters are correct

Report Review​

After generation:

  • Verify quantities match physical inventory
  • Confirm values align with financial records
  • Check for any unusual transactions
  • Review totals for reasonableness

Common Use Cases​

Month-End Reporting​

At month end:

  1. Post all pending documents
  2. Complete price adjustments
  3. Set date filter for the month
  4. Generate KEPU report
  5. Archive with month-end documentation

Regulatory Submissions​

For compliance:

  1. Generate report for required period
  2. Review for accuracy
  3. Include in regulatory filing
  4. Maintain for audit purposes

Internal Analysis​

For management review:

  1. Compare periods to identify trends
  2. Analyze inventory turnover
  3. Review pricing impacts
  4. Monitor location performance

Troubleshooting​

No Data Displayed​

If the report shows no data:

  • Verify retail location is selected
  • Check posting date filter range
  • Confirm transactions exist for the period
  • Ensure location is properly configured as retail

Incorrect Totals​

If totals don't match expectations:

  • Review all posted documents in the period
  • Verify price adjustments are posted
  • Check for pending or unposted documents
  • Confirm date filters are accurate

Missing Transactions​

If transactions are missing:

  • Verify document posting dates
  • Check retail location assignments
  • Review document status (posted vs. draft)
  • Confirm no filter restrictions