• AR integration to GL not bringing across functional values

    Hi Just wondering if there is a known issue with the posting of AR invoice batches to the GL when multicurrency is in use. All of a sudden, starting Mid Feb 2023, the functional values are not posting to income accounts and all income is going to the…
  • 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 …
  • Reconciling Shipment Clearing & Payable Clearing Accounts

    Hi, I want to know, what is the best way to reconcile shipment clearing account and payable clearing account ? is there an easy way to make it zero at the end of the reporting date. Thank you
  • Sage 300 AR Credit Card Receipt - can't post

    I have an AR receipt entry with a cc charge that has been settled but the receipt entry will not post. The charge was applied to two invoices. Before the batch was posted, another entry was made to those two invoices with a credit note applied to them…
  • How to populate GL Journal Entry - CUSTVEND column

    Hi all, On the GL Journal Entry screen, entry number finder, there are Customer / Vendor Number and Customer / Vendor Name column, which is related to GLJEH table, CUSTVEND column. I check on it and found that there is no value in this column. I would…
  • Sage 300 Web API - ICDayEndProcessing

    Hi All, I am developing a website that will use Sage 300 Web API to integrate with Sage 300 data. Currently, I would like to run the IC day end processing in my development, but I am confuse on the payload. Does someone have a sample or tutorial…
  • Customs Duties - How do we add them as additional costs with different rates for different items.

    Hi all. With American tariffs changing a lot recently, and therefore being volatile and different between types of products, we are looking for a way to add customs duties as additional costs based on each of the individual duty/tariff rates for each…
  • Mismatch between I/C quantity and Lot/Serial quantity of an item

    How to fix mismatch between I/C quantity and Lot/Serial quantity of an item if there is a variance on the I/C Serial/Lot Number Quantity on Hand Report? Below is an example in our sample data for this item, A1-405/0 at location 1. As you can see the…
  • Anyone using Sage 300 V.2016 to do Budgeting ?

    Hi all, My company hasn't been using Sage 300 (V.2016) to do budgets. Its typically been done in excel. I know it can be done, (use sage to budget) but don't know where to start or what reports i can print. Are there any courses just for the budgeting…
  • Help with New Payroll Code

    Is it possible to have a payroll code that will allow me to enter a 'day rate' i.e. $160.00 per day but also keep track of insurable hours? So on the timecard, I want to enter 5 days work, it will come up with the day rate of $160.00 and multiply it by…