• 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…
  • 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…
  • Sales Order boi c# , doesn't register the order

    I've been using c# to insert customers, now I'm trying to insert an order, I don't get any error but it don't find the order, I reasearched needed values but maybe I'm missing something int TaskID = (int)oSS.InvokeMethod("nLookupTask", "SO_SalesOrder_ui…
  • WE WANT TO PRINT/EXPORT TRANSACTION DETAIL FROM ACCOUNT MGMT/INQUIRY

    FormerMember
    FormerMember
    We've always wished that we could export or print the transaction detail that we see under the Transaction tab in G/L Account Maintenance and Account Inquiry. Yet that's not possible. What's most frustrating is that a Print button is staring you in the…
  • Deleted SO Shipping Data Entry showing up in SO Invoice Data Entry with 0 cost

    Currently, we're on Sage 100C 2017 v 5.4, this was a recent upgrade from v 4.9 last September. One of our user is noticing that deleted orders in the SO Shipping Data Entry batch is showing up in the SO Invoice Data Entry batch that is billing to the…
  • Tablets for Inventory Control

    We have been trying to find the right tablets for warehouse to use with Sage 100c on updating inventory qty's and bin locations. I thought I would send out a post and get some suggestions on what's working or not working for anyone else that has tablets…
  • Unable to read line level data

    Hello I am trying to read data from SO_SalesOrderDetial i tried setting key value to read data for a given sales order i am able to get data using GetResultSet but i am not able to read values like price , ordered etc and when i am trying to use…
  • Unable to edit order line and tax amount

    Hello I am trying to edit a existing sales order using BOI,... i am able to make header level changes but when i am trying to change line level data ( ie: item code) a new line is getting created.... And when i am trying to add a new line and over…
  • General ledger export from a payroll processing company

    We need to outsource our payroll now because the Sage payroll module can not handle negative checks. The payroll companies say that they will build a general ledger export to bring in the payroll information to Sage100c. Do I need another software package…
  • Daily Transaction journal update out of Balance

    I updated our Daily Transaction Register yesterday and it showed me and Out of Balance amount in the Totals Section. Is there a short cut to find the Out of Balance Invoice? I had to comb throw 100 invoices, adding each line item and total to find which…
  • Fictitious Invoices across all open batches

    Every now and then one of my locations has their internet drop when one of the stations is writing a sales order. When we log back in, the invoice gets distributed to all open batches across the company, and cannot be deleted or changed. It will not update…
  • SO invoice entry creating random backorders

    Our invoice clerk report 3 times that she had back orders on invoice she had entered last week. We don't do backorders in our business so this is very unusual. The Backorder column is not on the SO Invoice Data Entry form. The system seems to grab the…
  • AP Invoice Register updated in wrong month but caught before GL posting

    Hello Sage Community, We have a situation where an AP Invoice Register for entire batch was updated in the wrong period, but the date error was caught before the Daily Transaction Register was updated. Is there a clean method to correct the AP module…
  • So Order NOT copying Customer PO number

    Hi, We recently upgraded a client from v4.4 to v5.3. In Sales Order Entry -> Copy From -> Invoice History, "Cust PO" field data doesn't get copied over. They used to be able to this. Please help.
  • Commission edit register update and a salesperson link didn't update. What do I do?

    All the amounts were correct and when I printed and updated the commission register I saw 1 salesperson whose vendor link was not updated. Will is transfer to AP ? How can I correct this? I manually updated his link in salesperson maintenance, but how…
  • SO Invoice Data entry

    Hi guys, I'm trying to clean up our inventory a bit, but I'm having trouble with the Delete and Change Items task. What is basically happening is every time I try to enter the task, an error message pops up saying "You cannot proceed with unposted…
  • What is the best practice for entering monies received for things i.e. rents (parking) and rebates from vendors that are in the form of a check?

    Would it be to create a cash invoice in the receivables module and apply it to the best fitting G/L account? Is there a better way to enter receipts of intangibles for parking rent monies and rebate checks from vendors. As of now I am creating a cash…
  • Reverse Journal Entry

    How do I reverse a journal entry? I am using Sage 100 2015.
  • How assign to my sales a General Ledger Account

    Hello, I appreciated your help. currently I do have two branches and both are under my accounting in sage 100 v 5.0.0.8 I am adding a new branch but all the sales are currently going in to my local branch an existing branch. how can I assign a specific…
  • issue with my computer and it messed up something

    I was in the middle of entering the credit card and something went wrong with my computer and it crashed. By the time I restarted and got back in I saw the batch that I was entering was still there but it was at zero dollars. I started the process of…
  • Quantity Checking - Set default to backorder

    I've searched for an answer to this on the forum so forgive me if this has been posted. I was surprised not to find a posting on it. So I'm wondering if I've missed an obvious way to do this or I've just not found the posting somewhere. when entering…
  • Can you reopen a prior period?

    I need to add some things I forgot...
  • General Ledger account when one updated

    Hello I need a help, when I received an invoice in the Purchase Module sometimes there is a Variance, this particular variance goes into my purchase clearing account and trough off my purchase clearing account (I am using SAGE 100 V 5.008.00) how…
  • AUTOMATING ORDER RELEASE ERP100

    We are looking to automate our order releases through batch printing at timed intervals in the near future. Currently, we use a signal in the comments of an order when an order is READY TO PRINT (RTP) so that our finance team can review the customer account…
  • Purchases Clearance Accounting Question

    Currently we are on Sage 100 2014. We have finished product that is assembled from homeworkers and received/entered via Inventory Adjustment / Receipts. In this entry we calculate the cost of the item based on the raw materials and the labor to assemble…