Browse By Tags

  • Automated Inventory Reports

    Hello, I am looking at sending an automated monthly report to a customer with a list of the items they supply us. If possible, I also wanted to provide a breakdown of any work orders, inventory adjustments, etc against each item. Is this report possible…
  • Inventory Summary vs Group Inventory and services

    I am trying to get a download of inventory ready for our Year End. I have categorized and noticed there are discrepancies in value. Through Reports 1) Inventory and services summary approx. $450.00/Inventory icon same 2) Inventory and services list…
  • RECEIVED PO / MISSING INVOICE #

    Hello, Is there a way to show which PO's that have been received in are missing an invoice? We just switched over from Sage 50 and when the warehouse would receive material in, they would check off the box "waiting on bill". That way I could then just…
  • why aged balance report showing separate line for currency revaluation (CURVA) instead of embedded in each invoice?

    In the standard report - BALAGEHIST and normal BALAGEGRP - the detail aged balance is showing currency revaluation as a separate line. Can this revaluation entry show at individual invoice instead as for audit purpose - it will not be transparent to show…
  • Is there a way to calculate the commission by item sold?

    Hello, I have a warehouse of items that are are sold by sales reps. I need to compute commission earnings by sales rep; linking customer invoice detail to vendor costs. How can this be done for warehouse items? Thank you in advance. Ellen
  • How to print petty cash statement

    Hello, I want to use the report "Bank Account in Ledgers Report" for petty cash accounts as well. While printing the report under parameter section, i can see the petty cash accounts but when i click on bank selection it says record does not exists…
  • Inventory Report - Duplicating Items

    I have ran the inventory report multiple times for multiple reasons and have the same issue. When I ran the inventory report and downloaded into excel I am finding that it is duplicating many of the items. I am updating list pricing and am checking for…
  • Packaging Consumption in Work Orders

    I'm looking for ideas as to the best way to consume packaging in work orders. We sell products in various packaging....totes, drums, pails, etc. Currently the packaging is relieved from inventory at time of sales invoicing.....packaging codes are…
  • How to match Inventory (trial balance) amount with Inventory Valuation by Category - SQL statement

    For the past weeks, I have been working on generating a report that will provide the inventory amount per Category and should match it with the Inventory balance per Trial Balance or G/L or Financial reporter. Does anybody built a report on this using…
  • Item Sales Report Sorting

    I need to find a way to generate a report that shows how many times an inventory item was invoiced over a given period of time, and I need to sort it by the Sales Rep on the WO/Invoice. I am working to make sure stock items shipped to one of our locations…
  • Printing Record keeps on loading in Sales Order but it never print

    FormerMember
    FormerMember
    I got a problem regarding the sales order report printing , it keeps on loading but it never print . I'm just asking why was this happen . It only happen with this particular SO number.
  • Table Does Not Exist

    I have a report I built from scratch. Pretty simple, only 4 tables and one parameter to fill. I added it to the directory, then thereport dictionary, then set up the default values and then the print code. The report is visible after I hit "Record…