Sage 100

Hi All

We have a customer who wants to create a monthly reversing JE for PO's of a certain type (non-inventory) so that a reversing JE is created on the last day of the month, for the amount of the PO lines, offsetting to an accrued payable balance sheet account.

Has anyone heard of a solution that does this, or has made one ?

Thanks in advance.

Jeff F.

------------------------------
Jeff Fiddelman
Exeplex, LLC
------------------------------

Are they doing this to offset the current limitation of purchases clearing that does not create an unvouched entry for miscellaneous and special purchase items?  These items are only posted to the GL when the actual AP invoice is posted??  Or for some other reason?

------------------------------
Jeff Schwenk
FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Hi - they want this to use open PO as a method of tracking accruals and reversing entries, other than spreasheets...

Thx

------------------------------
Jeff Fiddelman
Exeplex, LLC
------------------------------

Original Message:
Sent: 08-18-2021 17:34
From: Jeff Schwenk
Subject: Creating monthly reversing JE from open PO's

Are they doing this to offset the current limitation of purchases clearing that does not create an unvouched entry for miscellaneous and special purchase items?  These items are only posted to the GL when the actual AP invoice is posted??  Or for some other reason?

------------------------------
Jeff Schwenk
FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Entering lines on a PO doesn't create a journal entry.  What is it they want to reverse?  A reversing entry reverses a previously recorded entry.  Are the reversing the entry associated with a receipt of goods and/or a receipt of invoice?

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles
------------------------------

Back to my original post, the purchases clearing account (if set up correctly) sets up the liability for inventory items when received.  No need for a ME accrual for that.  What doesn't get accrued are the misc and special item codes.  They post to the GL when the invoice is vouched in the system.  So I would start with the purchases clearing report selecting only the misc and special items.  This may give you the necessary information for an ME accrual entry w/ reversing date.  If it is too cluttered or needs to be summarized, you can modify or create a new report and save as a purchases clearing report.

Unfortunately, I have never created a specific report for ME accruals.

------------------------------
Jeff Schwenk
FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Original Message:
Sent: 08-19-2021 07:43
From: Doug Higgs
Subject: Creating monthly reversing JE from open PO's

Entering lines on a PO doesn't create a journal entry.  What is it they want to reverse?  A reversing entry reverses a previously recorded entry.  Are the reversing the entry associated with a receipt of goods and/or a receipt of invoice?

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles
------------------------------

Thank you for the suggestions - I will be discussing this more with the client, and then perhaps writing a more detailed post.

Regards,

Jeff F.

------------------------------
Jeff Fiddelman
Exeplex, LLC
------------------------------

Original Message:
Sent: 08-19-2021 08:19
From: Jeff Schwenk
Subject: Creating monthly reversing JE from open PO's

Back to my original post, the purchases clearing account (if set up correctly) sets up the liability for inventory items when received.  No need for a ME accrual for that.  What doesn't get accrued are the misc and special item codes.  They post to the GL when the invoice is vouched in the system.  So I would start with the purchases clearing report selecting only the misc and special items.  This may give you the necessary information for an ME accrual entry w/ reversing date.  If it is too cluttered or needs to be summarized, you can modify or create a new report and save as a purchases clearing report.

Unfortunately, I have never created a specific report for ME accruals.

------------------------------
Jeff Schwenk
FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------


Original Message:
Sent: 08-19-2021 07:43
From: Doug Higgs
Subject: Creating monthly reversing JE from open PO's

Entering lines on a PO doesn't create a journal entry.  What is it they want to reverse?  A reversing entry reverses a previously recorded entry.  Are the reversing the entry associated with a receipt of goods and/or a receipt of invoice?

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles

DSD does offer PO-1022 Special & Misc Items Clearing Account that creates an entry at time of receipt.  Had a customer use it and I believe it worked well.

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

Original Message:
Sent: 08-19-2021 08:23
From: Jeff Fiddelman
Subject: Creating monthly reversing JE from open PO's

Thank you for the suggestions - I will be discussing this more with the client, and then perhaps writing a more detailed post.

Regards,

Jeff F.

------------------------------
Jeff Fiddelman
Exeplex, LLC
------------------------------


Original Message:
Sent: 08-19-2021 08:19
From: Jeff Schwenk
Subject: Creating monthly reversing JE from open PO's

Back to my original post, the purchases clearing account (if set up correctly) sets up the liability for inventory items when received.  No need for a ME accrual for that.  What doesn't get accrued are the misc and special item codes.  They post to the GL when the invoice is vouched in the system.  So I would start with the purchases clearing report selecting only the misc and special items.  This may give you the necessary information for an ME accrual entry w/ reversing date.  If it is too cluttered or needs to be summarized, you can modify or create a new report and save as a purchases clearing report.

Unfortunately, I have never created a specific report for ME accruals.

------------------------------
Jeff Schwenk
FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 08-19-2021 07:43
From: Doug Higgs
Subject: Creating monthly reversing JE from open PO's

Entering lines on a PO doesn't create a journal entry.  What is it they want to reverse?  A reversing entry reverses a previously recorded entry.  Are the reversing the entry associated with a receipt of goods and/or a receipt of invoice?

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles

Good news!  Sad that this has to be an enhancement though!  Should be a standard offering.

------------------------------
Jeff Schwenk
FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Original Message:
Sent: 08-19-2021 10:34
From: Nancy Hanson
Subject: Creating monthly reversing JE from open PO's

DSD does offer PO-1022 Special & Misc Items Clearing Account that creates an entry at time of receipt.  Had a customer use it and I believe it worked well.

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


Original Message:
Sent: 08-19-2021 08:23
From: Jeff Fiddelman
Subject: Creating monthly reversing JE from open PO's

Thank you for the suggestions - I will be discussing this more with the client, and then perhaps writing a more detailed post.

Regards,

Jeff F.

------------------------------
Jeff Fiddelman
Exeplex, LLC


Original Message:
Sent: 08-19-2021 08:19
From: Jeff Schwenk
Subject: Creating monthly reversing JE from open PO's

Back to my original post, the purchases clearing account (if set up correctly) sets up the liability for inventory items when received.  No need for a ME accrual for that.  What doesn't get accrued are the misc and special item codes.  They post to the GL when the invoice is vouched in the system.  So I would start with the purchases clearing report selecting only the misc and special items.  This may give you the necessary information for an ME accrual entry w/ reversing date.  If it is too cluttered or needs to be summarized, you can modify or create a new report and save as a purchases clearing report.

Unfortunately, I have never created a specific report for ME accruals.

------------------------------
Jeff Schwenk
FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 08-19-2021 07:43
From: Doug Higgs
Subject: Creating monthly reversing JE from open PO's

Entering lines on a PO doesn't create a journal entry.  What is it they want to reverse?  A reversing entry reverses a previously recorded entry.  Are the reversing the entry associated with a receipt of goods and/or a receipt of invoice?

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles