Hello All,
We are using SAGE 100. Somehow On PO qty coming in Stock status report is not Open PO Qty.
SAGE is pulling a open PO qty from somewhere - SAGE ppl kindly share your thoughts
In the below example, in main I m seeing a open PO qty but in…
Hi!
We have recently created a second warehouse in our system and are trying to find the most efficient/effective way to transfer the inventory in the system as well as physically. I know there is a transfer option in inventory management, but we are…
We have a finished good that is serialized, however we will now be selling this item with an additional component that we would like deducted from inventory automatically.
We had considered changing the serialized item into a 'kit', however that would…
IC Transfer number skipping a digit, for example after posting a transfer, TRF 0002, the next number generated is TRF 0004! (the image shows transfer no. TRF0005433 is missing
the user says that when he posted the system did not give him the option…
Does anyone know how to change the valuation default in Item Maintenance from Standard to Lot? Trying to prevent incorrect entries when setting up a new inventory item. Thanks for your help!
Hello all,
I am trying to find a way to solve an issue that I have with how the Quantity Available field is displayed in Item Inquiry. It's kind of a difficult issue to explain but I'll try my best here:
Lets say I have 300pcs of an item On Hand.…
This may come down to being internally defined, but I am looking for examples of how you handle your RMA's as far as tracking in the Sage 500 system. By design, we originally had a Service Warehouse where all RMA's were receiveing into the default bin…
Trying to get a very simple report from IM.
Item Number, Reorder Point, Quantity Sold YTD and PY along with a calculated field.
The Reorder Point prints fine as do other fields such as Quantity On Hand and Quantity on Sales Order but I get nothing…
To start off, we are on Sage 100c Advanced v2018.2
How can we append an original Lot # when transferring qty from 1 whs to another?
Create PO for Qty = 100,000.
ROG the full Qty 100,000 to an offsite warehouse ("OFF") with Lot # 12345.
When when…
I was wondering if any one has done this type report
I did a custom crystal report that i'm able to see specific item code, but for some reason when i'm running the report those item codes that doesn't have any transaction history is not showing and…
My company is a broad line food distributor and we also manufacture deli products such as bologna, salami, etc. We carry about 1,500 different items. There are about 10 employees that work picking order throughout the day and night and its all done on…
Merged over 3,300 items to code "Z_Discontinued" after months of working with staff to make sure all items on list were approved for merging.
Now they need 2 of the 3,300 items restored, historical data. I created the original item numbers and setup…
I have a client that is exploring the idea of converting their inventory numbers (most are vendor numbers) to be generic numbers that will be sequential. They are a service company that has 16 years of Sage data. Some parts are drop shipped to their customers…
New to Sage 100 Contractor with the Inventory Module. I'm having an issue with posting Goods Receipt and the Invoice Receipt.
Goods Receipt was fine. Went to 12-4 and posted 500 units received. Immediately used qty 8 for Inventory Allocation 12-2…
In the pre-business framework days, this information was available in the resources link.
I need to know which files are used by the Inventory Trial Balance report.
Hello Sage 100 Community.
I was wondering if any of you know a way to view an inventory snapshot of a particular date in history (historical inventory quantity). I'm just trying to see the quantities for all items at a particular date in the past. …
Our client is working on Sage 300 2014 PU3.
When doing the Physical Inventory Reconciliation it gave an error that states "There is insufficient quantity available to adjust item XXX at location XXX".
When checking the specific item via Item Location…
Hi Support,
It is normal procedure to freeze all inventory transactions before generating the worksheet. Our month end inventory reconciliation last for up to two weeks. Is it possible to still post order entry invoices for the new month? What will…
We have a packaging company with a large variety of items which are packed to order. As we don’t prepack, virtually all our sales are through kits with the option selected to “always explode”. We do have a bill of materials (BOM) for each kit as items…
I understand how negative OVERDIST tiers occur, but a bit fuzzy on how positive OVERDIST tiers occur. Is there a good write up that someone has done that explains this process for both myself and my clients?
Hello,
We are a distribution company that is looking to implement a WMS that can integrate with Sage 100. Preferably one that can stand alone as well. We are going through some growing pains and may also be looking to a new ERP in years to come. May…
We are currently using MAS 200 for inventory reconciliation. I use the stock status report to balance our physical counts to MAS, giving us a potential variance amount. Once I enter the physical count numbers into physical count entry I am finding that…
I'm wanting to add about 600 items to an already existing list of products in our datasbase.
So, I exported 3 lists:
I opened I/C “Items”. I created a script that would contain all the columns we use in that first tab (of the Items Module), and the…
Community,
We are a mid-west manufacturing company and are looking to implement the JobOps product with barcoding using JOScan. We are hoping to find another company presently using JobOps with Sage 100 ERP that might be willing to share their experience…
