Sales Module
The Sales Module manages the complete sales lifecycle โ from opening the shop each day through sales orders, invoicing, delivery, returns, receipts, currency exchange, commission payments, and end-of-day shop closure.
About This Module
The Sales Module covers all day-to-day sales operations. Every sales day begins with a Shop Open and ends with a Shop Close. In between, the module handles the full range of customer-facing and financial transactions.
| # | Transaction | Purpose |
|---|---|---|
| 01 | Shop Open | Open the shop for the day before any sales can be processed |
| 02 | Sales Order / Proforma | Raise a sales order or proforma invoice for a customer |
| 03 | Sales Invoice (Facture) | Issue a tax invoice for goods sold to the customer |
| 04 | Provisional Invoice | Issue a provisional/advance invoice with loyalty point tracking |
| 05 | Delivery Note | Record physical delivery of goods to the customer |
| 06 | Sales Return | Process customer return against a linked sales invoice |
| 07 | Sales Return (Direct) | Process return without a linked invoice |
| 08 | Sales Receipt / Return | Record cash payment received against an invoice |
| 09 | Receipt / Payment (Shop) | Record shop-level cash receipts and payments |
| 10 | Currency Exchange | Record currency exchange transactions at the shop |
| 11 | Commission Payment | Process sales commission payments to sales persons |
| 12 | Shop Close | Close the shop at end of day and reconcile cash |
Sales Day Flow
The standard daily sales workflow is shown below. Optional paths (Proforma, Provisional Invoice, Delivery Note, Returns) are shown as alternate branches.
- Direct Path โ Goods are immediately available: raise a Sales Invoice (Facture). If cash sale, collect payment using the Sales Receipt screen (invoice is also printed from the receipt screen). If credit sale, no receipt is needed.
- Provisional Path โ Goods are not yet ready: raise a Provisional Invoice first, then raise a Delivery Note against the Provisional Invoice (PSI No) when goods are ready. Receipt is collected the same way โ cash or credit.
- Collect cash against a Sales Invoice or Provisional Invoice (cash sales only)
- Print the invoice โ the invoice is printed from the Receipt screen for cash transactions
- Refund money to the customer when a Sales Return is processed
Sales Module
The Sales Module manages the complete sales cycle โ from opening the shop and raising sales orders through invoicing, delivery, returns, receipts, and daily shop closure.
All Transactions
Shop Open
Open the shop for the day before any sales transactions.
Sales Order / Proforma
Raise a sales order or proforma invoice for a customer.
Sales Invoice (Facture)
Issue a tax invoice for goods sold to the customer.
Provisional Invoice
Issue a provisional/proforma invoice for advance billing.
Delivery Note
Record physical delivery of goods to the customer.
Sales Return
Process customer return against a sales invoice.
Sales Return (Direct)
Process direct return without a linked invoice.
Sales Receipt / Return
Record cash/payment receipt against an invoice.
Receipt / Payment (Shop)
Record shop-level receipts and payments.
Currency Exchange
Record currency exchange transactions at the shop.
Commission Payment
Process sales commission payments to sales persons.
Shop Close
Close the shop at end of day and reconcile cash.
Sales Workflow
Shop Open
The Shop Open screen is used to open the shop at the start of each business day. This is the first transaction that must be completed before any sales, receipts, or other shop operations can be processed for the day.
Navigation Path
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| New | Opens a blank Shop Open form for entry |
| Save | Saves the Shop Open record and marks the shop as open for the day |
| Search | Search for existing Shop Open records by date or location |
| List View | Displays all Shop Open records in a tabular list |
| View History | Shows who created or modified this record and when |
| Field Name | Description | Required |
|---|---|---|
| Doc Date* | Date for opening the shop. Defaults to today. Click calendar to change. | Yes |
| Location* | The shop or branch being opened. Defaults to Axpert. | Yes |
| Document No* | System-generated document number assigned on save. Use … to search existing. | Auto |
| Remarks | Optional notes or remarks for this shop opening entry. | Optional |
Steps
Click New, verify Doc Date and Location, enter Remarks if needed, then click Save.
Sales Order / Proforma
The Sales Order / Proforma screen is used to raise a sales order or issue a proforma invoice to a customer before a final invoice is generated. It allows the business to confirm the customer's order, agree on pricing, and reserve stock without immediately posting accounting entries. A Sales Order or Proforma can later be converted into a Sales Invoice.
Navigation Path
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| New | Opens a blank Sales Order / Proforma form |
| Save | Saves the record to the database |
| Save and Print | Saves and opens the print dialog immediately |
| Search | Search for existing orders by date, order number, or customer |
| List View | Displays all Sales Orders and Proformas in a list |
| View History | Shows the modification history of this record |
| Cancel | Cancels the current Sales Order / Proforma |
| Re-Print | Re-prints the Sales Order or Proforma document |
| Draft | Saves as a draft without confirming โ can be edited and confirmed later |
| Field Name | Description | Required |
|---|---|---|
| Location Name* | Branch or shop raising the order. Defaults to Axpert. | Yes |
| Type* | Select order type from dropdown โ Sales Order or Proforma. | Yes |
| Order/Proforma Date* | Date of the order. Select from calendar. | Yes |
| Order/Proforma No | System-generated reference number. Use … to search existing. | Auto |
| Customer Name* | Select customer using 🔍 search button. | Yes |
| Contact No* | Customer contact number. | Yes |
| Currency* | Transaction currency โ Local or Base only. | Yes |
| Exchange Rate (To USD)* | Exchange rate if applicable. | Yes |
| Sales Person* | Select the sales person using 🔍 search. | Yes |
| Free offer Applicable | Check if free offer scheme applies to this order. | Optional |
| Tax Exempted? | Check if this customer is tax exempted. | Optional |
| Field Name | Description | Required |
|---|---|---|
| S No | Auto-incremented row number. | Auto |
| Item Name* | Select item using 🔍 search. | Yes |
| Unit* | Unit of measure โ auto-filled from item master. | Auto |
| Packsize | Pack size of the item. | Auto |
| Available Stock | Current available stock โ reference only. | Auto |
| Quantity* | Quantity being ordered. | Yes |
| Price USD | Item price in USD โ reference. | Auto |
| Price* | Selling price per unit in transaction currency. | Yes |
| Gross Amount | Qty ร Price โ auto-calculated. | Auto |
| Discount (%) | Discount percentage. | Optional |
| Discount Amount | Calculated discount โ auto-filled. | Auto |
| Flat Discount | Flat amount discount. | Optional |
| Net Amount | Final line amount after discounts โ auto-calculated. | Auto |
| Field Name | Description | Required |
|---|---|---|
| Total Qty | Sum of all ordered quantities. | Auto |
| Total Gross Amount | Total before discounts. | Auto |
| Total Discount | Total discount amount. | Auto |
| Flat Discount Type | Type of flat discount applied. | Optional |
| Flat Discount (%) | Flat discount percentage. | Optional |
| Flat Discount Amount | Flat discount value โ auto-calculated. | Auto |
| Total Tax Amount | Total tax. | Auto |
| Total Round Off | Rounding adjustment. | Auto |
| Net Amount (USD) | Net amount in USD. | Auto |
| Net Amount (CDF) | Net amount in CDF. | Auto |
| Narration | Free text narration for this order. | Optional |
Step-by-Step Guide
Click New. A blank Sales Order / Proforma form opens with Location pre-filled.
Choose Type โ Sales Order or Proforma โ from the dropdown.
Enter the Order/Proforma Date using the calendar icon.
Click the 🔍 search button next to Customer Name and select the customer.
Enter Contact No. Select Currency and enter Exchange Rate (To USD) if applicable.
Click 🔍 next to Sales Person and select the sales person for this order.
In the Item Particulars grid, click 🔍 on the Item Name column and select the item. Enter Quantity and Price. Apply Discount if applicable.
Press Enter or Tab to add the next row. Repeat for all items in the order.
Verify Total Gross Amount, Total Discount, and Net Amount in the footer before saving.
Click Save to confirm the order, or Draft to save for later review. Use Save and Print to immediately print the Proforma for the customer.
Sales Invoice (Facture)
The Sales Invoice (Facture) is the primary billing document issued to a customer for goods sold. It is used when goods are immediately available for delivery at the time of invoicing. Saving a Sales Invoice posts the revenue and customer receivable accounting entries. For cash sales, the invoice is printed via the Sales Receipt screen.
When to Use Sales Invoice (Facture)
- Goods are physically available in stock at the time of sale
- Customer is buying over the counter or goods are ready to hand over immediately
- Cash sale โ customer pays at point of sale (use Receipt screen to collect payment and print)
- Credit sale โ goods handed over but payment due later (no Receipt needed)
Navigation Path
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| New | Opens a blank Sales Invoice (Facture) form |
| Save | Saves the invoice and posts the accounting entries |
| Save and Print | Saves and opens the print dialog |
| Search | Search for existing invoices by date, invoice number, or customer |
| List View | Displays all Sales Invoices in a list |
| View History | Shows the modification history of this record |
| Voucher Details | Displays the accounting journal entries (Dr/Cr) posted for this invoice |
| Print Facture | Prints the tax invoice (Facture) document for the customer |
| Print Delivery | Prints the delivery note document from the same invoice |
| Draft | Saves as a draft for review before confirming |
| Field Name | Description | Required |
|---|---|---|
| Location Name* | Branch or shop issuing the invoice. Defaults to Axpert. | Yes |
| Type* | Invoice type โ e.g., DIRECT. | Yes |
| Order/Proforma Date* | Date of the related order/proforma. | Yes |
| Invoice No | System-generated invoice number. Use … to search. | Auto |
| Sales Type* | Select sales type from dropdown. | Yes |
| Nom De Client* | Customer name โ select using 🔍 search. | Yes |
| SO/Proforma No. | Linked Sales Order or Proforma number. | Optional |
| Contact No* | Customer contact number. | Yes |
| Currency* | Transaction currency โ Local or Base only. | Yes |
| Exchange Rate (To USD)* | Exchange rate if applicable. | Yes |
| Sales Person (Delegue)* | Select sales person using 🔍 search. | Yes |
| Credit Limit | Customer credit limit โ auto-filled, read-only. | Auto |
| Creditdays | Customer credit days โ auto-filled. | Auto |
| Customer Outstanding $ | Customer outstanding balance โ auto-filled. | Auto |
| Additional Price % | Additional price loading percentage. | Optional |
| Agent Commission? | Check if agent commission applies. | Optional |
| Free offer? | Check if free offer is applicable. | Optional |
| Print in USD? | Check to print the invoice in USD. | Optional |
| Field Name | Description | Required |
|---|---|---|
| S No | Auto-incremented row number. | Auto |
| Item Name* | Select item using 🔍 search. | Yes |
| Unit* | Unit of measure. | Auto |
| Packsize | Pack size. | Auto |
| Reserved Stock | Stock reserved for pending orders. | Auto |
| Current Stock | Current available stock. | Auto |
| Batch No* | Select batch number from dropdown. | Yes |
| Batch Stock | Stock in selected batch. | Auto |
| Quantity* | Quantity being sold. | Yes |
| Price USD | Price in USD โ reference. | Auto |
| Price* | Selling price per unit. | Yes |
| Gross Amount | Qty ร Price โ auto-calculated. | Auto |
| Discount (%) | Discount percentage. | Optional |
| Discount Amount | Calculated discount. | Auto |
| Flat Discount | Flat discount amount. | Optional |
| Field Name | Description | Required |
|---|---|---|
| Total Qty | Total quantity invoiced. | Auto |
| Total Grossamount | Total before discount and tax. | Auto |
| Total Discount | Total discount. | Auto |
| Flat Discount Type | Type of flat discount. | Optional |
| Flat Discount (%) | Flat discount percentage. | Optional |
| Flat Discount Amount | Flat discount value. | Auto |
| Total Tax Amount | Total tax. | Auto |
| Net Amount | Net before round off. | Auto |
| Net Amount (USD) | Net in USD. | Auto |
| Net Amount (CDF) | Net in CDF. | Auto |
| Total Round Off (CDF) | Rounding in CDF. | Auto |
| Payable Amount | Amount payable by customer. | Auto |
| Payable F.C | Payable in foreign currency. | Auto |
| Payable $ | Payable in USD. | Auto |
| Narration | Free text narration. | Optional |
Step-by-Step Guide
Click New. A blank Sales Invoice form opens with Location pre-filled.
Select Type (e.g., DIRECT) and set the Order/Proforma Date.
Click 🔍 next to Nom De Client and select the customer. Credit Limit, Credit Days, and Outstanding balance auto-fill.
Enter Contact No, select Currency, enter exchange rate, and select Sales Person (Delegue).
If this invoice is against an existing Sales Order, select it in the SO/Proforma No. dropdown.
In the grid, select Item Name, confirm Unit and Packsize, select Batch No, enter Quantity and Price. Apply discount if applicable.
Press Enter to add new rows. Repeat for all items.
Verify Gross Amount, Discount, Tax Amount, Net Amount, and Payable Amount before saving.
Click Voucher Details to preview accounting entries before posting.
Click Save to post the invoice. For cash sales, go to Sales Receipt screen to collect payment and print the invoice.
- Before: Sales Order / Proforma โ raise a proforma before converting to invoice
- After (cash): Sales Receipt / Return โ collect payment and print the invoice
- After (return): Sales Return โ process customer returns against this invoice
- Alternative: Provisional Invoice โ use when goods are not yet ready for delivery
Provisional Invoice
The Provisional Invoice is used when a customer is billed in advance but the goods are not yet ready for delivery. The invoice is raised and accounting entries are posted, but physical goods are dispatched later via a Delivery Note raised against this Provisional Invoice (using the PSI No field). This is the correct workflow when payment or invoicing happens before stock is ready.
When to Use Provisional Invoice
- Customer is billed or pays in advance but goods are not yet ready for delivery
- Invoice needs to be raised today but stock will be dispatched on a later date
- Customer requires an invoice for advance payment processing
- Always follow up with a Delivery Note (PSI No) once goods are ready
Navigation Path
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| New | Opens a blank Provisional Invoice form |
| Save | Saves the Provisional Invoice and posts accounting entries |
| Save and Print | Saves and opens the print dialog |
| Search | Search for existing Provisional Invoices |
| List View | Displays all Provisional Invoices in a list |
| View History | Shows the modification history of this record |
| Voucher Details | Displays the accounting journal entries for this invoice |
| Re-print | Re-prints a previously saved Provisional Invoice |
| Cancel | Cancels the Provisional Invoice |
| Draft | Saves as a draft without confirming |
| Field Name | Description | Required |
|---|---|---|
| Location Name* | Branch issuing the provisional invoice. Defaults to Axpert. | Yes |
| Order/Proforma Date* | Date of the provisional invoice. | Yes |
| Invoice No | System-generated invoice number. Use … to search. | Auto |
| Sales Type* | Select sales type from dropdown. | Yes |
| Customer Name* | Select customer using 🔍 search. | Yes |
| Sales Person* | Select sales person using 🔍 search. | Yes |
| Contact No* | Customer contact number. | Yes |
| Currency* | Transaction currency. | Yes |
| Exchange Rate (To USD)* | Exchange rate if applicable. | Yes |
| Free Offer? | Check if free offer applies. | Optional |
| Print in USD? | Check to print in USD. | Optional |
| Credit Limit | Customer credit limit โ auto-filled. | Auto |
| Creditdays | Customer credit days โ auto-filled. | Auto |
| Customer Outstanding $ | Customer outstanding balance โ auto-filled. | Auto |
| Field Name | Description | Required |
|---|---|---|
| S No | Auto-incremented row number. | Auto |
| Item Name* | Select item using 🔍 search. | Yes |
| Unit* | Unit of measure. | Auto |
| Packsize | Pack size. | Auto |
| Current Stock | Current available stock. | Auto |
| Reserved Stock | Stock reserved for pending orders. | Auto |
| Quantity* | Quantity. | Yes |
| Price USD | Price in USD. | Auto |
| Price* | Selling price. | Yes |
| Gross Amount | Qty ร Price. | Auto |
| Discount(%) | Discount percentage. | Optional |
| Discount Amount | Calculated discount. | Auto |
| Flat Discount | Flat discount. | Optional |
| Net Amount | Net line amount. | Auto |
| Field Name | Description | Required |
|---|---|---|
| Total Qty | Total quantity. | Auto |
| Total Grossamount | Total before discount/tax. | Auto |
| Total Discount | Total discount. | Auto |
| Flat Discount Type / (%) / Amount | Flat discount fields. | Optional |
| Total Tax Amount | Total tax. | Auto |
| Net Amount / (USD) / (CDF) | Net amounts in respective currencies. | Auto |
| Total Loyalty Points | Loyalty points earned. | Auto |
| Redemptionpoints | Loyalty points redeemed. | Auto |
| Value/Points (in USD) | Value of redeemed points. | Auto |
| Redemption Value | Cash value of redemption. | Auto |
| Payableamount | Total payable amount. | Auto |
| Total Round Off (CDF) | Rounding in CDF. | Auto |
| Payable Amount (CDF) / (USD) | Payable in each currency. | Auto |
| Remarks | Free text remarks. | Optional |
Step-by-Step Guide
Click New. A blank Provisional Invoice form opens.
Enter the Order/Proforma Date using the calendar.
Select Sales Type, then click 🔍 next to Customer Name to select the customer.
Click 🔍 next to Sales Person and select.
Enter Contact No, select Currency, and enter the exchange rate.
In the grid, select Item Name, enter Quantity and Price. Apply discount if applicable.
Press Enter to add new rows for each item.
Verify Net Amount, Payable Amount (CDF) and Payable Amount (USD) before saving.
Click Save. A Provisional Invoice number is assigned. When goods are ready, raise a Delivery Note using this invoice's number in the PSI No field.
- Next step: Delivery Note โ raise against this Provisional Invoice (PSI No) when goods are ready
- After (cash): Sales Receipt / Return โ collect payment against this invoice
- After (return): Sales Return โ process customer returns against this invoice
Delivery Note
The Delivery Note is used to record the physical dispatch of goods to a customer. It is always raised against a Provisional Invoice โ the PSI No field links this delivery to the original invoice. The Delivery Note deducts stock and confirms that the goods billed in the Provisional Invoice have been physically handed over to the customer.
When to Use Delivery Note
- A Provisional Invoice has already been raised and goods are now ready to dispatch
- Physical delivery of goods needs to be recorded against a prior invoice
- Customer requires a delivery challan as proof of goods received
- Never use Delivery Note without a linked Provisional Invoice (PSI No)
Navigation Path
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| New | Opens a blank Delivery Note form |
| Save | Saves the Delivery Note and updates stock |
| Save and Print | Saves and opens the print dialog |
| Search | Search for existing Delivery Notes by date, document number, or customer |
| List View | Displays all Delivery Notes in a list |
| View History | Shows the modification history of this record |
| Re-Print | Re-prints a previously saved Delivery Note |
| Draft | Saves as a draft for review before confirming |
| Voucher Details | Displays the accounting journal entries posted for this Delivery Note |
| Field Name | Description | Required |
|---|---|---|
| Location Name* | Delivering location. Defaults to Axpert. | Yes |
| Document Date* | Date of delivery. Defaults to today. | Yes |
| Document No | System-generated delivery note number. | Auto |
| Customer Name* | Select customer using 🔍 search. | Yes |
| PSI No | The Provisional Invoice number against which this Delivery Note is being raised. Select from the dropdown โ only open Provisional Invoices for the selected customer will appear. This field links the delivery to the original Provisional Invoice raised at the time of billing. | Yes |
| Contact No* | Customer contact number. | Yes |
| Currency | Delivery currency. | Yes |
| Exchange Rate (To Base)* | Exchange rate to base currency. | Yes |
| Exchange Rate (To Local)* | Exchange rate to local currency โ always required. | Yes |
| Tax Exempted? | Check if customer is tax exempted. | Optional |
| Creditsales? | Check if this is a credit sale. | Optional |
| Field Name | Description | Required |
|---|---|---|
| S No | Auto-incremented. | Auto |
| Item Name* | Select item using 🔍 search. | Yes |
| Unit* | Unit of measure. | Auto |
| Packsize | Pack size. | Auto |
| Reserved Stock | Stock reserved. | Auto |
| Current Stock | Current available stock. | Auto |
| Batch No* | Select batch from dropdown. | Yes |
| Batch Stock | Stock in selected batch. | Auto |
| Balance Qty | Balance quantity available for delivery. | Auto |
| Quantity* | Quantity being delivered. | Yes |
| Field Name | Description | Required |
|---|---|---|
| Total Qty | Total delivered quantity. | Auto |
| Total Grossamount | Gross amount. | Auto |
| Total Discount | Total discount. | Auto |
| Flat Discount | Flat discount. | Optional |
| Total Tax Amount | Tax amount. | Auto |
| Net Amount / (in USD) / (in CDF) | Net amounts in currencies. | Auto |
| Redemption value | Loyalty redemption value. | Auto |
| Payable Amount / (CDF) / (USD) | Payable amounts. | Auto |
| Total Round Off | Rounding. | Auto |
| Remarks | Delivery remarks. | Optional |
Step-by-Step Guide
Click New. A blank Delivery Note form opens with Location and Document Date pre-filled.
Click 🔍 next to Customer Name and select the customer.
In the PSI No dropdown, select the Provisional Invoice against which goods are being delivered. This is mandatory.
Enter Contact No, select Currency, and enter exchange rates.
Check Creditsales? if goods are being delivered on credit.
In the grid, select Item Name, select Batch No, verify Balance Qty, and enter the Quantity being delivered.
Repeat for all items being delivered in this note.
Verify Total Qty, Net Amount, and Payable amounts before saving.
Click Save to record the delivery and deduct stock. Use Save and Print to print the delivery challan for the customer to sign.
- Prerequisite: Provisional Invoice โ must exist before a Delivery Note can be raised
- After: Sales Return โ if customer returns goods delivered via this note
Sales Return
The Sales Return screen is used to process returns from customers for goods sold through a Sales Invoice or Provisional Invoice. The return must be linked to the original invoice via the Invoice No field. Saving a Sales Return reverses the stock deduction, reduces the customer receivable, and if applicable, processes a cash refund through the Sales Receipt screen.
When to Use Sales Return (vs Direct Return)
- Customer returns goods and the original invoice is available in the system
- Goods were sold via Sales Invoice (Facture) or Provisional Invoice
- Return needs to be tracked against a specific invoice for audit purposes
- Use Sales Return (Direct) instead when no linked invoice can be identified
Navigation Path
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| New | Opens a blank Sales Return form |
| Save | Saves the Sales Return and reverses stock and accounting entries |
| Save and Print | Saves and opens the print dialog |
| Exports the Sales Return document as a PDF file | |
| Search | Search for existing Sales Return records |
| List View | Displays all Sales Returns in a list |
| View History | Shows the modification history of this record |
| Re-Print | Re-prints a previously saved Sales Return document |
| Draft | Saves as a draft for review before confirming |
| Voucher Details | Displays the reversal accounting journal entries for this return |
| Field Name | Description | Required |
|---|---|---|
| Location* | Location receiving the return. Defaults to Axpert. | Yes |
| Document Date | Date of return. | Yes |
| Return No | System-generated return number. Use … to search. | Auto |
| Return Based On* | Select the basis for return โ Invoice or Delivery Note. | Yes |
| Invoice No* | Select the original invoice from dropdown. | Yes |
| Invoice Date | Date of original invoice โ auto-filled. | Auto |
| Currency | Currency of original transaction โ auto-filled. | Auto |
| Exchange Rate (to Base) | Exchange rate โ auto-filled. | Auto |
| Customer Name | Customer name โ auto-filled from invoice. | Auto |
| Mobile No | Customer mobile number. | Optional |
| Address | Customer address โ auto-filled. | Auto |
| Credit Sales | Check if original was a credit sale. | Optional |
| Print in USD? | Check to print return document in USD. | Optional |
| Loyaltycard | Customer loyalty card number. | Optional |
| Available Points | Loyalty points available. | Auto |
| Field Name | Description | Required |
|---|---|---|
| S No | Auto-incremented. | Auto |
| Item | Item being returned โ select from dropdown. | Yes |
| Unit | Unit of measure โ auto-filled. | Auto |
| Packsize | Pack size. | Auto |
| Balance Qty | Quantity available for return from original invoice. | Auto |
| Batch* | Batch number of goods being returned โ select from dropdown. | Yes |
| Qty* | Quantity being returned. | Yes |
| Price | Original selling price โ auto-filled. | Auto |
| Gross Amount | Return value โ auto-calculated. | Auto |
| Discount Amount | Discount on return. | Auto |
| Net Amount | Net return amount. | Auto |
| Field Name | Description | Required |
|---|---|---|
| Total Paid Qty | Total return quantity. | Auto |
| Total Free Qty | Free items being returned. | Auto |
| Total Gross Amount | Total return value. | Auto |
| Total Discount | Total discount. | Auto |
| Total Tax Amount | Tax reversed. | Auto |
| Round Off | Rounding. | Auto |
| Net Amount / (USD) / (CDF) | Net return amounts. | Auto |
| Total Loyalty Points | Loyalty points reversed. | Auto |
| Narration* | Reason for return โ mandatory. | Yes |
Step-by-Step Guide
Click New. A blank Sales Return form opens with Location pre-filled.
Click 🔍 next to Supplier โ wait, this is Sales Return. Select the Return Based On type โ Invoice or Delivery Note.
Select Return Based On (Invoice or Delivery Note), then select the original Invoice No from the dropdown. Currency and customer details auto-fill.
Confirm or set the Document Date for this return.
In the Item grid, select the Item from dropdown, select the Batch, review the Balance Qty, and enter the Qty being returned.
Repeat for all items being returned.
Fill the mandatory Narration field with the reason for return (e.g., 'Damaged goods', 'Wrong item').
Verify Total Gross Amount, Tax Amount reversed, and Net Amount in the footer.
Click Save to process the return. Stock is re-entered and customer receivable is reduced. If a cash refund is needed, process it via the Sales Receipt / Return screen.
- Prerequisite: Sales Invoice or Provisional Invoice โ must exist to link this return
- After (cash refund): Sales Receipt / Return โ process the cash refund to customer
- Alternative: Sales Return (Direct) โ use when no linked invoice is available
Sales Return (Direct)
The Sales Return (Direct) screen is used to accept returns from customers when the original invoice cannot be identified or was not raised through the system. Unlike the standard Sales Return, this screen does not require a linked invoice โ items are returned directly with batch, supplier, and expiry details entered manually. Stock is re-entered into the system on saving.
When to Use Sales Return (Direct)
- Customer returns goods but the original invoice is not available or not in the system
- Goods were sold outside the system (e.g., old stock, branch transfers)
- Return involves items that need to be put back into stock with full batch details
- Do not use this if the original invoice exists โ use standard Sales Return instead
Navigation Path
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| New | Opens a blank Sales Return (Direct) form |
| Save | Saves the return and reverses stock and accounting entries |
| Save and Print | Saves and opens the print dialog |
| Exports the Sales Return (Direct) document as a PDF | |
| Search | Search for existing Direct Return records |
| List View | Displays all Direct Returns in a list |
| View History | Shows the modification history of this record |
| Draft | Saves as a draft for review before confirming |
| Field Name | Description | Required |
|---|---|---|
| Location* | Location receiving the return. Defaults to Axpert. | Yes |
| Document Date | Date of return. | Yes |
| Return No | System-generated return number. Use … to search. | Auto |
| Customer Name* | Select customer from dropdown. | Yes |
| Sales Person* | Select sales person using 🔍 search. | Yes |
| Invoice Date | Date of original invoice. | Optional |
| Currency* | Transaction currency. | Yes |
| Exchange Rate (to Base)* | Exchange rate to base currency. | Yes |
| Credit Sale? | Check if original was a credit sale. | Optional |
| Tax Exempted? | Check if customer is tax exempted. | Optional |
| Location Batch Flag | Enable batch location tracking. | Optional |
| Mobile No* | Customer mobile number. | Yes |
| Address* | Customer address. | Yes |
| Loyaltycard | Customer loyalty card number. | Optional |
| Available Points | Loyalty points available. | Auto |
| Field Name | Description | Required |
|---|---|---|
| S No | Auto-incremented. | Auto |
| Item* | Select item using 🔍 search. | Yes |
| Unit* | Unit of measure. | Auto |
| Packsize | Pack size. | Auto |
| Batch* | Batch number โ select from dropdown. | Yes |
| Supplier* | Select the supplier from dropdown. | Yes |
| Supplier Batchno* | Supplier batch reference number. | Yes |
| Manufacturing Date | Manufacturing date of batch. | Optional |
| Expiry Date* | Expiry date of batch. | Yes |
| Qty* | Return quantity. | Yes |
| Price* | Return price per unit. | Yes |
| Gross Amount | Auto-calculated return value. | Auto |
| Field Name | Description | Required |
|---|---|---|
| Total Qty | Total return quantity. | Auto |
| Total Free Qty | Free items returned. | Auto |
| Total Gross Amount | Total return value. | Auto |
| Total Discount | Total discount. | Auto |
| Total Tax Amount | Tax reversed. | Auto |
| Round Off | Rounding. | Auto |
| Net Amount / (USD) / (CDF) | Net amounts. | Auto |
| Total Loyaltypoints | Loyalty points reversed. | Auto |
| Notes | Free text notes for this return. | Optional |
Step-by-Step Guide
Click New. A blank Sales Return (Direct) form opens.
Select the Customer Name from the dropdown.
Click 🔍 next to Sales Person and select.
Select Currency and enter Exchange Rate (to Base).
Enter the Invoice Date if the original invoice date is known. Otherwise leave blank.
In the grid, click 🔍 on Item to select the item. Select Batch and Supplier. Enter Supplier Batchno, Manufacturing Date, and Expiry Date. Enter Qty and Price.
Repeat for all items being returned.
Fill the Notes field with the reason for direct return.
Click Save to post the return. Stock is re-entered with full batch details.
Sales Receipt / Return
- Collect cash from a customer against a Sales Invoice or Provisional Invoice. Used for cash sales only โ credit invoices do not require a receipt.
- Print the invoice โ for cash transactions, the invoice is printed directly from this screen after saving the receipt.
- Refund money back to the customer when a Sales Return has been processed โ the returned amount is given back through this screen.
Navigation Path
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| Search | Search for existing receipt records by receipt number, invoice number, or customer |
| Exports the receipt / invoice document as a PDF for printing or sharing |
| Field Name | Description | Required |
|---|---|---|
| Location | Location for which receipt is being processed. | Yes |
| Receipt No | System-generated receipt number. Use … to search. | Auto |
| Recu Taux | Exchange rate for receipt. | Yes |
| Invoice No | Select the invoice against which payment is received. | Yes |
| Type | Transaction type โ defaults to Sales Invoice. | Yes |
| Customer | Customer name โ auto-filled from invoice. | Auto |
| Taux Difference | Exchange rate difference โ auto-calculated. | Auto |
| Print in USD? | Check to print receipt in USD. | Optional |
| Field Name | Description | Required |
|---|---|---|
| CDF โ Invoice | Invoice amount in CDF. | Auto |
| CDF โ Received | Amount received in CDF โ enter actual cash collected. | Yes |
| CDF โ Returned | Change returned to customer in CDF โ auto-calculated. | Auto |
| CDF โ Balance | Remaining balance in CDF. | Auto |
| USD โ Invoice | Invoice amount in USD. | Auto |
| USD โ Received | Amount received in USD. | Yes |
| USD โ Returned | Change returned in USD. | Auto |
| USD โ Balance | Remaining balance in USD. | Auto |
Steps
Choose the customer and invoice number.
Enter the CDF and/or USD amount received from the customer.
System calculates Returned and Balance amounts automatically.
Click Save to post the receipt and update the customer payable.
- Used after: Sales Invoice (Facture) โ collect cash payment and print invoice
- Used after: Provisional Invoice โ collect advance cash payment
- Used after: Sales Return โ process cash refund to customer
Receipt / Payment (Shop)
The Sales Receipt / Return screen is used for three purposes: (1) Collect cash from a customer against a Sales Invoice or Provisional Invoice โ for cash sales only (credit invoices do not require a receipt). (2) Print the invoice โ for cash transactions, the invoice document is printed from this screen. (3) Process a cash refund to the customer after a Sales Return has been recorded.
Navigation Path
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| New | Opens a blank Receipt / Payment (Shop) form |
| Save | Saves the receipt or payment record and posts the accounting entry |
| Search | Search for existing records by date, document number, or particulars |
| List View | Displays all Receipt / Payment records in a list |
| View History | Shows the modification history of this record |
| Re-Print | Re-prints the receipt or payment document |
| Field Name | Description | Required |
|---|---|---|
| Location* | Shop location. Defaults to Axpert. | Yes |
| Date* | Transaction date. Defaults to today. | Yes |
| Document Number* | System-generated document number. | Auto |
| Receipt ~/ Payment* | Select type โ Receipt or Payment โ from dropdown. | Yes |
| Particulars* | Select the account/particulars for this transaction from dropdown. | Yes |
| Sub Ledger / Cost Center* | Select the sub-ledger or cost centre from dropdown. | Yes |
| Currency* | Transaction currency. | Yes |
| Ex Rate* | Exchange rate for the selected currency. | Yes |
| Amount* | Transaction amount in selected currency. | Yes |
| Amount ~ (CDF) | Equivalent amount in CDF โ auto-calculated. | Auto |
| Amount ~ (USD) | Equivalent amount in USD โ auto-calculated. | Auto |
| Narration* | Description or reason for this receipt or payment โ mandatory. | Yes |
| Cash Ledger | Cash ledger account โ auto-filled. | Auto |
| Balance Cash | Current cash balance โ auto-filled for reference. | Auto |
Step-by-Step Guide
Click New. A blank Receipt / Payment (Shop) form opens with Location and Date pre-filled.
In Receipt ~/ Payment dropdown, select Receipt if money is coming in, or Payment if money is going out.
Choose the account / purpose from the Particulars dropdown.
Choose the appropriate sub-ledger or cost centre.
Select the Currency and enter the Ex Rate. The CDF and USD equivalent amounts will auto-calculate.
Enter the transaction Amount in the selected currency.
Fill the mandatory Narration field describing the purpose of this receipt or payment.
Click Save to post the entry. Cash Ledger balance updates automatically.
Currency Exchange
The Receipt / Payment (Shop) screen is used to record miscellaneous cash inflows and outflows at the shop level that are not directly linked to a sales invoice. Examples include cash received from head office, petty cash payments for expenses, or inter-shop cash transfers. Every entry must specify whether it is a Receipt (money in) or Payment (money out).
Navigation Path
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| New | Opens a blank Currency Exchange form |
| Save | Saves the exchange record and posts the gain/loss accounting entries |
| Search | Search for existing Currency Exchange records |
| List View | Displays all Currency Exchange records in a list |
| Cancel | Cancels the current Currency Exchange entry |
| View History | Shows the modification history of this record |
| Field Name | Description | Required |
|---|---|---|
| Location* | Shop location. Defaults to Axpert. | Yes |
| Document Number* | System-generated document number โ e.g., 261001CE000001. | Auto |
| Currency* | Currency being exchanged โ e.g., CDF. | Yes |
| Amount Received | Amount received from customer in the selected currency. | Yes |
| Exchange Rate (CDF-System) | System exchange rate for reference โ auto-filled. | Auto |
| Exchange Rate (CDF)* | Actual exchange rate applied for this transaction โ editable. | Yes |
| Amount Given* | Amount given to the customer in the other currency after exchange. | Yes |
| Gain / Loss $ | Gain or loss in USD from the exchange โ auto-calculated. | Auto |
| Gain / Loss CDF | Gain or loss in CDF โ auto-calculated. | Auto |
| Narration | Description of the exchange transaction. | Optional |
| Date* | Date of the exchange transaction. | Yes |
| Balance Cash | Current cash balance in the shop โ auto-filled for reference. | Auto |
Step-by-Step Guide
Click New. A blank Currency Exchange form opens with Location pre-filled.
Choose the currency being exchanged (e.g., CDF) from the Currency dropdown.
The Exchange Rate (CDF-System) is auto-filled from the system configuration โ use this as a reference.
Enter the actual rate in Exchange Rate (CDF)*. This may differ from the system rate based on the transaction negotiated with the customer.
Enter the Amount Received from the customer in the selected currency.
Enter the Amount Given* to the customer in the other currency.
The system auto-calculates Gain / Loss $ and Gain / Loss CDF based on the rate difference. Review before saving.
Add a Narration describing the exchange if required.
Click Save to post the currency exchange and update cash balances.
Sales Commission Payment
The Currency Exchange screen is used to record currency exchange transactions at the shop โ for example, exchanging CDF to USD or vice versa with a customer. The screen shows the system exchange rate for reference and allows the actual exchange rate used to be entered. Any difference between the system rate and the actual rate is automatically calculated as a Gain or Loss.
Navigation Path
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| New | Opens a blank Commission Payment form |
| Save | Saves the record as a draft โ does not post to accounts |
| Approve_Save | Saves and posts the commission payment to the accounting ledger โ marks as Approved |
| Search | Search for existing Commission Payment records |
| List View | Displays all Commission Payment records in a list |
| View History | Shows the modification history of this record |
| Field Name | Description | Required |
|---|---|---|
| Location* | Location for commission payment. Defaults to Axpert. | Yes |
| Sales Person Name | Select the sales person using 🔍 search. | Yes |
| Currency* | Currency for commission payment. | Yes |
| Exchange Rate (to USD)* | Exchange rate to USD. | Yes |
| Expense Ledger | GL account for commission expense โ auto-filled. | Auto |
| Cash Ledger | Cash ledger for payment โ auto-filled. | Auto |
| Balance Cash | Current cash balance โ reference. | Auto |
| Approved? | Check box โ auto-marked when Approve_Save is used. | Auto |
| Voucher Number* | System-generated voucher number. Use … to search. | Auto |
| Voucher Date* | Date of commission payment. | Yes |
| Field Name | Description | Required |
|---|---|---|
| S No | Auto-incremented. | Auto |
| Invoice No | Invoice number for which commission is being paid. | Yes |
| Invoice Date | Date of the invoice โ enter or select from calendar. | Yes |
| Customer Name | Customer name linked to the invoice. | Yes |
| Invoice Amount Base | Invoice value in base currency. | Auto |
| Invoice Amount Local | Invoice value in local currency. | Auto |
| Amount Payable | Commission amount payable for this invoice. | Yes |
| .. | Additional action column. | Optional |
| Field Name | Description | Required |
|---|---|---|
| Total Amount | Total commission being paid โ auto-calculated. | Auto |
| Narration | Description of commission payment. | Optional |
Step-by-Step Guide
Click New. A blank Sales Commission Payment form opens with Location pre-filled.
Click 🔍 next to Sales Person Name and select the sales person.
Select Currency and enter Exchange Rate (to USD).
Enter the Voucher Date for this commission payment.
In the Discount Detail grid, enter the Invoice No, Invoice Date, Customer Name, and the Amount Payable (commission amount) for each invoice.
Repeat for all invoices on which commission is being paid.
Verify the Total Amount in the footer matches the expected commission.
Add a Narration describing the commission payment.
Click Save to save as draft for review, or click Approve_Save to confirm and post to the accounting ledger.
Shop Close
The Sales Commission Payment screen is used to record and process commission payments to sales persons based on invoices they have generated. The record is first saved as a draft and then approved using Approve_Save, which posts the commission expense to the accounting ledger. Only approved records affect the accounts.
When to Run Shop Close
- At the end of every business day โ mandatory before the next day can begin
- After all sales, returns, receipts, and currency exchanges for the day are complete
- When the physical cash in the till has been counted and verified
- If Shop Close is missed, it must be completed before the next Shop Open can be processed
Navigation Path
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| New | Opens a blank Shop Close form |
| Save | Saves the Shop Close record and posts the end-of-day accounting entries |
| Save and Print | Saves and opens the print dialog for the Shop Close summary |
| Search | Search for existing Shop Close records by date or location |
| List View | Displays all Shop Close records in a list |
| View History | Shows the modification history of this record |
| Voucher Details | Displays the accounting journal entries that will be posted on saving |
| Field Name | Description | Required |
|---|---|---|
| Doc Date* | Date of shop closure. Defaults to today. | Yes |
| Location* | Shop being closed โ select from dropdown. | Yes |
| Document No | System-generated document number. Use … to search. | Auto |
| Currency | Currency for closure โ auto-filled. | Auto |
| Exchange Rate (to CDF)* | Exchange rate to CDF โ mandatory. | Yes |
| Cash Ledger (CDF)* | CDF cash ledger account. | Yes |
| Cash Ledger (USD)* | USD cash ledger account. | Yes |
Steps
Click New, set Doc Date and Location.
The system auto-fills Opening Balance, Cash Sales, Receipts, Payments, and Exchange transactions from the day.
Enter the actual physical cash counted in Physical Cash (USD) and Physical Cash (CDF).
Go to Cash Denomination tab and enter cash count by note/coin denomination.
Check Summary tab to verify all day transactions before closing.
Click Save to close the shop. Voucher Details can be reviewed before saving.
The Shop Close screen is used to close the shop at the end of each business day. It reconciles all cash movements โ opening balance, sales, returns, receipts, payments, and currency exchanges โ and requires the store manager to enter the physical cash count. Any difference between the expected and actual cash is recorded as excess or shortage. The shop must be closed before it can be opened the next day.
Shop Close Details Tab Fields
| Field | Description |
|---|---|
| Opening Balance (USD / CDF) | Cash balance at start of day from Shop Open โ auto-filled. |
| Cash Sales (+) | Total cash sales for the day โ auto-calculated from invoices. |
| Cash Sales Return (-) | Total cash sales returns โ auto-calculated. |
| Receipt (+) | Total receipts received during the day. |
| Payment (-) | Total payments made during the day. |
| Sub Total Cash Received | Net cash position โ auto-calculated. |
| Money Exchanged (+) | Currency exchange inflows. |
| (-) | Currency exchange outflows. |
| Other Transfers/Exch. | Any other transfer or exchange amounts. |
| Closing Balance | Expected cash at close โ auto-calculated. |
| Physical Cash (USD / CDF) | Enter the actual physical cash counted at the till. |
| Difference | Closing Balance minus Physical Cash โ auto-calculated. Should be zero. |
| Cash Excess/Shortage | Any excess or shortage amount โ auto-calculated. |
| Gain / Loss (in USD) | Currency exchange gain or loss for the day. |
Other Tabs
- Cash Denomination โ Enter the physical count by denomination (notes and coins) for both USD and CDF
- Inventory Posting โ Reviews and posts end-of-day inventory adjustments
- Summary โ Shows a consolidated summary of the day's transactions for verification before closing
Customer Category
Customer Category is used to classify customers into broad groups such as Wholesale, Retail, or Institutional. Categories are used in pricing (Price Category), customer master setup, and sales reporting.
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| New | Opens a blank Customer Category form |
| Save | Saves the category record |
| Search | Search for existing categories |
| List View | Displays all categories in a list |
| View History | Shows modification history |
Fields
| Field | Description | Required |
|---|---|---|
| Category Name* | The name of the customer category (e.g., WHOLESALE, RETAIL, INSTITUTIONAL). This appears in the Customer master Category dropdown. | Yes |
| Code* | A short code for the category (e.g., WH for Wholesale). Used for reference and reporting. | Yes |
Step-by-Step Guide
Open a blank Customer Category form.
Type a descriptive category name (e.g., WHOLESALE, RETAIL).
Enter a short unique code for the category (e.g., WH, RE).
Click Save to store the category. It will now appear in the Category dropdown in the Customer master.
Customer Group
Customer Group is used to represent group companies โ when multiple customers (companies or branches) belong to the same business group, they are linked under a single Customer Group. This allows users to track and analyse the total business done with an entire group of companies, not just individual customers.
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| New | Opens a blank Customer Group form |
| Save | Saves the group record |
| Search | Search for existing groups |
| List View | Displays all groups in a list |
| View History | Shows modification history |
Fields
| Field | Description | Required |
|---|---|---|
| Group Name* | The name of the group company (e.g., ABC Group, XYZ Holdings). All individual customers belonging to this business group will be linked to this group in the Customer master. This enables consolidated reporting and analysis of the entire group's purchases and outstanding balances. | Yes |
Step-by-Step Guide
Open a blank Customer Group form.
Type the name of the group company or holding (e.g., ABC Group, XYZ Holdings, Pharma Distributors Group).
Click Save. The group is now available in the Customer Group dropdown in the Customer master. Assign this group to all individual customer records that belong to this company group.
Customer
The Customer master is used to register credit/account customers โ businesses or individuals who buy on credit terms. It stores full customer details including credit limits, pricing category, loyalty card, and assigned locations. This customer type appears in Sales Invoice and Provisional Invoice transactions.
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| New | Opens a blank Customer form |
| Save | Saves the customer record |
| Search | Search for existing customers |
| List View | Displays all customers in a list |
| View History | Shows modification history |
| CSV Import | Import multiple customers from a CSV file |
Header Fields โ Left Column
| Field | Description | Required |
|---|---|---|
| Category* | Customer category โ select from dropdown (must be set up in Customer Category master). | Yes |
| Customer Group* | Customer group โ select from dropdown (must be set up in Customer Group master). | Yes |
| Code* | Unique customer code. Use the … button to auto-generate or enter manually. | Yes |
| Customer Name* | Full name of the customer or business. | Yes |
| Existing Vendor?* | Check this box if this customer is also a vendor/supplier in the system. Links to the Supplier master. | Optional |
| Control Account* | GL control account for this customer's receivables. Select from dropdown. | Yes |
| Supplier Name | If Existing Vendor? is checked, select the linked supplier name. | Cond |
| Credit Limit (USD) | Maximum credit amount allowed for this customer in USD. | Optional |
| Credit Days | Number of days credit is allowed before payment is due. | Optional |
| National ID | Customer's national identification number. | Optional |
| Price Category* | Pricing tier for this customer โ determines which price list applies (Retail, Wholesale, etc.). | Yes |
| Loyalty Card | Assign a loyalty card scheme to this customer from the dropdown. | Optional |
Header Fields โ Right Column
| Field | Description | Required |
|---|---|---|
| NRC No | National Registration Certificate number (for business customers). | Optional |
| Impot No | Tax/Import registration number. | Optional |
| Address | Full postal or physical address of the customer. | Optional |
| Mobile Number | Customer's mobile phone number. | Optional |
| Email ID | Customer's email address for invoices and communication. | Optional |
| Sales Person* | Assign a default sales person to this customer. Click 🔍 to search. | Yes |
| Tax Exempted?* | Check if this customer is tax exempt. Tax will not be applied in invoices. | Optional |
| Free offer Applicable? | Check if this customer is eligible for free offer promotions. | Optional |
| Inactive?* | Check to deactivate this customer. Inactive customers cannot be used in transactions. | Optional |
Location Grid
| Field | Description | Required |
|---|---|---|
| S No | Auto-incremented row number. | Auto |
| Location* | Assign one or more shop locations where this customer can transact. Select from dropdown. Add multiple rows for multiple locations. | Yes |
Step-by-Step Guide
Open a blank Customer form.
Choose the appropriate Category and Customer Group from the dropdowns.
Use the … button to auto-generate a code or enter one manually.
Type the full customer or business name.
Enter Credit Limit (USD) and Credit Days if this is a credit customer.
Choose the pricing tier that applies to this customer.
Enter contact details โ Mobile Number, Email ID, and Address.
Click 🔍 and select the sales person responsible for this customer.
Check Tax Exempted?, Free offer Applicable?, or Inactive? as appropriate.
In the Location grid, select all shop locations where this customer can make purchases.
Click Save. The customer is now available in Sales Invoice and Provisional Invoice transactions.
Customer (Cash)
The Customer (Cash) master is used to register walk-in cash customers โ individuals who pay at point of sale without credit terms. This is a simplified customer record compared to the full Customer master, with no credit limit, control account, or location assignment required.
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| New | Opens a blank Customer (Cash) form |
| Save | Saves the record |
| Search | Search for existing cash customers |
| List View | Displays all cash customers in a list |
| View History | Shows modification history |
Fields
| Field | Description | Required |
|---|---|---|
| Location* | The shop location where this cash customer transacts. Select from dropdown. | Yes |
| Category* | Customer category โ select from Customer Category master. | Yes |
| Customer Group* | Customer group โ select from Customer Group master. | Yes |
| Code* | Unique customer code. Use … to auto-generate or enter manually. | Yes |
| Customer Name* | Full name of the cash customer. | Yes |
| National ID | Customer national ID number (optional for walk-in customers). | Optional |
| Price Category* | Pricing tier for this customer. | Yes |
| Loyaltycard | Assign a loyalty card scheme if applicable. | Optional |
| Address | Customer address. | Optional |
| Telephone No | Customer telephone number. | Optional |
| Email ID | Customer email address. | Optional |
| Sales Person | Assign a sales person if applicable. Click 🔍 to search. | Optional |
| Tax Exempted?* | Check if this customer is tax exempt. | Optional |
| Inactive?* | Check to deactivate this customer. | Optional |
| Free offer Applicable? | Check if eligible for free offer promotions. | Optional |
Step-by-Step Guide
Open a blank Customer (Cash) form.
Choose the shop location for this cash customer.
Choose from the configured masters.
Auto-generate or enter a code, then enter the customer name.
Choose the applicable pricing tier.
Enter address, telephone, and email if available.
Check Tax Exempted?, Inactive?, or Free offer Applicable? as needed.
Click Save. The customer is available for use in cash sales transactions.
Price Update (Single)
Price Update (Single) is used to set or update the selling price for a single item at a time. It shows the last purchase price for reference and allows the Retail % and Wholesale % markups to be entered, which auto-calculate the selling prices. Alternatively, prices can be entered directly.
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| New | Opens a blank Price Update form |
| Save | Saves the price record |
| Search | Search for existing price records |
| List View | Displays all price records in a list |
| View History | Shows modification history |
| CSV Import | Import prices from a CSV file for multiple items |
Fields
| Field | Description | Required |
|---|---|---|
| Location* | The shop location for which the price is being set. Select from dropdown. | Yes |
| Item Name* | The item whose price is being updated. Click 🔍 to search and select. | Yes |
| Unit | Unit of measure โ auto-filled from item master. | Auto |
| Currency* | The currency for this price (Local or Base). Select from dropdown. | Yes |
| Last Purchase Price (Base) | The most recent purchase cost of this item in base currency. Auto-filled for reference โ read-only. | Auto |
| Retail % | Markup percentage over Last Purchase Price to calculate the Retail selling price. Enter the percentage โ Retail Price auto-calculates. e.g., enter 20 for 20% markup | Optional |
| Wholesale % | Markup percentage over Last Purchase Price to calculate the Wholesale price. e.g., enter 15 for 15% markup | Optional |
| Retail Price | The selling price for retail customers. Can be entered directly or auto-calculated from Retail %. | Yes |
| Wholesale Price | The selling price for wholesale customers. Can be entered directly or auto-calculated from Wholesale %. | Yes |
| Current Price (Retail) | The current active retail price already saved in the system. Displayed for reference โ read-only. | Auto |
| Current Price (Wholesale) | The current active wholesale price in the system. Read-only. | Auto |
Step-by-Step Guide
Open a blank Price Update (Single) form.
Choose the shop location for which the price applies.
Click 🔍 on Item Name and select the item to price.
Choose the currency โ Local or Base.
Check the Last Purchase Price (Base) as a reference for markup calculation.
Either enter Retail % and Wholesale % to auto-calculate prices, or enter Retail Price and Wholesale Price directly.
Click Save. The new price takes effect immediately for sales transactions at the selected location.
Price Update (Multiple Items)
Price Update (Multiple Items) allows setting or updating selling prices for multiple items in a single document. It supports an effective date so prices can be scheduled to activate in the future, and can be imported from CSV for bulk updates.
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| New | Opens a blank Price Update (Multiple) form |
| Save | Saves the price update document |
| Search | Search for existing price update documents |
| List View | Displays all price update documents in a list |
| View History | Shows modification history |
Header Fields
| Field | Description | Required |
|---|---|---|
| Location | The shop location for which prices are being updated. Select from dropdown. | Yes |
| Price Update No | System-generated document number for this price update batch. Use … to search existing. | Auto |
| Effective From* | The date from which these prices become active. Can be set to a future date to schedule price changes. | Yes |
| Currency* | The currency for these prices. Select from dropdown. | Yes |
Item Grid Columns
| Field | Description | Required |
|---|---|---|
| S No | Auto-incremented row number. | Auto |
| Item Name* | Select item using 🔍 search. | Yes |
| Unit* | Unit of measure โ auto-filled from item master. | Auto |
| Last Purchase Price (Base) | Last purchase cost in base currency โ auto-filled for reference. | Auto |
| Current Retail Price | Current active retail price โ auto-filled for reference. | Auto |
| Retail % | Markup percentage to calculate new retail price. | Optional |
| Retail Price (Std Unit)* | New retail price in standard unit โ enter or auto-calculate from Retail %. | Yes |
| Current Wholesale Price | Current active wholesale price โ auto-filled for reference. | Auto |
| Wholesale % | Markup percentage to calculate new wholesale price. | Optional |
| Wholesale Price (Std Unit)* | New wholesale price โ enter or auto-calculate from Wholesale %. | Yes |
Step-by-Step Guide
Open a blank Price Update (Multiple Items) form.
Set the applicable shop location and currency.
Enter the date when these prices should activate. Use a future date to schedule price changes.
In the grid, click 🔍 on Item Name to select each item. Last Purchase Price and Current Prices auto-fill.
For each item, enter Retail % and Wholesale % to auto-calculate prices, or enter Retail Price (Std Unit) and Wholesale Price (Std Unit) directly.
Press Enter to add new rows. Repeat for all items to be updated.
Click Save. Prices activate on the Effective From date.
Shop Setup
Shop Setup configures the accounting ledgers and cash shortage tolerances for each shop location. This must be completed before Shop Open, Sales Invoice, and Shop Close transactions can be processed at a location. Each location requires its own Shop Setup record.
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| New | Opens a blank Shop Setup form |
| Save | Saves the shop setup record |
| Search | Search for existing shop setups |
| List View | Displays all shop setups in a list |
| View History | Shows modification history |
Fields
| Field | Description | Required |
|---|---|---|
| Location* | The shop or branch location being configured. Select from dropdown. Each location must have its own setup record. | Yes |
| Cash Customer* | The default cash customer to be used for over-the-counter cash sales at this location. Click 🔍 to search and select. This is typically a generic 'Walk-In Customer' or 'Cash Customer' record | Yes |
| Cash Ledger (Local)* | The GL ledger account for cash held in local currency (CDF) at this shop. Click 🔍 to select. | Yes |
| Cash Ledger (Base)* | The GL ledger account for cash held in base currency (USD) at this shop. Click 🔍 to select. | Yes |
| Cash Shortage Ledger* | The GL account to post any cash shortage or excess amounts identified during Shop Close. Click 🔍 to select. | Yes |
| Max Shortage Base Allowed | The maximum allowed cash shortage in base currency (USD) before an alert is triggered during Shop Close. | Optional |
| Max Shortage Local Allowed | The maximum allowed cash shortage in local currency (CDF) before an alert is triggered during Shop Close. | Optional |
| Shop Setup | Additional configuration reference field โ auto-filled by the system. | Auto |
Step-by-Step Guide
Open a blank Shop Setup form.
Choose the shop location to be configured.
Click 🔍 and select the default cash customer for over-the-counter sales at this location.
Click 🔍 for Cash Ledger (Local) and Cash Ledger (Base) and select the appropriate GL accounts from the chart of accounts.
Click 🔍 and select the GL account for posting shortage/excess amounts.
Enter Max Shortage Base Allowed and Max Shortage Local Allowed to define acceptable tolerance during Shop Close.
Click Save. The shop is now configured and ready for Shop Open and sales transactions.
Sales Promotion
Sales Promotion is used to configure free item promotional schemes based on the quantity of an item purchased. When a customer buys within a defined quantity range, the system automatically applies the free item offer during invoicing.
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| New | Opens a blank Sales Promotion form |
| Save | Saves the promotion scheme |
| Search | Search for existing promotions |
| List View | Displays all promotion records in a list |
| View History | Shows modification history |
Header Fields
| Field | Description | Required |
|---|---|---|
| Item Name* | The item to which this promotion applies. Click 🔍 to search and select. | Yes |
| Unit* | Unit of measure โ auto-filled from item master. Can be changed. | Auto |
| Reason* | The reason or type for the promotion scheme. Select from dropdown. | Yes |
| Expense A/c | GL account for the cost of free items given. Auto-filled based on Reason selection. | Auto |
| Cost Center* | Cost centre to which the promotion expense is allocated. Click 🔍 to search. | Yes |
| Scheme Date* | The start date of the promotion scheme. | Yes |
| Scheme No | System-generated unique scheme reference number. Use … to search existing. | Auto |
| Inactive?* | Check to deactivate this scheme without deleting it. | Optional |
Tabs
- Range Details โ Define quantity ranges and the free items given for each range (e.g., buy 10-20 units, get 1 free)
- Applicable Location โ Select which shop locations this promotion applies to
- Attachment โ Upload supporting documents (e.g., supplier promotion letter)
- Summary โ View a summary of the scheme configuration
Range Details Grid
| Field | Description | Required |
|---|---|---|
| S No | Auto-incremented row number. | Auto |
| Maximum Qty* | The upper limit of the quantity range for this tier. The system uses ranges to determine which free offer applies based on the quantity sold. e.g., enter 20 if the range is 'up to 20 units' | Yes |
Step-by-Step Guide
Open a blank Sales Promotion form.
Click 🔍 on Item Name to select the promoted item.
Select the promotion Reason and click 🔍 to select the Cost Center.
Enter the effective date of the promotion.
In the Range Details tab, enter the Maximum Qty for each promotion tier.
Go to the Applicable Location tab and select which shop locations this promotion applies to.
Click Save. The promotion scheme is now active and will be applied automatically during invoicing when the Free offer Applicable? flag is enabled for the customer.
Discount Slabs
Discount Slabs define automatic discount percentages that are applied based on the total invoice value. When a customer's invoice value falls within a configured range (From value to To value), the corresponding discount percentage is automatically applied.
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| New | Opens a blank Discount Slabs form |
| Save | Saves the discount slab configuration |
| Search | Search for existing discount slab records |
| List View | Displays all discount slab records in a list |
| View History | Shows modification history |
Header Fields
| Field | Description | Required |
|---|---|---|
| Document Date* | The effective date of this discount slab configuration. | Yes |
| Document No | System-generated document reference number. Use … to search existing. | Auto |
| Inactive?* | Check to deactivate this discount slab without deleting it. | Optional |
Tabs
- Slab Details โ Define the value ranges and discount percentages
- Applicable Location โ Select which locations this discount slab applies to
- Attachment โ Upload supporting documents
- Summary โ View a summary of the configured slabs
Slab Details Grid
| Field | Description | Required |
|---|---|---|
| S No | Auto-incremented row number. | Auto |
| Fromvalue* | The minimum invoice value for this discount tier (e.g., 100 means invoices of 100 and above qualify). | Yes |
| Tovalue* | The maximum invoice value for this discount tier (e.g., 500 means invoices up to 500 qualify for this tier's discount). | Yes |
| Discount (%) | The discount percentage applied when the invoice value falls within this range. e.g., 5 for 5% discount | Yes |
Step-by-Step Guide
Open a blank Discount Slabs form.
Enter the effective date for these discount slabs.
In the Slab Details tab, enter From value, To value, and Discount % for each tier. Add as many rows as needed to cover all value ranges.
Go to the Applicable Location tab and select which shop locations these slabs apply to.
Click Save. The discount slabs are now active and will be automatically applied to qualifying invoices.
- 0 โ 99: 0% discount
- 100 โ 499: 3% discount
- 500 โ 999: 5% discount
- 1000+: 8% discount
Sales Target โ Location Wise
Sales Target (Location Wise) is used to set monthly sales targets for each shop location. Targets are set by financial year and location, with individual quantity and amount targets for each month of the year.
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| New | Opens a blank Sales Target form |
| Save | Saves the target record |
| Search | Search for existing target records |
| List View | Displays all target records in a list |
| Tasks | Additional tasks such as copying targets or exporting |
| View History | Shows modification history |
Header Fields
| Field | Description | Required |
|---|---|---|
| Financial Year* | The financial year for which targets are being set. Select from dropdown. | Yes |
| Location* | The shop location for which these targets apply. Select from dropdown. | Yes |
Target Grid
| Field | Description | Required |
|---|---|---|
| S No | Auto-incremented row number. | Auto |
| Month | The month name for this target row โ auto-filled for all 12 months. | Auto |
| Target Qty | The target quantity (number of units) to be sold at this location in this month. | Yes |
| Target Amount | The target sales value (in currency) to be achieved at this location in this month. | Yes |
Step-by-Step Guide
Open a blank Sales Target (Location Wise) form.
Choose the financial year from the dropdown.
Choose the shop location for these targets.
For each month row, enter Target Qty and Target Amount.
Click Save. Targets are now active for performance tracking and reporting.
Sales Target โ Delegate Wise
Sales Target (Delegate Wise) is used to set monthly sales targets for individual sales persons. Targets are defined by financial year and sales person, enabling individual performance tracking against monthly quantity and amount goals.
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| New | Opens a blank Sales Target (Delegate) form |
| Save | Saves the target record |
| Search | Search for existing delegate target records |
| List View | Displays all delegate target records in a list |
| Tasks | Additional tasks such as copying targets |
| View History | Shows modification history |
Header Fields
| Field | Description | Required |
|---|---|---|
| Financial Year* | The financial year for which targets are being set. Select from dropdown. | Yes |
| Sales Person* | The sales person (delegate) for whom these targets are being set. Select from dropdown. | Yes |
Target Grid
| Field | Description | Required |
|---|---|---|
| S No | Auto-incremented row number. | Auto |
| Month | The month name โ auto-filled for all 12 months of the selected financial year. | Auto |
| Target Qty | Target quantity (units) for this sales person in this month. | Yes |
| Target Amount | Target sales value for this sales person in this month. | Yes |
Step-by-Step Guide
Open a blank Sales Target (Delegate Wise) form.
Choose the financial year from the dropdown.
Choose the sales person from the dropdown.
For each month row, enter Target Qty and Target Amount for the sales person.
Click Save. The targets are active and will appear in performance reports.
Loyalty Card
The Loyalty Card master is used to configure customer loyalty point schemes. It defines how many points a customer earns per unit of sales amount, the categories of customers eligible, the redemption rules, and how often points can be redeemed.
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| New | Opens a blank Loyalty Card form |
| Save | Saves the loyalty card scheme |
| Search | Search for existing loyalty card schemes |
| List View | Displays all loyalty card schemes in a list |
| View History | Shows modification history |
Header Fields
| Field | Description | Required |
|---|---|---|
| Document Date* | The effective date of this loyalty card scheme. | Yes |
| Card Name* | The name of the loyalty card scheme (e.g., Gold Card, Silver Card, Standard). | Yes |
| Redemption Frequency (Days) | The minimum number of days a customer must wait between loyalty point redemptions. e.g., 30 means points can only be redeemed once every 30 days | Optional |
| Inactive?* | Check to deactivate this scheme without deleting it. | Optional |
Tabs
- Loyalty Categories โ Define which customer categories earn points and how many sales amount = 1 point
- Redemption Details โ Configure redemption rules โ how many points = what monetary value
- Summary โ View a summary of the loyalty card configuration
Loyalty Categories Tab Grid
| Field | Description | Required |
|---|---|---|
| S No | Auto-incremented row number. | Auto |
| Loyalty Category* | The customer category eligible for this loyalty card scheme. Select from dropdown. | Yes |
| Sales Amount (Per Point)* | The sales amount (in currency) required to earn 1 loyalty point. For example, entering 100 means every 100 spent earns 1 point. e.g., 100 means spend 100 = earn 1 point | Yes |
Step-by-Step Guide
Open a blank Loyalty Card form.
Type a descriptive name for this loyalty scheme.
Enter the effective date of the scheme.
Enter the minimum days between redemptions if applicable.
In the Loyalty Categories tab, add rows for each eligible customer category and set the Sales Amount (Per Point) for each.
Go to the Redemption Details tab and define how redeemed points are converted to a monetary value.
Click Save. The scheme is now available to assign to customers in the Customer master (Loyalty Card field).
Quick Reference
A summary of all Sales Module transactions โ when to use each screen and what it affects.
Transaction Summary
| # | Screen | When to Use | Affects Stock | Affects Accounts | Receipt Needed |
|---|---|---|---|---|---|
| 01 | Shop Open | Start of every business day | No | No | No |
| 02 | Sales Order / Proforma | Customer order before invoicing | No | No | No |
| 03 | Sales Invoice (Facture) | Goods available โ bill and deliver | Yes ↓ | Yes | Cash only |
| 04 | Provisional Invoice | Bill now โ deliver goods later | No | Yes | Cash only |
| 05 | Delivery Note | Deliver against Provisional Invoice | Yes ↓ | No | No |
| 06 | Sales Return | Return against a linked invoice | Yes ↑ | Yes | If cash refund |
| 07 | Sales Return (Direct) | Return โ no linked invoice | Yes ↑ | Yes | If cash refund |
| 08 | Sales Receipt / Return | Collect cash / print invoice / refund | No | Yes | This IS receipt |
| 09 | Receipt / Payment (Shop) | Misc cash in/out not linked to invoice | No | Yes | No |
| 10 | Currency Exchange | Exchange CDF ↔ USD | No | Yes | No |
| 11 | Commission Payment | Pay sales commission | No | Yes (on Approve) | No |
| 12 | Shop Close | End of day โ cash reconciliation | No | Yes | No |
Invoice Path Decision Guide
| Situation | Use This Screen | Then |
|---|---|---|
| Goods available, customer pays cash | Sales Invoice (Facture) | Sales Receipt (collect + print) |
| Goods available, customer on credit | Sales Invoice (Facture) | No receipt needed |
| Goods not ready, bill now | Provisional Invoice | Delivery Note when goods ready |
| Customer returns (invoice exists) | Sales Return | Sales Receipt if cash refund |
| Customer returns (no invoice) | Sales Return (Direct) | Sales Receipt if cash refund |
Daily Checklist
- ☐ Start of Day โ Run Shop Open before any transactions
- ☐ Cash Sales โ Invoice → Receipt screen to collect and print
- ☐ Credit Sales โ Invoice only โ no receipt needed
- ☐ Deliveries โ Delivery Note against Provisional Invoice (PSI No)
- ☐ Returns โ Sales Return (linked) or Direct (unlinked)
- ☐ Cash Refunds โ Sales Receipt / Return screen
- ☐ End of Day โ Count cash, run Shop Close
Error Reference
Common errors in the Sales Module and how to resolve them.
Common Errors & Resolutions
| Error / Issue | Likely Cause | How to Fix |
|---|---|---|
| Cannot process any transaction | Shop not opened for the day | Run Shop Open first for the correct location and date |
| Item not found in search | Item not in item master | Contact admin to add item to item master |
| Customer not in list | Customer not registered | Add customer in Customer or Customer (Cash) master |
| Batch No. dropdown empty | No stock received for this item | Verify GRN was done; check batch master |
| Insufficient stock | Available stock less than quantity being sold | Check current stock; receive more via GRN |
| PSI No. dropdown empty | No open Provisional Invoice for this customer | Raise Provisional Invoice first |
| Invoice No. not in Sales Return | Invoice already fully returned or wrong customer | Verify customer selection; check prior returns |
| Commission not posting | Used Save instead of Approve_Save | Use Approve_Save to confirm and post |
| Shop Close blocked | Previous day not closed | Close previous day first |
| Cash difference in Shop Close | Physical cash does not match system | Recount cash; check for missing receipts |
| Credit limit exceeded | Customer outstanding exceeds credit limit | Get manager approval to proceed |
| Price not updating in invoice | Price not set for this location/currency | Update price in Price Update (Single) or (Multiple) |
| Free offer not applying | Customer Free offer Applicable? not checked, or no active promotion | Check customer master flag; verify Sales Promotion scheme is active |