IMakan
Below is a list of where data are stored in VAL.
Name | Table Name | Solution |
|---|---|---|
Collection Reports | Raw: Collection Reports | iMakan | Revenue Reconciliation |
In our list of queries, you can identify [to be populated]
Table | Query Name | Description |
|---|---|---|
Raw: Collection Reports | iMakan | Raw | Collection Report | iMakan | Orders - [Date Range] | This query provides the transaction for a selected date range |
Below is a list of workflow to trigger for performing various automation in VAL.
Name | Workflow Name | Solution |
|---|---|---|
Trigger upload of collection reports into VAL | [To be populated] | Revenue Reconciliation |
Where and how to download
- Head to Analytics>Sales Report>Daily Collections>Select Branch>Input date range From/To> Click Refresh.
- Once report is loaded, select “Excel” to download report
Filename convention
Please add the branch between “Collections” and “from” in filename before uploading as there is no branch in the report itself and we will use filename to
Ensure file name follows the convention Daily Collections <Branch> from YYYY-MM-DD to YYYY-MM-DD.xlsx
For the branch name to use, pls check with the assigned analyst to you for further information
Upload location
To be uploaded into VAL Drive -> RevRec -> 01_SourceReports
Other notes
Not available
