DESKTOP EDITION CLOUD EDITION SERVER EDITION GUIDES FORUM

Export / Import Inventory Write-offs


#1

It would be great if Manager could let me export Inventory Write-Offs - with a CSV file of the
Inventory Item Code, Inventory Item Name, Inventory Item Description and Qty’s.

Also, an importing feature for Inventory Write-Offs would be great.


#2

This is a bit difficult because one inventory write-off can contain multiple inventory items.

As for exporting, custom reports will be able to provide for this functionality.

As for importing, not sure if there will be a solution other than via Manager API. What is your use-case for importing?


#3

My use-case for importing is when lots of little items (say, 30) are consumed for prototyping, and the “Inventory Write-offs” function lets me account for them under an expense account titled “Goods used for R&D / Prototyping”.


#4

I see. But you have to enter the list of items you are writing-off anyway. So why entering items to Excel and then trying to import to Manager. Wouldn’t be easier to enter the transaction directly to Manager in the first place?


#5

True, though I also have to enter them into a (seperate) spreadsheet other balances.
With this in mind, I’ll look into making the (first) entries into Manager, then exporting them from the Custom Reports you mentioned on your Oct 24 6:55am post.

Saying that though, it would still be great if I could “plug-in” the data into Manager using the following steps:

  1. From the Inventory write-off screen, I click on a button called “Import Data”
  2. It gives a blank multi-line text input section, for CSV data, which I paste into (eg. stockcode-tab-qty)
  3. I click next
  4. It shows me how it interprets the data
  5. I click confirm to confirm that that’s how the data is meant to be interpreted.

How can I produce a report which will list Inventory Items booked out to a specific Inventory Write-off Description?

Cheers champ :wink: