Stock Take as Closing Inventory (Multi Location)

Menu Path: Inventory > Stock Take > Stock Take as Closing Inventory (Multi Location)

Instead to add the "branch code" for each ID, the Stock Take as Closing Inventory (Multi Location) screen allows the user to upload the Stock Take file for multiple location/branch in the SAME CSV file for a certain Transaction Date.

After all the Stock Count of the Items for a Branch/Location has been verified. An adjustment of all the Stock for all items can be done by clicking on the “Perform Stock Adjustment” button.

By default the checkbox to “Generate Journals Due to Adjustment Out of Historical Stock and Adjustment In of Actual Stock” is unchecked.

PREPARING THE FILE

Step 1: Open New Spreadsheet File

Step 2: Fill Up Data

Column AColumn BColumn CColumn DColumn E
TEST-SERIAL-ZAM 1120.00SA Co.-B1
GADGET1 41200.00NA Co.-B1
  • Column A = Item Code
  • Column B = Quantity
  • Column C = Value
  • Column D = Make sure to Put (N)  for non serialized  or (S) for serialized item
  • Column E = Branch Code

Step 3: Save File as comma separated values (.csv) format

  • Change the Field Delimiter " | "  and text Delimiter " blank "

STOCK TAKE PROCESS

Step 4: Upload File

Menu Path: Inventory > Stock Take > Stock Take as Closing Inventory (Multi Locations)

  • Add Stock Take Session ID → add Session ID, Branch and Transaction Date

  • Select the Session ID, you would wish to process.
  • "Process" under Stock Take Listing → under Add Session ID part 

  • Generate Stock Variance Report 

Perform Stock Adjustment

  • Key in the GL code → by default is "inventoryVariance"
  • Tick the item → which need need to be adjusted
  • Tick to generate journal → if any
  • Click Perform Stock Adjustment


Steps to remove zero items value from SBR-05 : How to remove value from zero stock in SBR-05 (Non-Serialized Stock) uses the same except you change the file to multi location. 


Private & Confidential