Advanced Matching: Advanced settings for Bill-to-PO Matching
Firstly, the Administrator needs to ensure that Purchase Order Matching is enabled in the Bill Approval workflow settings.
To do so, go to the Bill Creation, Review and Approval workflow under Approval Workflows and click on the gear icon:
Then, check if the option "Allow users to match Bills to Purchase Orders" has been activated:
Next, decide on the advanced settings.
Can a Bill be approved if it is not yet matched to a Purchase Order?
- If the option "Can a Bill be approved if it is not yet matched to a Purchase Order?" is set to "Yes, unmatched Bills can be approved", the approval of Bills that have not been matched to their corresponding Purchase Order(s) is allowed:
- If the option "Can a Bill be approved if it is not yet matched to a Purchase Order?" is set to "Yes, unmatched Bills up to the following amount can be approved", the approval of Bills up to the specified amount that have not been matched to their corresponding Purchase Order(s) is allowed:
- If the option "Can a Bill be approved if it is not yet matched to a Purchase Order?" is set to "No, unmatched Bills cannot be approved", the approval of Bills that have not been matched to their corresponding Purchase Order(s) is restricted.
Can a Bill be approved if the remaining balance of any matched Purchase Order is below zero?
This setting regulates whether or not Bills can be approved even if the amount of all matched Bills exceeds the amount of matched Purchase Order(s). The Administrator can set an amount limit for the remaining Purchase Order balance so that the matched Bills can exceed the matched Purchase Order(s) by a certain amount and still get approved.
- If the option "Can a Bill be approved if the remaining balance of any matched Purchase Order is below zero" is set to "Yes, such Bills can be approved", Purchase Orders will be auto-marked as Billed if the Purchase Order's remaining balance is below zero:
- If the option "Can a Bill be approved if the remaining balance of any matched Purchase Order is below zero" is set to "Yes, such Bills can be approved if the PO's remaining balance is no more than X per cent below zero", Purchase Orders should get auto-marked as Billed if the Purchase Order's remaining balance is between -X% and 0:
For example: if the Purchase Order amount is 100 AUD and the setting is 15%, it means a Bill can be approved if the Purchase Order's remaining balance is between -15 AUD and 0. - If the option "Can a Bill be approved if the remaining balance of any matched Purchase Order is below zero" is set to "Such Bills can be approved if the PO's remaining balance is no more than N below zero", the Purchase Order should be auto-marked as Billed if its Purchase Order's remaining balance is between -N and 0:
For example: if the Purchase Order amount is 10000 AUD and the setting is 1000 AUD, the sum of all matched Bills should be no more than 11000 AUD, i.e. the Purchase Order's remaining balance is between -1000 AUD and 0. - If the option "Can a Bill be approved if the remaining balance of any matched Purchase Order is below zero" is set to "No, such Bills cannot be approved", the Purchase Order should be auto-marked as Billed if its remaining balance is 0:
Can a Bill be matched to a Purchase Order which has a later date?
This setting regulates whether or not Bills can be matched to Purchase Order(s) that were issued later than the corresponding Bill.
- If the option "Can a Bill be matched to a Purchase Order which has a later date?" is set to "Yes, allow matching Bills to retrospective Purchase Orders", matching Bills to Purchase Order(s) that were issued later than the corresponding Bill is allowed:
- If the option "Can a Bill be matched to a Purchase Order which has a later date?" is set to "No, do not allow matching Bills to retrospective Purchase Orders", matching Bills to Purchase Order(s) that were issued later than the corresponding Bill is restricted:
Which type of amounts should be used in the matching allocations?
The remaining balances are calculated depending on whether the setting is currently set to gross or net.
- If the option "Which type of amounts should be used in the matching allocations?" is set to "Gross amounts", the remaining balance is calculated as the difference between the gross amount and the sum of all allocations:
- If the option "Which type of amounts should be used in the matching allocations?" is set to "Net amounts", the remaining balance is calculated as the difference between the net amount and the sum of all allocations:
Related Articles
Advanced Matching: How can I enable the new Advanced Bill-to-PO Matching?
This is how you enable the Bill-to-PO matching feature: Go to Workflows and settings > Approval workflows > Bill Creation, Review and Approval workflow: r Click on theicon, scroll down and enable Purchase Order Matching: Now, you will see matching ...Advanced Matching: Up to which point in the workflow can Bill-to-PO Matching be done?
The Bill-to-PO Matching can be done up to the point where: The Bill is approved* The Purchase Order** is marked as "Billed"* Only an Organisation's Administrator has the authority to match/edit a matching when the Bill has been approved. ** Only ...Advanced Matching: Migration process from Matching to Advanced Matching
If you already have matched Bills to Purchase Orders, you can migrate your data once the new matching feature has been turned on for your Organisation: Go to the "Organisation" page under the main menu (if you use the new menu, select your ...Advanced Matching: How is Bill-to-PO Matching reflected in reporting?
In reports, ApprovalMax includes all relevant Bill-to-PO Matching data and presents the information about which Bills and Purchase Orders were matched. Administrators and Auditors are able to view the balances of Purchase Orders and Bills, the sum of ...Advanced Matching: Which Purchase Orders are available for matching?
Purchase Orders (PO) can only be matched to Bills if: PO and Bill have the same Supplier and Currency PO is not marked as "Billed". Billed status can be revised. PO date does not exceed the Bill date (if the "No, do not allow matching Bills with ...