PartsManager + Sage Intacct Journal Reconciliation

Derek Torres
Derek Torres
  • Updated

Important Note: PartsLedger is now PartsManager. PartsManager retains all of the parts purchasing and warehouse management automation benefits of its predecessor. To read more about this exciting change, click here.

 

This article will explain to PartsManager + Sage Intacct users how Journal Reconciliation is executed between the two systems.

How it Works

In PartsManager, when a Sales Order is either fulfilled, unfulfilled, closed, or reopened, PartsManager creates and records individual journal transaction lines that can be found on the Transactions Tab of a Sales Order.

Screenshot_2023-02-03_at_10.06.26_AM.png

In Sage Intacct, The transaction journal number is ‘added’ to the Doc field on the general ledger line entry. To view these general ledger line entries, navigate to Sage Intacct Journal EntriesJournal TransactionsInventory Journal.

Example of this Process

In PartsManager

PartsManager → Sales Order → Transactions

Journal_Example_Replace.png

In the example above, the PartsManager Transactions Journal Numbers are created as follows:

  • 22203 Debit
  • 22203 Credit
  • 22204 Debit
  • 22204 Credit
  • 22205 Debit
  • 22205 Credit
  • 22206 Debit
  • 22206 Credit
  • 22207 Debit
  • 22207 Credit
  • 22208 Debit
  • 22208 Credit

In Sage Intacct

Sage Intacct → Application → General Ledger → Journal Entry → Inventory Journal → Entries → Memo

Screenshot-2023-02-03-at-10-18-01-AM.png

The reference number is ‘removed’ from GL Entry line memo for:

  • Sales Order Fulfilment/UnFulfilment/Closing/Reopen workflows.

The reference number is 'added' to GL Entry “Doc” to the following workflows:

  • Sales Order Fulfillment/Unfulfilment/Closing/Reopen.

Replaced Sage Intacct Header reference Journal # on Sales Order Fulfilment/UnFulfilment/Closing/Reopening workflows with PartsManager Sales Order #.

Verification and Reconciliation

In Sage Intacct, navigate to Applications → Reports → Report Center → General Ledger → Journal Report to see Document numbers.

Example

In Sage Intacct Journal Report

Screenshot-2023-02-03-at-10-24-55-AM.png

  • 22203 Debit
  • 22203 Credit
  • 22204 Debit
  • 22204 Credit
  • 22205 Debit
  • 22205 Credit
  • 22206 Debit
  • 22206 Credit
  • 22207 Debit
  • 22207 Credit
  • 22208 Debit
  • 22208 Credit

In PartsManager

Journal_Example_Replace.png

Was this article helpful?

/

Comments

0 comments

Article is closed for comments.