Public changes to xtuple sql schema
Shell
Switch branches/tags
Nothing to show
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
diffs
original
README.md
apaging.sql
explodekit.sql
makediffs.sh
triggers-coitem.sql
voidarcreditmemoapplication.sql
voidinvoice.sql
x-dragon-cobapply.sql
x-dragon-deletesoitemcheck.sql
x-dragon-invdetail-bydate.sql
x-dragon-invhist-transfer.sql
x-dragon-optimize.sql
x-dragon-salesorder-planning.sql
x-dragon-salesordercalcs.sql
x-dragon-trialbal-fix.sql
x-netsuite-mig-extra.sql
x-netsuite-recvgrp.sql

README.md

xtuple.modifications

Public changes to xtuple sql schema

Includes:

a) Explode Kit part non-destructive updateing

  • explodekit.sql [MODIFIED]
  • triggers-coitem.sql [MODIFIED]
  • x-dragon-deletesoitemcheck.sql [NEW]

b) Planning credit memo applications to invoices (cobmisc)

  • x-dragon-cobapply.sql [NEW]

c) Showing the exact quantity of stock a particular time.

  • x-dragon-invdetail-bydate.sql [NEW]

d) planning inventory transfers

  • x-dragon-invhist-transfer.sql [NEW]

e) query optimizations

  • x-dragon-optimize.sql [NEW]

f) usefull salesorder based calculations

  • x-dragon-salesordercalcs.sql [NEW]

g) source location and target ship id for planning sales orders and shipments.

  • x-dragon-salesorder-planning.sql [NEW]

h) netsuite import utilitiy methods / tables. Converts ItemReciept grouping into recvgrp and adds oldid columns to some tables to make refering easier.

  • x-netsuite-recvgrp.sql [NEW]
  • x-netsuite-mig-extra.sql [NEW]

i) [REMOVED] was void invoice keeping numbers - this breaks to much..

j) void invoice with applications This works by creating a fake CM/DM and moves the application to the two fake entries. Note currently does not suport cross currences

  • voidinvoice.sql [MODIFIED]
  • voidapcreditmemoapplication.sql