Browse By Tags

I am importing an Accounts Payable Vendor to BusinessWorks. The file is a comma delimited file. The definition says to send city and state abbreviation a City, ST for example Hastings, MN. When importing, this adds the city as "Hastings" and the Zip code…

I have been trying to import invoices from one vendor through the visual integrator, I can pull up the invoices in vendor maintenance in accounts payable but the transactions are not posted to the ledger accounts. I visited invoice register to post but…

When exporting payment history for AP I am only getting a few years information. If I run a report I can see the system has 20 years worth of data but its only giving me 2+ years which is more like just the time frame for viewing in the system. I tried…

Our client has a system in place that kicks out a dept code. This department code has been directly linked to a G/L account by utilizing the AP Expense Distribution Table (Code 5 on the Distribution Table is equivalent to the G/L account we want to import…

Does anyone have any experience importing labor costs from Paychex Flex to Sage 300CRE? Wondering if there is an import template available?

For context, I tried searching these forums for at least an hour to find an answer on this, but the only active discussions that popped up were 8+ years old. Either I was using the wrong search terms, or this is an uncommon issue. Apologies in advance…

Does anyone know what the file format needs to be for the 1099 Beginning balance import function? i tried Excel and it kicked out immediately, i tried CSV and it's not reading the comma delineation. I did some digging and it sounds like it's expecting…

I'm attempting to import an invoice using VI import and encountering a "HS Record Invalid or Write Failed. The Vendor Number is Required" condition. I've confirmed that the Vendor record exists but it continues to fail on the import. This error also…

I need to clean up our vendor database and would like to run an export, make my changes and then import those changes back into BW. I have looked at the articles available for vendor import, but they do not address any changes in status. I have over 500…

Does anyone have experience with using the SAS Concur Expense Solutions and importing the data extract via VI to the accounts payable module? or can you tell me which VI table is used for import of invoice data to A/P? Thanks!

For Sage 300 Prem ERP v 2014, are there report formats, or modules, that convert the Batch Payment Report (or a Generated Payment Batch) into a data file importable into banks' web portals? The banking portal is HSBCnet. We've deployed HSBCnet in US…

We currently use Sage 300 ERP for financials. Our MRP (Seradex OrderStream) will export daily AR/AP information and we import it into Sage via the appropriate forms Import. Our China facility is also using Sage 300 ERP for financials but they currently…

I am a veteran MAS 200/Sage 100 ERP user and have done many types of imports over many years. I am working on a 4.5 Sage 100 Advanced version of Sage (we are upgrading in early September) and need to import some temporary vendors and their invoices…

Has anyone used Visa Commercial Format (VCF) with MAS 90? I've been told I need to export a file in "VCF" format. Is anyone familiar with this requirement? Thanks.