Share
ReportI need to print Department and category of the item on the invoice.
I tried the following:
I used Entry.Item.DepartmentID but it's giving me a token error:
Any solutions, please?
You’re offline. This is a read only version of the page.
5
I need to print Department and category of the item on the invoice.
I tried the following:
I used Entry.Item.DepartmentID but it's giving me a token error:
Any solutions, please?
Hi! We have created quite a few customizations for RMS. Can you please let me know the name of your store and what city/state your store is located? I can then connect you with a contact at RITE who can check and see what options we might have for you.
Hi VkVk,
I am not aware of a way to summarize by department on the receipt; but others on this form may be able to assist.
As far as populating the SubDescription fields with the Department/Category information, this should be something you could do via a SQL script.
NOTE: Please ensure a backup is made before running any update/delete/insert scripts; and you may want to first try this in a TEST/DEV environment.
Hopefully this helps.
Hi Todd,
Thank you for your reply.
I couldn't login from previous account, so i had to create this new one and reply you.
I understand your point but we have more 10,000 products and it will be very difficult to keep track on SubDescription fields to have entered the Department / Category names.
Plus, we also want to show the total qty purchased by the department on the receipt. i.e:
Cigarettes: 40
Drinks: 20
Cigars: 10
etc etc
Is there any way that i can create variables for Department / Category in the database?
I have some knowledge of SQL server and XML coding.
I would really appreciate your help.
Thanks & Regards,
Hi VkVk,
In checking the documentation, there does not appear to be variables for adding item Department and Category to the receipt.
For your reference, I have attached the zipped Customization Guide which lists the available receipt variables.[View:/cfs-file/__key/communityserver-discussions-components-files/106/Customization-Guide-September-2007.zip]
The only option I can think of would be to populate unused fields with the Department and Category name (maybe Subdescription 1, Subdescription 2, Subdescription 3 if these aren't being used); and then add these fields to the receipt format.
_______________________________________________
Just a note that Mainstream support for Microsoft Dynamics RMS 2.0 ended on July 10, 2016; and extended support ends on 7/13/2021:
https://community.dynamics.com/rms/b/rmssupport/archive/2015/10/22/microsoft-dynamics-rms-2-0-mainstream-support-discontinuation-july-10-2016
Dynamics Retail Management System 2.0 - Microsoft Lifecycle | Microsoft Docs
This is less than 5 months from now; and you can continue using RMS after this date but technical support will not be available.
I would recommend checking with your partner in regard to what they may recommend as a replacement system after the extended support end date.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (