Transfer Price Master

Transfer Price Master

Transfer Price Master Module - User Guide

1. Introduction πŸ“

The Transfer Price Master module is used to define and manage the internal pricing of items when they are transferred between different business units, branches, or warehouses within the organization. Unlike customer-facing sales prices, transfer prices are tailored for inter-unit stock movements and internal accounting.

ℹ️

In the overall business flow:

  1. It defines the Cost Basis for inter-branch stock transfers.
  2. It tracks RSP (Retail Sale Price) and NRP (Net Realizable Price) for regulatory and valuation purposes.
  3. It ensures Marginal Consistency across different organizational units.

Typically, this module is managed by Cost Accountants and Finance Managers.


2. Getting Started with Transfer Price πŸš€

Accessing the Module

Navigate to the Transfer Price Master Index via the Inventory or Finance Setup menu.

The Index View

The index provides a searchable list of items with their current Transfer Price and the date it became effective (WEF Date).


3. Features ✨

πŸ“… Date-Versioned Pricing (WEF)

Prices are not just “set”β€”they are phased in using a With Effect From (WEF) date. This allows you to:

  • Pre-plan price changes for the next fiscal quarter.
  • Maintain a complete historical record of how prices have changed over time.
  • Ensure that old transactions aren’t affected by new price updates.

πŸ’° The Pricing Trio

For every item, you can maintain three distinct values:

  1. Transfer Price: The internal cost used for the inter-unit transaction.
  2. RSP: The maximum Retail Sale Price.
  3. NRP: Net Realizable Price, used primarily for inventory valuation and tax calculations.

πŸ“Š Bulk Excel Operations

Designed for high-volume updates, the module features a comprehensive Import/Export suite:

  • Download Model: Generates a pre-formatted Excel template (TransferPriceMstImportXl_Model.xlsx) ready for bulk entry.
  • Strict Filename Enforcement: The system strictly checks the uploaded filename. It MUST be named ImportTransferPriceMst.xlsx, otherwise the system rejects the upload with “Uploaded Excel File Name must be ImportTransferPriceMst (with extension .xlsx)”.
  • Apply From Date Picker: The import screen includes an “Apply From Date” selector that establishes the effective version date for all imported price lines.
  • Export to Excel Option Screen (/transferpricemstxloption): Rather than a static dump, the “Export To Excel” button opens a date-range filter screen (From Date and To Date) with intelligent background queueing (ReportQueuedDialog) and automated delivery of Transfer_Price_Master_Report.xlsx.
  • Error Reporting: If an import has issues, the system downloads TransferPriceMstImportXl.xlsx where each row is tagged with specific feedback (e.g., code 1 for model mismatch, code 2 for empty files, or individual row errors).

4. Related Reports πŸ“Š

  • πŸ’° Transfer Price Master Report (Transfer_Price_Master_Report.xlsx): Export date-ranged transfer prices for audit and review (accessible via Export To Excel on /transferpricemstindex).

5. Complete Flow πŸ”„

Single Entry (Manual)

  • Navigate to Transfer Price Index (/transferpricemstindex) and click “Create New”.
  • Select the item, set the Apply From Date, and enter Transfer Price, RSP, and NRP.
  • Note: The date must be later than any previously recorded price date for this item.

Bulk Import via Excel (/transferpricemstimport)

  • Click “Import” on the index page.

  • If you need the layout, click “Download Model” to get TransferPriceMstImportXl_Model.xlsx.

  • In the import screen, select the Apply From Date.

  • ⚠️
    Mandatory Upload File Name:

Ensure the spreadsheet is saved as ImportTransferPriceMst.xlsx before uploading.

Export to Excel (/transferpricemstxloption)

Transactional Application


6. Validations and Error Codes ⚠️

Validation TypeWhat is checked?Error Message / Action
Excel Upload NameUploaded file name matches requirement.“Uploaded Excel File Name must be ImportTransferPriceMst (with extension .xlsx)”
Model IntegrityColumn structure matches template.“Please upload correct model.”
Empty FileFile contains data rows.“There is no data in this file.”
Date Chronology“Apply From Date” must be later than existing pricing dates.“Apply From Date must be greater than previous WEF Date.”
Pricing FieldsTransfer Price, RSP, NRP must be positive decimal values (up to 4 decimals).Standard validation messages.

7. Best Practices / Tips πŸ’‘

  • Pre-Planning: Always upload your new fiscal year prices at least a week in advance using the WEF feature.
  • Keep the Model: Don’t change the column headers in the Download Model Excel file, as the system relies on them for mapping.
  • Audit Notes: Use the Notes field in the creation screen to document why a price was changed (e.g., “Adjusted for raw material hike”).

8. Technical Observations πŸ”

Salesmen Master