Dynamics Community Forum Thread Details

Best approach to track changes on prices from supplier invoices?

Hello,

This is my first post so I apologize for any missing information. My friend owns a business and they use Microsoft Dynamics RMS Version (to be addressed).

The problem they face is that the supplier may rise the prices of certain goods without letting them know. So the problem is that they have over 1000 products. And what they do is that for each product, they take one, scan it, verify the purchase price vs the new price on the latest invoice and then adjust the price accordingly.

As you may imagine this is extremely frustrating.

I am a Software Developer so I would assume that getting the invoices on a excel format and feeding them to some kind of middle app that integrates with RMS would be a good start to automate this process.

I wanted to know what are your thoughts. I never interacted with MS RMS before so what would be your best advice. I've worked with Oracle systems and they provide some APIs to allow integration with third party apps.

Is there anything that RMS offers out of the box to attack this problem?

What would be your best advice?

Hello Alejandro,

I had a similar problem with pictures as we use them for catalogues. It was pain staking and slow to find the missing, wrong or redundant pictures for each item. I have made a program that compares what we have to what we need, mind you I am not developer so you may posses better skills. Here is how I went about it:

Using reports from RMS saved files as .tab not .csv because entries may have commas in items. Say for you items from a supplier cost current. In my case pix of items of interest.

Using the order received in .xls or .tab form. In my case pix files in RMS folder.

Compare the two and highlight the changes.

A note of warning. When I attempted to retrieve the information directly from RMS database and connected to this data base the connection of POS, RMS manager, RMS Administrator was gone and I was not able to connect back. I had to delete and install from back up. That's why I am using report exported files to compare.

I used Visual Express 2008.

There is another way to check upon these changes. If orders are entered in RMS when received and the total amount is different in your order and invoice received then there is a change but then again have to picked up manually.

Good luck

Quick Links

Leaderboard