5.4.1 Stock In

Overview

This module is used if you want to set up

1. Beginning balances of your item(s).
2. if a Customer wants to return an item he/she purchased e.g., an item is damaged, this module helps manage those Customer Returns as well.
3. Make Adjustments in the Inventory

Stock In List

• List of all the SI(Stock In) and will also show the overview of the transaction.
• Here, the user also has the filter functionality and the button to add new Stock In.

Stock In Detail

1. To add new Stock In detail,go to Extra-ordinary Activities then click Stock In. After that, click the Add that can be seen in the Stock In list.

2. Fill out all the needed information for the Stock In Detail like,

• IN Date
• Document Reference
• Account
• Article

3. To add Stock In line item(s), you can:

• Manual add a line item

1. Click the Add button under the Items tab.

2. Click the Pick button that you want to add.

3. Fill up the necessary field for adding the item for Stock In such as Quantity and its Cost.

4. Click Save button to Save the item as a Stock In line item.

5. If you wish to add another item, just repeat Steps 2 to 4.
6. Click the Close button to close the popup and review your Stock In detail.

7.  After filling up the important fields, Save and lock the record. The Save button allows you to save the Stock In detail you created and it does not affect the inventory yet. If you want to have an effect in your inventory (increase the item’s quantity), click the Lock button.

Bulk Upload Line item(s)

1. Click on the Functions button then click on the Download File Format to download the template for bulk uploading Stock In line item(s).

2. Open the downloaded file then provide correct data. File name of the downloaded file is Stock in Item Format.  

Please see sample:

3. Save the file.
4. Go back to the system, then click again the Functions button then click the Upload Items.

5. Locate the file then you can double click the file to upload.
6. Once bulk uploading is successful, you will see a success toast message and the Stock In line item will automatically be supplied with data from the template.

7. Review the details and if everything is okay, Save and lock the record. The Save button allows you to save the Stock In detail you created and it does not affect the inventory yet. If you want to have an effect in your inventory (increase the item’s quantity), click the Lock button.

Customer Return via Stock In

Diagram:

Steps on how to do Customer Return via Stock In:

1. Go to Dashboard, then select the Inventory tab.

2. Scroll down and look for the Stock In menu.

3. Click the menu, you will be redirected to the Stock In list.
4. From the Stock In list, click the Add button to add new Stock In detail to be used for Customer Return.

5. After clicking the Add button, you will be redirected to the Stock In detail page. There’s no need to input for the Stock In headers, just simply click the Functions button, then select the Customer Return menu.

6. After clicking the Customer Return, a Pick Sales Invoice popup will display.

7. To quickly find the Sales Invoice number based on the Customer, look for the Customer column.

8. Select the filter icon, and input the Customer name.

9. Once the Customer name is found, click the Apply button.

10. It will now display the list of Sales Invoice based on the selected Customer.
11. Now, look for the Sales Invoice number then click the Pick button. Take note: Once you’ve already picked a Sales Invoice, you can’t do another Customer Return for that same  Stock In. If you need to do another Customer Return, you’ll have to create a new Stock In detail instead.

12. Once picked, the Stock In header is automatically populated like:

1. Document Reference → Sales Invoice’s Number
2. Account → default Account for Customer Return (Sales Returns)
3. Article → Customer Name

13. Under the Stock In line items, delete the item  that is not included on the return.

14. For the remaining item (item that is returned by the Customer), click the Edit button to edit the quantity being returned. Make sure, it will not exceed the quantity being purchased by the Customer.

15. Once okay, click the Save button to save the changes for the quantity.

16. Once everything is okay, click the Save and Lock button to save and lock the Stock In detail.
17. After that, click again the Functions button, then select the Create Credit Memo.

18. You will be redirected to the Credit Memo Detail page.

19. Review everything especially the Customer tagged and the Total Amount.

20. Once everything is okay, click the Save button.

21. After clicking the Save button, click the Lock button to make some changes on the system.