Best Of

When creating a Saved Search in OneWorld, the amount column from non-parent is automatically converted to the base currency of the Parent Subsidiary. Did you know that you can view these amounts in the base currency of their respective subsidiary and view the original amounts in transactions (for example: Foreign Amounts entered in an Invoice) Here how:

1.) Navigate to List > Search > Saved Searches > New

2.) Select Transaction

3.) Add a Criteria

Type (Optional) – For your Transaction Type

Subsidiary (Optional) – Select Subsidiary

Period (Optional) – Select an Accounting Period

Account (Optional) - If you wish to view balances of a particular account

4.) Under Results tab set the Consolidated Exchange Rate = None

When this is set to None, the Consolidated Exchange Rate is not applied to the Amount, this will make the amount column results to per Subsidiary.

5.) In the Results tab column, make sure that you add these important fields:

Amount – This will be the amount posted in the G/L of the transaction subsidiary. You can rename this to Subsidiary Base Currency Amount

Currency – This the Transaction Currency

Amount (Foreign Currency) – This is the transaction currency, please take note that even if the transaction is posted in the same currency of the subsidiary, this will still column will still have values. You can rename this to Transaction Currency Amount

6.) Rename Saved Search

7.) Save and Run the Report

Results:

In this example, Invoice # 266 is recorded using Philippine Peso, but it is posted in a German subsidiary with a base currency of Euro. Here is the original transaction:

Subsidiary Base Currency Amount is equal to Exchange Rate X Transaction Currency Amount, in this scenario PHP 25,000 X 0.0171 or €427.50 in the G/L Impact

Have you tried this Saved Search? Feel free to share your tips!

I hope this helps 😃    

Sample Scenario: On instances where the Sales Order is paid partly by Gift Card and partly by a Credit Card and the Credit Card declined but the Gift Card balance is not enough to cover for the Sales Order total eventually having the Sales Order cancelled, the fund in the Gift Card does not automatically get credited back. Below are the steps to move the fund back to the Gift Card:

1. Create a Credit Memo to reflect the unused GC amount
2. Create another GC
3. Apply the said credit memo

Detailed Steps:

I. Creating a credit memo

1. Go to the Invoice record with which the Gift Certificates were bought.

2. Click Credit button to create a Credit Memo.

3. In the line items you will see all the items bought in that Invoice. Click the line item which has the same code with the Gift Certificate you're having issues with.

4. Hit Save.

Now you have created a Credit Memo for the customer.

You then have to create a GC and apply the Credit Memo you just created.

II. Creating a new GC

1. Create an Invoice

2. Type in the Customer Name

3. Input the GC in the item > Input Amount

4. Hit Save

III. Applying Credit Memo on the Invoice

1. Navigate to Transactions > Customer > Accept > Customer Payments

2. Type in the Customer Name

3. Under the Invoices Tab > Check the Apply box on the Invoice

4. Under the Credits tab > Check the Apply box on the Credit memo

5. Hit Save

Note: If the Payment Method is required, just pick any Payment Method. This will not affect the process.

You can now check the Invoice of the new GC and it would show that it was paid in full. Your customer can now use this new GC on other transactions.

To other members, please feel free to share your thoughts on the thread if you have other ways to put the fund back to the Gift Certificate with a cancelled Sales Order.