Value - Rules of the game:

Admin:

  1. Startup / Initial Setup: Create database and set tablespaces. Userid and Password.
  2. Generate a company and associate an accounting year with it. Set / Reset passwords and roles.
  3. Edit or delete transactions.

Accountant:

  1. Set or change groups (balance sheet / profit or loss)
  2. Set or change accounts
  3. Set or change Activity Groups
  4. Set or change Activity (master) file
  5. Set or change settlement codes
  6. Set or change item groups
  7. Set or change items
  8. Set or change sub ledger codes
  9. Set or change warehouses
  10. Set or change preferences
  11. Check Purchase / Sales Allocation for reconciliation

Sales / Floor Manager

  1. Set or change tax codes
  2. Set or change item section
  3. Set or change item location
  4. Set or change shops
  5. Set or change cash registers
  6. Set or change customer preferences
  7. Set or change job codes
  8. Set or change sub contractors (related to sub ledger)

Shop Warehouse

  1. Raise a purchase order
  2. Receive against purchase order
  3. Raise debit notes
  4. Auto post in Voucher
  5. Return receiving
  6. Create Item tags (SKUs) against receiving
  7. Receive goods from shops

Manufacturing warehouse

  1. Issue item against a job
  2. Returns from jobs
  3. Issue items against a job to sub contractor
  4. Receive items against a job from sub contractor

Sales

  1. Set or change customer profile
  2. Generate a sales order
  3. Raise an invoice / sales memo
  4. Auto Post in Vouchers
  5. Delivery and execution of the order depending on preferences
  6. Settle an invoice (collection)
  7. Generate Sales Returns
  8. Generate Credit Notes
  9. Generate Settlement Returns
  10. Auto Post in Vouchers

Operator

  1. Enter a voucher
  2. Cash Receipt voucher – control account Cash
  3. Cash Payment voucher – control account Cash
  4. Bank Deposit voucher – control account checking account
  5. Bank Withdrawal voucher – control account checking account, check number
  6. Sales voucher – control account receivables account
  7. Purchase voucher – control account payable account
  8. Cash to bank or vice versa voucher – control account contra account
  9. Edit a voucher

Rules:

  1. All entries must check date against the company and year. The date must lie between start and end date for the company and year
  2. All entries in Receiving, Debit Notes, Sales Memo, Credit Notes will automatically generate Vouchers
  3. All Sales and Purchase entries and Payments associated with them will be entered in Allocation table for reconciliations
  4. All amount must be >= 0. Debit or Credit, Qnty, Rate no negative numbers allowed.
  5. For all vouchers (except Journals) control account must be selected – example if withdrawal, which bank?
  6. Withdrawal authorization rules – example the operator keys in extra 2 zeroes in a withdrawal resulting in a bank overdraft. Such mistakes can only be checked through limit rules.
  7. Before posting, any transaction or any voucher, all debits must be equal to credits.
  8. Contra accounts should have zero balance – audit.
  9. No items must have negative balance
  10. No item tags must have negative balance
  11. No item tags must have sales price <= purchase price
  12. No debit note, credit note must have different item, qnty > original, different rates.

 

Resource Planning:

 

Sales and Customer Relationships

  1. Business report – Daily / YTD sales (item wise, settlement wise (may have multi currency factors), customer wise, preference wise, sales person wise, location wise, section wise, originator wise)
  2. Cumulative – Shop wise, Item wise, Settlement wise
  3. Profitability report – Daily /YTD Gross sales margins (item wise, settlement wise (may have multi currency factors), customer wise, preference wise, sales person wise, location wise, section wise, originator wise)
  4. Cost of inventory report – Item movement report
  5. Loss Report – Loss, theft, unaccountability report
  6. Delivery pending report
  7. Back order reports

 

Accounts

  1. Cash / bank balances daily / ytd
  2. Activity wise costing and variance report
  3. Allocation reconciliation
  4. Profitability report
  5. Sales / Purchase gross profitability
  6. Tax paid / due report
  7. Analysis code wise (activity) report
  8. Bank reconciliation
  9. Audit report (cash negative, contra balance, bank / credit overdraft limit exceeded)
  10. Accounts payable
  11. Accounts receivable

 

Stock

  1. Job wise analysis
  2. Sub contractor wise analysis
  3. ABC analysis
  4. Stock movement analysis
  5. Cost of warehousing report
  6. Waste report