Integrated database for tracking shipping information

• US 7,938,315 B2
• Filed: 01/15/2008
• Issued: 05/10/2011
• Est. Priority Date: 05/16/2007
• Status: Active Grant

• Current Assignee: Lynch Marks LLC
• Original Assignee: Lynch Marks LLC
• Inventors: Gibby, Roger, Marks, Peter
• Primary Examiner(s): TRAIL, ALLYSON NEEL
• Application Number:
  US12/009,126
• Publication Number:
  US 20080283586A1
• Time in Patent Office: 1,211 Days
• Field of Search: 235/375, 235/385, 705/1, 705/9, 705/11
• US Class Current: 235/375
• CPC Class Codes: G06Q 10/08 Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
• CPC Class Codes: G06Q 10/083 Shipping
• CPC Class Codes: G06Q 10/08345 Pricing
• CPC Class Codes: G06Q 30/0623 Item investigation
• CPC Class Codes: G06Q 30/0635 Processing of requisition or of purchase orders
• CPC Class Codes: G06Q 30/0641 Shopping interfaces

Abstract

Systems and methods of the present invention for using an integrated database for shipping information are provided. Information gathered or entered during shipping label generation may be stored in a database. The label information may concern shipping labels associated with multiple shipping vendors. Information concerning shipping invoices may be received from the multiple shipping vendors are received, and a report may be generated based on the stored label information and the invoice information. The invoice information may also be stored in the database. Further, the invoice information may include electronic data interchange files received through vendor-specific interfaces.

Claims

1. A method for using an integrated database for tracking shipping information, the method comprising:

generating a plurality of shipping labels, each of the shipping labels being associated with one of a plurality of shipping vendors and non-invoiced shipments;

storing label information concerning the shipping labels in a database in memory;

receiving one or more shipping invoices from the plurality of shipping vendors over a communication network, the shipping invoices including cost data concerning the plurality of non-invoiced shipments; and

generating a report based on at least the stored label information and the received shipping invoices and cost data by matching the stored label information to corresponding entries in the received shipping invoices.

2. The method of claim 1, further comprising storing invoice information concerning the received shipping invoices and the received cost data in the database.

3. The method of claim 1, wherein the label information is designated by a user during label generation.

4. The method of claim 1, wherein receiving the shipping invoices further comprises receiving invoice information through vendor-specific communications interfaces.

5. The method of claim 1, wherein receiving the shipping invoices from the plurality of shipping vendors further comprises receiving electronic billing files associated with one or more of the plurality of shipping vendors.

6. The method of claim 1, further comprising assigning a tracking number to each of the shipping labels, wherein matching the shipping invoices with the label information is further based on tracking numbers.

7. The method of claim 1, wherein generating the report further comprises providing information concerning the shipping invoices, cost data, and the associated label information to an accounting system.

8. A method for using an integrated database for tracking shipping information, the method comprising:

receiving label information associated with one of a plurality of shipping vendors and plurality of non-invoiced shipments over a communication network;

storing the label information in a database in memory;

receiving one or more shipping invoices from the plurality of shipping vendors over the communication network, the shipping invoices including cost data concerning the plurality of non-invoiced shipments; and

generating a report based on at least the stored label information and the received shipping invoices and the received cost data by matching the stored label information to corresponding entries in the received shipping invoices.

9. A system for using an integrated database for tracking shipping information, the system comprising:

a label generator configured to generate a plurality of shipping labels associated with one of a plurality of shipping vendors and a plurality of non-invoiced shipments;

a database configured to store label information concerning each of the shipping labels generated by the label generator;

a report generator configured to generate a report based on at least the stored label information from the database and invoice information associated with one or more shipping invoices received from the plurality of shipping vendors or cost data associated with the plurality of non-invoiced shipments, the report being generated by matching the stored label information to corresponding entries in the received shipping invoices.

10. The system of claim 9, wherein the database is further configured to store the invoice information associated with one or more vendor-specific shipping invoices and cost data concerning the plurality of non-invoiced shipments.

11. The system of claim 9, further comprising a communications interface configured to receive the shipping invoices from the plurality of shipping vendors.

12. The system of claim 11, wherein the communications interface comprises vendor-specific interfaces associated with each of the plurality of shipping vendors.

13. The system of claim 11, wherein the communications interface is further configured to receive electronic billing files associated with each of the one or more shipping vendors.

14. The system of claim 11, wherein the communications interface is further configured to receive manually entered invoice information and to provide the manually entered invoice information to the report generator.

15. The system of claim 9, wherein the report generator is further configured to allocate each entry to a user account based on the associated label information.

16. The system of claim 9, wherein the report generator is further configured to provide information concerning the shipping invoices and the associated label information to an accounting system.

17. A non-transitory computer-readable storage medium having stored thereupon executable computing instructions for performing a method, the method comprising:

generating a plurality of shipping labels, each of the labels being associated with one of a plurality of shipping vendors and a plurality of non-invoiced shipments;

storing label information concerning the shipping labels in a database;

receiving one or more shipping invoices from the plurality of shipping vendors, the shipping invoices including cost data concerning the plurality of non-invoiced shipments; and

generating a report based on at least the stored label information and the received shipping invoices and cost data by matching the stored label information to corresponding entries in the received shipping invoices.

18. The non-transitory computer-readable storage medium of claim 17, wherein the executable instructions further provide for providing information concerning the shipping invoices, cost data, and associated label information to an accounting system.