Hi wanted to ask help. Is there a way that you can...
# accountingj
Jacob
07/25/2023, 11:58 PMHi wanted to ask help. Is there a way that you can control what specific accounts to use on where the Realized Gain/Loss amounts gets posted ?
m
Marc
07/26/2023, 12:11 AMConfigurr you foreign currency variance rules
j
Jacob
07/26/2023, 9:44 AMThanks a lot!
m
Melvin Pastores
07/27/2023, 9:36 PM@michoel @Marc I configured the foreign currency variance rules. How do I fire it off? I tested a transaction but the rule didn't do anything?
m
Marc
07/27/2023, 9:42 PMShow me the rules please
You need to select subsidiary , account type , gain or loss ( realized or not ) etc
m
Melvin Pastores
07/27/2023, 9:43 PMI did a very basic one
m
Marc
07/27/2023, 9:51 PMCould you delete the field account
And use that :
Account type : account payable , receivable , other current asset , other current liability,unbilled receivable
Gain/Loss : Gain
Variance type : realized
Subsidiary : select all
Create the same for Loss
Marc
07/27/2023, 9:52 PMThen you can create a bill and bill payment who use different exchange rate than bill
m
Melvin Pastores
07/27/2023, 9:52 PMOk, let me try.
Melvin Pastores
07/27/2023, 9:56 PM@Marc what is gain/loss : gain?
Melvin Pastores
07/27/2023, 9:56 PMI only have this
m
Marc
07/27/2023, 10:01 PMStrange you don’t have gain/loss ?? Because on my Netsuite I have
Marc
07/27/2023, 10:02 PMm
Melvin Pastores
07/27/2023, 10:03 PMYeah I don't some of the fields listed on the criteria
Melvin Pastores
07/27/2023, 10:03 PMProbably missing a setup somewhere
m
Marc
07/27/2023, 10:04 PMAre you admin ?
m
Melvin Pastores
07/27/2023, 10:05 PMyeah
m
Marc
07/27/2023, 10:05 PMThe setup is just to enable the feature
Marc
07/27/2023, 10:05 PMDo you have something similar in the list?
m
Melvin Pastores
07/27/2023, 10:06 PMI'm doing in this in sandbox. I don't think that should make a difference
Melvin Pastores
07/27/2023, 10:06 PMthe remaining drop down are custom fields
Melvin Pastores
07/27/2023, 10:07 PMm
Marc
07/27/2023, 10:09 PMHave you enable the feature multiple currency ??
m
Melvin Pastores
07/27/2023, 10:09 PMyes
m
Marc
07/27/2023, 10:09 PMHave you check in the sandbox ?
Marc
07/27/2023, 10:10 PMYou can test without gain/loss
But open a case to know what is the problem
m
Melvin Pastores
07/27/2023, 10:10 PMyup, it's enabled
Melvin Pastores
07/27/2023, 10:10 PMm
Marc
07/27/2023, 10:13 PMYour destination account is the system generated account ?
Marc
07/27/2023, 10:14 PMIf yes can you test with another account and check if you can select the value in the list
m
Melvin Pastores
07/27/2023, 10:14 PMNo, its a new account
m
Marc
07/27/2023, 10:16 PMStrange ..
Can you try with csv import , and check if you can select the gain/loss
m
Melvin Pastores
07/27/2023, 10:18 PMI was able to make it work without the gain/loss criteria
m
Marc
07/27/2023, 10:20 PMOk but in your test it’s a gain or loss ?
Because I don’t know if it loss , the account used in this case is gain ( account destination on your variance rule )
m
Melvin Pastores
07/27/2023, 10:21 PMit's a loss
Melvin Pastores
07/27/2023, 10:21 PMso I should test a gain to see if that works?
m
Marc
07/27/2023, 10:23 PMI think it will work for gain and loss.
the only problem is that in your variance account you have entered a gain account
so if you have a loss like the test you just did, it will impact the wrong account
m
Melvin Pastores
07/27/2023, 10:25 PMthe variance type?
Melvin Pastores
07/27/2023, 10:25 PMMelvin Pastores
07/27/2023, 10:25 PMor do you mean the destination account?
Melvin Pastores
07/27/2023, 10:26 PMMelvin Pastores
07/27/2023, 10:30 PMI found the gain and loss. I don't why it's translated in a different language.
Melvin Pastores
07/27/2023, 10:30 PMI think I'm in good shape. I have a path to move forward. Thanks for your help
m
Marc
07/27/2023, 10:38 PMAhhh good news
Cool
Marc
07/27/2023, 10:39 PMoh sorry I hadn't seen that in your destination account you put an account that manages losses and gains. So you don't even need to add the loss/gain criteria
3 Views