• Finding Lot numbers on Unconfirmed Deliveries

    Our business would like to print packing slips before delivery confirmation. In most cases, I can see the lot numbers from screen WK4STD1 but I cannot find the table where that lot is stored. SDELIVERYD seems to only have a lot number for some records…
  • Sage V12 Exporting Information from Various Pages

    We have just switched to V12. I am wanting to export information from various pages. Is there a way to personalise an export spreadsheet to suit my requirements? Some of the information I require is: Product SKU Product Description Pack …
  • AP / AR Aging Report Shows Fully Applied Invoices

    Hello, When i run the aged trial balance it shows fully applied invoices and payments. It is matched already and customer wants to see only outstanding documents. Are there any way to remove all applied documents from aging reports. Eranda
  • How do you create a report for Work Center Capacity Variation

    I'm trying to create a report so that the maintenance team can see how many "variations" they have scheduled across multiple work centers. the table CAPVAR is not at all structured like the grid in the work center page. Does anyone have a report already…
  • MACRS Depreciation type with 2,5,7 years lives

    We have a US client making use of this method - and applies it across various asset classes. Can you suggest how to apply the different rates per year of useful life to satisfy this method?
  • Is there a way to export some data into a csv or text file and tag it on to the end of a printed report?

    so, we want to output some of our customer data into another system but only as the delivery documents are printed. on V11, is it possible to tag something on the bottom of the report code that will output a CSV to a given location. eg: user prints…
  • 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.
  • INVOICE INQUIRY TABLES

    I am trying to report on the invoice inquiry screen. The fields are exactly what i need. Anyone has an idea what those tables are that are running?
  • Make A New Field

    How can I make a new field on the invoice? When an invoice is created I want to use this new field with drop down options that the team can use to tag invoices. So when reporting is done they can filter for a specific report.
  • What does the create date in the STOJOU table mean?

    I'm trying to track the health of our shipping department and I just want to ensure I fully understand the create date in the StoJou table. does that mean when the delivered qty is taken out of stock ? and if yes, does that also mean when the shipment…