• JC_JobTransactionDetail table import question

    I'm simply trying to change some comments for some records in the JC_JobTransactionDetail table. The source code for the records I'm trying to change is "PR" and it is set correctly in the import job and in the source file. The cost type is L for…
  • Inventory issue - Lot/FIFO Puzzle

    Good morning, Here's an explanation of a problem from one of our purchasing dept's. I could call Sage support and open a ticket, but wanted to see if this has an alternative quick resolution. We have an issue that I created last year when I did…
  • Receive inventory that has zero cost

    I had a vendor that cleared out their old inventory and sent my company several items that they are not charging us for. How do I enter them at a zero cost?
  • Visual Integrator - Purchase Order Detail - Unit of Measure Conversion Factor

    Recently was working on a large project to change the Standard Unit of Measure for thousands of SKUs in our company. The change necessitated that we change the thousands of open sales orders and purchase orders and work orders that were using these SKUs…
  • Delete/Change - No Action - Item found on a sales order

    Sage 100 2014 Using Delete/Change. Was able to delete a lot of parts that had no transactions. But I also have parts that I need help with. The Delete/Change (post process report) shows some items with this notation: No Action - Item found on a sales…
  • Standard Cost Adjustment Register/Update

    Is there was way to schedule the Standard Cost Adjustment Register/Update to run at a specified time?
  • PO variance to completed status

    I have a PO that was invoiced at less than we received the goods in at. I cannot complete a return of goods as the product has already left as a finished good (zero on hand). How do I process the receipt of invoice in a manner that will allow the purchase…
  • Rebuild sort files - SQL Premium Sage100

    I've 1 client on the Premium version of Sage 100 - some items show a quantity listed under the ON PO column and would like to clear them out. There are no outstanding PO's for these items. In non-SQL Sage 100, a simple Rebuild Sort files would clear those…
  • Change invoice is already paid in A/P module

    Hi all, I have problem to change invoice value if already paid and posted in A/P. =>A/P =>Main =>Invoice Data Entry =>adjust Doesn't work Anyone can help? Thanks
  • Adjusting Deposit Amount in Bank Reconciliation Mod

    FormerMember
    FormerMember
    I recently had to reverse 2 cash receipts but because we close A/R for October and September, I had to reverse them in December. Now they are showing up when I reconcile the bank account. It is throwing off the bank rec report vs. the GL account, but…