Reports

Reports can be accessed by clicking "Reports" from the menu. An establishment can find a status or movements of its stakeholders from this option.

Documents

Documents can be accessed by clicking "Documents" from the menu.

Stock Match

• The Stock Match Feature allows the stakeholder to upload actual stock data in order to verify the quantities available in their system against the stock data recorded in RSD. This can be done by uploading a file or entering the data manually within the system.

• After uploading the file, you can review the data by clicking on "Send".

• Please note that when uploading the file, it will be saved in the "Stock Match Records" page to ensure proper record organization.
• Once the stock matching process is completed, the file will be transferred to the stock match records list, and no further actions can be performed on it.

1. Excel Template File

• This template is provided by the system to upload correct data. You must follow the instructions when preparing the file.
• Data must be entered in English only, and modifying column names or rearranging them is not allowed, as the system relies on them to process the file correctly.
• You must ensure that the GTIN format is set correctly (Text format, not General) to prevent data loss or errors during reading.
• Please note that any changes in formatting or missing required fields may result in the file being rejected by the system.

2. Stock Match Results

• At the end of the stock matching process, the match percentage is calculated. A table can then be downloaded containing the following columns:
• Description, Quantity, Batch Number, and Global Trade Item Number (GTIN).

3. Last Stock Match Operation

• At the end of the stock matching process, a detailed report is displayed including: Global Trade Item Number (GTIN), Drug Name, Batch Number, Expiry Date, Active Quantity, Pending Receive, Actual Quantity, Stock Match Date, Difference.
• During these procedures, the stakeholder can execute actions such as accepting quantities or sending quantities, in order to complete the stock matching process and update the data accurately. Note: Stock matching actions (accepting or sending quantities) are only available to subscribed entities in the service.
• In case of no subscription, the user can only view the matching results and determine whether the quantities are matched or not.

4. Download Stock Match Table

• This table displays key information for inventory management. It starts with the Global Trade Item Number (GTIN), which is used as a unique identifier for the product. It is followed by the drug name, and the batch number.
• The expiry date is also included to ensure product validity. The table also shows the Active quantity, which represents the quantity recorded in the RSD system, in addition to the Pending Receive quantity, which has been received but not yet accepted.
• After the accept, the accepted quantity available is displayed. Where the difference indicates the variance between the registered quantity in the system and the actual quantity, helping detect any increase or shortage in inventory.

5. Accept Stock

• In the accept screen, it shows all the received quantities making it easier to complete the accept operation.
• The list includes the following details: Selection checkbox, notification date, from GLN, GTIN, batch number, expiry date, available quantity, and received quantity.
• You can select the desired quantity by checking the box next to the row. Once selected, the received quantity will automatically be filled with the same value.
• After that, you can specify the quantity to be accepted through the "Accepted Quantity" field, allowing you to either accept the full quantity or enter a custom amount as needed.

6. Transfer / Dispatch Stock

• In the Transfer / Dispatch Request screen, the remaining quantity appears first. Below it, there is a field to specify the Global Location Number (GLN) to which the quantities will be sent, along with entering the required quantity to be transferred.
• After that, you can click on "Insert" to include more than one destination operation within the same request.

• Click on "Save" to confirm the operations.

7. Stock Match Records List

• This page is used to display records of previously executed stock match operations, with the ability to search and filter according to specific criteria.
• To perform a search, you can use any one or a combination of them.
• The search criteria include:

• GTIN (Global Trade Item Number) or Drug Name
• Batch Number
• Match Percentage (From)
• Match Percentage (To)
• Start Date and End Date

8. Stock Match Records List Page

• By clicking on "View", the stock match details are displayed.
• The stock match details include:

• Stock Match ID
• Stock Match Date
• Available Quantity
• Actual Quantity
• Match Percentage

• When clicking on "View", the detailed stock match information will be shown.

9. Stock Match Record Details

• The stock match details are displayed, which include: Stock Match ID, Stock Match Date, Match Percentage.
• For more details, you can download an Excel file, and in addition to that, the following data will be displayed: GTIN (Global Trade Item Number), Batch Number, Available Quantity, Actual Quantity, Difference, and all operation done on each item for easier tracking.

10. Stock Match Record Details Table

• This file is used to display a record of stock match operations that have been executed, where the stock match number is assigned to each individual operation, in addition to the stock match date which indicates when the matching was performed.
• It also displays the active quantity recorded in the system at the time of the stock match and compares it with the actual quantity available. Based on this comparison, the match percentage is calculated to measure the accuracy of inventory and determine the level of consistency between the data recorded in the system and the actual stock.
• This helps in identifying discrepancies and improving inventory accuracy, which contributes to taking corrective actions when needed.