inventory physical count

[marycaruso]

Is it possoble to upload from Excel the physical count of inventory items into the qty on hand? Do you load them as transactions?

[dringstrom]

What I would do is determine the difference between the physical count and the item quantities on hand, then import item adjustments for those items where differences exist. This can be done from Excel, although it does require knowledge of how to structure an item adjustment import file. One solution is to analyze an exported file from the sample company. Another is to outsource the project.