Stock-taking Transactions


You can easily perform your Stock-taking Transactions on the "Stock-taking Transactions" screen, in order to compare your inventories displayed on the system with the actual inventories in your warehouses and locations. After the stock-taking document is uploaded to the system, the Stock-taking comparison screen lists the current inventory and stock-taking results in the system on the basis of inventory code. From here, you can perform “Stock-taking Deficiency” and “Stock-taking Surplus” operations for missing or excess stocks.

Route: ERP > Sales-Distribution > Shipment-Logistics > Stock-taking Transactions


The following steps are performed in order from the Stock-taking Transactions page.

  • Stock-taking Documents
  • Add Stock-taking Document
  • Combine Stock-taking Documents
  • Creating Combined Documents and Receipts
  • Reset Stock-taking
  • Stock-taking Comparison



Add Stock-taking Document (Stock-taking)

When stock-taking transactions are to be carried out, stock-taking documents are created as required by Workcube and saved in the system. The point to be noted here is that all stock movements (delivery note records, receipts, cash sales documents, etc.) for that date and that location are completed. However, after these processes are completed, stock-taking should be done, and stock-taking documents should be recorded in the system.

The stock-taking file below is arranged in the desired form (CSV) as shown on the add page and transferred to the system by selecting the relevant date and warehouse-location.

  1. Document Separator: Select the separator defined in the Document separator field. (This selection depends on whether there is a comma/semicolon between the information in your document.)
  2. Transfer Type: “Barcode”, “Inventory Code” and “Special Code” are selected from this field.
  3. Document: Add the document saved on your computer in the document area with the help of the "Browse" button.
  4. Warehouse/Location: This field is used to select which warehouse inventory the stock-taking import you made will be transferred to.
  5. Date: Specify the date when the inventory stock-taking transaction was performed by clicking the icon next to it.
  6. Additional Fields 1,2,3,4: Additional fields: It allows adding Product Spec ID, Shelf ID, and expiry date as additional columns. This information must also be written in the order of additional fields in the document to be uploaded. (Not mandatory).


Combine Stock-taking Documents

In the transaction of combining Stock-taking Documents, the documents entered for that warehouse are combined according to the warehouse and date we selected. Thanks to this page, more than one stock-taking file for a warehouse-location can be entered into the system.

Considering the possibility that there may be more than one product from the same product in each of the Stock-taking transaction/documents made at the same location, the documents will be combined after the Stock-taking transaction is completed. The user creates cumulative values for the Stock-taking documents belonging to the same location on the same date, taking into account the conditions just mentioned on the WorkCube. This is done by combining the numbers from all documents for any stock and converting them into a single value.



Combined Documents

In combined documents, the update page of the combined document opens with the "pencil" icon next to the document. This page provides the opportunity to update the combined document detail without making revisions to the stock-taking file for minor changes.



Creating Combined Documents and Receipts

Receipt must be created for cumulative values. These plugs are of 2 types. "Stock-taking Receipt" for products with more than the required number, "Material Loss Receipt" for the products whose number is less than the required number. The system lists the products with cumulative values created for that date and that location in 60 lists and creates related receipts. After the creation on a page, another 60 comes again, the created products do not come again. The process continues until there is no product left.

In the receipt creation process, the checkboxes next to the products listed are checked, and the receipt is created by selecting the Stock-taking Receipt and the Material Loss Receipt as the transaction type above.

This process adds “-” (minus) or “+” (plus) to the stock in order to equate the stocks of the products in the warehouse with the data we give in the file.

After checking the checkboxes on the combined documents page and selecting the stock-taking receipt transaction types, inventory receipts are created for all selected warehouse locations with the create inventory receipt button.




Reset Stock-taking

Afterwards, the system predicts a reset for the products that cannot be counted at that location (i.e. products that seem to exist in the system but cannot be counted because they are not in the location). This process should be done for that date and location only after the cumulative documents are created.

With the created stock-taking receipt, the stocks are reset and our system is now synchronized with the number of products in the warehouse. This process equates the stock numbers that come with the stock receipt with the system and resets the stocks of the products that are in stock but not counted in the document.




Stock-taking Comparison

The Stock-taking Comparison Report runs on combined documents. It provides the opportunity to examine the differences between the combined documents and the Available Stocks.

If you need to correct a document in any way after all operations, you can do so by undoing the same operations. The reset is undone, the receipts are deleted (you have to delete them manually), the cumulatives are deleted (the merged document lines), and only the relevant document is deleted and the new one is saved in the system and the operations are started from the beginning.

Feedback

Did you find this content helpful?
Related Contents