Posts Tagged ‘Enterprise Resource Planning

15
Mar
15

Data Migration – Legacy System Extraction Tool

We are working on a data migration strategy to migrate current 2 years’ financial transactions to the new system.  In between, we need to determine what are the transaction data/tables and master configuration data/tables to extract from today’s legacy system over to the new one.  One concern is how to get the extracted tables to map onto 1 or more excel/CSV templates which are those that map and migrates over to the new system.

The engineer suggests we obtain the new system’s current data dictionary, share with the legacy system’s vendor to design the extraction tool to follow the new system’s structure. This will use as a supporting tool to validate the correctness and integrity of the extraction tool.

We looked onto the types of data to migrate over to the new financial system and below are the few identified:

  1. Aging ARs (Accounts Receivables) and APs (Accounts Payables).
  2. Opening balances
  3. Master data (Fixed Assets, Suppliers, Customers, etc).  Note: The fixed assets data may not need to migrate over as doing so may results double-entries of assets depreciation to the new system.

Good job, team!

Advertisements
11
Apr
09

Implement New Order Type for Cross-Docking

When comes into program’s road-map to determine potential alignments with the Customer.  We have a few new implementations, communicating from all difference sources from the Customer.  We have to have a central contact or a regional alignment personnel to synchronize the initiatives as to manage the IT cost and resources’ availability more efficiently as to align to our Global management’s directions.

For this case, we have 2 new orders types from Customer that are to be handled by our countries’ warehousing operations.  This new initiative impacts the current operations’ processes and the WMS system that we have to manage the inventories and cross-docking operations for this Customer.  The areas that I am working on to fill up the gaps on this implementation are as follows:

  1. Understand the source of the order shipment (vendors, 3PLs etc)
  2. Where the shipment is going to be lifted from to the destination Hub
  3. The receiving process at Origin/manifests
  4. Commerical invoices from source
  5. The format of the shipping documents
  6. The packing labels/Carrier logics
  7. Update of shipment milestones
  8. Update of shipment delivery dates via Call Center
  9. Financial/billing methodology for this order type
  10. Freight Management

I am not sure what other areas I may be missing to perform the gap analysis but I believe the above almost covered 80% of information I need to assess on.  Hope whoever see this blog can advise me further what else I need to take note of 🙂

05
Mar
08

EDI945 Looping Structure

Knowing that EDI945 contains consolidated shipment details for a particular Customer after a shipment is made by a depositor. It also contains information on re-conciliating order quantities with shipment quantities.

As in this document itself, we are expecting multiple shipments’ details inside it so we need to know who to differentiate 1 complete shipment’s details from this consolidated EDI945. In programming, we need to understand the structure of EDI934 on where the looping occurs. Understand from the Manager, the standard looping to follow is described below:

LX
MAN
W12
LX
MAN
W12
LX
MAN
W12
(and so on until summary section)

This is also explained from one of the forum I found on the web – http://edi.stylusstudio.com/msg01666.htm




November 2017
M T W T F S S
« Mar    
 12345
6789101112
13141516171819
20212223242526
27282930  

Categories

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 443 other followers