Detail Sales Outbound Report

Lists every Sales Outbound transaction line by line, with its header details (date, branch, status, who created and approved it) and each product with quantity, prices, discounts and amounts.

Menu: Reports › Transaction Detail Reports › Detail Sales Outbound Report

Required permission

Reports › Detail Sales Outbound Report › View

What it's for

Use it when the transaction list isn't enough: to filter and export lines by product, brand, category, customer, supplier or status, for example for reconciliation, audits or analysis in Excel. Filter by any header field or product with Filters and Filter By Product. See Sales Outbound for the transaction itself.

Example

The accountant exports all sales outbound lines of a customer for the year, with Profit and returns, for the annual account review.

Filters

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

Branch, Branch Area, Trans. Date, Sheet No., Remarks, Approval Status, Deleted, Customer Type, Customer, Walk-in Customer, Collection Status, Salesman, Request by, Created by, Created Date, Last Modified By, Last Modified Date, Audit By, Audit Date, Reference No., Product Barcode, Product Name, Product Description, Product Brand, Category Tag, Product Category, Product Supplier, Default Supplier, S.N., Stock No., Product Tag, Chinese Name, Detail Remarks, Qty, UOM, Unit Specs, Total Qty, Weight, O. Price, Price, Discount 1, Discount 2, Discount 3, Discount 4, Cost, Amount, Memo, Secondary Barcode, Default Unit, Management Type, Product Life Cycle, Senior, PNST (Discount), Solo Parent, Vatable, Invoice Reference, Customer Branch, Total Amount, Adjustment Amount, Net Total Amount, Remaining Collection Amount, Term, Inspect Qty, MA Cost, Profit, MA Profit, Return Amount, Net Amount After Return, Return Inbound Amount, Net Amount After Return Inbound, Pick List Sheet No., Pick List Status, Inspection Status.

Columns

Column	What it shows
Created From	The branch where the transaction was created.
Created For	The branch the transaction is for (whose stock or money it affects).
For Location	The branch location whose stock the transaction affects.
Default Supplier	The product's default supplier (ticked on its Supplier tab).
Transaction Date and Time	The transaction's date and time.
Sheet No.	The transaction's sheet number; click it to open the transaction.
Invoice Reference	The invoice or reference number entered on the transaction.
Approval Status	Draft, For Approval, Approved or Declined.
Customer Type	Walk-in or regular customer.
Customer	The customer.
Customer Branch	The customer's branch (for customers with several branches).
Total Amount	Total sales or transaction amount.
Adjustment Amount	Amount added or taken off the whole transaction.
Net Total Amount	Total amount after the transaction's discounts.
Remaining Collection Amount	Amount not yet collected from the customer.
Remarks	The transaction's remarks.
Salesman	The salesman on the transaction.
Term	Payment term, in days.
Request by	The person who requested the transaction.
Created by	User who created the transaction.
Created Date	When the transaction was created.
Audit By	User who approved (audited) the transaction.
Audit Date	When the transaction was approved.
Deleted	Whether the transaction has been deleted.
Product Tags	The product's tags.
Product Name	The product name.
S.N.	Serial numbers or batch on the line.
Batch	The batch on the line (batch products).
Product Description	The product's description.
Qty	Quantity on the line.
UOM	The unit of measure used on the line.
Unit Specs	The unit used on the line and how many default units it holds.
Weight	Weight of the quantity on the line, from the unit's weight on the product.
Inspect Qty	Quantity checked in inspection mode.
Total Qty	Total quantity, in default units.
O. Price	Original price: the price before the line's discounts.
Price	Price per unit on the transaction line, after line discounts.
Discount 1	First discount on the line, in %.
Discount 2	Second discount on the line, in %, applied after the first.
Discount 3	Third discount on the line, in %.
Discount 4	Fourth discount on the line, in %.
Disc/Adj	Discount or adjustment type used on the line.
Cost	The product's cost on the line.
MA Cost	Moving average cost: the average cost of the stock on hand, updated with each incoming transaction.
Profit	Amount minus cost.
MA Profit	Amount − moving average cost.
Amount	Line amount: quantity × price.
Detail Remarks	The remarks on the product line.
Transaction Date	The transaction's date.
Transaction Time	The transaction's time.
Return Amount	Value of goods returned against this transaction.
Net Amount After Return	Amount minus returns.
Return Inbound Amount	Value received back from the customer by sales return inbound.
Net Amount After Return Inbound	Amount minus the return inbounds.
Pick List Sheet No.	The picking list the line is on.
Pick List Status	Status of that picking list.
Inspection Status	Status of the inspection (inspection mode).
Modified by	User who last changed the transaction.
Last Modified	When the transaction was last changed.

Also shows: Barcode, Stock No., Chinese Name.

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