Invoices are handled using an efficient electronic workflow process. A strict authorisation hierarchy is in place, based on the size of the invoices being handled. Invoice approval is integrated with the rest of the accounts payable process, and invoices can be accessed via systems like SAP or JDE. Where associated documents are in the system, these are stored in the same file alongside invoices so they can be located quickly and easily. One office processes purchase invoices for all the other offices in the UK, and they are initially processed using the Oracle Financials system.
When you have a system be vigilant! Make sure your people are accurate and timely with their entries, and make sure accounts are prompt in issuing invoices! Of course don't forget normal debt collection practices, there's no point issuing invoices promptly and then having poor follow up. So, throw out those paper based timesheet systems, throw out the spreadsheet timesheet systems that the wheels are falling of off, and move to a modern timesheet software system today. A timesheet software package like Timesheets MTS or Timesheets Lite is simple to administer, is simple for the casual user to enter time, and most importantly is simple for the accounts department to use and generate the reports they need for prompt invoicing. It can however be reproduced in full on any web page as long as it is edited in no way whatsover. Get low cost, efficient, timesheet software! This article is © Moving Target Software, 2004.
However when we are talking about large businesses - these checks have invoices printed. None, Document Number (when you have ACH), Due Date/Oldest Document, Due Date/Oldest Invoice (other than invoices you apply manually), Document Date, Specific Invoices (and you specify them in the list. This is still OK if you have a lot of small customers with one or few outstanding invoices. Lockbox is Dexterity piece, so it is in the hand of Dexterity Developer, if you need to improve it for your corporation. VBA Modifier and Continuum are also available.
This should be realized as Great Plains Dexterity custom window, with two scrolling windows on it, where you should list SOP Invoices and POP Shipments with Invoices. This system is primary source of information about the shipment, then all the collections and fees and associated customer and vendor invoices are moved to Accounting Application, such as Microsoft Great Plains. Stored Procedures and also Great Plains Dexterity for Screens and Reports - this is Great Plains Software (currently Microsoft Business Solutions) proprietary software development language and IDE. Use the same Great Plains Dexterity custom window technology. Batches then should be processed by AP/AR departments.
Customers, Invoices, Purchase Orders, etc. Net customization to link SOP and POP invoices in the settlement process. You use agents and settle their AR/AP invoices on the monthly or weekly basis. You should create heterogeneous SQL view and base you Crystal Report on this view. Microsoft CRM security suggests you to use MS CRM SDK or built-in Crystal Reports Enterprise to comply.
As we expect to do the business in Mexican pesos - all the Purchase Orders, Vendor Invoices, Some sales invoices (what we sell to the parent company in the USA, for example) will be stated in Peso. Some functionality could be realized through Microsoft Business Portal - which is web-based application. The other way is to have server in Mexico and have relatively inexpensive Microsoft Great Plains data be consolidated with Oracle, SAP, PeopleSoft based system in the USA. Consider Windows 2003 Terminal server licenses. You can host your Great Plains installation in the US and have Mexican users connected over the remote desktop connection.
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. Use eConnect to avoid high user license cost in Great Plains. 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.
The same symmetric procedure is for vendor invoices in Purchase Order Processing (POP. We recommend you to use integration manager to bring customer and vendor invoices and payments and post them in Great Plains. In Great Plains Accounts Receivables and Accounts Payables invoices have open status if payments are not yet applied to these documents. Conversion means the process of extracting data from your legacy application and massaging it to be ready to be fed to Great Plains. In case of each specific system you should use specific approach.
If you are trying to relay on eConnect exclusively and not researching Great Plains Architecture - you will need additions to eConnect from third party vendor, such as Alba Spectrum Technologies, which has the whole set of SOP populating stored procedures. Andrew is Great Plains specialist in Alba Spectrum Technologies ( http. For eCommerce developer the most important is to understand Great Plains tables structure and business processes in Sales Order Processing, Accounts Receivables, Inventory Control (inventory items allocation, backordering, etc), posting to Bank Reconciliation and General Ledger. And this is where Great Plains structure seems to be not transparent. Microsoft Great Plains, designed back in 1990th as database transferable and graphical platform independent ERP application - Great Plains Dynamics/Dynamics C/S+/eEnterprise.
Receivables Management Module - When Sales Order Processing Invoices are posted - they create record in Accounts Receivables or Receivables Management Module. Look at SOP10100, SOP10200 and other tables with SOP prefix. The reason is - it works with Inventoried items and typical eCommerce is ordering specific items off the internet. So we would recommend sticking to stored proc. Usually eCommerce solution works around Sales Order Processing tables.
We recommend you to deploy Great Plains Integration manager to import Vendor and Customers plus open documents. Historical transactions, if needed - should be moved by outside consultant. Microsoft CRM has import tool - try it first and subcontract more complex - attachments, for example. Great Plains requires consultant help to be implemented and integrated, because it has sophisticated tables structure and documents flow mechanism. Microsoft CRM should be probably tried as in-house pilot implementation with 5 users license and then you can purchase additional license as you have your users trained.
In Great Plains you naturally use Receivables Management invoices for this purpose. Feel free to use popular tools, such as Crystal Reports - you usually base your Crystal Report on SQL view or stored procedure (the second one allows you to use parameters and build temp tables in the body of your stored procs. If you are building web-application you can incorporate Crystal Report in it or deploy html publishing directly with your result set. Net, Crystal Reports and Microsoft CRM SDK developer. 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 and having locations in multiple states and internationally ( http.
Customer, Transaction (invoices, returns, layaways and others), TransactionAmount, Cashier, Tender to give you examples. Advanced Techniques - in MS SQL Enterprise Manager you can create Linked Server to all ODBC/OLEDB compliant databases. Ctree, PervasiveSQL/Btrieve, MS Access, ORACLE, DB2, Unidata, Navision (C/ODBC) and using OPENROWSET construction you can create geterogeneus view and stored proc - then you can have the data from multiple systems in your Crystal Report. Headquarters database doesn't create its own transactions - so be careful and do not try this type of data integration. SQL Views and Stored Procedures - yes - feel free to create them directly in RMS Headquarters database and deploy in your Crystal Report.
Create SQL Query to probe the data - we always recommend tuning your query and see that you are getting adequate results - in any case - Crystal Report is just a nice tool to show the results of your query.
Consider SQL Views - if you don't want complex links in Crystal Report itself or if you need unionization from several companies - SQL view is the answer. Net, Crystal Reports and Microsoft CRM SDK developer. Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies - USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, Los Angeles, San Francisco, San Diego, Boston, New York, Houston, Dallas, Miami, Atlanta, Minneapolis, Seattle and having locations in multiple states and internationally (www.
Create ODBC connection to GP Company database.
If you are on Great Plains Standard version. Andrew is Great Plains specialist in Alba Spectrum Technologies ( http. DIC and fill the gaps with RW_ functions - these are allowed to be placed on the report with parameters. When you need cross-modules data on the same report (Bill of Lading, which you could produce on the base of Picking List) you need to move the report you want to customize into your custom DYNAMICS. Let's first look at the advantages of using ReportWriter.
|
|
Microsoft Great Plains customization - Freight Forwarding/Transportation industry example
Accounts Payable: A Powerful Document Management and Workflow Solution