Best Of

Hi @Kristoffer Viray-Oracle

That wouldn't work as it's not looking for a particular phrase and is just extracting a number (while here, I need to extract anything after the phrase and before the first blank space after the phrase).

The following is working

REGEXP_REPLACE({incomingmessage}, '^.*?(our purchase order number|the purchase order number|the purchase order number is|purchase order no|PO number|po number|po no|purchase order)\s+([0-9a-zA-Z-_()/]+)?.*$', '\2',1, 1,'imn')

It does need a second field to get rid of the additional text that is extracted by this formula. The second field's formula is:

NVL(SUBSTR({custevent_po_lookup}, 0, INSTR({custevent_po_lookup}, CHR(10))-1), {custevent_po_lookup})

Hi All

I found this Knowledge Article 8930 useful. Please let me know if there is any other way for mass attachments using import method, thanks!

Attaching Files to Records

Published 03/04/2011 11:44 AM  |   Updated 05/08/2022 11:02 PM  |   Answer Id: 8930

Hello @User_XQ321,

Is it possible that the period range that you have selected in your Unrealized Exchange Rate Gains and Losses report does not have any Currency Revaluation yet?

For example for the month of June 2022:

Since I have not yet ran the Currency Revaluation for the month of June 2022 no data will appear in the report.

However, if I set it from April 2022 to May 2022, I am able to see results:

This is because unrealized/gain loss was posted for these periods as indicated by the Unrealized Gain/Loss Trans Number column

I hope this clarifies ?

==============

If you find this reply to your question as helpful, others with the same question might find it helpful as well. By marking “Yes” on the “Did this answer your question?”, you’ll be able to aid the community to find the solution much easier and faster without the need to read through all the replies, and you will also get closer to earning your next Answer Accepter badge.

Hello @User_XQ321 ,

When you would like to delete the reconciliation from January, you need to delete first the following reconciliations as well. It is nicely explained in our SuiteAnswers # 70168 - Deleting Reconciled Statements.

Regarding the new Bank Statement import you would need to do steps as you described. I recommend you to unreconciled, unclear, unmatched all transaction :-) and regarding the statement items I believe you don't need to exclude them, just delete the statement as per provided information above. After you import a new statement you will be able to reconcile all items again with the new statement.

Please, let me know if you have any other questions related to this concern.

“Kindly click "Yes" on "Did this answer the question?" if you find the reply on your thread helpful. This will aid the others with the same question to easily find the correct answer. Thank you!

No worries about it, User_XQ321.

Yes, I have tested it successfully. ?

Hi User_XQ321,

Thank you for patiently waiting. ?

I made some testing on my end with the same setup as yours, and I was able to generate a Dunning Letter correctly.

Here is a 44-day overdue Invoice that was picked up by the Invoice Dunning Procedure.

I have also tested an Invoice Dunning Procedure with 90 Days Overdue rule, and the Invoice I created was not picked up as no Dunning Level was assigned to it.

I think this may be a potential defect and Customer Support may assist you to check and further test on the back-end what could be the issue of your Dunning Procedures.

Thank you! ?

Hi @User_XQ321,

Just following up on this. Were you able to check any workflows/scripts that may be running on Purchase Orders? ?

Hello User_XQ321, yes. Thats correct.