• BOI script to update the Sales Journal

    Hi Forum, I am automating Sales Order Invoices import from an external source. I got that working (we are in test mode), now i am trying to write a script to Update the Sales Journal via script. Has anybody done something like this?.. i cannot find…
  • HOW TO DELETE A JOURNAL ENTRY BATCH

    I inadvertently created 2 journal entry batches for the daily upload. How do I delete them?
  • Work Ticket By Product - What cost does it go into inventory at?

    Some of my work ticket's create a by product item that goes into stock. We have been doing a line on the work ticket materials tab for -1 Part Number to remove it from the work ticket and return it to inventory. How to do we control what value it pulls…
  • How to deal with Vendor Credits on Prepaid Purchase Orders

    We regularly import products from overseas and prepay 100% of those purchase orders. Sometimes we end up changing items, leaving us with a credit with that vendor. They typically apply it as a credit on future purchase orders. What is the best practice…
  • Customer Fines/Fees

    When receiving a customer payment in which the customer takes a deduction for a fine/penalty, we create a debit memo. My question is do you book that debit memo in a cogs account or back to the AR account until it is credited? Thank you.
  • SO_SalesJournal_upd - 'The register must be printed prior to posting'

    So my trials with this update object continue. I have a console application that simply prints to paperless/updates the SO Sales Journal for any and all SO Invoice batches available. Program works fine when running it manually - prints all necessary reports…
  • Wish List

    FormerMember
    FormerMember
    Do I need to register again to submit suggestions for Sage 100? It didn't like my current Sage City credentials.
  • SO_SalesJournal_upd print additional reports/recaps

    So this is a follow up to a recent post of mine ( https://www.sagecity.com/support_communities/sage100_erp/f/sage-100-business-object-interface/168323/so_salesjournal_upd-batch-selection ), but wanted to start a separate thread for the other questions…
  • Stu:Post-Completion OPT and resident alien status

    Good day: We have a Resident alien employee who is Stu:Post-Completion OPT. Although he is set up as a resident alien, I do not see where he can be set up with an F1 status. He is exempt for Medicare and SS but those liabilities are still being deducted…
  • SO_SalesJournal_upd Batch Selection

    Anyone know if its possible to simulate the 'select all batches' UI functionality when selecting batches to post via BOI? I'd like to select multiple batches rather than iterating through all open SO Invoice batches and updating them individually. Thanks…
  • payroll

    I did something wrong when i started payroll this morning and created a default check number. It is in all my newly created records. I do not know what I did or how to correct it. tks
  • Script to import AP Invoices with multiple lines

    Hi Forum, I have a BOI script to import AP Invoices. All works fine, except the invoices with multiple lines. I add the total and matches the total of the invoice but i get the message "Out of Balance". I couldn't find anything related to my issue…
  • Bank Recon Sage Feeds

    Any recommendation on how to fix the setup for bank feeds with Bank Reconciliation module. "Error coming is Sage Bank feeds is not available at this time and cannot process your request. Please try again later. " Tried turning off firewall same issue…
  • AR credit that needs to be paid out

    I have a customer that has a large credit on their account. They haven't been ordering very much, so they want me to pay out the credit. How do I cut a check for an AR Credit Memo? We are using Sage 2015.
  • Adjusting invoices

    I am new to adjusting the GL#'s for an invoice and so I actually duplicated an invoice when I went in to change the GL#. I did figure out that you DON'T enter the amount of the invoice when your are adjusting a GL#. but how do I get rid of the extra…
  • Closing out for the year 2020, are there any updates that need to be done prior to me closing the year and printing W2s and 1099s?

    I am on Sage 100 Version 2019 V.6.10.2.0 Payroll 2.20.2.0 and will be closing out for the year 2020 on Monday, are there any updates that need to be done prior to me closing the year and printing W2s and 1099s? Thanks!
  • PostWrite script adding a line interferes with exploding kits

    We have an SO line PostWrite script that conditionally adds lines (a service charge, special discount...) which has been working great for years. Now the customer wants to set up exploding kits... which work great, except for lines that qualify for…
  • Search Invoices by Check Number

    Is there a way in Sage 100 where you can search a check number to find which invoices that specific check was applied to? Example scenario- a customer receives a statement and claims that they paid off certain invoices with a previous check that has…
  • General Ledger Exchange not importing amounts

    I set up a new General Ledger Exchange (GLE) import in a new sage company. I mirrored the GLE on another Sage company set-up. The file appears to run correctly except it doesn't include any amounts. It just includes the Journal, date, sequence number…
  • Balances showing in Cash Receipts but not showing on Accounts Receivables

    Accounting has brought to my attention that we have several balances that seem to be hung up on Cash Receipts but are not showing up on the Customers Accounts Receivables Aged Invoice Report. They believe this has happened when only trying to apply part…
  • Invoices

    If I have an invoice that was invoiced to the wrong customer are we able to credit that invoice and charge the correct customer after it has been invoiced or do we have to credit the wrong account and make a new order to invoice?
  • EDIT SO INVOICE AFTER "BATCH IS CLOSED"

    Hello , We are new to using Sage 100 and have a few questions . After our sales people process a sales order we then go into Shipping data entry and then print the invoice. At the end of the day , we then update the register. My question is , how…
  • Orders

    Is there a way in SAGE 100 to delete a sales order or line item(s) off an order, be able to make notes of what was deleted or whom ask for it to be deleted and still have a record of it without creating an invoice for it?
  • Upload budget for 2021 and I have not done this before Sage 100

    I have to upload Budget 2021 I did not how to upload my CSV file ?
  • Creating a batch in AR invoice data entry

    Hi Forum, I am having an issue creating a batch, or that's is what i think. the code below is throwing a message. InvoiceNo = "" : BatchNo = "" IF oBatch.nBatchEnabled = 1 Then retVal = oBatch.nSelectBatch(BatchNo) msgBox "retVal: " & retVal…