By using this website, you agree to our Terms of Use (click here)
Hello
I have an issue using a Budget import scenario. The data provider is Excel and the mapping is all good. The Import by Scenario works if I upload a new file version and do the Prepare. Up to this point all is good. When doing the Import function,after prepare, on the title bar it fails with an error that duplicate account/subaccount is not allowed.
So the question is...
Does Budget by import scenario only imports multi branch (its a consolidated ledger) budget records once? If not, how do I then get it to overwrite my previous import?
I do not really want to go upload branch by branch, since there is about 12 branches.
Version is 2018R1 Build 18.111.0019
Without knowing anything about importing budgets, the best way to debug an Import Scenario that's failing is to replicate what the scenario would do manually. In other words, try to assign the fields on the relevant page in the same order being done in the Import Scenario. Hopefully you should encounter an error and a message that may shed some light on your issue.
Thank you Royce
Have tried that already. The scenario imports fine for the 1st time. Its the update of the current budget that fails on the scenario, but works fine manually, even the screen import works fine.
If you can do it manually but the Import Scenario cannot do it that means something is wrong with your Import Scenario or the order of processing in your Import Scenario doesn't match the order followed when you did it manually.
Duplicate account, sub account error makes sense to me as i believe you cannot duplicate those values for a given ledger & financial year. How is it then possible that you were able to enter a duplicate row manually?
If you want to have an import scenario that updates existing rows you need to use different logic to one that inserts new rows. Are you familiar with Import Scenarios that update existing data (by searching for key values)?
Hi Royce
You are right. I think the scenario does not have the necessary instruction to indicate an overwrite of excisting records.
I am not familiar with the overwrite instruction in scenarios. Will investigate.
I think you'd probably have to identify row numbers in your import scenario which would get really messy since the number of rows could vary.
Online Members
