Sage 500

We have just discovered that we have 70,000 payments that were never applied to open invoices in our SAGE 500 System,  We know how to manually apply each one but that is just not realistic. We are desperate for a bulk solution to this problem. Is there…

This replaces a previously posted discussion regarding the 1099 TY 2021 Stand-Alone Updates to reflect that as with past 1099 Stand-Alone Updates that a given Product Update level is required prior to installing the 1099 Stand-Alone Updates.  This usual…

This has been edited since the original post to reflect that as with past 1099 Stand-Alone Updates that a given Product Update level is required prior to installing the 1099 Stand-Alone Updates.  This usual requirement helps ensure that both client and…

Does anyone have any luck finding a good third-party consolidation solution for Sage 500, instead of manually booking elimination entries in a separate company and pulling them into SI?   I am not an expert in consolidation, so I would appreciate thoughts…

I have been able to successfully import an Invoice batch of customer statements from a subsystem into Sage 500 AR and then post this batch. This batch consist of driver account invoices (fees and charges) and offsetting credit memos (redeemed CC script…

I am posting my first AP batch for 2021 and received an error stating that the period is currently locked and posting is not allowed.  We did not lock the period but I do see in Accounts Payable - Process Period End that there is an option for me to Unlock…

When you click to Generate PO on a line item of a sales order and process Generate PO from SO it creates the next available PO number.  RIght now we are manually creating the POs and giving them a PO number of DSorder#  (to indicate a Drop ship) then when…

Hi All, 

I created a voucher, posted it and then processed the invoice for payment and also posted this. 

I accidentally posted to the incorrect bank account and have created a journal to balance the amounts correctly, however I have also credit a debit…

How about we want to add a new procedure to the goods receipt process, I want to know if there is any way to see the comment that is made in each individual line in inventory transactions.

I hope you can help me, greetings!

HI, I have a HOW TO question.  Is there any way to automatically create a Purchase Order from a Sales Order when certain items or drop ship items are on the Sales Order?  Has anyone done this or is this core functionality?

Thank you.

-Robyn

We have several vendors that require us to make pre-payments for PO orders. We have a few of these payments where we haven't yet received the corresponding invoice before the 1099 deadline, and we're not sure how to address them. Since no invoice has…

I have a pick/pack that was done with a 8/7/19 future date in error.  I don’t believe that the pick/pack can be deleted or the date changed on it but need to know if I change the date on the invoice how it will affect the information processed. How does…

How does Sage 500 ERP calculate the trade discount and sales tax amounts? I keep getting the warning " Calculated Trade Discount Amt not the same as value passed in." after running the stored procedure, "spsoAPISalesOrdIns", and it keeps defaulting…

is there a way to reverse a posted bank reconciliation?  I am new to Sage 500 and have made an error that covers 2 months of bank reconciliations. I failed to key in the Bank Ending Balance for these 2 months and have just caught the error. 

So, I'm looking at implementing Landed Costs (finally!), and have a few questions:

• It appears that the Inventory Value/Cost of the item in question is altered accordingly; the offset is the Landed Cost GL -- in our case, Freight/Duties.  However,…

You double click on the column headers titled Print and Post.

Hello! We are trying to post a batch of Receipt of Goods and keep receiving the following error:

Can anyone offer advice/suggestions/a solution??

Thank you!

Getting print Error after patching to 7.70.7 of SAGE 500 2016. 

I ran an ACH batch and was able to receive a file.  However, I then notice I had the wrong payment date so I did not update the registers and deleted the batch.  Now I cannot general any new ACH files.  Any ideas why I am unable to do so?

Thanks

How to find out which credit memos applied to certain invoices?

I know how to do the 'Return To Vendor' process to take care of the Accounting in Sage500,  but HOW do you create shipping

documents to actually ship the Items back to the Vendor in Sage? 

I noticed that there was a similar question posted here…

Hello - I was asked by an auditor if my team can post an AP invoice to a previously closed period. in Sage 500.  Always assumed 'no', but an AP staff member was able to post to a prior period once they 'accepted' the 'posting to a prior period' warning…

Hello! We are using an outside service to process payments to our vendors. We are sending them a data file of vouchers, then they are sending back data files of payments.

What options are there for importing payment records?

Thank you. 

How do you run a report that will show you just the transactions that make up the balance in my accrued not invoiced report.  These are items that have been received but no invoice entered against that receipt yet.  The detail of that report should tie…

I am new to Sage and my company and just starting to dig in.  I am looking at the AP general ledger and comparing it to the subledgers and they do not agree.  AP GL = 3,085,390.  AP Vendor trial balance = 3,087,464.  AP Aged payables = 3,338,490.  I would…