Stock Item Information Pro

The following functions compliments the functions we have seen above to provide additional useful reporting data.

All of the following requires the Pro version. see Prices

 

Get Stock Item Information

This will get the Stock Item Name

QuickBooks only.

All return various figures

Parameters:

Parameter	Description
CompCode	Short code assigned by Consolidated XL, or by you to identify your company.
ItemCode	Stock Item code Stock Item Name if you don't use Stock Item Codes

Get Stock Item Last Cost

The Last Cost is based on the Last Price paid on a purchase invoice, which may have been adjusted due to currency variances. Consolidated XL syncs 5 years' worth of history. Therefore Last Price and Profit for Stock items may not be populated in the first initial year of setup until a Purchase invoice has been posted.

Current Last Cost.

Current Last Cost at end of period.

Current Last Cost at specific Date.

Parameters:

Parameter	Description
CompCode	Short code assigned by Consolidated XL, or by you to identify your company.
ItemCode	Stock Item code Stock Item Name if you don't use Stock Item Codes
GetDate	Date to get LastCost at particular date
Year	0 gives current year, -1 Previous … 2023 gives specific Year
Period	0 Current Period 1-12 gives specific Turnover for Period Or week no if Option set to “W”
[Options]	Optional “” or beginning with “A” gives by Financial Accounting Period beginning with “AQ” Financial Accounting Period Quarter beginning with “CQ” Calendar Period Quarter beginning with “C” gives by Calendar Month beginning with “W” gives by Calendar Week (Week 1 starting first Monday in year) Currencies: GBP, USD, EUR etc will give all figures posted in that Currency toUSD, toEUR will convert all Home currencies to Currency toUSD202304, toEUR202304 will convert all Home currencies to Currency as of the end of Year/Month 2023 April Currency Rates are updated every night Combination of Options: The options can be combines "C,toUSD" would produce a report in USD in Calendar Periods

Get Stock Item Turnover

Stock Turnover figures are summarised on a Accrual basis. So any Sale or Purchase is shown, and may be revalued if curreny comes into play.

ToDo: Tutorial and Video Demo of this

Parameters:

Parameter	Description
CompCode	Short code assigned by Consolidated XL, or by you to identify your company.
ItemCode	Stock Item code Stock Item Name if you don't use Stock Item Codes
Year	0 gives current year, -1 Previous … 2023 gives specific Year
Period	0 Current Period 1-12 gives specific Turnover for Period 100 Total up to current Period 106 give periods 1-6 112 All 12 periods 126 weeks 1 to 26 if asked by weeks
[CostCentre]/[Department]	Optional - Filter by Cost Centre/Department AKA as Tracking codes in Xero and Classes/Locations in QuickBooks
[Options]	Optional “” or beginning with “A” gives by Financial Accounting Period beginning with “AQ” Financial Accounting Period Quarter beginning with “CQ” Calendar Period Quarter beginning with “C” gives by Calendar Month beginning with “W” gives by Calendar Week (Week 1 starting first Monday in year) Currencies: GBP, USD, EUR etc will give all figures posted in that Currency toUSD, toEUR will convert all Home currencies to Currency toUSD202304, toEUR202304 will convert all Home currencies to Currency as of the end of Year/Month 2023 April Currency Rates are updated every night Combination of Options: The options can be combines "C,toUSD" would produce a report in USD in Calendar Periods

Get Stock Item Turnover by Cost Centres

Consolidated XL powerful functions can also analyse the accounting data by Cost Centres and Departments in Sage Accounting, known as Tracking Codes in Xero, Class/Locations in QuickBooks.

We have called them Cost Centres and Departments for consistence across the different Accounting Software packages, and to use the same functions.

For Sage Accounting

For Xero

For QuickBooks

Get Stock Item Net Profit

The Net Profit is based on the Last Price paid on a purchase invoice, which may have been adjusted due to currency variances. Consolidated XL syncs 5 years' worth of history. Therefore Last Price and Profit for Stock items may not be populated in the first initial year of setup until a Purchase invoice has been posted.

Profit is calulated as Sales Price - Last Cost Price. Currency Variance is then accounted for when paid.

ToDo: Tutorial and Video Demo of this

Parameters:

Parameter	Description
CompCode	Short code assigned by Consolidated XL, or by you to identify your company.
ItemCode	Stock Item code Stock Item Name if you don't use Stock Item Codes
Year	0 gives current year, -1 Previous … 2023 gives specific Year
Period	0 Current Period 1-12 gives specific Turnover for Period 100 Total up to current Period 106 give periods 1-6 112 All 12 periods 126 weeks 1 to 26 if asked by weeks
[Options]	Optional “” or beginning with “A” gives by Financial Accounting Period beginning with “AQ” Financial Accounting Period Quarter beginning with “CQ” Calendar Period Quarter beginning with “C” gives by Calendar Month beginning with “W” gives by Calendar Week (Week 1 starting first Monday in year) Currencies: GBP, USD, EUR etc will give all figures posted in that Currency toUSD, toEUR will convert all Home currencies to Currency toUSD202304, toEUR202304 will convert all Home currencies to Currency as of the end of Year/Month 2023 April Currency Rates are updated every night Combination of Options: The options can be combines "C,toUSD" would produce a report in USD in Calendar Periods

Different Period Structure

The last parameter of the function allows us to switch to different period structures. "C" for Calendar months, instead of Accounting Period.