1. Home
  2. Point-Of-Sale Software
  3. after physical inventory THEN what?

after physical inventory THEN what?

I did a physical inventory of my smallest department to test out how that works in RMS. I had a few "deltas" which I double-checked. I set reason codes and committed the new amounts to the database.

NOW WHAT?

Obviously, there is some entry that needs to be made in my accounting software for those deltas. I use Quickbooks, though I do not have any automatic posting to it set up yet (a goal for next year). How do I make an entry to correct for the corrected inventory values?

Thanks and PLEASE Cc me directly. ______________________________________________________

Larry Leveen OlyBikes Bikes, Parts, Repairs & GREAT Customer Service!

124 State Avenue NE Olympia, WA 98501

P: 360-753-7525 F: 360-528-7526 snipped-for-privacy@olybikes.com

formatting link
Featuring free bike advocacy and safety materials!

Reply to
OlyBikes
Loading thread data ...

After your done with your inventory, do a 'Item Movement History Report' on the reason code you used when you did the inventory. You will need to enter the name of the reason code in the filter, not the code#. This will give you the total $ amount you will enter as an adjustment in QB. You will need to do this adjustment manually, as it won't be included in any post. The default 'Item Movement History Report' that comes with RMS doesn't give you a $ amount,just quantity, so you will need to download 'Item Movement History Report with Cost' from Customersource to get these totals. Craig

Reply to
Craig

After your done with your inventory, do a 'Item Movement History Report' on the reason code you used when you did the inventory. You will need to enter the name of the reason code in the filter, not the code#. This will give you the total $ amount you will enter as an adjustment in QB. You will need to do this adjustment manually, as it won't be included in any post. The default 'Item Movement History Report' that comes with RMS doesn't give you a $ amount,just quantity, so you will need to download 'Item Movement History Report with Cost' from Customersource to get these totals. Craig

Reply to
CptSoft

Actually its even easier. Go back into the Physical, print it while adding the Delta Cost column. Then click the Group icon once and the Delta Cost is now totaled. That is your inventory adjustment amount that you post to your accounting program.

Reply to
Craig

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.