Navigation¶

• Adjutant Wiki Home
  

• CRM Wiki
  

• AFI Wiki
  

• Categories
• All Pages
• Create a new Page
  

• Administration
• File Management
  

• Login/Logout
• Consultant Guide
• Your Profile
• Create Account
  

Quick Search
»


Advanced Search »

Buyout Report

Table of Contents [Hide/Show] Default Menu Location General Description Fields/Filters Standard Report Fields (Header)    Group Header 1    Group Header 2    Group Header 3 Standard Report Fields (Line Items) Additional Report Fields for Customization

Default Menu Location¶

Reports >> Purchase Order >> Buyout Report

Click here for a screenshot

General Description¶

Buyout Report screen allows users to see a report for a specific date range or a specific time frame.

Fields/Filters¶

Date Range: Specific date range for the report

Custno: Customer number

Item: Item code

Fall off after x Days: No merchandise will show on the report after this specific days. (*Note*: This overwrites "Date Range" option above!)

Project: Project number and Sales Order number

Standard Report Fields (Header)¶

Company

• company
  

As of Date

• ' As of ' + dtoc(date())
  

Orders Type

• '( ' + lc_para + ' )'
  

Group Header 1¶

Item

• alltrim(item) + " : " + orgdesc
  

Group Header 2¶

Customer

• alltrim(company) + ' ( ' + alltrim(custno) + ' )'
  

Group Header 3¶

Order Number

• sono
  

Standard Report Fields (Line Items)¶

Line #

• linenum
  

ReqD: Request Date

• reqdate
  

Item/Description

• item
  

• alltrim(descrip) + chr(13) + alltrim(socdesc) + " " + alltrim(notes)
  

Unit

• unit
  

Un Purchased Qty

• qtyord
  

Unit Cost

• cost
  

Sales Person

• sp
  

Additional Report Fields for Customization¶