Show Reports

Show Reports Overview

The Show Reports function within SapphireOne Inventory Purchases Menu enables the user to set up a number of different report styles for different purposes. From the Purchase Menu the user has the ability to set up custom reoccurring reports as follows. Purchases by Vendor, Vendor Class, Item, Item Class, Project Class, Matrix, Serial/Batch and Purchases by Addition / Deduction.

It should be noted that the last item on the list, Fulfillment Summary, also includes a Shipping Summary, which has a slightly different report to the Fulfillment Summary. Check both reports and use the one that best suits your requirements accordingly.

All reports are created by using a simple selection of standard drop-down menus. Once the drop-down menu options have been selected the user can then select the dates or periods that the report is to encompass. All generated reports may be exported as a CSV file and may be opened by any external spreadsheet program. There is also is a Matrix report available that will display a report in a matrix style format. 

When the Show Reports option is selected this menu will be displayed, which currently has nine reports available. 

All reports are configured by using a standardised selection of drop-down menus.

Once the drop-down menu options have been selected the user can select the dates or periods that the report is to encompass.

All generated reports may be exported as a html or CSV file and may then be opened by any browser or external spreadsheet program. 

Show Reports (Purchases by Vendor)

In SapphireOne Purchases may be assigned to a specific Vendor. This functionality allows for additional reporting to be done using Purchases by Vendor. The SapphireOne user is then able to take advantage of this with a Purchases by Vendor based report.

Overview

This Show Report displays the total Purchases made from each Vendor for the selections as made by the user in the Query and Display settings areas.

When any alterations or changes are made to any settings in these reports, the Recalculate button must be selected each time. SapphireOne then re-calculates the report and displays the new details.

Setup Options Purchases by Vendor

Query Settings
  • Range – This may be Date based or Period based. A button located at the bottom left hand corner of the screen Use Period Button, acts as a toggle enabling the user to swap between date and period based reports. By Default SapphireOne will set the range to Date and This Month to Date. If period is selected, SapphireOne will display Periods for the From and To fields. The selection made here will populate the From and To fields with the appropriate dates or periods.
  • Range Selection – Either the From or To Dates or Periods may be directly entered by the user.
    • Date – Various date based options are available when the user selects the up/down arrows at the right of this drop-down menu. For example, Last Financial Year to Today’s Date Last Year. This will enable the user to compare last years sales figures to this years sales figures for the same time frame in last and current financial years.
    • Dates & Periods For a date driven report, the two date entry fields require the input of a date. Note that the date option has both the From and To underlined with a convenient pop-up calendar to pick dates from. For periods, directly enter the periods required accordingly.
  • Query Button – When any filtering of the report is required, for example, a Single Vendor, a detailed query may be performed for the Vendor by selecting the Query button. This then causes SapphireOne to display the detailed query pop-up. This enables the user to query for any item in SapphireOne.

Display Settings
  • Sort – This option allows the sorting of the items in the report. The options are ID, (Default), Name and Total. It should be noted that the small [>] button just to the right of the sort drop-down menu is used to invert the sort. It acts as a toggle reversing the sort order accordingly.
  • Column By – This option selects what data is included with each column. There are three options: The default of Total, Rep or Period. Select the report that best suits your requirements accordingly.
    • Total – This option provides a very simple report that displays the Vendor and to total sales selected by the user when making their selection from the Query and Display settings.
    • Rep – This option displays Purchases made by each Rep as selected by the user when selecting from the Query and Display settings.
    • Period – This option display Sales made on a period by period basis as selected by the user when selecting an option from the Query and Display settings.
  • Depart – Select All departments or select any Department in the company.
  • Recalculate – Every time a change is made to the report, the Recalculate button must then be selected. SapphireOne will then re-calculate the report. Any changes are displayed immediately in the report area as a result.

Footer Buttons
  • Export To html – Selecting this button will tell SapphireOne to export the report as a html file, which may be viewed with any web browser.
  • Export To CSV – Selecting this button will tell SapphireOne to export the report as a CSV file, which may be viewed with any spreadsheet program.
  • Print – If printing is required, select the Print button and the report will be printed immediately
Inventory-Sales-Show Report

Purchases by Vendor Class

Overview

In SapphireOne Vendors may be assigned to a specific class. This functionality allows for additional reporting to be done using the Vendors Class. The SapphireOne user is then able to take advantage of this with a Class based report.

When any alterations or changes are made to any settings in these reports, the Recalculate button must then be selected. SapphireOne will then re-calculate the report and display the new details accordingly.

Setup Options Purchases by Vendor Class

Query Settings
  • Range – This may be Date based or Period based. A button located at the bottom left hand corner of the screen Use Period Button, acts as a toggle enabling the user to swap between date and period based reports. By Default SapphireOne will set the range to Date and This Month to Date. If period is selected, SapphireOne will display Periods for the From and To fields. The selection made here will populate the From and To fields with the appropriate dates or periods.
  • Range Selection – Either the From or To Dates or Periods may be directly entered by the user.
    • Date- Various date based options are available when the user selects the up/down arrows to the right of this drop-down menu. For example, Last Financial Year to today’s date last Year This will enable the user to compare last years purchase figures to this years purchase figures for the same time frame in last and current financial years.
    • Dates & Periods – For a date driven report the two date entry fields require the input of a date. Note that the date option has both the From and To underlined so they have a convenient pop-up calendar to pick dates from. For periods directly enter the periods required accordingly.
  • Depart – Select All departments or select any Department in the company.
  • Query Button – When any filtering of the report is required, for example a Single Vendor, a detailed query may be performed for the Vendor by selecting the Query button. This then causes SapphireOne to display the detailed query pop-up. This enables the user to query for the Vendor or any item in SapphireOne.

Display Settings
  • Sort – This option allows the sorting of the items in the report. The options range from ID, (Default), Name and Total.
    • > – It should be noted that the small [>] button just the right of the sort drop-down menu is used to invert the sort. It acts as a toggle reversing the sort order as a result.
  • Column By – This option selects what data is included with each column. There are three options, The default of Total, Rep or Period. Select the report that best suits your requirements.
  • Recalculate – Every time a change is made to the report, the Recalculate button must be selected so that SapphireOne can re-calculate the report. Any changes are displayed immediately in the report area.

Footer Buttons
  • Export To html – Selecting this button will tell SapphireOne to export the report as a html file, which then may be viewed with any web browser.
  • Export To CSV – Selecting this button will tell SapphireOne to export the report as a CSV file, which then may be viewed with any spreadsheet program.
  • Print – If printing is required select the Print button and the report will be printed immediately.

Show Reports Purchases by Item (Inventory)

Overview

This Show Report will display purchases on an Inventory item by item basis. The Items ID, Name, Quantity as well as the total amount for each item is listed in a column in the report. The percentage of sales generated by the item, as well as the Average Price or cost for the items are also displayed.

When any alterations or changes are made to any settings in these reports, the Recalculate button must be selected each time. SapphireOne will then re-calculate the report and display the new details.

Setup Options Purchases by Inventory Item (Inventory)

Query Settings
  • Range – This may be Date based or Period based. A button located at the bottom left hand corner of the screen Use Period Button, acts as a toggle enabling the user to swap between date and period based reports. By Default SapphireOne will set the range to Date and This Month to Date. If period is selected, SapphireOne will display Periods for the From and To fields. The selection made here will populate the From and To fields with the appropriate dates or periods.
  • Range Selection – Either the From or To Dates or Periods may be directly entered by the user.
    • Date- Various date based options are available when the user selects the up/down arrows to the right of this drop-down menu. For example, Last Financial Year to Today’s Date Last Year. This will enable the user to compare last years sales figures to this years sales figures for the same time frame in last and current financial years.
    • Dates & Periods – For a date driven report the two date entry fields require the input of a date. Note that the date option has both the From and To underlined so they have a convenient pop-up calendar to pick dates from. For periods directly enter the periods required accordingly.
  • Depart – Select All departments or select any Department in the company.
  • Query Button – When any filtering of the report is required, for example a Single Vendor, a detailed query may be performed for the Vendor by selecting the Query button. This then causes SapphireOne to display the detailed query pop-up. This enables the user to query for any item in SapphireOne.

Display Settings
  • Grouping- This drop-down option currently has 10 items on it and it is used when the grouping of the Inventory Items within the report is required.
    • Normal Report – For a normal report the None (Default) option is used which will not group the report. Other grouping options are as follows, Class, Type, Brand, Detail, Tag4, Tag5, and Tag6.
    • Matrix Report – The remaining two options Matrix and Matrix Colour, are selected when a report is being set up for Matrix items. Matrix relates to the columns in a Matrix, while Matrix Colour relates to the Matrix Rows if the matrix is set up for other types of Inventory.
  • Sort – This option allows the sorting of the items in the report. The options are ID, (Default), Name, Quantity, Amount, % of Sales and Average Price.
    • It should be noted that the small [>] button just the right of the sort drop-down menu is used to invert the sort. It acts as a toggle reversing the sort order.
  • Column By – This option selects what data is included with each column. There are five options, Detail Default, Vendor, Period, Detail Period and Project. Select the report that best suits your requirements.
  • Breaking – With the use of this menu the report may be broken up as follows. None (default), and then by Vendor, Vendor Class, Rep, Period and Project.
  • Recalculate – Every time a change is made to the report, the Recalculate button must be selected so that SapphireOne can re-calculate the report. Any changes are displayed immediately in the report area.

Footer Buttons
  • Export To html – Selecting this button will tell SapphireOne to export the report as a html file which may be viewed with any web browser.
  • Export To CSV – Selecting this button will tell SapphireOne to export the report as a CSV file which may be viewed with any spreadsheet program.
  • Print – If printing is required select the Print button and the report will be printed immediately

Show Reports Purchases by Item Class (Inventory)

Overview

In SapphireOne Inventory Items may be assigned to a class. This functionality allows for additional reporting to be done using the Inventory Items Class. The SapphireOne user is able to take advantage of this with this Inventory Class based report.

When any alterations or changes are made to any settings in these reports, the Recalculate button must be selected each time. SapphireOne will then re-calculate the report and display the new details accordingly.

Setup Options Purchases by Inventory Item Class (Inventory)

Query Settings
  • Range – This may be Date based or Period based. A button located at the bottom left hand corner of the screen Use Period Button, acts as a toggle enabling the user to swap between date and period based reports. By Default SapphireOne will set the range to Date and This Month to Date. If period is selected, SapphireOne will display Periods for the From and To fields. The selection made here will populate the From and To fields with the appropriate dates or periods.
  • Range Selection – Either the From or To Dates or Periods may be directly entered by the user.
    • Date – Various date based options are available when the user selects the up/down arrows to the right of this drop-down menu. For example, Last Financial Year to today’s date last Year. This will enable the user to compare last years sales figures to this years sales figures for the same time frame in last and current financial years.
    • Dates & Periods – For a date driven report the two date entry fields require the input of a date. Note that the date option has both the From and To underlined so they have a convenient pop-up calendar to pick dates from. For periods directly enter the periods required accordingly.
  • Depart – Select All departments or select any Department in the company.
  • Query Button – When any filtering of the report is required, for example a Single Vendor, a detailed query may be performed for the Vendor by selecting the Query button. This then causes SapphireOne to display the detailed query pop-up. This enables the user to query for any item in SapphireOne.

Display Settings
  • Grouping- This is used when the grouping of the Inventory Items within the report is required. This drop-down option currently has 4 items on it as follows. The None (Default) option is used which will not group the report. Other grouping options are, Type, Brand, and Detail.
  • Sort – This option allows the sorting of the items in the report. The options are ID, (Default), Name, Quantity, Amount, % of Sales and Average Price.
    • It should be noted that the small [>] button just the right of the sort drop-down menu is used to invert the sort. It acts as a toggle reversing the sort order.
  • Column By – This option selects what data is included with each column. There are five options, Detail Default, Vendor, Period, Detail Period and Project. Select the report that best suits your requirements.
  • Recalculate – Every time a change is made to the report, the Recalculate button must be selected so that SapphireOne can re-calculate the report. Any changes are displayed immediately in the report area.

Footer Buttons
  • Export To html – Selecting this button will tell SapphireOne to export the report as a html file which may be viewed with any web browser.
  • Export To CSV – Selecting this button will tell SapphireOne to export the report as a CSV file which may be viewed with any spreadsheet program.
  • Print – If printing is required select the Print button and the report will be printed immediately.

Show Reports Project Class

In SapphireOne Projects may be assigned to a class. This functionality allows for additional reporting to be done using the Projects Class, so we are able to take advantage of this with this Project’s Class based report.

When any alterations or changes are made to any settings in these reports, the Recalculate button must be selected each time. SapphireOne will then re-calculate the report and display the new details accordingly.

Setup Options Purchases by Project Class

Query Settings
  • Range – This may be Date based or Period based. A button located at the bottom left hand corner of the screen Use Period Button, acts as a toggle enabling the user to swap between date and period based reports. By Default SapphireOne will set the range to Date and This Month to Date. If period is selected, SapphireOne will display Periods for the From and To fields. The selection made here will populate the From and To fields with the appropriate dates or periods.
  • Range Selection – Either the From or To Dates or Periods may be directly entered by the user.
    • Date- Various date based options are available when the user selects the up/down arrows to the right of this drop-down menu. For example, Last Financial Year to today’s date last Year. This will enable the user to compare last years sales figures to this years sales figures for the same time frame in last and current financial years.
    • Dates & Periods – For a date driven report the two date entry fields require the input of a date. Note that the date option has both the From and To underlined so they have a convenient pop-up calendar to pick dates from. For periods directly enter the periods required accordingly.
  • Depart – Select All departments or select any Department in the company.
  • Query Button – When any filtering of the report is required, for example a Single Vendor, a detailed query may be performed for the Vendor by selecting the Query button. This then causes SapphireOne to display the detailed query pop-up. This enables the SapphireOne user to query for any item in SapphireOne.

Display Settings
  • Sort – This option allows the sorting of the items in the report. The options are ID, (Default), Name, Quantity, Amount, %of Sales and Average Price.
    • It should be noted that the small [>] button just the right of the sort drop-down menu is used to invert the sort. It acts as a toggle reversing the sort order.
  • Column By – This option selects what data is included with each column. There are five options, Detail Default, Vendor, Period, Detail Period and Project. Select the report that best suits your requirements.
  • Recalculate – Every time a change is made to the report, the Recalculate button must be selected so that SapphireOne can re-calculate the report. Any changes are displayed immediately in the report area.

Footer Buttons
  • Export To html – Selecting this button will tell SapphireOne to export the report as a html file, which may be viewed with any web browser.
  • Export To CSV – Selecting this button will tell SapphireOne to export the report as a CSV file, which may be viewed with any spreadsheet program.
  • Print – If printing is required select the Print button and the report will be printed immediately.

Show Reports Purchases by Matrix

For Inventory items that use a matrix, the user should know the following as the matrix functionality may not only be for items of clothing. The Matrix functionality may be used in any industry where the selection of an item is enhanced by the use of a matrix.

  • Matrix – These are the column headings in a Matrix.
  • Matrix Colours – These are the row headings in a Matrix.

When this Matrix style report is generated, both the columns and the rows will be displayed as may be seen in the screen shot below.

When any alterations or changes are made to any settings in these reports, the Recalculate button must be selected each time. SapphireOne will then re-calculate the report and display the new details accordingly.

Setup Options Purchases by Matrix

Query Settings
  • Range – This report may be Date based or Period based. A button located at the bottom left hand corner of the screen Use Period Button, acts as a toggle enabling the user to swap between date and period based reports. By Default SapphireOne will set the range to Date and This Month to Date. If period is selected, SapphireOne will display Periods for the From and To fields. The selection made here will populate the From and To fields with the appropriate dates or periods.
    • Range Selection – Either the From or To Dates or Periods may be directly entered by the user.
      • Date- Various date based options are available when the user selects the up/down arrows to the right of this drop-down menu. For example, Last Financial Year to Today’s Date Last Year. This will enable the user to compare last years sales figures to this years sales figures for the same time frame in last and current financial years.
      • Dates & Periods – For a date driven report the two date entry fields require the input of a date. Note that the date option has both the From and To underlined so they have a convenient pop-up calendar to pick dates from. For periods directly enter the periods required accordingly.
  • Depart – Select All departments or select any Department in the company.
  • Query Button – When any filtering of the report is required, for example a Single Client, a detailed query may be performed for the client by selecting the Query button. This then causes SapphireOne to display the detailed query pop-up. This enables the SapphireOne user to query for any item in SapphireOne.

Back to Top

Display Settings
  • Display Raw – This option selects what data is included with each column. There are 4 options, Colour (Default), Master, Vendor and Period.
  • Use $ or Qty – This button is a toggle that switches the report from a Dollar $ based report to a Quantity based report.
  • Recalculate – Every time a change is made to the report, the Recalculate button must be selected so that SapphireOne can re-calculate the report. Any changes are displayed immediately in the report area.

Back to Top

Footer Buttons
  • Export To html – Selecting this button will tell SapphireOne to export the report as a html file which may be viewed with any web browser.
  • Export To CSV – Selecting this button will tell SapphireOne to export the report as a CSV file which may be viewed with any spreadsheet program.
  • Print – If printing is required select the Print button and the report will be printed immediately.

Show Reports Purchases by Serial / Batch

When any alterations or changes are made to any settings in these reports, the Recalculate button must be selected each time. SapphireOne then re-calculates the report and displays the new details accordingly.

Setup Options Sales by Serial / Batch

Back to Top

Query Settings
  • Range – This may be Date based or Period based. A button located at the bottom left hand corner of the screen Use Period Button, acts as a toggle enabling the user to swap between date and period based reports. By Default SapphireOne will set the range to Date and This Month to Date. If period is selected, SapphireOne will display Periods for the From and To fields. The selection made here will populate the From and To fields with the appropriate dates or periods.
    • Range Selection – Either the From or To Dates or Periods may be directly entered by the user.
      • Date – Various date based options are available when the user selects the up/down arrows to the right of this drop-down menu. For example, Last Financial Year to Today’s Date Last Year. This will enable the user to compare last years sales figures to this years sales figures for the same time frame in last and current financial years.
      • Dates & Periods – For a date driven report the two date entry fields require the input of a date. Note that the date option has both the From and To underlined so they have a convenient pop-up calendar to pick dates from. For periods directly enter the periods required accordingly.
  • Depart – Select All departments or select any Department in the company.
  • Query Button – When any filtering of the report is required, for example a Single Client, a detailed query may be performed for the client by selecting the Query button. This then causes SapphireOne to display the detailed query pop-up. This enables the SapphireOne user to query for any item in SapphireOne.

Back to Top

Display Settings
  • Column By – This option selects what data is included with each column. There are 7 options so select the option that best suits your requirements. Detail (Default), Qty Analysis, Bonded Stock, Vendor, Rep, Period and Project.
  • Recalculate – Every time a change is made to the report, the Recalculate button must be selected so that SapphireOne can re-calculate the report. Any changes are displayed immediately in the report area.

Back to Top

Footer Buttons
  • Export To html – Selecting this button will tell SapphireOne to export the report as a html file which may be viewed with any web browser.
  • Export To CSV – Selecting this button will tell SapphireOne to export the report as a CSV file which may be viewed with any spreadsheet program.
  • Print – If printing is required select the Print button and the report will be printed immediately.

Show Report Purchases by Addition / Deduction

In SapphireOne, Inventory items may be assigned Additions or Deductions. This Show Report will display purchases on an Addition and Deduction basis. Additions and Deductions allow you to schedule additional lines to Inventory transactions based on the Inventory items already added. This functionality allows for additional reporting to be done using Purchases by Addition/Deduction. The SapphireOne user is then able to take advantage of this with a Purchases by Addition/Deduction based report.

When any alterations or changes are made to any settings in these reports, the Recalculate button must be selected each time. SapphireOne will then re-calculate the report and display the new details accordingly.

Setup Options Purchases by Addition / Deduction

Query Settings
  • Range – This may be Date based or Period based. A button located at the bottom left hand corner of the screen Use Period Button, acts as a toggle enabling the user to swap between date and period based reports. By Default SapphireOne will set the range to Date and This Month to Date. If period is selected, SapphireOne will display Periods for the From and To fields. The selection made here will populate the From and To fields with the appropriate dates or periods.
  • Range Selection – Either the From or To Dates or Periods may be directly entered by the user.
    • Date – Various date based options are available when the user selects the up/down arrows to the right of this drop-down menu. For example, Last Financial Year to Today’s Date Last Year. This will enable the user to compare last years sales figures to this years sales figures for the same time frame in last and current financial years.
    • Dates & Periods – For a date driven report the two date entry fields require the input of a date. Note that the date option has both the From and To underlined so they have a convenient pop-up calendar to pick dates from. For periods, directly enter the periods required accordingly.
  • Depart – Select All departments or select any Department in the company.
  • Query Button – When any filtering of the report is required, for example a Single Vendor, a detailed query may be performed for the Vendor by selecting the Query button. This causes SapphireOne to display the detailed query pop-up. This enables the user to query for any item in SapphireOne.

Display Settings
  • Sort – This option allows the sorting of the items in the report. The options are ID, (Default), Name, Type, Calculation, Vendor and Amount.
    • It should be noted that the small [>] button just the right of the sort drop-down menu is used to invert the sort. It acts as a toggle reversing the sort order.
  • Breaking – With the use of this menu the report may be broken up as follows. None (default), and then by Vendor and Vendor Class.
  • Recalculate – Every time a change is made to the report, the Recalculate button must be selected so that SapphireOne can re-calculate the report. Any changes are displayed immediately in the report area.

Footer Buttons
  • Export To html – Selecting this button will tell SapphireOne to export the report as a html file, which may be viewed with any web browser.
  • Export To CSV – Selecting this button will tell SapphireOne to export the report as a CSV file, which may be viewed with any spreadsheet program.
  • Print – If printing is required select the Print button and the report will be printed immediately.

The only difference between the two procedures above is that in Manifest there is an SSCC page. When the Shipping function is is accessed from within invoice, the SSCC page from manifest is used to complete the Shipping procedure in the Invoice.

Back to Top

Show Reports Fulfillment & Shipment

Fulfillment Report

When the Column by Fulfillment option is selected, the report as seen below will be displayed. Select the report that best suits your shipping procedure. There is also a Shipping report available so select the report that best suits your Shipping procedure.

Shipment Report

When the Column by Shipment option is selected, the report as seen below will be displayed. Select the report that best suits your shipping procedure. There is also a Shipping report available so select the report that best suits your Shipping procedure.

Setup Procedure Fulfillment & Shipment

Query Settings
  • Range – This may be Date based or Period based. The Use Period Button or Use Date Button button, which acts as a toggle, is located at the bottom left hand corner of the screen. SapphireOne will initially set the range to Date and This Month to Date by default.
    • Range Selection:
      • Date – Various date based options are available when the user selects the up/down arrows to the right of this drop-down menu. For example, Last Financial Year to Today’s Date Last Year. This will enable the user to compare last years sales figures to this years sales figures for the same time frame in last and current financial years.
  • From and To Dates – For a date driven report the two date entry fields require the input of a date.
    • Note that the date option has both From and To underlined so they have a convenient pop-up calendar to pick dates from.
  • From and To Period – The user only has to enter the starting and ending periods for the report.
  • Depart – Select All departments or select any Department in the company.
  • Radio Buttons – These two radio buttons operate as a pair. The report my be generated using the Date In or the Delivery Date with the selection of the appropriate radio button.
  • Query Button – When any filtering of the report is required, for example a Single Vendor, a detailed query may be performed for the vendor by selecting the Query button. This then causes SapphireOne to display the detailed query pop-up. This enables the user to query for any item in SapphireOne.

Display Settings
  • Breaking – The user has the option of having no breaks in the list None,to Breaking the list on a Transaction by transaction basis. 
  • Sort – This option allows the sorting of the items in the report. The options range from Vendor, (Default) to Status.
    • It should be noted that the small [>] button just the right of the sort drop-down menu is used to invert the sort. It acts as a toggle reversing the sort order.
  • Column By – This option selects what data is included with each column. There are two options, The default of Fulfillment or Shipment. Select the report that best suits your requirements.
    • Fulfillment – This option provides a report that has 19 columns from Client ID to ETA and then ending with Status
    • Shipment – This report has 22 columns which offer slightly different details including what quantity was ordered and what quantity was actually shipped.
  • Recalculate Button – Every time a change is made to the report, the Recalculate Button must be selected so that SapphireOne can re-calculate the report. Any changes are displayed immediately in the report area.

Footer Buttons
  • Export To html – Selecting this button will tell SapphireOne to export the report as a html file, which may be viewed with any web browser.
  • Export To CSV – Selecting this button will tell SapphireOne to export the report as a CSV file, which may be viewed with any spreadsheet program.
  • Print – If printing is required select the Print button and the report will be printed immediately.

Report Column Details

For the list below Column by column is assumed.

  • Vendor – This displays the Vendor’s ID.
  • Name – This displays the Vendor’s Name.
  • Internal Ref – This displays the Internal Reference Number for the Transaction.
  • Line# – This displays the line number in the transaction.
  • Client – This displays the Client’s ID.
  • Name – This displays the Client’s Name.
  • Internal Ref – This displays the Internal Reference number for the invoice.
  • Line# – This displays the line number of the item in the invoice.
  • Inventory ID – This displays our Inventory ID for the item.
  • Name – This displays the Name of the Inventory Item.
  • Tag – This displays the Tag of the Inventory Item.
  • Unit – The unit as set in the Inventory Item.
  • Ordered – The Quantity Ordered.

This point is where the Fulfillment report carries on with backorder and ends at Status below.
The Shipping report carries on after Ordered above.

  • Back Order – The Quantity placed on Back Order.
  • Allocated – The Quantity Allocated to the transaction.
  • Linked – If this data has been entered into the invoice, it will be displayed in this column.
  • ETA – If this data has been entered into the Invoice, the details will be displayed in this column.
  • Status – The status of the of the Invoice will be displayed in this column.

The Shipment Report starts at Ordered above and carries on to Status.

  • Date In – The Date In on the Invoice.
  • Ship Date – The Shipping date.
  • Vessel 1 – The vessel name if entered.
  • Vessel 2 – A second vessel name if required.
  • POA – Port Of Arrival.
  • ETA – Estimated Time of Arrival.
  • In Store – Estimated data for the items to be In Store.
  • Shipped – Quantity Shipped, see above the Quantity Ordered.
  • Status – The Status of the invoice will be displayed in this column.

You can review our Blog and YouTube channel for additional information and resources on SapphireOne ERP, CRM and Business Accounting software.

Was this helpful?