Sage 300

For a small context, this is a part of a sync application. I cannot use the macro recorder the Sage 300 has built in to record edits - since the field I am trying to pull seems to be Read Only within the Invoice Entry. Working: Currently I am…

Hello, in the AR set up under optional fields there is a default value that we choose when creating a new option. Where is the default value created as the one I need does not exist? Thank you

debug to line : FieldsOEHeader.FieldByName["CUSTOMER"].set_Value(); is error Error HRESULT E_FAIL has been returned from a call to a COM component. help me, please

Hello, can a quote be printed so that it would exclude any items that are back order in the total since an order entry includes all items and therefore is not necessarily the correct total to give to a customer?

Hello, I find it strange that there is no standard financial statements available. First system I see that does not have one built in. Is there a link to the procedure to design one?

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, 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.

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…

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

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…

One of our customer needs two report (Trail Balance & GL Listing) to customize. The requirement is the reports Accounts description (Example : " Cash Account") should display Arabic word . So the solution planning to give is Optional Fields to Accounts…

Have a client that created a report.....selected the "all users" check box when creating the shortcut. Since then they have a new user that they do not want to see the report, but, of course, it does. How can we fix this? On another similar note...…