How can I import an excel sheet with modified item's opening stock?
To import an excel sheet with modified item's opening stock, you need to follow these steps:
Step 1: Go to administration section then click on Data export import
Step 2: Choose import master from excel or google sheet then select from item.
Step 3: Tick on excel option then tick on modify existing masters.
Step 4: Select the required master fields and map them with excel sheet column.
Step 5: Specify the excel file path with excel sheet number and starting and ending row then click on import button.
Step 6: Opening stock can be modified in the begging financial year of company.