EDI to QB for Sales Invoices

From UG

Contents 1 Parent Mantis 2 Intro 2.1 Example 2.1.1 Figure 1 CT2 2.1.2 Figure 2 QB 3 Requirements 3.1 Forward in batches 3.1.1 Frequency 3.2 Review process 3.2.1 Gaps in invoice numbers 3.3 QB fields and Mapping

Parent Mantis

http://mantis.jaguarfreight.com/mantis/view.php?id=2338

Intro

Core requirement: To eliminate double entry of Sales Invoices into 2 systems at Jaguar:

• CT2 transportation system
• QuickBooks accounting system

Example

See Figures below.

Figure 1 CT2

Invoice as it is entered in CT2.

Figure 2 QB

Invoice as it is entered in Quickbooks.

Requirements

Forward in batches

All sales invoices/credit notes entered in CT2 would be forwarded to QB in batches (bundles).

Frequency

Initially once a day at the end of the day.

Review process

Before batch is populated into QB accounting operators should have a chance for "30 sec review".

Gaps in invoice numbers

First inv# in new batch should be next number after last one in previous.

QB fields and Mapping

QB	CT2
Bill To	Bill To
Date	Date
Inv#	Invoice No
PO number	CT#
Ship	today date
Item code	lookup based on CC#
Amount	Amount
Total	Total invoice