Could anyone give me tips on importing financial history using DTW?

[Former Member]

Hi Forum,

I have not tried this yet, but will be trying soon - that is importing History (closed transactions) of old Financial transactions such as A/R and A/P invoices, Banking Transactions, Manual Transactions such s Payroll in their system etc.

Have you done this type of import using DTW? Please help me out here, any tips so I don't go off the wrong path for days and weeks?

Anything about period creaton, open or closed statuses while importing etc? Where do we start and how?

Thank you all very much.

[Former Member · Accepted solution]

Hi,

What is the reason you need to import financial history? It is never a good idea for this. You may import open balance only. Otherwise, it may not have benefit but more troubles.

Thanks,

Gordon

[Former Member · Accepted solution]

Hi Gordon,

What you mentioned is exactly what I have learnt from SAP B1 tutorials and may be generally the practice in ERP world.

However, the customer is desirous of the history, they only have financial for non-inventory items. Therefore, I am going to give it a try. It may be hard but it should be possible.

Waiting on others' commends and experiences in importing financial history of closed transactions?

Thanks.

[Former Member · Accepted solution]

Hi Sted,

It is more usual to import journal entries for history in order to generate accurate financial reports, and only import open documents which need to have due dates managed - even then journals are OK for these as they are now available in payments and payment wizard.

[Former Member · Accepted solution]

Julie is correct. If your customer insists on import history, only JE or open documents may be imported but not closed documents. Also warning them that to match B1 with their old system is not possible. Do not try!

[Former Member · Accepted solution]

Thank you Gordon and Julie. Now I know which path not to go in to - importing closed documents!

Appreciate your expertise!