EDI to QB for Sales Invoices

From UG

(Difference between revisions)
Jump to: navigation, search
(→Figure 2)
(→Requirements)
Line 31: Line 31:
=== Forward in batches ===
=== Forward in batches ===
-
=== Review process ===
+
All sales invoices/credit notes entered in CT2 would be forwarded to QB in batches (bundles).
-
==== Gaps in invoice numbers ====
+
==== Frequency ====
 +
Initially once a day at the end of the day.
-
=== Frequency ===
+
=== Review process ===
 +
Before batch is populated into QB accounting operators should have a chance for "30 sec review".
-
=== Workflows ===
+
==== Gaps in invoice numbers ====
 +
First inv# in new batch should be next number after last one in previous.
-
'''Current:'''
+
=== QB fields and Mapping ===
-
'''Future:'''
+
{| border="1" cellpadding="2"
 +
! scope="col" width="225" | QB
 +
! scope="col" width="225" | 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
 +
|-
 +
|  || 
 +
|-
 +
|  || 
 +
|}

Revision as of 19:38, 12 August 2010


Contents

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.

File:SiCT2.JPG

Figure 2 QB

Invoice as it is entered in Quickbooks.

File:Si.JPG

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
Retrieved from "https://wiki.jaguarfreight.com/EDI_to_QB_for_Sales_Invoices"
Personal tools