Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Data Importing Processes
05-28-2012, 05:58 AM, (This post was last modified: 05-28-2012, 06:17 AM by Rock*Star.)
#1
Data Importing Processes
I am working on my first webERP system for a client and stumbling through the learning process along the way. I am learning the system backwards because I am a programmer, not a user, and my first task is to data convert the data from the soon to be "old" system.

I thought I would begin a narrative. I think it could help others later, and I could use some help along the way.

I will further fine tune the data import procedures later as I have further discussions with the client on changes that they want made to the way webERP currently works. I hope they are minimal, but there will be changes, this will be an adventure.

I did the customer file first and you cannot do the customer file, debtorsmaster without also doing the customer branches file, custbranch. The old system had a "ship to" file which is similar in concept, but they had a choice to ship to the address stored in "debtorsmaster" or to a "custbranch" address, or to one time shipping locations so the sales orders and invoices had to retain the ship to address on a document by document basis.

I have the item file and warehouse files loaded, stockmaster and locstock.

I have sales order header and sales order items, salesorders and salesorderdetails.

Now, I have to get the invoice header and invoice lines files into webERP which looks like debtortrans and stockmoves will be my main insert files. Hoping I can do gltrans, stockmovetaxes, audittrail, debtortranstaxes transactions later and they won't stop me from getting simple invoice history into the system.

Periods and salesanalysis might also come into play

I think I am going to pause first and talk to the client. I would rather not have to dig into importing all the types of things that can happen with invoices, including credits and debits, and write offs, and so on. Hopefully I can just have them start with open sales orders, and give them historical reports by the union of old system and new system data via a report writer.
Reply


Messages In This Thread
Data Importing Processes - by Rock*Star - 05-28-2012, 05:58 AM
RE: Data Importing Processes - by phil - 05-28-2012, 07:40 PM
RE: Data Importing Processes - by Rock*Star - 05-28-2012, 11:05 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)