Sage 100

I'm not certain how this happens however a customer ( Sage 100 2018.5 just called and says they have unposted Daily Transaction Registers going back to March 2020.

However, it's not ALL their DTR. Only certain registers - namely from IM and SO. And it's only 3 pages.

I would think that this would post the next time someone updated a DTR? Or am I missing a way that these registers could go unposted for so long? 

I think in prior versions of Sage if you updated the IM or SO modules but said NO to DTR then the register would sit in the GL until someone updated specifically in the GL modules.

I'm wondering if that's what is at play although it seems like I can see the DTR in both IM/SO as well as all together in the GL if I preview the DTR.

Any idea what's going on? Naturally the customer is looking for an explanation of how this could happen.


------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990
------------------------------

What you said is exactly right.  Someone either answered No to print the DTR or answered No to update it.  Once that happens, you either have to go back to the subsidiary module and manually select the DTR to finish the post or if you go to GL and select the DTR, that pulls entries from all modules.

------------------------------
Mary Jo Krueger
Senior Software Consultant
CLA (CliftonLarsonAllen LLP)
Appleton WI
920-996-1176
------------------------------

I've always understood it to happen if someone is in GL when the other module users are trying to update the DTR.  It sits in GL DTR (I don't know if it also sits in the module DTR) but I always tell my customers to make it part of their monthly close to run the GL/Main/DTR to catch these things.
Running the next DTR doesn't catch anything sitting in limbo.

N

------------------------------
Nancy Hanson
Blytheco LLC
Eagan MN
------------------------------

Because of this I always recommend 'running the G/L DTR' as part of monthly period-end processing.

------------------------------
Brett Zimmerman
Net at Work
Greater Boston Area
------------------------------

Original Message:
Sent: 04-26-2021 20:12
From: Nancy Hanson
Subject: Daily Transaction Register Not Empty Going Back A Year

I've always understood it to happen if someone is in GL when the other module users are trying to update the DTR.  It sits in GL DTR (I don't know if it also sits in the module DTR) but I always tell my customers to make it part of their monthly close to run the GL/Main/DTR to catch these things.
Running the next DTR doesn't catch anything sitting in limbo.

N

------------------------------
Nancy Hanson
Blytheco LLC
Eagan MN
------------------------------

Agree with @Brett Zimmerman - Best practices is for someone in accounting to run the GL DTR weekly and especially at ME. 
​

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Original Message:
Sent: 04-26-2021 20:38
From: Brett Zimmerman
Subject: Daily Transaction Register Not Empty Going Back A Year

Because of this I always recommend 'running the G/L DTR' as part of monthly period-end processing.

------------------------------
Brett Zimmerman
Net at Work
Greater Boston Area
------------------------------


Original Message:
Sent: 04-26-2021 20:12
From: Nancy Hanson
Subject: Daily Transaction Register Not Empty Going Back A Year

I've always understood it to happen if someone is in GL when the other module users are trying to update the DTR.  It sits in GL DTR (I don't know if it also sits in the module DTR) but I always tell my customers to make it part of their monthly close to run the GL/Main/DTR to catch these things.
Running the next DTR doesn't catch anything sitting in limbo.

N

------------------------------
Nancy Hanson
Blytheco LLC
Eagan MN

It can be as simple as someone either accidentally said "No" to print in the first place, or said "No" to Update.  When you're so used to doing the same thing every day, if you accidentally say No, it's likely you won't even realize it.  

I love the new feature of updating the GL automatically - I've turned it on everywhere.

------------------------------
Beth Bowers
Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
Tennessee Software Solutions
269-445-1625
------------------------------

Original Message:
Sent: 04-26-2021 20:12
From: Nancy Hanson
Subject: Daily Transaction Register Not Empty Going Back A Year

I've always understood it to happen if someone is in GL when the other module users are trying to update the DTR.  It sits in GL DTR (I don't know if it also sits in the module DTR) but I always tell my customers to make it part of their monthly close to run the GL/Main/DTR to catch these things.
Running the next DTR doesn't catch anything sitting in limbo.

N

------------------------------
Nancy Hanson
Blytheco LLC
Eagan MN
------------------------------

Thanks, everyone. I thought I was going crazy for a minute. Couple this with the fact that every customer reaction these days is “how can this happen - explain it to me in detail”

---------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990
---------------------------------

We've set up a simple "Unposted DTR" alert to run nightly at a few clients (using Visual Cut) who have wasted a ton of time trying to figure out why a module doesn't balance with the GL, when there is data sitting half posted.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

Original Message:
Sent: 04-27-2021 07:39
From: Wayne Schulz
Subject: Daily Transaction Register Not Empty Going Back A Year

Thanks, everyone. I thought I was going crazy for a minute. Couple this with the fact that every customer reaction these days is "how can this happen - explain it to me in detail"

---------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990
---------------------------------

In researching this I find the feature to automatically update DTR was added in 2019.2

A security event has been added to Role Maintenance that allows you to
automatically update the Daily Transaction Register. For any series of journal and
register updates that concludes with the Daily Transaction Register, you will not
receive a prompt to print and update the register if the security event check box is
selected for your role. The Daily Transaction Register will be printed and updated
automatically.

The security event has been added for the following modules:

• Accounts Payable
• Accounts Receivable
• Bank Reconciliation
• Bill of Materials
• Inventory Management
• Job Cost
• Purchase Order
• Sales Order
• Work Order

------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990
------------------------------

@Wayne Schulz I have made it a point to include the automatic update of the DTR part of my what's new session along with the notification of a transaction date outside of a designated number of months before and after a current period.  After all this time we still get a fair number of support calls from posting to the wrong GL period, especially around the first of the year when users accidentally pick December of the new year instead of December of the previous year.  And "What do you mean my Aged Invoice Report balance does not match the GL? Why not"?​

------------------------------
alan niergarth
Velosio LLC
------------------------------

Original Message:
Sent: 04-27-2021 09:30
From: Wayne Schulz
Subject: Daily Transaction Register Not Empty Going Back A Year

In researching this I find the feature to automatically update DTR was added in 2019.2

A security event has been added to Role Maintenance that allows you to
automatically update the Daily Transaction Register. For any series of journal and
register updates that concludes with the Daily Transaction Register, you will not
receive a prompt to print and update the register if the security event check box is
selected for your role. The Daily Transaction Register will be printed and updated
automatically.

The security event has been added for the following modules:

• Accounts Payable
• Accounts Receivable
• Bank Reconciliation
• Bill of Materials
• Inventory Management
• Job Cost
• Purchase Order
• Sales Order
• Work Order

------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990
------------------------------

I have one customer that seems to have an extraordinary number of instances of posting the GL entry to the wrong period.  As mentioned by @alan niergarth  it is particularly important at year end to have the entries in the correct year / month.  I modified each  of the registers / journals to print out either "DO NOT UPDATE - Journal Period and Entry Period Mismatch" or  "OK TO UPDATE - Journal Period and Entry Period Match".  I modified the check register, electronic payment register, AP invoice register, manual check register, AR sales journal, BM disassembly register, BM production register, PO ROG register, PO ROI register, PO return register, and the SO sales journal.  Attached is the So sales journal, which is one of the easier ones to modify.  The PO ROG, ROI are more complex. 
​

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary
------------------------------

Original Message:
Sent: 04-27-2021 09:53
From: alan niergarth
Subject: Daily Transaction Register Not Empty Going Back A Year

@Wayne Schulz I have made it a point to include the automatic update of the DTR part of my what's new session along with the notification of a transaction date outside of a designated number of months before and after a current period.  After all this time we still get a fair number of support calls from posting to the wrong GL period, especially around the first of the year when users accidentally pick December of the new year instead of December of the previous year.  And "What do you mean my Aged Invoice Report balance does not match the GL? Why not"?​

------------------------------
alan niergarth
Velosio LLC
------------------------------


Original Message:
Sent: 04-27-2021 09:30
From: Wayne Schulz
Subject: Daily Transaction Register Not Empty Going Back A Year

In researching this I find the feature to automatically update DTR was added in 2019.2

A security event has been added to Role Maintenance that allows you to
automatically update the Daily Transaction Register. For any series of journal and
register updates that concludes with the Daily Transaction Register, you will not
receive a prompt to print and update the register if the security event check box is
selected for your role. The Daily Transaction Register will be printed and updated
automatically.

The security event has been added for the following modules:

• Accounts Payable
• Accounts Receivable
• Bank Reconciliation
• Bill of Materials
• Inventory Management
• Job Cost
• Purchase Order
• Sales Order
• Work Order

------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990

@Doug Higgs - you are assuming they actually look at the register before saying YES to update :) !  ​

------------------------------
alan niergarth
Velosio LLC
------------------------------

Original Message:
Sent: 04-27-2021 10:07
From: Doug Higgs
Subject: Daily Transaction Register Not Empty Going Back A Year

I have one customer that seems to have an extraordinary number of instances of posting the GL entry to the wrong period.  As mentioned by @alan niergarth  it is particularly important at year end to have the entries in the correct year / month.  I modified each  of the registers / journals to print out either "DO NOT UPDATE - Journal Period and Entry Period Mismatch" or  "OK TO UPDATE - Journal Period and Entry Period Match".  I modified the check register, electronic payment register, AP invoice register, manual check register, AR sales journal, BM disassembly register, BM production register, PO ROG register, PO ROI register, PO return register, and the SO sales journal.  Attached is the So sales journal, which is one of the easier ones to modify.  The PO ROG, ROI are more complex.
​

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary
------------------------------


Original Message:
Sent: 04-27-2021 09:53
From: alan niergarth
Subject: Daily Transaction Register Not Empty Going Back A Year

@Wayne Schulz I have made it a point to include the automatic update of the DTR part of my what's new session along with the notification of a transaction date outside of a designated number of months before and after a current period.  After all this time we still get a fair number of support calls from posting to the wrong GL period, especially around the first of the year when users accidentally pick December of the new year instead of December of the previous year.  And "What do you mean my Aged Invoice Report balance does not match the GL? Why not"?​

------------------------------
alan niergarth
Velosio LLC


Original Message:
Sent: 04-27-2021 09:30
From: Wayne Schulz
Subject: Daily Transaction Register Not Empty Going Back A Year

In researching this I find the feature to automatically update DTR was added in 2019.2

A security event has been added to Role Maintenance that allows you to
automatically update the Daily Transaction Register. For any series of journal and
register updates that concludes with the Daily Transaction Register, you will not
receive a prompt to print and update the register if the security event check box is
selected for your role. The Daily Transaction Register will be printed and updated
automatically.

The security event has been added for the following modules:

• Accounts Payable
• Accounts Receivable
• Bank Reconciliation
• Bill of Materials
• Inventory Management
• Job Cost
• Purchase Order
• Sales Order
• Work Order

------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990

@alan niergarth - this.
And I find an increasing number don't even save the registers ( including some that are NOT on paperless ). A small number have enabled the "allow update from preview" and they just update away without any register saved anywhere...​

------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990
------------------------------

Original Message:
Sent: 04-27-2021 10:16
From: alan niergarth
Subject: Daily Transaction Register Not Empty Going Back A Year

@Doug Higgs - you are assuming they actually look at the register before saying YES to update :) !  ​

------------------------------
alan niergarth
Velosio LLC
------------------------------


Original Message:
Sent: 04-27-2021 10:07
From: Doug Higgs
Subject: Daily Transaction Register Not Empty Going Back A Year

I have one customer that seems to have an extraordinary number of instances of posting the GL entry to the wrong period.  As mentioned by @alan niergarth  it is particularly important at year end to have the entries in the correct year / month.  I modified each  of the registers / journals to print out either "DO NOT UPDATE - Journal Period and Entry Period Mismatch" or  "OK TO UPDATE - Journal Period and Entry Period Match".  I modified the check register, electronic payment register, AP invoice register, manual check register, AR sales journal, BM disassembly register, BM production register, PO ROG register, PO ROI register, PO return register, and the SO sales journal.  Attached is the So sales journal, which is one of the easier ones to modify.  The PO ROG, ROI are more complex.
​

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary


Original Message:
Sent: 04-27-2021 09:53
From: alan niergarth
Subject: Daily Transaction Register Not Empty Going Back A Year

@Wayne Schulz I have made it a point to include the automatic update of the DTR part of my what's new session along with the notification of a transaction date outside of a designated number of months before and after a current period.  After all this time we still get a fair number of support calls from posting to the wrong GL period, especially around the first of the year when users accidentally pick December of the new year instead of December of the previous year.  And "What do you mean my Aged Invoice Report balance does not match the GL? Why not"?​

------------------------------
alan niergarth
Velosio LLC


Original Message:
Sent: 04-27-2021 09:30
From: Wayne Schulz
Subject: Daily Transaction Register Not Empty Going Back A Year

In researching this I find the feature to automatically update DTR was added in 2019.2

A security event has been added to Role Maintenance that allows you to
automatically update the Daily Transaction Register. For any series of journal and
register updates that concludes with the Daily Transaction Register, you will not
receive a prompt to print and update the register if the security event check box is
selected for your role. The Daily Transaction Register will be printed and updated
automatically.

The security event has been added for the following modules:

• Accounts Payable
• Accounts Receivable
• Bank Reconciliation
• Bill of Materials
• Inventory Management
• Job Cost
• Purchase Order
• Sales Order
• Work Order

------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990

Pet peeve: customers who won't accept our advice and keep enabling the ability to post from preview.  Yes, Paperless breaking with Windows Updates can be annoying, but that is not as bad as having no record of what was supposed to be posted, if there is an error during an update.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

Original Message:
Sent: 04-27-2021 11:08
From: Wayne Schulz
Subject: Daily Transaction Register Not Empty Going Back A Year

@alan niergarth - this.
And I find an increasing number don't even save the registers ( including some that are NOT on paperless ). A small number have enabled the "allow update from preview" and they just update away without any register saved anywhere...​

------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990
------------------------------


Original Message:
Sent: 04-27-2021 10:16
From: alan niergarth
Subject: Daily Transaction Register Not Empty Going Back A Year

@Doug Higgs - you are assuming they actually look at the register before saying YES to update :) !  ​

------------------------------
alan niergarth
Velosio LLC


Original Message:
Sent: 04-27-2021 10:07
From: Doug Higgs
Subject: Daily Transaction Register Not Empty Going Back A Year

I have one customer that seems to have an extraordinary number of instances of posting the GL entry to the wrong period.  As mentioned by @alan niergarth  it is particularly important at year end to have the entries in the correct year / month.  I modified each  of the registers / journals to print out either "DO NOT UPDATE - Journal Period and Entry Period Mismatch" or  "OK TO UPDATE - Journal Period and Entry Period Match".  I modified the check register, electronic payment register, AP invoice register, manual check register, AR sales journal, BM disassembly register, BM production register, PO ROG register, PO ROI register, PO return register, and the SO sales journal.  Attached is the So sales journal, which is one of the easier ones to modify.  The PO ROG, ROI are more complex.
​

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary


Original Message:
Sent: 04-27-2021 09:53
From: alan niergarth
Subject: Daily Transaction Register Not Empty Going Back A Year

@Wayne Schulz I have made it a point to include the automatic update of the DTR part of my what's new session along with the notification of a transaction date outside of a designated number of months before and after a current period.  After all this time we still get a fair number of support calls from posting to the wrong GL period, especially around the first of the year when users accidentally pick December of the new year instead of December of the previous year.  And "What do you mean my Aged Invoice Report balance does not match the GL? Why not"?​

------------------------------
alan niergarth
Velosio LLC


Original Message:
Sent: 04-27-2021 09:30
From: Wayne Schulz
Subject: Daily Transaction Register Not Empty Going Back A Year

In researching this I find the feature to automatically update DTR was added in 2019.2

A security event has been added to Role Maintenance that allows you to
automatically update the Daily Transaction Register. For any series of journal and
register updates that concludes with the Daily Transaction Register, you will not
receive a prompt to print and update the register if the security event check box is
selected for your role. The Daily Transaction Register will be printed and updated
automatically.

The security event has been added for the following modules:

• Accounts Payable
• Accounts Receivable
• Bank Reconciliation
• Bill of Materials
• Inventory Management
• Job Cost
• Purchase Order
• Sales Order
• Work Order

------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990

@alan niergarth - Yep, the downside of only keying mmdd for your dates is every January you run the risk of a bad year.  Every January, I would forward the email from the previous year to Diane Coffman explaining that even if changed the MODULE date to a December date, the year was still pulling from the Library master date, not the module date.  Finally after about six years, they came up with ​the date outside the allowable range fix.  Apparently, validating against the module date was too hard to do.  While the fix is appreciated, it only works if you close the periods.

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Original Message:
Sent: 04-27-2021 11:15
From: Kevin Moyes
Subject: Daily Transaction Register Not Empty Going Back A Year

Pet peeve: customers who won't accept our advice and keep enabling the ability to post from preview.  Yes, Paperless breaking with Windows Updates can be annoying, but that is not as bad as having no record of what was supposed to be posted, if there is an error during an update.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------


Original Message:
Sent: 04-27-2021 11:08
From: Wayne Schulz
Subject: Daily Transaction Register Not Empty Going Back A Year

@alan niergarth - this.
And I find an increasing number don't even save the registers ( including some that are NOT on paperless ). A small number have enabled the "allow update from preview" and they just update away without any register saved anywhere...​

------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990


Original Message:
Sent: 04-27-2021 10:16
From: alan niergarth
Subject: Daily Transaction Register Not Empty Going Back A Year

@Doug Higgs - you are assuming they actually look at the register before saying YES to update :) !  ​

------------------------------
alan niergarth
Velosio LLC


Original Message:
Sent: 04-27-2021 10:07
From: Doug Higgs
Subject: Daily Transaction Register Not Empty Going Back A Year

I have one customer that seems to have an extraordinary number of instances of posting the GL entry to the wrong period.  As mentioned by @alan niergarth  it is particularly important at year end to have the entries in the correct year / month.  I modified each  of the registers / journals to print out either "DO NOT UPDATE - Journal Period and Entry Period Mismatch" or  "OK TO UPDATE - Journal Period and Entry Period Match".  I modified the check register, electronic payment register, AP invoice register, manual check register, AR sales journal, BM disassembly register, BM production register, PO ROG register, PO ROI register, PO return register, and the SO sales journal.  Attached is the So sales journal, which is one of the easier ones to modify.  The PO ROG, ROI are more complex.
​

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary


Original Message:
Sent: 04-27-2021 09:53
From: alan niergarth
Subject: Daily Transaction Register Not Empty Going Back A Year

@Wayne Schulz I have made it a point to include the automatic update of the DTR part of my what's new session along with the notification of a transaction date outside of a designated number of months before and after a current period.  After all this time we still get a fair number of support calls from posting to the wrong GL period, especially around the first of the year when users accidentally pick December of the new year instead of December of the previous year.  And "What do you mean my Aged Invoice Report balance does not match the GL? Why not"?​

------------------------------
alan niergarth
Velosio LLC


Original Message:
Sent: 04-27-2021 09:30
From: Wayne Schulz
Subject: Daily Transaction Register Not Empty Going Back A Year

In researching this I find the feature to automatically update DTR was added in 2019.2

A security event has been added to Role Maintenance that allows you to
automatically update the Daily Transaction Register. For any series of journal and
register updates that concludes with the Daily Transaction Register, you will not
receive a prompt to print and update the register if the security event check box is
selected for your role. The Daily Transaction Register will be printed and updated
automatically.

The security event has been added for the following modules:

• Accounts Payable
• Accounts Receivable
• Bank Reconciliation
• Bill of Materials
• Inventory Management
• Job Cost
• Purchase Order
• Sales Order
• Work Order

------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990