Browse By Tags

  • Sage 300 - sql query for recalculating AP Balances - reconciling to GL

    Hi, I am trying to determine why my GL and AP control accounts dont balance. Yes, I know I can isolate GL only transactions from my control account, but I would like to build a more robust answer. To this end, I would like to build a query in sql…
  • Entry Batch is Full

    FormerMember
    FormerMember
    We came across and incident where we were printing out checks and then received an error stating that the Entry Batch is full. She went in and posted the checks that she had then tried closing out and re-entering the function but continues to receive…
  • Update Inventory Worksheet via SDK

    Hi Guys, I am having an issue while updating Inventory Counts in SAGE300. I have created the Macro but it actually does not update the Quantity Counted in I/C Physical Inventory Quantities. Has someone successfully updated /C Physical Inventory…
  • Vendor Price Lists

    Hello, Is there a way to import Vendor Price lists from excel so that the prices are updated for existing products and so that new products are added into inventory? Thanks, Dave