GL Posting for Sales Orders with Special Items in Sage 100 Standard ERP 2013

By | April 24, 2013

In this blog, we would discuss about the posting process of G/L Accounts, when Sales order is created in Sage 100 ERP (formerly Sage MAS 90/200 ERP) with special Items as its Line Items.

As discussed in our previous blog Create Sales Order Entry with Special Item, Sage 100 users can use a Special Item Code to those Inventory parts that have been written off or slow moving but are still sellable. This is done by assigning ‘*’ sign to the Inventory item in the SO or Invoice entry detail Line * (example: #12345).

For starters, user need to ensure that Integrate General Ledger option is checked along with setting of appropriate Default G/L Accounts in Sales Order option Menu.

Promote Orders and Invoices to Sage 100 from within Sage CRM

Sales Order Options

Say for an instance, we create a Sales Order entry against the Customer “Bristol, Sonya”.

Sage EM Sales Order Options

Here, we are selling an Item “cabinets” to the Customer. We have classified it as a Special Item since the transaction activity against it has been slow in this Fiscal year. We have prefixed an asterisk sign for the Item Code Cabinets in the Line Item; this changed the Item Type into “Special” type.

Line item

Note:Here, user needs to make sure the Drop Ship option against the Item is unchecked. If it is drop shipped there would be no COGS or Sales Account posting during invoice posting in Sales Order.  The only posting is sales and AR.

  1. We would create an Invoice against the created SO for this Customer and will do complete shipment for the same.
    SO Invoice Data Entry
  2. Then run Daily Sales report/Updates along with Daily transaction register to affect the G/L accounts posting.
  3. After posting, we will drill down to the maintenance Screen to G/L Account set in the Sales Order option.
  4. Here, Invoice amount has been successfully posted to COGS account set in Sales Order option through SO journal.
Sage X3 Sales Order Options

However, Account manager can highlight the account statistics sales and invested cost on the Items which are slowing moving from Stock and need to focus on the sales of such items.

About Us
Greytrix is a one-stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation expertise.

Greytrix has some unique solutions of Sage 100 integration with Sage CRM, and Salesforce.com  along with Sage 100 Migration from Sage 50 US, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 100 customization and development services to Sage business partners, end users, and Sage PSG worldwide.

For more details on Sage 100 Services, please contact us at sage@greytrix.com. We will be glad to assist you.