• Sage 300 always prompt SQL login database when Custom Report from Crystal Report is printed

    Hello, I want to ask about a custom report that I made using crystal report. So my custom report has been completed. The report uses a stored procedure because it saves time, compared to using a table / view. then I put the custom report into sage 300…
  • Create Customized Table in Sage 300

    Hi, I would like to ask question regarding customized table in company database. Lets say we have DB called SAMLTD. For customer requirement, I need to add another table ' CUSTOM ' in SAMLTD to store information. Then I have to sync this information…
  • Importing Employee Transaction History from Excel

    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…
  • Can the details on A/R invoices for a customer be exported in bulk?

    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…
  • How can you create a daily schedule for DB Dump?

    Hi Forum, I have created a macro that automatically dumps my company databases but my challenge is HOW to attach this to a scheduler like "Task Scheduler" and make it run successfully. When I tried creating the task and thought I had done everything…
  • Re: Remove 0 in the report

    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…
  • Sage 300 2014 Build 0 to Build 3 (PU3)

    Hi I did not run Day End in the PO module before updating to PU3 Build 3 from Build 0 Sage 300 2014 (AP,AR, GL, PO) The PU 3 Release Notes mentions that AP, AR, TX and PO have to be activated after PU3 is run. Since I did not do the day end before…