ASN Import

This feature focuses on customizing and streamlining the process of importing ASN files. By enabling mapping between import columns and stock-related fields, users can easily handle ASN files from different vendors and update stock data efficiently.

Key Functionalities:

1. ASN Format Configuration:
   1. Define custom ASN formats using the asn.format model.
   2. Map import columns to stock-related fields dynamically using format.mapping.
2. File Import Utility:
   1. Upload ASN files in .xlsx format for processing.
   2. Validate file headers to ensure proper structure (minimum 11 columns required).
   3. Automatically match import columns to fields based on the defined mappings for the selected vendor and format.
3. Dynamic Field Mapping:
   1. Map fields using dot-separated paths, allowing users to specify relational fields.
   2. Automatically resolve and create Many2one relations if records do not exist.
4. Error Handling:
   1. Validate mapping and field paths to prevent errors during import.
   2. Provide detailed error messages for invalid field paths or missing configurations.
5. Stock Move Line Creation:
   1. Generate stock.move.line records dynamically based on the imported data.
   2. Update transfer receipts with accurate information from the ASN file.
6. Integration with Stock Picking:
   1. Trigger the import process directly from the stock.picking form using the "Import ASN" action.

Key Benefits:

Flexibility: Support for custom ASN formats and mapping configurations tailored to different vendors.

Automation: Automates the creation of stock move lines, reducing manual intervention.

Error Prevention: Validates mapping and file structure to ensure data consistency and accuracy.

Efficiency: Speeds up the process of updating transfer receipts with ASN data.

Scalability: Handles complex field paths and relational mappings seamlessly.

Example Use Case:

A logistics manager receives an ASN file from a supplier and uploads it via the "Import ASN" action in Odoo. The system uses the pre-configured mappings to match import columns to stock move fields, automatically updating the transfer receipt with accurate information. This ensures timely processing of incoming shipments without manual errors.