PaXcel
What is PaXcel
Requirements
Installation
Installing PaXcel
Setting up Excel
Excel 2007
Registering PaXcel
PaXcel - functions
GL Functions
CatTitle()
CBBalance()
GLBalance()
GLBudget()
GLDetails()
GLFin()
GLFinBudget()
GLFinBudgetHist()
GLHistBal()
GLHistBud()
GLRep()
GLRepBudget()
GLRepBudgetHist()
General Functions
CompanyDetails()
GetExchName()
GetExchangeRate()
Customer Functions
SLDetail()
SLBalance()
SLSales()
SLCatBalance()
SLCatSales()
SLCatTitle()
SLAge()
SLAgeDoc()
SLItem()
Supplier Functions
PLCatTitle()
PLDetail()
PLBalance()
PLPurchases()
PLAge()
PLAgeDoc()
Inventory Functions
ICStore()
ICGrp()
ICItem()
ICOpening()
ICLastYear()
ICPurchase()
ICSale()
ICAdjust()
ICStock()
ICCost()
ICUnposted()
ICValue()
ICCatCost()
ICCatValue()
Sales Analysis
SADetail()
SABalance()
SAGPBalance()
SATarget()
SATargetPCT()
Job / Cost Code Functions
CCTrans()
GLJobCost()
GLJCDC()
GLJCDEF()
JCDetail()
Unposted Documents
UnpostCat()
UnpostCst()
UnpostItem()
UnpostGrp()
UnpostSle()
UnpostStr()
View Information
About/Registration
View Details
View Transactions
Retrieve Accounts
Missing Accounts
Select your Sage Pastel Data
Re-Calculate Worksheets
Remove static add-in location
Check Version
Select-n-Load
Import Journal
Select Import Region
Upload Budgets
Selection Region to Write
Load Inventory Pricing
Select Import Region