Skip to Content
This question has been flagged
importinventorylocationsadjustment17.
2 Replies
1927 Views
Avatar
Riccardo Branoner

Hi odoo'ers,


I am trying to import an initial stock of warehouse by performing an inventory adjustment. So far so easy. 

But additionally for several reasons I have to import initial product amounts in partners/customers location (tracking is none and by serial).


I have prepared my Excel sheets for serial imports and non-serialized product imports. But in both cases I can't manage to load initial values to partners/Customers location.


Can anybody tell me how to do that?


Thanks in advance!

Avatar
Discard
Avatar
Midhun M M
Best Answer

Why you are including customer location stock..!

Opening Stock is the amount and value of materials that a company has available for sale or use at the beginning of an accounting period.

While doing physical inventory adjustment, you can select only internal and transit locations.

Avatar
Discard
Riccardo Branoner
Author

Becuase we are tracking rented stuff. That's why we have to load equipment to the customer location in odoo while deploying the new odoo 17. Is there any chance by modifiying the domain filter from location_id in Tree View? But I guess the Importer checks the the filter conditions from model, isn't?

Midhun M M

I haven't personally tried the option you're asking about. However, we encountered a similar situation where dispatch and invoicing were completed in the old ERP system. After implementing Odoo, we faced some sales returns. To handle this, I created a new operation type named 'Sales Return' with the source location set as 'Customer' and the destination as our internal location, with the type set as 'Receipt'.
Instead of dumping all ti think this will be better. Please check.

Avatar
Jaideep
Best Answer

Inventory > Reporting > Locations

Filter the customer location and import records.


Avatar
Discard
Related Posts Replies Views Activity
Inventory Adjustment v17 import not working
import inventory adjustment odoo16features v17
Avatar
Avatar
Avatar
3
Jan 24
2037
Import QoH
import inventory products QOH adjustment
Avatar
0
Jul 16
4356
How can i import initial inventory stock via inventory adjustment.
inventory adjustment
Avatar
Avatar
Avatar
Avatar
Avatar
6
Nov 24
46562
opening stock
import inventory
Avatar
Avatar
1
Apr 25
1423
Odoo - use different production virtual locations with different GL accounts
inventory locations
Avatar
0
Jan 24
1213