• Error

    Can't post a batch, it is showing you can't post to future date.
  • MISC PAYMENT IMPORTATION DUPLICATE AMOUNT

    Am trying to import misc payment in AP Payment batch but all misc payment amount is duplicated Am using Sage 300 Standard 2020 PU 5
  • Do Importing Entries Negatively Affect Anything

    Hi All, My colleague, who somehow believes slowly entering the entries manually is the best way to do things, told me if I import entries from excel templates something is going to be wrong. Is there any truth to it? In particular, he mentioned that…
  • How to Add a Shipment using the Advantage dll or the Web Api?

    I have been trying to add a shipment to a Sales Order but haven't been able to do so. Did not see any option to such transaction on the Web Api so moved the Advantage dll. Tried to write to the view OE0434 and it does create a shipment, however I…
  • Can't add lines in AR invoice in Webscreens

    I have a client using Web Screens (V6.6) 1 of many users can't insert lines on an AR invoice in some companies. She can in one company, but can't in others. - I have checked permissions - all the same, I have tried logged in as ADMIN, and can't when she…
  • Contract/Billings Module

    I have added a contract in the Contract Module and it has been approved. But when I go into the Billings module, it is not listed as an active contract. What step am I missing?
  • Invoices

    We had a vendor cause damage on one of our job sites. We are splitting the cost to fix it with them. What is the best way to enter the invoice for their portion of the damamge? Do I have to create a new AR Customer?
  • Force Zero Quantity in A/R Invoice

    Sage 300 2019 PU 5 How to force a zero quantity in A/R Invoice using item detail type where the Invoice has an Extended Amount >0? Using summary detail type is not an option because there are other Items to be loaded on the same Invoice. Using Quantity…
  • RE: Credit Notes and Receipts

    Hi I am currently using Sage 300 Advanced 2019 where I have come to face the following problems; An Accounts Receivable staff had created fake credit notes and applied them directly to invoices for a customer. The fiscal year has already passed…
  • Why I export and import batch payment batch list as payment amout is double.

    Why I export and import batch payment batch list as payment amount from older batch payment amount is double payment amount but in detail is not double double all entries in misc.payment. I inqured excel template is the same as old template. or…
  • System error. Call to lnkCommitTrans failed [227]

    Hi Am getting this error when adding or posting an AR Invoice batch in Sage 300. System error. Call to lnkCommitTrans failed [227] I recently did a database move using the dump and load. Now my AR batches dont want to post. What could be the…
  • Best way to deal with shipments with 0 items shipped

    We use Sage 300 and Auto Simply. We run into an issue when we pick an order in auto simply, which creates the shipment for us as soon as we post it on the handheld. If the customer then cancels the order before it is picked up, or the freight company…
  • A/R invoice reversal

    A number of invoices were added in may however some of the may invoice dates were dated Jan so it ended up in Jan. The invoices were reversed in the general ledger since there were already posted. when the ages trial balance was run for the customers…
  • how to remove transactions entered to balance the GL and Book balance in Sage 300?

    how to remove transactions entered to balance the GL and Book balance in Sage 300? and other tranaction in the bank rec
  • Vender Ledger

    my predecessor & I are preparing for my 1st YE. We were looking for a Vendor Ledger and can't seem to find where it could be located. Can anyone point me in the right direction? Please & Thank you...
  • Error while posting invoice generated from PO module

    Hello, While posting an invoice generated by the PO module, i'm receiving an error message in AP module. The error is not clear and is generic. "Error occurred during posting batch(es)". The receipt entry went through without any issues and I can see…
  • Rolling back Invoice Entries

    Hello, I am importing large batches of invoice entries using the File > Import in the A/P Invoice Entry window. I find that if an invoice has error importing the process will stop and all of the previous ones in the file will remain in the system, and…
  • Sage 300 Web Screens

    Hi all, Sage 2019 PU3 When going into an order in both OE and PO You click on add line and click in the item column and the finder is not working in chrome. There is an ellipsis. (screen shots attached) This is obviously carrying over to CRM due to…
  • Sage 300 - Apply cash receipts to detail lines in AR Invoice

    We have a potential client and one of their requirements is to be able to apply an AR Cash receipt to invoice detail lines. So for example, if the invoice has 3 lines, maybe planning, shipping and surcharge - and the receipt covers only the shipping,…
  • Garnishment Check - Where/How to post

    I have a Wage Garnishment, where/how do I post it to Payroll? Do I enter the FTB as an 'Empolyee' and post to PR?
  • Item valuation not matching GL inventory

    What could be the possible causes for such?
  • How to make Web API AR Invoice Batches post-able?

    Am using the Sage300 Web API for the first time. We can create invoices via AR/ARInvoiceBatches, but they end up with a BatchStatus of "Open" and cannot be posted by the /AR/ARPostInvoices('$process') service. It seems the /AR/ARPostInvoices('$process…
  • Reconciling WIP account in PJC environment

    We are using Sage 300 Premium 2018 (Accpac) with the Job Costing module. I don't have a method of auditing the balance of the WIP balance sheet account. The balance is climbing, and it is as if transactions are being "dead-ended" there and not flushed…
  • Purchase Order Clearing Account Reconciliation

    Using Sage 300 Premium 2018, with Purchasing and Inventory Control modules. The PO Clearing account on the balance sheet has no means of reconciliation or audit report that proves the GL. I need a report that shows PO receipts that reconciles to the…
  • How to enter TD1 in payroll

    We're stuck on how to enter a new TD1. We have the basic amount ($12069) and the employee filled out $10150 for Tuition amount. If we put the amount $10150 as TD1 - Tuition and Edu in Sage 300, is the amount on "TD1-Total Tax Credit" in Sage (12069+10150…