<< Click to Display Table of Contents >> Navigation:  PaXcel  - functions > Supplier Functions

Functions used to return values details from Supplier accounts

 

PLDetail( Company, Account, FieldToReturn )

Will return master field for the given supplier

 

PLBalance( Company, Account, Period, ReturnForexValue )

Will return the outstanding balance for the given supplier

 

PLPurchases( Company, Account, Period )

Will return the purchase value for the given period

 

PLAge( Company, Account, Period, AgeAsAtDate )

Will return the ageing (for both Open Item and BFWD) period specified

 

PLAgeDoc( Company, Account, Period, AgeAsAtDate )

Will return the ageing (for both Open Item and BFWD) period specified

 

PLCatTitle( Company, Category )

Will return the name of the supplier category code