Free Articles, Free Web Content, Reprint Articles
Saturday, July 4, 2020
 
Free Articles, Free Web Content, Reprint ArticlesRegisterAll CategoriesTop AuthorsSubmit Article (Article Submission)ContactSubscribe Free Articles, Free Web Content, Reprint Articles
 

Freight Forwarding ERP: Microsoft Business Solutions Great Plains customization & setup – overview

Microsoft Great Plains may be recommended for international freight forwarding / transportation company.  Great Plains has such features as multicurrency (Euro, Pound, Yuan, Yen, Peso, Real), Spanish, French, Brazilian Portuguese (and if needed Unicode-specific languages such as Chinese, Japanese).  If you have operations in East Europe – you can have Polish version as well as you can have several screens (SOP Entry, Inventory Item Maintenance, Customer/Vendor Maintenance, etc) translated to Russian, Lithuanian, Latvian. 

Plus – if you consider Great Plains as a platform for custom tailoring and developing – you can have reasonably priced solution for horizontal business, such as freight forwarding, cargo delivery, consignment, transportation.  Let’s consider industry specifics and the way to implement them in Microsoft Business Solutions Great Plains

  • Agent Settlement.  Freight forwarder usually deploys agents to deliver shipment.  And agents are usually paid on the monthly or semimonthly basis.  This means that you should have agents as customer.
  • Daily Agent MBL invoices/statements.  Assuming that agent is handling several shipment with Master Bill of Ladings (MBL) and House Bill of Ladings (HBL) per day – freight forwarder emails to the agent daily invoices.  Then these daily invoices are settled and paid one time per months
  • Cargo Tracking System.  This is usually custom in-house made system, specific to each freight forwarder or industry specific stand alone software.  The important requirement is the integration between Shipment Tracking System and ERP, such as Great Plains
  • Accurate in-time payments.  Payments are required to stay in highly competitive business, such as freight forwarding
  • Bill of Lading report.  Where you usually need additional info to standard invoice form: Carrier, MAWB, Airport of Departure, Airport of Destination, Flight #/ETA, Weight in KG, Lbs, number of packages, etc.

Technologies and customization tools:

  • Great Plains Dexterity.  This is Great Plains Software and currently Microsoft Great Plains programming language and IDE.  It will allow you seamless integration with Great Plains user interface.  You should realize agent settlement screen and inquiry, MBS/HBL profit/loss inquiry form and probably Bill of Lading in Great Plains Dexterity.
  • SQL Integration.  Integrating with Cargo Tracking/Delivery system should be done via SQL stored procedures.  Use ODBC Linked Server to link to your tracking system database (MS SQL Server, Oracle, DB2, Unidata, Pervasive SQL, Ctree/Faircom, mySQL).
  • Web Order Entry.  Use eConnect to avoid high user license cost in Great Plains.  eConnect is SDK to reference Great Plains objects – you will need SOP and POP orders entry
  • Customer/Vendor Consolidation.  For agents, who are customers and vendors at the same time use consolidation module.  It is available for Great Plains Professional only – if you’d like to stay with Great Plains Standard – use Great Plains Dexterity to program the consolidation.

Good luck in implementing and if you have issues or concerns – we are here to help! If you want us to do the job - give us a call 1-866-528-0577Find Article, 1-630-961-5918! help@albaspectrum.com

Source: Free Articles from ArticlesFactory.com

ABOUT THE AUTHOR


Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies – USA nationwide Great Plains, Microsoft CRM customization company, serving clients  in Chicago, California, Texas, Florida, New York, Georgia, Arizona, Minnesota, UK, Australia, Canada, Mexico and having locations in multiple states and internationally ( http://www.albaspectrum.com ), he is CMA, Great Plains Certified Master, Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer. You can contact Andrew: andrewk@albaspectrum.com



Health
Business
Finance
Travel
Technology
Home Repair
Computers
Marketing
Autos
Family
Entertainment
Education
Law
Communication
Other
ECommerce
Sports
Home Business
Self Help
Internet
Partners


Page loaded in 1.815 seconds