Sage MAS 90 and 200 Sage MAS 500 blogs Product Feedback Support Training
Reply
Sage MAS 90 Customer
andrew4
Posts: 60
Registered: 11-13-2009
0

Physical Count Import

I'm not sure if it's because we're on 4.4 now or what, but I am unable to import successfully into Physical Count Entry now.

 

I currently have three fields I'm importing: WarehouseCode, ItemCode, and QuantityCounted. The import passes successfully, and when I open the Physical Count, the amount imported does show up for the Quantity Counted. However, when the register is updated, the quantities are unchanged.

 

One thing I notice when looking at the Physical Count after the import is that the Quantity on Hand is changed to zero for all items. Is this part of the issue? If you bring up an item in Physical Count manually (without importing) it brings up the correct quantity for the warehouse.

 

As a test I also tried importing the ChangeQuantity field, but that brought nothing into Physical Count other than the part (no quantities). Help?

Andrew Lee, CPA
Vancouver, WA
Sage MAS Partner
givingtr
Posts: 348
Registered: 11-14-2008
0

Re: Physical Count Import

Sounds like you have the "Default Qty Counted to Qty On Hand" checkbox selected in Physical Count Worksheet. I know the import works, as a client is using it on 4.4 PU3.

Mark Kotyla
Giving Tree Consulting, LLC
(860) 313-0720
Sage MAS 90 Customer
andrew4
Posts: 60
Registered: 11-13-2009
0

Re: Physical Count Import

I just checked the worksheet and that box is not checked. Any other ideas?

Andrew Lee, CPA
Vancouver, WA
Sage MAS 90 Customer
andrew4
Posts: 60
Registered: 11-13-2009
0

Re: Physical Count Import

Also, it is not defaulting the quantity counted to the quantity on hand. What it is doing is defaulting the Quantity On Hand to zero in Physical Count Entry each time the import is done.

Andrew Lee, CPA
Vancouver, WA
Sage MAS 90 Customer
andrew4
Posts: 60
Registered: 11-13-2009
0

Re: Physical Count Import

The problem ended up being simple--I needed to freeze inventory first!

Andrew Lee, CPA
Vancouver, WA
Switcher
BigLouie
Posts: 2,687
Registered: 10-28-2008
0

Re: Physical Count Import

Well da!

Big Louie No MBA but BMOC
--------------------------------------------------------------------------
You have enemies? Good. That means you've stood up for something in your life.
Sage MAS Partner
kathleenm
Posts: 98
Registered: 12-08-2008
0

Re: Physical Count Import

I am having the very same issue; however I froze Inventory!!! Everything is defaulting to 0.00 on hand.......gotta love this!!

 

As to Big Louie - Do you think DA!! was a very nice remark to make??