General Ledger Stock balances does not tally with Stock Valuation.

Richard Kwa
1616-1212-2019201920192019

Start Financial Year: 1/10/2019
Financial Value as 30/9/2019
BS Stock = 316,651.33
P&L Closing Stock = 319,754.20
Stock Valuation = 1,869,705.65

Steps:

1. Determine the Opening Values as at 1/10/2018.
    1a. Print Stock Transaction Listing with Tran Type as IO for Opening                Product Stock. General Ledger – Reports and Queries – 
          Transaction Listing – Trn Type From and To – Selection IO.
          Value reflected is 1,585,850.60.

    1b. Print General Ledger Transaction Listing with Tran Type as GO for
          GL Opening Balance. General Ledger – Reports and Queries –
          Transaction Listing – Trn Type From and To – Selection IO.
          Value is 1,596,056.67
     There is a different of 10,206.07.
     Must resolve the differences before proceeding. Note: Both values
     must be the same.

2. Check to ensure that opening only for Balance Sheet account and not Profit/Loss account.

3. Final Account Layout – set Both Opening and Closing Stock accounts under Stock



Recalculate Product Cost.
4a. Check for product with negative stock.
4b. Recalculate only those transaction related to Stock.
4c. Set “Auto Repost to GL” under User Maintenance.



5. Inventory – Operations – Recalculation Product Cost

A2000 ERP will consider chronologically all the transaction that involved and rebuild a database to reflect the amount moved with respect to time.

6.Reprint Balance Sheet, stock valuation report and verify the amount. 7. Untick the ‘Auto repost to GL’ when issue resolved.


Average rating: 0 (0 Votes)

You cannot comment on this entry