Inventory Transaction Summary Report

Totals all stock movements of a period by transaction type, in quantity and amount: what came in (receipts, returns, transfers in, adjustments up, conversions) and what went out (sales, POS, transfers out, damages, adjustments down).

Menu: Reports › Financial Reports › Inventory Transaction Summary Report

Required permission

Reports › Inventory Transaction Summary Report › View

What it's for

Use it for a one-page stock flow of a branch or the whole company for the month, for example to check that beginning stock + in − out = ending stock in accounting, or to see how much was lost to damages and adjustments.

Example

For April, the main branch shows In: Purchase Inbound 12,400 pcs / 1,860,000.00 and Out: POS Sales 9,800 pcs, Stock Delivery Outbound 2,100 pcs, Damage Outbound 45 pcs / 6,750.00. The owner asks why damages doubled compared with March.

Options on the screen

• Trans. Date and Branch (in the filters), plus product filters such as Category, Brand or Supplier.
• Each transaction type shows a Qty and an Amount, with totals for In and Out.

Filters

Click Filters to narrow the report. You can filter by:

Branch, Supplier, Default Supplier, Category, Category Tag, Brand, Status, Senior, Management Type, PNST (Discount), Solo Parent, Product Tag.

For searching, express filters, sorting, column settings, exporting and printing, see About reports.

Settings that affect this module

Your administrator can change these in Settings (see About settings). Click a section to see the choices.

Generic Settings › Income Statement

• Percent Income of RETAIL items sold in POS

Generic Settings › Product Pricing

• Restrict branches to only be able to view their own price
• Markup% computation basis
• Set base amount for rounding computation. (cents)

Generic Settings › Product

• Allow product name searching to ignore special characters?

Generic Settings › Purchase Inbound

• Apply counter checking of serial number or batch by re-scanning it to another modal window?

Generic Settings › Sales and Other Income

• For walk-in customers, prices are based from
• Hide all Sales & Collection Transactions before the specified date?
• Allow negative qty (as Returns) in Sales and Sales Outbound
• For regular customers, prices are based from

Generic Settings › Sales Outbound

• Cost price basis for Batch management type products
• Cost price basis for Serial management type products

Generic Settings › Security

• Protect Sheet with Password for Export to Excel Output?

Generic Settings › 3rd Party E-Commerce

• Enable E-Commerce Automatic Inventory Sync
• Enable E-Commerce Automatic Order Sync
• Enable E-Commerce Automatic Product Sync
• Enable auto import of E-Commerce Order list.
• Ignore on-hold qty of products in transactions on or earlier than:

Branch Settings › Payment

• Display transactions of other branches?

Branch Settings › Purchase Inbound

• Able to import purchase of other branches?

Branch Settings › Sales Outbound

• Able to import sales of other branches?