BasicReports Purchase Order Report
Table Of Contents
The Purchase Order report can be configured when Khaos Control is set to use Basic Reports. You can control a range of report settings through
[ System Operations | Basic Reports Setup ] and make more advanced layout changes using Report Builder.Warning: Before making changes to any Basic Report template, take a backup. Khaos Control also identifies Basic Reports and Report Builder as advanced functionality.
Purchase Order Report Options
Open
[ System Operations | Basic Reports Setup ] and select the Purchase Order report to configure its settings.Note: You need Admin permission to access Basic Reports Setup, and Basic Reports must be enabled on your system. System Operations - Basic Reports Setup
The following settings are available:
- Allow Cust Sorting (Order): Allows the contents of the Purchase Order report to be sorted.
- Allow Std Company Addr: Allows the standard company address used by the report to be configured.
- Leave Summary Space: Reserves space for summary information when required by the report layout.
- Show Shading: Controls whether shading is displayed on the report.
- Show Logo: Controls whether the company logo is displayed.
- Hide Date Requested When = Order Date: Hides the requested date when it is the same as the order date.
- Show Copy Label: Displays a copy label when applicable.
- Show Currency: Displays currency information on the report.
- Show Multi-currency: Allows the report to display foreign currencies.
- Stock Desc Include Supplier Ref: Includes the supplier reference with the stock description.
For further information about these options, see System Operations - Basic Reports Setup.
Report Builder
Use Report Builder when you need to make more advanced changes to the Purchase Order report template.
Important: Report Builder Designer is an Advanced User feature. Always back up the report template before making changes.
The fields you can add depend on the data pipeline selected in Report Builder. The available fields vary between report types, so not every Khaos Control field will necessarily be available on the Purchase Order template. DBDetails confirms that available item-line fields vary across Sales Invoice, Delivery Note, Picking Ticket and Purchase Order reports.
Purchase Order Report Data Fields
The Purchase Order report provides data through the following data trees:
- DBBase
- DBDetails
- DBItemExtDesc
- jitSystemValues
For an overview of fields published to Basic Reports, see Basic Reports - Available Data Fields.
DBBase
DBBase normally contains the header-level information for the Purchase Order.
Available fields include:
- company_tax_ref
- calc_so_sorder_code
DBDetails
DBDetails contains information relating to individual item lines on the Purchase Order.
Available fields include:
- stock_other_ref
DBDetails is the item-line data source used by Basic Reports and Report Builder. Depending on the report, it makes stock and order-line information available to the report template.
DBItemExtDesc
DBItemExtDesc provides data relating to extended stock item descriptions.
jitSystemValues
jitSystemValues provides system values that can be made available to the report.
Address Fields
Basic Reports normally contain separate memo fields for the:
- Company Address
- Invoice To or Order To Address
- Deliver To Address
For Purchase Orders, the Invoice To address is referred to as the Order To address. Basic Reports - Address fields also documents the supplier address memo field used by Purchase Orders.
If a standard address memo field is not needed, it can be hidden in Report Builder. Do not delete standard address fields from the template.