How to get an invoice directly from Approval Max
Log into Approval Max with your unique username and password
Navigate to the search bar (🔍) on the top right side of the screen
Make sure the Organization name is BVSA - Property
Depending on what you are looking for, use the following prompts:
In the Property search bar, search for the name of a property and click search:
All the relevant invoices for that property will show
In the Supplier Search bar, search for the name of a supplier and click search:
All the relevant invoices for that supplier will show.
You can combine properties and suppliers to refine your search or include dates and/or amounts to further refine your search.
Step 1
Download your Approval Max report.
Step 2
Insert a column next to the supplier name.
Step 3
Go to https://www.extendoffice.com/documents/excel/3243-excel-remove-numbers-from-strings.html, and copy the VBA Code in the black box.
Step 4
Go back to the excel Approval Max report, press Alt + F11 keys simultaneously to open the Microsoft Basic for Application window. Click Insert > Module, and then paste the VBA code into the opening Module window. Make sure to close the window when done.
Step 5
Type the following formula in the inserted column next to the supplier name =RemoveNumbers(A2) (A2 is the cell you will remove numbers from), and then drag the Fill Handle down to the range as you need.
Step 6
Give the inserted column a name and sort the column from A to Z. Once you have sorted the column you can delete it and you will be left with your Approval Max list in alphabetical order.
How To Capture an Invoice on Dext and Publish to Approval Max
1. Open Dext, go to Add Documents on the Right Hand Side.
2. Choose File from emails or if you saved it, go to that location and select the file that needs to be approved.
NOTE: You can drag and drop file or select file from location.
3. At the bottom it will show how many files have been loaded.
4. Click on “Processing”
5. Files are now being read and processed, this may take a while, you can refresh page until all files have been removed from the processing tab.
6. Go to the Inbox tab, files in Bold have been added and needs to be reviewed.
7. Click on 1st file, that it can open.
8. On the right hand side the necessary information will show and can be edited where needed.
PLEASE NOTE THAT WITH MUNICIPAL ACCOUNTS TO ADD THE ACCOUNT NUMBER IN THE DOCUMENT REF TAB FOR EASE OF ACCESS.
9. Go through each tab to make sure the information is correct.
10. When done click on Publish at the bottom. File will now be moved to Approval Max for approval by the allocated Property Manager.
11. To double check, go to Approval Max, the latest files you published will be under the “created by me tab”
NOTES:
1. Some Files may not read automatically and needs to be filled in manually.
2. Note that new suppliers may take a day or two before it is loaded to Dext.
3. New supplier rules will also need to be added when they appear in Dext.
4. When selecting a supplier, make sure the supplier has a unique code added in front, this should correspond with MDA.
How to Import Invoices from Dext into MDA (Only one liner items)
NOTE: After Invoices have been Published to Approval Max, only then can one Import from Dext into MDA.
1. In Dext, go to Archive
2. Tick the selected invoices that need to be Imported into MDA.
3. Then at the top click on Export, at the drop down box, next to CSV Format, choose “Dext Prepare default (line items) and click on Export
4. When this screen appears, click download and an excel (csv version) will be downloaded, and can be opened.
5. Open the Dext Import sheet, located at (BVPG Shared Folder / BVSA Property / Dext)
6. Go back to the Dext Export Sheet and copy sheet into the Dext Import sheet on the second tab (Dext 1st export (Normal Paste))
7. Go to the 1ste tab on the Dext Import sheet (MDA Final Import) and copy to a new Excel sheet, Paste as Values only.
8. Delete the rows where “Value” shows.
9. Save file as CSV and close document.
10. In MDA go to Process / Payments / Capture Expenses.
11. Click on Add Batch
12. Then go down to Import from File and click on Add.
13. At the Location block, go search for the Dext Import file you saved as a CSV, select it and click on Open.
14. Link of the File will be added to the Location Tab, then click on Add.
15. File will be Imported, When complete click on OK and Exit
NOTE: Just double check each transaction to make sure the correct property has been chosen, before it is posted.
16. When everything is correct, go to the Batch Control tab, and click on Post on the Right side of the screen.
17. A Warning message will appear, to print batch, Clock on No.
18. On the Next Screen click on Process.
19. When done click on Exit.