If we are not using finace posting from GRN and GIN then we can update closing stock in ERP as follows.
Please see below document using any strategicerp.com email id:
https://docs.google.com/spreadsheets/d/1G8a3-u6CvgINkEg1TcjLskBQdhwqCSg9ZD19fl0xRBs/edit?usp=sharing
|
STOCK ADJUSTMENTS : |
|||
|
A. Year 2014-15 |
|||
| Particulars | Amount | ||
| Opening Stock | 2,00,000.00 | ||
| Closing Stock | 1,50,000.00 | ||
| ` | |||
| Steps : | |||
| 1 | Create Groups From Accounts Group : | ||
| Group Name | Parent Group | Account Head | |
| Say, a. | Opening Stock | - | Trading Account |
| b. | Closing Stock | - | Trading Account |
| c. | Stock In Hand | - | Balance Sheet |
| 2 | Create Ledger From Ledger Accounts | ||
| Ledger | Group Name | ||
| Say, a. | Opening Stock Ledger | Opening Stock | |
| b. | Stock In Hand Ledger | Stock In Hand | |
| c. | Closing Stock Ledger | Closing Stock | |
| 3 | Opening Stock : | ||
| 3A. | Use Opening Form For Opening Balance : | ||
| Field Name | Data | ||
| Last FY Closing Date : | 31/03/2014 | ||
| Ledger : | Stock In Hand | ||
| Last FY Closing Amount : | 2,00,000.00 | ||
| 3B. |
Journal Voucher : Pass the below JV on 01/04/2014 |
||
| Opening Stock ….……...Dr. | 2,00,000.00 | ||
| To Stock In Hand | 2,00,000.00 | ||
| 4 | Closing Stock | ||
| Pass the below JV on 31/03/2015 | |||
| Stock In Hand ……………..Dr. | 1,50,000.00 | ||
| To. Closing Stock | 1,50.000.00 | ||
|
B. Year 2015-16 : |
|||
| Pass the below JV on 01/04/2015 | |||
| Opening Stock……….. …. Dr. | 1,50,000.00 | ||
| To Stock In Hand | 1,50,000.00 | ||
