Step by step
- Open Sales > Item Payment Sale Product Wise (it is there when the Item Payment Sale app is bought and switched on).
- Choose Search Product (type and pick the product from the list), the shop (only for users who see all shops), Customer, User, Item Payment Status (Paid, Partial or Due of each item), From Date, To Date, Category, Subcategory and Brand, then press Filter.
- Each row is one product (or variant): SL, Product, Qty Sold, Sale Amount, Paid Amount and Due Amount. The Total row adds up the products.
- When the vouchers have a sale tax, shipment charge or service charge, the table under the products shows each charge with its Sale, Paid and Due Amount, and the Total of the products and charges.
- Print prints the whole report with the totals. Excel and Pdf export the rows shown on the screen.
Good to know
- The figures are those of the "Paid by Item" table of each voucher: Paid Amount is what was paid for the item at the sale and by the receipts taken later item by item (Add Receipt), up to today. Due Amount = Sale Amount - Paid Amount.
- A receipt from the Receipts screens can pay the invoice without saying which item it pays, and a sales return that was not paid back lowers the invoice's due. Then the lines Received (not split by item), Less: Returns & Adjustments and Invoice Total show how the total comes to the invoices' own paid and due (as in Manage Sales).
- When a product, category, brand, search or item payment status is chosen, only the items listed are counted, without the charges and the receipts not split by item.
- Both dates are needed and the From Date can not be after the To Date. Needs the permission Item Payment Sale Product Wise Report (in Item Payment Sale Permissions).