Sage 300

Hi, is there an online video to explain how to do the following: I want to export on excel particular info from invoices. I tried to do so but get an error when trying to set up criteria. i would need in particual cust name date inv # the detail of each…

I've been working on a new budget for 2020, and started out using the Sage 300 macro to export the previous year's budget to Excel. I've kept the column layout and titles the same, and filled in the new numbers for the 2020 budget. Used the export macro…

Good Morning; I have a client that is using the Budget Macro, to populate the budget for the current year. It seems to skip a few accounts. Any ideas?

We have many employees with pre-tax 3rd-party short-term disability deductions. When those employees receive payments for short-term disability, some employer-related taxes must be calculated. I have a custom Excel workbook to carry out these calculations…

I do the work for two separate customers (slightly different ownership). One company -- Company A -- frequently invoices the second company for various items -- and the A/R invoices have many, many lines. The second company -- Company B -- wishes to post…

I am aware of how to import items manually through I/C Items > File > Import. And I tried to record a macro from this but it doesn't seem to show up in the macro code. Are there any other ideas?

Would anyone be able to point me to the table(s) I would need to query in order to retrieve all outstanding bank rec transactions for a particular bank? I'm referencing an older database schema, but it doesn't seem to match up 100% with the tables that…

Hello All, My Financial Report that exported from system by using template include a lot of 0, the cells without any number. The template is wrote by myself. I was wondering if somebody can advise how to remove 0 and just show clean cell? I mean how…

I hope this is the right place to ask this. Im just a lowly IT person attempting to help our Admin dept. They are using Sage 300 and we are trying to import an excel doc into Projects A/P Invoice Entry. I exported one that was manually entered correctly…

How can I show invoices from Sage 300 ERP on a website?

We have inventory sku and price data that is provided from our vendors everyday in excel format. I would like this fresh inventory data to be imported into Sage. What is the best way to have this imported? Should we update the database tables directly…

I have large number of lot records which does not have the expiry date entered . and as there is no import function in IC Lot Number screen, is it safe to alter data bases ICXLOT to update the Expiry Date EXPIRYDATE Field through SQL or export and…