Sales Order Line Status Export

This report shows you all the lines on Sales Orders, and their status of pending, fully or partially invoiced.

Introduction

Sales Order Line Status Export

Exported Fields

Introduction

The Sales Order Line Status Export produces an excel report that shows all lines on Sales Orders, and their status of pending, fully or partially invoiced. A list of all exported fields is shown below.

Return to Top of Page

Sales Order Line Status Export

This export is located on the Receivables menu.

• Go to Receivables > Exports > Sales Order Line Status Export.
• You can narrow down your search selections by Branch, Stock Category, Stock Group, Stock, Discount Group, and Staff.
• You must enter a Start and End date for Sales order date.
• Click Save defaults to re-use the same selection criteria without having to re-enter.
• Click Export Report.

Return to Top of Page

Exported Fields

This produces an Excel spreadsheet with the following columns for each line of Sales Orders, and you can now sort the data by Account Code, Sales Order Code or Sales Order, etc.

• • SalesOrderLineOid 
  • Quantity 
  • NotYetSuppliedQuantity
  • SuppliedQuantity 
  • Price
  • DiscountPercent 
  • SalesOrderCode
  • StockCodeAndDescription 
  • AccountCode
  • AccountDescription 
  • StaffCode
  • StaffDescription
  • BranchCode
  • BranchDescription
  • StockFullDescription
  • StockCategoryCode
  • StockCategoryDescription
  • StockGroupCode
  • StockGroupDescription
  • DiscountGroupCode
  • DiscountGroupDescription
  • NotYetOrderedQuantity

Return to Top of Page

Last updated: 5 April 2023