Guide to Create New Account Book

Created by Rhizla Alexandra Poblete, Modified on Sat, 3 Aug at 10:40 AM by Rhizla Alexandra Poblete

A2000 ONLINE SUPPORT DEPARTMENT

KNOWLEDGE BASE

NEW ACCOUNT BOOK

How to create a new Account Book (from A2000ERP), with 5 months of transactions in current year?

Example: Existing Account Book : 1-Jan 2015 to 31-May 2021

New Account Book Financial Year : 1-Jan 2021 to 31-Dec 2021

ACTIONS	BY
STEP 1 - BACKUP DATABASES (Mandatory Process)
STEP 2 - CURRENT BOOK (To Close it as at 31-Dec 2020) Lock Active Date Range (all transactions) in Current Book to 31-Dec 2020 Ensure the following reports ties up: - Customer Outstanding Invoice ties to GL Debtors Account, Supplier Outstanding Invoices ties to GL Creditors Account and Stock Valuation List ties to GL Stock Account. Output all the above (a), (b) and (c) as at 31-Dec 2020 to Excel format
STEP 3 – NEW ACCOUNT BOOK (From Jan 2021 Onward) Create a New Account Book using the Account Book Tool, and label it to distinguish it from the Current Account Book. With same tool, copy all the master codes, user settings and account layouts from Current Account Book to New Account Book Enter GL Opening (GO) transaction dated 31-Dec 2020 in New Account Book Create RO (Receivables Opening), PO (Payables Opening) and IO (Stock Opening) Import RO, PO and IO from Step 2 – Item 3 (a), (b) and (c) into New Account Book Import the following tables from Current Book to New Book, for GLH, GLD, OPH, OPD, IMD, where only transactions after 1-Jan 2021 and later transactions are imported Import Sales Orders & PO Table for ALL transactions where ClearFlag = N Repost GL Transactions for ALL transactions in new Account Book Customer need to re-allocate all invoices in New Account Book. This is mandatory as all receipt allocations cannot be imported. Customer may delete un-used Product, Customer and Supplier Codes (allowed only if no prior transactions exist)
STEP 4 – VERIFICATION & UAT (To Sign-off) Ensure Trial Balance, Outstanding Customer & Supplier Invoice Listing and Stock Valuation ties between Current and New Account Book to sign-off.

*END*

Disclaimer: The information provided here is provided on an as-is basis without warranty of any kind, either expressed or implied, including warranties of merchantability and fitness for a particular purpose. In no events shall A2000 Solutions Pte Ltd or its agents, distributors and suppliers (collectively known as A2000) be liable for any damages whatsoever including direct, indirect, incidental, consequential, loss of business profits or special damages, even if A2000 have been advised of the possibility of such damages. The names of actual companies and products mentioned herein may be the trademarks of their respective owners. All third party trademarks are the property of their respective owners.