-
|
The Financial Manager prints the "Stock Valuation By
Warehouse" report on the AS400 at the end of every month.
|
-
|
A spreadsheet is created on an Excel format and the AS400 figures
copied across to Excel. The figures are balanced in accordance
with the AS400 report and each warehouse is totaled as per
product description.
|
-
|
In the case of Demo Stock and Work in Progress (WIP), transfer
figures to the Demo column on the Excel Spreadsheet.
|
-
|
Transfer this spreadsheet’s
balances onto "Stock Adjustment" spreadsheet on excel.
(Spreadsheet shows all variances between AS400 and Pastel
Accounting System).
|
-
|
Print all the "End Stock" ledger accounts on Pastel Accounting -
Trial Balance and transfer the balances onto the "Stock
Adjustment" spreadsheet.
|
|
6. |
File journal in the journal file.
|
|
7. |
The As400 stock report is filed. |