Confirm Marketplace Sales in Mail Order

Upon Shipment in Monsoon, orders are automatically transferred into the PrismCore Mail Order module with a status of Closed. The Marketplace Order # will be imported into PrismCore and then displayed within the mail order comment field that is available at both the Enter Mail Orders screen and the Ship Mail Orders screen.
You will want to confirm that all orders transferred properly between Monsoon and your
PrismCore Mail Order system.
To confirm your marketplace orders in mail order:
1. Access Ship Mail Orders, Jump 153 (Inventory Management > Mail Order > Ship Mail Orders)
2. Click Reports and select Marketplace Reconciliation.
The 'Report Parameters' dialog will open.

In Marketplace, select the Marketplace or website you are reconciling. Leave blank to include all marketplaces or websites.

Note: Since the monsoon orders are automatically closed, at the time they are transferred into PrismCore Mail Order they will be added to the un-posted web sales. If none exist, a web sale will be created. An Accounts Receivable transaction will be created for each web order transferred into PrismCore viewable in AR Transaction Inquiry.


On Monsoon, from the orders tab, you may export a range of shipped orders selected by date and import the file into excel to subtotal it. All orders, shipments and refunds, should be included in this report.
Refunds are entered manually into PrismCore so if they are not listed on the Marketplace Reconciliation report, they have not yet been entered in PrismCore Mail Order. Please be sure to record refunds in PrismCore Mail Order. As of this writing (July, 2009), only refunds from Amazon.com appear on the Monsoon adaptor. Refunds for Alibris.com, Abebooks.com and Half.com are processed manually by you on their respective websites. Verify that all refunds from the Monsoon marketplace websites have been entered into PrismCore Mail Order.
Compare the PrismCore Marketplace Reconciliation Report to the orders on Monsoon for all marketplaces. Verify all orders from Monsoon are in PrismCore Mail Order. Verify subtotals, shipping, taxes and commissions; verify primary tender to the net amount of the order from the marketplace site.
Then compare the Marketplace Reconciliation report to the AR Daily Transaction Report printed from Transaction Inquiry under Receivables > Invoice Processing. If AR does not match ICS please contact ICS Support.
See Reconciling Marketplace Payments.