Skip to main content

Notifications

Microsoft Dynamics RMS (Archived)

Detailed Sales Report with Serial Number of the last Official Receipt/Invoice number

Posted on by 885

Hi guys,

Help!

How can I show the column in the sales report in which the Serial Number of the last Official Receipt/Invoice number issued for the month being reported?

Here in the Philippines, transaction number and the official receipt or invoice number should also be shown in the sales report.

Any feedback is greatly appreciated.

Thank you.

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Detailed Sales Report with Serial Number of the last Official Receipt/Invoice number

    I believe this is a government requirement to have their own series of transaction number per POS.  RMS only has one series of transaction number for all POS installed.  Gene, I suggest you contact one of your RMS partner in the Philippines. to do the customizations.  I already gave you our contact number.  Let us know if you want us to do it for you. Thanks.

  • Gerald Rothaus Profile Picture
    Gerald Rothaus 2,930 on at
    RE: Detailed Sales Report with Serial Number of the last Official Receipt/Invoice number

    Ok, I don't know where Heidi is going with the MAX thing at all. The serial number is recorded in a table called, oddly enough, 'Serial'. It can be joined to the transactionentry table via the transactionentryID to attach the serial number of the item sold to the item sale in the report this way.. Please explain.

    As far as the Official Receipt Number thing,  I still don't quite get that. An I to understand that is another number for the sale along with the invoice number? If so, where are you typing it in?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Detailed Sales Report with Serial Number of the last Official Receipt/Invoice number

    Hi Gene,

    You would need to write a report that selected MAX(TransactionNumber) that was grouped by month and year.

    If you're not sure, let me know and I can provide more information.

  • Gene Palomar Profile Picture
    Gene Palomar 885 on at
    RE: Detailed Sales Report with Serial Number of the last Official Receipt/Invoice number

    Hi Gerald,

    My question is, does it need to create a custom table for the Official Receipt #s? if so, what other tables are inter-related to it. I haven't done any customization in the tables, just in the receipt template.

    Any response is greatly appreciated.

    Thank you.

  • Gerald Rothaus Profile Picture
    Gerald Rothaus 2,930 on at
    RE: Detailed Sales Report with Serial Number of the last Official Receipt/Invoice number

    Hi. Now I see where you are going with this.

    Where is your official receipt number kept?

    You have to do a join to that table and then add the column in the report qrp to expose it and/or add it to your report.

    -Jerry

    jerry@jrdata.us

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,900 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,297 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans