• Imported Lines flagged Drop Ship Need a PO Created?

    Trying to think out this situation before attempting to script it out. We have orders being imported into Sage 100, some lines are "drop ship" if they are from this one certain vendor. When the customer orders from this vendor a PO is generated on the…
  • Sage 100 Warehouse Inventory prevent from going negative

    Hello, Is there any way to disallow negative balances for items in warehouses in Sage 100? We currently use FIFO valuation, just looking for a way to prevent transactions that send an item in a warehouse into negative balance. SAGE 2020 Warehouse…
  • Add Sales Order Lines in Shipping Data Entry

    I would like the ability to add new SO lines in Shipping Data Entry. Reviewing SO Options, Shipping Setup Options, and Shipper ID Maintenance, I don't see a setting that would allow that. Am I missing something or is there some other way to do it? I…
  • Why does my *item in sales order not show on my picking sheets for shipping to "ship"

    Trying to figure out why " *item" line items show at time shipping is picking the order in one Company, but not in a different company. I feel like something is not turned on in the company.
  • Inventory Item Stuck with Quantity 'In Shipping' When None are There

    We have an item that is showing with a quantity of 4 "in shipping" which we can not clear or zero out. There are no open sales orders for that item currently. Also there are no invoices for that item which have not posted. I have checked in the AR module…
  • Void credit card authorization on sales order

    Several versions ago we were able to void a credit card authorization on a sales order but haven't been able to get it to work on Sage100cloud Advanced 2019 Version 6.10.2.0. We are using Paya. I have confirmed that the Library Master, Security settings…
  • I pay and invoice but it still show open

    Hello, Yesterday I pay and invoice I did the check but still showing open in the vendor's file. can someone help me to see how to correct that. I did check the daily transaction registry and is empty, when i try to applied it again it say that is…
  • Incorrect cost on closed work order

    We created a work order for a part number and accidentally put the unit cost in as $1,486.4667 instead of $14.8429. The work order is closed and inventory is overstated. Help!
  • FIFO Item valuation and PM Work Ticket closing method of Standard variance suggestions?

    SAGE 100c 2021.2 Advanced Production Management Work Ticket Close Does anyone use FIFO valuation on Items and close work tickets using standard close method? Our standard cost in Item Maintenance is slightly higher than Actual build cost and the…
  • 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…
  • Automatically print backorder pick tickets?

    With raw materials and shortages we have found that we are shipping more shipments leaving a backorder in our system than ever before. Historically, shipping would go in and print a new ticket with the backorder and keep it until it could be filled. Our…
  • Shipping data entry sending items in multiple packages with packing list for each package

    We have a client who has a customer who wants a packing list for the items that are in each box shipped for the order and not the whole order on the packing list. Does anyone have a similar issue?
  • Sales kit cost on invoices

    I am using Sage 100 and invoicing in the Sales Order module. When I use a kit, no cost shows up, not on the invoice screen or when I print the invoice. However, if I act like I am going to post the batch (but don't actually post/update it) and go back…
  • serialized items are showing as available but they have been invoiced

    We are showing a serialized item on hand and available, but it was sold in November 2021. History shows the item was received and sold, with no further movement on this serial number It's still showing on the Inventory Valuation Report - item in…
  • Lines added to a purchase order that shouldn't be there

    A client entered a purchase order, printed it and sent it to the vendor. They went back to Purchase Order Entry, and three items were automatically added to the order mysteriously. It appears that items from another order are showing up on this order…
  • 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…
  • Subcontractor inventory

    Can you send me step by step instructions as to how to receive inventory that is partially assembled outside of the factory and brought in house to be completed to a finished product?
  • SO Shipping Batch No. missing on Invoice

    Occasionally we get an Invoice that is missing the Batch No. from when it was created via Shipping Data Entry. We have multiple batches a day, usually separated out between EDI and Non-EDI orders and/or AM vs. PM shipments; totally anywhere between 2…
  • Sage 2020 Negative Issue of Materials

    Hi, In Sage 2018 and WOScan we could negative issue an item and create a new unique Lot or Serial Number on the fly. In Sage 2020 and MFG100, MFG100 will accept the scan, but Sage rejects the import because the number Lot/SN doesn't already exist…
  • Work Order Auto Completed Not Allocating Materials (Sometimes)

    In the Work Order module for one of our companies, we have the settings set to: Work Order Issue Method: Backflush Auto Generate Material Transactions: Yes Auto Generate Labor Transactions: Yes This has been working, but every now and then we get this…
  • Shipping List ALE is blank...

    Has anyone seen a broken Shipping List lookup (flashlight list to show previously created entries in the batch)? There is no customized ALE. Customer has enhancements (PM, ScanForce...). ShipperID has full permissions, and so does my Sage login. We…
  • Work Order - Backflush Question

    In Work Orders, is it normal when Issue Method = Backflush Auto-Material = Yes To get the following message when issuing a completion transaction: I understand the message, but we don't get this every time. I presume there is a step I am missing, or simply…
  • PO: Auto Reorder Selection treated like a register (Role permission related to Print vs Preview)

    Why is Auto Reorder Selection covered by this Role permission? It most certainly is not a "register", since no $ or inventory is moved. It's just a way to create POs. We recommend users never have the permission to post from Preview (which is the…
  • Item Valuation Change errors

    Hi All, I'm running Sage 100 Standard 2019 v6.10. I'm trying to change a range of inventory items from Average to FIFO. When I get to the stage where you update the register, I get an error saying "A not-on-file warehouse code was found." Any suggestions…
  • The directory in P/L Journal and Register Maintenance is invalid or is not accessible from this workstation. error

    I'm trying to update SO batches today and all of a sudden I'm getting The directory in P/L Journal and Register Maintenance is invalid or is not accessible from this workstation. I've tried different modules S/O, I/M, A/P and different workstations and…