Problem with Importing Inventory Bulk Adjustments through Excel
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Content
‎02-02-2023 01:10 PM
I've recently taken on the task of inventorying our trucks and warehouse. With all the items being counted, I made an adjustment using the import adjustment template. I then added all the items on the list and their respective quantities. Once done, I process the import to realize that some items don't get uploaded to ServiceTitan's adjustment. (Example: 427 items on Excel sheet, but only 295 items on the ServiceTitan adjustment.)
Now I investigated and noticed most of the items that are not on the list, are items that have 0 quantities on the truck. These items should be on the truck and if the adjustment imported correctly, the items the truck needs would show up under replenishment. Unfortunately that is not the case. Instead, the items that have a 0 quantity, never get a chance to get to replenishment since the get lost during the import.
Has anyone come across this problem before and found any solutions?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Content
‎02-03-2023 07:38 AM
Are the min/max counts for those items that are currently @ 0 set in your template?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Content
‎02-04-2023 06:01 AM
No they’re set to reasonable min/maxes that are spaced out enough. 5-20
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Content
‎02-02-2023 04:20 PM
Lou1368,
Do all of the items that you uploaded have (Track Inventory) on them. If not, they will not be track on the trucks or be seen on the Replenishment Tab to reorder.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Content
‎02-03-2023 05:19 AM
Yes they are tracked through inventory and on the templates as well. I've tried to upload the excel sheet another time to see if just didn't fully process, but the same problem occurred.
