Hello,I am new to group consolidation and is working on an implementation. Have one question on consolidation history.Assume my client goes live on IFS on 7/1 (They are on fiscal calendar). They plan to load 20 subsidiary’s GL balance for all 12 months into IFS prior to go-live. They will have one master consolidation company. What is the easiest way to input group consolidation for pre-IFS history?Option 1Load consolidated balance history from legacy to master company only from 7/1/2021-6/30/22 to IFS.In master company start group consolidation in IFS after going live 7/1/22. Option 2Load GL balance history of each entity from 7/1/2021-6/30/22 to IFS. Run group consolidation in IFS for historical balance each month from 7/1/21-6/30/22. This is my client’s preference. Option 1 is easy, but no drill down from master to reporting entity on consolidation query.Option 2 will require lots of work but will allow user to drill down from master to reporting entity.Is there any other option I
My customer uses external tax system Zip2Tax to interface with their current ERP system Oracle application to look up/pass sales and use tax rate to Oracle. While their US company only uses external tax system to pass sales tax rate to customer order/invoice, their Canadian company uses the external system for both sales tax on customer order and use tax on purchase order. They are implementing IFS app 10 and will have to replace Zip2Tax with Vertex or Avalara. Can anyone tell me if IFS App 10 external tax interface with Vertex/Avalara work for passing Canadian sales tax (GST, PST, HST) to customer order and use tax to purchase (order) for Canadian companies? I cannot find documentation that indicates so. Any power-point slides and documentation I have read so far says customer order side only.If interface does not exist to pass tax rate onto customer order/PO/invoice for Canadian company, we have to develop interface with their current external tax system or users manually input/trac
On the external payment I created below which will replace the standard IFS BACS format for a UK customer, how do I add a function to sum the total of column “payment_amount” which is a number data type (detail tab). Without sum, the payment file output will list all supplier invoice while the file sent to bank should sum invoices to pay as one lumpsum per supplier. I did a search to list of available main functions, could not find sum function. The closest function I can find is “Add”. Am I missing something?
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.
