Lots can be accomplished with a little creativity.
Create a spreadsheet with item codes, and quantities. Scan the inventory bar codes into Excel (via laptop/usb scanner with quantities. Create a pivot table to consolidate multiple scans of the same item. Compare count to on-hand quantity. Very count against variances. Import line item counts. Easy and straightforward.
Or add a bar-coding solution from Scanforce or Scanco...
------------------------------
Jeff Schwenk
Owner
Bottomline Software, Inc.
Waynesboro VA
(540) 221-4444
Improving bottom lines for over 25 years!
------------------------------
Original Message:
Sent: 05-13-2025 23:33
From: Kevin Moyes
Subject: Items Missing in Physical Count Entry
If you are going to import from a spreadsheet, start with an Excel query of IM_Physical (after the freeze)... to avoid typing in the item / warehouse / lotserial... data, and just key in the counts.
------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------
Original Message:
Sent: 05-13-2025 23:13
From: Jeff Schwenk
Subject: Items Missing in Physical Count Entry
A suggestion for your client is to key the information into an Excel spreadsheet and then upload the data using VI. Way faster/accurate and you avoid the kludgy data entry slog that you are encountering.
------------------------------
Jeff Schwenk
Owner
Bottomline Software, Inc.
Waynesboro VA
(540) 221-4444
Improving bottom lines for over 25 years!
Original Message:
Sent: 05-13-2025 15:41
From: Kevin Moyes
Subject: Items Missing in Physical Count Entry
As long as you are not filtering the physical count entry screen by product line, it shouldn't matter.
GL accounts for posting any variances might be for the old PL though... I'm not sure which value Sage would use.
------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
Original Message:
Sent: 05-13-2025 15:17
From: Scotia Saunders
Subject: Items Missing in Physical Count Entry
They are cleaning up inventory and have changed the product line on several of the items in Item Maintenance. Would this make a difference?
------------------------------
Scotia Saunders
Keystone Business Solutions
scotia@teamkbs.com
Original Message:
Sent: 05-13-2025 14:27
From: Kevin Moyes
Subject: Items Missing in Physical Count Entry
Possibly an invisible character causing the grid sort order to put the data somewhere other than where you expect it. Run an Excel query against IM_Physical to see the raw data.
------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON