Browse By Tags

  • Unable to add 6th Company Database in Sage 300 2022 Advanced Edition Database Setup

    Hi friends, I have a strange issue at a site operating Sage 300 2022 Advanced with Product Update 7 installed. I am receiving the "Cannot create the database profile." error when attempting to add a 6th company database into Database Setup - irrespective…
  • Row Level Permissions

    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
  • Assign the correct Tax Schedule in Visual Integrator

    Hey All, I have a VI question. I have a pretty decent understanding of import jobs, but this one has me stumped. For our eCommerce website, we now have to start collecting sales tax in states where we meet economic nexus, and bring those taxes into…
  • VI Export - how to export the Company Code

    Can't find this having been discussed anywhere, although I thought I had. I am assuming I can use a Temp field and either assign "<CompanyCode>" or Calculate it somehow. So far, nothing that I have tried has worked.
  • Have a problem accessing the company data in network

    Hello, I have a Simply Accounting Premium 2008 version. I have recently added another computer to the network (the 2 computers are connected using an Ethernet cable) and I have access to the company data and back up from the second computer (read/write…
  • What is the purpose of the following: Substitution product "Field SBSITM / Screen ITS [ITS]" VS Alternate product "Field RPLITM / Screen ITM2 [ITM2]" in "Product"

    Hello All, Can someone explain the reason for these two fields listed in the subject in "Products" screen. I've read the basic break down's from "F1" help, but we are looking for more real world examples and purposes of these two fields. Could either…
  • VI Job for PM Work Ticket Entry

    Can anyone help me with importin in PM Wok Ticket Entry? I've created the Temp H file, but it gives me an error "HS Record Invalid"
  • Sales Price List By Customer Shipping Address

    Is there a way to set up price lists by the customer's city, zip, or state? Currently I only see the Ship To Address, which is the address code, and not necessarily helpful since this doesn't reference the customers' zip, city, nor state. I'd like to…
  • How to rename a Temp Field in a VI export?

    Haven't found this posted before, although it may have been and my searching skills are diminished. I also understand that this might be something that I can pull into Access or Excel, or even write a Crystal Report, to accomplish. But for the moment…
  • Written Down Value method configuration

    Hello, Can anyone guide me to configure the WDV depreciation method in Sage X3 V12?
  • how to give my user permissions to run a visual integrator job from the command line

    I've worked to get my VI job to run by following the instructions here: https://support.na.sage.com/selfservice/viewContent.do?externalId=19387&sliceId=1 This is the command I run: "C:\Sage\Sage 100 Workstation\MAS90\Home\pvxwin32.exe" -hd ../launcher…
  • Deactivating tax authorities

    Hi everyone, I started using an AP automotation software by Beanworks which is tied to our Sage 300 system. When I view our tax authorities within the Beanworks environment, it shows some tax authorities as inactive but when I go to the tax authorities…
  • Opening Multiple Companies - Changing Previous Choice

    The directions for opening multiple company files is very straight forward. 1. Open the first company. 2. Select File, and then either Open Company or Open Previous Company. 3. At the warning message, select Yes. 4. Select the next company you want…
  • Trolley Build Function Sage

    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…
  • VI Invoice Counter on export of AP_CheckDetail

    Hi Everyone, I am trying to export the AP_CheckDetail and CheckHeader information but I need to have a counter on the invoices. There is a field NumberOfDetailLines but if the Check has 5 invoices this field shows 5 but I need to have each invoice…
  • Antivirus Exclusion for Sage

    I have got a server where I would like to install antivirus. I have got sage X3 installed on the server. Can someone please provide me any advice on how should I move forward with this? Are there any important files/folder that I need to exclude…
  • Positive Pay Bank File Definition - Separate Detail Lines per Column

    Customer's bank wants the Excel file generated with the check details to have each required field in a separate column. Does anyone know how to specify this within the Bank File Definition?
  • Dimension Codes Not Flowing From Supplier Record to Supplier Invoice

    Common Data >> Bps >> Supplier, Financial Tab, Analytical Dimensions Currently only codes listed in AX1 flow through to the supplier invoice (Supplier BP invoices). How do I change the other dimensions to flow through to the supplier invoice as…
  • Production Scheduler Sage X3

    Hello, We have been using the Sage X3 with production scheduler and production scheduler is the most important tool for our operations and work order planning. Sage X3 version : Enterprise Management V 12.0.19 Production Scheduler : 6.0.2014…
  • VI for Transaction Entry

    Hello, I setup a VI import Job for Transaction Journal Entry and it was working fine until recently. It is taking the offset account number and using it for the line account number as well. I am telling it to get the number from column, but it ignores…
  • Delivery Notes Report - default values

    Where do you assign the defaults for a report? Specifically, when I print the BONLIV report I want it to default the customer value from the record so that I don't have to change the parameter lines each time. Where do you make these kinds of default…
  • VI Job Cycle Option - what is this for?

    Can someone explain the purpose of the Cycle Option in VI. I have read what documentation I can find but want a "real world" explanation of how it is used. I am hoping it will cause my VI Job to complete. I have a bat file that is run from Windows Task…
  • VI Bat File Error

    Attempting to create my first bat file to run a VI job outside of Sage 2018 Advanced 6.00.5.0, getting a Connection Time Out error. Can anyone tell me where I went wrong? I followed the steps carefully to create the new app in the Sage Application Server…
  • Creation of New Folder creation from user screen, unable to get full access?

    Hi All, I created a new folder from the front by using authorized Admin role access. But am not able to get full access rights to the newly created folder. it giving me an error while accessing the folder. needed suggestions on how to get full access…
  • Nice if 'PAC complete' could be on a line by line rule basis - believe would be much more versatile allocation and issue setup

    'Pac complete' as an overall function does not allow smaller units to break into larger units when needed for picking. Those smaller units need to be made manually available (or already available). Our orders need to be shipped in cases and pallets. Pallets…