PaXcel - functions > Customer Functions

Functions used to return balances and information from customer accounts

SLDetail( Company, Account, FieldToReturn )

Will return master field for the given customer

SLBalance( Company, Account, Period, ReturnForeignBalance )

Will return the customer outstanding balance for the given period

SLSales( Company, Account, Period )

Will return the sales value for the given period and customer

SLCatBalance( Company, CustomerCategory, Period, ReturnForexValue )

Will return the outstanding balance for the customer category specified

SLCatSales( Company, CustomerCategory, Period )

Will return the sales for the given customer category

SLCatTitle( Company, CustomerCategory )

Will return the Category title for the specified customer category

SLAge( Company, Account, Period, AgeAsAtDate )

Will return the customer ageing for the specified period

SLItem( Company, Account, ItemCode, Store, Period )

Will return the customer sales by product code and store (if applicable) for a given period

SLAgeDoc( Company, Account, Period, AgeAsAtDate )

Will return the customer ageing for the specified period