Hi, @Marcel.Ausan , @TimeMarBou For your information, finally, the script we did worked fine without any changes in the past data,.it did in the same time:select the “currency balance” set up to ticked select currency code part to “blocked”this worked fine for all accounts we wanted (whatever they had curr part code J already used or not). 😀We didn’t changed the past accounting data. 👍For past years, we had been able to do the currency revalution process using the account already selected with “curr balance” + we did a manual voucher for the others accounts.Then, for the future, it will be OK using any account ticked with “currency balance”.The currency spread we had on few cents, has been corrected by reprocesing the annual closure process again.Hope this helps, ThanksCamille
Thanks @Marcel.Ausan and @TimeMarBou for your answers !We will try to keep the script with the same process but only for the middle part: select the “currency balance” on the related accounts which are not used with Currrency code part J in postings and we will recreate new accounts with Currency balance selected and migrate the balance from old accounts to the new accounts created using Q voucherUnfortunatly, we have many accounts to change…but this process seems easier and proper, without data repairs…Thanks for you answers, Camille ,
Hi,following our tests at this step, the script is KO, as it does have an impact on the Balance analysis view, the result is not correct on this view… We are trynig to correct the script to restaure correctly the data in the Balance view but not I’m not sur this is possible.Does someone already had to tick the checkbox “currency balance” on accounts already used ? with correction on past vouchers ? How did you select the checkbox? Is it feasable?I’m interested in all solutions or ideas.ThanksCamille
Hi @TimeMarBou , thanks for your answer. to answer your questions and comments:yes of course we are doing many tests in TEST environnements, recently copied from PROD. yes using a counter account for the voucher does calculate new balances in this account, you should use statistical account only for counterpart in that case.@Marcel.Ausan thank you too, To explain better the current scenario:There is no issue on the GL finally, only the currency balance are not fully calculated, but to have them calculated, we need the “currency balance” tick on the account and then only, we have to recreate a manual voucher that does generated, after the correction, the currency balances.prerequesite: have the year concerned open, if not - do the process to rollback the YE voucher and reopen the year cconcernedWe have this situation: Accountabilty EUR Currency transactions Parrallel Curr EUR GL sum in the accounts 10 5 10 step 1 :GL voucher manual correction to set balance to null -10
Hi @Marcel.Ausan , Yes I think I found a way to correct this.@Ralph Gericke The balance in EURO was OK, in parallel currency too and I didn’t had any error message saying that the balance in Currency was KO. The ticket you are refering did’nt answer my query, I already have been through it.Our situation is different:We have a difference betwen the GL sum amount and the General balance (comparing the view “GL voucher Rows analysis” and “GL balance accounting” view) but only in currency transactions amounts and we are able to generate the YE voucher but, this one doesn’t fecthed all the amounts in currencies which are in the GL.Indeed its seems that the YE voucher is not fecthing the data from the GL … but from the Balance view. Finally, There is a mistake in my previous post, the balance view is equal to 53K in currencies.Reason: A list of account, related to the spread we had did’nt had the checkbox selected “currency balance” so they didn’t generate any currency balance. Consequently,
Hi Nancy, Thank you for your answer, you are right, the issue is more on the Customer Order process invoicing itself than on the Advance Invoice process flow. I don’t know for collective invoice…. this is out of scope, The quick order flow shoes nothing after because the last step on the flow is done. I should be able to create the invoice.But, you’re true, I cannot manually create the final invoice on a CO with or without Advance Invoice connected.I guess the actual settings doesn’t allow that process. Or IFS doesnt’ let us create final invoice on CO with automatic flow when an advance invoice is already created…Thanks for your help, Camille
Thank you Nancy, But as I said, I cannot create the customer Invoice in the screen “create customer invoice” , my Customer Order doen’t appears. How can I create the CO Invoice? It seems easy but it’s not available.
Hi Lihini, Ok thank you for your answer. Well noted for the subfamily code, it’s not fetched.I already defined the family code “ICDT” for the issuer BAI but it’s not enough to match the transaction, IFS doesnt’ recognize it as a “supplier payment” in the External Payment screen. I added some pseudo codes for other messages codes (275 /ex). but not the 466. Is it mandatory to connect the messages codes to a pseudo code to fetch the correct transaction type in the External Payment screen? thank you Camille
Hi Lihini, Thank you for you answer, it clarifies a little how IFS reads the messages codes from the bank in the XML file but it doesn’t really answer my question. Does IFS automatically recognized the Domain/ Family or Sub Family Codes? Or do we have to set up the 3 types of messages codes? I already set up the message code “ICDT” wich comes from the ISO transaction code list - family code, connected to the issuer "BAI" in the External Payment Parameters window.But it did not matched when I importeted the bank statements, so I added the specific messages code from the issuer BAI. Finally, it matched better when I imported the bank statement !As you can see in the XML extract (previous post), the message codes are populated in both entry: the Entry details (field BkTxCd) and "Prtry".As I understand , you said that there is a priority in IFS to read the message code?Does IFS read first the proprietary message codes, then the ISO messages code?Do we have to enter both in the External pa
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.