BTerrell Group Blog

Sage 300 ERP: Inventory Costing Automation and Day End Processing

Posted by Chris Firra on Tue, Oct 15, 2013

Businesses that use Sage 300 ERP for managing their inventory and sales orders face a question of how and when to process the costing aspects of their inventory transactions.  In Sage 300 ERP, inventory quantities (on-hand, on P/O, on S/O, and committed) are updated as soon as a transaction is posted, however, costing has typically been aggregated into a once-a-day batch process. The application has always had a user interface called DAY END PROCESSING residing within the Inventory Control Periodic Processing collection that is used to perform a large number of processing functions.  Those functions include:

  • Calculating costing data for all inventory-related transactions that have occurred since the last Day End Processing.
  • Producing G/L journal entries from the transactions processed.
  • Updating Inventory Control Posting Journal.
  • Updating Inventory Control Statistics
  • Activating and posting future sales and purchase orders that have reached their order date.
  • Removing quotes and purchase requisitions with expiration dates that have been reached.
  • Updating sales commissions
  • Creating Accounts Receivable invoice batches from posted Order Entry transactions.
  • Updating statistics and history in Order Entry and Purchase Orders.

Sage 300 ERP Day End Processing

As the name implies, Day End Processing was designed to be run at the end of a business day.  However, many companies require access to inventory values on a more frequent basis, and consequently run Day End Processing two or more times a day.  This is particularly true for companies with 24-hour operations.  In response, Sage introduced the option of performing the costing function upon posting each inventory transaction.  They managed to do this without locking up or negatively impacting other users that were entering and posting inventory transactions. The option is configured within the Inventory Control Options Costing Tab, which also allows for the option of concurrently creating the related subledger transactions.

Sage 300 ERP: Day End Processing with each inventory transaction

When costing during posting is enabled and the G/L Integration configurations are configured to create G/L Transactions by “Creating and Posting a New Batch”, the General Ledger inventory balances are effectively maintained in real time.

Sage cautions that if you cost inventory during posting, sales order and purchase order posting will naturally take longer.  On the flip side, Sage development guru, Stephen Smith, argued in a 2011 blog article that the delay during posting is minor.  Nevertheless, for many users whose primary function is to enter or process sales orders, the additional delay is not acceptable. 

The impact of the “Cost on Posting” performance penalty is a function of the number of order entry users and the number of inventory transactions processed.  I believe that companies should at least try out the “Cost on Posting” option to determine whether posting times are acceptable.  If the option is found to be inefficient, companies can revert to costing during day end processing.  There are other alternatives to obtaining frequent inventory value updates.

One such excellent alternative is to utilize Process Scheduler, an application from 3rd party developer, Orchid Systems.  Process Scheduler can be configured to automatically run Day End Processing at pre-set intervals, multiple times per day. 

Orchid Systems Process Scheduler with Sage 300 ERP

Additionally, Process Scheduler can automate other system processes, such as posting all subledger and General Ledger batches, so that G/L balances are completely up-to-date upon completion.  Even further, after Day End Processing and posting of all batches is completed, Process Scheduler can kick-off daily reports.  The amount of labor and frustration saved each day can be enormous.

If you would like to learn more, let us know.  We’d be happy to help you decide what’s best for your company.

Free Consultation

Tags: day end processing, Sage 300 ERP, inventory costing, Orchid Systems, process scheduler

Orchid Webinar - January 25, 2012

Posted by Meredith Gooch on Fri, Jan 20, 2012

Join us for a Webinar on January 25, 2012 at 3:00 p.m. Central.

Space is limited so reserve your spot now! https://www2.gotomeeting.com/register890720634

Inter Entity Transactions (IET) has always been a great solution for organizations that need to generate DueTo and DueFrom entries to balance Intercompany or Inter Fund Transactions within one company database or across multiple company databases. For example, IET automatically creates the DueTo and DueFrom entries to facilitate expenses or the revenue allocations within one or across more than one database.

With the latest release of IET, many key features have been added such as:

  1. Consolidated AP and AR Aging reports by Company.
  2. Cash Management to balance AR Receipt. AP Payment and Bank Transfer entries made on behalf of related organizations through Bank Services.
  3. GL Triggers to automatically set up entries to other GL Accounts in the same or different entities, AR Customers or AP Vendors.

The new IET TRADE module (purchased either standalone or integrated with IET) allows creation of entries within or across company databases for AP and AP transactions and/or OE to PO transactions. Support for Serialized & Lot Tracked Inventory and PJC information on these transactions has been added.

Webinar Title: Overview of Orchid Inter Entity Transactions with Cash Managment & GL Triggers and New IET TRADE Module
Date: Wednesday, January 25, 2012
Time: 3:00 p.m. Central

After registering, you will receive a confirmation email containing information about joining the Webinar.

System Requirements:
PC-based attendees - Windows(R) 7, Vista, XP, or 2003 Server
Mac-based attendees - Mac OS(R) X 10.5 or newer

 

Tags: Orchid Webinar, Orchid Inter Entity, Orchid Systems

Webinar: Review of New Inter Entity Transactions from Orchid Systems

Posted by Meredith Gooch on Mon, Dec 13, 2010

Join us to review the new features in Inter Entity Transactions, and the new module Inter Entity (IY) Trade. Inter Entity Transactions is being updated with new GL Trigger and Substitutions functionality. GL Triggers allows you to map the transactions in one company database to particular accounts, customers or vendors in another company database so you don’t have to replicate the GL Chart of Accounts in every company. It works on GL Journals from any source (sub ledger) including 3rd party modules.

IY Trade is a new module that will allow groups to automate trade based inter company transactions at a subledger level instead of just at the GL level. The transactions to be supported in the initial release are:
1) OE orders/invoices/Credit Notes to PO (and vice versa):
2) AR Invoices/Credit Notes to AP (and vice versa).
 
Please join us for an overview of these exciting new features in Inter Entity Transactions by Orchid Systems.

 

Title:

 

Review of New Inter Entity Transactions with GL Triggers and NEW IY Trade Module from Orchid Systems

 

 

 

Date:

 

Wednesday, December 15, 2010

 

 

 

Time:

 

3:00 PM - 4:00 PM Central

Reserve your spot now.

 

Tags: webinar orchid systems, Orchid Systems, Inter Entity Transactions

Webinar: New Features in Inter Entity Transactions by Orchid Systems

Posted by Meredith Gooch on Tue, Nov 16, 2010

Attend this webinar to review the new features in Inter Entity and the new module Inter Entity Trade. The webinar is scheduled for November 24, 2010 at 3:00 Central.

IY General Ledger Allocations is the current released product with a new GL Trigger functionality.
GL Triggers allows you to map the transactions in one company database to particular accounts, customers or vendors in another company database. It works on GL Journals from any source (sub ledger) including 3rd party modules.

IY Trade is a new module that will allow groups to automate trade based inter company transactions at a subledger level instead of just at the GL level. The transactions to be supported are:
     1) OE orders/invoices/Credit Notes to PO (and vice versa);
     2) AR Invoices/Credit Notes to AP (and vice versa);
     3) IC Item transfers between Locations.

Please join us for an overview of these exciting new features in Inter Entity Transactions by Orchid Systems.

Orchid Systems

Register now for this webinar.

Tags: Orchid Systems, Inter Entity Transactions, Webinar, inter entity

What's New With Orchid Systems?

Posted by Meredith Gooch on Fri, Mar 05, 2010

As a strong supporter of Orchid Systems products for Sage Accpac ERP, we are pleased to announce the newest 5.6 version features of Orchid's Process Scheduler, Info-Explorer, RMA, Inter-Entity Transactions, Information Manager, and Bin Tracking, which have already been released.

Process Scheduler - Version 5.6:

  • New action of "Clear Data Integrity Logs" that enables the clearing down of old integrity logs. All logs will be cleared which are older than "x" days - which is entered on the action.
  • New F9 zoom screen to facilitate quicker setup time
  • New schedules report to enable Schedules to be printed
  • Clear button on the Audit logs screen will only clear the filtered tasks

 Info-Explorer - Version 5.6:

  • Ability to export to HTML - and from there to email or print.

RMA - Version 5.6:

  • Compatibility with the new IC Version 5.6 Serial and Lot Tracking

Inter-Entity Transactions - Version 5.6:

  • Sage Accpac ERP Version 5.6 compatibility

Information Manager - Version 5.6:

  • Sage Accpac ERP Version 5.6 compatibility

Bin Tracking - Version 5.6:

  • Compatibility with the new IC v5.6 Serial and Lot Tracking
  • Sage Accpac ERP Version 5.6 compatibility
- Brian Terrell, CPA and Managing Partner

Tags: Sage Accpac ERP, Bin Tracking, Orchid Systems, process scheduler, Info-Explorer, Information Manager, Inter Entity Transactions, v5.6, version 5.6, Info, RMA, integrity, schedule, audit logs, serial and lot tracking