• Accounts Payable Check Printing

    We had 2 checks stick together during check printing. I did not notice we were off by a check number until I had printed and posted the batch. about 40 of our 78 checks printed are off by 1 number. How do I fix this? Do I have to void them all and reprint…
  • How to remove invoice items for deleted batch

    Dear concern, I am using sage erp 100. I accidentally deleted batch . Now can not post invoices. But these invoices hold items which are not available for sale. I want to cancel or delete these invoices. Please help me to solve this problem
  • lines in a sales order invoice doubling

    I have seen two unrelated instances of a single random line showing up on my invoice when generating one using the path sales order, main, invoice data entry the GL detail report that I printed early May for our April rebill, as well as the latest…
  • Restocking fees

    Do we have ability to charge restocking fees based on price net of prorated discount? thanks
  • A GL Account for a GPS traker

    I may not in the right place to post ask these questions. But I need some help. I purchase a GPS tracker for my trucks what GL should I use for this expense. Thank you for your help.
  • automate - 300+ customers need to be autopay a few days after the invoices go out.

    I have a client that bills once per month. I want to export the customers that have a checkbox I created that states yes, along with that month's invoice balance to auto-pay credit cards. 300+ customers need to be autopay a few days after the invoices…
  • Accounts Payable Check Printing

    Hello, We noticed that two vendors have a posted check with the same check number, different amounts, and different check dates. Check 4340 for 2,313.03 shows under Vendor A with a Check Date of 06/23/2022 Check 4340 for 2,120.14 shows under Vendor…
  • Can I get more that 2 people into a Cash Reciepts batch for entering Credit Cards during the workday?

    I am running Sage 2021 and have managed to get two people into the same batch for doing Credit Card transactions with Paya. Any attempt to add a third person will not work. What is the preferred method for allowing users to run a stored card for a client…
  • Positive Pay Export for Union Bank

    Has anyone created a Positive Pay Export for Union Bank or any bank that requires the detail record to be on two separate lines? Here's a sample of the output file Sample data transmission payee positive pay Input format 908123456700002000720312070000029375…
  • Automatically print backorder pick tickets?

    With raw materials and shortages we have found that we are shipping more shipments leaving a backorder in our system than ever before. Historically, shipping would go in and print a new ticket with the backorder and keep it until it could be filled. Our…
  • SO Shipping Batch No. missing on Invoice

    Occasionally we get an Invoice that is missing the Batch No. from when it was created via Shipping Data Entry. We have multiple batches a day, usually separated out between EDI and Non-EDI orders and/or AM vs. PM shipments; totally anywhere between 2…
  • Bulk delete empty Sales Order batches

    We have a process synchronization from our online store into Sage using the SData API. We had a glitch that caused a large number of empty Sales Order batches to be created. There are no invoices on these batches, so I was wondering if there was a way…
  • Visual Integrator Import Sales Orders Referencing a Master Order

    I use VI to regularly import sales orders. In this case, I would like to reference an existing master order, as the only data that needs to change per order is the header comment. As I have several master orders to reference, it would be nice to populate…
  • Sage 100 2020 6.2.0.1

    How to delete a line item in a sales order invoice that has been pulled through from standard sales order. Sage Advanced 2020 6.20.0.1
  • BOI for Sage100 ERP - BM Production Entry - How to Get BOI Logic to Explode Bill Components

    I am using BOI to automatically create production entries in BOM in Sage100 ERP. I realize Sage100 ERP support is obsolete, but it is what our company still has and we plan to update in the next year. I have some code I threw together below for testing…
  • Why can not see bank balance?

    There is only one bank code on my Sage 100. Cash receivables and payables have been recorded on the system and I did bank reconciliation. But I do not see any balance of cash receivables on the GL balance sheet. I would be grateful if someone…
  • VI PO Receipt of Goods both Lot and Avg items in the same receipt

    I'm trying to recreate PO Receipt of Goods from history. I can't seem to import to a PO where 10 lines are lot distributed and 1 line is not. What field can i add to distinguish between them?
  • Credit card not Processing on Sales Journal Update

    Hello, I am having an issue processing credit cards through Sales Order Invoice Data Entrybin Sage 100c 2018. I can preauthorize a credit card charge in Sales Order Entry and it preauthorizes in Paya. When I invoice the sales order the credit card authorization…
  • Merging items, "cannot merge Sales Kit to an Item" but no BOM exists

    Hello everyone, I've got myself a peculiar situation and wondering if you could lend me your brain a bit. This is 100c Advanced 2017 5.4 I'm trying to merge hundreds of Kit items into a corresponding new item code. In order to merge them, I initialized…
  • Some items received and others not - Receipt of Invoice entry

    Hi guys We posted a receipt of invoice batch earlier and some items seem to have updated to item maintenance and other items have not. Some items are showing as received in Receipt of invoice but not showing on IM. We ran a rebuild for the PO and…
  • Two separate errors: Sales Order Batch Authorization (oScript.UIObj error, and 'Referenced statement invalid')

    Hello, We have been having issues with Sales Order Batch Authorization. Nothing errors out until the final step where accounting actually tries to process the credit cards .Here is the first, which I'm unfamiliar with: The second one, I have…
  • Processes showing up in the master console that don't exist on the system

    I have processes showing up in the master console that don't exist on the system. How do i get rid of them in the master console? They are both country code maintenance programs
  • Misc item charges not being billed?

    Hello, We have a miscellaneous charge we add to certain customers sales order. I was just informed that although these are showing up on the Sales Order, the customer is not being billed for this. How would I go about ensuring that this miscellaneous…
  • MapQuest Outage Update. Fix ETA?

    It seems that the Compass Icon (=MapQuest lookup) in the Accounts Receivable Customer Maintenance/Inquiry has not been working for at least two months. (Error: "Sorry, we are having trouble with that URL"... KB # 110829) Has anyone else have this experience…
  • Is there a way to track who/when deleted a line item in a Sales Order?

    We are having an issue where line items are being deleted from active sales orders either manually or via our pick/allocation process. We can see these deleted line items in Sales Order History, but is there a table with history as to when/who deleted…