Goods Receipt Journal
This page describes the Goods Receipt Journal report in the Stock module.
---
The Goods Receipt Journal is a list Goods Receipts from the Goods Receipt register.
When printed to screen, the Goods Receipt Journal has the Standard ERP Drill-down feature. Click (Windows/macOS) or tap (iOS/Android) on any Goods Receipt Number in the report to open the corresponding Goods Receipt record.
- Period
- Paste Special
Reporting Periods setting, System module
- Enter the start and end date of the report period. The report will list Goods Receipts with Trans. Dates that fall within the period specified here. The first record in the Reporting Periods setting will be used as the default.
- Goods Receipt No.
- Range Reporting
Numeric
- Enter a Goods Receipt Number or a range of Numbers separated by a colon (:) here if you would like specific Goods Receipts to be listed in the report.
- Goods Receipts in the range that have been invalidated will not be included in the report.
- Supplier
- Paste Special
Suppliers in Contact register
- If you would like the report to list Goods Receipts received from a particular Supplier, enter the Contact Number of that Supplier here.
- PO No.
- Range Reporting
Numeric
- If you need the report to list Goods Receipts created from a particular range of Purchase Orders, enter their Order Numbers here. Use a colon (:) to separate the first and last numbers.
- Location
- Paste Special
Locations setting, Stock module
- If you need the report to list the Goods Receipts that you received in a single Location, specify that Location here. This refers to the Location entered at Goods Receipt level, not any that you may have entered in Goods Receipt rows.
- Location Group
- Paste Special
Location Groups setting, Stock module
- If you need the report to list the Goods Receipts that you received in Locations belonging to a particular Location Group, specify that Location Group here. This refers to the Location entered at Goods Receipt level, not any that you may have entered in Goods Receipt rows.
- Location Classification
- Paste Special
Location Classifications setting, Stock module
- Enter a Location Classification here if you need to restrict the report to the Goods Receipts that you received in Locations with that Location Classification. If you enter a number of Classifications separated by commas, the report will only include Goods Receipts received in Locations featuring all the Classifications that you have listed. If you enter a number of Classifications separated by plus signs (+), Goods Receipts received in Locations featuring at least one of the Classifications listed will be included in the report. If you enter a Classification preceded by an exclamation mark (!), the report will include Goods Receipts received in Locations featuring any Classification except the one listed.
- For example:
- 1,2
- Includes Goods Receipts received in Locations with Classifications 1 and 2 (including Locations with Classifications 1, 2 and 3).
- 1+2
- Includes Goods Receipts received in Locations with Classifications 1 or 2.
- !2
- Includes Goods Receipts received in Locations without Classification 2.
- 1,!2
- Includes Goods Receipts received in Locations with Classification 1 but without Classification 2. Note the comma before the exclamation mark in this example.
- !1,!2
- Includes Goods Receipts received in Locations without Classification 1 or 2 or both. Again, note the comma.
- !(1,2)
- Includes Goods Receipts received in Locations without Classifications 1 and 2 (Locations with Classifications 1, 2 and 3 will not be included).
- !1+2
- Includes Goods Receipts received in Locations without Classification 1 and those with Classification 2 (Locations with Classifications 1 and 2 will be included).
- (1,2)+(3,4)
- Includes Goods Receipts received in Locations with Classifications 1 and 2 and those with Classifications 3 and 4.
- 1*
- Includes Goods Receipts received in Locations with a Classification beginning with 1 (e.g. 1, 10, 100).
- 1*,!1
- Includes Goods Receipts received in Locations with a Classification beginning with 1 but not 1 itself.
- *1
- Includes Goods Receipts received in Locations with a Classification ending with 1 (e.g. 1, 01, 001).
- 1*,*1
- Includes Goods Receipts received in Locations with a Classification that begins and ends with 1 (e.g. 11, 101, 1001).
- This refers to the Location entered at Goods Receipt level, not any that you may have entered in Goods Receipt rows.
- Item
- Paste Special
Item register
- Range Reporting Alpha
- Use this field if you want to list the Goods Receipts that include a particular Item, or any Item from a range.
- If you produce the report using the Overview option, specifying an Item will have no effect on the report. If you use the Detailed option, only the rows with the specified Item will be listed.
- Item Group
- Paste Special
Item Group register, Sales Ledger
- Range Reporting Alpha
- Use this field if you want to list the Goods Receipts that include at least one Item belonging to a particular Item Group.
- If you produce the report using the Overview option, specifying an Item Group will have no effect on the report. If you use the Detailed option, only the rows with Items belonging to the specified Item Group will be listed.
- Item Classification
- Paste Special
Item Classifications setting, Sales Ledger
- Use this field if you want to list the Goods Receipts that include at least one Item with a particular Item Classification. You can also construct a complex search string using the +, ! and * characters as described under Location Classification above.
- If you produce the report using the Overview option, specifying an Item Classification will have no effect on the report. If you use the Detailed option, only the rows with Items with the specified Item Classification(s) will be listed.
- Salesman
- Paste Special
Person register, System module and Global User register, Technics module
- To list Goods Receipts created by a particular user, enter their Signature here.
- If you are using the Limited Access feature and the user producing the report is only able to see their own records, their Signature will appear here by default and can't be changed. Please refer to the description of the 'Access' card of the Person register for full details about the Limited Access feature.
- Sales Group
- Paste Special
Sales Groups setting, System module
- To list Goods Receipts created by users belonging to a particular Sales Group, enter that Sales Group here.
- If you are using the Limited Access feature and the user producing the report is only able to see records belonging to members of their Sales Group, their Sales Group will appear here by default and can't be changed. Please refer to the description of the 'Access' card of the Person register for full details about the Limited Access feature.
- Function
- Use these options to specify the level of detail that you need to be shown in the report.
- Overview
- This option produces a report with a single line for each Goods Receipt, showing Receipt Number and Date, Comment and Value.
- Detailed
- In addition to the information shown in the Overview, this option produces a report listing the Items on each Goods Receipt with quantities and unit prices. Any extra costs such as carriage or customs duties are also shown.
- Specify
- Use these options to specify whether Goods Receipts that have or have not been marked as OK or both are to be included in the report.
- Sorting by
- Choose one of these options to specify the order in which the Goods Receipts are to be listed in the report.
- Function
- A Consignment Stock Item is one that you receive from a Supplier that will remain the property of the Supplier until you sell it. The Supplier will therefore not issue a Purchase Invoice until you sell the Item. The Item never belongs to you: it remains the property of the Supplier until you sell it.
- Choose one of these options to specify whether Consignment Stock Items should be included in the report, as follows:
- Include Consignment Stock
- The report will include all Items i.e. Consignment Stock Items and Purchased Items will all be included.
- A Goods Receipt row will represent a Consignment Stock Item if the Stock Type field on flip E is set to "Consignment". Otherwise a Goods Receipt row will represent a Purchased Item.
- Exclude Consignment Stock
- The Overview version of the report will not include Goods Receipts in which every row represents a Consignment Stock Item. A Goods Receipt that includes both Consignment Stock Items and Purchased Items will be included.
- The lists of Items in each Goods Receipt in the Detailed version of the report will only include Purchased Items.
- Consignment Stock Only
- The Overview version of the report will not include Goods Receipts in which every row represents a Purchased Item. A Goods Receipt that includes both Consignment Stock Items and Purchased Items will be included.
- The lists of Items in each Goods Receipt in the Detailed version of the report will only include Consignment Stock Items.
- Please refer here for more information about Consignment Stock.
- TREO Items
- TREO (Tax Remission Export Office) Sales Orders are used in Kenya and other East African countries. If a manufacturing company receives a Sales Order from an export Customer, then any components purchased for manufacturing the Items on the Sales Order will be exempt from tax and customs duties.
- Choose one of these options to specify whether Items purchased on a TREO basis should be included in the report, as follows:
- Include TREO Items
- The report will include all Items i.e. TREO Items and non-TREO Items will all be included.
- A Goods Receipt row will represent a TREO Item if the TREO field on flip E is set to "TREO". Otherwise a Goods Receipt row will represent a non-TREO Item.
- Exclude TREO Items
- The Overview version of the report will not include Goods Receipts in which every row represents a TREO Item. A Goods Receipt that includes both TREO Items and non-TREO Items will be included.
- The lists of Items in each Goods Receipt in the Detailed version of the report will only include non-TREO Items.
- TREO Items Only
- The Overview version of the report will not include Goods Receipts in which every row represents a non-TREO Item. A Goods Receipt that includes both TREO Items and non-TREO Items will be included.
- The lists of Items in each Goods Receipt in the Detailed version of the report will only include TREO Items.
---
Go back to:
|
Introduction to Reports in the Stock Module
