Granite WMS/Accpac

Accpac

PO/Purchase = Granite Receiving

select * from [dbo].[POPORH1] where PONumber = 'PO00000021'
select [POPORL] , [PONUMBER],VDCODE,VDNAME,[DESCRIPTIO],[PORTYPE] from [dbo].[POPORH1] where PONumber = 'PO00000021'

select * from [POPORL] where PORHSEQ = 18772

IC/Receipts = Granite Takeon

select * from ICREED where SEQUENCENO =''

select * from ICREEH where RECPNUMBER=''

IC/Transfers = Granite Transfer/Move

select * from ICTRED where TRANFENSEQ=''

select * from ICTREH where DOCNUM=''

IC/Items= Granite MasterItems

 SELECT [ITEMNO], STOCKUNIT, INACTIVE, [DESC], [STOCKITEM],
   [FMTITEMNO], [CATEGORY]
  FROM [ICITEM] where [STOCKITEM] = 1

OE/Orders= Granite Picking

select * from OEORDH where ORDNUMBER = 'ORD001'
select * from OEORDD where ORDUNIQ in (
select ORDUNIQ from OEORDH where ORDNUMBER = 'ORD000000001     ')

IC/History Transactions

SELECT    LOCATION, ITEMNO, TRANSDATE, [LINENO], CATEGORY, DOCNUM, QUANTITY, UNIT
FROM      dbo.ICHIST WITH (INDEX (ICHIST_KEY_0))

執行多個 Accpac 版本 在一臺機器上安裝多個 Accpac 版本，然後在版本之間切換。

安裝所需的 Accpac（在路徑示例中：Program...\Accpac60）
安裝第二個版本（在路徑示例中：Program...\Accpac62）
要切換到所需的版本，請導航到安裝 Program...\Accpac60\Sage Accpac\runtime\
開啟/執行 RegAcc.exe。
完成操作後，開啟 Accpac