GL Registry

G/L Register enhancements

Dynamics SL users are accustomed to processing data entry in batches, with multiple documents per batch. Users are then able to reference the batch for later review, based on the batch and reference numbers of the documents in the batch. The GL Register Enhancement provides an easier way for Dynamics SL users to access ledger entries they created in Business Central D365 with links to the Vendor and Customer List pages, and the addition of a Created By User ID field in the G/L Register. This Created by User ID field lets users filter ledger entries based on their User ID, thus emulating the batch retrieval experience with which they are familiar.

In addition, new fields in data entry pages provide batch control total checking, like those found in Dynamics SL screens. These fields allow the user to enter a control total of all documents before data entry begins. A second field provides a total that is incremented as data entry occurs. A third field tracks the difference between the control total and the incremented total and alerts the user of any differences so that edits can be made before completing data entry.

Changes to Customer and Vendor Lists and Ledger Entry pages

A new Ledger Entries link accessed from the Vendor dropdown is added to both Customer List and Vendor List pages. In addition, a new Created by User ID field is added to Customer Ledger Entries and Vendor Ledger Entries pages which displays the User ID of the user who created the entry. This allows filtering and sorting on that Created by User ID field in the ledgers.

Changes to Purchasing and Sales Invoicing

Three new fields are added to the General fast tab of the following documents:

  • Purchase Quote
  • Purchase Order
  • Purchase Invoice
  • Purchase Credit Memo
  • Purchase Return Order
  • Sales Quote
  • Sales Order
  • Sales Invoice
  • Sales Credit Memo
  • Sales Return Order

The new fields added are:

  • Total Document Amount: this field is completed by the user with the total amount of the sales or purchasing document. This is like the Batch Control Total field in Dynamics SL.

  • Total Document Lines Amount: this field calculates the total amounts entered on all lines in the document. It increments as lines are created in the document.

  • Difference: this field calculates the difference in the amounts between the Total Document Amount and the Total Document Line Amount.

SL Overlay Setup changes

  1. A new option Show Document Total Fields on Document Header is added to the SL Overlay Setup page to enable or disable this feature.
  2. A new option Restrict Posting if Difference is not zero on Document Totals is added to the SL Overlay Setup page to restrict posting if the Difference field is not equal to zero when the user posts the document. If enabled, the user will receive an error message that the document will not post because the difference does not equal zero.

Post and Print changes in Documents List

  1. A new Post and Print option is added to post documents from the Document List page that are ready to be posted or based on the filters set in an Option page. It will process the Posted Documents based on the Document Sending Profile set up for the Vendor or Customer. If a Document Sending Profile is not set up for a Vendor or Customer, the Posted Document will print to a PDF.

Purchase, Sales and Cash Receipt Journal changes

A new Total Vendor Lines field is added to the Purchase Journal and a new Total Customer Lines Amount field is added to the Sales Journal and Cash Receipts Journal. This field adds the total amounts in the lines posted to the Customers/Vendors in the Purchase, Sales and Cash Receipts Journals to show the Document/Payment total in the journal.

G/L Register changes

A new Created By User ID field is added to the GL Register page which allows for filtering on the User ID of the user who created the entry.