Difference between revisions of "Vendors payables list"
(→Export to Excel) |
|||
Line 19: | Line 19: | ||
If you want to hide or display some jobs from the list, you may apply filters. | If you want to hide or display some jobs from the list, you may apply filters. | ||
− | You can hide or display filter fields by | + | You can hide or display filter fields by clicking the [[File:filter arrow gray.jpg|border|25px]] button in the upper right corner: |
[[File:Vendors payables filters1.png|border|1000px]] | [[File:Vendors payables filters1.png|border|1000px]] | ||
− | So you can enter the data into the appropriate fields and | + | So you can enter the data into the appropriate fields and click '''"Apply"'''. |
If the filter is applied, the header turns blue: | If the filter is applied, the header turns blue: | ||
Line 29: | Line 29: | ||
[[File:14.png|border|900px]] | [[File:14.png|border|900px]] | ||
− | You may hide the filter interface by | + | You may hide the filter interface by clicking the [[File:Blue arrow.jpg|border|25px]] button. |
<span style="color:red">'''Note''':</span> The hidden filter remains activated. | <span style="color:red">'''Note''':</span> The hidden filter remains activated. | ||
− | You can expand the hidden filter back by | + | You can expand the hidden filter back by clicking [[File:Blue arrow.jpg|border|25px]] again. |
<span style="color:red">'''Note''':</span> The applied filter is remembered, so it will remain even if you leave the page. | <span style="color:red">'''Note''':</span> The applied filter is remembered, so it will remain even if you leave the page. | ||
− | To inactivate the filter, | + | To inactivate the filter, click the '''"Clear"''' button. |
The header color will turn to gray, which means that no filter is not applied: | The header color will turn to gray, which means that no filter is not applied: | ||
Line 47: | Line 47: | ||
<span style="color:red">'''Note:'''</span> If you are issuing a separate invoice for each job, you can do it directly from the <U>[[Project details, Finances tab#Invoice payables|'''Finances tab''']]</U> of the related project. | <span style="color:red">'''Note:'''</span> If you are issuing a separate invoice for each job, you can do it directly from the <U>[[Project details, Finances tab#Invoice payables|'''Finances tab''']]</U> of the related project. | ||
− | 1. To create vendor invoices, | + | 1. To create vendor invoices, click one of the following buttons over the table: |
[[File:Vendors payables filters2.png|border|1000px]] | [[File:Vendors payables filters2.png|border|1000px]] | ||
Line 55: | Line 55: | ||
*'''Invoice all'''—the system will create invoices for all payables which have not been invoiced. If there are many records to invoice, probably you’ll have time to make a cup of coffee. | *'''Invoice all'''—the system will create invoices for all payables which have not been invoiced. If there are many records to invoice, probably you’ll have time to make a cup of coffee. | ||
− | *'''Invoice all''' ''by filter''—first, '''<U>[[Vendors payables list#Search payables with filters|filter]]</U>''' the payables you need to invoice and then | + | *'''Invoice all''' ''by filter''—first, '''<U>[[Vendors payables list#Search payables with filters|filter]]</U>''' the payables you need to invoice and then click the '''"Invoice all"''' button. The system will create invoices for all filtered payables, even if there are thousands of them. |
2. The system will create invoices. Payables with the same vendor and currency will be linked into one invoice. Vendors can verify invoices in their accounts. | 2. The system will create invoices. Payables with the same vendor and currency will be linked into one invoice. Vendors can verify invoices in their accounts. | ||
Line 85: | Line 85: | ||
=='''Export to Excel'''== | =='''Export to Excel'''== | ||
− | You can export all the displayed table of vendor payables to Excel by | + | You can export all the displayed table of vendor payables to Excel by clicking the '''"Export to Excel"''' button over the upper right corner of the table: |
[[File:Vendors payables2.png|border|1000px]] | [[File:Vendors payables2.png|border|1000px]] |
Revision as of 14:38, 8 September 2022
Vendors payables list page: http://cloud.protemos.com/payable/index
On this page you can:
- View all the payables to your vendors and search them with filters.
- Create vendor invoices for the selected payables.
- Open payables or go to the related vendor profiles and jobs.
- Export all the displayed table of vendor payables to Excel.
Contents
Search payables with filters
By default, you can see all the payables in your database, 200 per page.
If you want to hide or display some jobs from the list, you may apply filters.
You can hide or display filter fields by clicking the button in the upper right corner:
So you can enter the data into the appropriate fields and click "Apply".
If the filter is applied, the header turns blue:
You may hide the filter interface by clicking the button.
Note: The hidden filter remains activated.
You can expand the hidden filter back by clicking again.
Note: The applied filter is remembered, so it will remain even if you leave the page.
To inactivate the filter, click the "Clear" button.
The header color will turn to gray, which means that no filter is not applied:
Create vendor invoices
Note: If you are issuing a separate invoice for each job, you can do it directly from the Finances tab of the related project.
1. To create vendor invoices, click one of the following buttons over the table:
- Invoice selected—the system will create invoices for the payables you marked in the list.
- Invoice all—the system will create invoices for all payables which have not been invoiced. If there are many records to invoice, probably you’ll have time to make a cup of coffee.
- Invoice all by filter—first, filter the payables you need to invoice and then click the "Invoice all" button. The system will create invoices for all filtered payables, even if there are thousands of them.
2. The system will create invoices. Payables with the same vendor and currency will be linked into one invoice. Vendors can verify invoices in their accounts.
3. After all the invoices are created, the system will bring you to the vendor invoices list.
Note 1: Vendors can create invoices themselves from their interface. But you can forbid them to do it. For more info, please check the Vendor portal settings.
Note 2: For vendors without payment methods invoices cannot be created. So you should create the nesessary payment method in the vendor profile first.
Note 3: Only the payables in jobs with the "Accepted by manager" status can be invoiced.
You can click items in the table to open corresponding pages:
- Code—opens the payable details page.
- Invoice—(if created) opens the corresponding Vendor invoice view page.
- Vendor—opens Vendor view page.
- Job—opens Job view page.
Tip: Protemos supports multiple windows. So you may open the link in the new window by holding "Shift" while clicking.
Export to Excel
You can export all the displayed table of vendor payables to Excel by clicking the "Export to Excel" button over the upper right corner of the table:
Note: The exported file will contain the filtered records from all the pages of the table, not just the ones displayed on the first page.