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…
  • Accounts Payable

    I am looking for a work around to void a check in my current accounting period, that pays something in a previous closed accounting period so far back the accounting period can not be opened. What is my JE or work around to void check or to reinstate…
  • 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…
  • Adjust a BOM during a transaction

    Is there a way to adjust a BOM during a transaction. My client has a BOM that can use substitute materials. We are creating versions of the BOM for normal customizations, like using 50% of one material and 50% of the other, but they can make many versions…
  • Sage 300 doesn't allow removing posted AR Documents

    Hello Team, I cannot remove posted documents in Sage 300. Could you clarify how I can remove posted documents?
  • Cannot find adjustments among posted documents

    Hello Team, In Sage 300, I created the adjustment and allocated it to the invoice. Then, I posted the adjustment. But, I cannot find adjustment by Adjustment Number on the Document Injury page. Also, endpoint ARPostedReceipts doesn't return this adjustment…
  • Refund payments

    Team, Could you help me with the following question. In Sage 300 the user can create a Refund payment. Thus, I can create an Income payment (receipt) and then refund it using refund payment. What type of documents should this payment be attributed to…
  • Example of the request for the method - ARPostReceiptsAndAdjustments

    Hello Team, Could you please provide an example of the request for the following method ARPostReceiptsAndAdjustments ? I found the following article https://www.sagecity.com/support_communities/sage300_erp/f/sage-300-general-discussion/156859/help---using…
  • 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…
  • Importing Inventory counts

    Hi, I am new to my company and am wanting to import our year-end inventory counts back into Sage instead of having them manually keyed in. I was able to export and import the 2 workbooks, but after importing I am not sure what steps need to be taken…
  • 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!
  • SAGE 300 2019 ERROR the field [bkenth].[totfuncamt] contains more decimals than the currency code [AED/INR etc] allows

    While Applying a Prepayment to AP Invoices or Reversing any Payment entry/ Bank Deposits the system is giving this error. The Decimal points are already 2 in the currency master. while creating new transactions it is accepting but while applying it or…
  • A/P Invoice Distribution (Coding) Change

    Hi, I would like to correct a previously entered invoice. The coding of the invoice is incorrect however I don't want to actually reverse the cheque, I just want to change the coding. Normally, I would do a JE to correct it however I would like to follow…
  • Vendor Prepayment Refund

    Dear All, Could you please help me on query. I have made an prepayment to one of our vendor in Feb 19. and It has been reconciled. Due to some reason, The vendor has refunded the whole amount in March. Since, there is no refund option, How should…
  • SAGE 300 CUSTOMER NUMBER CHANGE ERROR

    HI, I have used customer code change. Most of the codes have been changed succesfully. However I have gotten this error on some customers. Any help will be highly aprecciated A/R Customers: 3C0002 to 7C0001, Critical Error: [54353] unknown error…
  • Changing Stocking Unit of Measure

    Is there anything we should look out for when we change the stocking unit of measure? We some items that have a couple of conversion factors and the items are used in BOMs. To be careful should I issue out all the inventory, change the stocking unit…
  • 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…
  • Valuation Variances

    Hello I was recently tasked with solving a valuation variance issue at work. I did some digging and it is caused by the price not being accurate on the purchase order due to the purchasing dept. not having the manpower to reach out for quotes. They then…
  • SAGE 300 SHIPMENT REVERSALS IN ORDER ENTRY MODULE

    Hi Guys, Is there a way of reversing a shipment that was done for wrong quoted items before the invoicing? The client does not want to create an invoice and then raise a credit not due to challenges with the tax man. Any help will 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…