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 :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Retail Posting missing...
Microsoft Dynamics AX (Archived)

Retail Posting missing in Invoice Journal

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

I am facing an issue in Retail Posting. For one particular day's retail store transaction I have posted but I cant see the same in both the places Invoice Journal and Customer transaction. But when I looked into posted statements, I can see the same transaction has been posted with statement number. 

I am thinking the issue can be the posting got stuck at retail module and it hasn't gone to Accounts Receivable module. Anybody has any idea how to resolve this?

Thanks in advance.

*This post is locked for comments

I have the same question (0)
  • nunomaia Profile Picture
    nunomaia 25 Moderator on at
    RE: Retail Posting missing in Invoice Journal in AX2012

    Did you enabled aggregation of Voucher transactions ?

  • Community Member Profile Picture
    Community Member on at
    RE: Retail Posting missing in Invoice Journal in AX2012

    Sorry, which in module you are talking about?

    I think why this issue happened is during posting retail transaction power has gone. So it got stuck in the middle.

  • nunomaia Profile Picture
    nunomaia 25 Moderator on at
    RE: Retail Posting missing in Invoice Journal in AX2012

    I has referring the aggregation settings in the Retail Parameters, you can have “less” entries in payment vouchers due do aggregation.

    If you had a power outage during the posting, it might the reason, I never had such experience.  

  • Community Member Profile Picture
    Community Member on at
    RE: Retail Posting missing in Invoice Journal in AX2012

    Hi Nunomaia,

    Yes there was a power outage.

    Anybody has any suggestion how to solve the issue? If I do database synchronization, will it helps? or any other workarounds?

    Thanks,

    Dhanoop R.Warrier

  • nunomaia Profile Picture
    nunomaia 25 Moderator on at
    RE: Retail Posting missing in Invoice Journal in AX2012

    Those issues are hard to solve, because if you have an incomplete transaction due to an error ( power outage, etc.), you must try to do somehow,  to recover the incomplete data using journals, etc. ( if possible …  )  This shouldn’t happen even in a AOS failure, but some code might have an error, if isn’t protected properly in a transaction. Nevertheless, there is an KB issued by Microsoft to solve an issue if the AOS failed during statement processing you might get an incomplete statements.  I don’t know if it fits your case.

  • Community Member Profile Picture
    Community Member on at
    RE: Retail Posting missing in Invoice Journal in AX2012

    Hi,

    I am facing same issue in Retail posting. For some statement i cant see Invoice journal and customer transaction into posted statement with SO reference but when i see sales order there is no record of item transaction. But in invent trans table i can see those item line record with Physical reserve status.

    If you can find the solution or root cause, let me know.

    Regards,

    Rohan Sawant

  • Community Member Profile Picture
    Community Member on at
    RE: Retail Posting missing in Invoice Journal in AX2012

    Hi Rohan,

    Have you posted Retail statement?

  • Community Member Profile Picture
    Community Member on at
    RE: Retail Posting missing in Invoice Journal in AX2012

    Yes Retail statement is posted and sales inoice reference is availble into statement but item line is missing into SO. also payment entry is made against that. because of that customer is showing as over payment.

  • Community Member Profile Picture
    Community Member on at
    RE: Retail Posting missing in Invoice Journal in AX2012

    Hi Rohan,

    What I understood is, the retail statement is posted, SO is created and inventory also got affected. Or inventory is showing as reserved?

    I suggest you to check the tables in AOT level and find out the items are showing in sales order or not. You can check table name "Sales Line". But please careful with AOT always. Don't do any changes there unless you are 100% confirm.

    Regards,

    Dhanoop R.Warrier

  • Community Member Profile Picture
    Community Member on at
    RE: Retail Posting missing in Invoice Journal in AX2012

    Hi Dhanoop,

    Retail statement is posted and, SO is created but in SO there is no line of item. I have also checked into Sales line table but no line is showing.but invent trans table item line is showing with physical reserved status.

    If i checked customer transaction there is no invoice transaction.

    I checked in all table but apart from invent trans all other inventory table missing item sale data.

    I wonder how can system didn't post sales invoice but payment is showing against invoice.

    Regards,

    Rohan Sawant

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

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…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#2
Community Member Profile Picture

Community Member 2

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans