Sage BusinessWorks

Hello All, I am trying to import sales orders created from a third party. All works as it should, except when adding a discount to a line item. I get an error that says " ERROR: Line item extended price must be equal to line item unit price times line…

I get an error when trying import Payment (ARP) where I point payment method like a credit card. For this, I create CSV file and use code "-1" (from the documentation) and get the error: "Invalid payment check number". Example CSV: /P,customer100…

Hi All, Is there any APIs, webservice Or tools for Import/Export data? Please, anyone can share knowledge about it? Thanks for your help in Advance, SF

I import journal entries (JE) into the General Ledger module, some of which affect cash accounts. However, they do not depict on the Cash Account Register in the Cash Management module. I have to manually re-enter the JEs via the "Enter Bank Transaction…

Is there a better way to import journal entries into Sage BusinessWorks 2015? Like directly from Excel. Or a faster way of creating CSV file of many records from Excel, readying it for import?

While manually entering information into the ACA Preparer, I noticed when I right-clicked one of the column headers an import from CSV file option appeared. I was unaware this was an option. We already track all of our ACA information in an Excel spreadsheet…

I've followed the steps in KB 18720 and continue to have issues. Unit Cost will not populate regardless of how I structure the source file. Has anyone had any experience with this? I'm currently running BW 2015 SP10. I've tried from 2 different computers…

I need to get data in Business Works exported in to Reynolds EraLink. Has anyone found a way to do this other than manual data entry?

Hello, I am trying to collect data for a particular customer... I need to export every product the customer has ever ordered into a spreadsheet that includes the part number, part description, and the last cost the customer was charged for the part…

We have a BusinessWorks' customer who was recently acquired by a larger company. The new company needs the usual monthly reports in an Excel file to import to their corporate headquarters. I am having some issues with Custom Office and would appreciate…

I have tried looking into the Enter global Global price changes and global part change and it only give me Base, Line, and Margin, but Not Absolute option. I have 200+ items I need to change to Absolute so that I can import pricing on them. any ideas…

Is there a way I could update the status of part id from Active to Inactive by doing multiple at one time I have over 1000 part ID I have to change to INACTIVE and I have been able to rename them using the Export/Import Part method, but I don't know how…

Is it possible to Merge the data of two vendors within the same company. My two largest vendors merged and I want to have all invoices for both accounts merged into one account so I can look at one aging. I can't seem to figure it out. Thanks

I have created a custom customer export to capture YTD activity by customer. When I run the export, the YTD figures are incorrect. I am getting figures, but they are not Year To Date figures. I haven't been able to figure out what numbers it is…

I have tried doing a part rename using /r,"OLD PARTID","NEW PARTID"<cr><lf> but it tells me invalid import file format Please help