Sage 300

What is everyone using to manage who is currently using a license for a Module? We have 4 licenses for JC but have to ask 10 plus people who is in it and can they get out (we use a Teams Chat for this). Sometimes someone had it stuck open or left it open…

What do they use language localisation for?

Hello, Getting the below issue while activating the newly developed module. I am able to create a flat view that is independent but when it comes to creating a join subclass view in the below tables like ARCUS, ARIBH, OEORDH. I am getting RVSPYTRACE…

Hi All, In my table, there is value 3, 4, 5 in RECSTATUS column for BKTRANH table. But there is no entries for 3, 4, 5 in AOM. Can anyone help me on what is the RECSTATUS value for 3, 4, 5 in BKTRANH? Thanks.

I am trying to validate some data for our team and am stuck trying understand the data layout. My boss is using stonefield reports to generate a monthly sales report and he has 2 versions generating different #s. There seems to be confusion on what date…

Hi I have a client who is running Sage 2018 Pu 2 windows server 2019 I have installed the web screens, and run the portal. As soon as I access the web screens I get this. I can confirm the web licence is activated. I am wondering if the…

Hello, When logging into sage I would like users have an option to click forgot passwords, rather than them emailing an admin to send them a temp password. How to add that as an option?

I'm using sage 300 but when I click on some icon, instead of opening the related forms, an error form pops us with the description as shown in the attachments The solutions I have tried to apply include:- 1. reinstalling the application 2. reapplying…

Hi, I am doing customization to add multiple lines to GLJED. But I get multiple error that I cannot find out why it is happening, note that I only trying to add to GLJED, not GLJEH Below is my code. Instead of getting the record by Batch in GLBCTL…

Hi, we need a crosstab valuation report where the row is the period date and the columns are the location / item category. Has anyone created something similar? Thanks.

Hi, we created our own menus but the icons are arranged as they were added. Is there a way to organize them differently? Thanks.

Hi I'm trying to get company color but I haven't the same color with Sage, Someone can help me please Dim Company As String Company = AccpacSession.CompanyID Dim System As String System = AccpacSession.Organizations(AccpacSession.CompanyID).SystemDatabaseID…

Hi, I'm running Sage 300 V2020- Running on a VM accessed by RDP and with SQL 2017 databases running on Azure. I redirected the Custom Reports to the new Azure server with the SQL sa user name and passw and it's working fine inside the SAP Crystal…

I have a crystal report which is run via Sage 300 desktop shortcut [Macro] which has stopped pulling data through for some batches. The Crystal Report only shows a blank Custom form for some A/P Payment batch entries and will pull the data for some batch…

I am looking for one-on-one training for Intelligence Reporter with Connector. I have done all the Sage training courses so I am comfortable with the feature. I have a strong understanding of relational databases and I have a basic knowledge of programming…

Hi, I want to create a Business Intelligence Report by using Report Manager & Connector. In this report, I want to get rows from table APPYM of all Companies database. But first, I need to know which database is actually a company database for Sage…

Can you sort data if you download into Excel. I have a large downloaded file that will not sort (filter not working)? Appreciate any help Ann

Custom report developed for AR invoices . User enters parameters and executes reports and all the data comes on print preview , approx 15 pages . As soon they click on export button the following error is received. generally user tends to run the…

How do I add sub-accounts in my chart of accounts? EX; Account 64000 - Marketing shows I want to add travel, meals, supplies, freight all under this account. Marketing Shows Travel Meals Supplies Freight

We have a client on Sage 300 2014. They have macs they use to RDP into a server to run Sage. A recent update to RDP causes the AP check logo, which is Red, to print in black and white. Has anyone seen an issue like this before?

I create a user in ACCPAC. But i can't execute my macro syntax. But if i change the user to Admin, its working fine. Can anyone help me? How to configure the new user, so i can execute the syntax

i want login using macro. but using windows authentication and specific domain can anyone can help me?

i have some code PORCP1header.Order = 0 PORCP1headerFields.FieldByName("RCPHSEQ").PutWithoutVerification("0") ' Receipt Sequence Key PORCP1header.Init() PORCP1header.Order = 1 temp = PORCP1detail1.Exists PORCP1detail1.RecordClear() PORCP1detail3…

I want to get value from PORCP1detail1Fields.FieldByName("ITEMDESC"). the condition that i have set if PORCP1header.Read how to get the previous data from that field and set into a variable in vb Example: Dim vItemDesc As String = "" vItemDesc…

Greetings! In the data dictionary, for the above table, I see an 'ENTEREDBY' field; when I open POPOR04.rpt to try and modify it to include the 'ENTEREDBY' field in the report, I do not see this field in the POPORH2 table in Database Fields panel of…