Sage 100

We need a multi company Aging Report and want to create it in Sage Intelligence reporting. I am assuming I cannot use the A/R Aging work file as it only works when run in Providex. Right? I did try that file in SI and came up with no data. I am not surprised…

Sage 2019 - Looking for way to import into AR_CashReceiptHeader from a source file that contains only the invoice number and check number but not the customer number. Manual entry allows to enter an invoice number followed by the check number. This automatically…

is there a way to export the line details on current open AR invoices. When I use Business insights the current open AR invoices just give the balance of the invoice not the line detail for those invoices. If I use invoice history I get more then open…

Looking to see how big AR Invoice History Header and Detail files can get before there is a performance hit or a file size limit. We are looking at importing AR invoice details going forward in 2024, instead of a 1 line summary per invoice (actually…

Please help!!! Very simple VI job has been in use since 2015, maybe earlier. But within the last year, we have had at least 3 incidents, and want to make sure that if user forgets to populate this column of the AR cash receipts excel template, the record…

Hello everyone, We are trying to merge similar customers in SAGE 100 2020, and we have discovered that ship-to addresses with the same shiptocode are being overwritten by the source shiptocode if they are identical. Is there any way to modify the shiptocode…

Is there an SOP available to set up Paperless AR Statement Delivery only for specific customers?

We have recently experienced a 10 second lag when trying to pull up an invoice from a customer invoice history. It used to open immediately, however now it takes at least 10 seconds. Has anyone else noticed this or know of a fix?

This may be better accomplished by a crystal report, but I don't have access to create those. I'm looking to calculate the final GP Margin on a job including credits which are often $0 to the customer with negative costs of goods so they greatly improve…

What collections software do you utilize with Sage 100? What are the pros/cons? Would you recommend it or another?

I want to add Cash Discounts to the Summary or History Tab in Customer Maintenance: Each tab is pulling cash received in a given period. I can not get the correct data to pull cash discounts. Any ideas would be great. I need to know the sales, cash receipts…

I need some help wrapping my head around creating this AR Terms Code. This is what I need: Invoice dated 1st - 15th payable 15th following month Invoices 16th-31st payable 30th following month Thanks for any suggestion!

I am putting together a VI import job to import invoices into the AR_InvoiceHeader table in Sage 100 2016. The import appears to be identifying the headers and line items appropriately, however it does not skip duplicates as all existing invoices are…

I should know this but I can't figure it out. On 4/26 we received a check for an receivable invoice. We deposited the check on 4/26. On 5/1 the check was debited from our bank account as the check was returned. I'm not seeing how to reverse the paid invoice…

My client does not want to show the payment and credit detail for each invoice on the AR Statement. He only wants to see a single line for the invoice and the balance owed for that invoice. How do I hide the payment detail in Crystal?

Any suggestions on this, I believe it used to be offered on Extended Solutions from what I can tell?

Hello, I have create a UDF called Item code in Cash Receipt detail table and add it on the Grid. I want to create a Button script using the invokelookup which will fire off the item code list and can select the item code from the list, then set the…

I have been using MAS since 1987, but have never used the above features. With the demands of customers lately I need to be able to email a variety of forms to multiple people within a company. Right now it is taking way too long to scan documents in…

Using MAS 100 - A/R module * I have a few customers with no current invoices that have lingering credits that I need to clear up. How can I clean the credits off their accounts? Any help will be appreciated.

Is there any way to update only one source journal in a daily transaction register showing multiple source journals? I bumped the keyboard during during Cash Receipts Entry after printing the Cash Receipts Journal and it skipped the Daily Transaction…

When I have AR Invoice History Inquiry open is there a button to click to find out payment information, date inv paid, check number, amount, etc? Besides going to AR Customer Maint or Inquiry, finding the invoice and clicking on it that way.

I am trying to add a custom panel onto the customer memo inquiry and maintenance screens so I can see both the create date and the auto display field (to quickly distinguish old notes from current notes). Currently in maintenance I only see the memo code…

I was trying to change a customer number, but when I went to Utilities and tried to use Delete/Change, I got the message that I was unable to proceed with unposted data in A/R Invoice Entry. When I looked at the A/R invoices, I was unable to select…

I am implementing landed cost in my system. I am wondering what others have found works best for them. I know I have to have goods and invoice received together for landed cost to function, however more times than not, I do not receive invoices until…

Has anyone ever retrieved values from the AR_InvoiceHistory Header & Detail tables from inside a vb script? At the end of the day I am trying to duplicate the logic behind the "Copy From" button on the sales order header screen so that when a user creates…