• Recalculate Cost Inventory Control Item

    When we are using costing item on Inventory Control module, Day End Process or During Posting. Then we have Audit result and doing Adjustment backdate, ex. current period Nov 2023 (many issued/internal usages Item from Jan to Oct), we input IC Adjustment…
  • How to reverse an AR Refund Entry that do not have Bank Code?

    Hi All, I posted an AR Refund Entry that is using Cash Payment, No Bank Code, use Cash Account instead. It does not have a Bank Code so I cannot use the Reverse Transaction from Bank Transaction. Any other way to reverse this refund? Thank …
  • How to adjust EI and CPP earnings on Sage 300

    Does anyone know how to adjust EI insurable and CPP pensionable earnings for T4s on Sage 300?
  • Disabling "Clear History" in G/L Periodic Processing for certain users

    Hi have been trying to figure out how I can disable "Clear History" for certain Users.) (last item in screengrab) Tried unticking "Period End Maintenance" and "History/Budget Maintenance" - both did not work. ( please see list of options for GL ) …
  • 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…
  • 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…
  • 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…
  • 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…
  • 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…
  • Issue sending AP/AR Adjustments using SAGE300WebAPI calls ARReceiptAndAdjustmentBatches/APPaymentAndAdjustmentBatches

    I'm sending adjustments to Sage 300 ERP Server for 'posted' invoices and I know that the transaction are successful because the webapi call returns a reponse code is 201 and the response message contains the information I sent but when I open the adjustment…
  • Set up loans receivable in subsidiary ledger

    Hello, How do we set up loans receivable in subsidiary ledger? I cant find the option to release cash and set up a receivable(should be in AR aging) at the same time. Thank you!
  • Serialization implementation - Sage 300 v2017 I/C (Help!)

    We just started using serialization and we have a few items in inventory (received before the item had the serial number flag turned on) that we wanted to record serial numbers for when we shipped. So I went into Serial / Lot Reconciliation and added…
  • Adding a cost to a Sales Order

    We use different online marketplaces and they charge a commission/fee to us for selling products through their website. How can I build this into Order Entry, such that the commission/fee is included in the cost of order/item. Ex. debit inv/cogs, credit…
  • How to reverse a credit note ( Type: Return ) in Purchase Order (Posted to GL)

    How to reverse a credit note ( Type: Return ) in Purchase Order (Posted to GL) .Since the credit note entered a wrong date , i want to adjust the record , What can i do ? is it open a Debit note to recover it?
  • Adjust Purchase Order after receipt completed

    How to adjust the Purchase Order after receipt completed? since the item have receipted more than the org. order, i want to adjust the PO for matching the receipt. thanks
  • Flag old quotes as "Completed" for each line item

    FormerMember
    FormerMember
    Is there a way to set each line item in a quote as "completed"? I can do this with regular orders by zeroing out the quantities and then double clicking on "Completed" to change from "No" to "Yes". The reason for doing this is to keep the original record…