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 AX (Archived) / Unable to recall sales...
Microsoft Dynamics AX (Archived)

Unable to recall sales order on POS when the customer was created from back office

(0) ShareShare
ReportReport
Posted on by Shafeeque P. 6,533 Moderator

I am facing a strange issue. When I create a sales order for a new customer on AX back office. I am unable to recall the sales order and the POS returns the below error message in the event viewer. However, once i run 1010 job and pull the customer information to channel DB, it works fine. 

Error message on POS:

Validation failed for one or more entities. See 'EntityValidationErrors' property for more details.: System.Data.Entity.Validation.DbEntityValidationException: Validation failed for one or more entities. See 'EntityValidationErrors' property for more details.
at System.Data.Entity.Internal.InternalContext.SaveChanges()
at System.Data.Entity.Internal.LazyInternalContext.SaveChanges()
at System.Data.Entity.DbContext.SaveChanges()
at Microsoft.Dynamics.Retail.Pos.DataManager.CustomerDataManager.SaveParties(IEnumerable`1 parties)
at Microsoft.Dynamics.Retail.Pos.SalesOrder.SalesOrder.GetCustomerFromAX(String accountNumber, ICustomerSystem customerSystem, CustomerDataManager customerDataManager)
at Microsoft.Dynamics.Retail.Pos.SalesOrder.SerializationHelper.GetTransactionFromInfo(CustomerOrderInfo orderInfo, SalesOrder salesOrderService)
at Microsoft.Dynamics.Retail.Pos.SalesOrder.SalesOrder.GetCustomerOrder(Boolean& retValue, String orderId, String& comment, IRetailTransaction& posTransaction)
at Microsoft.Dynamics.Retail.Pos.SalesOrder.WinFormsTouch.SalesOrderActions.GetCustomerOrder(String orderId, CustomerOrderType orderType, CustomerOrderMode forMode)
at Microsoft.Dynamics.Retail.Pos.SalesOrder.WinFormsTouch.frmGetSalesOrder.btnEdit_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at DevExpress.XtraEditors.BaseButton.OnClick(EventArgs e)
at DevExpress.XtraEditors.BaseButton.OnMouseUp(MouseEventArgs e)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at DevExpress.Utils.Controls.ControlBase.WndProc(Message& m)
at DevExpress.XtraEditors.BaseControl.WndProc(Message& msg)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam).

*This post is locked for comments

I have the same question (0)
  • sumit0417 Profile Picture
    sumit0417 2,890 on at

    After the customer is created in Back office , did you run the run the customer job to push it to the channel DB? But if you are not running the scheduler job then how are you able to create the sales order for that customer in POS.

  • Shafeeque P. Profile Picture
    Shafeeque P. 6,533 Moderator on at

    I dont want to create the sales order on POS. I am trying to recall a sales order that was created in back office to accept the payment at POS. Sales order recalling works fine if the customer account information is already there in channel DB. If the customer is new, it doesn't work.

  • Suggested answer
    sumit0417 Profile Picture
    sumit0417 2,890 on at

    The database for POS and AX are different.

    If you create the Customer at Back office, it will be created in AX database, untill you run the scheduler job to push them to the POS database.

    Now when you create a sales order and recall it on POS, it checks the customer information and didnt find it in POS database and gives the error. The correct method is to always sync the customer to the POS database and then perform any operation for the new customer at POS.

  • Shafeeque P. Profile Picture
    Shafeeque P. 6,533 Moderator on at

    I understand that. When I recall the sales order on POS using RTS. The POS channel DB is getting updated with the new customer information that I had created on back office. I guess i am missing some field which is causing the issue.

    Question: What is the workflow you recommend to customers for sales orders ? sales order creation on POS

                                                             OR

    Sales order creation on Back office and recall it on POS for prepayment collection ?

  • Suggested answer
    sumit0417 Profile Picture
    sumit0417 2,890 on at

    On Recalling the sales order from POS, the channel data is not updated with the customer information, it still tries to find the Customer against the sales order in POS database.

    The correct flow would be to sync the Customer to POS DB before recalling it at POS or create the Customer from POS itself.

    There is no problem in creating the sales order at POS and then recalling it at POS or creating sales order from Back office and recalling it at POS untill the customer information is synced in the POS channel DB.

  • Shafeeque P. Profile Picture
    Shafeeque P. 6,533 Moderator on at

    To double confirm i did a test. I created the below customer and sales order  from back office and recalled it on POS. Please note that I dint run any job. When I recalled the sales order on POS, the system created an entry for this customer on ax.custtable in store channel DB automatically. Which table does POS use to validate or check if the customer is already existent ?

  • sumit0417 Profile Picture
    sumit0417 2,890 on at

    Its good to see that the record gets created in CustTable, but are you able to search the customer at POS and perform a cash and carry sales transaction- after you recall and close the order.

    Have you checked the other relevant tables that are required to show the customer on POS like RetailCustTable , DirPartyTable etc.

    Basically at POS if you are able to search the customer, then you should be able to perform transaction on it.

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 AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans