There is no such feature, nor is it necessary. Turn off day-end processing until you're done.

Physical Inventory, Generate Inventory Worksheet creates a snapshot of the inventory at that point in time.

Hi Jay,

It is necessary to achieve the actual physical count to tie up with the system. If we generate inventory worksheet and says that an item qty on hand is 10 and a shipment entry of 2qty has been posted it will reduce the qty on hand to 8. When you go back to
to Physical Inventory quantities and record the actual count which is 8qty, it will have again reduce the qty on hand by 2qty, leaving the qty on hand per system as 6 which is wrong.

I don't understand the "Turn off day-end processing until you're done." How can this be done?

Regards,
Michelle

Michelle, you are 100% correct. we encounter the exact same thing. That is why we tell everyone to STOP processing anything. If someone processes a document that affects I/C after the count is made, you are in for a world of hurt.

It can be unavoidable though, so it might be easier to just keep track of any shipments that happen after the worksheet is made, and re-count those items after the inventory process is complete. We do this every year to ensure those items are correct.

No, when you post the physical inventory quantities, it says "-2" from before. It works from the snapshot, not what's current.

Sorry, Mike, you are mistaken.

wrong. run the sheet. it says 10 pieces. before I get there, someone write up a new order for 3 pieces and ships it out. I go and count them with a sheet that say I should have 10 pieces. I only find 5 pieces. so the sheet wants to make a -5 adjustment, but the shipment ALSO takes out it's 3 pieces. That's a total of -5.

Your turn. Been through this EVERY year.

total of -8. typo

Yeah, whatever, you can believe what you want. My clients don't have any problems with physicals.

I repeat: Physical Inventory, Generate Inventory Worksheet creates a snapshot of the inventory quantity at that point in time. Your physical count adjustment is then calculated against the snapshot quantity - not against the current quantity on hand.

Your'e wrong.

Your'e wrong..

Wrong again

To test this do the following in sample company data (SAMINC):
1. Run IC day end processing
2. Generate Inventory Worksheet for location 1, include Default Quantity on Hand
3. Print page 1 of the Inventory Worksheet, include Quantity. This is your hard copy to check quantities against later on.
4. Open Physical Inventory Quantities and verify that the quantities match with your printed Inventory Worksheet.
5. Check the quantities in Location Details and verify that they match your printed Inventory Worksheet
6. Post an OE invoice for the items listed on your inventory worksheet, use random quantities
7. Run IC day end processing
8. Open Physical Inventory Quantities again and verify that the quantities match with your printed Inventory Worksheet - they will still be the same.

I understand that the physical count adjustment is calculated against the snapshot quantity but then system still allows posting of transaction that will affect the quantity, which will result to wrong I/C adjustment.

No, it won't. You have been given bad advice.

Pay attention to my post above - the snapshot quantity does not change when transactions are posted. Physical inventory quantity adjustments are calculated against the stored quantity in the snapshot.

Dear Michelle,
In that case we are exporting user access and then removing the access of IC/OE transactions for the respective users. and once the physical inventory is done we are importing the previous access. it takes only 10-15 min for my 100 users and this is so simple and safe..

Simple, safe, and unnecessary.

but it will solve his purpose.

There is nothing to solve - hence it has no purpose. The standard Physical Inventory functionality works if they follow the correct procedure as outlined in the Inventory Control user guide. There is no need to do all kinds of unnecessary steps.

ok, so from your example, you are saying that people should be running a day-end BEFORE they post the final inventory reconciliation. That is completely contrary to what Sage says to do.

This is straight from the manual:

"Warning! To ensure quantities and costs on worksheets are current, do not
post transactions (receipts, shipments, transfers, adjustments, assemblies,
or internal usage), and then run Day End Processing between the time you
generate inventory worksheets and the time you post the inventory
reconciliation."


Guys, I'm not trying to argue with you, but I am a USER that has been using this for over 10 years. I know you are both professionals with 30+ years but sometimes you need to stop and listen to what others are trying to say before passing judgment.

I was agreeing that the worksheet will take a snapshot. What it can't see is when people go and post another transaction for a part before a count person gets to count it. So if you are saying that running a day-end mid process, is not going to screw up costing and will indeed update the inventory... then sweet jesus that would have saved hours of headaches over the years.

I'm moving on. I was trying to help with what we experience. I honestly thought this forum was supposed to be about talking about what everyone experiences and ways of working together.

I'm a Sage consultant that has been doing this for over 20 years.
Yes, I do say run an IC day end BEFORE you generate inventory worksheets. To be more specific, and this is in the user guide, complete all IC/OE/PO transactions that affect inventory for the period you are closing (i.e. not transactions for the new period) and THEN run IC day end processing BEFORE you generate inventory worksheets. Happy now?
And now follows the part you quoted, i.e. hold off IC day end processing until you have completed the physical inventory and posted the adjustments.
So to clarify clearly - I'm not saying that you should run IC day end in mid process, you ran it at the start of the process and then again at the end.
BTW I'm not passing judgement - some users here are dispelling absolute untruths and that need to be pointed out, because the next users who come along here and read that kind of garbage is going to think it is true.

I see where you got confused. Note my post (the one that starts with "To test this...") was intended to point out that the quantities do not change in the physical inventory worksheet even if you do post OE transactions and run day end processing. I was not saying that this is the correct way of going about doing a physical inventory... use some common sense.

Interesting conversations guys. Correctly managing your inventories is always harder than selling the stuff in the first place. Anytime more than 1 person is performing both actions it always goes backwards.

We've built a tool in house that allows us to more rapidly do Cycle counting with Accpac. Although it can also handle an annual inventory as well, we've chosen to go the cycle counting way.

The tool calculates how many items should be in the bin / location at that the time your standing in front of it based on live OE/PO/IC etc.. information. Proving to be very accurate. The tool will then make the correct adjustment to an inventory worksheet on the fly after our Automated Day end runs at 12:30am. I'm certain we could even adjust it to recheck the item for any changes before posting the final worksheet adjustment thus negating the requirement to stop daily order processing. If your curious I could provide you with more information.

We may not even have to do a year end count this year, exciting stuff!