YEAR END INVENTORY 1

[johnny45]

We just finished our year end physical count of inventory.
We have the coount information in an excel spreadsheet.....

Is it possible to import these counts into accpac 5.5?
Would I import here:
I/C : Physical Inventory Quantities ?

 

[Jay Converse]

Yes.

 

[johnny45]

Thank you tuba2007.

I exported the file from I/C : Physical Inventory Quantities...

Excel workbook worksheets:
sheet:Inventory_Worksheet_Headers
columns:LOCATION-SORTCODE-ITEMNO-QTYCOUNTED
ACTION:UPDATE QTYCONTED coloumn

sheet:Inventory_Worksheet_Details
columns:LOCATION-SORTCODE-ITEMNO-UNIT-QTYCOUNTED
ACTION:UPDATE QTYCONTED coloumn

sheet:Inventory_Worksheet
columns:LOCATION-POSTTYPE
ACTION:NONE (one record exported will keep no change?)

sheet:Worksheet_Detail_Optional_Field
columns:LOCATION-SORTCODE-ITEMNO-OPTFIELD
ACTION:NONE (no records were part of export)

sheet:Worksheet_Optional_Fields
columns:LOCATION-OPTFIELD
ACTION:NONE (no records were part of export)


As I do not want to import irreversible mistakes...