Tag: Document Date

Posting Interruptions in Accounts Payable – Check Runs

| 11/24/2011 | 3 Comments
Posting Interruptions in Accounts Payable – Check Runs

Recently, I was responding to a forum discussion where the issue mentioned was as shown below. “Occasionally, one of the subsystems that we integrate invoices from will send over an invoice with an incorrect date (11/20/1911 instead of 11/20/2011).  These invoices post just fine.  However, when we process a check run that includes an invoice […]

Continue Reading

Receivables HATB With Aging By Due Date (using Document Date)

| 07/21/2011 | 3 Comments
Receivables HATB With Aging By Due Date (using Document Date)

Hi all As a follow up to my script for generating the Receivables HATB by Document Date, I have decided to post a script for the same with aging buckets based on the due date. This will provide the aging buckets for each transaction based on the receivables aging buckets setup. /****************************************************************** Created July 21, […]

Continue Reading

Recent Updates to Payables HATB Script

| 06/30/2011 | 1 Comment
Recent Updates to Payables HATB Script

Hi all I have posted an updated for the following scripts today. Please make use of these updated scripts for the historical aged trial balance in payables. AP Historical Aged Trial Balance – By GL Posting Date http://msdynamicstips.com/2010/10/09/payables-hatb-report-sql-query/ AP Historical Aged Trial Balance – By Document Date http://msdynamicstips.com/2010/10/08/payables-hatb-using-document-date/ Hope this update helps the community… Until […]

Continue Reading

Receivables HATB Report (using Document Date)

| 11/07/2010 | 5 Comments
Receivables HATB Report (using Document Date)

Hi all Today, I have decided to post a script for the Receivables Historical Aged Trial Balance (HATB), which is generated by picking transactions based on the GL posting date for the receivables transactions. This script can also be used as a base to reconcile the sub-ledger balances as of a certain date with the […]

Continue Reading

Receivables Aging By Document Date & Due Date

| 11/07/2010 | 0 Comments
Receivables Aging By Document Date & Due Date

Hi all This is an article which explains the two different options available for document aging in receivables setup window. They are Document Date Due Date   If the aging has been setup to be determined based on the document date, the system determines the aging bucket based on the document date of the receivables […]

Continue Reading

How to get data in separate columns rather than rows in SmartList Builders (Aging, Sales by Months, etc)

| 11/02/2010 | 0 Comments

This has been on my list of things to blog about – but when I saw this post  in the Forums, I knew its time had come: I have a client who is attempting to create a Sales report which shows sales by Customer.  They want the report to include a separate column for each month – based on Document Date.  I have attempted to create a calculation for each month (If/Then) but either don’t have the syntax correct or it is truly not going to work. CASE WHEN Sales Transaction History:Document Date > 1/1/2017…   Any ideas????? This is something that seems to have become a very popular request in the last few years and I have always coded it in SQL

Continue Reading