Hi,
Can anyone advise how to increase a limit of row level permissions (Parameters --> Users --> Users --> Organisation) in user setup? It is set to 10 in my organisation and I need to be able to add more to some users.
Thanks
Ania
Hello everyone
When I create a SQL trigger on a table in SQL management studio the trigger will be deleted when the table is validated or a new release is patched.
Is there any way to create SQL triggers so that they are protected? Like activity codes…
Customer wants a report to be run from Sage which gives the following 5 columns . Currently they export users and they print user authorizations report and then mix and match data but since its a bank involved in Identity access management and they want…
Hi everyone, I came across these excellent and useful to improve navigation on X3 V12.
A. Right Panel Actions
ESC + N – new
ESC + B - save
ESC + C - create
ESC + D - delete
ESC + E - cancel
ESC + ALT + U - refresh
ESC + ALT + P - print…
I am wondering if anyone out here has had any experience with the trolley build features with Datalinx? We are thinking of exploring "picking to slot", "Trolley Build", "picking to Carton" functions in our warehouse. Would love to pick someone's brain…
We are on Sage 100c 2019 and I'm trying to find out a way, that when BOM Production Entry is launched and we go to the lines tab, that the line sequence is NOT alphabetical/numeric ascending (which appears to be the default), but based on the way the…
We received a case where a customer wanted to configure Quick Find to return the result of a search on a custom field that was added to the Company entity.
When a user searches through the entities it can only display a maximum of 30 results based on…
Hello Everyone,
Can anyone let me know that how to download SEPA (FRA legislation) XML file after posting payments through manual remittance. I am not sure whether any other software required to download SEPA XML bacs file or any special setup required…
I'm looking for ideas as to the best way to consume packaging in work orders.
We sell products in various packaging....totes, drums, pails, etc.
Currently the packaging is relieved from inventory at time of sales invoicing.....packaging codes are…
Hello All,
Please am having issue with PAYMENTH description Table not flowing to GACCENTRYD description table.
I did a transaction on payment screen which was ok and generated a journal number, so i tried designing a report (Supplier statement) which…
Is there a way to disable the forcing of capital letters in the PO no. field within order entry?
We have a partner who sends us PO numbers that contain both capital and lowercase letters.
When we transmit through EDI back to them the information is…
Hi There, I am trying to integrate Sage x3 v12 with MS Office, and I am facing the error below, when setup the datasource: Cannot read property 'shortDate' of null --------------------------------------------------------------------------------------…
Hi there, I have been attaching images in sales invoices in the Attachment section of the Invoice record, it takes time to do but in the long run when we have more images then one.
Question: When attaching the Images I have to do them one at a time…
Hello all,
When I am in the PILOT folder trying to access Setup> Users, "GESAUS" function, the system presents this error:
Error only on PILOT folder.
I'm using Admin user, this started happening after validating the menu in the function…
When calling a Subprog from a button action on a Window, it executes a number of data validations, one of these validations does select in in SQL.
When I execute the query in SQL, it returns the correct results. For example:
When testing the same…
We use Sage and write software that integrates our book information system with Sage for inventory and finance functionality. The information in Sage about Mat Req Pc is clear, but I can't seem to find information about MaterReqPer and how it relates…
Hello all,
I'm trying to create a SQL expression to view the value from an optional field in the APIBDO table. The report being used is a GL Transaction Detail report with the following source container join:
((([GLPOST] INNER JOIN [GLAMF] ON [GLPOST…
Is there a way to customize Item memo so if certain customers order that item a pop up will show up on the sales order. Possible by customer number or country code. We have some items that can not be sold in certain countries.
Anybody know of an easy way to import expense items from a Concur file export?
Alternatively would anyone know how I can export GL strings for each company managed in Sage?
Thanks
SonnyS