Browse By Tags

  • 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…
  • Inventory Unit Activity Report value not correctly

    I use SDK to insert Inventory Adjustment data , the data in Invnetory Adjustment Journal report is correct , but data in Inventory Unit Activity Report is not correct . if using Support Utinities-integrity check , the data in Inventory Unit Activity…
  • Year end adjustments to account payables

    I know there was few topics on similar issue but it seems I didin't find the answer. I received following year end adjustments Account payables Cr 20 000 consulting services Db 20 000 Since I cannot do adjustments to accounts payables without…
  • reversing bank charges from bank reconciliation

    I have posted bank charges in expenses tab in account reconciliation as of Oct 31. After year-end adjustments, my accountant asked me to move it for next year. For some reason this transaction was not showing up to him. How can I move it to November so…
  • AR Invoice Adjustment not reflected in GL

    Hello, I posted an AR invoice to the wrong customer, so I went back in to Invoice Data Entry and adjusted the invoice to 0, using the same miscellaneous item codes. I then posted the invoice to the correct customer. The two GLs involved are only showing…
  • overbillings and fiscal periods

    This is my first year using Sage 100 Contractor (or sage at all). I started with a construction company in March 2021. I recently took a deep dive into how the overbillings and changes to estimated job profits effect each fiscal period. I simply wanted…
  • Tracking external processing item costs Sage 50 Quantum

    Hi, I'm trying to determine what the best way to track the costs of external processes on inventory items? hoping some folks around here could chime in. RM=RAW MATERIAL AS=ASSEMBLY FG=FINISHED GOOD EXAMPLE: 1. 10 x Widgets item number (RMWIDGET1…
  • Inventory items on Purchase Order

    When entering a P.O. for Vendor/Supplier and it is an inventory item, does it remove from Inventory when processing that order? Or does it remove when it has been invoiced. Our current process for inventory stock is done the following ways: -Sales…
  • varying pay periods

    Our normal pay period is bimonthly (24 pay days) One person's payroll does not make sense because some periods, his pay stub is correct (march1-15, then 16-30) but some months, the pay stub is incorrect (april1-15, then 25-31). The bi-monthly salary…
  • Inventory balance to Inventory Unit

    Currently I have a one line GL entered inventory balance, but want to change it from a one line item to units. This is inventory that has not been tracked over the years, but I want to start drawing it down through internal allocations to various jobs…
  • possible, specific 'tutoring'?

    Hi! Does this forum offer names/contact info for possible tutor sessions? Having specific problems not easily addressed, and no 'go to' person in our very small office.... Timeslips 2014, attorney based. Thanks!
  • Unable to fix negative COGS due to adjustments in inventory module ?

    We are a factory using Sage 50 Quantum. We use average cost and quantities were not negative. I managed to set the correct quantities and values of the inventory by using the inventory module, by first resetting the value to 0 in the module and then adding…
  • PO and mfg variance calculations (PPV)

    I'm trying to understand exactly what is in the the PPV amounts (and how calculated) on our Sage income statement so we understand the information reported, if the manual JE's are correct,a and if we need to change our processes. We have two GL accounts…
  • inventory adjustments - quick way?

    I've working on year end inventory adjustments. Is there another way to correct our inventory other than by doing individual inventory adjustments for each item? Is there an option where you can just enter the current inventory amount instead of doing…
  • How to correct duplicate Misc. Cash Receipt entry

    The same Misc. Cash Receipt was entered twice, on different dates. Since it was not payment towards an AR customer account, how do you correct the duplicate entry?
  • Prior Year Adjusting entry

    I need some insight on how to make adjusting entries for expense accounts from 2018 to 2019 that were not claimed for 2018 Taxes. I need to carry forward the amounts I made from receipts and Invoices that were charged and paid for in 2018. For example…
  • Using inventory and build from BOM correctly

    Hi Everyone, I am currently working for a company where they have not been utilizing the inventory module correctly- we are using Sage 50 Quantum Accounting. Currently we have all of our inventory (raw Materials, packaging and FG in Sage. We are only…
  • Serialized item on hand but not available.

    I am trying to assign a serial number that shows it is on hand, but when I try to assign it to the sales order, it is not available? How do I correct this? Sage 100 v.2017 v 5.40.1.0 Any suggestions on how to correct this would be appreciated.
  • Need Help Please...Inventory costing nightmare

    Our year end is March 31 ......and we use average costing of inventory allowing for negative values. I cannot figure out how to fix this, and it's completely messing with my inventory and financial statements. What is creating this variance line? How…
  • paycheck issued in January for wrong amount and needs to be corrected along with CRA amounts

    I work with Sage 50 Canadian Edition 2019.2 I have two paychecks that were posted in January with the wrong amounts. CRA remittance was paid based on these wrong figures. I need to correct in order to reconcile the account and do not know how to post…
  • Adjusting the total of a Paid Bill

    I entered a bill for $3000 and paid it. the vendor called and said the bill was for $5000 and turns out I entered the bill wrong initially. Since the month was still open I changed the bill amount from $3000 to $5000 which created an open balance of…
  • How to append a Lot # when transferring from 1 Whs to another?

    To start off, we are on Sage 100c Advanced v2018.2 How can we append an original Lot # when transferring qty from 1 whs to another? Create PO for Qty = 100,000. ROG the full Qty 100,000 to an offsite warehouse ("OFF") with Lot # 12345. When when…
  • 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.
  • Can't process sales invoice due to cost of inventory items change

    Hi, all: While I modified a sales invoice, this is error message: "The cost of one or more items has changed since you started processing this transaction. If you recently printed this transaction's Detail report, reprint the report to see the effect…