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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Commerce forum / POS cash reconciliatio...
Commerce forum
Suggested answer

POS cash reconciliation functionality

(0) ShareShare
ReportReport
Posted on by 36

I have setup a safe for a store

pastedimage1653905846259v1.png

I have enabled Advanced Cash Managemen:

pastedimage1653905879189v2.png

I have ran distribution job 1070.

When trying to close a shift in the POS I get the following error:

pastedimage1653905906692v3.png

When I open Manage Shifts, select the shift, the "Reconcile" operation is not available:

pastedimage1653905996924v4.png

Why is this operation not available? How is the user suppose to reconcile in order to be able to close the shift?

  • Juergen Weber Profile Picture
    107 on at
    RE: POS cash reconciliation functionality

    Hello Ramune,

    I´m currently testing the shift management with the new Store Commerce APP and have some issues with the advanced cash management features, too!

    I get an error message whenever I try to declare the starting amount for my regular shift.

    I read your blogpost and followed the steps in the video, but without success.

    All the details concerning my issue are available on the following yammer post.   www.yammer.com/.../1782595112353792

    Do you perhaps have any further idea as to what my problem could be?

    Thank you very much in advance!

  • Suggested answer
    Ramune Profile Picture
    on at
    RE: POS cash reconciliation functionality

    Hi Andreas,

    the design for this feature is created working with our biggest customers who use this feature every day.

    This is an intended design for current versions, but I agree any improvement would be very welcome as well.

    Cash reconciliation in our system always happen at a Shift level and not at a Register / Device or Safe level. For Safe operations we should have a separate shift dedicated only for safe. If you start to mix shifts with sales and safe transactions, and the end will be difficult to reconciliate money.

    Using Advanced Cash management feature we post operations to GL only:

    - Safe drop (from Manage safes)

    - Bank drop (from Manage safes)

    We did think about posting to GL some other operations like Declare start amount for Safes, but this is not approved to be done. I suggest you create an IDEA for us with some special requirements which we will analyze later (and collect votes from other customers to see how many customers needs such improvement). If you will create an Idea, please share a link there, we will be happy to vote as well.

  • AndreasSt Profile Picture
    36 on at
    RE: POS cash reconciliation functionality

    Hi. Thanks for the swift reply.

    Is there a view for safe operations in back office (FnO)? Or how would Finance team working only in FnO see e.g. Current safe count and safe transactions history?

    Further, I find the process of having a separate shift for Safe operation quite ineffective for the stores personell.

    "NOTE: Customers have some money in Safe which they use every day to move to Register - e.g. from Safe to Register operation is happening every morning for many of customers and they do not move money from Safe to Bank every day. This is like money circulating inside the store. And this move is not posted to GL.". What is the rational behind this design? From an accountant point of view quite baffling  design. If you have "money circulating inside the store", you would like to keep track of that in your books?

    My thinking of a typical store process:

    1. Count safe

    2. Declare register/drawer start amount (withdrawal from safe to register)

    3. Sales and returns

    4. Count register/drawer end amount - tender declaration

    5. Deposit from register/drawer to safe (safe drop)

    As of now only step 3 and 5 are registered into GL? Does it not make sense to register all these events into the ledger?

  • Suggested answer
    Ramune Profile Picture
    on at
    RE: POS cash reconciliation functionality

    Hi Andreas,

    the feature was created to see operations in a Safe only, not on GL level.

    Till now there is no plan to change/improve this feature.

    You may log an Idea for us, we will see how many customers needs the same and then make new decisions.

  • AndreasSt Profile Picture
    36 on at
    RE: POS cash reconciliation functionality

    I just read "With ‘Cash traceability’ turned on as well, the GL postings for this will continue the same way. ‘Cash traceability’ feature by itself has not introduced any new GL postings and as such - like all safe transactions to post to the general ledger when money moves in or out of the safe - are not supported."

    What is the relational behind this? No plans to change this?

    Does it not make sense to keep track of you safe balance in the GL?

  • AndreasSt Profile Picture
    36 on at
    RE: POS cash reconciliation functionality

    Thanks for the reply. I will read up on the provided documentation.

    A question out of this topic, is it possible to represent safes with main accounts and have postings to/from the ledger account when moving money from/to the safe?

  • Suggested answer
    Ramune Profile Picture
    on at
    RE: POS cash reconciliation functionality

    Hi Andreas,

    Have you been able to check our blog article about this topic? If you want to know more about safe/bank operations, you may check this blog article about Advanced cash management:

    community.dynamics.com/.../dynamics-365-commerce---cash-traceability-feature-advanced-cash-management

    Very Important to look at ‘Things to consider…’, also documents posted on 20 Oct 2020 (video - explaining the process, excel file – depending to video), document posted on 21 Jan 2021 (word file – the same process described in written form).

    There you will find some information about Reconciliation.

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

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Blog subscriptions now enabled!

Follow your favorite blogs

TechTalk: How Dataverse and Microsoft Fabric powers ...

Explore the latest advancements in data export and integration within ...

Leaderboard > Commerce

Featured topics

Product updates

Dynamics 365 release plans