01
Problem
BookERP is meant to hold more than one publishing house. Phoenix Books is the pilot. Before it, titles, print quantities, and the warehouse count lived in Excel, and the warehouse count was one cell. Quotations, challans, and the cash book were other files, or paper. Accounts retyped them at month end.
Whoever saved the stock cell last replaced the number. A lower count might be a sale, a transfer, or a typing error, and the file cannot say which. The title on a bill can drift from the title that was printed. A fiscal year running Shrawan to Ashadh, with VAT split out of the total, stays in order only if nobody inserts a row. Another house would need its own copy of the workbook. The spreadsheet also had no seat for the person outside the house who admits an organization and turns its areas on.
