How to print Department & Category of the item on sales receipts?

(0) Share

Report

Posted on by VkB

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?

I have the same question (0)

All responses (4)

Answers (0)

ToddB Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
VkB 5 on at

Like (0)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No
ToddB Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Kevin Antosh 1,649 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No