MarketMan <> QBO Integration 

TABLE OF CONTENTS

• Guidelines: 
  • Purchase Flow:
  • Transfer Flow:
  • Wastage Flow:
  • COGs Flow:
  • Adjustment Flow:
• Trouble Shooting: 

Guidelines: 

Purchase Flow:

1. Received Purchase Orders are reflected in QBO as Vendor Bill with each line item classified to Food, Beverage or Other. 

2. Negative values on MarketMan are reflect as debit note on QBO.

3. Condition for Purchase Orders integration is DocType: invoice and DocStatus: approved.  

4. Line description in the vendor bill indicates that the bill is created by the integration and includes Marketman DocNumber as reference. 

5. All new Vendors should be created in Marketman only and they will be synced to QBO by the integration. 

Transfer Flow:

1. Transfer transactions are reflected as Journal Entries in QBO. 

2. All transfer orders from a specific location for a specific day can be found in the same Journal. 

3. Each line in the Transfer Orders Journal represent a transfer order total of Food or Beverage specified in the line memo. 

4. Marketman Transfer Order Number can be found in the line memo of the Journal Entry. 

Wastage Flow:

1. Waste events per location per month are reflected as Journal Entry in QBO with the total waste of Food and Beverage each in a separate line indicated in the line memo. 

COGs Flow:

1. COGs events per location per month are reflected as Journal Entry in QBO with the total COGs of Food and Beverage each in a separate line indicated in the line memo. 

Adjustment Flow:

1. Adjustment  events per location per month are reflected as Journal Entry in QBO with the total Adjustment (the difference between the actual and theoretical cost on MarrketMan) of Food and Beverage each in a separate line indicated in the line memo.

Memo in all Journal Entries indicates that the record is created by the integration and line memo gives more information about the type of the transaction and category of items. 

Trouble Shooting: 

1. Some Purchase Orders not Integrated. 

Reason: Document created in a day and approved in a day passed the integration date.  

Solution: At the end of the month the Integration will read all Purchase Orders of the month and sync the missed orders. 

2. Differences in Transfers, Waste Events or COGs 

Reason: Modification by an employee on Marketman transaction after data is synced the Integration. 

Solution: To agree on a specific date to do the integration on it after finishing the modification by the employees.