Best Of

Hi @Strategit_Shunta4

Yes, Its not possible to set the summary check box via CSV Import.

Hi @Dext3r

My suggestion is to set the approval matrix tier based on subsidiary base currency instead of per transaction currency.

1. Create a custom trans body field apply to purchase transaction :
"Total (Base Curr)" with store value set to No, Set the default value formula = {total}*{exchangerate}

2. In your workflow just refer to this "Total (Base Curr)" field instead of the Total field which is in transaction currency for your approval routing per subsidiary.

Regards,
Wee Ming

Thanks for the reply, I'll look into building that solution.

It's very clear; thank you very much for helping me

Hi @User_KSN9M

Sorry forgot to mention, for #3 need to ask all the sale order approvers to do this configuration as this setting is stored per user and browser login. Its not a global setting.

Hi @User_FL4CK

From what I experience and tested, below are the standard payment batch approval features:-

1. We can set up to max 3 levels of approval per Bank account.
2. Each level require a maximum payment approval limit.  
3. Payment Approval Limit for higher level must be greater than lower level.
4. Each level approver must be unique. i.e. User A cannot be both Level 1 & Level 2 approvers. 
5. Each level can set multiple approvers but only 1 approver required to approve the batch batch per level.
6. Higher level approval must wait for lower-level approved. Cannot override. 

So if your approval rules are different from above, you will need to customise your approval. We can't really change the Batch approval logic as its managed by the EBP bundle script. But we can add custom approval status to control the access of payment file in the Payment File Administration record which is generated for all type of payment batch.

To give you a rough idea, below is one method using custom fields and workflow on the Payment File Administration (PFA) record:-

1. You can use the standard batch approval as your first level approval. So once the batch is approved, a PFA will be created.

2. Add custom fields in the Payment File Administration (PFA) record to set your final approval status.
e.g. Approval Status, Approved By and Approved Date

3. Set default custom Approval Status to pending approval upon PFA record creation. And use workflow to hide the File Reference field or any other controls that you want to restrict before the PFA record approval status = Approved.

4. Use workflow to implement your custom approval flow in PFA record. And set the Approval Status = Approved at final stage, based on this status to un-hide file reference field for user to download and upload to bank.

Regards,
Wee Ming

Hi @User_KSN9M

For sales order there is only pending approval and no rejected status. Once sales order is approved, the status will change to pending fulfillment (depends on the item lines in the sales order.

I assumed you would like to change a Pending Fulfillment status sales order back to pending approval and disallow to approve again ?

If yes below is my proposed solution:-
1. Create a custom field "Rejected" checkbox in sales order
2. Open the sales order that you want to reject and tick this rejected field and also change the status to Pending Approval

3. At the Approve Sales Orders page, to make sure Sales order approvers will not re-approve rejected order again, click [Customize] button and tick to include "Rejected" field under the Additional Columns & Additional Filters tab. And make sure the list of orders are not rejected before approve.

#2 can use workflow to add a [Reject] button to perform this update if you want.

Regards,
Wee Ming

Hi @Irichelle Monterozo-Oracle Check for any inconsistencies or errors in the data within the CSV file. Invalid or corrupt data entries can cause issues during the retrieval process.