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

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Calculate statement on Retail Module AX 2012 R3

(0) ShareShare
ReportReport
Posted on by 167

Hello every one ,

   I have an requirement  when calculate statement on retail  

      i need to know what is the on-hand Qty that required before i calculate statement .

     and  how AX deal with Product Kits  during Calculate Statement  ?

thanks 

I have the same question (0)
  • Ramune Profile Picture
    on at
    RE: Calculate statement on Retail Module AX 2012 R3

    Hi Ashraf,

    Regarding on-hand qty - what exactly do you want to see before statement calculation? Do you mean for sold item transactions to check on-hand qty? Do you mean some report? Or form? What the reason of such request?

    Regarding Product kits - do you want to know how kits are shown in calculated statement and how they are posted? Or something different?

  • Suggested answer
    A.Prasanna Profile Picture
    8,223 on at
    RE: Calculate statement on Retail Module AX 2012 R3

    Hi Ashraf,

    Ideally you will need enough on hand inventory , same or more than you issued while posting statement. POS any way allows negative inventory.but when the time of posting statement it will reconcile against on hand inventory.

    same logic applies to Product Kits too because It's just of assembly of 2 or more items.

    Thanks & Regards,

    Amith Prasanna

  • Ashraf Kamal Profile Picture
    167 on at
    RE: Calculate statement on Retail Module AX 2012 R3

    Hi  , Amith Prasanna 

    ex .

     assume that  , We have an product kit X and its Components  Y , Z 

     if i sold From X  10  and its onhand   5 
     

    how may qty of Y and Z to can post this statement  ?

  • Ashraf Kamal Profile Picture
    167 on at
    RE: Calculate statement on Retail Module AX 2012 R3

    i want an report to know the difference  between sold qty and on-hand  

    and i want  to know how Kits are  shown in calculated in statement and how they post  ?

  • Verified answer
    A.Prasanna Profile Picture
    8,223 on at
    RE: Calculate statement on Retail Module AX 2012 R3

    it will differ the way you bundled them in the KIT , if X consist of  1Y and 1Z mean  1X =1Y+1Z  if you sold 10 thats mean it will show you 10Y , 10 Z . if you have only 5 kits it will settle with 5 and other 5 will show as balance.

    refer : kurthatlevik.com/.../ for more clarification

  • Ashraf Kamal Profile Picture
    167 on at
    RE: Calculate statement on Retail Module AX 2012 R3

    i will try this and feedback  , 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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,028

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 878 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 579 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans