New and updated Jiwa guides and video walkthroughs are available. See what's new
Jiwa Training Centre
Auto Light Dark
Auto Light Dark

Create a Foreign Currency (FX) Credit Note


Applies to: Jiwa 8.0
Requirements: Access to Sales Order Entry with permission to create credit notes.

Create a foreign currency (FX) credit note from an original invoice or enter an independent credit. Check the currency, exchange rate, credited amounts and stock-return setting before saving.

Before you begin

  • Have the customer, items, quantities and amounts to be credited available.

  • For an invoice-based credit, identify the original processed invoice and snapshot, and check what has already been credited.

  • Confirm the intended credit reason, stock-return treatment, currency, exchange rate and applicable tax.

See Credit Notes for Stock for the general procedure. Its screenshots use an earlier interface; the foreign currency checks here apply to Jiwa 8.0.

Check the stock-return setting before saving. When Credit Goods into Stock is selected, saving can return the credited goods to stock before the credit note is processed. Choose the credit reason and stock-return setting that match the actual return. Do not credit the same return twice.

Create an invoice-based credit note

Jiwa applies the system default exchange rate when the credit note is created. It does not select the rate from the original invoice date or necessarily copy the invoice’s rate. Check that the rate and credited amounts are appropriate for the credit.

  1. Open Sales Order Entry.

  2. Select New > New Credit Note.

  3. Select Yes at the New Credit Note prompt.

  4. Find and select the original invoice.

  5. Select the snapshot to be credited.

  6. Check the source invoice link, credit reason, stock-return setting, items and quantities. Retain only what is being credited.

Review any freight copied from the invoice. Compare the credit’s Currency, Rate, selling prices and tax with the source before changing amounts.

Example 1 — retain the default rate

The original invoice is in USD. The new credit uses the current default rate. In this example, the USD selling price is retained and its local AUD equivalent is recalculated.

Value

Original invoice

New credit

Rate

0.690000

0.675000

USD unit price excluding tax

62.17

62.17

AUD unit price excluding tax

90.10

92.10

FXCN-readable-source116-header.png
Original invoice: currency, rate and snapshot.
FXCN-readable-source116-prices.png
Original invoice line, one unit: compare the foreign and local selling prices.
FXCN-readable-default116-header.png
Default-rate credit: currency, rate and source snapshot.
FXCN-readable-default116-prices.png
Credit line, one unit: the foreign selling price is retained and the local equivalent recalculates.

Leave the default rate unchanged when it is appropriate for the credit. Check the amounts before saving.

Example 2 — change the rate

For this credit, the required rate is 0.800000. Change Rate and leave the field to apply it.

Value

Before changing the rate

After changing the rate

Rate

0.675000

0.800000

USD unit price excluding tax

62.17

62.17

AUD unit price excluding tax

92.10

77.71

FXCN-readable-changed116-header.png
Changed-rate credit: the selected rate after leaving the field.
FXCN-readable-changed116-prices.png
Credit line, one unit: compare the foreign selling price and recalculated local equivalent.

The USD selling price remains unchanged while the AUD equivalent recalculates. Review tax, freight, rounding and totals in both currencies. Use the rate required for the credit; it does not have to match the invoice’s rate.

When the original invoice’s local price was changed

If the local AUD selling price was manually changed on the original invoice, the credit note retains that local price and recalculates the USD selling price using the rate applied when the credit is created.

In this example, the invoice’s local unit price had been changed to AUD 100.00. The credit retains that amount:

Value

Original invoice

New credit

Rate

0.800000

0.675000

AUD unit price excluding tax

100.00

100.00

USD unit price excluding tax

80.00

67.50

FXCN-readable-source117-header.png
Local-price-edited invoice: currency, rate and snapshot.
FXCN-readable-source117-prices.png
Original invoice line, two units: the local selling price was manually changed.
FXCN-readable-default117-header.png
Credit from the local-price-edited invoice: creation rate and source snapshot.
FXCN-readable-default117-prices.png
Credit line, two units: the local price is retained and the foreign price recalculates.

Check that the recalculated USD amount is the amount intended for the credit.

Create an independent credit note

Use an independent credit note when the credit does not relate to a specific invoice.

  1. Open Sales Order Entry.

  2. Select New > New Credit Note.

  3. Select No at the New Credit Note prompt.

  4. Select the customer.

  5. Select the appropriate credit reason and check Credit Goods into Stock.

  6. Check Currency and Rate before adding items.

  7. Add the items and quantities to be credited.

Example 3 — independent credit note

In this USD example, the rate is 0.675000 before the item is added. The unit selling prices excluding tax are:

Order currency: USD

Local currency: AUD

60.82

90.10

FXCN-readable-independent-header.png
Independent credit: selected currency and rate, with no source invoice snapshot.
FXCN-readable-independent-prices.png
Independent credit line, one unit: review the foreign and local selling prices and line tax.

Check the item’s tax, any freight and both sets of totals. Confirm the credit reason and stock-return setting before saving.

Check prices, tax and totals

  1. Check each line’s Fx Price Ex against the foreign selling price to be credited.

  2. Check Price Ex for the local-currency selling price.

  3. Check the line’s Tax Rate, Fx Tax and Fx Total Inc.

  4. Review any freight charges in the Cartage tabs.

  5. Check the order-currency totals in the Totals tab and compare the local totals, including any displayed FX rounding adjustment.

Use the actual selling prices, not System PriceEx or Fx System PriceEx, to confirm the credited amount. System prices are separate from the credit’s selling prices. A foreign-currency credit is not automatically tax-free; check the applicable product tax and calculated amount rather than the tax-code name alone.

After changing the currency, rate or selling price on an unprocessed credit, leave the field and repeat the affected price, tax, freight and totals checks. For a tax-inclusive adjustment, check the resulting excluding-tax selling price, tax and total in both currencies. Do not use a local inclusive-price field when the intended adjustment is a foreign amount.

Check and save the credit note

  1. Confirm the customer, original invoice where applicable, credit reason and Credit Goods into Stock setting.

  2. Confirm Currency and Rate.

  3. Confirm the items, quantities, foreign and local selling prices, tax and any freight.

  4. Confirm the totals in both currencies.

  5. Select Save.

Complete these checks before following the separate processing procedure. If the rate, credited amounts or stock-return treatment do not match the intended credit, resolve the difference with your Opal Logic Jiwa Consultant before proceeding.

Video Walkthrough