Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Problem

Job costing invoices and non inventory item sales were excluded from the Customer Activities tab in Debtors maintenance - 7.02.01 and earlier

Solution

Warning
titleSQL skills are required

Use A working knowledge of SQL Management Studio is required to apply this SQL script to the database

...

complete this task.

Download and apply the SQL script to the relevant database(s)

View file
nameusp_JIWA_Debtor_BuildGrid_OnUnprocessedSales.sql
height250

Filter by label (Content by label)
showLabelsfalse
max5
spacesJ7UG
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel in ("customer_activities","debtors_maintenance") and type = "page" and space = "J7UG"
labelsdebtors_maintenance customer_activities

...