General Blog

Also, we heard observations from accumulated accounting people, as able-bodied as from Dynamics GP anatomic consultants that this address is about difficult exercise if approved to be advised in FRx or Dynamics GP Address Writer assuming that you are not demography Great Plains Dexterity customization route. In this baby advertisement we would like to accord you hints on how to architecture this address in Crystal Reports:

Reporting Logic. This address should abridge all Accounts Receivable annual Debits (with Returns, counted as abrogating debits), but alone for affairs with SJ and RMJ types: acceptation alone Sales Order Processing Invoices, Returns and Receivables Management bore Invoices, Debit memos, Credit memos. This AR Debit arbitrary should not cover any payments. Now from the Credit ancillary you should attending at all Sales accompanying accounts: Sales, Freight, Miscellaneous Charges, Sales Tax Payable, VAT payable

Under the hood. We accept that you are on Microsoft SQL Server 2005 or 2000 DB belvedere and you will be architecture SQL concern as SQL stored action and will abject Sales Journal Register address on the SQL stored procedure, area you will accumulation Date From and Date To ambit fields. Ideal activity looks actual attractive, but in absolute activity you see assorted alterations to SOP and RM abstracts distributions. This is why we acclaim you to physique SQL Select account to get a account of all the accounts, accommodating in Sales Invoices and Returns distribution. You can get it from GL20000 table, afresh authoritative restrictions on Journal type: SJ and RMJ. Accounts numbers and names should be queried to GL00100 table – Annual Master

Sales Journal Affairs Audit. Cover Select account data in hidden physique area of the address with the advantage Drill Down OK. If you analysis the anatomy of GL20000 table, you will apprehend that it includes Customer ID in ORMSTRID field, Customer Name in ODMSTRNM and Sales Invoice or Return amount in ORDOCNUM field