Sage 100

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…

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…

Trying to better understand when to use recurring journal entries vs allocation entries in GL.

I would like to set up Sage so that specific recurring journal entries can be reversed the following month.

Working with Sage 100c Advanced v2019 and need to clean up Purchase Clearing Report where some PO's on report have Misc Charges on them, they go back years. Example: Qty Ordered = 7.00 Qty Received = 0.00 (Can't receive Qty on a Charge) Qty Invoiced…

The situation is a leased piece of equipment with 48 payments of 701.00. However, the first month payment is prorated based in delivery date of the equipment. SO the first month payment is 316.58 calculated as: 701.00/31=22.61, and then 22.61 x 14 days…

Is there a way to give a customer a credit memo without including any inventory items in the "lines" section? One of our salesman price gauged a customer, the customer found out, and now we need to give them a credit to cover the extra price that was…

I have a master order from which we have made several orders and invoices. The problem is that the balance on the master order is wrong. It does not match the quantities deducted on the invoices. It is as if one of our order quantities was deducted twice…

Can I create a Master Sales Order and Invoice/Ship off the Master, like the Master PO? Thanks - Darrin

We are looking for ERP Consultants (Sage 100) at Springfield, MA with one of our clients, please do let me know if anyone is interested and available. You can reach me at 914 502 9535; [email protected] Job Title: ERP Senior Consultant(Sage…

Hello, So the situation seems a bit complex and I am having a hard time figuring it out. Hopefully someone can help. The organization has had Sage for years but only entered invoices and paid through the system. At the fiscal year end the bookkeeper would…

I go to cash receipts entry and I double click. I created a new batch I click accept, then I created a new deposit number I type the total deposit amount and click accept, then I look for the customer number hit tab then I type check# then I type the…

I'm doing a manual bank rec (not using Sage bank rec, but doing it on my own using bank statements plus everything I've entered into Sage.) It's not balancing. I have used the General Ledger Detail report to verify each item entered and everything matches…

In Receipt of Invoice Entry, is there a way to prevent being able to invoice for a larger quantity than has been received on a PO? I know I cannot invoice more than ordered but I have situations where an amount gets invoiced without ever being received…

Hello everyone. We are an E-Commerce Distributor and Furniture Importer located near Chicago IL. We are currently looking for a consultant that can come in, review our Accounting procedures and see if we are utilizing Sage 100 to its fullest potential…

Need help with creating Master Sales orders - Does Sage 100c 2018 upgrade help with Master Sales orders?

I wasn't quite sure what category to place this question in, so I hope this placement is okay. We are utilizing Sage 100 Premium 2016 (Version 5.30.2.0). When processing monthly statements is there any way to do the following? * Verify that the…

We have someone moving to Sage 100 from the old Sage PRO product, using only SO and AR modules (I don't know why but they use QB for AP and GL). The business is completely service based and over 90% of its business starts as repetitive monthly services…

I created two credit memos in the SO module and noted that they should apply to two specific invoices. However, the invoices had already been paid. Now the customer wants to take these credits against a different invoice. When I go to cash receipts entry…

We have a customer in the UK that returned parts on different invoices. We already applied their wire and the invoices have a zero balance. I wired the refund to them, but I don't know how to book the entry. I need to offset cash. The parts were not…

Does anyone have any input on a way to track and manage rental fleet equipment within sage 100 ER\P version 5.30.2.0, we looked into ARM and it upwards of $30,000.00 just curious if any current customers have any suggestions on how to currently do this…

Hello, We have certified payroll every week - in addition to regular payroll processing. When we print certified payroll checks - the checks print with regular pay rates - not the certified pay rates. How do I get the check to display the…

Working with a contractor(AR) that is issuing joint checks to our Sub/Suppliers (AP). Have entered inventory through the PO module (Ordered, Received, and Invoiced), and now has flowed into AP. Have entered Revenue Receivable through the JC module…

We recently started charging a finance charge to one customer. I noticed however, that the amount of the charge is not showing up in any GL account. I went into Division Maintenance and the account listed for the FC is correct. I also double checked that…

What is the easiest way to apply security deposit (asset account) to my utility expenses? as you know, some utility company's require security deposits upon set up, after a year in good standing they start to refund your security deposit. I'm at that…