| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Purchase (purchase) • Discuss (mail) |
| Lines of code | 860 |
| Technical Name |
pi_sales_purchase_register |
| License | OPL-1 |
| Website | https://primacyinfotech.com/ |
| Versions | 17.0 18.0 |
PI Sales Purchase Register
The PI Sales Purchase Register is a comprehensive Odoo Module designed to provide detailed, tabulated views of sales and purchase transactions for accounting and compliance purposes. This module bridges the gap between Odoo's standard reporting capabilities and the specific requirements of businesses needing detailed transactional registers.
- No Credit Card
- Cancel Anytime
Benefits & ROI
- Reduced Manual Work: Automates register generation (saves 4-6 hours per month)
- Fewer Errors: Eliminates manual calculation mistakes
- Faster Closing: Accelerates month-end processes by 50%
Cost Savings
- Instant Reports: Generate comprehensive reports in seconds
- Quick Filtering: Find specific transactions immediately
- Automated Totals: No manual addition required
Time Efficiency
- Real-Time Data: Always current with posted transactions
- Automatic Calculations: Eliminates human error
- Consistent Formatting: Standardized report format
Improved Accuracy
- GST Ready: Separates tax components for easy filing
- Audit Trail: Complete transaction history
- Regulatory Compliance: Meets accounting standards
Enhanced Compliance
- Trend Analysis: Identify patterns in sales/purchases
- Performance Metrics: Track key business indicators
- Strategic Insights: Data-driven business decisions
Better Decision Making
Comprehensive Reporting
- Tabulated Sales Register: Detailed line-by-line view of all sales transactions
- Tabulated Purchase Register: Complete purchase transaction breakdown
- Dual Register Access: Both registers accessible from a single module
Advanced Filtering & Grouping
- Period-Based Filtering: This Month, Last Month, This Quarter, Last Quarter, This Year, Custom Range
- Dynamic Date Selection: Automatic date calculation based on selected period
- Multi-Level Grouping: Group by vendor/buyer, invoice/bill number, date, fiscal position
Detailed Transaction Breakdown
- Individual Line Items: Each product/service line displayed separately
- Automatic Totals: Invoice/Bill totals and Grand totals calculated automatically
- Tax Segregation: Separate SGST, CGST, and IGST columns
Seamless Integration
- Direct Navigation: Click to view source invoices/bills
- Sale/Purchase Order Linking: Connects transactions to original orders
- Warehouse Integration: Shows warehouse information for each transaction
Export & Reporting
- Excel Export: Export filtered data to Excel for further analysis
- Print-Ready Format: Professional layout suitable for official reports
- Customizable Views: List view with sortable columns
For Accounting Teams
For Management
For Compliance
For Operations
Sales Register Columns
- Total Label: Identifies summary rows (Invoice Total, Grand Total)
- Invoice Date: Date of invoice posting
- Invoice No: System-generated invoice number
- SO Date: Original sales order date
- SO Number: Sales order reference
- Buyer: Customer name
- GSTN: Customer GST number
- Income Ledger Account: Revenue account used
- Warehouse: Delivery warehouse
- Item: Product/service name
- HSN: HSN/SAC code
- Quantity: Sold quantity
- UoM: Unit of measure
- Rate: Unit price
- Amount: Line total (before tax)
- SGST/CGST/IGST: Tax amounts
- Bill Amount: Final amount (including tax)
Purchase Register Columns
- Total Label: Identifies summary rows (Invoice Total, Grand Total)
- Bill Date: Date of bill posting
- Bill No.: Vendor bill number
- PO Date: Original purchase order date
- PO Number: Purchase order reference
- Vendor: Supplier name
- GSTN: Vendor GST number
- Expense Ledger Account: Expense account used
- Warehouse: Receiving warehouse
- Item: Product/service name
- HSN: HSN/SAC code
- Quantity: Purchased quantity
- UoM: Unit of measure
- Rate: Unit cost
- Amount: Line total (before tax)
- SGST/CGST/IGST: Tax amounts
- Bill Amount: Final amount (including tax)
Advanced Features
- Use the search bar to find specific transactions
- Apply filters by clicking on column headers
- Group data using the "Group By" options
- Click the "Export" button to download Excel files
- Select specific columns for export
- Choose between "Export All" or "Export Selected
- Click "View Invoice" or "View Bill" buttons to see original documents
- Navigate to related sale/purchase orders
- Access customer/vendor details
Filtering & Searching
Exporting Data
Drilling Down
Frequently Asked Question
Q What is the PI Sales Purchase Register module?
A The PI Sales Purchase Register is an Odoo module that provides detailed, tabulated sales and purchase registers for accounting, compliance, and management reporting.
Q How is this different from Odoo’s standard reports?
A Unlike standard Odoo reports, this module gives line-by-line transaction details, advanced filtering options, separate GST breakdown (SGST, CGST, IGST), HSN integration, and direct drill-down to invoices and bills.
Q Who can benefit from using this module?
A The module is designed for accountants, finance teams, business owners, compliance officers, and operations managers in SMEs, trading, manufacturing, and service companies.
Q Does it support GST and statutory compliance?
AYes, the module is fully GST-ready, provides separate tax columns, integrates HSN codes automatically, and maintains a clear audit trail for compliance and regulatory audits.
Q Can I export the reports?
AAbsolutely. Reports can be exported in Excel format, printed in a professional layout, and customized with filters and groupings for detailed analysis.
Q Is any additional configuration required after installation?
ANo, the module works out-of-the-box with your existing Odoo setup. Once installed, you can start generating sales and purchase registers immediately.
PI Sales Purchase Register Odoo Screenshots
Dashboard
Sales Register
Sales Register Report
Purchase Register
Purchase Register Report
We provide FREE 15 days of support for any doubts, queries, or bug fixes related to this module (excluding data recovery). This support covers assistance with usage, troubleshooting, and resolving issues directly connected to the module.
WATCH DEMO
OUR ODOO ERP DEVELOPMENT
SERVICES
Odoo Customization
We will fullfill your business Needs with our expertise!
Odoo Implementation
We understand your business Requirements! We customize the each module to implement it in the way you want!
Odoo Integration
We offer out of the box solution to Integrate Odoo with 3rd party application!
Odoo Migration
We provide data and code Migration from your legacy system!
Odoo Support and Maintenance
We provide 24 X7 bug fixes and issue Resolving and version upgrade!
Consulting Services
Odoo provides sales management, CRM, HRMS, E-commerce, warehouse management, and accounting.
Licencing Consultation
We provide 24 X7 bug fixes and issue Resolving and version upgrade!
Hosting
We provide 24 X7 bug fixes and issue Resolving and version upgrade!
For Free Demo
PI Sales Purchase Register
For Free Consultant
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module