Sales,Register,Report,Great,Pl computer Sales Register Report: Great Plains Dynamics GP Reporting Sa
Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc ----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a
Also, we heard observations from corporate accountingpeople, as well as from Dynamics GP functional consultants that this report istypically difficult exercise if tried to be designed in FRx or Dynamics GPReport Writer (assuming that you are not taking Great Plains Dexterity customizationroute). In this small publication wewould like to give you hints on how to design this report in Crystal Reports: 1. ReportingLogic. This report should summarize allAccounts Receivable account Debits (with Returns, counted as negative debits),but only for transactions with SJ and RMJ types: meaning only Sales OrderProcessing Invoices, Returns and Receivables Management module Invoices, Debitmemos, Credit memos. This AR Debitsummary should not include any payments. Now from the Credit side you should look at all Sales related accounts:Sales, Freight, Miscellaneous Charges, Sales Tax Payable, VAT payable 2. Underthe hood. We assume that you are onMicrosoft SQL Server 2005 or 2000 DB platform and you will be building SQLquery as SQL stored procedure and will base Sales Journal Register report onthe SQL stored procedure, where you will supply Date From and Date Toparameters fields. Ideal life looks veryattractive, but in real life you see various alterations to SOP and RM documentsdistributions. This is why we recommendyou to build SQL Select statement to get a list of all the accounts,participating in Sales Invoices and Returns distribution. You can get it from GL20000 table, againmaking restrictions on Journal type: SJ and RMJ. Accounts numbers and names should be queriedto GL00100 table Account Master 3. SalesJournal Transactions Audit. IncludeSelect statement details in hidden body section of the report with the optionDrill Down OK. If you review thestructure of GL20000 table, you will realize that it includes Customer ID in ORMSTRIDfield, Customer Name in ODMSTRNM and Sales Invoice or Return number in ORDOCNUMfield 4. Letus know. The paragraphs above shouldgive you very good start. If you feel,that you are not really Dynamics GP technical consultant or Crystal ReportsDeveloper, feel free to call or email us
Sales,Register,Report,Great,Pl