Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Expand
titleForex - AP

Step 1: Create New Purchase Order with Currency, eg; USD 10,000 with xrate 4.4

Step 2: Create GRN by Purchase Order  → assume the xrate is remain the same (xrate 4.4)

Step 3: Refer to Supplier Invoice created from previous GRN → user can create manual Supplier Invoice if auto create SINV is ENABLED

Step 4: Create Payment Voucher and settle with SINV above

Expand
titleForex AP Gain
  • Example: PV worth USD 10,000 with xrate 4.2

Journal Entry:

Journal Entry:

  • System will auto knock off with SINV



Expand
titleForex AP Loss
  • Example: PV worth USD 10,000 with xrate 4.5

Journal Entry:

  • System will auto create Supplier Credit Memo to recognize the forex loss → refer to Supplier Credit Memo Listing or PV document pop up (related document)

Journal Entry:

  • System will auto knock off with PV


...

Expand
titleForex AR

Step 1: Create Sales Order with Currency, eg; USD 1,000 with xrate 3.5

Step 2: Create Invoice → assume the xrate is remain the same (xrate 3.5)

Step 3: Check Monitor Outstanding Documents Currency

Step 4: Create Settlement / Collection upon receive payment from customer

Step 5: If Upload Settlement upon receive payment from customer

View file
nameSettlement Upload Templete FOrex.csv
height250

screenshot-6.pngImage Added

on EMP view to key in the settlement:

Image Added

NOTES:  User need to enter Invoice Value under the payment method and the difference between the Invoice and RCT under the Forex Gain or Loss

Expand
titleForex AR Gain
  • Example: RCT worth RM 3,500 with xrate 3.2

Journal Entry:

  • System will create TWO RCT


Expand
titleForex AR Loss
  • Example: RCT worth MYR 3,500 with xrate 3.6

Journal Entry:

  • System will auto knock off with PV

Step 5: Create Reverse Receipt Voucher → if any

Journal Entry:

Step 6: Check Statement of Account Currency


...