14

There are two scenarios when Batch number for Return transactions are not taken from sales transaction:


  1. When return transaction is registered in POS without reference to sales transaction
  2. When return transaction is registered in POS with reference to sales transaction but both transactions are posted in the same Statement


In both two scenarios when Batch number for return transaction is not taken from sales transaction there is required to setup Batch number group in Released product to enter new Batch number from sequence.

It is standard behavior but in effect it generates many new not necessary Batch numbers.

It would be better to use Default Batch number instead Batch number from sequence in such case like it is for cash&carry sales transaction.


Repro steps with 2 scenarios:

  1. Register Return product operation in POS for Item with Batch number tracked (no reference to sales order),
  • Upload by P job to HQ,
  • Run Validation of retail transaction,
  • Calculate and try to Post Statement


  1. Register Sales transaction in POS for Item with Batch number tracked,
  • Go to Show journal and select new created sales transaction,
  • Register return transaction,
  • Upload by P job to HQ,
  • Run Validation of retail transaction,
  • Calculate and try to Post Statement


In both cases there is presented error message in Statement:

While processing the state Customer order invoiced, generic exception encountered in retail statement xxx post aggregate controller while aggregating the transactions: 

Posting Posting Sales order: yyyy Item: zzz Batch number group is not specified on item and can therefore not automatically be created 

Posting Posting Sales order: yyyy Item: zzz Inventory dimension Batch number must be specified. 

Posting Posting Sales order: yyyy Item: zzz Update has been canceled. .


It would be better to assign Default Batch number id for return transaction instead of generating new ones from sequence number



STATUS DETAILS
New

Comments

J

agree, kindly facilitate

Category: Order processing and fulfillment

J

Please enable return batch handling framework in retail statement posting. thankyou

Category: Order processing and fulfillment

J

@Microsoft Product team,


Our company is doing Perfumery Production, its Trading & Retail business.

We deal with Products that have batch with production/expiry dates in production, However for our Retail business we didn't opted to enable Batch tracking due to one of the reason listed by Mr. Jaroslaw, 2ndly no control of batch expire and batch based pricing at MPOS.


I hope you guys would refine the solution for batch enabled products sales and return for Retail business. thank you

Category: Order processing and fulfillment

J

Thank you @Jaroslaw highlighting very important issue for handling batch tracked items at Dynamics Moder Point of Sales (MPOS) for Retail businesses. I would second the proposed solution and case statement you have provided in the idea above.


https://learn.microsoft.com/en-us/dynamics365/commerce/batch


In my view point...

This is not good for MS to provide an ad-hoc solution to its customers for batch tracked item. In order to deal with Retailers using batch enabled items at MPOS, the solution should be complete in all possible aspects. Presently Retail Sales posting process is not working correctly for both sales scenarios that you have correctly documented in your email. I also hope MS team should also understands the quantum of issue from retail business perspective that is using batch enabled items. The volume of issues in retail would be quite high and it’s not possible either for MS Partner/MS Support team to support customer to keep customers business running and neither customer’s ERP/ operations team can be held responsible to clear batch related errors for return sales manually or manage new/unnecessary batch numbers created by retail statement posting process in D365FO. The D365FO application design should be fixed to match with requirements/scenarios of batch enabled items handling just like it does for back office operations.

 

I would also encourage others from the industry to vote your idea..

 '

Category: Order processing and fulfillment