x Want to participate? Join the group to interact
  • State Suggested Answer
  • Replies 2 replies
  • Answers 2 answers
  • Subscribers 240 subscribers
  • Views 1710 views
  • Users 0 members are here
Browse Forums
Sage 100 Contractor Announcements
119
topics
57
replies
Sage 100 Contractor General Discussion
1k
topics
4k
replies
Sage 300 CRE Announcements
168
topics
526
replies
Sage 300 CRE General Discussion
3k
topics
8k
replies
Sage Construction Management Announcements
4
topics
0
replies
Sage Construction Management General Discussion
15
topics
20
replies
Sage Estimating Announcements
39
topics
3
replies
Sage Estimating General Discussion
189
topics
443
replies
bsneddon

Job Cost Batch Reversals

SUGGESTED
Posted By

Hello,

We recently had an individual accidentily post a number of batches in Job Cost that should not have been posted. These batches ranged from accouting dates in February 2021 to April 2021. Luckily the GL was closed up to April 2021 and as a result these batches did not post in the GL but did post in the JC module. I was wondering if somebody could provide some insight/help with the following:

  1. Is there any way to easily remove batches from the JC module other than creating a reversal batch and importing that through JC?
  2. Is there a way to remove unwanted and unposted batches from the JC module? For example, these batches show up when you go to conditions in the post entries task.

Any help woud be greatly appreciated as there are 20+ batches adding a significant amount of cost to our JC module.

Thank you,

Brendan

  • 0
    SUGGESTED

    Normally, you would reverse the batches back in the application that created them.  That is the only safe way to handle your situation.  Otherwise, Contact Sage Support.  What you're asking sounds too dangerous/complicated for an easy answer. 

  • 0
    SUGGESTED

    Brendan,

    1. The process of posting transactions in Job Cost update the Job, Extra, Cost Code, and Category records (as they apply), so you will want to generating reversing entries and post those (whether you do that manually or run the reversing entries report and import) to reverse/undo the update to your Master records.  Once you have "negated" the unwanted transactions in Job Cost it is possible to use the Move Transactions tool, but I recommend that you be specific to Application of Origin, Batch, and possibly Run numbers to only move out the "extraneous" Transactions.  You can follow the article below, but substitute Current for New, or you can move the Transactions/Batches to History only which would eliminate them from reports and Inquiries run only on the Current file.

    2. Follow this article to move unwanted transactions out of your new.jct file:  View Document - Sage Knowledgebase.  There is a similar article for moving Transactions/Batches out of your new.glt file.  You may need to follow this process multiple times depending on whether you are able to use OR statements and create/add multiple conditions to include multiple batches/transactions.

    Todd Baker
    Sage Consultant
    Contractor Business Solutions NW, LLC

*Community Hub is the new name for Sage City