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:
- It defines the Cost Basis for inter-branch stock transfers.
- It tracks RSP (Retail Sale Price) and NRP (Net Realizable Price) for regulatory and valuation purposes.
- 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:
- Transfer Price: The internal cost used for the inter-unit transaction.
- RSP: The maximum Retail Sale Price.
- 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 DateandTo Date) with intelligent background queueing (ReportQueuedDialog) and automated delivery ofTransfer_Price_Master_Report.xlsx. - Error Reporting: If an import has issues, the system downloads
TransferPriceMstImportXl.xlsxwhere each row is tagged with specific feedback (e.g., code1for model mismatch, code2for 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.xlsxbefore uploading.- Click “Import”.
- Review the automatically downloaded
TransferPriceMstImportXl.xlsxto verify that all rows were imported successfully.
Export to Excel (
/transferpricemstxloption)- Click “Export To Excel” on the index page.
- Specify the From Date and To Date range.
- Click Print: the system either downloads
Transfer_Price_Master_Report.xlsximmediately or queues it in the background if the date range covers large data volumes.
Transactional Application
- Inter-unit delivery documents and transfer invoices automatically fetch the appropriate transfer price based on the transaction date against the versioned “Apply From Date”.
6. Validations and Error Codes β οΈ
| Validation Type | What is checked? | Error Message / Action |
|---|---|---|
| Excel Upload Name | Uploaded file name matches requirement. | “Uploaded Excel File Name must be ImportTransferPriceMst (with extension .xlsx)” |
| Model Integrity | Column structure matches template. | “Please upload correct model.” |
| Empty File | File 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 Fields | Transfer 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 π
- Precision: Prices are stored and validated up to 4 decimal places.
- File Handling: Standard CSV/Excel reading with automated cleanup of temporary S3 files.
- Soft Reference: The system uses the
ItemIdas the primary key for lookups during Excel imports.