How to manage inventory by adding purchase entry and bill the items from pos with different batch

Inventory Management, Purchase Entry & Batch-wise POS Billing

The system should provide an Inventory Management module that allows users to maintain stock by recording purchases and selling items through the POS. Inventory should support batch-wise stock management, allowing the same product to have multiple batches with different purchase prices, expiry dates, and available quantities.

1. Create a Purchase Entry

When stock is received from a supplier, create a Purchase Entry in Caddayn Biller.

Enter the required details, such as:

• purchase bill number

• Supplier name

• branch

• add item

• total landing cost

• Bill amount

• date of purchase

• payment method

• amount

• quantity

• buying price

• tax

• select batch

• MFG date

• expiry date

• calculate profit

note: A purchase entry can be created only if there is a profit

Once the purchase entry is saved, the purchased quantity is added to the inventory under the respective batch.

2. Batch-wise Inventory

The same product may be purchased multiple times with different batches.

For example:

The system should maintain these batches separately instead of combining them into a single stock record.

Users should be able to view:

• Item name and code

• Quantity

• Selling price

• Location

• Branch name and code

• Brand name and code

• Expiry

3. Bill Products Through POS

When a customer purchases the product:

1. Open the POS Billing screen.

2. Select the required product.

3. If multiple batches are available, select the appropriate batch.

4. Enter the quantity.

5. Add the item to the bill.

6. Complete the payment and generate the invoice.

The quantity sold is automatically deducted from the selected batch.

For example, if 10 units are sold from Batch B001:

Only the stock of Batch B001 is reduced.