Purchase Order Pending Report

This report shows pending purchase orders. Purchase order is pending if it has been authorized but the invoice for the ordered items has not been processed yet and/or stock is not received.



Input:

Following are input for this report



From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required report
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format


Output:

After setting inputs described above, when you press update button, report will refresh as per inputs selected. There are following output field available for this report



SKU
Product SKU, ordered but not yet fully billed.
Product
The name of the product, ordered but not yet fully billed.
PO #
Purchase Order Number the product is ordered by.
PO Date
Date of the purchase order.
Status
Purchase status.
Supplier
Supplier name who received the purchase order.
Ordered
Quantity of the product being ordered.
To Invoice
Quantity of the product not yet billed.
To Receive
Quantity of the product not yet received.
Year
Year of purchase order date.
Quarter
Quarter of purchase order date.
Month
Month of purchase order date.
Location
Location this purchase intended for.
Category
Product category.
Brand
Product brand.
Product Tags
Comma-separated product tags.
Family
Product family name.
Unit
Product unit of measure.
Required By
Date when stock is expected to be received.
Supplier Additional Attribute 1-10
Values of Additional supplier attributes.
Product Additional Attribute 1-10
Values of product additional attributes.


Purchase Order Details Report


This report shows details of purchase orders made during given period of time and, optionally, status of the invoice. User can see all products ordered during the period.


Input:

Following are input for this report




From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required report
Currency
Allow user to select Currency for report
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format


Output:

After setting inputs described above, when you press update button, report will refresh as per inputs selected. There are following output field available for this report



SKU
Product SKU
Product
The name of the product
PO #
Purchase Order Number the product is ordered by.
PO Date
Date of the purchase order.
Invoice #
Purchase Invoice Number.
Invoice Date
Invoice Date of the purchase order.
Status
Purchase status.
Supplier
Supplier name who received the purchase order.
Quantity
Ordered quantity.
Price
Ordered price (without discount).
Total
Line Total for the product.
Year
Year of purchase order date.
Quarter
Quarter of purchase order date.
Month
Month of purchase order date.
Location
Location this purchase intended for.
Category
Product category.
Brand
Product brand.
Product Tags
Comma-separated product tags.
Family
Product family name.
Unit
Product unit of measure.
Comment
 Invoice line comment.
Required By
Date when stock is need to be delivered.
Currency
Supplier currency code this purchase is created in.
PO Status
Purchase order status.
Invoice Status
Status of the invoice
Supplier Additional Attribute 1-10
Values of Additional supplier attributes.
Product Additional Attribute 1-10
Values of product additional attributes.


Purchase Order Summary Report

This report shows purchase orders made during given period of time and, optionally, status of the invoice.


Input:

Following are input for this report



From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required report
Currency
Allow user to select Currency for report
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format


Output:

After setting inputs described above, when you press update button, report will refresh as per inputs selected. There are following output field available for this report



Supplier
 Supplier name who received the purchase order.
PO #
 Purchase Order Number the product is ordered by.
PO Date
 Date of the purchase order.
Invoice Date
 Invoice Date of the purchase order.
Required By
 Date when purchase needs to be delivered.
Status
 Purchase status.
Order Total
 Total Ordered amount.
Invoice Total
 Total Billed amount. Includes Credit Note if any.
Paid Total
 Total Paid amount. Includes Credit Note refund if any.
Due
 Amount not yet paid. Due = Invoice Total - Paid Total
Year
 Year of purchase order date.
Quarter
 Quarter of purchase order date.
Month
 Month of purchase order date.
Currency
 Supplier currency code this purchase is created in.
Invoice #
 Invoice number assigned by supplier.
PO Status
 Purchase order status.
Invoice Status
 Status of the invoice
Supplier Additional Attribute 1-10
 Values of Additional supplier attributes.


Purchase Order vs Invoice Report


This report compares what has been ordered vs what has been invoiced. This will show all discrepancies between invoices and purchase orders.


Input:

Following are input for this report


From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required report
Currency
Allow user to select Currency for report
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format


Output:

After setting inputs described above, when you press update button, report will refresh as per inputs selected. There are following output field available for this report


SKU
 Product SKU.
Product
 The name of the product.
PO #
 Purchase Order Number the product is ordered by.
Supplier
 Supplier name who received the purchase order.
Order Quantity
 Ordered quantity.
Invoice Quantity
 Invoiced quantity.
Diff Quantity
 Difference between Invoiced and Ordered quantity.
Order Price
 Purchase order price without discount.
Invoice Price
 Invoice price without discount.
Diff Price
 Difference between Invoice and Order price.
Order Total
 Purchase order line total.
Invoice Total
 Purchase invoice line total.
Diff Total
 Difference between Invoice and Order line total.
Year
 Year of purchase order date.
Quarter
 Quarter of purchase order date.
Month
 Month of purchase order date.
Location
 Location this purchase intended for.
Category
 Product category.
Brand
 Product brand.
Product Tags
 Comma-separated product tags.
Family
 Product family name.
Unit
 Product unit of measure.
Currency
 Supplier currency code this purchase is created in.
Supplier Additional Attribute 1-10
 Values of Additional supplier attributes.
Product Additional Attribute 1-10
 Values of product additional attributes.


Stock Received Not Invoiced Report

This report displays Stock received via Purchase but not yet invoiced/billed filtered by Date Received. Un-invoiced receipts are products you have received that your supplier did not invoice yet.


Input:

Following are input for this report


From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required report
Currency
Allow user to select Currency for report
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format


Output:

After setting inputs described above, when you press update button, report will refresh as per inputs selected. There are following output field available for this report.


SKU
 Product SKU.
Product
 Product name.
PO #
 Purchase Order Number identifying the purchase.
PO Date
 Date of the purchase order.
Received Date
 Date when stock was received.
Supplier
 Supplier name.
Quantity
 Quantity of the product received.
Cost
 Cost of 1 unit of product from Purchase Order.
Total
 Total = Cost * Quantity.
Required By
 Date when purchase needs to be delivered.
Location
 Location this purchase intended for.
Category
 Product category.
Brand
 Product brand.
Product Tags
 Comma-separated product tags.
Family
 Product family name.
Unit
 Product unit of measure.


Purchase Invoice Details Report

This report shows purchase invoice details. User can see all products invoiced during given period of time.


Input:

Following are input for this report


From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required report
Currency
Allow user to select Currency for report
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format


Output:

After setting inputs described above, when you press update button, report will refresh as per inputs selected. There are following output field available for this report.


SKU
 Product SKU.
Product
 The name of the product.
PO #
 Purchase order number identifying the purchase.
Invoice #
 Purchase invoice number.
Invoice Date
 Date when Invoice was created.
Status
 Purchase status.
Supplier
 Supplier name who issued the invoice.
Quantity
 Invoiced quantity.
Price
 Invoice price (without discount).
Total
 Line Total for the product.
Year
 Year of invoice date.
Quarter
 Quarter of invoice date.
Month
 Month of invoice date.
Location
 Location this purchase intended for.
Category
 Product category.
Brand
 Product brand.
Product Tags
 Comma-separated product tags.
Family
 Product family name.
Unit
 Product unit of measure.
Comment
 Invoice line comment.
Required By
 Date when purchase needs to be delivered.
Currency
 Supplier currency code this purchase is created in.
Invoice Status
 Status of the invoice
Supplier Additional Attribute 1-10
 Values of Additional supplier attributes.
Product Additional Attribute 1-10
 Values of product additional attributes.


Purchase Invoice Summary Report

This report shows invoice and credit notes summaries for given period including outstanding payment amounts.


Input:

Following are input for this report


From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required report
Currency
Allow user to select Currency for report
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format


Output:

After setting inputs described above, when you press update button, report will refresh as per inputs selected. There are following output field available for this report.


PO #
 Purchase Order Number the product is ordered by.
Invoice #
 Invoice number assigned by supplier.
Supplier
 Supplier name who issued the invoice.
Invoice Date
 Date when Invoice was created.
Status
 Purchase status.
Invoice Total
 Total billed amount. Includes Credit Note if any.
Paid Total
 Total paid amount. Includes Credit Note refund if any.
Due
 Amount not yet paid. Due = Invoice Total - Paid Total
Year
 Year of invoice date.
Quarter
 Quarter of invoice date.
Month
 Month of invoice date.
Currency
 Supplier currency code this purchase is created in.
Invoice Due Date
 Date when Invoice is due.
Required By
 Date when purchase needs to be delivered.
Invoice Status
 Status of the invoice
Supplier Additional Attribute 1-10
 Values of Additional supplier attributes.


Stock Received vs Invoice Report

This report compares stock received vs invoice. User can see what has been received but not invoiced or what has been invoiced but not received.


Input:

Following are input for this report


From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required report
Currency
Allow user to select Currency for report
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format


Output:

After setting inputs described above, when you press update button, report will refresh as per inputs selected. There are following output field available for this report.


SKU
 Product SKU.
Product
 Product name.
PO #
 Purchase Order Number identifying the purchase.
Invoice #
 Invoice Number issued by supplier.
Invoice Date
 Date of the invoice.
Received Date
 Date when stock was received.
Supplier
 Supplier name.
Received
 Quantity of the product received.
Invoiced
 Quantity of the product invoiced.
PO Total
 Purchase Order Total for the product received excluding tax.
Required By
 Date when purchase needs to be delivered.
Invoice Due Date
 Date when Invoice is due.
Invoice Status
 Status of the invoice.
Stock Status
 Status of the stock received.
Status
 Purchase status.
Location
 Location this purchase intended for.
Category
 Product category.
Brand
 Product brand.
Product Tags
 Comma-separated product tags.
Family
 Product family name.
Unit
 Product unit of measure.


Purchase Cost Analysis Report

Purchase cost analysis report detailing costs associated with purchasing every product during given period of time.


Input:

Following are input for this report


From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required report
Currency
Allow user to select Currency for report
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format


Output:

After setting inputs described above, when you press update button, report will refresh as per inputs selected. There are following output field available for this report.


Supplier
 Supplier name.
PO #
 Purchase order number identifying the purchase.
Invoice #
 Purchase invoice number.
SKU
 Unique product stock keeping unit.
Product
 Name of the product.
Location
 Location product is received at.
Batch #
 Batch or Serial number associated with stock received.
Quantity
 Received quantity minus unstock quantity if any.
Main Cost
 Main invoice cost for the batch.
Additional Cost
 Portion of additional costs distributed to the batch.
Journals
 Portion of additional not capitalised costs distributed to the batch.
Tax
 Tax amount combining both main invoice and portion of additional costs associated with the batch.
Currency
 Supplier currency code this purchase is created in.
Category
 Product category.
Brand
 Product brand.
Product Tags
 Comma-separated product tags.
Family
 Product family name.
Unit
 Product unit of measure.
Supplier SKU
 Product stock keeping unit assigned by supplier.
Supplier Product
 Product name assigned by supplier.
Order Date
 Date when purchase was created.
Expiry Date
 Date when current product batch expires.
Status
 Purchase status.
Year
 Year of invoice date.
Quarter
 Quarter of invoice date.
Month
 Month of invoice date.
Supplier Additional Attribute 1-10
 Values of Additional supplier attributes.
Product Additional Attribute 1-10
 Values of product additional attributes.


Supplier Financial Summary Report

This report indicates summaries of all financial transactions for every supplier including opening and closing balances for each supplier.


Input:

Following are input for this report


From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required report
Currency
Allow user to select Currency for report
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format


Output:

After setting inputs described above, when you press update button, report will refresh as per inputs selected. There are following output field available for this report.


Supplier
 Supplier name.
Invoice Date
 Date when Invoice was created.
Opening Balance
 Opening balance of the supplier on From date.
Invoice Total
 Totals of invoices for the period.
Paid Total
 Total paid amount for the period.
Closing Balance
 Closing balance for the supplier
Supplier Additional Attribute 1-10
 Values of Additional supplier attributes.


Product Prices By Supplier

This report shows product’s last price & Fixed price by all suppliers from which PO has been issued.


Output:

Following are columns of output report, this report can be exported as Excel csv.


Product
 Product SKU.
Category
 Product category.
Supplier
 The name of supplier.
Supplier SKU
 Product SKU as specified by Supplier.
Supplier Product Name
 Product Name as specified by Supplier.
URL
 URL of web page describing the product on supplier's web site.
Latest Price
 Latest Price of product excluding discount from most recent purchase invoice of Supplier.
Fixed Price
 Fixed Price of product defined by Supplier.
Drop Ship
Drop shipment provide by Supplier Yes/No


Inventory Suppliers Report

This report shows suppliers for all products.


Input:

Following are input for this report


From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required report
Currency
Allow user to select Currency for report
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format


Output:

After setting inputs described above, when you press update button, report will refresh as per inputs selected. There are following output field available for this report.


SKU
 Product SKU.
Product
 The name of product in DEAR.
Supplier
 The name of supplier.
Supplier SKU
 Product SKU as specified by Supplier.
Supplier Product Name
 Product Name as specified by Supplier.
Latest Price
 Latest Price of product excluding discount from most recent purchase invoice of Supplier.
Fixed Price
 Fixed Price of product defined by Supplier.
Category
 Product category.
Brand
 Product brand.
Product Tags
 Comma-separated product tags.
Family
 Product family name.
Unit
 Product unit of measure.
Supplier Product URL
 URL of web page describing the product on supplier's web site.
Supplier Additional Attribute 1-10
 Values of additional supplier attributes.
Product Additional Attribute 1-10
 Values of additional product attributes.


Outstanding Quotes Report

This report shows all authorised quotes without authorised sale order/invoice issued during specified time interval.


Input:

Following are input for this report


From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required report
Currency
Allow user to select Currency for report
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format


Output:

After setting inputs described above, when you press update button, report will refresh as per inputs selected. There are following output field available for this report.


Order #
 Sale Order Number identifying the quote.
Customer
 Customer name.
Sales Representative
 Company sales representative responsible for the quote.
SKU
 Product SKU.
Product
 The name of the product.
Unit
 Product unit of measure.
Quantity
 Quoted quantity.
Total
 Line Total for the product including tax.
Date
 Date when quote was issue.
Year
 Year of quote issue date.
Quarter
 Quarter of quote issue date.
Month
 Month of quote issue date.
Location
 Location this sale will be dispatched from.
Category
 Product category.
Brand
 Product brand.
Product Tags
 Comma-separated product tags.
Family
 Product family name.
Customer Tags
 Comma-separated customer tags.
Currency
 Currency code this quote is created in.


Sale Overview Report

This report shows overview of all sales filtered by sale order date. It shows COGS and Payment information even if effective date is outside of From - To date range.


Input:

Following are input for this report


From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required report
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format


Output:

After setting inputs described above, when you press update button, report will refresh as per inputs selected. There are following output field available for this report.


Order #
 Sale Order Number identifying the sale.
Invoice #
 Invoice Number identifying sale invoice.
Customer
 Customer name.
Order Date
 Sale order date.
Status
 Sale status. The same as can be seen on Sales List.
Ready For Shipment
 Indicates if sale has been shipped, ready or not ready to be shipped.
Invoice
 Total of invoice - Total of credit note including tax in base currency.
Sale
 Total of invoice - Total of credit note excluding tax in base currency.
Paid
 Total Paid - Total Refunded in base currency.
Due
 Due amount = Invoice - Paid. In base currency.
COGS
 Cost of Goods Sold in base currency.
Journals
 Total of all Additional Transactions associated with the sale in base currency.
Profit
 Profit = Invoice - COGS. In base currency.
FX Gain/Loss
 Foreign Exchange gains and losses.
Invoice Date
 Invoice issue date.
Due Date
 Date when invoice is due for payment.
Sales Representative
 Name of sales representative associated with the sale.
Ship By
 Date when order needs to be shipped.
Customer Reference
 Customer reference.
Country
 Shipment address country.
State
 Shipment address state.
City
 Shipment address city.
Postcode
 Shipment address postcode.
Shipping Address 1
 Shipment address line 1.
Customer Tags
 Comma-separated customer tags.
Credit Note #
 Credit note number.
Quote Status
 Status of the quote.
Sale Order Status
 Status of the order.
Pick Status
 Status of the picking.
Pack Status
 Status of the packing.
Ship Status
 Status of the shipment.
Invoice Status
 Status of the invoice.
Credit Note Status
 Status of the credit note.
Notes
 Sale Notes.


Sale Order Details Report

This report shows sale order details for authorised sale orders filtered by sale order date.


Input:

Following are input for this report


From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required report
Currency
Allow user to select Currency for report
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format


Output:

After setting inputs described above, when you press update button, report will refresh as per inputs selected. There are following output field available for this report.


SKU
 Product SKU.
Product
 The name of the product.
Order #
 Sale Order Number identifying sale order.
Order Date
 Sale Order Date.
Customer
 Customer name.
Location
 Default location selected for sale.
Status
 Status of sale.
Quantity
 Quantity of the product ordered (doesn't include restocked quantity.
Discount
 Average Discount applied.
Tax
 Tax calculated for line.
Total
 Total amount invoiced with tax.
Sale
 Total amount excluding tax.
Customer Tags
 Comma-separated customer tags.
Unit
 Product unit of measure.
Category
 Product category.
Brand
 Product brand.
Product Tags
 Comma-separated product tags.
Family
 Product family name.
Invoice Status
 Status of the Invoice in sale.
Invoice Date
 Invoice issue date.
Invoice #
 Invoice Number identifying sale invoice.
Ship by
 Date when order is to be shipped.
Country
 Shipment address country.
State
 Shipment address state.
City
 Shipment address city.
Postcode
 Shipment address postcode.
Shipping Address 1
 Shipment address line 1.
Sales Representative
 Name of sales representative associated with the sale.
Customer Reference
 Customer Reference associated with the sale.
Product Additional Attribute 1-10
 Values of product additional attributes.
Customer Additional Attribute 1-10
 Values of customer additional attributes.


Pending Sale Orders Report

This report shows all authorised sale orders without authorised pick issued during specified time interval.


Input:

Following are input for this report


From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required report
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format


Output:

After setting inputs described above, when you press update button, report will refresh as per inputs selected. There are following output field available for this report.


Order #
 Sale Order Number identifying the sale.
Customer
 Customer name.
Sales Representative
 Company sales representative responsible for the sale.
SKU
 Product SKU.
Product
 The name of the product.
Unit
 Product unit of measure.
Quantity Required
 Ordered quantity.
Date
 Date of sale order.
Year
 Year of sale order date.
Quarter
 Quarter of sale order date.
Month
 Month of sale order date.
Location
 Location this sale will be dispatched from.
Category
 Product category.
Brand
 Product brand.
Product Tags
 Comma-separated product tags.
Family
 Product family name.
Customer Tags
 Comma-separated customer tags.
Currency
 Currency code this sale is created in.
Customer Reference
 Sale customer reference.
Ship by
 Ship by date.
Product Additional Attribute 1-10
 Values of product additional attributes.
Customer Additional Attribute 1-10
 Values of customer additional attributes.


Sale Profit Summary Report

This report shows profit and additional financial summary for sales.


Input:

Following are input for this report


From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required report
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format

 

Output:

After setting inputs described above, when you press update button, report will refresh as per inputs, there are following output field available for this report 


Customer
 Customer name.
Order #
 Sale Order Number identifying the sale.
Invoice #
 Invoice Number identifying sale invoice.
Invoice Date
 Invoice issue date.
Credit Note Date
 Credit Note issue date.
Shipment Date
 Date of the shipment.
Invoice
 Total of invoice - Total of credit note including tax in base currency.
Sale
 Total of invoice - Total of credit note excluding tax in base currency.
Paid
 Total Paid - Total Refunded in base currency.
Due
 Due amount = Invoice - Paid. In base currency.
COGS
 Cost of Goods Sold in base currency.
Journals
 Total of all Additional Transactions associated with the sale in base currency.
Profit
 Profit = Invoice - COGS. In base currency.
Gross Margin
 Gross Margin = (Sale - COGS) * 100 / Sale. In base currency. If Sale or COGS is 0 it will show as N/A.
Markup
 Markup = Gross Margin / (1 - Gross Margin). In base currency. If Sale or COGS is 0 it will show as N/A.
FX Gain/Loss
 Foreign Exchange gains and losses.
Customer Tags
 Comma-separated customer tags.
Sales Representative
 Name of sales representative associated with the sale.
Ship By
 Date when order needs to be shipped.
Due Date
 Date when invoice is due for payment.
Country
 Shipment address country.
State
 Shipment address state.
City
 Shipment address city.
Postcode
 Shipment address postcode.
Shipping Address 1
 Shipment address line 1.


Profit by Sales Representatives Report

This report shows profit and additional financial summary by sales representatives.


Input:

Following are input for this report


From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required report
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format

 

Output:

After setting inputs described above, when you press update button, report will refresh as per inputs, there are following output field available for this report 


Sales Representative
 Name of sales representative associated with the sale.
Customer
 Customer name.
Invoice #
 Invoice Number identifying sale invoice.
Invoice Date
 Invoice issue date.
Due Date
 Date when invoice is due for payment.
Credit Note Date
 Credit Note issue date.
Shipment Date
 Date of the shipment.
Invoice Lines
 Total of invoice lines - Total of credit note lines including tax in base currency.
Lines Tax
 Combined tax amount for all lines in invoice (excluding additional charges) in base currency.
Additional Charges
 Total of invoice additional charges - Total of credit note additional charges including tax in base currency.
Additional Charges Tax
 Combined tax amount for all additional charges in invoice in base currency.
Total Invoice
 Total of invoice - Total of credit note including tax in base currency.
Sale
 Total of invoice without taxes in base currency.
Paid
 Total Paid - Total Refunded in base currency.
Due
 Due amount = Invoice - Paid. In base currency.
COGS
 Cost of Goods Sold in base currency.
Journals
 Total of all Additional Transactions associated with the same in base currency.
Profit
 Profit = Invoice - COGS. In base currency.
FX Gain/Loss
 Foreign Exchange gains and losses.
Gross Margin
 Gross Margin = (Sale - COGS) * 100 / Sale. In base currency. If Sale or COGS is 0 it will show as N/A.
Markup
 Markup = Gross Margin / (1 - Gross Margin). In base currency. If Sale or COGS is 0 it will show as N/A.
Customer Tags
 Comma-separated customer tags.
Ship By
 Date when order needs to be shipped.
Country
 Shipment address country.
State
 Shipment address state.
City
 Shipment address city.
Postcode
 Shipment address postcode.
Shipping Address 1
 Shipment address line 1.
Customer Reference
 Sale Customer Reference.
Status
 Sale status.


Sales By Product Details Report

This report shows quantities, profit and additional financial summary for sales by product.


Input:

Following are input for this report


From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required report
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format

 

Output:

After setting inputs described above, when you press update button, report will refresh as per inputs, there are following output field available for this report 


SKU
 Product SKU.
Product
 The name of the product.
Order #
 Sale Order Number identifying the sale.
Order Date
 Sale Order date.
Invoice #
 Invoice Number identifying sale invoice.
Invoice Date
 Invoice issue date.
Credit Note Date
 Credit Note issue date.
Shipment Date
 Date of the shipment.
Customer
 Customer name.
Sales Representative
 Name of sales representative associated with the sale.
Quantity
 Quantity of the product sold (by invoice - credit note restock).
Weight
 Weight of the product Quantity.
Invoice
 Invoice Line Total - Credit Note Line Total including tax in base currency. Will include "Invoice Line Total" only when Invoice Date is within specified From - To date range
Sale
 Invoice Line Total - Credit Note Line Total excluding tax in base currency. Will include "Invoice Line Total" only when Invoice Date is within specified From - To date range
Tax
 Invoice Line Tax - Credit Note Tax in base currency. Will include "Invoice Line Tax" only when Invoice Date is within specified From - To date range
COGS
 Cost of Goods Sold in base currency = Invoice COGS - Credit Note COGS. Will include Invoice COGS only when Max Ship date from Ship tab is within specified From - To date range. Will include -Credit Note COGS only when Credit Note date is within specified From - To date range.
Journals
 Total of all Additional Transactions associated with the sale in base currency distributed by invoice lines using Total amount
Profit
 Profit = Invoice - COGS - Tax. In base currency.
Customer Tags
 Comma-separated customer tags.
Unit
 Product unit of measure.
Category
 Product category.
Brand
 Product brand.
Product Tags
 Comma-separated product tags.
Family
 Product family name.
Invoice Status
 Status of the Invoice in sale.
Shipment Status
 Shipment status in Sale.
Country
 Shipment address country.
State
 Shipment address state.
City
 Shipment address city.
Postcode
 Shipment address postcode.
Shipping Address 1
 Shipment address line 1.
Product Additional Attribute 1-10
 Values of product additional attributes.
Customer Additional Attribute 1-10
 Values of customer additional attributes.


Sales By Product Summary Report

This report shows quantities, profit and additional financial summary for sales by product.


Input:

Following are input for this report


From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required report
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format

 

Output:

After setting inputs described above, when you press update button, report will refresh as per inputs, there are following output field available for this report 


SKU
 Product SKU.
Product
 The name of the product.
Unit
 Product unit of measure.
Customer
 Customer name.
Sales Representative
 Name of sales representative associated with the sale.
Quantity
 Quantity of the product sold (by invoice - credit note restock).
Weight
 Weight of the product Quantity.
Invoice
 Invoice Line Total - Credit Note Line Total including tax in base currency. Will include "Invoice Line Total" only when Invoice Date is within specified From - To date range
Sale
 Invoice Line Total - Credit Note Line Total excluding tax in base currency. Will include "Invoice Line Total" only when Invoice Date is within specified From - To date range
Tax
 Invoice Line Tax - Credit Note Tax in base currency. Will include "Invoice Line Tax" only when Invoice Date is within specified From - To date range
COGS
 Cost of Goods Sold in base currency = Invoice COGS - Credit Note COGS. Will include Invoice COGS only when Max Ship date from Ship tab is within specified From - To date range. Will include -Credit Note COGS only when Credit Note date is within specified From - To date range.
Journals
 Total of all Additional Transactions associated with the sale in base currency distributed by invoice lines using Total amount
Profit
 Profit = Invoice - COGS. In base currency.
Customer Tags
 Comma-separated customer tags.
Category
 Product category.
Brand
 Product brand.
Product Tags
 Comma-separated product tags.
Family
 Product family name.


Sale Price History Report

This report shows sale price fluctuations for all active products by location and price tier.


Input:

Following are input for this report


From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required report
Currency
Allow user to select Currency for report
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format

 

Output:

After setting inputs described above, when you press update button, report will refresh as per inputs, there are following output field available for this report 


SKU
 Product SKU.
Product
 The name of the product.
Unit
 Product unit of measure.
Invoice Date
 Date when price changed to new value.
Price
 Price without discount in customer currency specified in Currency field.
Year
 Year of price change date.
Quarter
 Quarter of price change date.
Month
 Month of price change date.
Location
 Location this sale is dispatched from.
Category
 Product category.
Brand
 Product brand.
Product Tags
 Comma-separated product tags.
Family
 Product family name.
Currency
 Currency code this quote is created in.
Price Tier
 Name of the price tier the sale is made in.


Backorder Details Report

This report shows all authorized sale orders with not yet shipped backordered lines.


Input:

Following are input for this report


Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format

 

Output:

After setting inputs described above, when you press update button, report will refresh as per inputs, there are following output field available for this report 


Order #
 Sale Order Number identifying the sale.
Customer
 Customer name.
Sales Representative
 Company sales representative responsible for the sale.
SKU
 Product SKU.
Product
 The name of the product.
Ship By
 Ship goods by this date.
Quantity Required
 Ordered quantity.
Location
 Location this sale will be dispatched from.
Category
 Product category.
Brand
 Product brand.
Product Tags
 Comma-separated product tags.
Family
 Product family name.
Customer Tags
 Comma-separated customer tags.
Unit
 Product unit of measure.
Date
 Date of sale order.


Backorder Summary Report

This report shows summary of all backordered sales.


Input:

Following are input for this report


Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format

 

Output:

After setting inputs described above, when you press update button, report will refresh as per inputs, there are following output field available for this report 


SKU
 Product SKU.
Product
 The name of the product.
Unit
 Product unit of measure.
Supplier
 Supplier name.
Quantity Required
 Backordered quantity.
Quantity On Hand
 Current quantity on hand.
Quantity Remaining
 Currently available quantity.
Quantity Ordered
 Already ordered quantity.
Location
 Location name.
Category
 Product category.
Brand
 Product brand.
Product Tags
 Comma-separated product tags.
Family
 Product family name.


Find Sale By Purchase Order Report

This report allows to find all sales included in specific purchase order created via Reorder Backordered function.


Input:

Following are input for this report


Only not shipped sales
Option to select Only not shipped sales or all Sales
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format

 

Output:

After setting inputs described above, when you press update button, report will refresh as per inputs, there are following output field available for this report 


Purchase Order #
 Purchase order number identifying purchase order created via Reorder Backordered function.
Purchase Invoice #
 Invoice number issued by supplier.
Invoice #
 Invoice Number identifying sale invoice.
Supplier
 Supplier name.
Stock Received
 "Yes" if Stock Received is authorised on Purchase, "No" otherwise.
Sale Order #
 Sale order number identifying backordered sale.
Sale Order Date
 Date of sale order.
Sale Invoice #
 Sale invoice number identifying backordered sale invoice.
Customer
 Customer name.
Customer Reference
 Reference provided to the customer.
Sales Representative
 Sales representative associated with the sale.
Ship By
 Ship your sale by this date.
Ready for Shipment
 Indication if sale is ready to be fully picked and shipped.
Supplier Additional Attribute 1-10
 Values of Additional supplier attributes.
Customer Additional Attribute 1-10
 Values of Additional customer attributes.


Customer Payment Details Report

This report shows payment details by customer with invoiced, Paid and still Due amount.


Input:

Following are input for this report


From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required report
Currency
Allow user to select Currency for report
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format

 

Output:

After setting inputs described above, when you press update button, report will refresh as per inputs, there are following output field available for this report 


Customer
 Customer name.
Invoice #
 Invoice Number identifying sale invoice.
Invoice Date
 Invoice issue date.
Due Date
 Date when invoice is due for payment.
Sales Representative
 Name of sales representative associated with the sale.
Invoice Total
 Total of invoice - Total of credit note including tax.
Paid
 Total Paid - Total Refunded.
Due
 Due amount = Invoice - Paid - FX Gain/Loss.
FX Gain/Loss
 Foreign Exchange gains and losses.
Year
 Year of invoice date.
Quarter
 Quarter of invoice date.
Month
 Month of invoice date.
Customer Tags
 Comma-separated customer tags.
Customer Reference
 Additional reference provided to customer to identify the sale.
Country
 Shipment address country.
State
 Shipment address state.
City
 Shipment address city.
Postcode
 Shipment address postcode.
Shipping Address 1
 Shipment address line 1.


Customer Payment Summary Report

This report shows payment details by customer with invoiced, Paid and still Due amount.


Input:

Following are input for this report


From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required report
Currency
Allow user to select Currency for report
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format

 

Output:

After setting inputs described above, when you press update button, report will refresh as per inputs, there are following output field available for this report 


Customer
 Customer name.
Last Invoice Date
 Last invoice date with in specified From - To period.
Last Payment Date
 Last Date payment/refund was processed with in specified From - To period.
Invoice Total
 Summary of all invoiced and credited amounts including tax.
Paid
 Summary of all received and refunded amounts for the period.
Due
 Due amount = Invoice - Paid - FX Gain/Loss.
FX Gain/Loss
 Foreign Exchange gains and losses for the period.
Customer Tags
 Comma-separated customer tags.


Customer Orders by Product Report

This report shows detailed financial and quantity-related information about each product sold.


Input:

Following are input for this report


From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required report
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format

 

Output:

After setting inputs described above, when you press update button, report will refresh as per inputs, there are following output field available for this report 


SKU
 Product SKU.
Product
 The name of the product.
Invoice #
 Invoice Number identifying sale invoice.
Invoice Date
 Invoice issue date.
Customer
 Customer name.
Location
 Name of the location from where goods were picked/dispatched.
Quantity
 Quantity of the product sold (by invoice - credit note restock).
Invoice
 Invoice Line Total - Credit Note Line Total including tax in base currency.
Sale
 Invoice Line Total - Credit Note Line Total excluding tax in base currency.
Tax
 Invoice Line Tax - Credit Note Tax in base currency.
Discount
 Average Discount applied to invoice line.
COGS
 Cost of Goods Sold in base currency = Invoice COGS - Credit Note COGS. Will include Invoice COGS only when Max Ship date from Ship tab is within specified From - To date range. Will include -Credit Note COGS only when Credit Note date is within specified From - To date range.
Journals
 Total of all Additional Transactions associated with the sale in base currency distributed by invoice lines using Total amount
Profit
 Profit = Invoice - COGS. In base currency.
Customer Tags
 Comma-separated customer tags.
Unit
 Product unit of measure.
Category
 Product category.
Brand
 Product brand.
Product Tags
 Comma-separated product tags.
Family
 Product family name.
Invoice Status
 Status of the Invoice in sale.
Shipment Status
 Shipment status in Sale.
Country
 Shipment address country.
State
 Shipment address state.
City
 Shipment address city.
Postcode
 Shipment address postcode.
Sales Representative
 Name of sales representative associated with the sale.
Customer Reference
 Customer Reference associated with the sale.


Sale Credit Notes By Product Report


This report shows detailed financial and quantity-related information about each sale credit note.


Input:

Following are input for this report


From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required report
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format

 

Output:

After setting inputs described above, when you press update button, report will refresh as per inputs, there are following output field available for this report 


SKU
 Product SKU.
Product
 The name of the product.
Invoice #
 Invoice Number identifying sale invoice.
Credit Note #
 Credit Note Number identifying sale credit note.
Credit Note Date
 Credit Note issue date.
Invoice Date
 Invoice issue date.
Customer
 Customer name.
Location
 Name of the location from where goods were picked/dispatched.
Quantity
 Quantity of the product credited.
Credited
 Credit Note Line Total including tax in base currency.
Sale
 Credit Note Line Total excluding tax in base currency.
Discount
 Average Discount applied to credit note line.
COGS
 Cost of Goods Sold in base currency = Credit Note COGS.
Invoice Due Date
 Invoice due date.
Customer Tags
 Comma-separated customer tags.
Unit
 Product unit of measure.
Category
 Product category.
Brand
 Product brand.
Product Tags
 Comma-separated product tags.
Family
 Product family name.
Country
 Shipment address country.
State
 Shipment address state.
City
 Shipment address city.
Postcode
 Shipment address postcode.
Sales Representative
 Name of sales representative associated with the sale.
Customer Reference
 Customer Reference associated with the sale.


Product Availability

This report shows availability status of inventory items.


Input:

Following are input for this report


Refresh
Refresh button for the report
Export
This button will allow user to export report data in Excel
Print
Allow user to Print Labels for selected products

 

Output:

Following are the output fields of the report


Category
 Product category.
Product
 The name of the product.
Location
 Location this sale will be dispatched from.
Bin
Shows Bin in which Product is placed
Batch/Serial #
Batch or Serial Number of Product
Expiry Date
Expiry Date of Product
Stock Value
Value of Stock
On Hand
Quantity on Hand
Available
Quantity Available for Sale
On Order
Quantity for which Purchase Order has been places with suppliers
Allocated
Quantity for which order has been received from customer i.e. quantity allocated to sale orders


Inventory Movement Details Report

This report shows all stock movements in specified date interval. "Filter by" defines what dates are used as a base stock movement date or transaction effective date.


Input:

Following are input for this report


From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required report
Filter by
Allow user to either filter by Stock Movement Date or by Transaction Effective Date
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format

 

Output:

After setting inputs described above, when you press update button, report will refresh as per inputs, there are following output field available for this report 


SKU
 Product SKU.
Product
 The name of the product.
Unit
 Product unit of measure.
Location
 Location name.
Bin
 Bin where stock is located within Location.
Type
 Type of movement. In or Out of the location.
Reference
 Task Reference responsible for stock movement.
Date
 Effective date of stock movement
Quantity In
 Quantity of stock moved into the location
Quantity Out
 Quantity of stock moved out of the location
Cost In
 Cost of the stock moved into the warehouse in base currency.
Cost Out
 Cost of the stock moved out of the warehouse in base currency.
Year
 Year of effective date of stock movement.
Quarter
 Quarter of effective date of stock movement.
Month
 Month of effective date of stock movement.
Tags
 Comma-separated product tags.
Category
 Product category.
Brand
 Product brand.
Family
 Product family name.
Stock Locator
 Location in the warehouse.
Product Additional Attribute 1-10
 Values of product additional attributes.


Inventory Movement Summary Report


This report shows summary of stock movements in specified From - To timeframe together with stock on hand value on To date.


Input:

Following are input for this report


From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required report
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format

 

Output:

After setting inputs described above, when you press update button, report will refresh as per inputs


Location
 Location name.
SKU
 Product SKU.
Product
 The name of the product.
Unit
 Product unit of measure.
Quantity On Hand
 Quantity on hand on To date.
In
 Quantity of stock moved into the location within From - To time frame.
Out
 Quantity of stock moved out of the location within From - To time frame.
Unit Cost
 Unit cost of the stock on To date in base currency.
Stock On Hand
 Stock on hand on To date in base currency.
Tags
 Comma-separated product tags.
Category
 Product category.
Brand
 Product brand.
Family
 Product family name.
Volume On Hand
 Volume on hand now calculated as Product Height * Product Width * Product Length * Quantity On Hand.
Stock Locator
 Location in the warehouse.
Product Additional Attribute 1-10
 Values of product additional attributes.


Products Price List Report

This report shows product price list.


Input:

Following are input for this report


Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format

 

Output:

Following are the output fields of the report


SKU
 Product SKU.
Product
 The name of the product.
Unit
 Product unit of measure.
Category
 Product category.
Brand
 Product brand.
Price Tiers 1 to 10
 Prices in Customer Currency for all price tiers. Price Tier names can be changed on General Settings page.
Family
 Product family name.
Family Option 1 Value
 Value of Option 1 of this product in product family.
Family Option 1 Name
 Name of Option 1 of product family the product belongs to. Can be added to report via More Fields button.
Family Option 2 Value
 Value of Option 2 of this product in product family.
Family Option 2 Name
 Name of Option 2 of product family the product belongs to. Can be added to report via More Fields button.
Family Option 3 Value
 Value of Option 3 of this product in product family.
Family Option 3 Name
 Name of Option 3 of product family the product belongs to. Can be added to report via More Fields button.
Tags
 Comma-separated product tags.
Stock Locator
 Location of the product within a warehouse.
Product Attribute 1-10
 Additional attributes 1 to 10 values of the product belonging to some attribute set. Can be added to report via More Fields button.
Weight
 Product Weight. Can be added to report via More Fields button.
Width
 Product Width. Can be added to report via More Fields button.
Height
 Product Height. Can be added to report via More Fields button.
Barcode
 Product Barcode. Can be added to report via More Fields button.
Average Cost
 Product Average Cost in base currency.
Product Additional Attribute 1-10
 Values of product additional attributes.


Products Stock Level Report

This report shows current stock level of all active products in all locations.


Input:

Following are input for this report


Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format

 

Output:

Following are the output fields of the report


Location
 Location name.
SKU
 Product SKU.
Product
 The name of the product.
Unit
 Product unit of measure.
Quantity On Hand
 Quantity on hand now.
Allocated
 Stock allocated by pending Production and Sale tasks.
On Order
 Stock ordered from suppliers/currently being manufactured.
Unit Cost
 Unit cost of the product stock now in base currency.
Stock On Hand
 Stock on hand now in base currency.
Tags
 Comma-separated product tags.
Category
 Product category.
Brand
 Product brand.
Family
 Product family name.
Reorder Quantity
 Quantity of the product to reorder as configured for the product.
Minimum Before Reorder
 Minimum stock level for the product to appear on Reorder stock form.
Volume On Hand
 Volume on hand now calculated as Product Height * Product Width * Product Length * Quantity On Hand.
Product Additional Attribute 1-10
 Values of product additional attributes.


Products Reordering Report

This report shows stock level details necessary for stock refill.


Input:

Following are input for this report


Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format

 

Output:

Following are the output fields of the report


Location
 Location name.
SKU
 Product SKU.
Product
 The name of the product.
Unit
 Product unit of measure.
Supplier
 Name of the supplier who is associated with the product.
Available
 Currently available stock.
On Order
 Stock on order.
Purchase Price
 Product Purchase price in Supplier currency.
Reorder Quantity
 Quantity of the product to reorder as configured for the product.
Minimum Before Reorder
 Minimum stock level for the product to appear on Reorder stock form.
Product Tags
 Comma-separated product tags.
Category
 Product category.
Brand
 Product brand.
Family
 Product family name.
Supplier Additional Attribute 1-10
 Values of Additional supplier attributes.
Product Additional Attribute 1-10
 Values of product additional attributes.


Products Low on Stock Report

This report shows products with stock levels below reorder point.


Input:

Following are input for this report


Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format

 

Output:

Following are the output fields of the report


Location
 Location name.
SKU
 Product SKU.
Product
 The name of the product.
Unit
 Product unit of measure.
Supplier
 Name of the supplier who is associated with the product.
Available
 Currently available stock.
On Order
 Stock ordered but not yet received.
Purchase Price
 Product Purchase price in Supplier currency.
Reorder Quantity
 Quantity of the product to reorder as configured for the product.
Minimum Before Reorder
 Minimum stock level for the product to appear on Reorder stock form.
Product Tags
 Comma-separated product tags.
Category
 Product category.
Brand
 Product brand.
Family
 Product family name.
Supplier Additional Attribute 1-10
 Values of Additional supplier attributes.
Product Additional Attribute 1-10
 Values of product additional attributes.


Inventory Aging Report

This report shows how long products stay in stock by time intervals.


Input:

Following are input for this report


Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format

 

Output:

Following are the output fields of the report


SKU
 Product SKU.
Product
 The name of the product.
Batch #
 Batch or Serial Number.
Expiry Date
 Expiry Date of the batch.
0-30 Days
 Quantity purchased 30 or less days ago.
30-60 Days
 Quantity purchased less than 60 days ago but more than 30 days ago.
60-90 Days
 Quantity purchased less than 90 days ago but more than 60 days ago.
90-120 Days
 Quantity purchased less than 120 days ago but more than 90 days ago.
120-150 Days
 Quantity purchased less than 150 days ago but more than 120 days ago.
150-180 Days
 Quantity purchased less than 180 days ago but more than 150 days ago.
Above 180 Days
 Quantity purchased more than 180 days ago.
Tags
 Comma-separated product tags.
Category
 Product category.
Brand
 Product brand.
Family
 Product family name.
Location
 Location name.
Bin
 Bin where stock is located within Location.
Unit
 Product unit of measure.
Product Additional Attribute 1-10
 Values of product additional attributes.


Lot Expiry Report

This report shows all product batches due to expire on specified date.


Input:

Following are input for this report


Lot expire before
Allow user to select a date i.e. Expiry date
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format

 

Output:

After setting inputs described above, when you press update button, report will refresh as per inputs, there are following output field available for this report 


SKU
 Product SKU.
Product
 The name of the product.
Location
 Location name.
Bin
 Bin where stock is located within Location.
Batch #
 Batch or Serial number to expire.
Expiry Date
 Batch expiry date.
Quantity On Hand
 Current quantity on hand on the batch.
Tags
 Comma-separated product tags.
Category
 Product category.
Brand
 Product brand.
Family
 Product family name.
Unit
 Product unit of measure.
Year
 Year of expiry date.
Quarter
 Quarter of expiry date.
Month
 Month of expiry date.
Product Additional Attribute 1-10
 Values of product additional attributes.


Lot Recall

This report shows Customers, Stock On hand and Suppliers of selected product & Batch#


Input:

Following are input for this report


Product
Allow user to select a Product
Batch / Lot / Serial Number
Allow user to select a batch/lot/serial number of above selected product

 

Output:

After setting inputs described above, when you press Show button, report will refresh as per inputs, there are following output field available for this report 


Customer
Shows list of Customers against whom a SO has been issued for the selected product & batch #
Customer
Customer’s name
Phone
Customer’s Phone number
E-mail
Customer’s e-mail
Address Line1
Customer’s Line 1
Address Line2
Customer’s Line 2
Task
SO number of Sale
SKU
SKU
Quantity
Quantity in SO
Stock On Hand
Shows Stock on Hand for selected product & Batch
Location
Location of the Product
Product
Product Name
Batch/Serial No
Batch / Serial Number of the product
Expiry Date
Expiry Date of the product
On Hand
Quantity on Hand
Allocated
Quantity Allocated to Sale orders
Suppliers
Shows list of Supplier to whom a PO has been issued for the selected product & batch #
Supplier
Supplier’s name
Phone
Supplier’s Phone number
E-mail
Supplier’s e-mail
Task
PO number of Purchase
Product
Product Name
Quantity
Quantity in PO


Job Costing Materials Report

This report shows materials used on the particular job during given period of time. It also indicates where this material were purchased if it came not from warehouse.


Input:

Following are input for this report


From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required report
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format


Output:

After setting inputs described above, when you press update button, report will refresh as per inputs selected. There are following output field available for this report


Job #
 Job number.
Customer
 Customer name the job is done for.
Date
 Date when expense happened.
Job
 Job description.
Status
 Status of the job.
SKU
 SKU of the product spent for the job.
Product
 Name of the product spent for the job.
Unit
 Product unit of measure.
Quantity
 Quantity used.
Price
 Product purchase price in base currency.
Tax
 Tax if any in base currency.
Total
 Total purchase invoice line without tax / Total manufacturing cost of the product.
Year
 Year of the date when expense happened.
Quarter
 Quarter of the date when expense happened.
Month
 Month of the date when expense happened.
Tags
 Comma-separated product tags.
Category
 Product category.
Brand
 Product brand.
Family
 Product family name.
Address
 Job address.
Contact
 Job contact details.
Supplier
 Supplier from whom materials were bought. Empty for Issue to Production and Finished Goods expenses.
Product Additional Attribute 1-10
 Values of product additional attributes.


Finished Goods Analysis Report

This report shows completed finished goods quantity and cost split by components/services.


Input:

Following are input for this report


From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required report
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format


Output:

After setting inputs described above, when you press update button, report will refresh as per inputs selected. There are following output field available for this report


Assembly #
 Assembly number.
Status
 Finished Goods task status. In progress and Authorised tasks are displayed regardless of the date range specified
Location
 Location of the assembly.
Assembled SKU
 SKU of the assembled product.
Assembled Product
 Name of the assembled product.
Component SKU
 SKU of the material/service used in production.
Component
 Name of the material/service used in production.
Type
 Type of component used in production. Services or Materials
Yield
 Actual yield of assembled product.
Production Cost
 Total cost of assembled product (for the quantity specified in Yield) in base currency.
Component Quantity
 Total quantity of the component used in production.
Component Cost
 Total cost of the component used in production.
Completion Date
 Date when Finished Goods task was completed.
Assembled Tags
 Tags associated with the assembled product.
Assembled Unit
 Unit of measure for the assembled product.
Assembled Category
 Category of the assembled product.
Assembled Brand
 Brand of the assembled product.
Assembled Family
 Family name of the assembled product.
Component Batch #
 Batch or serial number of the material used in production.
Year
 Year of assembly completion date.
Quarter
 Quarter of assembly completion date.
Month
 Month of assembly completion date.
Product Additional Attribute 1-10
 Values of product additional attributes.


Disassembly Analysis Report

This report shows completed dis-assemblies with quantity and cost split by components.


Input:

Following are input for this report


From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required report
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format


Output:

After setting inputs described above, when you press update button, report will refresh as per inputs selected. There are following output field available for this report


Disassembly #
 Disassembly number.
Location
 Location of the disassembly.
Assembled SKU
 SKU of the disassembled product.
Assembled Product
 Name of the disassembled product.
Component SKU
 SKU of the component produced from disassembly or Labour / Overhead used.
Component
 Name of the component produced from disassembly or Labour / Overhead used.
Type
 Type of component used in disassembly. Services or Materials
Disassembled Quantity
 How many of the product was disassembled.
Disassembled Cost
 Total cost of disassembled product (for the quantity specified in Disassembled Quantity) in base currency.
Services Cost
 Total cost of services included in the result value of Component Costs in base currency.
Component Quantity
 Total quantity of the component produced as a result of disassembly.
Component Cost
 Total cost of the component produced as a result of disassembly.
Date
 Date when Disassembly task was completed.
Dissembled Tags
 Tags associated with the disassembled product.
Dissembled Unit
 Unit of measure for the disassembled product.
Dissembled Category
 Category of the disassembled product.
Dissembled Brand
 Brand of the disassembled product.
Dissembled Family
 Family name of the disassembled product.
Component Batch #
 Batch or serial number of the component produced as a result of disassembly.
Year
 Year of disassembly completion date.
Quarter
 Quarter of disassembly completion date.
Month
 Month of disassembly completion date.
Product Additional Attribute 1-10
 Values of product additional attributes.


Balance Sheet Report

This report shows simple snapshot of all financial transactions happened within given period of time.


Input:

Following are input for this report


From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required report
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format


Output:

After setting inputs described above, when you press update button, report will refresh as per inputs selected. There are following output field available for this report


Account Class
 Ledger account class.
Account Code
 Ledger account code.
Job #
 Job number if applicable.
Opening Balance
 Opening balance for the account.
Debit
 All debit turnovers for the period.
Credit
 All credit turnovers for the period.
Closing Balance
 Closing balance for the account


Transactions Report

This report shows detailed financial transactions happened within given period of time.


Input:

Following are input for this report


From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required report
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format


Output:

After setting inputs described above, when you press update button, report will refresh as per inputs selected. There are following output field available for this report


Type
 Transaction type.
Reference
 Document reference.
Debit
 Debit account.
Credit
 Credit account.
Amount
 Value of transactions in base currency.
Description
 Transaction description.
Date
 Effective date of transaction
Debit Job #
 Debit sub-account of Job #
Credit Job #
 Credit sub-account of Job #


Transactions VS Stock On Hand Difference Report

This report shows difference between stock on hand and transactions on specified Effective Date. If there is no difference then this report will contain no data


Input:

Following are input for this report


Effective Date To
Allow user to select a date i.e. effective date of required report
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format


Output:

After setting inputs described above, when you press update button, report will refresh as per inputs selected. There are following output field available for this report


Task #
 Task number identifying task with detected difference.
Account
 Account name.
Transaction Type
 Type of the task.
Stock Amount
 Stock Value in base currency.
Document Amount
 Document Value in base currency.


Job Costing Profit & Loss Report

This report shows profit made for each job on every Expense/Sale within given period of time.


Input:

Following are input for this report


From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required report
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format


Output:

After setting inputs described above, when you press update button, report will refresh as per inputs selected. There are following output field available for this report


Job #
 Job number.
Customer
 Customer name the job is done for.
Job
 Job description.
Status
 Status of the job.
Milestone
 Job milestone profit/loss transaction is related to.
Type
 Type of profit/loss transaction.
Date
 Effective Date of profit/loss transaction.
Reference
 Transaction reference.
Expense
 Expense associated with the transaction in base currency without tax.
Tax
 Tax associated with the transaction in base currency.
Income
 Income associated with the transaction in base currency without tax.
Profit
 Profit = Income - Expense. Only visible in Totals
Tax
 Tax if any in base currency.
Address
 Job address.
Contact
 Job contact details.
Supplier
 Supplier name for transaction type "Purchase".
Start
 Date when job started.
Finish
 Date when job has been completed.
Year
 Year of Effective Date of profit/loss transaction.
Quarter
 Quarter of Effective Date of profit/loss transaction.
Month
 Month of Effective Date of profit/loss transaction.


 Profit & Loss By Product Report


This report shows profit made for each product within given period of time.


Input:

Following are input for this report


From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required report
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format


Output:

After setting inputs described above, when you press update button, report will refresh as per inputs selected. There are following output field available for this report


Location
 Location name.
SKU
 Product SKU.
Product
 The name of the product.
COGS
 Total cost of goods sold amount.
Sale Proceeds
 Sale proceeds for the product.
Production / Inventory / Transfer
 Cost of the product spent on non-sale transactions.
Profit
 Profit = "Sale Proceeds" + "Production / Inventory / Transfer" - "COGS".
Unit
 Product unit of measure.
Tags
 Comma-separated product tags.
Category
 Product category.
Brand
 Product brand.
Family
 Product family name.
Batch #
 Batch or Serial number.
Expiry Date
 Batch Expiry Date.
Year
 Year of stock movement date.
Quarter
 Quarter of stock movement date.
Month
 Month of stock movement date.
Product Additional Attribute 1-10
 Values of product additional attributes.