• VI Job for Inventory Adjustments

    Hi there, I hope you can help me. I created a job to import data for a positive inventory adjustment, and I need to specify the unit cost. We are using Scanforce multi-bin software, so we also need to specify the bin and lot. The issue is that the job…
  • RETURN AND ALLOCATIONS

    I don't work in shipping but I had a shipping question brought up to me. We have a customer that placed a rather large order. They notified us that they made a mistake and ordered too much of one item. To avoid a ton of work, I did a return of just the…
  • 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…
  • Duplicated Invoices

    hi, I'm working with v 2021 Premium. we've had issues with CI_140MB_UpdateDetailToIM.pvc. SO invoice batch posting was interrupted resulting in multiple HeaderSeq numbers being created once posting was refreshed - invoices were duplicated. Looks like…
  • Physical Count Situation

    Hey All, I saw this post https://www.sagecity.com/us/sage100_erp/f/sage-100-distribution-manufacturing-and-internet-modules/94349/you-cannot-proceed-with-unposted-data-in-physical-count-entry , but I want to elaborate a bit to see if I can find the…
  • ZERO COST WAREHOUSE?

    USING SAGE 100 ADVANCED 2021. Is there a way to create a warehouse that does not apply any unit cost to an item? we want this new warehouse code to hold items that will eventually be replaced by the factory. so if we receive a container full of…
  • AR credit that needs to be paid out

    I have a customer that has a large credit on their account. They haven't been ordering very much, so they want me to pay out the credit. How do I cut a check for an AR Credit Memo? We are using Sage 2015.
  • Moving an overpayment from one customer to another

    I have a customer that has about 10 different divisions in different states. I received a few checks today , and while applying payments i accidentally over received in one account. So now that account shows -$239.40 , however i need that to be transferred…
  • Applying overpayment to progress billing

    A Client overpaid and was asked to apply the overpayment on another job, done easy peasy. How do I apply an overpayment on a progress billing without having to adjust the original contract amount to get a $0.00 balance on contract result?
  • A/R Invoices

    I have a dilemma with a client. Company has an a/r account with many outstanding invoices that have been "donated" to a particular client. However, the salesperson has done the donation and the owner has offset all of these "sales" by deducting them from…
  • How do you record a merchant account chargeback?

    I tried searching for answers to this issue, but was surprised to find that nothing addressed this not uncommon issue. We had a customer that was invoiced for a purchase and paid with a credit card. It turns out it was a fraudulent credit card. Recently…
  • Sales Tax adjustment when a customer takes a discount

    We have a customer who takes a 2% discount on their invoice regardless of when it is paid. How should we adjust for the reduced amount of sales tax? The payment is usually made in a different period than the original invoice month. We've already paid…
  • Purchase order and invoice price discrepancy

    How does one correct an item received at the wrong price and billed at a cheaper price? The item cannot be returned as it has been used from inventory. Example: Item 1234 received at 1.80 ea, but billed at 1.65 ea.
  • Work Order Adjustments

    FormerMember
    FormerMember
    In Sage 100c Advanced 2016, Updated a completion step of Work Order. Some items posted to scrap with all the cost and some items posted to inventory with no cost. Somehow the cost was all posted to scrap. Now if we complete other steps in the Work Order…
  • 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…
  • Returned Check

    I should know this but I can't figure it out. On 4/26 we received a check for an receivable invoice. We deposited the check on 4/26. On 5/1 the check was debited from our bank account as the check was returned. I'm not seeing how to reverse the paid invoice…
  • Inventory receiving issues

    We have two companies that buy and sell from each other. We use purchase orders and invoices to move inventory between the two companies. I accidently received a PO and paid the invoice to the second company. But, we never received any product from…
  • Reversing an Invoice

    Is there an easy way to populate the lines of a Credit Memo in order to reverse a wrongly posted invoice? We had some large invoices that were wrong so we want to back them out but it's very time consuming on these large ones. Thanks!
  • How do I clear out +/- 0.01 amounts in A/R and A/P?

    I have some customers & vendors that show +0.01 and others that show -0.01. How do I clear these out?
  • Acct Rec

    Using MAS 100 - A/R module * I have a few customers with no current invoices that have lingering credits that I need to clear up. How can I clean the credits off their accounts? Any help will be appreciated.
  • How do I adjust inventory valuation for a certain item?

    We have the module Bill of materials, we typically receive an order from a customer for an item (Program) that has to be built. We create an invoice for that item (Program) and in a few days when we have enough orders to build the item (Program) it will…
  • Check was unused by vendor but all invoices paid

    I recently took three checks to our local tax office to get registration on vehicles (five vehicles on each check). I got the registration costs from the tax office website. However, I was told that I had overpaid by over $500 dollars. Instead of giving…
  • Fixing Average Cost

    If I do not currently have any inventory for an item, do I need to wait until I do have inventory to fix? Found this on another topic: Typically, the only way to fix the average costs is to do an IM transaction entry to 0 out the quantity on hand…