Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
I have gone through the set up wizard for the General Ledger Exchange to import a journal entry from a CSV vile and got all of the way through to the GL Exchange window to import the file. When I click on the Proceed file I get an error that says, "Source…
I am writing a C# app to bring in Journal Entries. I have two issues; I am getting no value for nGetNextJournalNo and I get an invalid key error when attempting to set the SourceJournal+EntryNo key, even though I am setting entryno to a string. I have…
Greetings, Our customer are complaining they have problems with MAS Desktop. They claim that is due to our application activity. Our app uses BOI to have access to sales orders, invoices, customers (read/write). The customer have to clean up SY_Workstation…
I have been able to use nProcess to open and display an existing Vendor record. I am wondering what I need to do to achieve the same thing for a payable invoice. I thought that it was batch number, division number, vendor number, and invoice number. I…
I am trying to use BOI tp print PO to paperless office and I am having hard time finding any good examples of printing to paperless.
Does anyone have code for printing of any forms or reports to paperless?
My goal is to email PDF copy of purchase…
Hi,
I was wondering if anyone had any thoughts on the SQL version of MAS200. We are considering either getting the DSD SQL mirroring software or switching to the SQL version in our next upgrade. We publish reports on a Sharepoint site, and the Providex…
I can't find any information online that applies to MAS200. Everything is 100ERP :(
I need to invoice a customer for a deposit on a sales order.
1 - sales order is not complete
What is the best way to invoice for this deposit so that when the sales…
Is there some place I can get more specific information on how Visual Integrator works with MAS200 v 4.3? We are trying to use it to get reports and either the jobs don't run at all or they run but pull no records.
For example: Table APCheckHistoryDetail…
It seems that the MRP generation uses the sales order date as the required date for its calculations. It seems to me that the ship date or promise date from the sales order would be the correct thing to use. The sales order date we assume to be the date…
We are using Sage Payment Solutions to process our credit cards. We are currently on version 4.40.0.10.
We sometimes pre-authorize credit cards on the sales order and then finalize the transaction on the invoice. Sometimes we simply do a one-step credit…
We are currently using VEEAM. I HIGHLY recommend you take a look at it. While I run a VMware shop, it also works with Hyper-V.
I prefer this over anything else because of the snapshot ability and replication. Currently my live server replicates every…
Looking at any views in Explorer for our main company works fine. However, in our test company (which should be a recent copy of our main company), when you click on any view, the screen shows no details and when you close the window, you receive Providex…
We have upgraded to MAS200 43 and our VI is no longer working. It will search records but will not export files.
This was accomplished using AP Check History Detail Report in previous system.
Using same information in new system, the report will not…
We would like to see Master Orders by default when viewing the Sales Orders Tab in Customer Maintenace. There is a way to Search on them but I would like the default view to include Master Orders.
Is there a simple way to do this?
We are using Sage…
I know how to view contents of a work (wrk) file and I know how to view what tables are used to make a work file, but:
1) how do i know how the tables are linked (joined on what field(s)?) to produce the work table? where can I see this?
2) how do…
I have a 4 users who are accessing MAS 200 in the following arrangement:
1. The user logs into a thin client in Office 1
2. From the thin client, the user logs into a terminal server (TS1) in Office 1
3. From TS1, the user logs into a terminal…
I need to let the system to calculate a discount based on Sales Order Header - 4. Totals -Order Total.
The formula will be 5% * Order Total . I need to create a UDF, UDF_DISCOUNT, under Sales Order Header - 4. Totals Tab to show this amount.
I don…
Thank you very much. It works.
However, how to get value from different module? For example, I want to get value from PO header to add to open sales order table.
Also, what are all abbreviation of different type of tables, such as header table, wrk…
I created a UDF, Estimated Delivery Date, in PO Header. Now I have trouble to add this UDF to PO Detail table. Anyone can help me?
User-Defined Field and Table Maintenance-->PO Purchase Order Detail-->Right click-->Edit Fields-->Green '+' on the right…
oy vey, I thought I knew this sort of software well but I was clearly wrong....
I'm using 2 queries in an event like below.
First Query - gets a list of new orders that contains CustomerNo and the email address of the user who created the orders…
Sage 100 Advanced 2013. Importing GL Accounts - Test import completed successfully with no bad records (except header). After reviewing log, clocked Accept to import records and received this error message.
No File, no channel and no key.
This error…
Yesterday in the middle of working, all users suddenly went Unauthorized when clicking through modules. What could have caused this and is there a quick fix?
