Trace a transaction

Gallery 54 · by **Gallery 54** » Wed Jul 31, 2013 2:22 pm

How do I trace a "Sales Receipt" in QuickBooks back to Retail Edge?
The Sales receipt number in QB does not correlate with Ticket number in RE.

Thanks

by **RetailEdge Moderator** » Wed Jul 31, 2013 3:21 pm

There is no way to trace a sales receipt in QB to RetailEdge. The export to QB as you know does not bring over individual transactions from RetailEdge but a summary of closings. This sales receipt is really used so that we can bring over the account adjustments as well as the totals of the payment methods used. We don't have an identifierm because the closing information you bring over might be from one RetailEdge closing or multiple workstations or even multiple days. You also have the ability to change the actual deposit date that RetailEdge posts into Quickbooks so this value might not be a good identifier either.

The best way to track information that was taken over to QuickBooks from RetailEdge POS would be to:

1. Bring the data over at a regular interval. That way it will be clearer what and when data was transferred over.

2. Run a closing or summary closing in RetailEdge and see whether the totals showing up on this report match what you think should be in Quickbooks. If it does not, re-run the report for a different range of dates until the data matches. Starting the export and viewing the list of closings to be exported would be a good place to start this.

Hope this helps.

Gallery 54 wrote:How do I trace a "Sales Receipt" in QuickBooks back to Retail Edge?
The Sales receipt number in QB does not correlate with Ticket number in RE.

Thanks

Gallery 54 · by **Gallery 54** » Wed Jul 31, 2013 3:49 pm

We do close RE every night, and I do export single day at a time into QB. The figure for 6-20-13 TO RetailEdge-Customer reads $215.73. What figure in RE should I be able to match this to?
Thanks.

by **RetailEdge Moderator** » Wed Jul 31, 2013 3:53 pm

This should equate to the closing deposit total for this day. When you do an export can you see this value in the list?

Gallery 54 wrote:We do close RE every night, and I do export single day at a time into QB. The figure for 6-20-13 TO RetailEdge-Customer reads $215.73. What figure in RE should I be able to match this to?
Thanks.

Gallery 54 · by **Gallery 54** » Wed Jul 31, 2013 5:34 pm

It doesn't match...hence I am trying to trace it.
Closing report shows a total of
$1102.50. QB reads $215.73 and this doesn't even match just cash of just MC or AE either.
I cannot attach close report here for some reason.
Any other advice on how to figure out what happened?
Thanks

by **RetailEdge Moderator** » Thu Aug 01, 2013 8:11 am

No way other than to bracket it with closings on either side of the day. If you send a closing to technical support, maybe they can look at it and pin it down.

RetailEdge Discussion Forums