As a new user to the system, we are finding items that were not properly accounted for in the beginning inventory. When something is found, we enter it as a new item, but enter the inventory count before saving it. When saving, it asks if it is a correct count or starting inventory adjustment. I usually select "starting inventory. (We use the Quickbooks accounting interface to post to Quickbooks. I do not post purchase journals as it does not provide the same flexibility and vendor accounting that Quickbooks does when entered through their Vendor Billing system.) I do have the daily batches post to Quickbooks. I can't find any of the inventory adjustments that should be created when the inventory is modified. My question - Does the system create any journal entry that would effect inventory? If so, how can I trace them? I have tried change the accounting option so it posts to a "iif" file and then re-post all of the daily batches. The only thing I see in the file are the daily sales postings, nothing notating an inventory adjustment.
Hello. We are trying to export GL from RMS into our acct. sw, and your issue sounds like what we're trying to do by exporting GL data - to credit or debit certain inventory transactions on our books- you may need to:
-perform your new item transaction in a way that makes some kind of item history -therefore may be logged as a GL account type-by using Inventory\Transfer - this generates records & data trail;
- have corresponding entry in your GL items in RMS, to either get/report on/send - the info you want, in Quickbooks.
GL accounts are described in the Help section, I think well enough, certainly more detailed than the rest of Help. See if a specified acct type is in there to match your needs.
But it sounds as if you 1st adjust inventory using Inventory\Transfer In\Out, you will generate the type of info trail allowing detailed reporting on inv. adjustments in RMS, and creation of a GL account that is linked to this activity as well.
I thought we purchase software to make our work easier! Having to manually go into inventory transfer in/out is time consuming, and drive me nuts tracking each one. In addition, using transfer out for removing inventory when, say a vendor takes product back and issues a credit should be a function in the purchase order screen. There are times that vendor bills include credits on invoices. This should be allowed to be in the original P.O., not seperating them on two different entry methods.
I have a suggestion, does anyone remember the United Airlines commercial where the president passes out airline tickets to his sales people and tells them to visit their customers? Well, Microsoft has forgotten about it's cusotmers, and needs to send their programmers out to sit with users to see how difficult the system is, and how easy it could be made to work. Programmers see with "blinders" and think that their method is the "only method".
Microsoft, please wake up, and really read some of these e-mails. Your customers want answers, but you are not listening! Not telling us about future product releases is B.S., especially for what we pay for the software and then the support packages. Give us an outline of the future, so there is some encouragement. You don't need to disclose detail, but really, tell us what to expect. Does Bill Gates ever read any of this, and, does he even care? I guess being the richest guy in the world should not let him lose focus on who pays those dividends!
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here.
All logos and trade names are the property of their respective owners.