Dear everyone,
I know that my subject is kind weird, please let me elaborate further.
Before I joined, my current company is not utilizing the feature Purchase Order in RMS. So whenever they received items from suppliers they will update the inventory manually or not at all.
The good thing is that whenever they received items from suppliers there is a document called packing list containing all the information such as date, quantity, etc. So I'm thinking of creating POs based on these packing lists, but the challenge is how do I insert these POs to show the date that is shown in the packing list and at the same time not ruin my current inventory – we already performed physical inventory and it is 99.99 % accurate.
We came up with this idea of inserting POs because we want to identify the "age" of items that are now sitting for months. It's really difficult to identify their "age" since I don't have Purchase Order history in RMS
At the back of my mind, I know this is possible by running SQL queries/command, but the problem is I am not that well verse in managing SQL database and we don’t have the budget to outsource.
Any help will be highly appreciated.
Thank you,
Koymackoy
