• Posting Date Guidelines

    Hello! - Wondering if anyone has a simple and easy guide already prepared that could be used as mass communication regarding when and what needs to occur in the same month when reviewing before posting an entry. We have had document dates not matched…
  • Change labor cost to non-billable labor

    New to Sage, and learning. So I have been asked to close Job work order's that we did not billed the customer. But in payroll (5-2-2 payroll records) I see that the labor cost was charged to the job. How do I change that? I have been asked to change…
  • Adding Posting Periods

    Help, I'm a newbie! Where/How do I add Posting Periods? I think if someone can direct me to it, I hopefully can figure it out or feel free to give helpful hints. I don't know what category/subcategory to use...sorry. Thanx!!!!
  • Post Dating Accounts Payable Check to a future date

    We would like to print checks on the 30th but have them posted to the 1st of the next month, can we do this and have it posted in the next month as well? If we can, how would we do this? We want to do this because the rent invoices are for July but…
  • AP Invoice Batch Posting Issue

    BOI-Experts, We are running into an interesting phenomenon. A BOI script creates AP and PO invoices in multiple companies, and then posts the AP and PO batches company by company. A lot of times that works just fine. Every now and then the invoices…
  • Extension Amount on System-Generated, Partially Shipped Backorder Lines, is Incorrectly calculated on Order Qty not Backorder Qty

    Most but not all Backorder lines are incorrectly calculated based on the Order Qty but should be Backorder Qty. As a test, I copied the Live company into a test company at the end of our shipping day just before running Daily Sales Reports and Updates…
  • Posting One Journal at a time...

    I've uploaded multiple Journal Entries from the VI. How can I post only 1 at a time? (in the example below, I am ready to post GJ-000005, but not GJ-000004 just yet) Will Sage 100 post whatever is in the queue even though the JE contains zero or has been…
  • AR Invoice with negative balance

    I have an invoice that shows to have a balance of $5,382.38. When I try to apply the payment in the cash receipts function, the balance shows as -$10. I don't get it. How can I fix this? I don't see any credit memos.
  • When two people are posting simultaneously, our reports sometimes get swapped

    I've run into this issue occasionally for at least the last couple of years. Say, for example, that I'm posting a batch of Invoices in Accounts Payable while my coworker is posting a batch of Cash Receipts Entries in Accounts Receivable. I post my batch…
  • Cancelling Payment Batch

    FormerMember
    FormerMember
    I created an EFT payment batch, posted it and now want to cancel it. The open batch is still in the G/L. I'm wondering if I can just delete the batch in the G/L? What are the implications because I technically paid it, but didnt' actually send the funds…
  • Unable to read line level data

    Hello I am trying to read data from SO_SalesOrderDetial i tried setting key value to read data for a given sales order i am able to get data using GetResultSet but i am not able to read values like price , ordered etc and when i am trying to use…
  • Unable to edit order line and tax amount

    Hello I am trying to edit a existing sales order using BOI,... i am able to make header level changes but when i am trying to change line level data ( ie: item code) a new line is getting created.... And when i am trying to add a new line and over…
  • General ledger export from a payroll processing company

    We need to outsource our payroll now because the Sage payroll module can not handle negative checks. The payroll companies say that they will build a general ledger export to bring in the payroll information to Sage100c. Do I need another software package…
  • Daily Transaction journal update out of Balance

    I updated our Daily Transaction Register yesterday and it showed me and Out of Balance amount in the Totals Section. Is there a short cut to find the Out of Balance Invoice? I had to comb throw 100 invoices, adding each line item and total to find which…
  • SO invoice entry creating random backorders

    Our invoice clerk report 3 times that she had back orders on invoice she had entered last week. We don't do backorders in our business so this is very unusual. The Backorder column is not on the SO Invoice Data Entry form. The system seems to grab the…
  • AP Invoice Register updated in wrong month but caught before GL posting

    Hello Sage Community, We have a situation where an AP Invoice Register for entire batch was updated in the wrong period, but the date error was caught before the Daily Transaction Register was updated. Is there a clean method to correct the AP module…
  • So Order NOT copying Customer PO number

    Hi, We recently upgraded a client from v4.4 to v5.3. In Sales Order Entry -> Copy From -> Invoice History, "Cust PO" field data doesn't get copied over. They used to be able to this. Please help.
  • Commission edit register update and a salesperson link didn't update. What do I do?

    All the amounts were correct and when I printed and updated the commission register I saw 1 salesperson whose vendor link was not updated. Will is transfer to AP ? How can I correct this? I manually updated his link in salesperson maintenance, but how…
  • What is the best practice for entering monies received for things i.e. rents (parking) and rebates from vendors that are in the form of a check?

    Would it be to create a cash invoice in the receivables module and apply it to the best fitting G/L account? Is there a better way to enter receipts of intangibles for parking rent monies and rebate checks from vendors. As of now I am creating a cash…
  • How assign to my sales a General Ledger Account

    Hello, I appreciated your help. currently I do have two branches and both are under my accounting in sage 100 v 5.0.0.8 I am adding a new branch but all the sales are currently going in to my local branch an existing branch. how can I assign a specific…
  • Quantity Checking - Set default to backorder

    I've searched for an answer to this on the forum so forgive me if this has been posted. I was surprised not to find a posting on it. So I'm wondering if I've missed an obvious way to do this or I've just not found the posting somewhere. when entering…
  • Can you reopen a prior period?

    I need to add some things I forgot...
  • General Ledger account when one updated

    Hello I need a help, when I received an invoice in the Purchase Module sometimes there is a Variance, this particular variance goes into my purchase clearing account and trough off my purchase clearing account (I am using SAGE 100 V 5.008.00) how…
  • Purchases Clearance Accounting Question

    Currently we are on Sage 100 2014. We have finished product that is assembled from homeworkers and received/entered via Inventory Adjustment / Receipts. In this entry we calculate the cost of the item based on the raw materials and the labor to assemble…
  • Is there a way to Reinstate a Check after it has been reversed?????

    We reversed and issued a replacement check only to find out that the original check actually cleared the bank. Is there a way to REVERSE the replacement check and Reinstate the original check to account for the history? The original check was issued…