Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Stock adjustment improvement needed
01-28-2013, 02:45 PM,
#4
RE: Stock adjustment improvement needed
Need to think a bit more ... Off the top of my head - if we add a field to stock moves this creates waste on every other stockmove record - and it's a big table so need to be careful not to bloat by mistake.

Perhaps we add a stockadjustments reasons table that links to the stockmoves table id so we only create records for the stockadjustments - needs to be done for stock checks too.
We also need a new table with the reasons - which will need a new form to define the reasons.

CREATE TABLE stockadjustmentreasons (
reasonid,
reasondescription
);

Then the new table of

CREATE TABLE stockadjustreasonglpostings (
reasonid,
loccode,
categoryid,
accountcode
PRIMARY_KEY(reasonid,loccode,categoryid));

We will also need to create a form for input of these as per COGSGLPostings.php or SalesGLPostings.php
Also a new function in SQL_CommonFunctions.inc to

GetStockAdjustmentGLCode (reasonid, loccode, categoryid)

so we can just modify as little as possible of the existing adjustment/stock check scripts

Sorry logged in as testing - but this is Phil :-)
Reply


Messages In This Thread
RE: Stock adjustment improvement needed - by phil - 01-15-2013, 05:53 PM
RE: Stock adjustment improvement needed - by testing - 01-28-2013, 02:45 PM

Forum Jump:


Users browsing this thread: 2 Guest(s)