Skip to Content
author's profile photo Former Member
Former Member

Import historical pre-sbo sales data

Hi,

By implementing a new case, we imported al data in the company database with the DTW.

Our customer wants to see its historical sales data in sbo. Normally historical data builds itself over time. But our customers wish is to see its pre-sbo sales data just for consulting purposes and make right decisions.

So I could import all invoices over the last 3 years in his database. By doing this, stock and inventory postings occur. It will cause a major problem to get all the bookings right. In my opinion it is not able to do this in the given time and budget.

I think historical pre-sbo data is not implemented in sbo and it isn’t possible to import this data with the DTW.

So my question sounds like:

Is it possible to get historical (pre- sbo) data in the company database without the stock postings and inventory postings occur?

If not what are the alternatives?

Kind Regards,

Eddy

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on May 19, 2005 at 11:35 AM

    Some of the techniques I have seen used by various people are as follows:-

    - Setup dummy G/L codes for the control postings and load everything as service documents to avoid stock postings, change G/L codes back to the real ones after the import.

    - Load history into UDT's and provide some basic queries to access the information.

    - Setup a separate company database purely for historic information, load the data as-is. You can then log into this database for reference to historic data, or write some cross database queries that can be run from the 'live' company database.

    None of them are particularly great, and it depends on what the customers requirements are how suitable they would be.

    John.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Couple of Q's

      Eddy , Did you get a solution to this and use it? if so what did you end up doing?

      John

      re this type of solution

      <Snip>

      - Setup dummy G/L codes for the control postings and load everything as service documents to avoid stock postings, change G/L codes back to the real ones after the import.

      </snip>

      Can you supply additional information on how to do this

      particually avoiding stock postings etc

      or can you point me to where I might find further information.

      We have a new customer looking for exactly this requirement.

      Thanks

      George.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.