web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / sales transaction not ...
Microsoft Dynamics RMS (Archived)

sales transaction not uploading from store to HQ

(0) ShareShare
ReportReport
Posted on by Community Member

We have a single transaction that was not uploaded to HQ from one of our stores.  All the other transactions from that day were uploaded.  Is there a way to re -upload transactions from that day?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Antonijo Todorovik Profile Picture
    Antonijo Todorovik 4,025 on at

    Hi there.

    Can You update that transaction with SQL maybe? Just update the comment for example, some field that is not important that much? Another option, return the transaction with F11 and do another sale equal, but do it in the same Batch, so it will not affect the Z read.

    In both cases, after that, send a 401/402 worksheets for that store, with date previous to the original sale...

    Hope this helps, A.

  • Suggested answer
    archelle16 Profile Picture
    archelle16 1,743 on at

    here... just copy, paste and execute the query below to your store database where you want to re upload sales. Just do not forget to change the date range.

    declare @fromdate as date

    declare @todate as date

    set @fromdate = '2016-11-01' --- date format must be in year-monthnumber-day

    set @todate  = '2016-11-02'  --- date format must be in year-monthnumber-day

    update [Transaction] set StoreID = StoreID

    where CAST([Time] as DATE) >= @fromdate and CAST([Time] as DATE) <= @todate

    update transactionentry

    set StoreID = StoreID

    FROM transactionentry te

    inner join [Transaction]  t on t.TransactionNumber = te.TransactionNumber

    where CAST(t.[time] as DATE) >= @fromdate and CAST(t.[time] as DATE) <= @todate

    update Batch

    set StoreID = StoreID

    FROM Batch b

    inner join [Transaction]  t on b.BatchNumber =  t.BatchNumber

    where CAST(t.[time] as DATE) >= @fromdate and CAST(t.[time] as DATE) <= @todate

  • Suggested answer
    archelle16 Profile Picture
    archelle16 1,743 on at

    then re sync your store, issue worksheet 401, after sync check detailed sales report. thanks.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans