Skip to Content
0
Former Member
Feb 04, 2013 at 09:03 AM

Import without Deleting the Manual Input Form Data

27 Views

Hi Experts,

We have the following requirement for a consolidation model. The model is a copy of the IFRS starter kit.

We want to import a trial balance file to the input AuditID (DataSource) and then later, key in additional information (e.g. detail flow) via the input forms to the same AuditID. This process is consistent with the toolkit approach.

If there are changes required in the original trial balance file, I want to re-load the trial balance without losing all the manual work done via the input forms. In my experience with BPC 7.5 MS, an import deletes the manual data for the same entity and period.

I see there are various import options in the NW version, and will test shortly once my system is available. Other than using a different AuditID for the input forms are there ideas as to what we can do to fulfill this requirement?

The import for trial balance uses one set of FLOWS (end balances – BS & PL -> F99 & PL99) and the detail uses another e.g. additions/reductions F20 & F30.

Thank you in advance.

We are using the IFRS starter toolkit.

NW 10 SP9

Eyal Feiler