Browse By Tags

  • Is there a PO Return of Goods History Report

    Is there a PO Return of Goods History Report? I see Inventory Sales History, Inventory Receipts History, and Inventory Issue History Reports under IM module, but I don't see an Inventory Return of Goods History Report. Nor do I find one under the PO…
  • Receipt of goods is not asking to print all reports

    Receipt of goods is not asking to print all reports it is just automatically printing the Goods register and the Daily Transaction register. It is not printing or offering to print the back order register. If do a preview it does ask to print all but…
  • Auto filling Inventory from Receiving Purchase Orders

    We are using Scanforce to receive our purchase orders once they are placed. We can see the receipts in the Receipt of good entry section once they are received, but would like to see the inventory auto update to our on hand stock once received. Do we…
  • returned item shows as received on PO

    I have a PO with returned item still showing as received. 15 ordered, 20 originally received, 5 returned, 15 invoiced The PO shows the goods receipts for the 20 and (5), GLs are debited and credited as expected and inventory is correct. However, the…
  • RECEIPT OF GOODS VS P.O. VS COST DETAIL

    What would be the best way to get around the issue of receiving items at the incorrect cost? The issue we're having is that the receivers are just receiving in the items with no knowledge of cost differences on the p.o. vs the invoice we receive from…
  • Inventory Adjustments - Profit Margins

    Hi Everyone A purchase order was received in with a higher unit costs than it was supposed to be Sales orders were processed and updated Found mistake did a return of good and re-received at the correct unit costs How do I now fix the profit margins…
  • Restrict an On Hold PO from being ROG

    Is there a way to restrict an On Hold PO from being received in ROG/ROI? New security on Sage 100c Advanced 2022.1 doesn't have such an option for "Override" or anything else I could find. SO has something, but not PO. Why wouldn't Sage make the same…
  • Reopen a Completed PO

    Is there a way to allow non-Admin Sage 100 users the ability to Re-Open Completed PO's? Quite often we get late Invoices or additional quantity received after the PO has automatically been changed to Completed status, due to 10% Completion rule or that…
  • PO ROG not all items posted to GL

    Client on 2021 has a ROG listing where 3 ROG did not post to GL. They have a drill down on the ROG record pointing to the GL posting, but their receipts are not a part of it. I've checked the GL account, verified it's not DropShip, and it IS an inventory…
  • PO Daily Receipt Registers posting VERY (!) slow

    Sage 100c Advanced 2018 v6.00.10.0 When we update a Receipt of Good Register, even for just a small receipt, it can take 30 minutes or more to update. No other updates in the system take as long Is there a way to refresh the work/crystal files so…
  • ROG shows all lines as being received but the PO is in back ordered status. How do I resolve this back ordered PO?

    On a back ordered PO, I need to do a receipt of goods to make the quantity received match the quantity invoice and ordered. However, when I enter a ROG, it shows all lines as being received. How do I resolve this back ordered PO?
  • Sage 100 2018 Customizer question PO Receipt of Goods Date UDF to post thru to IM Cost file

    Sage 100 2018 Customizer question All Inventory items are FIFO Valuation Client wants a Date UDF added to the PO Receipt of Good Lines I added the Date UDF to the PO Receipt of Good grid I need to know the steps on how to get this Date UDF to post thru…
  • Can I apply landed cost during invoice entry? Inbound freight is not known during receipt of goods entry.

    We often order stock items on a PO where the inbound freight amount is TBD or an estimated amount that is only known/determined when we receive the vendor's invoice. From what I can tell, landed freight costs are applied during Receipt of Goods. Since…
  • error 200 sy_service.pvc 465 in Receipt of Goods

    Client began getting this Friday, whether including an invoice number or not, when they get to the Totals tab. Rebuilt ALL PO files. Rebuilt GL_Bank File, since it was mentioned in the INFO on the error. No luck. Anyone know any more detail about this…
  • RECIEPT OF GOODS INVOICE - SAGE 100

    For some reason quite often when i do a receipt of goods invoice a few days later the invoice shows for $0 with lines "0" invoiced. I do multiple invoices in batches and i always make sure that the quantity being invoiced matches what we received and…
  • RECEIVED PO / MISSING INVOICE #

    Hello, Is there a way to show which PO's that have been received in are missing an invoice? We just switched over from Sage 50 and when the warehouse would receive material in, they would check off the box "waiting on bill". That way I could then just…
  • Receiving multiple purchase orders with one receipt

    Hi, I'm trying to figure out why the button to enter multiple purchase orders against one receipt in the receipt of goods is now showing, I've followed the help files and made sure the four fields, dealing with ship via, tax schedule, etc... were…
  • Does a "Waiting on Bill" feature from Sage 50 exist in Sage 100?

    We are migrating from Sage 50 to Sage 100? And in Sage 50 the "Waiting on Bill" feature allows you to get your costs (freight, Inventory, etc...) into payables without having an Invoice number. I have 6 freight Bills (Waiting on Bill-Do not have Invoice…
  • Vendor Alias Item Code & Receipt of Goods

    We stock all kinds of hardware for some of our installation work like bolts, washers, and nuts. While our company standard is to utilize manufacturer specific part numbers, this doesn't make as much sense for truly generic hardware. I might order hardware…
  • Goods Received incorrectly reflected in wrong Warehouse.

    Hi All, I had an issue with my receipt of goods entry... Basically the Goods entered as Received in Warehouse 008 but its balances is reflected in warehouse 001 in Inventory valuation report. What causes this and how do i rectified it?
  • How to use the same UDFs in PO ROG and IM Transaction Entry

    I have nearly 30 UDFs in PO Receipt of Goods Detail file and linked to posting/update files, work files and history files. These are working great. Staff wants these same UDFs to appear in IM Transaction Entry for Receipts for those items without a…
  • Goods receipt referencing this purchase order

    Hi, I searched this question, and found some answers but they were all from several years ago. I want to be sure I'm getting current information, in case anything's changed. My receiver mistakenly created two receipts of goods. Since he hadn't updated…
  • PO Receipt of Goods error

    Has anyone had an issue with a receipt of goods doubling the inventory on hand with correct data posting to PO and GL?
  • How do I add new lots on a receipt for a Purchase Order?

    I have created a new Lot item in Sage 100, and then created a new PO with the new lot item. When I go to add new Lot numbers to the Receipt of Goods Entry, and run day end processing, none of my lot numbers are available to use on Sales Orders / Shipment…
  • Does anyone know what a TranStatus of Incomplete in the tpoReceiverLog table means?

    We have some, less than 100, records in the tpoReceiverLog table that show a status of 1, which vListValidationString says is Incomplete. The RcvrKey 's do not exist in tpoReceiver, so I am suspecting that they are somehow orphaned records in the system…