Project

General

Profile

Ticket no : 66112

User documentation
08/15/2024

Problem Statement
  • When saving the Tax Invoice(TI) & Sales Invoice(SI) in Web POS with the payment term set as cash, if the client has multiple branches and desires to debit a cash account other than the default, the system is not functioning as expected.

Requirement Overview

The client operates multiple branches/divisions within a company, and each branch has distinct cash ledger accounts created under the cash account to be debited for Cash Payments. Examples include "Cash in hand (Butwal)" and "Cash in hand (Kathmandu)," which should be mappable to specific divisions through the division setting.

However, in the current scenario, regardless of the branch where we issue the tax invoice, only the default "Cash in hand" account is being debited OR Users are required to manually select other cash accounts at the time of tax invoice generation, instead of the system automatically loading the appropriate cash account based on division settings.

Database Changes
  • Incorporate the column named 'CASH_AC' into the 'DIVISION' table for mapping custom cash account’s 'ACID'
  • If DIVISIONWISEACLISTING=’1’ list cash account only which are mapped to logged in division
  • If DIVISIONWISEACLISTING=’0’ list all cash account
Dependencies
  • We should consider tender cash sales invoice as well
  • Sales Vouchers and Sales Return Vouchers including reverse entry
Limitation
  • This feature can be only be useful to user’s default branch/Division
Functional Requirement
Requirement Id Requirement Statement Comment Want/ Must
FR001 Add the Field called ‘Cash Account’ in division master For Account Selection Must
FR002 After ‘Pressing Enter or Tab’ in it should pop up the cash account for the selection which are created under Web Accounting > Account Master > Assets > Current Assets> Cash For account Listing Must

UI for Reference


Definition of Done
  • Cash accounts are debited on a division-wise basis for sales, sales returns in accordance with the mapping specified in the division master.
  • Abbreviated Sales Invoice,Tax Invoice,Tax Invoice(Wholesale),Self billing and Reverse entries (It should function seamlessly in both modes, whether the bill tender mode is enabled or disabled.)
Unit Testing
  • Generate the multiple cash account for the multiple division
  • Map the cash ledger account different to each division from division master
  • Go to Tax invoice and select payment term as a cash
  • Check if the ‘account’ ledger appeared is according mapped account as in division master
  • Save the Tax invoice/ Sales Invoice SI and sales return cash account mapped in the division table should debited each time sales voucher is saved and credited at the time of return accordingly

Files

clipboard-202408151403-o0vkj.png (55.7 KB) clipboard-202408151403-o0vkj.png Sumita Gurung, 08/15/2024 08:18 AM
clipboard-202408151403-mdmei.png (62.8 KB) clipboard-202408151403-mdmei.png Sumita Gurung, 08/15/2024 08:18 AM
clipboard-202408151404-kfgvj.png (47.7 KB) clipboard-202408151404-kfgvj.png Sumita Gurung, 08/15/2024 08:19 AM
clipboard-202408151404-6t1qt.png (103 KB) clipboard-202408151404-6t1qt.png Sumita Gurung, 08/15/2024 08:19 AM
clipboard-202408151405-zdcya.png (106 KB) clipboard-202408151405-zdcya.png Sumita Gurung, 08/15/2024 08:20 AM